sqlite.assoc_case (0,1,2) Scope: (Web server info) PHP_INI_ALL; Default value: 0 While
sqlite.assoc_case (0,1,2) Scope: PHP_INI_ALL; Default value: 0 While SQLite uses (and retrieves) column names in exactly the same format in which they appear in the database schema, various other database servers attempt to standardize name formats by always returning them in uppercase letters. This dichotomy can be problematic when porting an application to SQLite, because the column names used in the application may be standardized in uppercase to account for the database server s tendencies. To modify this behavior, you can use the sqlite.assoc_case directive. It determines the case used for retrieved column names. By default, this directive is set to 0, which retains the case used in the table definitions. If it s set to 1, the names will be converted to uppercase. If it s set to 2, the names will be converted to lowercase. Opening a Connection Before you can retrieve or manipulate any data located in an SQLite database, you must first establish a connection. Two functions are available for doing so, sqlite_open() and sqlite_popen(). sqlite_open() resource sqlite_open (string filename [,int mode [,string &error_message]]) The sqlite_open() function opens an SQLite database, first creating the database if it doesn t already exist. The filename parameter specifies the database name. The optional mode parameter determines the access privilege level under which the database will be opened, and is specified as an octal value (the default is 0666) as might be used to specify modes in Unix. Currently, this parameter is unsupported by the API. The optional error_message parameter is actually automatically assigned a value specifying an error if the database could not be opened. If the database is successfully opened, the function returns a resource handle pointing to that database. Consider an example: This either opens an existing database named mydatabase.db, creates a database named mydatabase.db within the directory /home/book/20/, or results in an error, likely because of privilege problems. If you experience problems creating or opening the database, be sure that the user owning the Web server process possesses adequate permissions for writing to this directory. sqlite_popen() resource sqlite_popen (string filename [,int mode [,string &error_message]])
Note: If you are looking for cheap and reliable webhost to host and run your mysql application check mysql web server services.