pdoでdbに接続してcolumnを取得 – php
<?php
try
{
$pdo = new PDO(
'mysql:host=localhost; dbname=db_name;charset=utf8',
'root',
'password',
array(PDO::ATTR_EMULATE_PREPARES => false));
}
//err
catch (PDOException $e)
{
exit('fald。'.$e->getMessage());
echo 'db_conecct_fald。';
}
$dbname = $pdo->query('SELECT name from table_name;');
while ($row = $dbname->fetch())
{
echo $row['column_name'];
echo "<br />";
}
?>