INSERTING INTO MYSQL

dadms · Nov 26, 2003

PLEASE HELP, I CANT SEEM TO GET MY PHP SCRIPT WORKING. I DONT GET A CONNECTION ERROR. I GET THIS....

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /usr/home/panao3/public_html/formuser.php on line 11
there is a trouble2

PHP SCRIPT
<?php
//open connection

$dbh=mysql_connect("localhost", "panao3_matt", "Kiani123&quot

or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db("panao3_tierii&quot

;

//create SQL statement
$sql = "INSERT INTO user (id, name) VALUES ('', '$_POST[name]')";

// execute the SQL statement
if (mysql_query($sql, $conn)) {
echo "record added!";
} else {
echo "there is a trouble2";
}
?>

HTML FILE
HTML>
<HEAD>
<TITLE>test</TITLE>
</HEAD>
<BODY>

<FORM METHOD="POST" ACTION="formuser.php" >

<table width="100%" border="0" align="center">
<tr>
<td colspan="2" style="border-bottom-style: solid; border-bottom-width: 1" width="941">
<p align="center">DATABASE SUBMITTAL FORM</td>
</tr>

<tr>
<td width="939" colspan="2" style="border-style: solid; border-width: 1"> </td>
</tr>

<tr>
<td width="1" style="border-style: none; border-width: medium"><b>AUTHOR:</b></td>
<td width="1043" style="border-style: none; border-width: medium">
 <input type="text" name="name" size="20"></td>
</tr>
</table>
<p align="center">
<INPUT TYPE=SUBMIT VALUE="Submit Form">
<INPUT TYPE=RESET VALUE="Reset Form"> </p>
</FORM>
<HR>
</BODY>
</HTML>

MYSQL TABLE user
id int(15) UNSIGNED No auto_increment Primary Index
name text No

Zilch · Nov 26, 2003

The line after $sql you'll want to put this:

$result = mysql_query($sql,$dbh) or die("Information insersion fail.<br>Reason: ". mysql_error());

I believe this should fix your problem.

hos2 · Nov 27, 2003

I found this also strange
$sql = "INSERT INTO user (id, name) VALUES ('', '$_POST[name]')";

if id is an autoincrement you can leave it out

Code:

$sql = &quot;INSERT INTO user (name) VALUES ('$_POST[name]')&quot;;

spookie · Nov 27, 2003

Not sure if user is a keyword in mysql.

Try renaming table user to user1 or something and try..

--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.

Chacalinc · Nov 28, 2003

take a look on this:

$dbh=mysql_connect("localhost", "panao3_matt", "Kiani123&quot

or die ('I cannot connect to the database because: ' .

...

//create SQL statement
$sql = "INSERT INTO user (id, name) VALUES ('', '$_POST[name]')";

// execute the SQL statement
if (mysql_query($sql, $conn)) ...

you use $dbh to make the connection, but in mysql_query you are using $conn ...!!?? does it make sense for you?

and it should by mysql_query($dbh, $sql).

hope this helps you.

dadms · Nov 28, 2003

Thank everybody very much for your help. It was driving me crazy. I was so out of it I even left my username and passwords in the script. Here is a copy of what I have now and it works if anybody is interested.

<?php
//open connection

$dbh=mysql_connect("localhost", "user", "password&quot

or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db("panao3_tierii&quot

;

//create SQL statement
$sql = "INSERT INTO tieriiuser VALUES ('', '$_POST[name]')";
$result = mysql_query($sql,$dbh) or die("Information insersion fail.<br>Reason: ". mysql_error());

// execute the SQL statement
if (mysql_query($sql,$dbh)) {
echo "record added!";
} else {
echo "there is a trouble2";
}
?>

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

INSERTING INTO MYSQL

dadms

Technical User

Zilch

Programmer

hos2

Programmer

spookie

Programmer

Chacalinc

Vendor

dadms

Technical User

Similar threads

Part and Inventory Search

Sponsor