Re: SQLite problem INSERTing string

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



$val="127.0.0.1";
$query="INSERT INTO node set uri=\"$val\", name=\"bla\"";

Try this one... think is better n less confusing for u...

On Sun, 19 Sep 2004 19:13:48 +0200, Darryl <admin@xxxxxxxxxx> wrote:
> 
> $val = "127.0.0.1";
> $query = "INSERT INTO node (uri,name) VALUES ('".$val."','bla')";
> 
> Try that?
> 
> 
> -----Original Message-----
> From: Stefan Reimers [mailto:php@xxxxxxxxxxxxxxxxx]
> Sent: Sunday, September 19, 2004 6:37 PM
> To: php-db@xxxxxxxxxxxxx
> Subject:  SQLite problem INSERTing string
> 
> Hello,
> 
> I am currently experiencing a problem with an INSERT statement in SQLite.
> 
> First of all an excerpt from the code:
> 
> $val = "127.0.0.1";
> $query = "INSERT INTO node (uri,name) VALUES (".$val.",'bla')";
> 
> $db_name = "mysqlite";
> 
> if($db_hdl = sqlite_open($db_name)){
> 
>        $db_result = sqlite_query($db_hdl,$query);
> 
> }
> 
> I get the error message:
> 
> Warning: sqlite_query(): near ".": syntax error in
> C:\Programme\xampp\htdocs\dipl\testclient\sqlite_test.php on line 10
> 
> I tried addslashes (which I know I shouldn't), sqlite_escape_string, any
> variant of quotes etc, I asked google and the searched the news groups
> but with no relevant result, except the insight, that others experience
> the same so long unsolved problem or use a syntax in their tutorials
> that does not work with my code...
> 
> As you an see from the error message, I use Windows, Apache, PHP4 with
> SQLite in a 2.8.14 version.
> 
> If anyone has a clue, please contact me or just answer.
> Thanks in advance
> Stefan
> 
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
> 
> 
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux