본문 바로가기

Papers/PHP

php와 database 연동

<?
$connect = mysql_connect("[hostname or op]", "[user_id]", "[user_password]");
if(!$connect)
{
 die('did not connect: ' . mysql_error());
}

mysql_select_db("[database_name]", $connect);

#result = mysql+query("query");

while ($row = mysql_fetch_array($result))
{
 echo $row['first_name'] . " " . $row['last_name'];
 echo "<br />";
}
 
 mysql_close($connect);
?>