在wordpress插件中将“mysql_fetch_array”更新为“$ wpdb-> get_results”

Question

I'm updating some old wordpress plugin files and understand I need to update "mysql_fetch_array" to "$wpdb->get_results" to get the plugin to talk with the database.

Here is the code where "mysql_fetch_array" is used:

//select ads id's  stored into db table
$sql  = "SELECT id FROM $table_name_ad_google";
$result = mysql_query($sql);

while($row = mysql_fetch_array($result))
{

How do I rewrite this to use $wpdb->get_results?

Answer 1

$sql = "SELECT * FROM tbl_employee WHERE 1=1";
$query = $wpdb->get_results($sql,ARRAY_A);
foreach($query as $row){
/*$row["your column name"];*/
}