Advertisement
lolxorlol

PostSnapshot.php

Dec 4th, 2018
233
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.83 KB | None | 0 0
  1. <?php
  2. if(isset($_POST['Item']) && isset($_POST['Number']) && isset($_POST['BatchId']))
  3. {  
  4.  
  5.     //Create a Database connection
  6.     $servername = "localhost";
  7.     $username = "SOMEUSERNAME";
  8.     $password = "SOMEPASSWORD";
  9.     $dbname = "SOMEDATABASENAME";
  10.     $tbl_name = "StockSnapshot";
  11.    
  12.     //Create connection
  13.     $con = mysqli_connect($servername,$username,$password) or die("Could not connect: " . mysqli_connect_error());
  14.  
  15.     //Creating request
  16.     $stmt = $con->prepare("INSERT INTO `$dbname`.`$tbl_name` (`BatchId`, `Item`, `Number`) VALUES (?, ?, ?);");
  17.     $stmt->bind_param('isi', $_POST['BatchId'], $_POST['Item'], $_POST['Number']);
  18.     $stmt->execute();
  19.     echo "New records created successfully";
  20.  
  21.     $stmt->close();
  22.     $con->close();
  23.  
  24. } else {
  25.         echo "is not set or is not post";
  26.         echo "item:".$_POST['Item']."number".$_POST['Number'];
  27. }
  28. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement