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 #175882 is a reply to message #175880]

Thu, 03 November 2011 22:49

Tim Streater
Messages: 328
Registered: September 2010

Karma:

Senior Member

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?

--
Tim

"That excessive bail ought not to be required, nor excessive fines imposed,
nor cruel and unusual punishments inflicted" -- Bill of Rights 1689

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: Fri Nov 22 14:20:08 GMT 2024

Total time taken to generate the page: 0.05012 seconds