Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if(isset($_POST['Item']) && isset($_POST['Number']) && isset($_POST['BatchId']))
- {
- //Create a Database connection
- $servername = "localhost";
- $username = "SOMEUSERNAME";
- $password = "SOMEPASSWORD";
- $dbname = "SOMEDATABASENAME";
- $tbl_name = "StockSnapshot";
- //Create connection
- $con = mysqli_connect($servername,$username,$password) or die("Could not connect: " . mysqli_connect_error());
- //Creating request
- $stmt = $con->prepare("INSERT INTO `$dbname`.`$tbl_name` (`BatchId`, `Item`, `Number`) VALUES (?, ?, ?);");
- $stmt->bind_param('isi', $_POST['BatchId'], $_POST['Item'], $_POST['Number']);
- $stmt->execute();
- echo "New records created successfully";
- $stmt->close();
- $con->close();
- } else {
- echo "is not set or is not post";
- echo "item:".$_POST['Item']."number".$_POST['Number'];
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement