Problem sending info from a HTML form to mySQL Database

ld0121

Hi all,

I have a database set up, and can hapilly add info through phpMyAdmin manually and by importing data from a file. I now want to be able to send data to my data base from a HTML form. I have followed a tutorial but still can get the thing to work. When I press submit, it goes to the Thanks your information has been sent page, but when I look at the database none of the information has gone in.

This is the code that im using, any help would be great, PS I have swapped out my database details for xxxxxx.

Cheers
Lee
------------------------>>>

<html>

<body>

<?php

if ($submit) {

// process form

$db = mysql_connect("localhost", "xxxxxx", "xxxxxx");

mysql_select_db("xxxxxxxx",$db);

$sql = "INSERT INTO 'xxxxxxx' (name, desc, url) VALUES ('$name','$desc','$url')";

$result = mysql_query($sql);

echo "Thank you! Information entered.\n";

} else{

// display form

Name of site:<input type="Text" name="name"><br>

Description:<input type="Text" name="desc"><br>

URL:<input type="Text" name="url"><br>

</form>

<?php

} // end if

</body>

</html>

leatherback

Hi,

Due to security settings in PhP, you cannot acces the variables directly anymore. You can retrieve them through:

$_POST['yourvar'], so in your case:

$name = $_POST['name']

ld0121

hi, thanks for the response. I am a complete novice at this, where do I put/use the code you sugessted?

Cheers
Lee

leatherback

Hi,

You would place it in the page where the variables are submitted to, before the location where you need them:

<?php 

if ($submit) { 

// process form 

$db = mysql_connect("localhost", "xxxxxx", "xxxxxx"); 

mysql_select_db("xxxxxxxx",$db); 

&name=$_POST['name'];
$desc = $_POST['desc'];
$url = $_POST['url'];


$sql = "INSERT INTO 'xxxxxxx' (name, desc, url) VALUES ('$name','$desc','$url')"; 

$result = mysql_query($sql); 

echo "Thank you! Information entered.\n"; 

} else{ 



// display form 



?> 



<form method="post" action="<?php echo $PHP_SELF?>"> 

Name of site:<input type="Text" name="name"><br> 

Description:<input type="Text" name="desc"><br> 

URL:<input type="Text" name="url"><br> 

<input type="Submit" name="submit" value="Enter information"> 

</form> 


<?php 


} // end if

ld0121

Hi, again!, im just getting what I had before, the for submits but the data isnt going into the database. Any other thoughts?

Cheers
Lee

leatherback

Is the data getting to the form thou?

If you post
echo $sql ;
directly after you define the query, what you do get?

ld0121

I get

INSERT INTO gzdata (name, desc, url) VALUES ('test','test','test')Thank you! Information entered.

fire_cracker

Try to see if SQL is throwing an error back at you. Obviously if the form isn't being processed there must be an error someplace along the line. I try and use pretty fail safe methods, so that I know where when and why an error is showing up in my script.

Here is what I would do:

if ($submit) { 

// process form 

mysql_connect("localhost", "xxxxxx", "xxxxxx") or die("Could Not Connect To The Database. <br>" . mysql_error()); 

mysql_select_db(xxxxxxxx) or die("Could Not Select The Proper Database. <br>" . mysql_error()); 

&name=$_POST['name'];
$desc = $_POST['desc'];
$url = $_POST['url'];


$sql = "INSERT INTO 'xxxxxxx' (name, desc, url) VALUES ('$name','$desc','$url')"; 

$result = mysql_query($sql);

if($result)
{
echo "Data Properly Inserted";
}
else
{
echo "An Error occured while trying to process your information.";
}

}

While this method makes your code a lot longer, it does make it easier to identify where your problem is occuring.

Hope this helps.

ld0121

I no get

An Error occured while trying to process your information.INSERT INTO gzdata (name, desc, url) VALUES ('test','test','test')Thank you! Information entered.

Is this a code problem or could be it be a permissions problem on the server?

Cheers
Lee

fire_cracker

Hmmm. I've never gotten an error like that before. Provided the code was all acuratly writen the program can connect to the database server, it can open the proper database, but it can't insert the fields properly.

I would check the table you are trying to insert data into, make sure that all the fields you have specified are of the proper data type, and the length is long enough, then if all else fails try doing a very basic insert where you have to define all the fields like:

INSERT INTO table_name("NULL","Data1",Data2","Data3");

Put the information in order and set your id field to null during the insert. Errr, it is kinda hard to explain what I mean. Hopefully you sorta understand.

ld0121

OK im lost now, the settings in MySQL are

name varchar(50) Yes NULL _ Change Drop Primary Index Unique Fulltext

desc text Yes NULL _ Change Drop Primary Index Unique Fulltext

url varchar(50) Yes NULL _ Change Drop Primary Index Unique Fulltext

which I think is ok?

If all else fails, do you know anywhere I could get some code to do this form?

Lee

ld0121

Just in case ive missed something heres the code so far!

<html>

<body>

<?php

if ($submit) {

// process form

$db = mysql_connect("localhost", "XXXXX", "XXXXXX") or die("Could Not Connect To The Database. <br>" . mysql_error());

mysql_select_db("XXXXXX",$db) or die("Could Not Select The Proper Database. <br>" . mysql_error());

$name = $POST['name'];
$desc = $POST['desc'];
$url = $_POST['url'];

$sql = "INSERT INTO gzdata(name, desc, url) VALUES ('$name','$desc','$url')";

$result = mysql_query($sql);

if($result)

{

echo "Data Properly Inserted";

}

else

{

echo "An Error occured while trying to process your information.";

}

echo $sql ;

echo "Thank you! Information entered.\n";

}

else

{

// display form

Name of site:<input type="Text" name="name"><br>

Description:<input type="Text" name="desc"><br>

URL:<input type="Text" name="url"><br>

</form>

<?php

} // end if

</body>

</html>

fire_cracker

That looks right to me. Dunno tho.

ld0121

Sorted, the problem was caused by me using desc as a field name, and MySQL uses DESC as a comand.

fire_cracker

I forgot all about that sort of problem. I had trouble with that too not to long ago.