Why does PHP script fail to insert into MySQL database?

Question

I am trying to figure out why an error occurs when my PHP script tries to insert data into a MySQL database.

I am working on a small form that collects data, and then in PHP I submit it into my SQL database. When I submit it, I get a blank page and nothing is inserted, I have added an echo to display if the insert fails, which it is.

<?php
mysql_connect("host", "user", "pass") or die(mysql_error());
mysql_select_db("db") or die(mysql_error());

$name=$_POST['repname'];
$replace=$_POST['replace'];
$reg=$_POST['reg'];
info=$_POST['info'];

if($name == '') {
    $errmsg_arr[] = 'Rep name missing.';
    $errflag = true;
}

if($replace == '') {
$errmsg_arr[] = 'Please fill out all the forms.';
$errflag = true;
}
if($reg == '') {
$errmsg_arr[] = 'Please fill out all the forms.';
$errflag = true;
}
if($info == '') {
$errmsg_arr[] = 'Please add some other information about your rep.';
$errflag = true;
}


if(!mysql_query("INSERT INTO reps (name, replace, reg, boxinfo) VALUES          
('".$name."','".$replace."','".$reg."','".$info."')"))   
{ 
 echo 'failed'; 
} 
else 
{ 
 echo 'inserted'; 
}

?>

You are missing a `$` before ---> (info) variable `info=$_POST['info'];` — Shankar Narayana Damodaran, Dec 29 '13 at 17:29
@ShankarDamodaran, post that as an answer before someone else does :D — Matt Clark, Dec 29 '13 at 17:30
Plus you're open to SQL injection. Read this => http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php — Funk Forty Niner, Dec 29 '13 at 17:31
But he didn't mention any syntax errors so i am still wondering ^_^ — Shankar Narayana Damodaran, Dec 29 '13 at 17:31
If the OP said to put it as an answer, then we can assume it's correct ;-) @ShankarDamodaran — Funk Forty Niner, Dec 29 '13 at 17:32

score 3 · Answer 1 · edited May 23 '17 at 12:28

3

Beside Shankar's comment replace is a reserved word use backticks.

INSERT INTO reps (name, `replace`, reg, boxinfo)

edited May 23 '17 at 12:28

Community

1
1

answered Dec 29 '13 at 17:32

Mihai

26,325
7
66
81

1

LOL! It's something I like to do, in order to put emphasis and clarification ;-) @Mihai – Funk Forty Niner Dec 29 '13 at 17:38

Why does PHP script fail to insert into MySQL database?

1 Answers1

Linked