IT/PHP
PHP MySqli 사용 예제
SpringUpOhWell!
2016. 10. 19. 23:06
반응형
<?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>";
}
?>
반응형