require_once('DB.php'); $db = DB::connect('mysql:host=localhost;dbname=mydatabase', 'username', 'password'); // Load a single row of data from the 'users' table where the user_id is 1 $user = $db->load('users', 1); // Print the user's information echo "Name: " . $user['name'] . "
"; echo "Email: " . $user['email'] . "
";
require_once('DB.php'); $db = DB::connect('mysql:host=localhost;dbname=mydatabase', 'username', 'password'); // Set the primary key column name PEAR::setErrorHandling(PEAR_ERROR_RETURN); $primary_key = $db->quoteIdentifier('employee_id'); PEAR::setErrorHandling(PEAR_ERROR_DIE); // Load a single row of data from the 'employees' table where the employee_id is 101 $employee = $db->load('employees', 101, $primary_key); // Print the employee's information echo "Name: " . $employee['name'] . "In this example, the load function is used to retrieve a single row of data from an 'employees' table where the primary key column is 'employee_id'. The data is then stored in the $employee variable, which can be accessed using an associative array. The package library for the PHP DataObject load function is the PEAR package.
"; echo "Department: " . $employee['department'] . "
";