PHP/MySQL Database/Database Insert

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

Table data insert

   <source lang="html4strict">

<?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 "

Product successfully inserted!

";
     else 
echo "

There was a problem inserting the Employee!

";
     mysql_close();

?>


      </source>
   
  


Use form to add data to database

   <source lang="html4strict">

<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("

New employee added

");
 } else {
echo("

Error adding new employee: " . mysql_error() . "

");
 }

?>

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

<?php

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

?> <form action="<?=$_SERVER["PHP_SELF"]?>" method="post">

Enter the new employee:
FirstName: <input type="text" name="name" size="20" maxlength="255" />
Email: <input type="text" name="email" size="20" maxlength="255" />
<input type="submit" name="submit" value="SUBMIT" />

</form> <?php endif; ?> </body> </html>

      </source>