ECshop--数据库模块细究

早上交任务的时候又被老大批了一顿

$fieldsValue = array("id"=>"98","type"=>"uuu","id"=>"66","type"=>"iii");

话说能写出这样代码的人也真是人才，回头想想确实啊，想想自己都觉得好笑，
，哎，反正脸皮够厚，无所谓，能多学一点是一点，实习生就是各种挨锅。

总结下昨天的任务:
昨天把整个ecshop后面的数据库模块整理了下，对应的文件在include/cls_mysql.php下，仿照ecshop的getAll、getOne、getCol、insert、update、delete方法，自己改写测试了几遍，下面是测试的几个方法

<?php

header("Content-type:text/html;charset=utf-8");

include './conn.php';
include_once './config.php';

class Mysql {
	
	private $host;
	private $user;
	private $pwd;
	private $dbName;
	private $charset;
	private $conn = null;
	
	private $queryCount = 0;
	private $queryTime = '';
	private $queryLog = array();
	private $serviceStart = 0;
	private $errorMessage = array();

	
	public function connect($h, $u, $p, $n) {
		
		//提示PHP版本
		//判定数据库连接
		$conn = mysql_connect($h, $u, $p);
		mysql_select_db($n, $conn);
		$serviceStart = time();
		$this -> conn = $conn;
	}
	
	function query($sql) {
		
		//echo $this->conn;
		if($this->conn === NULL) {//连接
			
			$this->connect($host, $user, $pwd);
			echo "连接成功";
			
		}
		
		if($this->queryCount++ <= 99) {//查询次数自增，记录查询sql
			
			$this->queryLog[] = $sql;
			
		}
		
		if($this->queryTime == '') {//记录查询时间
			
			$this->queryTime = microtime(TRUE);
			
		}
		
		if($this->serviceStart +1 < time()) {
			
			mysql_ping();//重新连接
			
		}
		
		//var_dump($sql);
		//$queryValue = mysql_query($sql);
		
		if( !( $queryValue = mysql_query($sql) ) ) {//查询操作
		
			$this->errorMessage[] = mysql_error();
			
			//echo "1";
			return FALSE;
		}
		//var_dump($queryValue);
		return $queryValue;
	}

	
	
	/*public function deleteAssign($tableName,$index,$value) {
		
		$sql = "delete from ".$tableName." where ".$index." = ".$value;
		
		echo "<br>******************************<br>";
		echo $sql;
		echo "<br>******************************<br>";
		$result = mysql_query($sql);
		
		return mysql_affected_rows();
		
	}*/
	
	function selectLimit($sql, $num, $start = 0) {
		
		if($start == 0) {
			
			$sql .= " limit ".$num;
			
		}
		else {
			
			$sql .= " limit " . $start . "," . $num;
			
		}
		
	} 
	
	public function delete($tableName) {
		
		$sql = "delete from ".$tableName;
		
		echo "<br>******************************<br>";
		echo $sql;
		echo "<br>******************************<br>";
		$result = mysql_query($sql);
		
		return mysql_affected_rows();
		
	}
	
	/*public function update($tableName,$updateIndex,$updateValue,$index,$value) {
		
		$where = "";
		if($index != ""&&$value != "")
			$where = " where ".$index." = '".$value."'";
		
		$sql = "update ".$tableName." set ".$updateIndex." = '".$updateValue."'".$where;
		echo "<br>******************************<br>";
		echo $sql;
		echo "<br>******************************<br>";
		$result = mysql_query($sql);
		
		return mysql_affected_rows();	
		
	}*/

	public function getCol($sql){
		
		$result = $this->query($sql);
		
		//echo $result;
		
		if($result !== false) {
			
			$value = array();
			
			while($row = mysql_fetch_row($result)) {
				
				$value[] = $row[0];
				
			}
			//echo "yes";
			return $value;
		}
		else {
			//echo "no";
			return false;
		}
	
	}

	public function close() {
		mysql_close($this -> conn);
	}

	public function getOne($sql, $limited = false) {
		
		/*$sql = "select * from ".$tableName;
		$result = mysql_query($sql);
		echo "<br>******************************<br>";
		echo $sql;
		echo "<br>******************************<br>";
		return mysql_fetch_assoc($result);*/
		
		if($limited) {//限制取第一条记录
			
			$sql = trim($sql.' limit 1 ');
			
		}
		
		$result = $this->query($sql);
		
		if($result !== false) {
			
			$getIndex = mysql_fetch_row($result);//取得当前result首行记录，以index访问
			
			//var_dump($getIndex[2]);
			
			return $getIndex==true?$getIndex[0]:'';//0：取值第一个字段属性
			
		}
		else {
			//var_dump("123");
			return false;
		}
		
	}

	function getAll($sql) {
	
		//$tableName = "user";
		//$sql = "select * from ".$tableName;
		//$result = mysql_query($sql);
		/*echo "<br>******************************<br>";
		echo $sql;
		echo "<br>******************************<br>";*/
		
		$result = $this->query($sql);
		$values = array();
		
		if($result !== false) {
				
			
			while ($row = mysql_fetch_array($result)) { //循环获取所有值
					
				$values[] = $row; //获得当前行的值，然后添加到values数组中
		
			}
			return $values;
		}
		else {
			
			return false;
			
		}

		return $values;
	}
	
	//insert into ecs_nav (id,type)
	//value (99,'123')
	
	function insert($table, $fieldsValue) {
		
		$allFieldName = $this->getCol("desc ".$table);//获取所有字段
		
		
		//var_dump($allFieldName);
		$sql = "";
		$fields = $values = array(); //设定两个数组，field数组存放要插入数据的字段属性
		                             //values数组存放插入数据字段对应的值
		foreach ($allFieldName as $fieldName) {
			
			if(array_key_exists($fieldName, $fieldsValue) == true) { //查找传入的value数组，通过键值和字段name数组匹配
				 
					$fields[] = $fieldName;         //属性字段注入临时数组
					$values[] = "'" . $fieldsValue[$fieldName] . "'"; //属性值注入
				
				}
			}
			
			var_dump($values);
			
			if(empty($fields) == false) {       //判定临时存放字段数组非空
				
				$sql = "insert into " . $table . "(" . implode(', ', $fields) .  //implode拼装fields字符串
				") values (" . implode(", ", $values) . ")";
			}
			
			echo $sql;
			
			if($sql)
				return $this->query($sql)?"<br>insert OK<br>":"<br>insert error<br>";
		
		
	}
	
	function update($table, $fieldValues, $where = "") {  //where更新条件
		
		$allFieldName = $this->getCol("desc ".$table);
		
		$sql = "";
		$sets = array();
		
		foreach ($allFieldName as $fieldName) {
			
			if(array_key_exists($fieldName, $fieldValues) == true) { //拼装set语句
				
				$sets[] = $fieldName . " = '" . $fieldValues[$fieldName] . "'";
				
			}
			
			if(empty($sets) == false) {
				
				$sql = "update " . $table . " set " . implode(", ", $sets) . " where " . $where;
				
			}
			
			if($sql) 
				
				return $this->query($sql)?"<br>update OK<br>":"<br>update error<br>";
			
			
		}
		
		
	}
	
	
}


?>

之前是看网上给的一些，写了一堆，然后被老大喷了一顿，囧

测试文件打包

http://download.csdn.net/detail/k183000860/9570069