neworder( if(isset($_POST['submit'])) { $po = trim($_POST['po']); $no = trim($_POST['no']); $market = trim($_POST['market']); $lga = trim($_POST['lga']); $shopno = trim($_POST['shopno']); $enno = trim($_POST['enno']); $fdate = trim($_POST['fdate']); $pdate = date("Y-m-d") ; //$pdate = trim($_POST['pdate']); $change = $DBcon->prepare("insert into changeo(fowner,nowner,market,lga,fdate,enno,shopno,pdate,admin) values(:a,:b,:c,:d,:e,:f,:g,:h,:i)") ; $change->bindparam(":a",$po) ; $change->bindparam(":b",$no) ; $change->bindparam(":c",$market) ; $change->bindparam(":d",$lga) ; $change->bindparam(":e",$fdate) ; $change->bindparam(":f",$enno) ; $change->bindparam(":g",$shopno) ; $change->bindparam(":h",$pdate) ; $change->bindparam(":i",$admin) ; if($change->execute()) { //$last_id = $conn->lastInsertId(); $last_id = $DBcon->lastInsertId(); header("location: pchange.php?reg=$last_id") ; } } ?>