PHP串連mysql

標籤：for   param   soc   base   prepare   set   values   pass   utf8   

$servername = "localhost";   //伺服器
$username = "root";     //使用者名稱
$password = "root";    //密碼
$dbname="base";　　　　//表名
$params = array (
    PDO::MYSQL_ATTR_INIT_COMMAND => ‘SET NAMES \‘UTF8\‘‘ ,   //設定字元集 保證中文不亂碼
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,           //設定當前pdo的錯誤處理方式
);
try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password, $params);
    echo "串連成功";

    //查詢
    $sqlinquire = ‘select * from shop‘;
//    $sqlinquire = ‘select * from shop WHERE Id=3||typeId=1‘;//給查詢加入限制條件
    $preinquire = $conn->prepare($sqlinquire);
    $preinquire->execute();
    $resultinquire=$preinquire->fetchAll(PDO::FETCH_ASSOC);



    //插入，增加記錄
    $str=‘‘;
    $arr=array();
    for($i=0;$i<10;$i++){
        if($i==0){
            $str="(?,?,?)";
        }else{
            $str.=",(?,?,?)";
        }
        $s="張三".rand(1000,100000);
        $t=rand(1,3);
        $m=‘￥‘.rand(100,1000);
        $arr[]=$s;
        $arr[]=$t;
        $arr[]=$m;
    }
    echo $str;
    print_r($arr);
    $sqladd="INSERT INTO shop(shopname,typeId,money) VALUES $str";
    $preadd = $conn->prepare($sqladd);
    $preadd->execute($arr);



    //修改編輯資料
    $sqlchange="UPDATE shop SET money=‘￥1599‘ WHERE Id=2";
    $prechange = $conn->prepare($sqlchange);
    $prechange->execute();

    //刪除
    $sqldel="DELETE FROM shop";
    $predel = $conn->prepare($sqldel);
    $predel->execute();

} catch(PDOException $e) {
    echo $e->getMessage();
}

PHP串連mysql