<?php try{ $dbh = new PDO('MySQL:dbname=testdb;host=localhost', 'mysql_user', 'mysql_pwd'); $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); }catch(PDOException $e){ echo '數(shù)據(jù)庫連接失?。?.$e->getMessage(); exit; } //聲明一個(gè)SELECT查詢,從表contactInfo中獲取D01部門的四個(gè)字段的信息 $query = "SELECT uid, name, phone, email FROM contactInfo WHERE departmentId='D01'"; try { $stmt = $dbh->PRepare($query); //準(zhǔn)備聲明好的一個(gè)查詢 $stmt->execute(); //執(zhí)行準(zhǔn)備好的查詢 $stmt->bindColumn(1, $uid); //通過列位置偏移數(shù)綁定變量$uid $stmt->bindColumn(2, $name); //通過列位置偏移數(shù)綁定變量$name $stmt->bindColumn('phone', $phone); //綁定列名稱到變量$phone上 $stmt->bindColumn('email', $email); //綁定列名稱到變量$email上 while ($stmt->fetch(PDO::FETCH_BOUND)) { //fetch()方法傳入特定的參數(shù)遍歷 echo $uid."/t".$name."/t".$phone."/t".$email."/n"; //輸出自動(dòng)將列值賦給對(duì)應(yīng)變量的值 } } catch (PDOException $e) { echo $e->getMessage(); }
新聞熱點(diǎn)
疑難解答
圖片精選
網(wǎng)友關(guān)注