listview에서 아이템 선택 시 해당 번호를 get방식으로 받아서 조회수를 1증가, 해당 글과 리플을 파싱해서 뿌려주는 php문입니다
조회수 증가 부분을 따로 실행시키면 실행이 되고
글과 리플 부분을 xml로 나타내는것도 따로 실행하면 되는데
두 가지를 같이 실행하면 에러가 발생합니다.....
해결 방안이 없나요?
error_reporting(E_ALL);
ini_set("display_errors", 1);
header("Content-Type: text/xml; chareset=UTF-8");
// 연결
$db_host = "localhost";
$db_user = "";
$db_passwd = "";
$db_name = "";
$conn = mysqli_connect ( $db_host, $db_user, $db_passwd, $db_name );
//utf-8변환
mysqli_query($conn, "set session character_set_connection=utf8;");
mysqli_query($conn,"set session character_set_results=utf8;");
mysqli_query($conn,"set session character_set_client=utf8;");
// �Խù� �˻�
$board_no = $_GET['item_no'];
//// view 증가
$result = mysqli_query($conn, "SELECT MAX(freeboard_view) FROM ezcook_freeboard where freeboard_idx=0 and freeboard_num='$board_no'");
$board_view_value = 0;
while ($board_num = mysqli_fetch_array($result, MYSQLI_BOTH)) {
echo $board_num[0];
$board_view_value = $board_num[0];
}
$board_view_value += 1;
echo $board_view_value;
mysql_free_result($result);
mysql_free_result($board_num);
mysqli_query($conn, "UPDATE ezcook_freeboard set freeboard_view='$board_view_value' where freeboard_idx=0 and freeboard_num='$board_no'");
//// view 증가 끝
//// 게시물 가져오기
$sql = "SELECT * FROM ezcook_freeboard where freeboard_idx = 0 and freeboard_num = '$board_no'";
$rs = mysqli_query ($conn, $sql);
$xmlString = " version='1.0' encoding='utf-8'?>";
$xmlString .= "";
while ( $result = mysqli_fetch_array ( $rs, MYSQLI_ASSOC ) ) {
$title = $result ['freeboard_title'];
$contents = $result['freeboard_contents'];
$creater_UUID = $result['freeboard_creater_UUID'];
$view = $result['freeboard_view'];
$num = $result ['freeboard_num'];
$date = $result ['freeboard_datetime'];
$good = $result ['freeboard_goodUUID'];
$bad = $result ['freeboard_badUUID'];
//SQ
$xmlString .= "$num$title$contents$creater_UUID$view$date$good$bad";
// $creater
// echo $text;
}
mysqli_free_result ( $rs );
//// 게시물 가져오기 끝
//// 리플 가져오기
$sql = "SELECT * FROM ezcook_freeboard where freeboard_num = '$item_no' and freeboard_idx > 0";
$rs = mysqli_query ( $conn, $sql );
//xml []�ȿ� ��� ���� ���� db�ʵ��̸�
while ( $result = mysqli_fetch_array ( $rs, MYSQLI_ASSOC ) ) {
$contents = $result ['freeboard_contents'];
// $nick = $result['freebard_creater'];
$creater_UUID = $result['freeboard_creater_UUID'];
$view = $result['freeboard_view'];
$num = $result ['freeboard_num'];
$date = $result ['freeboard_datetime'];
$good = $result ['freeboard_goodUUID'];
$bad = $result ['freeboard_badUUID'];
//SQ
$xmlString .= "$num$contents$creater_UUID$view$date$good$bad";
// $creater
// echo $text;
}
$xmlString .= "";
//
mysqli_free_result ( $rs );
//리플 가져오기 끝
// DB????????
mysqli_close ( $conn );
// echo '
';
// $xmlString .= "";
echo $xmlString;
?> | |
|
등록안내
등록안내
