[PHP] php 로 mysql 데이터 가져오기.

<?php

$link = mysql_connect("localhost", "root", "1234") or die("MySQL Connection Error.");

$select = mysql_select_db ("db");

if (!$select) {

echo "DB Selection Error.";

exit;

}

$query = "select count(*) from {$table_name} where column1='{$column1}'";

$result = mysql_query($query);

$count = mysql_result($result, 0, 0);

mysql_close($link);

?>

<?php 

$conn = mysqli_connect('localhost', $id, $pw, $db) or die(mysql_error());

mysqli_query($conn, "SET NAMES 'utf8'");

$query = "select img, next from {$table_name} where id = {$_GET['id']} ;";

$result = mysqli_query($conn, $query) or die(mysql_error());

$row = mysqli_fetch_array($result, MYSQLI_ASSOC);

mysqli_close($conn);

?>