PHPFORMYSQL代码生成助手(根据Mysql里的字段自动生成类文件的)_PHP教程

但需要导入：

require_once ./db/ez_sql_core.php;
require_once ./db/ez_sql_mysql.php;

帮助文档：http://jvmultimedia.com/docs/ezsql/ez_sql_help.htm

上图 ：

核心代码:
代码如下:

<br><!--?php <BR-->class db{ <br>/********************************************************************** <br>* Author: fangjun (fangjunai@163.com) <br>* Name..: PHP_For_MySQL_Helper v1.0 <br>* Desc..: 自动生成数据库操作类 <br>* Date..: 2011-7-22 <br>/**********************************************************************/ <br>private $db_server = 'localhost'; <br>private $db_username = 'root'; <br>private $db_password = ''; <br>private $primary_key = null; <br>//初始化 <br>public function __construct(){ <br>$this->db_conn = mysql_connect($this->db_server,$this->db_username,$this->db_password) or die('Error:'.mysql_error()); <br>} <br>//返回所以的数据库名称 <br>public function db_list(){ <br>$databasename = array(); <br>$i=0; <br>$list = mysql_list_dbs($this->db_conn); <br>while ($row = mysql_fetch_object($list)) { <br>$databasename[$i] = $row->Database; <br>$i++; <br>} <br>mysql_close(); <br>return $databasename; <br>} <br>//返回所以的数据库名称 <br>public function table_list($databasename){ <br>$tablename = array(); <br>$i=0; <br>$result = @mysql_list_tables($databasename); <br>while($row = mysql_fetch_array($result,MYSQL_NUM)){ <br>$tablename[$i] = $row[0]; <br>$i++; <br>} <br>mysql_free_result($result); <br>mysql_close(); <br>return $tablename; <br>} <br>//返回表里的字段 <br>public function field_list($databasename,$tablename){ <br>$fieldname = array(); <br>$v = 0; <br>mysql_select_db($databasename,$this->db_conn); <br>$rel = mysql_query("select * from ".$tablename); <br>for($i=0;$i<mysql_num_fields($rel);$i++){ <br="">$meta = mysql_fetch_field($rel); <br>if($meta){ <br>if($meta->primary_key==1){ <br>$this->primary_key = $meta->name; <br>}else{ <br>$fieldname[$v] = $meta->name; <br>$v++; <br>} <br>} <br>} <br>mysql_close(); <br>return $fieldname; <br>} <br>public function showclass($databasename,$tablename){ <br>$field = $this->field_list($databasename,$tablename); <br>$this->primary_key; <br>$key = null; <br>$val = null; <br>$sql = null; <br>$tmp = null; <br>$html = '////////////////////////////////////<br>'; <br>$html = $html.'//使用方法<br>'; <br>$html = $html.'// 导入<br>'; <br>$html = $html.'// ez_sql：http://jvmultimedia.com/docs/ezsql/ez_sql_help.htm'; <br>$html = $html.'// require_once \'./db/ez_sql_core.php;<br>'; <br>$html = $html.'// require_once \'./db/ez_sql_mysql.php;<br>'; <br>$html = $html.'// $db = new ezSQL_mysql($cfg_db_user,$cfg_db_pass,$cfg_db_name,$cfg_db_host);<br>'; <br>$html = $html.'// $db->query(\'set names utf8\');<br>'; <br>$html = $html.'// 调用<br>'; <br>$html = $html.'// $forum = new Forum($db);<br>'; <br>$html = $html.'// $forum->save($Posts);<br>'; <br>$html = $html.'////////////////////////////////////<br><br><br>'; <br>$html = $html.'// 作者:<br>'; <br>$html = $html.'// 备注:<br>'; <br>$html = $html.'// 创建时间:'.date('Y-m-d H:i:s').'<br>'; <br>$html = $html.'<pre class="layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li> class '.$tablename.'{<br>'; <br>$html = $html.'<br>'; <br>$html = $html.' private $db'; <br>$html = $html.'<br>'; <br>$html = $html.'<br>'; <br>$html = $html.' //实例化 <br>'; <br>$html = $html.' public function '.$tablename.'($db){<br>'; <br>$html = $html.' $this->db = $db;<br>'; <br>$html = $html.' }<br>'; <br>$html = $html.'<br>'; <br>$html = $html.' //保存记录<br>'; <br>$html = $html.' public function save($arry){<br>'; <br>for($i=0;$i<count($field);$i++){ <br="">$key = $key.$field[$i].','; <br>$val = $val.'\'{$arry['.$field[$i].']}\','; <br>} <br>$sql = "\"insert into ".$tablename." (".rtrim($key,",").")values(".rtrim($val,",").")\""; <br>$html = $html.' $sql='.$sql.';<br>'; <br>$html = $html.' return $this->db->query($sql);<br>'; <br>$html = $html.' }<br>'; <br>$html = $html.'<br>'; <br>$html = $html.' //根据主键更新记录 <br>'; <br>$html = $html.' public function update($arry){<br>'; <br>for($i=0;$i<count($field);$i++){ <br="">$tmp = $tmp.$field[$i].'=\'{$arry['.$field[$i].']}\','; <br>} <br>$sql = "\"update ".$tablename." set ".rtrim($tmp,",")." where ".$this->primary_key.'=".$arry['.$this->primary_key.']'; <br>$html = $html.' $sql='.$sql.';<br>'; <br>$html = $html.' return $this->db->query($sql);<br>'; <br>$html = $html.' }<br>'; <br>//PostID='{$Posts['PostID']}'"; <br>$html = $html.'<br>'; <br>$html = $html.' //根据主键删除记录 <br>'; <br>$html = $html.' public function delete($'.$this->primary_key.'){<br>'; <br>$sql = "\"delete from ".$tablename." where ".$this->primary_key."=\".$".$this->primary_key; <br>$html = $html.' $sql='.$sql.';<br>'; <br>$html = $html.' return $this->db->query($sql);<br>'; <br>$html = $html.' }<br>'; <br>$html = $html.'<br>'; <br>$html = $html.' //根据主键查询一条记录 <br>'; <br>$html = $html.' public function getQueryById($'.$this->primary_key.'){<br>'; <br>$sql = "\"select * from ".$tablename." where ".$this->primary_key."=\".$".$this->primary_key; <br>$html = $html.' $sql='.$sql.';<br>'; <br>$html = $html.' return $this->db->get_row($sql);<br>'; <br>$html = $html.' }<br>'; <br>$html = $html.'<br>'; <br>$html = $html.' //查询全部记录 <br>'; <br>$html = $html.' public function getQuery(){<br>'; <br>$sql = "\"select * from ".$tablename."\""; <br>$html = $html.' $sql='.$sql.';<br>'; <br>$html = $html.' return $this->db->get_results($sql);<br>'; <br>$html = $html.' }<br>'; <br>$html = $html.'<br>'; <br>$html = $html.'<br>'; <br>$html = $html.'}</count($field);$i++){></count($field);$i++){></li></ol></pre>'; <br>echo $html; <br>} <br>} <br>?> <br> <br> <br> <br><meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <br><title> PHP For MySQL Helper v1.0 </title> <br><style> <BR>body{ font-size:14px;} <BR>h3{ padding:0px; margin:0px; background-color:#333; color:#FFF;font-size:14px; } <BR>.dblist,.tablelist,.show{width:100%;padding:10px 0;} <BR>a:link {} <BR>a:hover {color:#F00} <BR></style> <br> <br> <br><!--?php <BR-->ini_set('default_charset', 'utf-8'); <br>echo ''; <br>echo '<h3>请选择数据库</h3>'; <br>//----------------------------------- <br>$DB = new db(); <br>$dblist = $DB->db_list(); <br>for ($row=0;$row<count($dblist);$row++){ <br="">echo ''.$dblist[$row].'<br>'; <br>} <br>//----------------------------------- <br>echo ''; <br>echo ''; <br>echo '<h3>请选择表</h3>'; <br>//----------------------------------- <br>if(isset($_GET['databasename'])){ <br>$databasename = $_GET['databasename']; <br>$DB = new db(); <br>$tablelist = $DB->table_list($databasename); <br>for ($i=0;$i<count($tablelist);$i++){ <br="">echo ''.$tablelist[$i].'<br>'; <br>} <br>} <br>//----------------------------------- <br>echo ''; <br>echo ''; <br>echo '<h3>自动生成数据类</h3>'; <br>//----------------------------------- <br>if(isset($_GET['databasename'])&& isset($_GET['tablename'])){ <br>$databasename = $_GET['databasename']; <br>$tablename = $_GET['tablename']; <br>$DB = new db(); <br>$DB->showclass($databasename,$tablename); <br>} <br>//----------------------------------- <br>echo ''; <br>?> <br> <br> <br><br>代码打包下载<p></p>
<p></p>
<p align="left"><span id="url" itemprop="url">http://www.bkjia.com/PHPjc/323915.html</span><span id="indexUrl" itemprop="indexUrl">www.bkjia.com</span><span id="isOriginal" itemprop="isOriginal">true</span><span id="isBasedOnUrl" itemprop="isBasedOnUrl">http://www.bkjia.com/PHPjc/323915.html</span><span id="genre" itemprop="genre">TechArticle</span><span id="description" itemprop="description">根据 Mysql 里的字段 自动生成 类文件： 但需要导入： require_once ./db/ez_sql_core.php; require_once ./db/ez_sql_mysql.php; 帮助文档：http://jvmultimedia.com...</span></p>
                    </count($tablelist);$i++){></count($dblist);$row++){></mysql_num_fields($rel);$i++){>