Hi,
I'm not very experienced in PHP, and have always used mysql with it,
but now I have a Sqlite database that I want to manipulate and I
thought PHP would be an easy way to do it. It turned out that I need
to use PDO to access a Sqlite V3 database, which is all new to me.
I've managed
still not working,
$sesdb = new PDO('sqlite:file.sqlite3');
$query=SELECT ZNAME, ZQUANTITY, ZPRODUCTID FROM ZITEM WHERE
ZCategory != 14;
$statement= $sesdb-query($query);
$result=$statement-fetchAll();
foreach ($result as $product) {
$prodname=$product[0];
$prodqty = $product[1];
output?
On Wed, Aug 20, 2008 at 11:02 AM, Amy Gibbs [EMAIL PROTECTED]
wrote:
still not working,
$sesdb = new PDO('sqlite:file.sqlite3');
$query=SELECT ZNAME, ZQUANTITY, ZPRODUCTID FROM ZITEM WHERE
ZCategory !=
14;
$statement= $sesdb-query($query);
$result=$statement-fetchAll();
foreach
) {
$prodname=$product[0];
$prodqty = $product[1];
$prodid=$product[2];
$sql = UPDATE ZITEM SET ZQUANTITY='0' WHERE ZPRODUCTID='{$prodid}';
$sesdb-exec($sql);
}
On Wed, Aug 20, 2008 at 11:49 AM, Amy Gibbs [EMAIL PROTECTED]
wrote:
No errors reported, but it's not updating the db
Thanks for trying,
On 20 Aug 2008, at 11:42, Evert Lammerts wrote:
Sorry, I'm out of options. Hopefully somebody on the list has a little
more experience with PDO.
On Wed, Aug 20, 2008 at 12:26 PM, Amy Gibbs [EMAIL PROTECTED]
wrote:
It's still not working :(
$query=SELECT ZNAME, ZQUANTITY
');
var_dump($sesdb-exec(UPDATE ZITEM SET ZQUANTITY=0 WHERE
ZPRODUCTID=1));
On Wed, Aug 20, 2008 at 12:42 PM, Evert Lammerts
[EMAIL PROTECTED] wrote:
Sorry, I'm out of options. Hopefully somebody on the list has a
little
more experience with PDO.
On Wed, Aug 20, 2008 at 12:26 PM, Amy Gibbs
(UPDATE ZITEM SET ZQUANTITY=0 WHERE
ZPRODUCTID=1));
On Wed, Aug 20, 2008 at 12:42 PM, Evert Lammerts
[EMAIL PROTECTED] wrote:
Sorry, I'm out of options. Hopefully somebody on the list has a
little
more experience with PDO.
On Wed, Aug 20, 2008 at 12:26 PM, Amy Gibbs [EMAIL PROTECTED]
wrote
with PDO.
On Wed, Aug 20, 2008 at 12:26 PM, Amy Gibbs [EMAIL PROTECTED]
wrote:
It's still not working :(
$query=SELECT ZNAME, ZQUANTITY, ZPRODUCTID FROM ZITEM WHERE
ZCategory !=
14;
$statement= $sesdb-query($query);
$result=$statement-fetchAll();
$statement=null;
foreach ($result as $product