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 vote135 views2 answers
Postgres having
SQL
-1 vote124 views1 answer
Io
SQL
0 vote92 views1 answer
Big query add table rows to another table
SQL
0 vote87 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote186 views1 answer
Setting default value for Boolean data type in SQL
SQL
2 votes134 views1 answer
Add default sql server
SQL
8 votes130 views3 answers
Connect python to mysql
SQL
0 vote160 views1 answer
Eliminate zero from integer mysql
SQL
0 vote134 views1 answer
Grant access on table in oracle
SQL
1 vote126 views1 answer
Sql eliminare un record
SQL