public function testFetchArray() { $db = new DB(); $host = "localhost"; $user = "******"; $pass = ""; $db_name = "thankscard"; $db->db_connect($host, $user, $pass, $db_name); $sql = "SELECT * FROM user "; $rs = $db->db_query($sql); $user = $db->fetch_array($rs); print_r($user); echo 123; }
<?php require_once dirname(__FILE__) . "/library/DB.php"; require_once dirname(__FILE__) . "/config/config.php"; session_start(); if (!isset($_SESSION["user"])) { header("Location: index.php"); } $db = new DB(); $db->db_connect(); //$from = "NOW" $sql = "SELECT * FROM message INNER JOIN user ON message.message_user = user.user_id WHERE message.message_created <= '" . date("Y-m-d h:i:s") . "' limit 10"; $rs = $db->db_query($sql); $message = $db->fetchAll($rs); ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>CIBRiDGE ASIA Thanks Card - Member List</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <link href="/thankcard/img/icon_fav.ico" rel="shortcut icon"> <link rel="stylesheet" type="text/css" href="css/common.css" media="all"> <link rel="stylesheet" type="text/css" href="css/style.css" media="all"> <link rel="stylesheet" type="text/css" href="css/print.css" media="print"> <script src="js/jquery-1.8.3.min.js"></script> <script src="js/script.js"></script> <style type="text/css"> .message { border: 1px solid #ccc;