PHP/ > 그누4 질문답변

PHP/ 정보

PHP/

본문

글작성 페이지에서 글쓰기를 한후
뷰페이지에서 보면 적용이 안되어 질문합니다..ㅠㅠ

write.php

ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ
<tr id="newUrl1" style="display:none">
<td class=write_head>기본료</td>
<td>LTE 34 : <input class='ed' style="width:10%;" name=wr_13 id="wr_13" itemname="LTE 34" <?if($w==''){?>value="34000"<?}else{?>value="<?=$wr_13?>"<?}?>> LTE 42 : <input class='ed' style="width:10%;" name=wr_14 id="wr_14" itemname="LTE 42" <?if($w==''){?>value="42000"<?}else{?>value="<?=$wr_14?>"<?}?>> LTE 52 : <input class='ed' style="width:10%;" name=wr_15 id="wr_15" itemname="LTE 52" <?if($w==''){?>value="52000"<?}else{?>value="<?=$wr_15?>"<?}?>> LTE 62 : <input class='ed' style="width:10%;" name=wr_16 id="wr_16" itemname="LTE 62" <?if($w==''){?>value="62000"<?}else{?>value="<?=$wr_16?>"<?}?>><br>LTE 72 : <input class='ed' style="width:10%;" name=wr_17 id="wr_17" itemname="LTE 72" <?if($w==''){?>value="72000"<?}else{?>value="<?=$wr_17?>"<?}?>> LTE 85 : <input class='ed' style="width:10%;" name=wr_18 id="wr_18" itemname="LTE 85" <?if($w==''){?>value="85000"<?}else{?>value="<?=$wr_18?>"<?}?>> LTE 100 : <input class='ed' style="width:10%;" name=wr_19 id="wr_19" itemname="LTE 100" <?if($w==''){?>value="100000"<?}else{?>value="<?=$wr_19?>"<?}?>></td></tr>
<tr id="newUrl6" style="display:none"><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>
<tr id="newUrl2" style="display:none">
<td class=write_head>무료통화</td>
<td>LTE 34 : <input class='ed' style="width:10%;" name=wr_20 id="wr_20" itemname="LTE 34" <?if($w==''){?>value="120분"<?}else{?>value="<?=$wr_20?>"<?}?>> LTE 42 : <input class='ed' style="width:10%;" name=wr_21 id="wr_21" itemname="LTE 42" <?if($w==''){?>value="180분"<?}else{?>value="<?=$wr_21?>"<?}?>> LTE 52 : <input class='ed' style="width:10%;" name=wr_22 id="wr_22" itemname="LTE 52" <?if($w==''){?>value="250분"<?}else{?>value="<?=$wr_22?>"<?}?>> LTE 62 : <input class='ed' style="width:10%;" name=wr_23 id="wr_23" itemname="LTE 62" <?if($w==''){?>value="350분"<?}else{?>value="<?=$wr_23?>"<?}?>><br>LTE 72 : <input class='ed' style="width:10%;" name=wr_24 id="wr_24" itemname="LTE 72" <?if($w==''){?>value="450분"<?}else{?>value="<?=$wr_24?>"<?}?>> LTE 85 : <input class='ed' style="width:10%;" name=wr_25 id="wr_25" itemname="LTE 85" <?if($w==''){?>value="650분"<?}else{?>value="<?=$wr_25?>"<?}?>> LTE 100 : <input class='ed' style="width:10%;" name=wr_26 id="wr_26" itemname="LTE 100" <?if($w==''){?>value="1050분"<?}else{?>value="<?=$wr_26?>"<?}?>></td></tr>
<tr id="newUrl7" style="display:none"><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>
<tr id="newUrl3" style="display:none">
<td class=write_head>무료문자</td>
<td>LTE 34 : <input class='ed' style="width:10%;" name=wr_27 id="wr_27" itemname="LTE 34" <?if($w==''){?>value="200건"<?}else{?>value="<?=$wr_27?>"<?}?>> LTE 42 : <input class='ed' style="width:10%;" name=wr_28 id="wr_28" itemname="LTE 42" <?if($w==''){?>value="200건"<?}else{?>value="<?=$wr_28?>"<?}?>> LTE 52 : <input class='ed' style="width:10%;" name=wr_29 id="wr_29" itemname="LTE 52" <?if($w==''){?>value="250건"<?}else{?>value="<?=$wr_29?>"<?}?>> LTE 62 : <input class='ed' style="width:10%;" name=wr_30 id="wr_30" itemname="LTE 62" <?if($w==''){?>value="350건"<?}else{?>value="<?=$wr_30?>"<?}?>><br>LTE 72 : <input class='ed' style="width:10%;" name=wr_31 id="wr_31" itemname="LTE 72" <?if($w==''){?>value="450건"<?}else{?>value="<?=$wr_31?>"<?}?>> LTE 85 : <input class='ed' style="width:10%;" name=wr_32 id="wr_32" itemname="LTE 85" <?if($w==''){?>value="650건"<?}else{?>value="<?=$wr_32?>"<?}?>> LTE 100 : <input class='ed' style="width:10%;" name=wr_33 id="wr_33" itemname="LTE 100" <?if($w==''){?>value="1050건"<?}else{?>value="<?=$wr_33?>"<?}?>></td></tr>
<tr id="newUrl8" style="display:none"><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>
<tr id="newUrl4" style="display:none">
<td class=write_head>무료데이터</td>
<td>LTE 34 : <input class='ed' style="width:10%;" name=wr_34 id="wr_34" itemname="LTE 34" <?if($w==''){?>value="550MB"<?}else{?>value="<?=$wr_34?>"<?}?>> LTE 42 : <input class='ed' style="width:10%;" name=wr_35 id="wr_35" itemname="LTE 42" <?if($w==''){?>value="1.1GB"<?}else{?>value="<?=$wr_35?>"<?}?>> LTE 52 : <input class='ed' style="width:10%;" name=wr_36 id="wr_36" itemname="LTE 52" <?if($w==''){?>value="2GB"<?}else{?>value="<?=$wr_36?>"<?}?>> LTE 62 : <input class='ed' style="width:10%;" name=wr_37 id="wr_37" itemname="LTE 62" <?if($w==''){?>value="5GB"<?}else{?>value="<?=$wr_37?>"<?}?>><br>LTE 72 : <input class='ed' style="width:10%;" name=wr_38 id="wr_38" itemname="LTE 72" <?if($w==''){?>value="9GB"<?}else{?>value="<?=$wr_38?>"<?}?>> LTE 85 : <input class='ed' style="width:10%;" name=wr_39 id="wr_39" itemname="LTE 85" <?if($w==''){?>value="13GB"<?}else{?>value="<?=$wr_39?>"<?}?>> LTE 100 : <input class='ed' style="width:10%;" name=wr_40 id="wr_40" itemname="LTE 100" <?if($w==''){?>value="18GB"<?}else{?>value="<?=$wr_40?>"<?}?>></td></tr>
<tr id="newUrl9" style="display:none"><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>
<tr id="newUrl5" style="display:none">
<td class=write_head>요금약정할인</td>
<td>LTE 34 : <input class='ed' style="width:10%;" name=wr_120 id="wr_120" itemname="LTE 34" <?if($w==''){?>value="7700"<?}else{?>value="<?=$wr_120?>"<?}?> /> LTE 42 : <input class='ed' style="width:10%;" name="wr_121" id="wr_121" itemname="LTE 42" <?if($w==''){?>value="11550"<?}else{?>value="<?=$wr_121?>"<?}?> /> LTE 52 : <input class='ed' style="width:10%;" name=wr_122 id="wr_122" itemname="LTE 52" <?if($w==''){?>value="14850"<?}else{?>value="<?=$wr_122?>"<?}?> /> LTE 62 : <input class='ed' style="width:10%;" name=wr_123 id="wr_123" itemname="LTE 62" <?if($w==''){?>value="17600"<?}else{?>value="<?=$wr_123?>"<?}?> /><br>LTE 72 : <input class='ed' style="width:10%;" name=wr_124 id="wr_124" itemname="LTE 72" <?if($w==''){?>value="19800"<?}else{?>value="<?=$wr_124?>"<?}?> /> LTE 85 : <input class='ed' style="width:10%;" name=wr_125 id="wr_125" itemname="LTE 85" <?if($w==''){?>value="22000"<?}else{?>value="<?=$wr_125?>"<?}?> /> LTE 100 : <input class='ed' style="width:10%;" name=wr_126 id="wr_126" itemname="LTE 100" <?if($w==''){?>value="26400"<?}else{?>value="<?=$wr_126?>"<?}?> /></td></tr>
<tr id="newUrl10" style="display:none"><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>
ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ

view.php

ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ
<?}else{?>
<tr>
<td width="53" height="32" align="center" bgcolor="<?=$bg_color?>"><strong><font color="#ffffff">구분</font></strong></td>
<td width="93" align="center" bgcolor="<?=$bg_color?>"><strong><font color="#ffffff">LTE 34</font></strong></td>
<td width="100" align="center" bgcolor="<?=$bg_color?>"><strong><font color="#ffffff">LTE 42</font></strong></td>
<td width="100" align="center" bgcolor="<?=$bg_color?>"><strong><font color="#ffffff">LTE 52</font></strong></td>
<td width="100" align="center" bgcolor="<?=$bg_color?>"><strong><font color="#ffffff">LTE 62</font></strong></td>
<td width="100" align="center" bgcolor="<?=$bg_color?>"><strong><font color="#ffffff">LTE 72</font></strong></td>
<td width="100" align="center" bgcolor="<?=$bg_color?>"><strong><font color="#ffffff">LTE 85</font></strong></td>
<td width="100" align="center" bgcolor="<?=$bg_color?>"><strong><font color="#ffffff">LTE 100</font></strong></td>
</tr>
<tr>
<td height="32" align="center" bgcolor="#e0ecfc">할부원금</td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_65])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_66])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_67])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_68])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_69])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_70])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_71])?></td>
</tr>
<tr>
<td height="32" align="center" bgcolor="#e0ecfc">LTE플러스약정할인</td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_100])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_101])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_102])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_103])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_104])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_105])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_106])?></td>
</tr>
<tr>
<td height="32" align="center" bgcolor="#e0ecfc">할부금지원</td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_107])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_108])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_109])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_110])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_111])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_112])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_113])?></td>
</tr>
<tr>
<td height="32" align="center" bgcolor="#e0ecfc">단말기 고객 총부담금</td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_65]+$view[wr_100])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_66]+$view[wr_101])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_67]+$view[wr_102])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_68]+$view[wr_103])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_69]+$view[wr_104])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_70]+$view[wr_105])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_71]+$view[wr_106])?></td>
</tr>
<tr>
<td height="32" align="center" bgcolor="#e0ecfc">단말기 월 부담금</td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_65]/$view[wr_114]-$view[wr_120])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_66]/$view[wr_114]-$view[wr_121])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_67]/$view[wr_114]-$view[wr_122])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_68]/$view[wr_114]-$view[wr_123])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_69]/$view[wr_114]-$view[wr_124])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_70]/$view[wr_114]-$view[wr_125])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_71]/$view[wr_114]-$view[wr_126])?></td>
</tr>
ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ

write.php 소스에서

<tr id="newUrl5" style="display:none">
<td class=write_head>요금약정할인</td>
<td>LTE 34 : <input class='ed' style="width:10%;" name=wr_120 id="wr_120" itemname="LTE 34" <?if($w==''){?>value="7700"<?}else{?>value="<?=$wr_120?>"<?}?> /> LTE 42 : <input class='ed' style="width:10%;" name="wr_121" id="wr_121" itemname="LTE 42" <?if($w==''){?>value="11550"<?}else{?>value="<?=$wr_121?>"<?}?> /> LTE 52 : <input class='ed' style="width:10%;" name=wr_122 id="wr_122" itemname="LTE 52" <?if($w==''){?>value="14850"<?}else{?>value="<?=$wr_122?>"<?}?> /> LTE 62 : <input class='ed' style="width:10%;" name=wr_123 id="wr_123" itemname="LTE 62" <?if($w==''){?>value="17600"<?}else{?>value="<?=$wr_123?>"<?}?> /><br>LTE 72 : <input class='ed' style="width:10%;" name=wr_124 id="wr_124" itemname="LTE 72" <?if($w==''){?>value="19800"<?}else{?>value="<?=$wr_124?>"<?}?> /> LTE 85 : <input class='ed' style="width:10%;" name=wr_125 id="wr_125" itemname="LTE 85" <?if($w==''){?>value="22000"<?}else{?>value="<?=$wr_125?>"<?}?> /> LTE 100 : <input class='ed' style="width:10%;" name=wr_126 id="wr_126" itemname="LTE 100" <?if($w==''){?>value="26400"<?}else{?>value="<?=$wr_126?>"<?}?> /></td></tr>
<tr id="newUrl10" style="display:none"><td colspan=2 height=1 bgcolor=#e7e7e7></td></tr>

