关于php的面向对象的问题
<?php
// The basic DB SQL operation Class
// V 1.0
// By Xiao Gang. searchware@sina.com
// 2000.05.22
require ("config.php");
Class DBSQL
{
var $CONN = "";
var $USER = UserName;
var $PASS = PassWord;
var $SERVER = ServerName;
// added by hofman
# var $DBName = DBName;
// the constructor
function DBSQL($DBName)
{
$user = $this->USER;
$pass = $this->PASS;
$server = $this->SERVER;
$dbase = $DBName;
$conn = mysql_connect($server,$user,$pass);
if(!$conn) {
$msg = "数据库连接失败!请检查系统设置。";
include("err.php3");
exit;
}
if(!mysql_select_db($dbase,$conn)) {
$msg = "数据库 $DBName 选择失败!请检查系统设置。";
include("err.php3");
exit;
}
$this->CONN = $conn;
return true;
}
// SQL function to MySQL databases
// select SQL function
// INPUT: $sql, the SQL statement submitted.
// RETURN: the selected results in an array OR false
function select($sql="")
{
if (empty($sql)) return false;
if (empty($this->CONN)) return false;
$conn = $this->CONN;
$results = mysql_query($sql,$conn);
if ((!$results) or (empty($results))) {
mysql_free_result($results);
return false;
}
$count = 0;
$data = array();
while ($row = mysql_fetch_array($results)) {
$data[$count] = $row;
$count++;
}
mysql_free_result($results);
return $data;
}
// insert SQL function
// INPUT: $sql, the SQL statement submitted.
// RETURN: the inserted item ID OR false
function insert($sql="")
{
if (empty($sql)) return false;
if (empty($this->CONN)) return false;
$conn = $this->CONN;
$results = mysql_query($sql,$conn);
if (!$results) return false;
$results = mysql_insert_id();
return $results;
}
// update SQL function
// INPUT: $sql, the SQL statement submitted.
// RETURN: true OR false
function update($sql="")
{
if(empty($sql)) return false;
if(empty($this->CONN)) return false;
$conn = $this->CONN;
$result = mysql_query($sql,$conn);
return $result;
}
// delete SQL function
// INPUT: $sql, the SQL statement submitted.
// RETURN: true OR false
function delete($sql="")
{
if(empty($sql)) return false;
if(empty($this->CONN)) return false;
$conn = $this->CONN;
$result = mysql_query($sql,$conn);
return $result;
}
}
// End Class
?>
在调用这个类时他们都是抽象的操作
怎么样可以在调用是得到具体信息呢?
<?php
require("dbsql.inc");
$db=new DBSQL($DBName);
$sql="select * from feifei";
$out=$db->select($sql);
return $out;
?>
怎么它是没有显示呢?
怎么样可以让它显示具体的内容
------
回复此文章 |
果然是高手,佩服!
------
回复此文章 |
我们的问题都能得到回答谢谢
$name=$out[0]["name"];
echo $name;'
out[0][“name'];
"name"是字段名,
那么”0“是数组序号了
对不对
// The basic DB SQL operation Class
// V 1.0
// By Xiao Gang. searchware@sina.com
// 2000.05.22
require ("config.php");
Class DBSQL
{
var $CONN = "";
var $USER = UserName;
var $PASS = PassWord;
var $SERVER = ServerName;
// added by hofman
# var $DBName = DBName;
// the constructor
function DBSQL($DBName)
{
$user = $this->USER;
$pass = $this->PASS;
$server = $this->SERVER;
$dbase = $DBName;
$conn = mysql_connect($server,$user,$pass);
if(!$conn) {
$msg = "数据库连接失败!请检查系统设置。";
include("err.php3");
exit;
}
if(!mysql_select_db($dbase,$conn)) {
$msg = "数据库 $DBName 选择失败!请检查系统设置。";
include("err.php3");
exit;
}
$this->CONN = $conn;
return true;
}
// SQL function to MySQL databases
// select SQL function
// INPUT: $sql, the SQL statement submitted.
// RETURN: the selected results in an array OR false
function select($sql="")
{
if (empty($sql)) return false;
if (empty($this->CONN)) return false;
$conn = $this->CONN;
$results = mysql_query($sql,$conn);
if ((!$results) or (empty($results))) {
mysql_free_result($results);
return false;
}
$count = 0;
$data = array();
while ($row = mysql_fetch_array($results)) {
$data[$count] = $row;
$count++;
}
mysql_free_result($results);
return $data;
}
// insert SQL function
// INPUT: $sql, the SQL statement submitted.
// RETURN: the inserted item ID OR false
function insert($sql="")
{
if (empty($sql)) return false;
if (empty($this->CONN)) return false;
$conn = $this->CONN;
$results = mysql_query($sql,$conn);
if (!$results) return false;
$results = mysql_insert_id();
return $results;
}
// update SQL function
// INPUT: $sql, the SQL statement submitted.
// RETURN: true OR false
function update($sql="")
{
if(empty($sql)) return false;
if(empty($this->CONN)) return false;
$conn = $this->CONN;
$result = mysql_query($sql,$conn);
return $result;
}
// delete SQL function
// INPUT: $sql, the SQL statement submitted.
// RETURN: true OR false
function delete($sql="")
{
if(empty($sql)) return false;
if(empty($this->CONN)) return false;
$conn = $this->CONN;
$result = mysql_query($sql,$conn);
return $result;
}
}
// End Class
?>
在调用这个类时他们都是抽象的操作
怎么样可以在调用是得到具体信息呢?
<?php
require("dbsql.inc");
$db=new DBSQL($DBName);
$sql="select * from feifei";
$out=$db->select($sql);
return $out;
?>
怎么它是没有显示呢?
怎么样可以让它显示具体的内容
------
回复此文章 |
果然是高手,佩服!
------
回复此文章 |
我们的问题都能得到回答谢谢
$name=$out[0]["name"];
echo $name;'
out[0][“name'];
"name"是字段名,
那么”0“是数组序号了
对不对
hofman
2005-11-19 22:49:06
评论:0
阅读:513
引用:0
