= 100){ $pr_txt = mb_substr($row['pr_txt'], 0, 100, 'UTF-8'); }else{ $pr_txt = $row['pr_txt']; } $comment_flg = $row['comment']; $estimate_flg = $row['estimate']; //クリエイター情報を取得 $sql = "select * from creater_tbl where creater_id = '".$row['creater_id']."'"; $res_creater = db_sql($sql, $conn_id); //SQL実行 $prof_row = mysql_fetch_array($res_creater); //写真のパス if($row['image_pic01'] != ""){ $pic = explode(".",$row['image_pic01']); $detail_pic = $pic[0]."detail.".$pic[1]; $size = @getImageSize("..".$detail_pic); if($size[0] == "" || $size[1] == ""){ $detail_pic = "/common/images/noimage03.gif"; $size = @getImageSize("..".$detail_pic); } }else{ $detail_pic = "/common/images/noimage03.gif"; $size = @getImageSize("..".$detail_pic); } //編集するボタンの処理 if($_POST['edit'] == "編集する" || $_POST['edit_x']){ session_initial(); header("Location:./index.php?serv_id=".$_GET['serv_id']); exit; } //削除するボタンの処理 if($_POST['delete'] == "削除する" || $_POST['delete_x']){ session_initial(); header("Location:./delete_confirm.php?serv_id=".$_GET['serv_id']); exit; } //評価済みかどうか? if($_SESSION['sumi_flg'] != 1){ //Goodボタンクリック時 if($_POST['good'] == "Good" || $_POST['good_x']){ //コメントテーブルに投稿 $sql = "insert into comment_tbl( service_id, creater_id, good, bad, ip_address, regist_date) values( '".$_GET['serv_id']."', '".$_SESSION['creater_id']."', '1', '', '".gethostbyname(gethostbyaddr($_SERVER['REMOTE_ADDR']))."', '".date("Y-m-d H:i:s")."')"; //echo $sql; $res_good = db_sql($sql, $conn_id); //SQL実行 $_SESSION['sumi_flg'] = 1; } //Badボタンクリック時 if($_POST['bad'] == "Bad" || $_POST['bad_x']){ //コメントテーブルに投稿 $sql = "insert into comment_tbl( service_id, creater_id, good, bad, ip_address, regist_date) values( '".$_GET['serv_id']."', '".$_SESSION['creater_id']."', '', '1', '".gethostbyname(gethostbyaddr($_SERVER['REMOTE_ADDR']))."', '".date("Y-m-d H:i:s")."')"; $res_bad = db_sql($sql, $conn_id); //SQL実行 $_SESSION['sumi_flg'] = 1; } //コメントするボタンクリック処理 if($_POST['commentbtn'] == "投稿する" || $_POST['commentbtn_x']){ //評価かコメントはどちらかを入力 if($_POST['title'] == "" && $_POST['comment'] == ""){ $err_txt = "評価またはコメントを入力してください。"; }else{ //評価を振り分け if($_POST['title'] == 1){ $good = 1; }else if($_POST['title'] == 2){ $bad = 1; }else{ $good = 0; $bad = 0; } //コメントテーブルに投稿 $sql = "insert into comment_tbl( service_id, creater_id, good, bad, comment, ip_address, regist_date) values( '".$_GET['serv_id']."', '".$_SESSION['creater_id']."', '".$good."', '".$bad."', '".str_replace("'","''",$_POST['comment'])."', '".gethostbyname(gethostbyaddr($_SERVER['REMOTE_ADDR']))."', '".date("Y-m-d H:i:s")."')"; $res_comment = db_sql($sql, $conn_id); //SQL実行 $_SESSION['sumi_flg'] = 1; } } } //コメント・評価を削除する if($_GET['del_id'] != ""){ //コメントテーブルに投稿 $sql = "delete from comment_tbl where comment_id = '".$_GET['del_id']."'"; $res_del = db_sql($sql, $conn_id); //SQL実行 } ?> <? echo $row['title'] ?>|ツクログ " />

クリエイター:  リリース日:

'' order by regist_date desc"; $result = db_sql($sql, $conn_id); //SQL実行 $all_num = mysql_num_rows($result); //該当件数の取得 //ページ数の計算 if($all_num > 10){ $page_num = $all_num / 10; //あまりの件数はありますか? if($all_num % 10 != 0){ $page_num ++; $page_num = floor($page_num); } }else{ $page_num = 1; } //該当ページの指定がない場合 if($_GET['page'] == "" || $_GET['page'] == 0){ $page_no = 1; //該当ページの指定がある場合 }else{ $page_no = $_GET['page']; } //10件づつ表示 $start = ($page_no - 1) * 10; $sql = "select * from comment_tbl where service_id = '".$_GET['serv_id']."' and comment <> '' order by regist_date desc limit ".$start.", 10"; $res_comment = db_sql($sql, $conn_id); //SQL実行 } if($comment_flg != 1){ ?>

