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 votes132 views1 answer
Sql float to int
SQL
10 votes187 views4 answers
SELECT FROM WHERE
SQL
5 votes186 views1 answer
Get table columns from sql
SQL
0 vote163 views1 answer
Sql select duplicates based on two columns
SQL
0 vote167 views1 answer
Run mssql server terminal
SQL
7 votes176 views3 answers
Foreign key oracle
SQL
0 vote205 views1 answer
Pagination with row_number
SQL
0 vote188 views1 answer
Time data type in mysql
SQL
1 vote203 views1 answer
Postgresql append array
SQL
3 votes173 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL