File name
Commit message
Commit date
File name
Commit message
Commit date
<?php
$user = "root";
$password = "1234";
$option = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);
/* Try Catch */
try {
/* PDO Connection */
$db = new PDO("mysql:host=localhost;dbname=study", $user, $password, $option);
$db->exec("set names UTF8");
echo "<strong>Database Connection Success!!!</strong><br>";
} catch (PDOException $e) {
echo "<strong>Database Connection Fail!!!</strong>";
echo "<br>" . $e;
} finally {
}
/* Statement */
$stmt = $db->query("select * from address");
/* Query RUN, Result GET */
$result = $stmt->fetchAll();
foreach ($result as $value) {
echo "AGE : " . $value["age"] . "<br>";
}
/* INSERT */
// $stmt = $db -> query("insert into address values(NULL, '임효원', 28, '010-5489-5486', '강원', '1665-12-15')");
// $result = $stmt->execute();
/* UPDATE */
$stmt = $db -> query("update address set name='안효원' where name='황동재'");
$result = $stmt->execute();