matometaru
11/13/2017 - 7:42 AM

db接続

db接続

$user = 'user';
$password = 'pass';
$dbName = 'name';
$host = 'host';
$dsn = "mysql:host={$host};dbname={$dbName}";

try{
    $pdo = new PDO($dsn, $user, $password);
} catch (Exception $e) {
    echo $e;
}

$sql = $pdo->prepare ( 'select * from `table`' );
$sql->execute();
foreach ( $sql->fetchAll () as $row ) {
    echo '<table>';
    echo '<tr>';
    echo '<td>'. $row ['id']. '</td>';
    echo '</tr>';
    echo '</table>';
}