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

2 votes261 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
4 votes255 views2 answers
Oracle set date format
SQL
16 votes279 views1 answer
Mssql int max value
SQL
1 vote290 views1 answer
Replace all numbers in mysql
SQL
0 vote265 views1 answer
Mysql auto increment default value with prefix month and year
SQL
11 votes288 views2 answers
Insert current date sql
SQL
0 vote240 views1 answer
Oracle list all stored procedures
SQL
1 vote282 views1 answer
Launch sql script from docker in mysql
SQL
6 votes271 views1 answer
Oracle desc table primary key
SQL
1 vote294 views1 answer
Oracle compile schema
SQL