위부분에 적용된 내용이

view.php 소스의

<tr>
<td height="32" align="center" bgcolor="#e0ecfc">단말기 월 부담금</td>
<td align="center" bgcolor="#f3f3f3"><?=number_format($view[wr_65]/$view[wr_114])-$view[wr_120])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format(($view[wr_66]/$view[wr_114])-$view[wr_121])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format(($view[wr_67]/$view[wr_114])-$view[wr_122])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format(($view[wr_68]/$view[wr_114])-$view[wr_123])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format(($view[wr_69]/$view[wr_114])-$view[wr_124])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format(($view[wr_70]/$view[wr_114])-$view[wr_125])?></td>
<td align="center" bgcolor="#f3f3f3"><?=number_format(($view[wr_71]/$view[wr_114])-$view[wr_126])?></td>
</tr>

여기 적용이 되어야 하는데 전혀 적용이안되거든요-0-
나누기는 되는데 그다음 빼기가...안되네요...-0-

복사
공유하기

댓글 전체

맞을꺼야 자기소개 아이디로 검색 회원게시물

자기소개 아이디로 검색 회원게시물

13.02.05 10:18:06

write_update.php
파일 insert부분을 echo $sql; 이런식으로 하신후 콘솔에서 작동해 보세요
아마 쿼리 부분 오류 일껍니다.

APRiCA 홈페이지 자기소개 아이디로 검색 회원게시물

홈페이지 자기소개 아이디로 검색 회원게시물

13.02.05 11:22:04

if ($w == "" && $board[bo_4] != "") { // 게시판 환경설정에 값이있는 경우만 실행 (list.skin.php와 연동)

$thu_quality = '99'; // 썸네일화질 (Quality)
$img_resizing = $board[bo_4]; // 이미지 축소크기(pixel)

$data_path = $g4[path]."/data/file/$bo_table";
// $thumb_path = $data_path.'/thumb';

$sql2=" select * from $g4[board_file_table] where bo_table = '$bo_table' and wr_id = '$wr_id' order by bf_no asc";
$results2 = sql_query($sql2);

for ($d=0; $row2=sql_fetch_array($results2); $d++) {

if ($_FILES[bf_file][name][$d]) {
$file = $data_path .'/'. $row2[bf_file];

if (preg_match("/.(jp[e]?g|gif|png)$/i", $file)) {
$size = getimagesize($file);
if ($size[2] == 1)
$src = imagecreatefromgif($file);
else if ($size[2] == 2)
$src = imagecreatefromjpeg($file);
else if ($size[2] == 3)
$src = imagecreatefrompng($file);
else
break;

$rate = $img_resizing / $size[0];
$height = (int)($size[1] * $rate);

if ($size[0] > $img_resizing){

@unlink($data_path.'/'.$row2[bf_file]);
$dst = imagecreatetruecolor($img_resizing, $height);
imagecopyresampled($dst, $src, 0, 0, 0, 0, $img_resizing, $height, $size[0], $size[1]);
imagejpeg($dst, $data_path.'/'.$row2[bf_file], $thu_quality);
chmod($data_path.'/'.$row2[bf_file], 0707);

$bf_size = @filesize(addslashes($file));
$sql = " update $g4[board_file_table]
set bf_filesize = '$bf_size'
where bo_table = '$bo_table' and wr_id = '$wr_id' ";
sql_query($sql);

}
}
}
}

}
// ---------- 이미지 리사이징 END ----------------------------------- //
?>

