MYSQL 최근 쓴 PDO+PHP 쿼리 몇 개

php로 작업을 하게되었는데 국내 자료들에는 주로 mysqli를 사용하는 분들이 많은데
범용적으로 사용하기 위해서 pdo로 찾아보았다.

PHP MYSQL PDO

CONNECT 1

$dbHost="localhost";
$dbName=“db”;
$dbUser="root";
$dbPassword= “pass”;
$dbChar= "utf8";

$dbc = new PDO("mysql:host={$dbHost};dbname={$dbName};charset={$dbChar}",$dbUser,$dbPassword);

 

CONNECT 2 ( conn.php )

<?php
$dbName = "dbname";
$dbUser = "root";
$dbHost = "localhost";
$dbPassword = "pass";


try {
  $pdo = new PDO("mysql:host=" . $dbHost . ";dbname=" .
    $dbName, $dbUser, $dbPassword);
} catch (PDOException $err) {
  echo "Database connection problem: " . $err->getMessage();
  exit();
}
?>

 

DISCONNECT

$stmt = null;
$dbc =null;

 

INSERT QUERY

$query = “INSERT INTO $tableName ( a , b ,c ) VALUES (:a,:b,:c)”;
$data = [‘a’=>$a,  ’b’=>$b,  ’c’=>$c];
$stmt = $dbc -> prepare($query);
$stmt -> execute($data);

DELETE QUERY

<?php

$email = $_POST['email'];
$data = ['email' => $email];
$query = "DELETE FROM email_list WHERE email = :email";
$stmt = $pdo->prepare($query);
$stmt->execute($data);
echo 'Customer removed: ' . $email;

?>

DELETE QUERY2

$email = $_POST['email'];
$query = "DELETE FROM email_list WHERE email = $email";
$stmt = $pdo->prepare($query);
$stmt->execute();
echo 'Customer removed: ' . $email;

 

FETCH QUERY

$stmt = $pdo->query("SELECT * FROM guitarwars");
while ($row = $stmt->fetch()) {
// Display the score data
echo '<tr><td class="scoreinfo">';
}

 

SELECT QUERY

$stmt = $pdo->query("SELECT * FROM guitarwars");

 

 

rowCount()

$stmt = $pdo->prepare($query);
$stmt->execute();
$count = $stmt->rowCount();
if ($count == 1) {