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 vote350 views1 answer
No suitable driver found for sqlite
SQL
0 vote379 views1 answer
Mysql case when on date
SQL
0 vote414 views1 answer
Sql cursor example multiple columns
SQL
0 vote364 views1 answer
Alter rename command in mysql
SQL
2 votes346 views1 answer
Sql skip the first row
SQL
4 votes353 views1 answer
Add constraint fk
SQL
1 vote375 views1 answer
Mysql curdate between two dates
SQL
1 vote303 views1 answer
Postgres grant read only access to database
SQL
6 votes403 views2 answers
How to get last element sql
SQL
1 vote354 views1 answer
Postgres set column equal to another
SQL