메뉴 건너뛰기

XEDITION

project2018

PHP MySQL SELECT 2

admin 2018.04.16 11:13 조회 수 : 1

http://www.spatium.co.kr/languages/content.php?chno=3&bno=25

 

<?php

 

$conn = mysqli_connect("localhost", "root", "", "test");

$table_name = $_POST['table_name'];

 

if(mysqli_connect_errno()){

echo"MySQL 연결 실패 : " .mysqli_connect_error();

}

 

$query = "select * from $table_name";

 

$result = mysqli_query($conn, $query);

 

while($row = mysqli_fetch_array($result)){

echo "a : ".$row[games].",  b : ".$row[pub];

}

 

mysqli_close($conn);

 

?>

위로