php+mysql代码生成器 1.0绿色免费版

php+mysql代码生成器做的内容就是剩掉你写sql语句的时间 有显示,插入,修改,删除,还有显示的表格和添加修改的表单! 下载后把MakeCode.exe.config里的用名和密码改成你本地的!就可以简单的生成! 里面用到的mysql类,还有sql语句中的函数,都在其它代码中if($_POST['id']==''){//INSEART$InsertSQL = sprintf(INSEART INTO cuku_faqcat (`catname`,`list`,`cont`) VALUES (%s ,%s ,%s ),GetSQLValueString($_POST['catname'],text),GetSQLValueString($_POST['list'],int),GetSQLValueString($_POST['cont'],text));$db-query($InsertSQL);}else{//UPDATE$UpdateSQL = sprintf(UPDATE cuku_faqcat SET `catname`= %s, `list`= %s, `cont`= %s where `id`= %s),GetSQLValueString($_POST['catname'] ,text),GetSQLValueString($_POST['list'] ,int),GetSQLValueString($_POST['cont'] ,text),GetSQLValueString($_POST['id'],int));$db-query($UpdateSQL); }//生成时用到的函数function GetSQLValueString($theValue, $theType, $theDefinedValue = , $theNotDefinedValue = ) {$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;$theValue = function_exists(mysql_real_escape_string) ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);switch ($theType) {case text:$theValue = ($theValue != ) ? ' . $theValue . ' : NULL;break;case long:case int:$theValue = ($theValue != ) ? intval($theValue) : NULL;break;case double:$theValue = ($theValue != ) ? ' . doubleval($theValue) . ' : NULL;break;case date:$theValue = ($theValue != ) ? ' . $theValue . ' : now();break;case defined:$theValue = ($theValue != ) ? $theDefinedValue : $theNotDefinedValue;break;case sqltable:$theValue = ($theValue != ) ? $theValue : die(NULL Table);break;}return $theValue;}//引入数据库类 include./mysql.php;//声明数据库$db = new Dirver();加上数据库类的写法!

php+mysql代码生成器