Append variable To string in php insert

Question

I'm having an issue appending a file name variable to a string in a sql insert like so

$insert = $mysqlConn->query("INSERT into images (image_name, url) VALUES ('".$fileName."', 'images/".$fileName."'");

I can do it with just the $fileName and it works fine but my syntax is wrong. I'm simply trying to make sure that every file name inserted starts with 'images/'

So if I'm inserting 'red.jpg' it would be 'images/red.jpg'

You're just missing the trailing ) for the VALUES, change the string to "INSERT into images (image_name, url) VALUES ('".$fileName."', 'images/".$fileName."')" — Nick
– Nick, Commented Sep 17, 2018 at 4:05
You must use PDO for security reasons to prevent injections. — Krishnadas PC
– Krishnadas PC, Commented Sep 17, 2018 at 5:10

Sociopath · Accepted Answer · 2018-09-17 06:01:07Z

1

You can store image value into one variable

 $imgPath = 'images/'.$fileName;

Above variable you can pass into the query

edited Sep 17, 2018 at 6:01

Sociopath

13.4k22 gold badges53 silver badges82 bronze badges

answered Sep 17, 2018 at 5:59

Sanu0786

56910 silver badges16 bronze badges

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

Comments

Rp9 · Accepted Answer · 2018-09-17 04:10:23Z

0

try this,you are missing one bracket

$insert = ("INSERT into images (image_name, url) VALUES ('".$fileName."', 'images/".$fileName."')");

edited Sep 17, 2018 at 4:10

answered Sep 17, 2018 at 4:06

Rp9

1,9612 gold badges27 silver badges34 bronze badges

2 Comments

user3783243 Over a year ago

Your closing parenthesis is on the wrong side of the quote.

Nick Over a year ago

Please don't post answers to questions which are just simple typos. Instead, make a comment (as I have already done) and flag the question as "off-topic" due to a typographical error. Questions like this add no value to the site and will eventually be deleted, thus causing you to lose any reputation that you may gain from answering.

Collectives™ on Stack Overflow

Append variable To string in php insert

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related