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 vote104 views1 answer
Ms sql - add one hour to time
SQL
-1 vote141 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote141 views1 answer
Oracle sql generate list of days
SQL
2 votes151 views1 answer
Sql server check for value in multiple columns
SQL
-1 vote143 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote114 views1 answer
How to check oracle index table
SQL
1 vote109 views1 answer
Import in mysql without a software
SQL
1 vote137 views1 answer
Drop table if exists oracle
SQL
0 vote140 views2 answers
Update all linkedserver tables with openquery on db
SQL
24 votes145 views4 answers
Postgres delete database
SQL