Advertisement
lolxorlol

NewBatch

Dec 4th, 2018
273
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.67 KB | None | 0 0
  1. <?php
  2. if(isset($_POST['Type']) && $_POST['Type']=="New")
  3. {
  4.     //Create a Database connection
  5.     $servername = "localhost";
  6.     $username = "SOMEUSER";
  7.     $password = "SOMEPASSWORD";
  8.     $dbname = "SOMEDATABASENAME";
  9.     $tbl_name = "Batch";
  10.    
  11.     //Create connection
  12.     $con = mysqli_connect($servername,$username,$password) or die("Could not connect: " . mysqli_connect_error());
  13.  
  14.     //Creating request
  15.     $stmt = $con->prepare("INSERT INTO `$dbname`.`$tbl_name` () VALUES ();");
  16.     $stmt->execute();
  17.     $result = mysqli_query($con, "SELECT MAX(Id) AS Id FROM `$dbname`.`$tbl_name`;");
  18.     $row = mysqli_fetch_array($result);
  19.     echo $row['Id'];     
  20.  
  21.     $stmt->close();
  22.     $con->close();
  23. }
  24. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement