单利 pdo 链接数据库

来源:互联网 发布:淘宝写论文有靠谱的吗 编辑:程序博客网 时间:2024/04/26 20:49
class danli{            public $db;            protected static $ins=null;                protected function __construct(){                                         $servername = "localhost";        $username = "dbname";        $password = "cs.123456789";        try {            $this->db = new PDO("mysql:host=$servername;dbname=kuaijiezou", $username, $password);            //echo "Connected successfully";         }        catch(PDOException $e)        {            echo $e->getMessage();        }                }                public static  function getins(){                    if(self::$ins ==null){                       self::$ins = new self();                    }                    return self::$ins;                }         }        $conn = danli::getins()->db;        
$url = "SELECT id,breakfast,lunch,personal,isdayin FROM my_order";//订单状态已接单   支付状态已支付   订单状态未打印        $res = $conn->query($url)->fetch(PDO::FETCH_ASSOC);        if($res['id']){            $orderid = $res['id'];            $isdayin = $res['isdayin'].$num;            $v='';            if($res['breakfast'] ==34){                $v .= ",breakfast=36";            }            if($res['lunch'] ==34){                $v .= ",lunch=36";            }            if($res['personal'] ==34){                $v .= ",personal=36";            }               $v .= ",status=36";           $sqlup = "UPDATE my_order SET isdayin=$isdayin$v WHERE id=".$res['id'];            $count = $conn->exec($sqlup);

1 0
原创粉丝点击