mysqlで配信情報を管理する

あまりmysqlを扱ったことがないのでメモ
適当なテーブルを作ってデータを取得

<?php

$db_sever = "DB Server domain";
$user_name = "user name";
$password = "password";
$db_name = "database name";
$table_name = "table name";

$mysqli = new mysqli($db_sever, $user_name, $password, $db_name);
if (mysqli_connect_error()) {
    die('Connect Error (' . mysqli_connect_errno() . ') '
            . mysqli_connect_error());
}

if ($result = $mysqli->query("SELECT id,name FROM checker_broadcaster")) {
	while ($row = mysqli_fetch_assoc($result)) {
		echo $row['id'] . PHP_EOL;
		echo $row['name'] . PHP_EOL;
	}
    $result->close();
}

$mysqli->close();