145 lines
4.0 KiB
PHP
145 lines
4.0 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' ORDER BY wr_num, wr_reply;
|
|
";
|
|
|
|
$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_etc9 = $row[wr_datetime];
|
|
$b_etc10 = $row[wr_content];
|
|
|
|
|
|
// echo $i." -> update board set b_etc9 = '".$b_etc9."', b_etc10 = '".$b_etc10."' where b_class=3 and b_etc1 = '".$row[wr_num]."'; <br>";
|
|
// $sql = "update board set b_etc9 = '".$b_etc9."', b_etc10 = '".$b_etc10."' where b_class=3 and b_etc1 = '".$row[wr_num]."'";
|
|
// $Result = mysql_query($sql, $conn1) or die(mysql_error());
|
|
$i++;
|
|
}
|
|
?>
|
|
<!-- </table> -->
|
|
<?
|
|
mysql_close($conn);
|
|
mysql_close($conn1);
|
|
?>
|
|
</body>
|
|
</html>
|