Hey guys, I am new to PHP and MySQL and I am trying to make a script to add a users first name and last name to a mysql database but I keep recieving this error:
Unknown column ‘Craig’ in ‘field list’(this is mysql_erorr()'s error.)
along with
‘Could Not Add User, Try Again Later.’(this is my error response.)
I’m afraid I dont know how to put code in the special boxes as you guys do, so I’ll just paste it here.
:::index.php:::
<?php
$link=mysql_connect(‘localhost’,‘x’,‘x’);
if(!$link){
die('Could Not Connect: ’ . mysql_error());
}
else{
echo ‘Connected Successfully<br>’;
}
$db=mysql_select_db(‘cdabe3_tester’,$link);
if(!$db)
{
die(‘Could Not Connect To database<br>’.mysql_error());
}
else
echo ‘Connected to database successfully.<br>’;
$info=mysql_query(“SELECT id,firstname,lastname FROM bigtest”);
?>
<html>
<head>
</head>
<body>
<P>Add A Name</P>
<form name=“adduser” method=“post” action=“adduser.php”>
<input type=“text” name=“firstname” size=“20” />
<input type=“text” name=“lastname” size=“20” />
<input type=“submit” value=“Add User” />
</form>
<?php
echo “<P><B>Users</B></P><br>”;
while($row=mysql_fetch_assoc($info)){
echo $row[“id”];
echo $row[“firstname”];
echo $row[“lastname”];
}
mysql_close($link);
?>
</body>
</html>
:::adduser.php:::
<?php
$Fname=$_POST[“firstname”];
$Lname=$_POST[“lastname”];
$connect = mysql_connect(‘localhost’,‘x’,‘x’);
if(!connect){
die(‘Could Not Connect.<br>’ . mysql.error());
}
echo ‘Connected Successfully<br>’;
$db=mysql_select_db(‘cdabe3_tester’,$connect);
if(!$db)
{
die(‘Could Not Connect To database<br>’.mysql_error());
}
else
echo ‘Connected to database successfully.’;
$query=‘INSERT INTO bigtest VALUES(NULL,’.$Fname.’,’.$Lname.’)’;
$useradded=mysql_query($query);
if(!$useradded){
echo ‘Could Not Add User, Try Again Later.<br>’;
echo mysql_error();
}
else
echo ‘User Added Successfully.<br>’;
mysql_close($connect);
?>
<html>
<head>
</head>
<body>
<a href=“index.php”>Go Home</a>
</body>
</html>
I have this uploaded to a site, http://www.cdabe.com which will show you what’s happening.
Thanks in advance for any input you can give me, it is much appreciated