PHP MySqli 사용 예제

<?php

 define("DBUSER", "root");

 define("DBPASS", "root");

 define("DBNAME", "tlc_db");

 define("DBHOST", "localhost");

 

$conn = new mysqli(DBHOST, DBUSER, DBPASS, DBNAME);

if ($conn->connect_error)

{

trigger_error("Database connection failed :" . $connection->connect_error, E_USER_ERROR);

}

$sql = "select m_id, m_name, m_sex, m_age, m_phone, m_address from member_table;";

$ret = $conn->query($sql);

if (false == $ret)

{

trigger_error("Sql Query Error", E_USER_ERROR);

}

while($row = $ret->fetch_assoc())

{

echo $row['m_id']."-".$row['m_name']."-".$row['m_sex']."-".$row['m_phone']."<br>";

}

?>