DB Programing

// DB Connect
$db_name = "voip";
$user_name = "root";
$user_password = "apmsetup";

$connect=mysql_connect("localhost","root","apmsetup") or  die( "SQL server에 연결할 수 없습니다.");
mysql_select_db($db_name, $connect);

// select
$user_result = mysql_query("SELECT * FROM search_db");
$user_count = mysql_num_rows($user_result);
mysql_result($user_result, $i, "Homepage");


// insert
$SQL = "insert into user_db (id, pass, join_date) Values(";
$SQL = $SQL . "'" . $user . "',";
$SQL = $SQL . "'" . $pass . "',";
$SQL = $SQL . "now())";

$rs = mysql_query($SQL);