[php] mysqli create table select insert

<?php

$con=mysqli_connect("localhost","아이디","비밀번호","데이타베이스명");

// Check connection

if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$sql="create table Persons(

  FirstName varchar(50)

  ,LastName varchar(50)

  ,Age varchar(50)

)";

if(mysqli_query($con,$sql)){

echo "Table Person created successfully";

}else{

echo "Error creating table: ".mysqli_error($con)."<br/>";

}

// Perform queries

$result=mysqli_query($con,"SELECT * FROM Persons");

if($result){

echo "조회된 행의 수: ".mysqli_num_rows($result)."<br/>";

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

printf("%s : %s : %s <br/>", $row["FirstName"], $row["LastName"], $row["Age"]);

}

}

$r = mysqli_query($con,"INSERT INTO Persons (FirstName,LastName,Age)

VALUES ('Glenn','Quagmire',33)");

//print_r($r);

if($r){

echo "insert 성공";

}else{

echo "insert 실패";

}

mysqli_close($con);

?>