update_sql ( "update media_news set isshow=" . $_GET ['show'] . " where id=" . $_GET ['id'] ); //$db->print_last_query(); print ""; exit (); } if (isset ( $_GET ['d'] )) { $r = $db->select ( "select id,image from media_news where id=" . $_GET ['d'] ); $row = $db->get_row ( $r, 'MYSQL_BOTH' ); if ($row [1] != "") unlink ( "images/" . $row ['1'] ); $db->delete ( "delete from media_news where id=" . $row ['0'] ); //$db->print_last_query(); print ""; exit (); } if (! empty ( $_POST ['deleted_pdts'] )) { $r = $db->select ( "select id,image from media_news where id IN(" . $_POST ['deleted_pdts'] . ")" ); while ( $row = $db->get_row ( $r, 'MYSQL_BOTH' ) ) { if ($row [1] != "") unlink ( "images/" . $row ['1'] ); $db->delete ( "delete from media_news where id=" . $row ['0'] ); } //$db->print_last_query(); print ""; exit (); } ?>
Latest Registered Users Our media news
select ( "select * from media_news order by id desc LIMIT $limit" ); $numOfRows = $db->select_one ( "Select count(*) from media_news" ); //$db->print_last_query(); while ( $row = $db->get_row ( $res, 'MYSQL_BOTH' ) ) { $p = $row ['0']; ?>
Title Image Date Added Link Actions
"; else echo ""; ?>
Add new row Delete all