$start + 10){ $disp_end = $start + 10; }else{ $disp_end = $all_num; } //10ページまで表示 if($page_num > 10 && $page_no <= $page_num - 9){ $start_page = $page_no; }else if($page_num > 10 && $page_no > $page_num - 9){ $start_page = $page_num - 9; }else{ $start_page = 1; } if($page_no == $page_num || $page_num <= 10){ $end_page = $page_num; }else{ $end_page = $start_page + 9; } //前のページへ表示 if($page_no != 1 && $page_num > 10){ $back = $page_no - 1; $page_html = $page_html."<<"; } //**** ページ移動処理 for($page_cnt = $start_page; $page_cnt <= $end_page; $page_cnt++){ if($page_no == $page_cnt){ $page_html = $page_html."".$page_cnt.""; }else{ $page_html = $page_html."".$page_cnt.""; } } //次のページへ表示 if($page_no <= $page_num - 9 && $page_num > 10){ $next = $page_no + 1; $page_html = $page_html.">>"; } echo $page_html; } ?>

    0 && $comment_flg != 1){ //コメントを表示 while($row_comment = mysql_fetch_array($res_comment)){ //クリエイター情報を取得 $sql = "select * from creater_tbl where creater_id = '".$row_comment['creater_id']."'"; $res_creater = db_sql($sql, $conn_id); //SQL実行 $prof_row = mysql_fetch_array($res_creater); if($prof_row['pic_path'] != ""){ if(strstr($prof_row['pic_path'], "twimg.com") != false && $prof_row['pic_path'] != ""){ $prof_pic = $prof_row['pic_path']; }else{ $prof_pic = $prof_row['pic_path']; $pic = explode(".",$prof_row['pic_path']); $prof_pic = $pic[0]."_thumb.".$pic[1]; } }else{ $prof_pic = "/common/images/noimage05.gif "; } ?>
  • Good! Bad!

     投稿日時: 削除する
  • まだコメントはありません。
$start + 10){ $disp_end = $start + 10; }else{ $disp_end = $all_num; } //10ページまで表示 if($page_num > 10 && $page_no <= $page_num - 9){ $start_page = $page_no; }else if($page_num > 10 && $page_no > $page_num - 9){ $start_page = $page_num - 9; }else{ $start_page = 1; } if($page_no == $page_num || $page_num <= 10){ $end_page = $page_num; }else{ $end_page = $start_page + 9; } //前のページへ表示 if($page_no != 1 && $page_num > 10){ $back = $page_no - 1; $page_html = $page_html."<<"; } //**** ページ移動処理 for($page_cnt = $start_page; $page_cnt <= $end_page; $page_cnt++){ if($page_no == $page_cnt){ $page_html = $page_html."".$page_cnt.""; }else{ $page_html = $page_html."".$page_cnt.""; } } //次のページへ表示 if($page_no <= $page_num - 9 && $page_num > 10){ $next = $page_no + 1; $page_html = $page_html.">>"; } echo $page_html; } ?>

評価
コメント
HTMLタグは使用できません。

同じカテゴリのサービス

    '".$_GET['serv_id']."' and".$like; $res_genre = db_sql($sql, $conn_id); //SQL実行 $all_num = mysql_num_rows($res_genre); }else{ $all_num = 0; } if($all_num != 0){ $sql = "select * from service_tbl where service_id <> '".$_GET['serv_id']."' and".$like." order by rand() limit 6"; $res_random = db_sql($sql, $conn_id); //SQL実行 while($ran_row = mysql_fetch_array($res_random)){ //情報解析 //写真のパス if($ran_row['image_pic01'] != ""){ $pic = explode(".",$ran_row['image_pic01']); $pick_pic = $pic[0]."picup.".$pic[1]; }else{ $pick_pic = "/common/images/noimage04.gif"; } //クリエイター情報を取得 $sql = "select * from creater_tbl where creater_id = '".$ran_row['creater_id']."'"; $res_creater = db_sql($sql, $conn_id); //SQL実行 $prof_row = mysql_fetch_array($res_creater); $size = @getImageSize(".".$pick_pic); ?>
  • sample
同じカテゴリーのサービスはありません。