require_once 'MDB2.php'; $dsn = 'mysql://user:pass@localhost/db_name'; $options = array( 'debug' => 2, 'portability' => MDB2_PORTABILITY_ALL, ); $db = MDB2::singleton($dsn, $options);
$db = MDB2::singleton($dsn, $options); $sql = "SELECT * FROM `table_name` WHERE `column_name`=:column_value"; $stmt = $db->prepare($sql); $column_value = 'value'; $stmt->bindParam(':column_value', $column_value, MDB2::TYPE_STRING); $res = $stmt->execute(); $rows = $res->fetchAll(MDB2_FETCHMODE_ASSOC); foreach ($rows as $row) { // process each row }In this example, we are using the `PDO` package to execute a SELECT statement. We are creating a prepared statement with a bind parameter and executing it. Finally, we are fetching the result into an associative array for easy processing. Package Library: PearDatabase (database abstraction layer)