setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $pdo->query("SELECT * FROM xxx");
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e){
echo "ERROR: " . $e->getMessage();
} catch (Exception $e){
echo "ERROR: " . $e->getMessage();
}
return $rows;
}
function loginid_add($id, $pass){
$ret = FALSE;
$query = '';
try {
$pdo = new PDO("mysql:host=localhost;
dbname=".DBNAME,DBUSER,DBPASS);
$pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
$query = "insert into xxx (v1,v2) values(2,'aaa')";
$pdo->exec($query);
$ret = TRUE;
}catch (PDOException $e){
$msg = array();
$msg[0] ='ERROR: ' . $e->getMessage();
$msg[1] = $query;
db_error($msg);
} catch (Exception $e){
echo "ERROR: " . $e->getMessage();
}
$pdo = null;
return $ret;
}
//表示関数
function disp_score2(){
$rows = selectAll();
echo "";
echo "| v1 | v2 |
|---|
";
for( $i=0; $i < count($rows); $i++) {
$row = $rows[$i];
echo "";
foreach ($row as $val) {
echo "| " . $val . " | ";
//echo $val . " , ";
}
echo "
";
//echo "
";
}
echo "
";
}
?>
PHP Sample