<?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);
<?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"; }
<?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; } } }