Invoice No Generating using Php Mysql

Posted on August 2, 2021

5 min read

2,218

This tutorial will teach you how to do auto generate Invoice No 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 = "minventory";
    $conn = mysqli_connect($servername,$username,$password,$dbname);
?>

<?php
$query = "SELECT invoiceid FROM sales ORDER BY invoiceid DESC";
$result = mysqli_query($conn,$query);
$row = mysqli_fetch_array($result);
$lastid = $row['invoiceid'];
if(empty($lastid))
{
    $number = "E-0000001";
}
else
{
    $idd = str_replace("E-", "", $lastid);
    $id = str_pad($idd + 1, 7, 0, STR_PAD_LEFT);
    $number = 'E-'.$id;
}
?>

<?php

if($_SERVER["REQUEST_METHOD"]== "POST")
{
    $invoiceid = $_POST['invoiceid'];
    $prodname = $_POST['prodname'];
    $price = $_POST['price'];

if(!$conn)
    {
        die("connection failed " . mysqli_connect_error());
    }
    else
    {
        $sql = "insert into sales(invoiceid,prodname,price)VALUES('".$invoiceid."','".$prodname."','".$price."') ";
        if(mysqli_query($conn,$sql))
        {
            $query = "SELECT invoiceid FROM sales ORDER BY invoiceid DESC";
            $result = mysqli_query($conn,$query);
            $row = mysqli_fetch_array($result);
            $lastid = $row['invoiceid'];

if(empty($lastid))
            {
                $number = "E-0000001";
            }
            else
            {
                $idd = str_replace("E-", "", $lastid);
                $id = str_pad($idd + 1, 7, 0, STR_PAD_LEFT);
                $number = 'E-'.$id;
            }

}
        else
        {
            echo "Record Faileddd";
        }
    }
}
    ?>
<html>

</head>
<body>
<div class="row">
    <div class="col-sm-4">
        <form action="<?php echo($_SERVER["PHP_SELF"]); ?>" method="post">
            <div align="left">
                <h3>invoice no generating </h3>
            </div>

<div align="left">
                <label>Invoice No</label>
                <input type="text" class="form-control" name="invoiceid" id="invoiceid" style=" font-size: 16px; color: blue; font-weight: bold; "  value="<?php echo $number; ?>" readonly >
            </div>

<div align="left">
                <label>Productname</label>
                <input type="text" class="form-control" name="prodname" id="prodname"  >
            </div>

<div align="left">
                <label>Price</label>
                <input type="number" class="form-control" name="price" id="price" >
            </div>

</br>

</div>

</body>

</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

<?php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "minventory";

$conn = mysqli_connect($servername,$username,$password,$dbname);

<?php

$query = "SELECT invoiceid FROM sales ORDER BY invoiceid DESC";

$result = mysqli_query($conn,$query);

$row = mysqli_fetch_array($result);

$lastid = $row['invoiceid'];

if(empty($lastid))

{

$number = "E-0000001";

}

else

{

$idd = str_replace("E-", "", $lastid);

$id = str_pad($idd + 1, 7, 0, STR_PAD_LEFT);

$number = 'E-'.$id;

}

<?php

if($_SERVER["REQUEST_METHOD"]== "POST")

{

$invoiceid = $_POST['invoiceid'];

$prodname = $_POST['prodname'];

$price = $_POST['price'];

if(!$conn)

{

die("connection failed " . mysqli_connect_error());

}

else

{

$sql = "insert into sales(invoiceid,prodname,price)VALUES('".$invoiceid."','".$prodname."','".$price."') ";

if(mysqli_query($conn,$sql))

{

$query = "SELECT invoiceid FROM sales ORDER BY invoiceid DESC";

$result = mysqli_query($conn,$query);

$row = mysqli_fetch_array($result);

$lastid = $row['invoiceid'];

if(empty($lastid))

{

$number = "E-0000001";

}

else

{

$idd = str_replace("E-", "", $lastid);

$id = str_pad($idd + 1, 7, 0, STR_PAD_LEFT);

$number = 'E-'.$id;

}

else

{

echo "Record Faileddd";

}

<html>

<head>

</head>

<body>

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

<h3>invoice no generating </h3>

</div>

<label>Invoice No</label>

<input type="text" class="form-control" name="invoiceid" id="invoiceid" style=" font-size: 16px; color: blue; font-weight: bold; " value="<?php echo $number; ?>" readonly >

</div>

<label>Productname</label>

</div>

<label>Price</label>

</div>

</br>

</div>

</form>

</div>

</body>

</html>

Invoice No Generating using Php Mysql

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

Auto Number Generate 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