Part II: Developing Intranet Solutions // Dump the (Web server on xp)
Part II: Developing Intranet Solutions // Dump the contents of the DBI object to // see what it contains. echo
; print_r($dbi); echo
; ?> Here, $dbi is an instance of the DBI object created from class.DBI.php. The constructor method has to be passed a database URL which has the following syntax: database_type://username:password.tabase_host/database_name The $DB_URL variable was set to create a database URL that pointed to a MySQL database (mysql) named mydb on host called localhost The database can be accessed using the root user account and foobar password. The DBI() method sets the DB URL passed to itself as db_url member variable and calls the connect() method to connect to the given database. The constructor sets the fetch mode to DB_FETCHMODE_OBJECT, which allows us to fetch database rows as objects. . connect(): By default, the DBI() constructor method calls the connect() function directly to establish the connection, so you don t need to. connect() connects to the database specified in db_url member variable of the object. It sets a member variable dbh to the database handle object created by the DB::connect() method, which is found in the PEAR DB package. connect also sets a member variable called connected to Boolean TRUE or FALSE and returns that value. . disconnect(): The disconnect() function disconnects the DBI object from the database. The terminate() function in PHPApplication class (class. PHPApplication.php) calls the disconnect() function if the application is connected to a database. See terminate() function in PHPApplicationclass for details. . query(): This function performs a SQL query on the connected database. The result of the query is stored in a result object called $result. If the query returns SQL error(s), a member variable called $this->dbi->error is set to the error message and null is returned.
Note: If you are looking for cheap and reliable webhost to host and run your web application check Vision coldfusion web hosting services