Inserting into database php variables

Question

I have got this code:

$title = mysql_real_escape_string($_POST['title']);
$description = mysql_real_escape_string($_POST['description']);
$method = mysql_real_escape_string($_POST['method']);

$method1 = '<ul><li>' . implode('</li><li>', explode("\n", $description)) . '</li></ul>';


mysql_query("INSERT INTO recipe (title, description, method) VALUES('".$title."', '".$description."', '".$method1."')");

But it isnt adding anything to my database. Should this code be working?

UPDATE***

I have added the following code but it is not outputing anything

if($success)
{
echo "<h1>Success</h1>";
}
else
{
echo "<h1>Error</h1>";
}

Try the query directly in phpmyadmin or your console to see the error. — GG.
– GG., Commented Nov 24, 2011 at 16:35
I tried the query in phpmyadmin and it worked? INSERT INTO recipe (title, description, method) VALUES('".$title."', '".$description."', '".$method1."') — user667430
– user667430, Commented Nov 24, 2011 at 16:43
That might because you aren't entering the same query; PHP would translate $title to the value of $title. What I usually do (as a lazy solution) would be to write $query="bla bla"; and then use $result=mysql_query($query); -- you can 'echo query;' to see what the actual query you're generating is. — RonLugge
– RonLugge, Commented Nov 24, 2011 at 18:22

Haim Evgi · Accepted Answer · 2011-11-24 16:27:51Z

1

try to wrap your fields with ''

"INSERT INTO recipe (`title`, `description`, `method`) VALUES('".$title."', '".$description."', '".$method1."')");

look on reserved words

answered Nov 24, 2011 at 16:27

Haim Evgi

126k46 gold badges222 silver badges226 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Maxime · Accepted Answer · 2011-11-24 17:00:27Z

1

' and " are inverted in VALUES().

edited Nov 24, 2011 at 17:00

user212218

answered Nov 24, 2011 at 16:30

Maxime

214 bronze badges

Comments

GG. · Accepted Answer · 2011-11-24 16:31:48Z

0

Not need (title, description, method) if you insert the fields in the correct order.

$query = "INSERT INTO recipe VALUES ('".$title."', '".$description."', '".$method1."')";

mysql_query($query);

If the problem is not resolved, try the query directly in phpmyadmin or your console to see the error.

answered Nov 24, 2011 at 16:31

GG.

22k14 gold badges93 silver badges133 bronze badges

1 Comment

Haim Evgi Over a year ago

in case this table is contain only those 3 fields

Collectives™ on Stack Overflow

Inserting into database php variables

3 Answers 3

Comments

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Related