PHP:: mySqli does not insert a new line with a variable

Question

This line is working perfectly :

$mysqli->query("INSERT INTO `myDatabase`.`myTable`(Date,Time,SID) VALUES (1,2,3)");

But this not :

session_start();
$sessionID=session_id();
$mysqli->query("INSERT INTO `myDatabase`.`myTable`(Date,Time,SID) VALUES (1,2,$sessionID)");

I have also tried:

session_start();
$sessionID=session_id();
$mysqli->query("INSERT INTO `myDatabase`.`myTable`(Date,Time,SID) VALUES (1,2,".$sessionID.")");

All table rows defined as TINYTEXT.

Strings should always be between quotation marks. Like this: `$mysqli->query("INSERT INTO table (column_1 ,column_2) VALUES ('value', '" . $value2 . "')"); ` Also make sure a variable is effective a variable and not simply a string... mentioned as 2nd value in the query — Jeroen Bellemans, May 13 '15 at 13:06

Florian · Accepted Answer · 2015-05-13T13:07:29.297

7

You need to pass the variable as a variable to your query ad wrap your values into an "'s, example:

$mysqli->query("INSERT INTO `myDatabase`.`myTable`(Date,Time,SID) VALUES ('1','2','" . $sessionID . "')");

edited May 13 '15 at 13:07

answered May 13 '15 at 13:02

Florian

@Hezi-Gangina what is the return value of your query? – Florian May 13 '15 at 13:08
Thanks man! I solve that out (...see @Jeroen Bellemans comment) – Hezi-Gangina May 13 '15 at 13:16
...Your answer is accepted (...after you edit it ;--)) – Hezi-Gangina May 13 '15 at 13:17

score 1 · Answer 2 · answered May 13 '15 at 13:14

1

Thanks to @Jeroen Bellemans and @Florian...

I merge both techniques and it works like a charm ;)

$mysqli->query("INSERT INTO `myDatabase`.`myTable`(Date,Time,SID) VALUES ('1','2','".$sessionID."')");

Thanks guys!

answered May 13 '15 at 13:14

Hezi-Gangina

2 Answers2