# PHP add user script

**URL:** <https://forum.kirupa.com/t/php-add-user-script/236319>\
**Category:** programming\
**Created:** [August 19, 2007, 9:16pm UTC](https://forum.kirupa.com/t/php-add-user-script/236319 "2007-08-19T21:16:38Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cschauer](https://avatars.discourse-cdn.com/v4/letter/c/a3d4f5/32.png) [@cschauer](https://forum.kirupa.com/u/cschauer)\
**Post date:** [August 19, 2007, 9:16pm UTC](https://forum.kirupa.com/t/php-add-user-script/236319/1 "2007-08-19T21:16:38Z")

</div>

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