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

3 votes146 views1 answer
What is having
SQL
0 vote118 views1 answer
Postgres declare variable
SQL
0 vote122 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote132 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote115 views1 answer
MySql Modify Increment
SQL
1 vote120 views1 answer
Md5 encryption for existing records
SQL
4 votes123 views3 answers
Count with where
SQL
0 vote120 views1 answer
Database traccar
SQL
0 vote131 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
1 vote137 views1 answer
Mysql not supported auth mode
SQL