How to reset Auto Increment back to 1 in XAMPP MySQL using phpMyAdmin

Once the system is up and running and you have done so many tests for your database entry the entries just kept on accumulating even when you deleted every records from the table, that has an AUTO Increment ID field, the delete option will not reset the Auto Increment.  There are two methods to reset the numbering: Method …

Protected: Online Computer Shop Management System

There is no excerpt because this is a protected post.

Protected: Program flowchart

There is no excerpt because this is a protected post.

Protected: Creating a Blog System with PHP & MySQL

There is no excerpt because this is a protected post.

Computer Shop Management System

Download the project Extract the project folder in your server folder  xampp►htdocs. Open project folder and then open database folder where you will see computer_shop_management.sql file open your phpmyadmin (localhost:82/phpmyadmin) create a database with name computer_shop_management select your database click on import file and then select computer_shop_management.sql  file then click on go  run the index file …

Basic PHP – Database update

To make the Update|Delete button functional: create a new php file and save it as edit.php and save in the folder where the index.php and connections.php is located. <?php include("connections.php"); $user_id = $_GET["user_id"]; //method get //variable =query then get the $connections variable $get_record = mysqli_query($connections, "SELECT * FROM user WHERE user_id ='$user_id'"); //will check if …

Basic PHP – adding new field option for updating entry

how to make a new field for editing or updating of the entry. OPTION FIELD. OUTPUT to add choices under the option field, we have Update and Delete OUTPUT: some adjustment: To make all fields loop, insert a pipe key symbol '|' (vertical bar) between the Update and Delete links,   adjust the border from …

Basic PHP – validation of string user inputs

To validate string user inputs: validation rules for the form above are as follows:   Field - Validation Rules First Name - 'Your First Name is too short.' if : ($check_first_name <2) Middle Name - 'Your Middle Name is too short.'if :$check_middle_name <2 Last Name - Your Last Name is too short.' if : $check_last_name <2 Email - Invalid …

Basic PHP – to display the contents of the form

At this post we will display the values of the input fields that was retained using a simple echo statement. if($first_name && $middle_name && $last_name && $gender && $email) //if there is a value (true) echo "$first_name <Br> $middle_name <Br> $last_name <Br> $gender <Br> $email";   The && Operator The && symbols mean AND. Use this if …

Basic PHP – how to keep the values in the form

To show the values in the input fields after the user hits the register button, we add a little PHP script inside the value attribute of the following input fields: first name, middle name, last name and email. The little script outputs the value of the $first_name, $middle_name, $last_name and $email for the gender , …