|
|
|
|
Bookmark this on Delicious
Share on Facebook
 Slashdot It!
Digg  sqlite_field_name
Returns the name of a particular field
(PHP 5, PECL sqlite:1.0-1.0.3)
Code Examples / Notes » sqlite_field_namerrf5000
While working with SQLite using its object-oriented mode, I found need to display a column/field name without knowing what it was in advance. I couldn't find any examples on the Internet, just this document. So, for anyone who happens to need to do this, here's an example. <?php $db = "db/database.sqlite"; // create new database (OO interface) $dbo = new SQLiteDatabase("$db"); // create table foo and insert sample data $dbo->query(" CREATE TABLE foo(id INTEGER PRIMARY KEY, name CHAR(255)); INSERT INTO foo (name) VALUES('Ilia1'); INSERT INTO foo (name) VALUES('Ilia2'); INSERT INTO foo (name) VALUES('Ilia3'); "); $query = "SELECT * FROM foo;"; $result = $dbo->query($query) or die("Error in query"); echo " <table border='1' cellpadding='10'> <tr> <td>".$result->fieldName(0)."</td> <td>".$result->fieldName(1)."</td> </tr>"; // iterate through the retrieved rows while ($result->valid()) { // fetch current row $row = $result->current(); echo " <tr> <td>".$row[0]."</td> <td>".$row[1]."</td> </tr>"; // proceed to next row $result->next(); } echo "</table>"; ?> |
Change Language
sqlite_array_query sqlite_busy_timeout sqlite_changes sqlite_close sqlite_column sqlite_create_aggregate sqlite_create_function sqlite_current sqlite_error_string sqlite_escape_string sqlite_exec sqlite_factory sqlite_fetch_all sqlite_fetch_array sqlite_fetch_column_types sqlite_fetch_object sqlite_fetch_single sqlite_fetch_string sqlite_field_name sqlite_has_more sqlite_has_prev sqlite_key sqlite_last_error sqlite_last_insert_rowid sqlite_libencoding sqlite_libversion sqlite_next sqlite_num_fields sqlite_num_rows sqlite_open sqlite_popen sqlite_prev sqlite_query sqlite_rewind sqlite_seek sqlite_single_query sqlite_udf_decode_binary sqlite_udf_encode_binary sqlite_unbuffered_query sqlite_valid |
