get_results("select * from ".$wpdb->prefix."reg_form WHERE 1= 1 order by id DESC ", OBJECT);
return count($res);
}
function aparnf_get_status($id)
{ global $wpdb;
$result = $wpdb->get_results("select list_status from ".$wpdb->prefix."reg_form WHERE id = '$id' ", OBJECT);
foreach( $result as $entry ) {
$list_order = $entry->list_status;
}
return $list_order;
}
/* --------- Custom Function ends here ------------ */
if($mode=='delete')
{
$wpdb->query("delete from ".$wpdb->prefix."reg_form where id=$_REQUEST[pid]");
}
if($mode=='changeStatus')
{
$result = $wpdb->get_results("select list_status from ".$wpdb->prefix."reg_form WHERE id = $_REQUEST[pid]", OBJECT);
foreach( $result as $entry ) {
if($entry->list_status == '1')
{ $status_change_to = '0';
$status_change_message = 'Row successfully unpublished.';
}
else{
$status_change_to = '1';
$status_change_message = 'Row successfully published.';
}
$wpdb->update($wpdb->prefix.'reg_form',array('list_status'=>$status_change_to),array('id'=>$_REQUEST['pid']));
}
}
$result = $wpdb->get_results("SELECT `page_title`,`page_url` ,COUNT(*) as total from ".$wpdb->prefix."reg_form GROUP BY page_url order by count(*) DESC");
?>
Registration Summary
Banner successfully added.';} ?>
Banner successfully updated.';} ?>
'.$status_change_message.'';} ?>