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();
加上数据库类的写法!>
下载仅供下载体验和测试学习，不得商用和正当使用。
