Auto Number Generate Using Php Mysql

Posted on August 2, 2021

4 min read

3,273

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>

<?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>

</head>

<body>

<form action="<?php echo ($_SERVER["PHP_SELF"]);?>" method="post">

<h3>Autono Generating in php</h3>

</div>

<label>Employee No</label>

<input type="text" class="form-control" name="id" id="id" style="color: red" value="<?php echo $customer_ID; ?>" readonly>

</div>

<label>Employee Name</label>

</div>

<label>Employee Salary</label>

</div>

</br>

</div>

</form>

</div>

</body>

</html>

Auto Number Generate Using Php Mysql

i have attached the video link below. which will do this tutorials step by step.

Invoice No Generating using Php Mysql

Node js React Mongodb Search Functionality

Node js Angular Mongodb Search Functionality

How to Search Records Node js Express Mongodb

PHP MYSQL CRUD Application || Create,Read,Update,Delete

MilkBar Inventory Management using Php

Registration System using Php Mysql

Leave a Reply Cancel reply

Check Also

Node js React Mongodb Search Functionality

Recent Posts