Home > Backend Development > PHP Tutorial > Detailed explanation of the sample code of how PHP inserts information from the page to the database

Detailed explanation of the sample code of how PHP inserts information from the page to the database

黄舟
Release: 2023-03-06 15:36:01
Original
2227 people have browsed it

PHP Page

 <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 "添加成功"; 
      }     
     }
Copy after login

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

HTML page

<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>
Copy after login

The above is the detailed content of Detailed explanation of the sample code of how PHP inserts information from the page to the database. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template