Use form to add data to database : Database Insert « MySQL Database « PHP

Use form to add data to database


if (isset($_POST['submit'])):
  $dbcnx = mysql_connect('', 'java2s', 'password');

  $name = $_POST['name'];
  $email = $_POST['email'];
  $sql = "INSERT INTO Employee SET FirstName='$name', EMail='$email' , ID = '3'";
  if (@mysql_query($sql)) {
    echo('<p>New employee added</p>');
  } else {
    echo('<p>Error adding new employee: ' . mysql_error() . '</p>');

<p><a href="<?=$_SERVER['PHP_SELF']?>">Add another Author</a></p>

  else: // Allow the user to enter a new author

<form action="<?=$_SERVER['PHP_SELF']?>" method="post">
<p>Enter the new employee:<br />
FirstName: <input type="text" name="name" size="20" maxlength="255"
  /><br />
Email: <input type="text" name="email" size="20" maxlength="255"
  /><br />
<input type="submit" name="submit" value="SUBMIT" /></p>

<?php endif; ?>


Related examples in the same category

1.Table data insert
2.Adding a Row to a Table