mysqlの情報をjson出力
URLクエリとしてidをもらって、そのidに関する情報を出力
<?php $db_sever = "DB Server domain"; $user_name = "user name"; $password = "password"; $db_name = "database name"; $table_name = "table name"; $encode = array(); if(isset($_GET['id'])){ $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,twitter_name FROM checker_broadcaster" . " limit 1 OFFSET " . ($_GET['id'] - 1))) { while ($row = mysqli_fetch_assoc($result)) { $encode[] = $row; } echo json_encode($encode); $result->close(); } $mysqli->close(); }