true, ); $mdb2 =& MDB2::factory($dsn, $options); if (PEAR::isError($mdb2)) { echo ($mdb2->getMessage().' - '.$mdb2->getUserinfo()); } function getUserData($mdb2) { $query ="SELECT * FROM USER"; $result = $mdb2->query($query); // check if the query was executed properly if (PEAR::isError($result)) { echo ($result->getMessage().' - '.$result->getUserinfo()); exit(); } // fetch all and free the result $arr = $result->fetchAll(MDB2_FETCHMODE_ASSOC); $result->free(); $mdb2->disconnect(); return $arr; } // Get all users $users_arr = getUserData($mdb2); $number_users = count($users_arr); echo "
Host | User | Password |
".$users_arr[$i]['host']." | ".$users_arr[$i]['user']." | ".$users_arr[$i]['password']." |