<?php
/*
* 定义数据库操作类
* @author achao
* @site http://www.phpcoding.cn
*/class db {
private static $dbhost = "localhost";
private static $dbuser = "root";
private static $password = "";
private static $dbname = "mydb";
private static $instance = NULL;
private function __construct() {
self::createcon();
}
public static function getInstance(){
if (self::$instance == NULL) {
self::$instance = new db();
}
return self::$instance;
}
public function mycon() {
@mysql_connect ( self::$dbhost, self::$dbuser, self::$password );
}
public function selectdb() {
@mysql_select_db ( self::$db );
}
public static function createcon() {
mysql_connect ( self::$dbhost, self::$dbuser, self::$password );
mysql_select_db ( self::$dbname );
}
public function fetch_array($sql) {
$result = $this->query ( $sql );
$rs = mysql_fetch_array ( $result );
//echo "rs "."$rs[1]";
return $rs;
}
public function query($sql) {
mysql_query ( "set names gb2312" );
return mysql_query ( $sql );
}
public function loop_query($result) {
return mysql_fetch_array ( $result );
}
public function close() {
return mysql_close ();
}
}?>然后在另外一个文件实现下面这段代码$sql = "select count(*) from lyb where test='y'";
$array = $db->fetch_array ( $sql );
echo"$array[0]";
为什么 echo"$array[0]"等于结果集的行数呢? 搞不懂
/*
* 定义数据库操作类
* @author achao
* @site http://www.phpcoding.cn
*/class db {
private static $dbhost = "localhost";
private static $dbuser = "root";
private static $password = "";
private static $dbname = "mydb";
private static $instance = NULL;
private function __construct() {
self::createcon();
}
public static function getInstance(){
if (self::$instance == NULL) {
self::$instance = new db();
}
return self::$instance;
}
public function mycon() {
@mysql_connect ( self::$dbhost, self::$dbuser, self::$password );
}
public function selectdb() {
@mysql_select_db ( self::$db );
}
public static function createcon() {
mysql_connect ( self::$dbhost, self::$dbuser, self::$password );
mysql_select_db ( self::$dbname );
}
public function fetch_array($sql) {
$result = $this->query ( $sql );
$rs = mysql_fetch_array ( $result );
//echo "rs "."$rs[1]";
return $rs;
}
public function query($sql) {
mysql_query ( "set names gb2312" );
return mysql_query ( $sql );
}
public function loop_query($result) {
return mysql_fetch_array ( $result );
}
public function close() {
return mysql_close ();
}
}?>然后在另外一个文件实现下面这段代码$sql = "select count(*) from lyb where test='y'";
$array = $db->fetch_array ( $sql );
echo"$array[0]";
为什么 echo"$array[0]"等于结果集的行数呢? 搞不懂
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货