自动增加员工ID

I just want to add an employee and after that, the employee ID will also increment. Also that textbox must be disabled

Also here's my code. All I want is to auto increment my employee ID when I add a new employee. I hope everyone will help me. Thank you in advance. :)

<center>
    <form class="contact_form" action="#" method="post">
            <h2>Register New Employee</h2>
            <br/>
            <table>
                <tr>
            <td><label for="emp">Emp ID:</label></td>
            <td><input type="text" name="emp" placeholder="Emp ID" required /></td>
        </tr>
                <tr>
            <td><label for="name">Name:</label></td>
            <td><input type="text" name="fname" placeholder="First Name" required />
                    <input type="text" name="lname" placeholder="Last Name" required /></td>
        </tr>
        <tr>
            <td><label for="address">Address:</label></td>
            <td><input type="text" name="address" placeholder="Full Address" required /></td>
        </tr>
        <tr>
            <td><label for="contact">Contact:</label></td>
            <td><input type="text" name="contact" placeholder="Contact Number" required /></td>
        </tr>
                <tr>
                    <td><label for="type">Type:</label></td>
                    <td><select name="type" id="type">
                        <option>Type of Employee</option>
                        <option>Contractual</option>
                        <option>Regular</option>
                    </select>
                    </td>
                </tr>
                <tr>
            <td><label for="salary">Salary:</label></td>
            <td><input type="text" name="salary" placeholder="Emp Salary" required /></td>
        </tr>
        </table>
            <br/>
            <button class="submit" name="submit" type="submit" onclick="message()">Submit</button>
            <button class="reset" name="reset" type="reset">Clear</button>
        </form>
        <?php
        if (isset($_POST['submit'])) {
            include 'alqdb.php';
                $emp=$_POST['emp'];
                $fname= $_POST['fname'];
                $lname=$_POST['lname'];
                $address=$_POST['address'];
                $contact=$_POST['contact'];
                $type=$_POST['type'];
                $salary=$_POST['salary'];
            mysqli_query($con, "INSERT INTO employee (EmpID,EmpFName,EmpLName,EmpAddress,ContactNumber,TypeofEmployee,Salary)
            VALUES ('$emp','$fname','$lname','$address','$contact','$type','$salary')");
        }
        ?>
    </center>
</body>
<script language="javascript">
    function message() {
        alert("Successfully added!");
    }
</script>

If you want to have an EmpID like EMP001

this code will work:

public function autoincemp()
{
    global $value2;
    $query = "SELECT empid from tbemployee order by empid desc LIMIT 1";
    $stmt = $this->db->prepare($query);
    $stmt->execute();

    if ($stmt->rowCount() > 0) {
        $row = $stmt->fetch(PDO::FETCH_ASSOC);
        $value2 = $row['empid'];
        $value2 = substr($value2, 3, 5);
        $value2 = (int) $value2 + 1;
        $value2 = "EMP" . sprintf('%04s', $value2);
        $value = $value2;
        return $value;
    } else {
        $value2 = "EMP0001";
        $value = $value2;
        return $value;
    }
}

Place AUTO_INCREMENT attribute to emp_id column in your DB. Remove that EMP ID field from your UI.

The AUTO_INCREMENT attribute can be used to generate a unique identity for new rows. Means, AUTO_INCREMENT automatically insert new incremented id for that field on each INSERT query

Reference

You could modify your database to include AUTO_INCREMENT in EmpID.

You can disable input by doing <input type="text" name="emp" placeholder="Emp ID" required disabled />

You can hide Emp ID code and change input type="text" to input type="hidden" and remove required in your form. Now just use AUTO_INCREMENT for EmpId in your table.

It's late but you can do this,

$id = 1; //Your last record Id + 1
str_pad($id, 3, "0", STR_PAD_LEFT);

Hope this helps someone.

Reference