PHP mysql::process_str示例

<?php

/**
 * Created by PhpStorm.
 * User: wb.dengxiaohui
 * Date: 2016/3/31
 * Time: 15:20
 */
require_once 'mysql.php';
$db = new mysql("localhost", "root", "asd123", "website");
$salt = "abc123";
$login_username = $db->process_str($_POST["login_username"]);
$login_password = md5($db->process_str($_POST["login_password"]) . $salt);
if ($db) {
    $conn = $db->connect_mysql();
    if ($conn) {
        $sql_login_select = "SELECT password From user WHERE username = '******'";
        $select_login_result = $db->query($conn, $sql_login_select);
        $login_row = mysqli_fetch_array($select_login_result, MYSQLI_ASSOC);
        if ($login_row["password"] == $login_password) {
            $lifeTime = 24 * 3600;
            session_set_cookie_params($lifeTime);
            session_start();
            $_SESSION["state"] = 1;
            $_SESSION["username"] = $login_username;
            setcookie(session_name(), session_id(), time() + $lifeTime, "/");
            mysqli_free_result($select_login_result);
            $db->close_db($conn);
            echo "1";
        } else {
            mysqli_free_result($select_login_result);

示例#2

显示文件

文件： register.php 项目： icenewman/project

<?php

/**
 * Created by PhpStorm.
 * User: trinity
 * Date: 2016/2/28
 * Time: 23:03
 */
require_once 'mysql.php';
/**创建数据库类 **/
$db = new mysql("localhost", "root", "asd123", "website");
/**处理Post数据安全 **/
$salt = "abc123";
$register_username = $db->process_str($_POST["register_username"]);
$register_password = md5($db->process_str($_POST["register_password"]) . $salt);
$register_email = $db->process_str($_POST["register_email"]);
$register_time = $_SERVER['REQUEST_TIME'];
/**开始注册逻辑 **/
if ($db) {
    $conn = $db->connect_mysql();
    if ($conn) {
        $sql_rigister_select = "SELECT * From user WHERE username = '******'";
        $select_rigister_result = $db->query($conn, $sql_rigister_select);
        $row = mysqli_fetch_array($select_rigister_result, MYSQLI_ASSOC);
        if (!$row) {
            $sql_insert = "INSERT INTO  user(username,password,register_time,email) VALUES('{$register_username}','{$register_password}','{$register_time}','{$register_email}')";
            if ($db->query($conn, $sql_insert)) {
                $db->close_db($conn);
                mysqli_free_result($select_rigister_result);
                echo "1";
            }

示例#3

显示文件

文件： check_username.php 项目： icenewman/project

<?php

/**
 * Created by PhpStorm.
 * User: wb.dengxiaohui
 * Date: 2016/4/8
 * Time: 16:42
 */
require_once 'mysql.php';
/**创建数据库类 **/
$db = new mysql("localhost", "root", "asd123", "website");
/**处理Post数据安全 **/
$register_username = $db->process_str($_POST["register_username"]);
if ($db) {
    $conn = $db->connect_mysql();
    if ($conn) {
        $sql_rigister_select = "SELECT * From user WHERE username = '******'";
        $select_rigister_result = $db->query($conn, $sql_rigister_select);
        $row = mysqli_fetch_array($select_rigister_result, MYSQLI_ASSOC);
        if (!$row) {
            $db->close_db($conn);
            mysqli_free_result($select_rigister_result);
            echo 1;
        } else {
            $db->close_db($conn);
            mysqli_free_result($select_rigister_result);
            echo 0;
        }
    }
}