PHP代码片收藏

今天还有同学问到php mysql部分，写了一点经常用到的，不能浪费时间嘛，凑一片博客吧

//插入用户信息
<?php
$response = array();
require("db_config.php");
$conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password) ordie("error connecting") ;
mysql_query("set names 'utf8'"); 
mysql_select_db($mysql_database);
if (isset($_GET['user_id']) &&isset($_GET['user_password'])) {
    $id = $_GET['user_id'];
    $pwd = $_GET['user_password'];
    $result = "INSERT INTO userinfo(user_id, user_password) VALUES('$id', '$pwd', '$end')";
    $re=mysql_query($result);
    if($re){
        //echo "插入数据成功";
        $rs['result'] ='0';
        $rs['msg'] ="数据插入成功";
        echo json_encode($rs);
    }
}
?>
//确认用户是否存在
<?php
    $response = array();
    require("db_config.php");
    $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password) ordie("error connecting") ;
    mysql_query("set names 'utf8'");
    mysql_select_db($mysql_database);
    if (isset($_GET['user_id'])) {
        $id = $_GET['user_id'];
        $sql="select * from userinfo where user_id='$id'";
        $result = mysql_query($sql);
        $data = mysql_num_rows($result);
        if ($data){
            $response["success"] =0;
            $response["message"] ="NO";
            echo json_encode($response);
        }
        else{
            $response["success"] =1;
            $response["message"] ="YES";
            echo json_encode($response);
        }
        
    }
?>
//验证登录密码是否正确
<?php
    $response = array();
    require("db_config.php");
    $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password) ordie("error connecting") ;
    mysql_query("set names 'utf8'");
    mysql_select_db($mysql_database);
    if (isset($_GET['user_id'])&&isset($_GET['user_password'])) {
        $id = $_GET['user_phone'];
        $user_password = $_GET['user_password'];
        $sql="select user_id,user_password from userinfo where user_id='$id'";
        $result = mysql_query($sql);
        if(!mysql_num_rows($result))
        {
            $response["success"] =0;
            $response["message"] ="用户不存在";
            echo json_encode($response);
        }
        else
        {
            $row=mysql_fetch_assoc($result);
            if($user_password!=$row['user_password'])
            {
                $response["success"] =0;
                $response["message"] ="密码错误";
                echo json_encode($response);
            }
            else
            {
                $response["success"] =1;
                $response["message"] ="登录成功";
                echo json_encode($response);
            }
        }
    }
    
?>
//插入datecollection信息
<?php
    $response = array();
    require("db_config.php");
    $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password) ordie("error connecting") ;
    mysql_query("set names 'utf8'");
    mysql_select_db($mysql_database);
    if (isset($_GET['date_id']) &&isset($_GET['time_duration'])&&isset($_GET['num_getout'])) {
        $date_id = $_GET['date_id'];
        $time_duration = $_GET['time_duration'];
        $num_getout = $_GET['num_getout'];
        $result = "INSERT INTO datecollection(date_id, time_duration,num_getout) VALUES('$date_id', '$time_duration', '$num_getout')";
        $re=mysql_query($result);
        if($re){
            //echo "插入数据成功";
            $rs['result'] ='0';
            $rs['msg'] ="数据插入成功";
            echo json_encode($rs);
        }
    }
?>