php 原生pdo 接收get参数中文要打引号

待我称王封你为后i 2022-04-18 00:43 150阅读 0赞

e.g.

[http://www.site1.com/?rout=getArticleByPeriodicalLevel&periodicalLevel=][http_www.site1.com_rout_getArticleByPeriodicalLevel_periodicalLevel]'省级'

<?php
    header("Content-type:text/html;charset=utf8");
    
    ini_set("display_errors","On");
    error_reporting(E_ALL);
    
    //header('Content-type: application/json'); //json
    $localhost = 'xxx.xxx.com';
    $db_name = 'dbname';
    $user_name = 'username';
    $pass_word = 'password';
    
    
    $db = new PDO("mysql:host={$localhost};dbname={$db_name}", $user_name, $pass_word,array(PDO::MYSQL_ATTR_INIT_COMMAND=>"set names utf8"));
    
    function queryAll($db,$sql){
        $sth = $db->query($sql);
        return $sth->fetchAll(PDO::FETCH_ASSOC);
    
    }
    
    function getArticleAll($db)
    {
        $sql = "SELECT * FROM article ";
        return queryAll($db,$sql);
    }
    
    function getArticlePagination($db,$index,$pageSize,$searchKey)
    {
        $sql = "SELECT * FROM article limit {$index},{$pageSize} ";
    
        if(!empty($searchKey)){
            $sql = "SELECT * FROM article WHERE periodicalName CONCAT('%',{$searchKey}, '%') 
    limit {$index},{$pageSize} ";
        }
    
        return queryAll($db,$sql);
    }
    
    function getArticle($db,$articleId)
    {
        $sql = "SELECT * FROM article WHERE articleId = {$articleId}";
        return queryAll($db,$sql);
    
        //$sql = "SELECT * FROM article WHERE articleId = :articleId";
        //$stmt = $db->prepare($sql);
        //$stmt->execute(array(':articleId'=>$articleId));
        //return $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    }
    
    function getArticleByPeriodicalLevel($db,$periodicalLevel)
    {
        $sql = "SELECT * FROM article WHERE periodicalLevel = {$periodicalLevel}";
        return queryAll($db,$sql);
    }
    
    
    //路由入口
    if(!empty($_GET['rout'])){
    
        // id查询  /?rout=getArticle&articleId=1
        if($_GET['rout']=='getArticle')
        {
            $articleId = $_GET['articleId'];
            $ret = getArticle($db,$articleId);
            echo json_encode($ret);
        }
    
        // 查询全部  /?rout=getArticleAll
        if($_GET['rout']=='getArticleAll')
        {
            $ret = getArticleAll($db);
            echo json_encode($ret);
        }
    
        // 分类查询  /?rout=getArticleByPeriodicalLevel&periodicalLevel=5
        if($_GET['rout']=='getArticleByPeriodicalLevel')
        {
            $periodicalLevel = $_GET['periodicalLevel'];
            //var_dump(gettype($periodicalLevel));die;
            //$periodicalLevel = iconv("gb2312","utf-8",$periodicalLevel);
            $ret = getArticleByPeriodicalLevel($db,$periodicalLevel);
            echo json_encode($ret);
        }
    
        // 分页查询  /?rout=getArticlePagination&pageIndex=1&pageSize=2&searchKey
        if($_GET['rout']=='getArticlePagination')
        {
            $pageIndex = $_GET['pageIndex'];
            $pageSize = $_GET['pageSize'];
            $searchKey = $_GET['searchKey'];
    
            $skip = ((int)$pageIndex - 1) * (int)$pageSize ;
            $ret = getArticlePagination($db,$skip,$pageSize,$searchKey);
    
            echo json_encode($ret);
        }
    
    }

[http_www.site1.com_rout_getArticleByPeriodicalLevel_periodicalLevel]: http://www.site1.com/?rout=getArticleByPeriodicalLevel&periodicalLevel=%27%E7%9C%81%E7%BA%A7%27