544 CHAPTER 22 SQLITE This (Web site management) returns: Name:
544 CHAPTER 22 SQLITE This returns: Name: Jason Gilmore (Employee ID: 1) Ideally, you ll want to use this function when you re working either with result sets consisting of numerous columns or with particularly large columns. sqlite_fetch_single() string sqlite_fetch_single (resource row_set [, int result_type [, bool decode_binary]]) The sqlite_fetch_single() function operates identically to sql_fetch_array() except that it returns just the value located in the first column of the row_set. Tip This function has an alias: sqlite_fetch_string(). Except for the name, it s identical in every way. Consider an example. Suppose you re interested in querying the database for a single column. To reduce otherwise unnecessary overhead, you should opt to use sqlite_fetch_single() over sqlite_fetch_array(), like so: “; } sqlite_close($sqldb); ?> This returns: Employee: Jason Gilmore Employee: Sam Spade Retrieving Result Set Details You ll often want to learn more about a result set than just its contents. Several SQLite-specific functions are available for determining information such as the returned field names, the number of fields and rows returned, and the number of rows changed by the most recent statement. These functions are introduced in this section.
You need excellent and relaible webhost company to host your web applications? Then pay a visit to Inexpensive Web Hosting services.