Forum Moderators: coopster
<?php
}
php?>
</HTML>
$sql = INSERT INTO personnel (firstname, lastname, nick, email, salary) VALUES ('$first', '$last', '$nick', '$email', '$salary')
should be :
$sql = "INSERT INTO personnel (firstname, lastname, nick, email, salary) VALUES ('$first', '$last', '$nick', '$email', '$salary')";
-sned
$db = mysql_connect ("localhost", "root, "");
you're missing a "
$db = mysql_connect ("localhost", "root", "");
i observed that and corrected it with a " and there is still an error apparently...
should be
?>
<html>
<?
if ($submit) {
$db = mysql_connect ("localhost", "username", "password");
mysql_select_db ("learndb", $db);
$sql = "INSERT INTO personnel (firstname, lastname, nick, email, salary) VALUES ('$first', '$last', '$nick', '$email', '$salary')";
$result = mysql_query($sql);
if (!$result) {
die('Query failed: ' . mysql_error());
} else {
echo "Thank you! Information entered.\n";
}
}
?>
<form method="post" action="input.php">
First name:<input type="Text" name="first"><br>
Last name:<input type="Text" name="last"><br>
Nick name:<input type="Text" nickname="first"><br>
E-mail:<input type="Text" name="email"><br>
Salary:<input type="Text" name="salary"><br>
input type="Submit" name="submit" value="Enter information">
</form>
</html>
