$limit=10; if($_POST['page']){ $page=$_POST['page']; }else{ $page=1; } $pages=$page-1; if($_POST['action']=='delete'){ mysql_query("delete from payments where id='".$_POST['id']."'")or die(mysql_error()); } $res=mysql_query("select * from payments"); $count=mysql_num_rows($res); $pagination=smart_pagination($_POST['page'],$count,$limit,'da') ?> <table width='100%' cellspacing='0' cellpadding='0'> <tr style='background:#5c8c00; color:#fff;'> <td class='tdhead' width='20'>ID</td> <td class='tdhead' width='320'>From</td> <td class='tdhead'>Amount</td> <td class='tdhead' width='100'>Invoice No.</td> <td class='tdhead' width='180'>Payment Method</td> <td class='tdhead' width='100'>Date</td> <td class='tdhead' width='60'>Actions</td> </tr> <? $i=1; $res=mysql_query("select * from payments order by id desc LIMIT " . ($pages*$limit) . "," . $limit)or die(mysql_error());
if(isset($_POST['addpay'])){ if($_POST['value']!=''){ mysql_query("insert into payments(`from`,`amount`,`invoice`,`pmethod`,`date`) values('".$_POST['from']."','".$_POST['value']."','".$_POST['id']."','".$_POST['pmethod']."','".time()."')")or die(mysql_error()); } } if(isset($_GET['delete'])){ mysql_query("delete from invoices where id='".$_GET['delete']."'")or die(mysql_error()); mysql_query("delete from products where invoice='".$_GET['delete']."'")or die(mysql_error()); mysql_query("delete from payments where invoice='".$_GET['delete']."'")or die(mysql_error()); } $res = mysql_query("select * from invoices"); $count = mysql_num_rows($res); $pagination = smart_pagination(1,$count,10,'da') ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <title>Invoice List | Pro Invoice Maker</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <script language="javascript" type="text/javascript" src="js/jquery.js"></script> <script language="javascript" type="text/javascript" src="js/jquery.boxshadow.js"></script> <script language="javascript" type="text/javascript" src="js/script.js"></script> <link rel="stylesheet" media="screen" href="style/style.css" /> </head> <body> <div id='container'> <?include "inc/header.php"?> <div class='title'>View All Invoices</div>