Tag Archives: WebDB

PHP 회원목록 출력

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”… Read More »

PHP 회원가입 프로그램

php_member.sql CREATE TABLE IF NOT EXISTS `php_member` (     `userid` varchar(16) NOT NULL,   `password` char(32) NOT NULL,   `username` varchar(20) NOT NULL,    `jumin1` char(6) NOT NULL,   `jumin2` char(32) NOT NULL,   `zipcode` char(7) NOT NULL,   `address1` varchar(40) NOT NULL,   `address2` varchar(40) NOT NULL,   `email` varchar(40) NOT NULL,   `job` varchar(10) NOT NULL,   `intro` tinytext NOT NULL,   PRIMARY KEY… Read More »