인의적으로 insert한다음에 게시판으로 불러오기문제
다름이 아니라 write.php를 이용해서 올린게 아니구요
일반 insert형식으로(그누보드 보드의 틀은 이용했구요)
게시판으로 불러왔습니다.
저장되고 불러오는데까지는 되는데 문제는 삭제가 안된다는 것인데요
페이지 넘거때문에 그런건지 정확하게 감이 안오네요...
소스는
<?
include "db_connect.php";
include "function.php";
include "function.php";
$current = time();
$timeinfo = getdate($current);
$today=$timeinfo["year"]."-".$timeinfo["mon"]."-".$timeinfo["mday"];
$timeinfo = getdate($current);
$today=$timeinfo["year"]."-".$timeinfo["mon"]."-".$timeinfo["mday"];
$conn=@mysql_connect($sql_ip,$sql_id,$sql_pw);
mysql_select_db($sql_db,$conn);
/*
$db=mysql_connect("localhost","root","apmsetup");
mysql_select_db("intranet", $db);
mysql_select_db($sql_db,$conn);
/*
$db=mysql_connect("localhost","root","apmsetup");
mysql_select_db("intranet", $db);
$name = $HTTP_POST_VARS['name'];
$subject1 = $HTTP_POST_VARS['subject1'];
$subject2 = $HTTP_POST_VARS['subject2'];
$subject3 = $HTTP_POST_VARS['subject3'];
$subject4 = $HTTP_POST_VARS['subject4'];
$subject5 = $HTTP_POST_VARS['subject5'];
$subject6 = $HTTP_POST_VARS['subject6'];
$subject7 = $HTTP_POST_VARS['subject7'];
$subject8 = $HTTP_POST_VARS['subject8'];
$subject9 = $HTTP_POST_VARS['subject9'];
$subject10 = $HTTP_POST_VARS['subject10'];
$subject11 = $HTTP_POST_VARS['subject11'];
$subject12 = $HTTP_POST_VARS['subject12'];
$subject13 = $HTTP_POST_VARS['subject13'];
$from = $HTTP_POST_VARS['from'];
$body = $HTTP_POST_VARS['body'];
$subject1 = $HTTP_POST_VARS['subject1'];
$subject2 = $HTTP_POST_VARS['subject2'];
$subject3 = $HTTP_POST_VARS['subject3'];
$subject4 = $HTTP_POST_VARS['subject4'];
$subject5 = $HTTP_POST_VARS['subject5'];
$subject6 = $HTTP_POST_VARS['subject6'];
$subject7 = $HTTP_POST_VARS['subject7'];
$subject8 = $HTTP_POST_VARS['subject8'];
$subject9 = $HTTP_POST_VARS['subject9'];
$subject10 = $HTTP_POST_VARS['subject10'];
$subject11 = $HTTP_POST_VARS['subject11'];
$subject12 = $HTTP_POST_VARS['subject12'];
$subject13 = $HTTP_POST_VARS['subject13'];
$from = $HTTP_POST_VARS['from'];
$body = $HTTP_POST_VARS['body'];
mysql_query("insert into orders values ('', '$name', '$subject1', '$subject2', '$subject3', '$subject4', '$subject5', '$subject6', '$subject7', '$subject8', '$subject9', '$subject10', '$subject11', '$subject12', '$subject13', '$from', '$body')", $db);
*/
$name = trim($name);
//$subject0 = trim($subject0);
$subject0 = '문의테스트 발송입니다.';
$subject1 = trim($subject1);
$subject2 = trim($subject2);
$subject3 = trim($subject3);
$subject4 = trim($subject4);
$subject5 = trim($subject5);
$subject6 = trim($subject6);
$subject7 = trim($subject7);
$subject8 = trim($subject8);
$subject9 = trim($subject9);
$subject10 = trim($subject10);
$subject11 = trim($subject11);
$subject12 = trim($subject12);
$subject13 = trim($subject13);
$wr_password = '123456789';
$from = trim($from);
$body = trim($body);
//$subject0 = trim($subject0);
$subject0 = '문의테스트 발송입니다.';
$subject1 = trim($subject1);
$subject2 = trim($subject2);
$subject3 = trim($subject3);
$subject4 = trim($subject4);
$subject5 = trim($subject5);
$subject6 = trim($subject6);
$subject7 = trim($subject7);
$subject8 = trim($subject8);
$subject9 = trim($subject9);
$subject10 = trim($subject10);
$subject11 = trim($subject11);
$subject12 = trim($subject12);
$subject13 = trim($subject13);
$wr_password = '123456789';
$from = trim($from);
$body = trim($body);
$code = trim($code);
$FB_PASSWORD = trim($passwd);
$FB_NAME = trim($writer);
$FB_SUBJECT = trim($subject);
$FB_CONTENT = trim($content);
$FB_MB_ID = trim($mb_id);
$FB_WR_1 = trim($wr_1);
$FB_PASSWORD = trim($passwd);
$FB_NAME = trim($writer);
$FB_SUBJECT = trim($subject);
$FB_CONTENT = trim($content);
$FB_MB_ID = trim($mb_id);
$FB_WR_1 = trim($wr_1);
$FB_NAME = addslashes($writer);
$FB_SUBJECT = addslashes($subject);
$FB_CONTENT = addslashes($content);
$FB_SUBJECT = addslashes($subject);
$FB_CONTENT = addslashes($content);
$FB_DATE = date('Y.m.d (H:i)');
$FB_IP = getenv("REMOTE_ADDR");
$wr_num = $write[wr_num];
$FB_IP = getenv("REMOTE_ADDR");
$wr_num = $write[wr_num];
$contents = $subject0."\r\n제품명 :".$subject1."\r\n모델명:".$subject2."\r\n구입점:".$subject3."\r\n구입시기:".$subject4."\r\n고객명:".$name."\r\n전화번호:".$subject5."-".$subject6."-".$subject7."\r\n이메일:".$from."\r\n핸드폰:".$subject8."-".$subject9."-".$subject10.""."\r\n기타내용:".$body;
$sql="INSERT INTO ".$sql_tb." VALUES('wr_num',' ', '','', '', '', '', '', '', '$subject0', '$contents', '', '', 0, 0, '', 0, 0, 0, '$name', '$wr_password', '$name', '$from', '', '$FB_DATE', '', '$FB_IP', '$subject1', '$subject2', '$subject3', '$subject4', '$subject5', '$subject6', '$subject7', '$subject8', '$subject9', '$subject10')";
$rs_query=mysql_query(($sql),$conn);
/*
mysql_close($conn);
echo "&sql_complete=ok&";
exit;
mysql_close($db);
*/
mysql_close($conn);
echo("check=success");
exit;
?>
문제의 게시판 : http://napoldesignfurniture.com/board/bbs/board.php?bo_table=orders&page=1&sfl=&stx=&spt=&page=1
게시물을 삭제해보시면 삭제가 안되네요.. ㅜㅜ
글쓰기에서 하면 글은 삭제가되는데요
저위의 소스로 삽입을 한 소스는 삭제가되지 않습니다.
|
댓글을 작성하시려면 로그인이 필요합니다.
로그인
댓글 3개
db를 보시고 wr_num 값이 제대로 들어갔는지 확인부터 하시는게 원칙인거 같네요.
꼭 삭제해야되는데 코드가 꼬여서 잘 안되면,
phpMyAdmin으로 접속해서 해당 데이터 삭제 하시면 되겠습니다.
그리고 나서 천천히 연구해보심이 좋을 듯 하네요.
게시판 넘버문제같네요...^^;