include "db.inc";
/* PARAMETERS READ */
$PAGE = (int)($_REQUEST['page']);
$NUM = (int)($_REQUEST['num']);
$MODE = $_REQUEST['mode'];
$PASSWD = $_REQUEST['passwd'];
$SEARCH_KEY = $_REQUEST['search_key'];
$SEARCH_VAL = $_REQUEST['search_val'];
$CUBRID_HOST = "localhost";
$CUBRID_PORT = 33000;
$CUBRID_DATABASE = "board";
$CUBRID_ID = "dba";
$CUBRID_PASS = "";
$con = db_connect($CUBRID_HOST, $CUBRID_PORT, $CUBRID_DATABASE, $CUBRID_ID, $CUBRID_PASS);
$BUTTON_NAME="저장";
if ($MODE == "modify") {
$pass_qry = "select bd_title, bd_name, bd_content, bd_passwd from board where bd_seqcd = ?";
$req = cubrid_prepare($con, $pass_qry);
$res = cubrid_bind($req, 1, $NUM, "NUMERIC");
$result = cubrid_execute($req);
$row = cubrid_fetch($req);
if ($req > 0) cubrid_close_request($req);
if ($row["bd_passwd"] != $PASSWD) {
echo "";
exit;
}
$TITLE = $row["bd_title"];
$UNAME = $row["bd_name"];
$CONTENT = $row["bd_content"];
$BUTTON_NAME="수정";
} else if ($MODE == "reply") {
$pass_qry = "select bd_title, bd_name, bd_content from board where bd_seqcd = ?";
$req = cubrid_prepare($con, $pass_qry);
$res = cubrid_bind($req, 1, $NUM, "NUMERIC");
$result = cubrid_execute($req);
$row = cubrid_fetch($req);
if ($req > 0) cubrid_close_request($req);
$TITLE = $row["bd_title"];
$CONTENT = "\n\n\n\n\n--------------- " . $row["bd_name"] . "님이 작성하신 글 ---------------\n> \n> " . str_replace("\n", "\n> ", $row["bd_content"]);
}
?>
CUBRID PHP board sample
CUBRID board sample
db_disconnect($con);
?>