PHP/MySQL Database/Database Insert — различия между версиями
Admin (обсуждение | вклад) м (1 версия) |
|
(нет различий)
|
Версия 13:37, 26 мая 2010
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!
";elseecho "
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>