[PHP] my-sql DB 연결하기

** PHP로 mysql 접속하기:
 
DB 연결 설정 - (db_con.inc)
<?php
$db_user = "root";
$db_pass = "1111";
$db_host = "localhost";
$db_name = "test";
 
mysql_connect($db_host, $db_user, $db_pass);
mysql_select_db($db_name);
?>
 
Mysql 테이블 생성 예제 - (create_file.php)
<?php
include "db_con.inc";
 
$result = mysql_query("create table $table".
             "(file_id int(11) NOT NULL auto_increment primary key,".
             "file_path varchar(100) NOT NULL,".
             "file_name varchar(100) NOT NULL,".
             "file_size int unsigned NOT NULL,".
             "file_see smallint unsigned NOT NULL,".
             "file_num int NOT NULL )");
 
//에러처리
if(!$result)
{
     echo mysql_errno().":";
     echo mysql_error()."<BR>";
}
 
mysql_close();
echo"자료실 테이블이 정상적으로 만들어졌습니다";
?>