分享个人信息资料等等的数据库存储方式
<?phpclass IndexAction extends YouYaX{ public function index() { header("Content-type: text/html; charset=utf-8"); //查询出二维数组 $data=$this->select("select info from personal_info"); $dat=array(); foreach($data as $v) { $tmp=unserialize($v['info']); $tmp[2]=$tmp[2]=="0"?"男":"女"; $dat[]=$tmp; } $this->assign('data',$dat); $this->display("index.html"); } public function Adds(){ $arr[]=$_POST['per_name']; $arr[]=$_POST['per_age']; $arr[]=$_POST['per_sex']; $data['info']=serialize($arr); $this->add($data,"personal_info"); $this->redirect("Index/index"); }}?>
<html> <head> <title>welcome YouYaX</title> <style> .tdclass{border-bottom:1px dashed #ff0000} </style> </head> <body> <center> <form action="__APP__/Index/Adds" method="post"> <table width=800 > <tr> <td colspan=2>个人资料</td> </tr> <tr> <td>姓名</td><td><input name="per_name"></td> </tr> <tr> <td>年龄</td><td><input name="per_age"></td> </tr> <tr> <td>性别</td><td><input type="radio" name="per_sex" value="0">男 <input type="radio" name="per_sex" value="1">女</td> </tr> <tr> <td colspan=2><input type="submit" name="sub" value="保存"></td> </tr> </table> </form> <hr> <table width=800 style="background:#f8f8f8"> <tr><td>姓名</td><td>年龄</td><td>性别</td></tr> <list> <tr> <td class="tdclass">{data.0}</td> <td class="tdclass">{data.1}</td> <td class="tdclass">{data.2}</td> </tr> </list> </table> </center> </body></html>