How to concatenate user defined variables in PHP and insert result into MySQL Table

Question

I'm trying to concatenate three variables into one variable and INSERT the result into an MYSQL table.

Here's my code so far:

$title = $_GET['title']; 
$colour = $_GET['colour']; 
$shoe_id = $_GET['shoe_id'];

$order_title = $title + '(' + $colour + '|' + $shoe_id');

$sql="INSERT INTO orders(order_title_1)
VALUES('$order_title')";
$result=mysql_query($sql);

Result : $title ($colour | $shoe_id)
i.e. Ara Ladies Reggio Lazer Cut Trouser Shoe (White | 51179-05G) | 12200

At the moment the result stored in the database is zero. I presume this is because I'm using the '+' operator incorrectly, however, I'm not sure what I should be using to concatenate the variables.

What do I need to do to concatenate the variables properly?

Thanks.

Concatenate operator is . in php

Mihai
– Mihai

2014-04-15 08:49:10 +00:00
Commented Apr 15, 2014 at 8:49 — Mihai
– Mihai, Commented Apr 15, 2014 at 8:49
Whereas + is used as concatenate operator in javaScript.

Vikas Arora
– Vikas Arora

2014-04-15 08:59:06 +00:00
Commented Apr 15, 2014 at 8:59 — Vikas Arora
– Vikas Arora, Commented Apr 15, 2014 at 8:59

Abhik Chakraborty · Accepted Answer · 2014-04-15 08:48:53Z

0

Correct way is

$order_title = $title .'( '.$colour.'|'.$shoe_id.' )';

In PHP concate operator is . not +

+ is an arithmetic operator in PHP

answered Apr 15, 2014 at 8:48

Abhik Chakraborty

44.9k6 gold badges56 silver badges63 bronze badges

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

1 Comment

Aphex22 Over a year ago

Thanks! - I knew it was the incorrect operator, just wasn't sure of the right one.

Collectives™ on Stack Overflow

How to concatenate user defined variables in PHP and insert result into MySQL Table

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related