insert to db from url?

del753

I'm wondering how i would insert this information into my database (mysql)

$no = $_GET['id']; <taken from the url

i'm getting the id from a previous page and want to auto insert it i suppose when i get the rest of the info from the user of this page.

thanks

move3rd

Assuming you already have a DB connection:

	$insert_data =mysql_query("INSERT INTO table_name (num,
							                        column_2,
							                         another_col_etc)
							VALUES
							      ('$num',
							       '$column_2_value',
							       '$another_value_etc')");

del753

ok, i'm getting no php errors but its not inserting heres my code..

$showno = $GET['id'];
if (empty($POST['firstname'])) {
$fn = FALSE;
$message .= '<p>You forgot to enter your first name!</p>';
} else {
$fn = $_POST['firstname'];
}

if ($fn) {
require_once ('mysql_connect.php');
$query = "INSERT INTO tab (firstname, showno) VALUES ('$fn', '$showno')";
$result = @ ($query);

thanks alot

move3rd

I dont see any errors there other than that there is is no closing tag

for if code=php {[/code].

del753

thanks anyway i did close that, just missed out on it when posting here...

move3rd

What was the problem?

del753

wish i knew.......still there😕

liquorvicar

try changing this:
$result = @ ($query);
to

$result = mysql_query ($query) or die(mysql_error());

and see what you get.

and try posting in PHP tags next time. it makes it sooo much easier to read and hence help you.

del753

yeah i did try that but nothing different happened? thanks for your help

liquorvicar

have you tried echo-ing out the INSERT query and running it directly against the DB (via phpMyAdmin or similar)?

del753

eh no, havent tried that, how would i go about that? thanks

liquorvicar

have you got a MySQL GUI like phpMyAdmin?

if so, after this line:

$query = "INSERT INTO tab (firstname, showno) VALUES ('$fn', '$showno')";

add die($query); this will stop your script and print out your query. copy that and go into your MySQL GUI and run that query directly to see if you get an error or if it inserts into the DB.