в 10:37, 26 мая 2010

2010-05-26T10:37:34Z

Admin: 1 версия

2010-05-26T07:06:20Z

1 версия

Новая страница

==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 "<p>Product successfully inserted!</p>";
else
echo "<p>There was a problem inserting the Employee!</p>";
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("<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>

</source>

← Предыдущая	Версия 10:37, 26 мая 2010
(нет различий)

PHP/MySQL Database/Database Insert - История изменений

в 10:37, 26 мая 2010

Admin: 1 версия