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 votes382 views2 answers
Oracle create table if not exists
SQL
11 votes323 views1 answer
Ddl materialized view
SQL
1 vote344 views1 answer
Sql first
SQL
0 vote331 views1 answer
Mysql query single row
SQL
0 vote345 views1 answer
TSQL convert csv to table
SQL
1 vote389 views2 answers
Install sql server management studio ubuntu
SQL
13 votes344 views2 answers
Sqlite rename table
SQL
0 vote335 views1 answer
Add column to table with default value plsql
SQL
4 votes343 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote326 views2 answers
Plsql function that return a table
SQL