How to use
Copy Code code as follows:
$mysql = new Sqlstr ("Table1");
$mysql->set ("name", "value");
$mysql->set ("name", "1", true);
echo $mysql->insertsql ();
Copy Code code as follows:
Class Sqlstr
{
Private $param =array ();
Private $tablename;
function Sqlstr ($tablename)
{
$this->tablename = $tablename;
}
Public function set ($name, $value, $isnum =false) {
$value = Str_replace ("'", "" ", $value);
$this->param[$name]=array ($value, $isnum);
}
Public Function Insertsql () {
$keys = "";
$values = "";
foreach ($this->param as $key => $value) {
$keys = $keys. $key. ",";
if ($value [1]) {
$values = $values. $value [0]. ",";
}else{
$values = $values. "'" . $value [0]. "',";
}
}
if ($keys!= "") {$keys =substr ($keys, 0,strlen ($keys)-1);
if ($values!= "") {$values =substr ($values, 0,strlen ($values)-1);
Return ' INSERT INTO '. $this->tablename. " ($keys) VALUES ($values) ";
}
Public Function Updatesql ($cond) {
$group = "";
foreach ($this->param as $key => $value) {
$group. = $key. "=";
if ($value [1]) {
$group. = $value [0]. ",";
}else{
$group. = "'". $value [0]. "',";
}
}
if ($group!= "") {$group =substr ($group, 0,strlen ($group)-1);
Return "Update". $this->tablename. "Set $group where." $cond;
}
}