PHP/MySQL Database/Database Insert

Материал из Web эксперт
Перейти к: навигация, поиск

Table data insert

<?php
   mysql_connect("mysql153.secureserver.net","wbex","password");
   mysql_select_db("wbex");
      $id = "12";
      $name = "Joe";
      $query = "INSERT INTO Employee SET id="$id", name="$name"";
      $result = mysql_query($query);
      // Display an appropriate message
      if ($result) 
         echo "<p>Product successfully inserted!</p>";
      else 
         echo "<p>There was a problem inserting the Employee!</p>";
      mysql_close();
?>



Use form to add data to database

<html>
<body>
<?php
if (isset($_POST["submit"])):
  $dbcnx = mysql_connect("mysql153.secureserver.net", "wbex", "password");
  mysql_select_db("wbex");
  $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>
<?php
  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>
</form>
<?php endif; ?>
</body>
</html>
Источник — «http://wbex.ru/index.php?title=PHP/MySQL_Database/Database_Insert&oldid=1101»