- php基础编程 - 第一次写类,写的不好 - 喜悦国际村

喜悦国际村 » php基础编程 » 第一次写类,写的不好

喜悦证交所已经关闭

上一主题

下一主题

fnet
高级会员
Rank: 4

**村大队书记

UID 65788
精华 0
积分 718
帖子 785
金钱 718 喜悦币
威望 0
人脉 0
阅读权限 50
注册 2005-8-12
状态离线

[广告]: q m

第一次写类,写的不好

<?php
class dataBase
{
var $Link;
var $tableName;
var $dbName;
var $eregResult;
var $query;
var $index;
var $data;
var $field;
var $resultHandle;
//*********connect and struct********

function dataBase($host='localhost',$useName='',$passWord='')
{
$link=mysql_connect($host,$useName,$passWord);
$this->link=$link;
}
//********create database********???

function createDB($dbName)
{
$this->dbName=$dbName;
$query="create database $dbName";
mysql_query($query,$this->link);
}

//********create table********???

function createTable($tableName)
{
$this->tableName=$tableName;
$query="create talbe $tableName ($field)";
mysql_query($query,$this->link);
}

//********use database********

function useDB($dbName='')
{
if($dbName='')
{
$query="use $this->dbName";
mysql_query($this->dbName,$this->link);
}else{
$query="use $dbName";
mysql_query($dbName,$this->link);
}
}

//********add data********

function add($tableName,$data)
{
$this->data=$data;
$this->printData($this->data);
if(!$tableName){
$query="insert into $this->tableName values ($this->eregResult)";
$this->resultHandle=mysql_query($query,$this->link);
}else{
$query="insert into $tableName values ($this->eregResult)";
$this->resultHandle=mysql_query($query,$this->link);
}
}

//********delete data********

function delete($tableName='',$index='')
{
if($index='' && $tableName='')
{
$query="delete from $this->tableName";
$this->resultHandle=mysql_query($query,$this->link);
}else if($index='' && !$tableName=''){
$query="delete from $tableName";
$this->resultHandle=mysql_query($query,$this->link);
}else if(!$index='' && $tableName=''){
$query="delete from $this->tableName where id=$index";
$this->resultHandle=mysql_query($query,$this->link);
}else{
$query="delete from $tableName where id=$index";
$this->resultHandle=mysql_query($query,$this->link);
}
print $this->printData($this->resultHandle);
}

//********update data********

function upDate($tableName='',$field,$data)
{
$this->data=$data;
$this->field=$field;
$this->printData($this->field);
$field=$this->eregResult;
$this->printData($this->data);
$data=$this->eregResult;
if($tableName=''){
$query="update $this->tableName set ($field) values ($data)";
$this->resultHandle=mysql_query($query,$this->link);
}else{
$query="update $tableName set ($field) values ($data)";
$this->resultHandle=mysql_query($query,$this->link);
}
print $this->printData($this->resultHandle);
}

//********print data********

function printData($value)
{
if($value==$this->resultHandle){
while($result=mysql_fetch_assoc($this->resultHandle)){
while(list($key,$val)=each($result))
{
print $val."<br>";
}
}
}else if($value==$this->data){
$data="";
for($i=1;$i<=count($this->data);$i++)
{
$data.=$this->data[$i].",";
}
$pattern='[,]$';
$this->eregResult=ereg_replace($pattern,"",$data);
}else if($value==$this->field){
$field="";
for($i=1;$i<=count($this->field);$i++)
{
$field.=$this->field[$i].",";
}
$pattern='[,]$';
$this->eregResult=ereg_replace($pattern,"",$field);
}
}

//********show database to web page********

function showDB()
{
$query="SHOW DATABASES";
$this->resultHandle=mysql_query($query,$this->link);
$this->printData($this->resultHandle);
}

//********show table to web page********

function showTable($dbName)
{
if(!$dbName){
$query="show tables from $this->dbName";
$this->resultHandle=mysql_query($query,$this->link);
}else{
$query="show tables from $dbName";
$this->resultHandle=mysql_query($query,$this->link);
}
$this->printData($this->resultHandle);
}

//********show template********

function showTemplate()
{
}
}
?>