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

0 vote362 views1 answer
Mysql date without time
SQL
3 votes348 views3 answers
Update join
SQL
1 vote336 views1 answer
Loading local data is disabled mysql
SQL
9 votes323 views4 answers
Mysql show table fields
SQL
3 votes354 views3 answers
Order by postgres
SQL
12 votes347 views1 answer
Psql drop column
SQL
1 vote367 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
0 vote337 views1 answer
Knex last insert id mysql
SQL
1 vote336 views1 answer
Convert rows to string sql server
SQL
10 votes349 views2 answers
Linux command line import mysql database
SQL