php pdo 链接数据库

来源:互联网 发布:淘宝店铺悬浮导航制作 编辑:程序博客网 时间:2024/04/30 04:48
/链接数据库        $servername = "localhost";        $username = "root";        $password = "111111";        try {            $conn = new PDO("mysql:host=$servername;dbname=kuaijiezhou", $username, $password);            $conn->exec("SET NAMES 'utf8';");                //echo "Connected successfully";         }        catch(PDOException $e)        {            echo $e->getMessage();        }$orderid = $_GET['orderid']  ? intval($_GET['orderid']) : ''; //用户id        //查询订单        $url1 = "SELECT * FROM my_order where id = $orderid";        $res_order = $conn->query($url1)->fetch(PDO::FETCH_ASSOC);        //订单配送时间        $url2 = "SELECT * FROM my_ordersendtime where orderid = $orderid";        $res_order_sendtime = $conn->query($url2)->fetch(PDO::FETCH_ASSOC);        //订单详情        $url3 = "SELECT * FROM my_orderdetail where orderid = "."'".$res_order['orderid']."'";        $res_order_detail = $conn->query($url3)->fetchAll(PDO::FETCH_ASSOC);

1 0
原创粉丝点击