<?php
//数据库modelclass Person{
var $name;
var $age;
function __construct($name,$age){
$this->name=$name;
$this->age=$age;
}
}
//$sql="insert into db_person (id,name,sex,address)values('a','b','c','d')";
$sql1="insert into db_person (";
$sql2=")values(";
$sql3=")";
$p1=new Person("aaaaa",'a');
//实例化model成字符串
$str= json_encode($p1);
//去除 前后 {}
$newstr = substr($str,1,strlen($str)-2);
// " 替代成 '
$newstr=str_replace("\"","'",$newstr);
echo $newstr;
//字符串转化成array
$strarray=explode(",",$newstr);
echo end($strarray);
var_dump($strarray);
//遍历字符串
foreach ($strarray as $key => $value) {
//取出键跟值
$inarray=explode(":",$value);
//echo $inarray[0]."||".$inarray[1];
//在键值后加, 最后一个不加
if(end($strarray)==$value){
$sql1.=$inarray[0];
$sql2.=$inarray[1];
}else{
$sql1.=$inarray[0].",";
$sql2.=$inarray[1].",";
}
}
//去掉value 前 sql 中的 '并输出
echo str_replace("'","",$sql1).$sql2.$sql3;
?>