dbConfig.php
<?php
$dbHost = "localhost";
$dbUser = "dbuser";
$dbpass = "dbpass";
$dbName = "dbname";
?>
memberList.php
<?php
require "./dbConfig.php";
$sql = "SELECT userid, username, email FROM php_member";
$dbConn = mysql_connect($dbHost, $dbUser, $dbpass);
mysql_select_db($dbName, $dbConn);
mysql_set_charset("utf8");
$result = mysql_query($sql, $dbConn);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body>
아이디 이름 이메일 <br />
<?php
while ($rec = mysql_fetch_array($result)) {
echo $rec["userid"] . " " . $rec["username"] . " " . $rec["email"] . "<br />";
}
?>
</body>
</html>
<?
mysql_close($dbConn);
?>
'프로그래밍 > PHP' 카테고리의 다른 글
PHP 개요 (0) | 2010.09.06 |
---|---|
PHP 회원가입 프로그램 (0) | 2010.05.17 |