Data can be entered into MySQL tables by executing SQL INSERT statement using PHP function mysql_query. Here We Explain simle example to insert a record into employee table.
<html> <head> <title>Add New Record in MySQL Database Using PHP</title> </head> <body> <?php if(isset($_POST['add'])) { $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = ''; $dbname = 'Database Name'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die(mysql_error()); mysql_select_db($dbname ) or die(mysql_error()); $emp_name = $_POST['emp_name']; $emp_address = $_POST['emp_address']; $emp_salary = $_POST['emp_salary']; $sql = "INSERT INTO employee (emp_name, emp_address, emp_salary, join_date) VALUES('$emp_name', '$emp_address', $emp_salary, NOW())"; $retval = mysql_query( $sql) or die(mysql_error()); echo "data successfully Inserted \n"; mysql_close($conn); } ?> <form method="post" action="<?php $_PHP_SELF ?>"> <table width="400" border="0" cellspacing="1" cellpadding="2"> <tr> <td width="100">Employee Name</td> <td><input name="emp_name" type="text" id="emp_name"></td> </tr> <tr> <td width="100">Employee Address</td> <td><input name="emp_address" type="text" id="emp_address"></td> </tr> <tr> <td width="100">Employee Salary</td> <td><input name="emp_salary" type="text" id="emp_salary"></td> </tr> <tr> <td width="100"> </td> <td> </td> </tr> <tr> <td width="100"> </td> <td> <input name="add" type="submit" id="add" value="Add Employee"> </td> </tr> </table> </form> </body> </html>
My name is Mukesh Jakhar and I am a Web Application Developer and Software Developer, currently living in Jaipur, India. I have a Master of Computer Application in Computer Science from JNU Jaipur University. I loves to write on technology and programming topics. Apart from this, I love to travel and enjoy the beauty of nature.