PHP如何從頁面插入資料庫的範例程式碼詳解

PHP頁面

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

 

#

以上是PHP如何從頁面插入資料庫的範例程式碼詳解的詳細內容。更多資訊請關注PHP中文網其他相關文章！