[RESOLVED] Using Variables with mysql queries

slightlyeskew

I tried to compile the following and received a

Parse error: syntax error, unexpected T_VARIABLE ... on line 10.

The code:

<?php
require_once "MDB2.php";

$db = MDB2::connect('...');
if (MDB2::isError($db)) {die("Can't Connect: " . $db->getMessage()); }

$insertionTest = 42;
$sql = "INSERT INTO test VALUE($insertionTest)";
$result = $db->query($sql);
?>

I'm not sure what I'm not catching...I've read through this a couple of times. :queasy:
I thought the problem might have to do with "42" being a string and not an integer, and that the field I'm trying to insert it into is set to Integer.
Perhaps I've just misapplied quotation marks. Any help would be appreciated.

dagon

there is no error on line 10 of this code, what's the error message say in full?

slightlyeskew

Thanks for the phenomenally quick response Dagon.

Unfortunately there was not much more information. I recompiled just to make sure that this was the error.

The error in full:

Parse error: syntax error, unexpected T_VARIABLE in /var/www/NovaDB/insertiontest.php on line 10

Let me know if I can provide any other information...all my versions for php and mysql server are the newest from the ubuntu repository.

Thanks again for the help!

slightlyeskew

Sorry for my newbness...this development perplexed me even more.

I took very similar code, closed the tab in firefox I had been using to load localhost, changed to a different text file and used this:

<?php

require_once "MDB2.php";

$db = MDB2::connect('....');
if (MDB2::isError($db)) {die("Can't Connect: " . $db->getMessage()); }

$x = 42;
$sql = $db->query("INSERT INTO test VALUE($x)");

This compiles fine. The different format of query should not have affected the outcome. Is this a problem with my browser, or the text file, or what? Any insight would be appreciated!

slightlyeskew

RESOLVED

The issue had to do with my newbness in Linux, no PHP!

I had originally started the text file in a different folder, when I copied the file to a different folder I guess it wasn't fully transferred there? A "~" was prefixed to the front of it. I had edited the file sometime ago to add a ";" to

$x = 42

which had originally compiled to give me the error. The browser kept reloading the file which had not yet been edited. Sorry again 🙂