Wp do sql query from function

<?php
// 1st Method - Declaring $wpdb as global and using it to execute an SQL query statement that returns a PHP object
global $wpdb;
$results = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}options WHERE option_id = 1", OBJECT );

Source: developer.wordpress.org

Wp do sql query from function

<?php
// 2nd Method - Utilizing the $GLOBALS superglobal. Does not require global keyword ( but may not be best practice )
$results = $GLOBALS['wpdb']->get_results( "SELECT * FROM {$wpdb->prefix}options WHERE option_id = 1", OBJECT );

Source: developer.wordpress.org

Similar codes

1 vote223 views1 answer
Drush sql-dump
SQL
18 votes210 views2 answers
Sql inner join
SQL
0 vote242 views1 answer
Check if mysql db is used
SQL
0 vote229 views1 answer
Oracle swap partition
SQL
0 vote269 views1 answer
How to add auto increment primary key
SQL
2 votes226 views5 answers
SQL trigger
SQL
1 vote240 views3 answers
How to create a table structure from another table in mysql
SQL
1 vote234 views1 answer
Mysql workbench in ubuntu 14.04
SQL
1 vote248 views5 answers
Postgresql difference between two dates in days
SQL
1 vote220 views1 answer
"i_am_a_dummy flag" in MySQL
SQL