Jump to content

It won't insert user input!


Doomflame
 Share

Recommended Posts

The code below enters the values $title, $id, and $value into the database, not their values. All of them are set.

 


$sql = \'INSERT INTO `stocks` (`Title`, `ID`, `Value`) VALUES (\'$title\', \'$id\', \'$value\');\'; 

$query = mysql_query($sql);

if ($query) {

echo "Success!";

} else {

echo "ERROR!";

}

 

Can anyone help me?

Link to comment
Share on other sites

WHen you start a string with a single tic it\'s interpreted to be a string literal by php. Use a double quote around the assignment instead, and php will do the variable replacement you expect.

 

[php:1:501ca3e94d]<?php

$sql = \"INSERT INTO `stocks` (`Title`, `ID`, `Value`) VALUES (\'$title\', \'$id\', \'$value\');\";

$query = mysql_query($sql);

if ($query) {

echo \"Success!\";

} else {

echo \"ERROR!\";

}

?>[/php:1:501ca3e94d]

Link to comment
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.