176 lines
5.2 KiB
PHP
176 lines
5.2 KiB
PHP
<?
|
|
### Database OLD
|
|
//$myServer = "ZipulDB";
|
|
//$myUser = "Zipul2";
|
|
//$myPass = "Rash5!high";
|
|
//$myDB = "zipul2";
|
|
//
|
|
//$conn = mssql_connect($myServer, $myUser, $myPass) or die ("서버 연결 실패");
|
|
//mssql_select_db($myDB,$conn) or die ("DB 연결 실패");
|
|
$conn = mysql_connect ("db.pmson.com", "jejuwed", "jejuwed008))") or die ("DB connect error");
|
|
@mysql_select_db("jejuwed-old", $conn) or die ("DB 연결 실패"); //$database_csv 와 $csv 함수는 각자 맞게 설정
|
|
|
|
//$query = "
|
|
//SELECT * FROM g5_write_qna2 WHERE wr_reply <> 'A' ORDER BY wr_num, wr_reply;
|
|
//";
|
|
$query = "
|
|
SELECT * FROM g5_write_review WHERE wr_reply <> 'A' AND wr_reply <> 'AA' ORDER BY wr_num DESC;
|
|
";
|
|
|
|
$result=mysql_query($query, $conn) or die(mysql_error());
|
|
|
|
?>
|
|
<!DOCTYPE html>
|
|
<html lang="">
|
|
<head>
|
|
|
|
<!-- Basic -->
|
|
<meta charset="utf-8">
|
|
<meta http-equiv="X-UA-Compatible" content="IE=edge">
|
|
|
|
<title><?=_TITLE?></title>
|
|
|
|
<!-- Mobile Metas -->
|
|
<meta name="viewport" content="width=device-width, initial-scale=1, minimum-scale=1.0, shrink-to-fit=no">
|
|
</head>
|
|
<body>
|
|
<table style="width:100%" border="1">
|
|
<tr>
|
|
<td>wr_id</td>
|
|
<td>wr_num</td>
|
|
<td>wr_reply </td>
|
|
<td>wr_parent </td>
|
|
<td>wr_is_comment </td>
|
|
<td>wr_comment </td>
|
|
<td>wr_comment_reply</td>
|
|
<td>ca_name </td>
|
|
<td>wr_option</td>
|
|
<td>wr_subject</td>
|
|
<td>wr_content</td>
|
|
<td>wr_link1</td>
|
|
<td>wr_link2</td>
|
|
<td>wr_link1_hit</td>
|
|
<td>wr_link2_hit</td>
|
|
<td>wr_hit</td>
|
|
<td>wr_good</td>
|
|
<td>wr_nogood</td>
|
|
<td>mb_id</td>
|
|
<td>wr_password</td>
|
|
<td>wr_name</td>
|
|
<td>wr_email</td>
|
|
<td>wr_homepage</td>
|
|
<td>wr_datetime</td>
|
|
<td>wr_file</td>
|
|
<td>wr_last</td>
|
|
<td>wr_ip</td>
|
|
<td>wr_facebook_user</td>
|
|
<td>wr_twitter_user</td>
|
|
<td>wr_1</td>
|
|
<td>wr_2</td>
|
|
<td>wr_3</td>
|
|
<td>wr_4</td>
|
|
<td>wr_5</td>
|
|
<td>wr_6</td>
|
|
<td>wr_7</td>
|
|
<td>wr_8</td>
|
|
<td>wr_9</td>
|
|
<td>wr_10</td>
|
|
</tr>
|
|
<?
|
|
$conn1 = mysql_connect ("db.pmson.com", "jejuwed", "jejuwed008))") or die ("DB connect error");
|
|
@mysql_select_db("jejuwed", $conn1) or die ("DB 연결 실패"); //$database_csv 와 $csv 함수는 각자 맞게 설정
|
|
|
|
$i = 0;
|
|
while($row=mysql_fetch_array($result)){
|
|
?>
|
|
<tr>
|
|
<td><?=$row[wr_id]?> </td>
|
|
<td><?=$row[wr_num]?> </td>
|
|
<td><?=$row[wr_reply]?> </td>
|
|
<td><?=$row[wr_parent]?> </td>
|
|
<td><?=$row[wr_is_comment]?> </td>
|
|
<td><?=$row[wr_comment]?> </td>
|
|
<td><?=$row[wr_comment_reply]?></td>
|
|
<td><?=$row[ca_name]?> </td>
|
|
<td><?=$row[wr_option]?></td>
|
|
<td><?=$row[wr_subject]?></td>
|
|
<td><?=$row[wr_content]?></td>
|
|
<td><?=$row[wr_link1]?></td>
|
|
<td><?=$row[wr_link2]?></td>
|
|
<td><?=$row[wr_link1_hit]?></td>
|
|
<td><?=$row[wr_link2_hit]?></td>
|
|
<td><?=$row[wr_hit]?></td>
|
|
<td><?=$row[wr_good]?></td>
|
|
<td><?=$row[wr_nogood]?></td>
|
|
<td><?=$row[mb_id]?></td>
|
|
<td><?=$row[wr_password]?></td>
|
|
<td><?=$row[wr_name]?></td>
|
|
<td><?=$row[wr_email]?></td>
|
|
<td><?=$row[wr_homepage]?></td>
|
|
<td><?=$row[wr_datetime]?></td>
|
|
<td><?=$row[wr_file]?></td>
|
|
<td><?=$row[wr_last]?></td>
|
|
<td><?=$row[wr_ip]?></td>
|
|
<td><?=$row[wr_facebook_user]?></td>
|
|
<td><?=$row[wr_twitter_user]?></td>
|
|
<td><?=$row[wr_1]?></td>
|
|
<td><?=$row[wr_2]?></td>
|
|
<td><?=$row[wr_3]?></td>
|
|
<td><?=$row[wr_4]?></td>
|
|
<td><?=$row[wr_5]?></td>
|
|
<td><?=$row[wr_6]?></td>
|
|
<td><?=$row[wr_7]?></td>
|
|
<td><?=$row[wr_8]?></td>
|
|
<td><?=$row[wr_9]?></td>
|
|
<td><?=$row[wr_10]?></td>
|
|
</tr>
|
|
<?
|
|
$b_no_sql = "select ifnull(max(b_no),0)+1 as b_no from board ";
|
|
|
|
$b_no_result = mysql_query($b_no_sql,$conn1) or die(mysql_error());
|
|
$_b_no = @mysql_fetch_array($b_no_result);
|
|
|
|
$b_class = 3;
|
|
$b_no = $_b_no[b_no];
|
|
$b_top = $_b_no[b_no];
|
|
$b_step = "00";
|
|
$b_category = NULL;
|
|
$b_name = $row[wr_name];
|
|
$b_pwd = $row[wr_password];
|
|
$user_id = ($row[mb_id] != "") ? "admin" : "";
|
|
$b_title = str_replace("'","`",$row[wr_subject]);
|
|
$b_notice = 9;
|
|
$b_tag = "Y";
|
|
$b_homepage = NULL;
|
|
$b_email = $row[wr_email];
|
|
$b_content = htmlspecialchars($row[wr_content],ENT_QUOTES,'UTF-8');
|
|
$b_regdate = $row[wr_datetime];
|
|
$b_ip = $row[wr_ip];
|
|
$b_secert = "N";
|
|
//$b_front = NULL;
|
|
$b_tel = NULL;
|
|
$b_cnt = $row[wr_hit];
|
|
$b_etc1 = $row[wr_num];
|
|
//$b_etc2 = $row[b_img];
|
|
//$b_etc3 = $row[b_img2];
|
|
//$b_etc4 = $row[b_img3];
|
|
//$b_pwd = $row[password];
|
|
|
|
$_colum = "b_class,b_no,b_top,b_step,b_category,b_name,b_pwd,user_id,b_title,b_notice,b_tag,b_homepage,b_email,b_content,b_regdate,b_ip,b_secert,b_tel,b_cnt,b_etc1";
|
|
|
|
$_value = "'".$b_class."','".$b_no."','".$b_top."','".$b_step."','".$b_category."','".$b_name."','".$b_pwd."','".$user_id."','".$b_title."','".$b_notice."','".$b_tag."','".$b_homepage."','".$b_email."','".$b_content."','".$b_regdate."','".$b_ip."','".$b_secert."','".$b_tel."','".$b_cnt."','".$b_etc1."'";
|
|
|
|
// echo $i." -> INSERT INTO board (".$_colum.") VALUES (".$_value.");<br>";
|
|
// $sql = "INSERT INTO board (".$_colum.") VALUES (".$_value.");";
|
|
// $Result = mysql_query($sql, $conn1) or die(mysql_error());
|
|
$i++;
|
|
}
|
|
?>
|
|
<!-- </table> -->
|
|
<?
|
|
mysql_close($conn);
|
|
mysql_close($conn1);
|
|
?>
|
|
</body>
|
|
</html>
|