DIV CSS 佈局教程網

Ajax 提交表單數據並入庫的完整操作流程(PHP)
編輯:AJAX基礎知識     

在 PHP 項目中對數據庫做寫入操作時,若未做好防 SQL 注入處理,容易引發各種不可預知的錯誤。本文以一個註冊表單為例,完整演示從前端 Ajax 提交到後端入庫的全流程。

一、註冊頁面 index.htm

<form action='_process.php' method='post' enctype='multipart/form-data'>
  <input type='text' id='name' name='name' />
  <input type='text' id='ages' name='ages' />
  <input type='password' id='password' name='password' />
  <input type='text' id='addr' name='addr' />
  <input type='text' id='email' name='email' />
  <input type='button' value='register' id="but"/>
</form>
<span id='msg' style='display:none'>正在加載...</span>
<p id="result"></p>

<script type='text/javascript'>
$("#but").click(function(){
    var name  = $.trim($("#name").val());
    var ages  = $.trim($("#ages").val());
    var pn    = /^\d+$/;
    var addr  = $.trim($("#addr").val());
    var pass  = $.trim($("#password").val());
    var email = $.trim($("#email").val());
    var reg   = /^[a-zA-Z0-9_]+@[a-zA-Z0-9_]+(\.[a-zA-Z]+)+$/;

    if(name.length == 0){ alert("請認真填寫姓名!"); return false; }
    if(ages.length == 0){ alert("請填寫年齡!"); return false; }
    if(!pn.test(ages)){ alert("請填寫有效數字!"); return false; }
    if(pass.length == 0 || pass.length > 6){ alert("請認真填寫密碼!"); return false; }
    if(addr.length == 0){ alert("請認真填寫地址!"); return false; }
    if(!reg.test(email)){ alert("電子郵件檢測失敗"); return false; }

    var send = {'name':name,'ages':ages,'pass':pass,'addr':addr,'email':email};
    $.post('_process.php', send, function(data){
        if(data.res == -1){ $("#result").addClass("error"); }
        $("#result").html(data.msg);
    }, 'json');
});
$("#msg").ajaxStart(function(){ $(this).fadeIn(); })
       .ajaxStop(function(){ $(this).fadeOut(); });
</script>

二、後端處理 _process.php

<?php
header('Content-Type:text/html;charset=utf-8');
$conn = mysqli_connect("localhost","root","root","register")
        or die("Unable to connect!".mysqli_connect_error());
mysqli_query($conn, "set names utf8");

$name  = isset($_POST['name'])?mysqlQuotes(trim($_POST['name'])):'';
$ages  = isset($_POST['ages'])?intval(trim($_POST['ages'])):'';
$pass  = isset($_POST['pass'])?mysqlQuotes(trim($_POST['pass'])):'';
$addr  = isset($_POST['addr'])?mysqlQuotes(trim($_POST['addr'])):'';
$email = isset($_POST['email'])?mysqlQuotes(trim($_POST['email'])):'';

if(empty($name)){ echo json_encode(array('res'=>-1,'msg'=>'請您認真輸入姓名')); exit; }

// 判斷用戶名是否已存在
$sql0 = "select count(1) as nums from tb_register where username='{$name}'";
$row0 = select_one($conn, $sql0);
if($row0['nums'] >= 1){
    echo json_encode(array('res'=>-1,'msg'=>'對不起,該用戶名已被注冊!')); exit;
}
if(!preg_match("/^\d+$/", $ages)){ echo json_encode(array('res'=>-1,'msg'=>'請輸入合法的數字')); exit; }
if(!preg_match("/^[a-zA-Z0-9_]+@[a-zA-Z0-9_]+(\.[a-zA-Z]+)+$/", $email)){
    echo json_encode(array('res'=>-1,'msg'=>'您的郵箱格式不正確')); exit;
}

$add_day = date("YmdHis");
$sql = "insert into tb_register set username='{$name}',ages='{$ages}',"
     . "password='{$pass}',address='{$addr}',email='{$email}',add_day='{$add_day}'";
mysqli_query($conn, $sql);
echo json_encode(array('res'=>1,'msg'=>'恭喜你,注冊成功!'));
exit;

// 防注入處理
function mysqlQuotes($content){
    if(!get_magic_quotes_gpc()){
        $content = addslashes($content);
    }
    return stripslashes(htmlspecialchars($content));
}

function select_one($conn, $sql){
    $res = mysqli_query($conn, $sql) or die("Failed".mysqli_error());
    $result = array();
    if(!empty($res)){ $result = mysqli_fetch_assoc($res); }
    mysqli_free_result($res);
    return $result;
}
?>

關鍵函數說明

  • addslashes:給單引號、雙引號、反斜槓、NULL 等特殊字符加反斜槓轉義。
  • htmlspecialchars:把 &、"、'、<、> 等特殊字符轉為 HTML 實體。
  • stripslashes:刪除 addslashes 添加的反斜槓,還原數據原貌。

更好的做法是在源頭用參數化查詢(如 PDO/MySQLi 預處理語句)來防注入,這比手工轉義更安全可靠。

XML學習教程| jQuery入門知識| AJAX入門| Dreamweaver教程| Fireworks入門知識| SEO技巧| SEO優化集錦|
Copyright © DIV+CSS佈局教程網 All Rights Reserved