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);

'Devlopment > Web' 카테고리의 다른 글

class vs. id  (0) 2008.06.25
id selector & Selectors can be contextual  (0) 2008.06.25
Grouping & Add Styles to Elements with Particular Attributes  (0) 2008.06.25
Pseudo-Class Selector & CSS 글꼴 꾸밈관련 스타일  (0) 2008.06.25
css link  (0) 2008.06.25
주민등록번호 검사  (0) 2008.06.25
HTML Event  (0) 2008.06.25
Core & Keyboard Attribute  (0) 2008.06.25
META 태그  (0) 2008.06.25
DB Programing  (0) 2008.06.25
세션 및 GET, POST 받기  (0) 2008.06.25

Leave a Comment


to Top