채택완료
등급별 쪽지 보내기.. db업데이트 안되는데요? 함수가 틀린건지?
1) /admin.menu200.php
아래 코드 추가
Copy
<?php$menu['menu200'] = array ( array('200000', '회원관리', G5_ADMIN_URL.'/member_list.php', 'member'), array('200100', '회원관리', G5_ADMIN_URL.'/member_list.php', 'mb_list'), array('200300', '회원메일발송', G5_ADMIN_URL.'/mail_list.php', 'mb_mail'), array('200400', '회원쪽지발송', G5_ADMIN_URL.'/memo_list.php'), array('200800', '접속자집계', G5_ADMIN_URL.'/visit_list.php', 'mb_visit', 1), array('200810', '접속자검색', G5_ADMIN_URL.'/visit_search.php', 'mb_search', 1), array('200820', '접속자로그삭제', G5_ADMIN_URL.'/visit_delete.php', 'mb_delete', 1), array('200200', '포인트관리', G5_ADMIN_URL.'/point_list.php', 'mb_point'), array('200900', '투표관리', G5_ADMIN_URL.'/poll_list.php', 'mb_poll'));?>
2) memo_list.php
등급별 설정
Copy
<?$sub_menu = "200400";include_once("./_common.php"); $g5[title] = "회원쪽지발송";include_once("./admin.head.php");?><script>function check(f){ f.action="memo_update.php"; f.submit();}</script><form name="memo" method="post"><table><Tr><Td width=100 bgcolor="#f2f2f2"> · 받는사람 권한</td><td><input type="checkbox" name="level" value=1> 모두발송 <input type="checkbox" name="level2" value=2> 2 <input type="checkbox" name="level3" value=1> 3 <input type="checkbox" name="level4" value=1> 4 <input type="checkbox" name="level5" value=1> 5 <input type="checkbox" name="level6" value=1> 6 <input type="checkbox" name="level7" value=1> 7 <input type="checkbox" name="level8" value=1> 8 <input type="checkbox" name="level9" value=1> 9 <input type="checkbox" name="level10" value=1> 10</td></tr><Tr><Td width=100 bgcolor="#f2f2f2"> · 내용 </td><td><textarea name="content" rows=15 cols=80> </textarea></td></tr><Tr><Td colspan=2><input type="button" value="보내기" onclick="check(document.memo)"><input type="reset" value="취소"></td></tr></table></form><?include_once ("./admin.tail.php");?>
3) memo_update.php
쪽지를 등급회원 추출 후, 개별 db insert ==> 현재 db 쪽지 내용이 insert 안되는 거 같습니다.
mysql_fetch_row --> sql_fetch_row 하여도 안되네요
Copy
<?$whendate="150"; //¸îÀÏÀü±îÁö Á¢¼ÓÇÑ È¸¿ø¿¡°Ô ÂÊÁö¸¦ º¸³¾±î¿ä?$sub_menu = "200400";include_once("./_common.php"); $g5[title] = "회원쪽지발송";include_once("./admin.head.php"); $memocon=mysql_escape_string($_POST['content']);$level=array();$level[1]=$_POST['level'];$level[2]=$_POST['level2'];$level[3]=$_POST['level3'];$level[4]=$_POST['level4'];$level[5]=$_POST['level5'];$level[6]=$_POST['level6'];$level[7]=$_POST['level7'];$level[8]=$_POST['level8'];$level[9]=$_POST['level9'];$level[10]=$_POST['level10'];if($level[1]){ $sql_who="AND mb_level in ('2','3','4','5','6','7','8','9','10')";}else{ $first=1; $sql_who="AND mb_level in ("; for($i=2;$i<11;$i++){ if($level[$i]){ if(!$first) $sql_who.=","; else $first=0; $sql_who.="'".$i."'"; } } $sql_who.=")";}$sql="SELECT mb_id FROM g5_member WHERE 1 $sql_who AND date_format(mb_today_login,'%Y%m')>=".date("Ym",(time()-86400*$whendate))."";$result=sql_query($sql);for($i=0;$row=mysql_fetch_row($result);$i++){ echo $row[0]."<br>"; sql_query("INSERT INTO g5_memo (me_recv_mb_id,me_send_mb_id,me_send_datetime,me_memo) values('".$row[0]."','$member[mb_id]',now(),'$memocon')");}?> 전송 성공 <?include_once ("./admin.tail.php");?>
|
답변 1개
채택된 답변
+20 포인트
2016-10-23 (일) 23:28:33
mysql_escape_string 여기도 sql_escape_string
답변을 작성하려면 로그인이 필요합니다.