<?php $con=mysqli_connect("db4free.net","thesis","tribiana7584913","library"); $date = $_POST["date"]; $accession = $_POST["accession"]; $statement = mysqli_prepare($con, "SELECT Acces_no FROM book_tbl where Acces_no= ? "); mysqli_stmt_bind_param($statement, "s", $accession); mysqli_stmt_execute($statement); mysqli_stmt_store_result($statement); mysqli_stmt_bind_result($statement,$accession); if(mysqli_stmt_fetch($statement)){ $Inventory= $accession; echo json_encode($Inventory); } if($rs = $statement){ $statement = mysqli_prepare($con, "INSERT INTO inventory_tbl (inv_date,Acces_no) VALUES (?,?)"); mysqli_stmt_bind_param($statement, "ss",$date,$accession); mysqli_stmt_execute($statement); mysqli_stmt_close($statement); mysqli_close($con); } ?>
You have javascript disabled. You will not be able to edit any code.