<?php

$host = "localhost";

$user = "test";

$pw="1234";

$db = "test";

$mysqli = new mysqli($host, $user, $pw, $db);
mysqli_query($mysqli,"set names utf8");

if (mysqli_connect_error()) {
   echo mysqli_connect_error();
   exit();
}

 

// select 예

$query = " select * from test";

$result = $mysqli->query($query);

while ($row = $result->fetch_array(MYSQLI_ASSOC)) {

   echo $row[name];

}

 

// update 예

$mysqli->query("update test set name='aaa' where id='1'");

 

 

$mysqli->close();

?>