分享个人信息资料等等的数据库存储方式解决方案

分享个人信息资料等等的数据库存储方式

PHP code

<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

--><?php class 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 code

<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->
    
        <title>welcome YouYaX</title>
        <style>
         .tdclass{border-bottom:1px dashed #ff0000}
        </style>
    
    
    <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>
    

登入後複製