Пример #1
0
 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;
 }
Пример #2
0
<?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;