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 vote188 views1 answer
Create new table in SQL from old table with data
SQL
2 votes192 views1 answer
Drop sequence
SQL
5 votes190 views1 answer
Get column name sql server
SQL
1 vote198 views1 answer
Where not in array sql
SQL
0 vote175 views1 answer
Raven ql select count
SQL
1 vote197 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote149 views2 answers
Delete the last item in a table sql
SQL
0 vote188 views1 answer
Varchar2 length in oracle
SQL
0 vote181 views1 answer
Oracle DROP PROGRAM
SQL
0 vote187 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL