FUDforum: comp.lang.php » sqlite and php

Home » Imported messages » comp.lang.php » sqlite and php

Show: Today's Messages :: Polls :: Message Navigator

Re: sqlite and php [message #175884 is a reply to message #175882]

Thu, 03 November 2011 22:53

Jerry Stuckle
Messages: 2598
Registered: September 2010

Karma:

Senior Member

On 11/3/2011 6:49 PM, Tim Streater wrote:
> In article <-76e7-4b70-b81b-67d5b8b8522a(at)q13g2000vbd(dot)googlegroups(dot)com>,
> Anne Achey <anneachey(at)gmail(dot)com> wrote:
>
>> Hi,
>>
>> Anyone know how to create a sqlite database from PHP code? I am trying
>> the code below:
>>
>> try
>> {
>> //create or open the database
>> $database = new SQLiteDatabase('myDatabase.db', 0666, $error);
>> }
>> catch(Exception $e)
>> {
>> die($error);
>> }
>
> What's all this rubbish?
>
> Try:
>
>
> $connstr = "sqlite:" . $name_of_my_db;
> $dbh = new PDO ($connstr);
>
> $dbh->setAttribute (PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
>
> and then to use it:
>
> $res = $dbh->query ($sql);
>
> if ($res===false)
> {
> $earray = $dbh->errorInfo ();
> // Then $earray[0] has error code, more info in [1] and [2]
> }
>
> and so on. Have you not looked at the PHP website docs?
>

A completely different interface, Tim. The op's code should work.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================

Report message to a moderator

[Message index]

		sqlite and php By: Anne Achey on Thu, 03 November 2011 20:30
		Re: sqlite and php By: Tim Streater on Thu, 03 November 2011 22:49
		Re: sqlite and php By: Jerry Stuckle on Thu, 03 November 2011 22:53
		Re: sqlite and php By: Tim Streater on Thu, 03 November 2011 23:20
		Re: sqlite and php By: Jerry Stuckle on Thu, 03 November 2011 22:57
		Re: sqlite and php By: P E Schoen on Thu, 03 November 2011 23:14
		Re: sqlite and php By: P E Schoen on Thu, 03 November 2011 23:24
		Re: sqlite and php By: Denis McMahon on Fri, 04 November 2011 00:20
		Re: sqlite and php By: Denis McMahon on Fri, 04 November 2011 02:38

Previous Topic:	email sent from webpage is classed as junk
Next Topic:	session cookie: client side

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 22:49:53 GMT 2024

Total time taken to generate the page: 0.03637 seconds