prefix}aistore_notification WHERE user_id='$user_id' order by id desc";
$v1= $wpdb->get_results($sql );
foreach ($v1 as $row):
?>
get_row( "SELECT * FROM {$wpdb->prefix}aistore_notification WHERE user_id = '". $user_id."' order by id desc limit 1" );
if(isset($notification->type))
return ' ';
else
return "";
}
function aistore_notification($notification,$type="success",$user_login="" ){
if($user_login=="")
{
$user_id=get_current_user_id();
}
global $wpdb;
$q1=$wpdb->prepare("INSERT INTO {$wpdb->prefix}aistore_notification ( message,type, user_id ) VALUES ( %s, %s, %d ) ", array( $notification,$type, $user_id));
$wpdb->query($q1);
}
function aistore_notification_new($n ){
global $wpdb;
$q1= ( $wpdb->prepare( "INSERT INTO {$wpdb->prefix}aistore_notification ( user_login, message,type,user_id,url ) VALUES ( %s, %s, %s ,%d ,%s)", array( $n['user_login'], $n['message'], $n['type'] ,$n['user_id'] ,$n['url']) ) );
$wpdb->query($q1);
}
?>