채택완료

등급별 쪽지 보내기.. db업데이트 안되는데요? 함수가 틀린건지?

2016-10-23 (일) 23:16:47 3,609

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">&nbsp;&middot; 받는사람 권한</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">&nbsp;&middot; 내용 </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 포인트

mysql_escape_string 여기도 sql_escape_string  

답변을 작성하려면 로그인이 필요합니다.