This tutorial will teach you how to generate auto number using Php Mysql step by step.
i attached full source code below.i explained more clearly in the video tutorial attached below.
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "emppp";
$conn = mysqli_connect($servername, $username, $password, $dbname);
?>
<?php
$query2 = "select * from student order by id desc limit 1";
$result2 = mysqli_query($conn,$query2);
$row = mysqli_fetch_array($result2);
$last_id = $row['id'];
if ($last_id == "")
{
$customer_ID = "CUS1";
}
else
{
$customer_ID = substr($last_id, 3);
$customer_ID = intval($customer_ID);
$customer_ID = "CUS" . ($customer_ID + 1);
}
?>
<?php
$conn = mysqli_connect($servername, $username, $password, $dbname);
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$id = $_POST["id"];
$stname = $_POST["stname"];
$course = $_POST["course"];
if (!$conn)
{
die("Connection failed: " . mysqli_connect_error());
}
$sql = "INSERT INTO student (id,stname,course )VALUES ('$id','$stname','$course')";
if (mysqli_query($conn, $sql)) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
mysqli_close($conn);
}
?>
<html>
<head>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
</head>
<body>
<div class="container">
<div class="row">
<div class="col-sm-4">
<form action="<?php echo ($_SERVER["PHP_SELF"]);?>" method="post">
<div align="left">
<h3>Autono Generating in php</h3>
</div>
<div align="left">
<label>Employee No</label>
<input type="text" class="form-control" name="id" id="id" style="color: red" value="<?php echo $customer_ID; ?>" readonly>
</div>
<div align="left">
<label>Employee Name</label>
<input type="text" class="form-control" name="stname" id="stname">
</div>
<div align="left">
<label>Employee Salary</label>
<input type="text" class="form-control" name="course" id="course">
</div>
</br>
<div align="left">
<input type="submit" value="ADD">
</div>
</form>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script></div>
</div>
</div>
</body>
</html>
Have you ever wanted to talk to a friendly, smart robot that helps you with…
DeepSeek AI is becoming a friendly and powerful new tool in the world of artificial…
Do you want to become an expert in Spring Boot CRUD operations? This comprehensive tutorial…
Modern websites must have a navigation bar that is clear and responsive. FlexBox CSS is…
Introduction In this section, we will guide you step by step in the development of an image upload registration system in Java using MySQL and JDBC. In the application, users register…
The Touchable Shop POS (Point of Sale) system is a sophisticated software solution developed using…