select("select id from newsletter where id=".$_GET['d']); $row = $db->get_row($r, 'MYSQL_BOTH'); $db->delete("delete from newsletter where id=".$row['0']); //$db->print_last_query(); print ""; exit(); } if(!empty($_POST['deleted_pdts'])) { $r = $db->select("select id from newsletter where id IN(".$_POST['deleted_pdts'].")"); while($row = $db->get_row($r, 'MYSQL_BOTH')) { $db->delete("delete from newsletter where id=".$row['0']); } //$db->print_last_query(); print ""; exit(); } ?>
Latest Registered Usersnewsletter
Export Emails
select_one("Select count(*) from newsletter"); $totalNum = $numOfRows; $page = isset($_GET['page']) ? $_GET['page'] : 1; $perPage = 15; $url = $_SERVER['PHP_SELF']; $length = 10; $class = 'pagination'; $g=($_GET['page']-1)*15; $def=$g.",15"; if(isset($_GET['sort']))$sort=$_GET['sort'];else $sort="id"; $limit= isset($_GET['page']) ? $def : '0,15'; //$limit =(!empty($_GET['pagination'])) ? $_GET['pagination'] : '0,50'; $res=$db->select("select * from newsletter order by $sort desc LIMIT $limit"); $numOfRows = $db->select_one("Select count(*) from newsletter"); //$db->print_last_query(); while($row=$db->get_row($res,'MYSQL_BOTH')) { $p=$row['0']; ?>
Full Name Email Actions