根據 Mysql 裡的字段 自動生成 類文件：
但需要導入：
require_once ./db/ez_sql_core.php;
require_once ./db/ez_sql_mysql.php;
幫助文檔：http://jvmultimedia.com/docs/ezsql/ez_sql_help.htm
上圖 ：
核心代碼:
復制代碼 代碼如下:
<?php
class db{
/**********************************************************************
* Author: fangjun ([email protected])
* Name..: PHP_For_MySQL_Helper v1.0
* Desc..: 自動生成數據庫操作類
* Date..: 2011-7-22
/**********************************************************************/
private $db_server = 'localhost';
private $db_username = 'root';
private $db_password = '';
private $primary_key = null;
//初始化
public function __construct(){
$this->db_conn = mysql_connect($this->db_server,$this->db_username,$this->db_password) or die('Error:'.mysql_error());
}
//返回所以的數據庫名稱
public function db_list(){
$databasename = array();
$i=0;
$list = mysql_list_dbs($this->db_conn);
while ($row = mysql_fetch_object($list)) {
$databasename[$i] = $row->Database;
$i++;
}
mysql_close();
return $databasename;
}
//返回所以的數據庫名稱
public function table_list($databasename){
$tablename = array();
$i=0;
$result = @mysql_list_tables($databasename);
while($row = mysql_fetch_array($result,MYSQL_NUM)){
$tablename[$i] = $row[0];
$i++;
}
mysql_free_result($result);
mysql_close();
return $tablename;
}
//返回表裡的字段
public function field_list($databasename,$tablename){
$fieldname = array();
$v = 0;
mysql_select_db($databasename,$this->db_conn);
$rel = mysql_query("select * from ".$tablename);
for($i=0;$i<mysql_num_fields($rel);$i++){
$meta = mysql_fetch_field($rel);
if($meta){
if($meta->primary_key==1){
$this->primary_key = $meta->name;
}else{
$fieldname[$v] = $meta->name;
$v++;
}
}
}
mysql_close();
return $fieldname;
}
public function showclass($databasename,$tablename){
$field = $this->field_list($databasename,$tablename);
$this->primary_key;
$key = null;
$val = null;
$sql = null;
$tmp = null;
$html = '////////////////////////////////////<br/>';
$html = $html.'//使用方法<br/>';
$html = $html.'// 導入<br/>';
$html = $html.'// ez_sql：http://jvmultimedia.com/docs/ezsql/ez_sql_help.htm';
$html = $html.'// require_once \'./db/ez_sql_core.php;<br/>';
$html = $html.'// require_once \'./db/ez_sql_mysql.php;<br/>';
$html = $html.'// $db = new ezSQL_mysql($cfg_db_user,$cfg_db_pass,$cfg_db_name,$cfg_db_host);<br/>';
$html = $html.'// $db->query(\'set names utf8\');<br/>';
$html = $html.'// 調用<br/>';
$html = $html.'// $forum = new Forum($db);<br/>';
$html = $html.'// $forum->save($Posts);<br/>';
$html = $html.'////////////////////////////////////<br/><br/><br/>';
$html = $html.'// 作者:<br/>';
$html = $html.'// 備注:<br/>';
$html = $html.'// 創建
代碼打包下載
