php+mysql代码生成器

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();
加上数据库类的写法!