I have a problem. This code is well in php. I am trying make that WordPress environment code. What is problem on my code? I cant understand.
Thanks
PHP Code:
$final_array = array();
$sql="select hotel FROM hotels";
$result=$mysqli->query($sql);
while ($myrow = $result->fetch_array(MYSQLI_ASSOC)){
foreach($api_array as &$value){
if($myrow['hotel'] == $value['property_name']){
$final_array[] = $value;
}
}
}
echo "<pre/>";print_r($final_array);
WordPress:
foreach($array as $api_array){
$final_array = array();
$sql = $wpdb->get_results( "select hotel FROM hotels" );
//$result=$mysqli->query($sql);
while ($myrow = $sql(MYSQLI_ASSOC)){
foreach($api_array as &$value){
if($myrow['hotel'] == $value['property_name']){
$final_array[] = $value;
}
}
}
Read more here: Need wordpress environment code