We have already learnt form element in our HTML tutorial. Since we understand that HTML only shows you how your form look like, it can not store\/save your data for future reference. We can not edit or delete that data without storing anywhere. We all know that PHP enhances our website with its better connectivity to database. Here, we are using PHP with MySQL tool (phpmyadmin). For this, you just need web server (here we are using WAMP server). So let\u2019s start with simple example of student detail.<\/p>\n\n\n\n
We have created our database in phpmyadmin with database name \u201cdb_student<\/strong>\u201c. Table inside this database is \u201ctbl_stud_detail<\/strong>\u201c. All the fields are : stud_id integer(5) Primary Key Auto Increment<\/em>, stud_name varchar(50)<\/em>, stud_city varchar(50), stud_age integer (3)<\/em><\/p>\n\n\n\n After creating the table, now we are start creating HTML form from which we can insert data to tbl_stud_detail.<\/p>\n\n\n\n The following file is \u201cstud_insert.html<\/strong>\u201c<\/p>\n\n\n\n Now create \u201cstud_insert.php<\/strong>\u201d file to connect it with database<\/p>\n\n\n\n Now create \u201cstud_data.php<\/strong>\u201c. This page shows you the inserted records in a tabular format.<\/p>\n\n\n\n This is how you can insert any data from HTML form to your phpmyadmin database table & fetch them in your webpage as per your requirement in a tabular form.<\/p>\n\n\n\n Table of Contents<\/p>\n<form method=post action=\"stud_insert.php\">\n\tEnter Student Name :<input type=text name=t1><br>\n\tEnter Student City :<input type=text name=t2><br>\n\tEnter Student Age :<input type=number name=t3><br>\n\t<input type=submit name=s1><br>\n<\/form><\/code><\/pre>\n\n\n\n<?php\n\/\/Fetch all the values from HTML form elements \n$s_nm=$_POST['t1'];\n$s_city=$_POST['t2'];\n$s_age=$_POST['t3'];\n\n\/\/Connect with server & phpmyadmin database \n$conn=mysqli_connect(\"localhost\",\"root\",\"\");\n$db=mysqli_select_db($conn,\"db_student\");\n\n\/\/Insert query to insert record into table\n$insert_qry=\"INSERT INTO `tbl_stud_detail` \n\t(`stud_name`,`stud_city`,`stud_age`) \n\tVALUES \n\t('$s_nm','$s_city','$s_age')\";\n\n\/\/Execute\/Send the query to phpmyadmin\nmysqli_query($conn,$insert_qry);\n\n\n\/*After sending insert query this page redirects to stud_data.php where a tabular format of data is displayed *\/\nheader(\"location:stud_data.php\");<\/code><\/pre>\n\n\n\n<?php\n\n\/\/Connection & database selection\n$conn=mysqli_connect(\"localhost\",\"root\",\"\");\n$db=mysqli_select_db($conn,\"db_student\");\n\n\/\/Select required columns from table\n$select=\"select * from `tbl_stud_detail`\";\n$result=mysqli_query($conn,$select);\n\necho \"<table border=2>\n\t<tr>\n\t<th>Student Id<\/th>\n\t<th>Student Name<\/th>\n\t<th>City<\/th>\n\t<th>Age<\/th>\n\t<\/tr>\";\n\n\/\/This while loop executes till the record is in the resultset (result returned from SELECT query)\nwhile($r=mysqli_fetch_row($result))\n{\n echo \"<tr>\n\t\t<td>\".$r[0].\"<\/td>\n\t\t<td>\".$r[1].\"<\/td>\n\t\t<td>\".$r[2].\"<\/td>\n\t\t<td>\".$r[3].\"<\/td>\n\t<\/tr>\";\n}\n\necho \"<\/table>\";\necho \"<br><a href='stud_insert.html'>Add another record<\/a>\";\n?><\/code><\/pre>\n\n\n\n