phpeveryday.com

For this practice, create a folder named "ntier" within www/test. Place your all PHP ADOdb folder at here. Thus, you have www/test/ntier/adodb.

Then create a file named "dataaccess.php" within www/test/ntier. Enter following code

<?
include('adodb/adodb.inc.php'); 

$databasetype = 'mysql';
$server = 'localhost';
$user   = 'root';
$password = 'admin';
$database = 'test';

$db = ADONewConnection($databasetype); 
$db->debug = false; 
$db->Connect($server, $user, $password, $database); 

$recordSet = &$db->Execute('select * from books'); 

if (!$recordSet) 
  print $conn->ErrorMsg(); 
else 
  while (!$recordSet->EOF) { 
    print $recordSet->fields[0].' '.$recordSet->fields[1].' '.$recordSet->fields[2].'<BR>'; 
  $recordSet->MoveNext();       
}    

$recordSet->Close(); # optional 
		
$db->Close();

?>

Test it. Open your browser. point to http://localhost/test/ntier/dataacces.php.

Next post, we will talk about business logic layer. Don't miss it.