Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if(isset($_POST['Type']) && $_POST['Type']=="New")
- {
- //Create a Database connection
- $servername = "localhost";
- $username = "SOMEUSER";
- $password = "SOMEPASSWORD";
- $dbname = "SOMEDATABASENAME";
- $tbl_name = "Batch";
- //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` () VALUES ();");
- $stmt->execute();
- $result = mysqli_query($con, "SELECT MAX(Id) AS Id FROM `$dbname`.`$tbl_name`;");
- $row = mysqli_fetch_array($result);
- echo $row['Id'];
- $stmt->close();
- $con->close();
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement