DB connect

• 1.1. DB연결 방식 3가지

// Mysqli OOP
$servernme = "localhost"
$username = "root"
$password = "";
$conn  = new myasqli($servername, $username, $password);

mysqli 절차지향
$conn = mysqli_connect($servername, $username, $password);

try {
    $conn = new PDO("mysql:host=$servername", $username, $password);
    $conn ->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    echo "<p>DB연결했습니다.</p>";
} catch(PDOException $e) {
    echo $e -> getMessage();
    exit;
}

try {
    $sql = "CREATE DATABASE testdb";
    $conn->exec($sql);
    echo "<p>firstdb 성공했습니다</p>";
} catch(PDOException $e) {
    echo $e ->getMessage();
}코드를 입력하세요

cd /Applications/Xampp/bin
./mysql -u root -p 비번

$sql = "DROP DATABASE testdb";