Connecting to a SQLITE database

[Phpnewbie23]

Is there any other way to connect to a sqlite database other  than ODBC.

 

Cheers

[MadTechie]

ODBC if its no another PC but if its local then just use the file path..

 

[.josh]

http://www.google.com/search?hl=en&q=php+connect+to+sqlite+database&btnG=Google+Search

[Phpnewbie23]

Looking at php.net can i use the sqlite functions with the ODBC functions  this is my code it is suppost to populate a table with Backup_Name.

 

<?php

//  Database connector

$conn=odbc_connect('VembuDSN', '', '');

 

//  Generate querey string

$query="SELECT BACKUP_NAME FROM INCREMENTAL_BACKUP_REPORT";

$res=odbc_exec($conn,$query);

 

// execute query

// return result object

$result=odbc_result($res);

//$conn->query($query); //or die("Error in query");

 

// if rows exist

if ($result->odbc_num_rows() >0) {

//get each row as an array

//print values

echo"<table cellpadding=10 border=1>";

while($row=$result->fetch()) {

echo "<tr>";

echo "<td>".$row[0]."</td>";

echo "<td>".$row[1]."</td>";

echo "<td>".$row[2]."</td>";

}

echo "</table>";

}

?>

 

Cheers

 

[Mchl]

There's sqlite extension enabled by default since PHP5...

[fj1200]

Go with the sqlite().  It's far easier and probably faster and it's native to php.