중복데이터 출력소스
<?
//페이지 인클루드
include "../system_files/system_option.php";
include "../system_files/system_common2.php";
//db 연결
$db_name = "imsi";
$db_user = "temp";
$db = new DataBase(); //db 객체를 생성한다.
$db->conn($db_name, $db_user, $db_user_pw, $db_host);
//리스팅 쿼리
$offset = ($pNum * $list_size) - $list_size;
$q = "select m_hphone, count(m_hphone) from member_eqsms group by m_hphone having count(m_hphone) > 1";
$rs = new RecordSet();
$rs->open($q, $db);
$dup_hphones = array();
print "//중복된 핸드폰 번호<br>";
$i = 0;
while($rs->next()){
printf("핸드폰: %s, 중복회수: %s<br>", $rs->get_str(0), $rs->get_str(1));
$dup_hphones[$i] = $rs->get_str(0);
$i++;
}
$rs->close();
print "합계: $i";
print "<p>//중복된 핸드폰 번호를 사용하는 ID<br>";
$k = 0;
for($i = 0; $i < count($dup_hphones); $i++){
print "---------------------<br>";
$q = "select m_id, m_hphone, m_eq_money from member_eqsms where m_hphone = '$dup_hphones[$i]'";
$rs = new RecordSet();
$rs->open($q, $db);
while($rs->next()){
printf("ID: %s, 핸드폰: %s, EQM: %s<br>"
, $rs->get_str(0), $rs->get_str(1), $rs->get_str(2));
$k++;
}
$rs->close();
}
print "합계: $k";
$db->close();
?> | |
HTML