<?
if ($w == 'u' && $is_admin) { // 게시물의 등록날짜 수정 (수정모드에서 관리자만 허용)
$sql = " update $write_table set wr_datetime = '$wr_datetime'
where wr_id = '$wr_id' ";
sql_query($sql);
}

if ($w == 'u' && $is_admin) { // 게시물의 조회수 수정 (수정모드에서 관리자만 허용)
$sql = " update $write_table set wr_hit = '$wr_hit'
where wr_id = '$wr_id' ";
sql_query($sql);
}
?>

<?
// --- [★★★ 기능] 글등록후, 리스트화면으로 이동
// goto_url("./board.php?bo_table=$bo_table");
?>

요기 write_update.php는 없고...
write_update.skin은 있네요..같은건다..ㅜㅜ
무튼 어딜 고쳐야 할까요..ㅠㅜㅠㅜ 비슷한건 건드려봐도 반응이 없네요ㅠㅠ

if ($w == "" && $board[bo_4] != "") { // 게시판 환경설정에 값이있는 경우만 실행 (list.skin.php와 연동)

$thu_quality  = '99';  // 썸네일화질 (Quality)
$img_resizing = $board[bo_4]; // 이미지 축소크기(pixel)

$data_path = $g4[path]."/data/file/$bo_table"; 
// $thumb_path = $data_path.'/thumb';

$sql2=" select * from $g4[board_file_table] where  bo_table = '$bo_table' and wr_id = '$wr_id' order by bf_no asc"; 
$results2 = sql_query($sql2);

for ($d=0; $row2=sql_fetch_array($results2); $d++) {

if ($_FILES[bf_file][name][$d]) { 
		$file = $data_path .'/'. $row2[bf_file];

if (preg_match("/.(jp[e]?g|gif|png)$/i", $file)) { 
			$size = getimagesize($file); 
		if ($size[2] == 1) 
			$src = imagecreatefromgif($file); 
		else if ($size[2] == 2) 
			$src = imagecreatefromjpeg($file); 
		else if ($size[2] == 3) 
			$src = imagecreatefrompng($file); 
		else 
		break;

$rate = $img_resizing / $size[0]; 
	$height = (int)($size[1] * $rate);

if ($size[0] > $img_resizing){

@unlink($data_path.'/'.$row2[bf_file]); 
		$dst = imagecreatetruecolor($img_resizing, $height); 
		imagecopyresampled($dst, $src, 0, 0, 0, 0, $img_resizing, $height, $size[0], $size[1]); 
		imagejpeg($dst, $data_path.'/'.$row2[bf_file], $thu_quality); 
		chmod($data_path.'/'.$row2[bf_file], 0707);

$bf_size = @filesize(addslashes($file)); 
		$sql = " update $g4[board_file_table] 
		set bf_filesize = '$bf_size' 
		where  bo_table = '$bo_table' and wr_id = '$wr_id'  "; 
		sql_query($sql); 
  
		 } 
	   } 
     } 
   }

}
// ---------- 이미지 리사이징 END ----------------------------------- //
?>

<?
if ($w == 'u' && $is_admin) { // 게시물의 등록날짜 수정 (수정모드에서 관리자만 허용)
        $sql = " update $write_table set wr_datetime = '$wr_datetime' 
                where wr_id = '$wr_id' "; 
        sql_query($sql); 
    }

if ($w == 'u' && $is_admin) { // 게시물의 조회수 수정 (수정모드에서 관리자만 허용)
       $sql = " update $write_table set wr_hit = '$wr_hit' 
                where wr_id = '$wr_id' "; 
        sql_query($sql); 
    } 
?>

<?
// --- [★★★ 기능] 글등록후, 리스트화면으로 이동
// goto_url("./board.php?bo_table=$bo_table");
?>

요기 write_update.php는 없고...
write_update.skin은 있네요..같은건다..ㅜㅜ
무튼 어딜 고쳐야 할까요..ㅠㅜㅠㅜ 비슷한건 건드려봐도 반응이 없네요ㅠㅠ

그누4 질문답변

본문

공유하기

댓글 전체