Why does this pdo::mysql code crash on windows??
Posted
by user154107
on Stack Overflow
See other posts from Stack Overflow
or by user154107
Published on 2009-08-11T03:03:44Z
Indexed on
2010/03/15
2:39 UTC
Read the original article
Hit count: 447
Why does this pdo::mysql code crash on windows???
<?php
$username = "root";
$password = "";
try {
$dsn = "mysql:host=localhost;dbname=employees";
$dbh = new PDO($dsn, $username, $password);
$dbh->setAttribute(PDO::ATTR_EMULATE_PREPARES, FALSE);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
echo "Connected to database<br />" ;
$dbh->exec("DROP TABLE IF EXISTS vCard;");
$dbh->exec("DROP TABLE IF EXISTS emp;");
$table = "CREATE TABLE vCard(
id INT(4) NOT NULL PRIMARY KEY,
firstName VARCHAR (255),
lastName VARCHAR (255),
office VARCHAR (255),
homePh VARCHAR (13),
mobilePh VARCHAR (13))";
$dbh->exec($table);
$dbh->beginTransaction();
$dbh->exec("INSERT INTO vCard(id, firstName, lastName, office, homePh, mobilePh)
VALUES (4834, 'Randy', 'Lewis', 'SR. Front End Developer', '631-842-3375', '917-435-2245');");
$dbh->exec("INSERT INTO vCard(id, firstName, lastName, office, homePh, mobilePh)
VALUES (0766, 'Frank', 'LaGuy', 'Graphic Designer', '631-789-8244', '917-324-9897');");
$dbh->exec("INSERT INTO vCard(id, firstName, lastName, office, homePh, mobilePh)
VALUES (6684, 'Donnie', 'Dolemite', 'COO', '631-789-9482', '917-234-1222');");
$dbh->exec("INSERT INTO vCard(id, firstName, lastName, office, homePh, mobilePh)
VALUES (8569, '', 'McLovin', 'Actor', '631-842-9786', '917-987-8944');");
$dbh->commit();
echo "Data entered successfully<br/><br/>";
$sql = "SELECT * FROM vCard"; // WHERE firstName = 'Donnie'";
$results = $dbh->query($sql);
foreach ($results as $id){
echo "SSN: ". $id['id']." ";
echo "First Name: ". $id['firstName']." ";
echo "Last Name: ". $id['lastName']."<br/>";
}
}
catch (PDOException $e) {
echo "Failed: " . $e->getMessage();
$dbh->rollback();
}
?>
basically this line of code is what triggers Apache to crash..
$sql = "SELECT * FROM vCard";
If I try to select one value like 'id' it'll ... when I try to select more than one value "*" it crashes??????
© Stack Overflow or respective owner