|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2008-03-29 22:49 UTC] gustavolopez at cantv dot net
Description: ------------ I create a SQLIte3 DB with 1 table, 4 fields (varchar (20)) I inserted 3 records in it. I connect to DB, select * from these table. The function numColumns() always return zero (0), but the query returns 3 rows, 4 fields, as expected PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Fri Oct 24 23:00:01 2025 UTC |
<?php $db = new SQLite3(':memory:'); $a = 'CREATE TABLE test (Cedula varchar(12) PRIMARY KEY ON CONFLICT ROLLBACK NOT NULL COLLATE NOCASE, '; $a .= 'Nombres varchar(50) NOT NULL COLLATE NOCASE, Apellidos varchar(50) COLLATE NOCASE, Edad integer DEFAULT 0) '; echo "create Table test<br>"; $db->exec($a); echo "INSERT 3 rows<br>"; $db->exec("Insert INTO test (Cedula, Nombres, Apellidos, Edad) VALUES ('18888', 'MARIA', 'MENDIETA', 90) "); $db->exec("Insert INTO test (Cedula, Nombres, Apellidos, Edad) VALUES ('18222', 'MARIA', 'MENDIETA', 90) "); $db->exec("Insert INTO test (Cedula, Nombres, Apellidos, Edad) VALUES ('182223', 'MARIA', 'MENDIETA', 90) "); echo "<br>SELECT ALL rows<br>"; $results = $db->query("SELECT * FROM test"); while ($result = $results->fetchArray(SQLITE3_NUM)){ var_dump($result); } echo "<br><br>Total Columns (expected 4): ".$results->numColumns(); $results->finalize(); $db->Close(); ?>