Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <head>
- <title>Add New Record in MySQL Database</title>
- </head>
- <body>
- <?php
- if(isset($_POST['add'])) {
- $dbhost = 'localhost:3036';
- $dbuser = 'root';
- $dbpass = 'rootpassword';
- $conn = mysql_connect($dbhost, $dbuser, $dbpass);
- if(! $conn ) {
- die('Could not connect: ' . mysql_error());
- }
- if(! get_magic_quotes_gpc() ) {
- $emp_name = addslashes ($_POST['emp_name']);
- $emp_address = addslashes ($_POST['emp_address']);
- }else {
- $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())";
- mysql_select_db('test_db');
- $retval = mysql_query( $sql, $conn );
- if(! $retval ) {
- die('Could not enter data: ' . mysql_error());
- }
- echo "Entered data successfully\n";
- mysql_close($conn);
- }else {
- ?>
- <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>
- <?php
- }
- ?>
- </body>
- </html>
Add Comment
Please, Sign In to add comment