체크된값을 넘겨받아서 쿼리 적용하는문의좀요 형님들 채택완료
<?
$email1 = $_REQUEST['email1'];
for($i=0;$i<count($email1);$i++) {
echo $email1[$i];
echo "<BR>";
}
echo "<script>alert('".$email1."')</script>";
echo "<script>alert('".$i."')</script>";
?>
값갯수 값내용 정상적으로 가져와서 찍히는데.
이걸 sql에 넣어서 돌려야되는데..
도움좀주세요 ㅜㅜ
$ary = array();
$ppk = mysql_query("select mb_email from g4_member where mb_id=$email 여기 잘모르겠네요");
while($data = mysql_fetch_row($ppk))
{array_push($ary,$data[0]);}
$fre = join(",",$ary);
$admin_email="$fre";
</p><p>정리한것</p><p><?</p><p>
$email1 = $_REQUEST['email1'];
for($i=0;$i<count($email1);$i++) { </p><p> </p><p>
echo $email1[$i];
echo "
"; </p><p>}
$ary = array();
$ppk = mysql_query("select mb_email from g4_member where mb_id=$email1");
while($data = mysql_fetch_row($ppk))
{array_push($ary,$data[0]);}
$fre = join(",",$ary);
$admin_email="$fre";
echo "<script>alert('".$admin_email."')</script>";
echo "<script>alert('".$email1."')</script>";
?></p><p> </p><p>찍어봤는데 값은 정상찍히는데 저기 ppk 쿼리타는부분이 안먹드라구요 ㅠ</p><p> </p><p>답변 5개
<?
$email1 = $_REQUEST['email1']; -> 넘겨온 값을 가지고 오죠.
$free='';
$n=0;
for($i=0;$i<count($email1);$i++) { -> 배열수만큼 돌아갑니다.
$mb = get_member($email1[$i]); -> 회원아이디로 회원정보를 가지고옵니다.
if($mb[mb_email]) {
if($n==0) {
$fre .= $mb[mb_email] ;
} else {
$fre .= ",".$mb[mb_email] ;
} -> 회원의 이메일주소를 뽑아서 $fre 변수에 넣어줍니다. "aaa@aaa.com, bbb@aaa.com" 이런식으로
$n++:
}
}
답변에 대한 댓글 1개
댓글을 작성하려면 로그인이 필요합니다.
</p><p><?php</p><p>$email1 = $_REQUEST['email1'];</p><p>$email_list="";</p><p>for($i=0;$i<count($email1);$i++) {</p><p style="margin-left: 40px;">if($i > 0) $email_list .= ",".$email[$i];</p><p style="margin-left: 40px;">else if($i == 0) $email_list = $email[$i];</p><p>}</p><p>echo "<script>alert('".$email_list."')</script>";</p><div>
</div><p> </p><p>?></p><p>댓글을 작성하려면 로그인이 필요합니다.
</p><p><?</p><p>
$email1 = $_REQUEST['email1']; </p><p>for($i=0;$i<count($email1);$i++) { </p><p>echo $email1[$i];
echo ",";
echo "<script>alert('".$email1[$i]."')</script>"; </p><p>} </p><p>
이걸로 우선 다시 짰는데..
값들이 따로따로 찍혀서 연결되서 찍어서 변수에 넣고싶은데 어떻게 해야될까여 ㅠㅠ 형님
댓글을 작성하려면 로그인이 필요합니다.
<?
$email1 = $_REQUEST['email1'];
$free='';
$n=0;
for($i=0;$i<count($email1);$i++) {
$mb = get_member($email1[$i]);
if($mb[mb_email]) {
if($n==0) {
$fre .= $mb[mb_email] ;
} else {
$fre .= ",".$mb[mb_email] ;
}
$n++:
}
}
이제 이메일주소가 $fre 로 들어가 있어여.
메일을 보내시면 됩니다.
답변에 대한 댓글 1개
$email1 = $_REQUEST['email1'];
$free='';
$n=0;
for($i=0;$i<count($email1);$i++) {
$mb = get_member($email1[$i]);
if($mb[mb_email]) {
if($n==0) {
$fre .= $mb[mb_email] ;
} else {
$fre .= ",".$mb[mb_email] ;
}
$n++;
}
echo "<script>alert('".$fre."')</script>";
}
?>
빈값만찍히네여 ㅜㅜ
그래서 지금 다시 짯는데
[code]
<?
$email1 = $_REQUEST['email1'];
for($i=0;$i<count($email1);$i++) {
echo $email1[$i];
echo ",";
echo "<script>alert('".$email1[$i]."')</script>";
}
?>
[/code]
다 정상찍힙니다. email 다 잘찍히는데..
이걸 묶어서 변수에 담고싶습니다.
예를들어 a@a.com,b@b.com,c@c.com 이런형식으로 다 붙여서 나열하고싶습니다..
이걸 mailler 쪽으로 보낼예정이거든요 ㅠㅠ
댓글을 작성하려면 로그인이 필요합니다.
<code class="variable" style="font-size: 14.004px; line-height: 25.2072px; letter-spacing: -0.01px; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; color: rgb(170, 119, 0) !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(248, 248, 248); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;">$ppk</code><span style="font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace; font-size: 14.004px; letter-spacing: -0.01px; line-height: 25.2072px; background-color: rgb(248, 248, 248);"> </span><code class="plain" style="font-size: 14.004px; line-height: 25.2072px; letter-spacing: -0.01px; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(248, 248, 248); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;">= mysql_query(</code><code class="string" style="font-size: 14.004px; line-height: 25.2072px; letter-spacing: -0.01px; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; color: blue !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(248, 248, 248); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;">"select mb_email from g4_member where mb_id='$email1'"</code><code class="plain" style="font-size: 14.004px; line-height: 25.2072px; letter-spacing: -0.01px; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier, monospace !important; margin: 0px !important; padding: 0px !important; border: 0px !important; outline: 0px !important; float: none !important; vertical-align: baseline !important; position: static !important; left: auto !important; top: auto !important; right: auto !important; bottom: auto !important; height: auto !important; width: auto !important; background-image: none !important; background-attachment: initial !important; background-color: rgb(248, 248, 248); background-size: initial !important; background-origin: initial !important; background-clip: initial !important; background-position: initial !important; background-repeat: initial !important;">);쿼리의 문자열 부분 즉 mb_id부분의 비교 값을 ' 을 넣어 감싸주세요
mb_id = '$email1'
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인
[code]
<?
$email1 = $_REQUEST['email1'];
for($i=0;$i<count($email1);$i++) {
echo $email1[$i];
echo ",";
echo "<script>alert('".$email1[$i]."')</script>";
}
?>
[/code]
다 정상찍힙니다. email 다 잘찍히는데..
이걸 묶어서 변수에 담고싶습니다.
예를들어 a@a.com,b@b.com,c@c.com 이런형식으로 다 붙여서 나열하고싶습니다..
이걸 mailler 쪽으로 보낼예정이거든요 ㅠㅠ