如何从页面向数据库插入信息（PHP实例）

PHP页面

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<?php
//初始化act
$_REQUEST['act']=$_REQUEST['act']?$_REQUEST['act']:'';
if($_REQUEST['act']=='add'){
 include 'templates/zhiliang_add.php';
 }elseif($_REQUEST['act']=='insert'){       //文件上传  
     //var_dump($new_file_name);
     $title=$_POST['title'];
     $content=$_POST['content'];
     $time=$_POST['time'];
     include 'db.class.php';
     $db=new db('localhost','root','123','fanyi');
     $sql="insert into zhiliang values(null,'$title','$content','$time')";
     if(mysql_query($sql)){
       echo "添加成功"; 
      }     
     }

 

--------------------------------------------------------------------------------------------------------

HTML页面

<form method="post" action="zhiliang.php" name="theForm" enctype="multipart/form-data" onsubmit="return validate()">
<table cellspacing="1" cellpadding="3" width="100%">
  <tr>
    <td class="label">标题</td>
    <td><input type="text" name="title" maxlength="60" value="" /><span class="require-field">*</span></td>
  </tr>
  <tr>
    <td class="label">时间</td>
    <td><input type="text" name="time" maxlength="60" size="40" value="" /></td>
  </tr>
   <tr>
    <td class="label">文章内容</td>
    <td><textarea  name="content" cols="60" rows="4"  ></textarea></td>
  </tr>
 
  <tr>
    <td colspan="2" align="center"><br />
      <input type="submit" class="button" value=" 确定 " />
      <input type="reset" class="button" value=" 重置 " />
    </td>
  </tr>
</table>
</form>