約 2,720,500 件
https://w.atwiki.jp/aiit/pages/13.html
#html2(){{{{{{ a href="http //www.amazon.co.jp/gp/product/4627096011?ie=UTF8 tag=aiit08-22 linkCode=as2 camp=247 creative=7399 creativeASIN=4627096011" Rによるデータサイエンス - データ解析の基礎から最新手法まで /a img src="http //www.assoc-amazon.jp/e/ir?t=aiit08-22 l=as2 o=9 a=4627096011" width="1" height="1" border="0" alt="" style="border none !important; margin 0px !important;" / }}}}}} Rによるデータサイエンス - データ解析の基礎から最新手法まで
https://w.atwiki.jp/thecockrockshockpop/pages/2733.html
MusicHow Will I Know If Heaven Will Find Me? Music How Will I Know If Heaven Will Find Me? 2022 [ Fiction ] ( N 2406 ) 1. How Will I Know 2. Bloodrush 3. Say It Again 4. There's a Light 5. Northern Star 6. Wait for Me 7. One By One 8. Ready for Something 9. For the Night 10. In the Morning 11. I'm Not Ready
https://w.atwiki.jp/amazonz/pages/37.html
アップロード ?php require_once( Connections/connAmazon2.php ); ? ?php require_once( Connections/connAmazon2.php ); ? ?php $currentPage = $_SERVER["PHP_SELF"]; $maxRows_rsAmazonz2 = 10; $pageNum_rsAmazonz2 = 0; if (isset($_GET[ pageNum_rsAmazonz2 ])) { $pageNum_rsAmazonz2 = $_GET[ pageNum_rsAmazonz2 ]; } $startRow_rsAmazonz2 = $pageNum_rsAmazonz2 * $maxRows_rsAmazonz2; $colname_rsAmazonz2 = "%"; if (isset($_GET[ key ])) { //magic_quotes_gpcの設定に応じて取得した値を変換する $colname_rsAmazonz2 = (get_magic_quotes_gpc()) ? $_GET[ key ] addslashes($_GET[ key ]); } $maxRows_rsAmazonz2 = 5; $pageNum_rsAmazonz2 = 0; if (isset($_GET[ pageNum_rsAmazonz2 ])) { $pageNum_rsAmazonz2 = $_GET[ pageNum_rsAmazonz2 ]; } $startRow_rsAmazonz2 = $pageNum_rsAmazonz2 * $maxRows_rsAmazonz2; $key = $_GET[ key ]; mysql_select_db($database_connAmazon2, $connAmazon2); $query_rsAmazonz2 = sprintf("SELECT * FROM amazonz_data WHERE uset_id LIKE %s ORDER BY uptime DESC", $colname_rsAmazonz2); $query_limit_rsAmazonz2 = sprintf("%s LIMIT %d, %d", $query_rsAmazonz2, $startRow_rsAmazonz2, $maxRows_rsAmazonz2); $rsAmazonz2 = mysql_query($query_limit_rsAmazonz2, $connAmazon2) or die(mysql_error()); $row_rsAmazonz2 = mysql_fetch_assoc($rsAmazonz2); if (isset($_GET[ totalRows_rsAmazonz2 ])) { $totalRows_rsAmazonz2 = $_GET[ totalRows_rsAmazonz2 ]; } else { $all_rsAmazonz2 = mysql_query($query_rsAmazonz2); $totalRows_rsAmazonz2 = mysql_num_rows($all_rsAmazonz2); } $totalPages_rsAmazonz2 = ceil($totalRows_rsAmazonz2/$maxRows_rsAmazonz2)-1; $maxRows_rsMember = 10; $pageNum_rsMember = 0; if (isset($_GET[ pageNum_rsMember ])) { $pageNum_rsMember = $_GET[ pageNum_rsMember ]; } $startRow_rsMember = $pageNum_rsMember * $maxRows_rsMember; mysql_select_db($database_connAmazon2, $connAmazon2); $query_rsMember = "SELECT * FROM amazonz_user ORDER BY id DESC"; $query_limit_rsMember = sprintf("%s LIMIT %d, %d", $query_rsMember, $startRow_rsMember, $maxRows_rsMember); $rsMember = mysql_query($query_limit_rsMember, $connAmazon2) or die(mysql_error()); $row_rsMember = mysql_fetch_assoc($rsMember); if (isset($_GET[ totalRows_rsMember ])) { $totalRows_rsMember = $_GET[ totalRows_rsMember ]; } else { $all_rsMember = mysql_query($query_rsMember); $totalRows_rsMember = mysql_num_rows($all_rsMember); } $totalPages_rsMember = ceil($totalRows_rsMember/$maxRows_rsMember)-1; $queryString_rsAmazonz2 = ""; if (!empty($_SERVER[ QUERY_STRING ])) { $params = explode(" ", $_SERVER[ QUERY_STRING ]); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_rsAmazonz2") == false stristr($param, "totalRows_rsAmazonz2") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_rsAmazonz2 = " " . htmlentities(implode(" ", $newParams)); } } $queryString_rsAmazonz2 = sprintf(" totalRows_rsAmazonz2=%d%s", $totalRows_rsAmazonz2, $queryString_rsAmazonz2); ? !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http //www.w3.org/TR/html4/loose.dtd" html head meta http-equiv="Content-Type" content="text/html; charset=euc-jp" title メンバ検索 /title style type="text/css" !-- .style3 {font-size 10px} .style4 {color #FF0000} /style /head body form name="form1" method="get" action="" div align="center" p メンバ検索 /p ?php do { ? table width="250" border="0" cellpadding="3" tr td input name="key" type="radio" id="key" value=" ?php echo $row_rsMember[ id ]; ? " ?php echo $row_rsMember[ id ]; ? /td /tr /table ?php } while ($row_rsMember = mysql_fetch_assoc($rsMember)); ? input type="submit" name="Submit" value="メンバ検索" /div /form p align="center" span class="style3" !-- セレクトKEYが空でない場合以後表示 -- ?php if($key !=""){ $key = $_GET[ key ]; $kensu=$totalRows_rsAmazonz2; print(" $key で検索した結果"); print(" $kensu 件ヒットしました"); } ? /span レコード ?php echo ($startRow_rsAmazonz2 + 1) ? ～ ?php echo min($startRow_rsAmazonz2 + $maxRows_rsAmazonz2, $totalRows_rsAmazonz2) ? 件 / 全 ?php echo $totalRows_rsAmazonz2 ? /span /p table width="400" border="0" align="center" cellpadding="3" ?php do { ? tr td span class="style3" ?php echo $row_rsAmazonz2[ uptime ]; ? /span /td /tr tr td span class="style3" ?php echo $row_rsAmazonz2[ title ]; ? /span /td /tr tr td span class="style3" ?php echo $row_rsAmazonz2[ category ]; ? /span /td /tr tr td span class="style3" ?php echo nl2br($row_rsAmazonz2[ topic ]); ? /span /td /tr tr td span class="style3" ?php echo $row_rsAmazonz2[ uset_id ]; ? /span /td /tr tr td hr /td /tr ?php } while ($row_rsAmazonz2 = mysql_fetch_assoc($rsAmazonz2)); ? /table table border="0" width="50%" align="center" tr td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 0) { // Show if not first page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, 0, $queryString_rsAmazonz2); ? " 先頭 /a ?php } // Show if not first page ? /td td width="31%" align="center" ?php if ($pageNum_rsAmazonz2 0) { // Show if not first page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, max(0, $pageNum_rsAmazonz2 - 1), $queryString_rsAmazonz2); ? " 戻る /a ?php } // Show if not first page ? /td td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 $totalPages_rsAmazonz2) { // Show if not last page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, min($totalPages_rsAmazonz2, $pageNum_rsAmazonz2 + 1), $queryString_rsAmazonz2); ? " 次へ /a ?php } // Show if not last page ? /td td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 $totalPages_rsAmazonz2) { // Show if not last page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, $totalPages_rsAmazonz2, $queryString_rsAmazonz2); ? " 最終 /a ?php } // Show if not last page ? /td /tr /table /body /html ?php mysql_free_result($rsAmazonz2); mysql_free_result($rsMember); ?
https://w.atwiki.jp/antiqrm/pages/24.html
■Amazonレビューで「違和感」を感じたときには■ 【ロゼ作品を絶賛している人の特徴】 ・レビュー数が一つ（例：ハトアリ）だけ。他作品へのレビューが皆無。 ・他にも感想を書き込んでいるが、レビュー数がとても少ない。（2,3個） ・また、何故かレビューは乙女ゲー限定。ロゼ作品以外は酷評する傾向があり。 ・ロゼ作品には長々と詳しい感想が書き込まれているが、他作品へのレビュー（肥、水旋など） に関しては、具体的な内容批判がないなど不自然な点が多い。 【絶賛レビューで多用される言葉】 ※否定意見を曲解させた擁護と、似たような（同一人物？）美辞麗句が目立つため抜粋 ・賛否両論あるけど～ ・ファンやアンチの論争が絶えないほど話題性があって～ ・人を選ぶゲーム云々～ ・今までになかったタイプの～ ・シナリオが作り込まれていて～ ・クセのあるキャラクター～ ・全年齢向けだけど精神的に～ Amazonのレビューは、メルアドを複数取得すれば、いくらでも自演は可能です。 Amazonでの評判に釣られて購入してしまった人（アンチスレ来訪者）は多いようなので 購入を検討してらっしゃる方は、Amazon以外の評価も参考にしてみて下さい。 ---------------------------------------------------------- ■数々の自演疑惑の中でも最古のものを抜粋。 ■「魔法使いとご主人様」発売前後のもの。同一人物によるレビューです。 ---------------------------------------------------------- 魔法使い（発売済） 星５ シナリオや設定が面白いゲームです, taetaetaetae (プロフィールを見る) 福山 Japan シナリオが独特で、エンディングや展開も多数。イベント数が多くてやりこみ甲斐がある。 主人公の設定は強気で勝気なご主人様という設定ですが、ライトノベルみたいです。 重厚な感じではないけど、読みやすいｗ 恋愛イベントは激甘でした！ エンディング数があまりに多いので、コンプリートしたい人は大変かもしれませんが、 コンプリートにこだわらなければ苦痛ではありませんでした。 水の旋律（発売前） 星１ う～ん・・・, 2005/08/08 taetaetaetae (プロフィールを見る) 絵や声優さんはいいけど、ストーリーにひかれるものがないかも・・・。 シナリオが一番なので、発売後の評判待ちかな・・・； ---------------------------------------------------------- ※【・・・；】 公式サイトの制作日記で多用されている、特徴的な三点リーダーと； ( ﾟДﾟ) ＜…社員さん、何してんの？ 魔法使いとご主人様スレッドが祭に… 乙女＠魔法使いとご主人様２ 361 名前：名無しって呼んでいいか？ ：2005/09/06(火) 00 16 ID ??? 今までにない主人公が魅力です, 2005/09/04 レビュアー： 田所真○ 兵庫県神戸市 今までの恋愛シュミレーションの主人公とは一味違う主人公が魅力です。 恋愛相手を蹴ったり､苛めたりするんです｡ちょっと投影しにくいかもしれませんが、 プレイしていくにつれ楽しくなります。 他にも幼馴染と使い魔が取り合って喧嘩したり、女子校ノリを味わったり・・・ 素直な感情にしたがってプレイすると思わぬ反応が返って来る事も｡意外性もあり楽しめますよ 今までにない主人公です｡, 2005/09/04 レビュアー： エムエ○ 兵庫県神戸市 恋愛シュミレーションの主人公としては、個性的な主人公が魅力です｡ 恋愛相手を蹴ったり､いじめたりする事もあるので、はじめは投影しにくい人もいるかもしれませんが、 プレイしていくうちに楽しくなります｡ それに幼馴染と使い魔が主人公を取り合って喧嘩をしてくれたり、女子校ノリが楽しめたり・・・ オススメです。自分の感情に素直になって楽しみましょう なんでｱﾏｿﾞﾝのレビューってそっくりなんだ？ 362 名前：名無しって呼んでいいか？ ：2005/09/06(火) 00 19 ID ??? どっちかがパクって書いたんじゃねーの？ 363 名前：名無しって呼んでいいか？ ：2005/09/06(火) 00 20 ID ??? ｱﾏｿﾞﾝのレビューは流通が書いてる場合がある。 ソフトバンク 453 名前：名無しって呼んでいいか？投稿日：2005/09/08(木) 08 35 50 ID ??? 魔法使い（発売済） 星５ シナリオや設定が面白いゲームです, taetaetaetae (プロフィールを見る) 福山 Japan シナリオが独特で、エンディングや展開も多数。 イベント数が多くてやりこみ甲斐がある。 主人公の設定は強気で勝気なご主人様という設定ですが、 ライトノベルみたいです。重厚な感じではないけど、読みやすいｗ 恋愛イベントは激甘でした！ エンディング数があまりに多いので、コンプリートしたい人は大変かもしれませんが、 コンプリートにこだわらなければ苦痛ではありませんでした。 水の旋律（発売前） 星１ う～ん・・・, 2005/08/08 taetaetaetae (プロフィールを見る) 絵や声優さんはいいけど、ストーリーにひかれるものがないかも・・・。 シナリオが一番なので、発売後の評判待ちかな・・・； ←（！） ↑( ﾟДﾟ) ＜…社員さん、何してんの？ 465 名前：名無しって呼んでいいか？投稿日：2005/09/08(木) 13 16 06 ID ??? レビュー書いた人の個人情報が丸見えになるトラブルがあった時 自分の作品に作家本人が好意的なレビューを書いてるのが たくさん見つかって騒ぎになったことがあったような… たしかあれは海外の密林だったと思うけど 467 名前：名無しって呼んでいいか？投稿日：2005/09/08(木) 14 04 42 ID ??? 試聴盤を聞けたり見られたりする音楽ＣＤやＤＶＤなんかと違って 発売前のゲームの低評価っておかしいっつか、普通の人間じゃやらないだろ。 体験版とかあったとしてもあくまで一部だし変更点ある可能性もあるし 体験版の部分のもっと先にすごいことが起きてるかもしれないと思えば いくらなんでも評価１とか、そんなの言えないと思うんだよね。 よっぽど自分の目に自信を持ってる人か、 そのソフトを陥れようとする悪意の人間か、 ライバル会社の中の人なんだろうな＞フライング評価。 ねえコウタマ。 477 名前：名無しって呼んでいいか？投稿日：2005/09/09(金) 03 43 14 ID ??? 参考になった人の人数が面白すぎる。 それを教えちゃったら 明日からコウ様が必死で「参考になった」を クリックしちゃうyo！
https://w.atwiki.jp/amazonz/pages/39.html
アップロード ?php require_once('Connections/connAmazon2.php'); ? !-- アクセス制御 -- ?php session_start(); $MM_authorizedUsers = ""; $MM_donotCheckaccess = "true"; function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { // For security, start by assuming the visitor is NOT authorized. $isValid = False; // When a visitor has logged into this site, the Session variable MM_Username set equal to their username. // Therefore, we know that a user is NOT logged in if that Session variable is blank. if (!empty($UserName)) { // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. // Parse the strings into arrays. $arrUsers = Explode(",", $strUsers); $arrGroups = Explode(",", $strGroups); if (in_array($UserName, $arrUsers)) { $isValid = true; } // Or, you may restrict access to only certain users based on their username. if (in_array($UserGroup, $arrGroups)) { $isValid = true; } if (($strUsers == "") true) { $isValid = true; } } return $isValid; } $MM_restrictGoTo = "account_cre2.php"; if (!(*1) (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) { $MM_qsChar = "?"; $MM_referrer = $_SERVER['PHP_SELF']; if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = " "; if (isset($QUERY_STRING) strlen($QUERY_STRING) 0) $MM_referrer .= "?" . $QUERY_STRING; $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer); header("Location ". $MM_restrictGoTo); exit; } ? ?php $currentPage = $_SERVER["PHP_SELF"]; $maxRows_rsAmazonz2 = 5; $pageNum_rsAmazonz2 = 0; if (isset($_GET['pageNum_rsAmazonz2'])) { $pageNum_rsAmazonz2 = $_GET['pageNum_rsAmazonz2']; } $startRow_rsAmazonz2 = $pageNum_rsAmazonz2 * $maxRows_rsAmazonz2; $colname_rsAmazonz2 = "%"; if (isset($_GET['key'])) { $colname_rsAmazonz2 = (get_magic_quotes_gpc()) ? $_GET['key'] addslashes($_GET['key']); } mysql_select_db($database_connAmazon2, $connAmazon2); $query_rsAmazonz2 = sprintf("SELECT * FROM amazonz_data WHERE topic LIKE '%s' ORDER BY uptime DESC", $colname_rsAmazonz2); $query_limit_rsAmazonz2 = sprintf("%s LIMIT %d, %d", $query_rsAmazonz2, $startRow_rsAmazonz2, $maxRows_rsAmazonz2); $rsAmazonz2 = mysql_query($query_limit_rsAmazonz2, $connAmazon2) or die(mysql_error()); $row_rsAmazonz2 = mysql_fetch_assoc($rsAmazonz2); if (isset($_GET['totalRows_rsAmazonz2'])) { $totalRows_rsAmazonz2 = $_GET['totalRows_rsAmazonz2']; } else { $all_rsAmazonz2 = mysql_query($query_rsAmazonz2); $totalRows_rsAmazonz2 = mysql_num_rows($all_rsAmazonz2); } $totalPages_rsAmazonz2 = ceil($totalRows_rsAmazonz2/$maxRows_rsAmazonz2)-1; $queryString_rsAmazonz2 = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode(" ", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_rsAmazonz2") == false stristr($param, "totalRows_rsAmazonz2") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_rsAmazonz2 = " " . htmlentities(implode(" ", $newParams)); } } $queryString_rsAmazonz2 = sprintf(" totalRows_rsAmazonz2=%d%s", $totalRows_rsAmazonz2, $queryString_rsAmazonz2); ? ?php session_start(); $logoutAction = $_SERVER['PHP_SELF']."?doLogout=true"; if (*2) ($_SERVER['QUERY_STRING'] != "")){ $logoutAction .=" ". htmlentities($_SERVER['QUERY_STRING']); } if (*3) ($_GET['doLogout']=="true")){ //to fully log out a visitor we need to clear the session varialbles session_unregister('MM_Username'); session_unregister('MM_UserGroup'); $logoutGoTo = "[[top.php]]"; if ($logoutGoTo) { header("Location $logoutGoTo"); exit; } } ? ?php $currentPage = $_SERVER["PHP_SELF"]; function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) $theValue; switch ($theType) { case "text" $theValue = ($theValue != "") ? "'" . $theValue . "'" "NULL"; break; case "long" case "int" $theValue = ($theValue != "") ? intval($theValue) "NULL"; break; case "double" $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" "NULL"; break; case "date" $theValue = ($theValue != "") ? "'" . $theValue . "'" "NULL"; break; case "defined" $theValue = ($theValue != "") ? $theDefinedValue $theNotDefinedValue; break; } return $theValue; } $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if (*4) ($_POST["MM_insert"] == "form2")) { $insertSQL = sprintf("INSERT INTO amazonz_data (id, title, category, topic, uptime, uset_id) VALUES (%s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['id'], "int"), GetSQLValueString($_POST['title'], "text"), GetSQLValueString($_POST['category'], "text"), GetSQLValueString($_POST['topic'], "text"), GetSQLValueString($_POST['uptime'], "date"), GetSQLValueString($_POST['uset_id'], "text")); mysql_select_db($database_connAmazon2, $connAmazon2); $Result1 = mysql_query($insertSQL, $connAmazon2) or die(mysql_error()); $insertGoTo = "admin2.php"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? " " "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location %s", $insertGoTo)); } $maxRows_rsAmazonz2 = 5; $pageNum_rsAmazonz2 = 0; if (isset($_GET['pageNum_rsAmazonz2'])) { $pageNum_rsAmazonz2 = $_GET['pageNum_rsAmazonz2']; } $startRow_rsAmazonz2 = $pageNum_rsAmazonz2 * $maxRows_rsAmazonz2; mysql_select_db($database_connAmazon2, $connAmazon2); $query_rsAmazonz2 = "SELECT * FROM amazonz_data ORDER BY uptime DESC"; $query_limit_rsAmazonz2 = sprintf("%s LIMIT %d, %d", $query_rsAmazonz2, $startRow_rsAmazonz2, $maxRows_rsAmazonz2); $rsAmazonz2 = mysql_query($query_limit_rsAmazonz2, $connAmazon2) or die(mysql_error()); $row_rsAmazonz2 = mysql_fetch_assoc($rsAmazonz2); if (isset($_GET['totalRows_rsAmazonz2'])) { $totalRows_rsAmazonz2 = $_GET['totalRows_rsAmazonz2']; } else { $all_rsAmazonz2 = mysql_query($query_rsAmazonz2); $totalRows_rsAmazonz2 = mysql_num_rows($all_rsAmazonz2); } $totalPages_rsAmazonz2 = ceil($totalRows_rsAmazonz2/$maxRows_rsAmazonz2)-1; mysql_select_db($database_connAmazon2, $connAmazon2); $sessionname=$_SESSION['MM_Username']; $query_rsAmazonz2 = sprintf("SELECT * FROM amazonz_data WHERE topic LIKE '%s' uset_id = '$sessionname' ORDER BY uptime DESC" , $colname_rsAmazonz2); $query_limit_rsAmazonz2 = sprintf("%s LIMIT %d, %d", $query_rsAmazonz2, $startRow_rsAmazonz2, $maxRows_rsAmazonz2); $rsAmazonz2 = mysql_query($query_limit_rsAmazonz2, $connAmazon2) or die(mysql_error()); $row_rsAmazonz2 = mysql_fetch_assoc($rsAmazonz2); if (isset($_GET['totalRows_rsAmazonz2'])) { $totalRows_rsAmazonz2 = $_GET['totalRows_rsAmazonz2']; } else { $all_rsAmazonz2 = mysql_query($query_rsAmazonz2); $totalRows_rsAmazonz2 = mysql_num_rows($all_rsAmazonz2); } $totalPages_rsAmazonz2 = ceil($totalRows_rsAmazonz2/$maxRows_rsAmazonz2)-1; $queryString_rsAmazonz2 = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode(" ", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_rsAmazonz2") == false stristr($param, "totalRows_rsAmazonz2") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_rsAmazonz2 = " " . htmlentities(implode(" ", $newParams)); } } $queryString_rsAmazonz2 = sprintf(" totalRows_rsAmazonz2=%d%s", $totalRows_rsAmazonz2, $queryString_rsAmazonz2); ? html xmlns="http //www.w3.org/1999/xhtml" head meta http-equiv="Content-Type" content="text/html; charset=euc-jp" / title Amazonz -管理- /title link href="css.css" rel="stylesheet" type="text/css" / script language="JavaScript" type="text/javascript" !-- function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a i a.length (x=a[i]) x.oSrc;i++) x.src=x.oSrc; } function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?")) 0 parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n]) d.all) x=d.all[n]; for (i=0;!x i d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x d.layers i d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x d.getElementById) x=d.getElementById(n); return x; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i (a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } /script /head body onload="MM_preloadImages('img/account2.jpg','img/key2.jpg','img/member2.jpg','img/kate2.jpg')" div id="body_2" div id="head" div id="head1" /div div id="head2" /div /div div id="main" div id="menu" div class="img1" img src="img/menu1.jpg" width="180" height="24" class="img1" / /div div class="img1" div class="img1" ?php echo ($_SESSION['MM_Username']. "さん こんにちわ！"); ? /div p a href=" ?php echo $logoutAction ? " ログアウト /a a href="top.php" 投稿閲覧 /a /p /div div class="img1" img src="img/menu1.jpg" width="180" height="24" hspace="0" vspace="0" border="0" class="img1" / /div div class="img1" a href="[[member_s.php]]" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image10','','img/member2.jpg',1)" img src="img/member.jpg" alt="メンバー検索" name="Image10" width="180" height="40" border="0" id="Image10" / /a /div div class="img1" a href="[[category_s.php]]" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image11','','img/kate2.jpg',1)" img src="img/kate.jpg" alt="カテゴリー検索" name="Image11" width="180" height="40" border="0" id="Image11" / /a /div div class="img1" a href="[[key_s.php]]" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image9','','img/key2.jpg',1)" img src="img/key.jpg" alt="キーワード検索" name="Image9" width="180" height="40" border="0" id="Image9" / /a /div /div div id="text" img src="img/blank.jpg" / form action=" ?php echo $editFormAction; ? " method="post" name="form2" id="form2" table width="250" height="100" align="center" tr valign="baseline" td align="left" nowrap="nowrap" class="style3" タイトル： input type="text" name="title" value="" size="32" / /td /tr tr valign="baseline" td align="left" nowrap="nowrap" class="style3" カテゴリ： select name="category" option value="BOOK" ?php if (!(strcmp("BOOK", ""))) {echo "SELECTED";} ? BOOK /option option value="DVD" ?php if (!(strcmp("DVD", ""))) {echo "SELECTED";} ? DVD /option option value="MUSIC" ?php if (!(strcmp("MUSIC", ""))) {echo "SELECTED";} ? MUSIC /option /select /td /tr tr valign="baseline" td align="left" valign="top" nowrap="nowrap" p class="style3" トピック： br / textarea name="topic" cols="40" rows="5" /textarea /p /td /tr tr valign="baseline" td align="left" nowrap="nowrap" class="style3" input type="submit" value="投稿" / /td /tr /table span class="style3" input type="hidden" name="id" value="" / input type="hidden" name="uptime" value=" ?php echo date('Y/m/d H i s'); ? " / input type="hidden" name="uset_id" value=" ?php echo($_SESSION['MM_Username']); ? " / input type="hidden" name="MM_insert" value="form2" / /span /form table width="400" border="0" align="center" cellpadding="3" ?php do { ? tr td class="style3" ?php echo $row_rsAmazonz2['uptime']; ? /td /tr tr td class="style3" ?php echo $row_rsAmazonz2['title']; ? /td /tr tr td class="style3" ?php echo $row_rsAmazonz2['category']; ? /td /tr tr td class="style3" ?php echo $row_rsAmazonz2['topic']; ? /td /tr tr td class="style3" ?php echo $row_rsAmazonz2['uset_id']; ? /td /tr tr td span class="style3" a href="[[update2.php]]?id= ?php echo $row_rsAmazonz2['id']; ? " 修正 /a a href="[[del2.php]]?id= ?php echo $row_rsAmazonz2['id']; ? " 削除 /a /span hr / /td /tr ?php } while ($row_rsAmazonz2 = mysql_fetch_assoc($rsAmazonz2)); ? /table table border="0" width="50%" align="center" tr td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 0) { // Show if not first page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, 0, $queryString_rsAmazonz2); ? " 先頭 /a ?php } // Show if not first page ? /td td width="31%" align="center" ?php if ($pageNum_rsAmazonz2 0) { // Show if not first page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, max(0, $pageNum_rsAmazonz2 - 1), $queryString_rsAmazonz2); ? " 戻る /a ?php } // Show if not first page ? /td td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 $totalPages_rsAmazonz2) { // Show if not last page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, min($totalPages_rsAmazonz2, $pageNum_rsAmazonz2 + 1), $queryString_rsAmazonz2); ? " 次へ /a ?php } // Show if not last page ? /td td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 $totalPages_rsAmazonz2) { // Show if not last page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, $totalPages_rsAmazonz2, $queryString_rsAmazonz2); ? " 最終 /a ?php } // Show if not last page ? /td /tr /table ?php mysql_free_result($rsAmazonz2); ? /div div id="under" div id="under1" /div div id="under2" /div /div /div /div /body /html
https://w.atwiki.jp/amazonz/pages/38.html
アップロード ?php require_once('Connections/connAmazon2.php'); ? ?php $currentPage = $_SERVER["PHP_SELF"]; $maxRows_rsAmazonz2 = 5; $pageNum_rsAmazonz2 = 0; if (isset($_GET['pageNum_rsAmazonz2'])) { $pageNum_rsAmazonz2 = $_GET['pageNum_rsAmazonz2']; } $startRow_rsAmazonz2 = $pageNum_rsAmazonz2 * $maxRows_rsAmazonz2; $colname_rsAmazonz2 = "%"; if (isset($_GET['key'])) { $colname_rsAmazonz2 = (get_magic_quotes_gpc()) ? $_GET['key'] addslashes($_GET['key']); } mysql_select_db($database_connAmazon2, $connAmazon2); $query_rsAmazonz2 = sprintf("SELECT * FROM amazonz_data WHERE topic LIKE '%s' ORDER BY uptime DESC", $colname_rsAmazonz2); $query_limit_rsAmazonz2 = sprintf("%s LIMIT %d, %d", $query_rsAmazonz2, $startRow_rsAmazonz2, $maxRows_rsAmazonz2); $rsAmazonz2 = mysql_query($query_limit_rsAmazonz2, $connAmazon2) or die(mysql_error()); $row_rsAmazonz2 = mysql_fetch_assoc($rsAmazonz2); if (isset($_GET['totalRows_rsAmazonz2'])) { $totalRows_rsAmazonz2 = $_GET['totalRows_rsAmazonz2']; } else { $all_rsAmazonz2 = mysql_query($query_rsAmazonz2); $totalRows_rsAmazonz2 = mysql_num_rows($all_rsAmazonz2); } $totalPages_rsAmazonz2 = ceil($totalRows_rsAmazonz2/$maxRows_rsAmazonz2)-1; $queryString_rsAmazonz2 = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode(" ", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_rsAmazonz2") == false stristr($param, "totalRows_rsAmazonz2") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_rsAmazonz2 = " " . htmlentities(implode(" ", $newParams)); } } $queryString_rsAmazonz2 = sprintf(" totalRows_rsAmazonz2=%d%s", $totalRows_rsAmazonz2, $queryString_rsAmazonz2); ? ?php session_start(); $loginFormAction = $_SERVER['PHP_SELF']; if (isset($accesscheck)) { $GLOBALS['PrevUrl'] = $accesscheck; session_register('PrevUrl'); } if (isset($_POST['id'])) { $loginUsername=$_POST['id']; $password=$_POST['pass']; $MM_fldUserAuthorization = ""; $MM_redirectLoginSuccess = "[[admin2.php]]"; $MM_redirectLoginFailed = "[[account_cre.php]]"; $MM_redirecttoReferrer = false; mysql_select_db($database_connAmazon2, $connAmazon2); $LoginRS__query=sprintf("SELECT id, pass FROM amazonz_user WHERE id='%s' AND pass='%s'", get_magic_quotes_gpc() ? $loginUsername addslashes($loginUsername), get_magic_quotes_gpc() ? $password addslashes($password)); $LoginRS = mysql_query($LoginRS__query, $connAmazon2) or die(mysql_error()); $loginFoundUser = mysql_num_rows($LoginRS); if ($loginFoundUser) { $loginStrGroup = ""; //セッション変数の宣言と割り当て $GLOBALS['MM_Username'] = $loginUsername; $GLOBALS['MM_UserGroup'] = $loginStrGroup; //セッション変数の登録 session_register("MM_Username"); session_register("MM_UserGroup"); if (isset($_SESSION['PrevUrl']) false) { $MM_redirectLoginSuccess = $_SESSION['PrevUrl']; } header("Location " . $MM_redirectLoginSuccess ); } else { header("Location ". $MM_redirectLoginFailed ); } } ? !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http //www.w3.org/TR/html4/loose.dtd" html head meta http-equiv="Content-Type" content="text/html; charset=euc-jp" title Amazonz /title link href="css.css" rel="stylesheet" type="text/css" script language="JavaScript" type="text/JavaScript" !-- function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a i a.length (x=a[i]) x.oSrc;i++) x.src=x.oSrc; } function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?")) 0 parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n]) d.all) x=d.all[n]; for (i=0;!x i d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x d.layers i d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x d.getElementById) x=d.getElementById(n); return x; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i (a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } /script /head body onLoad="MM_preloadImages('img/account2.jpg','img/key2.jpg','img/member2.jpg','img/kate2.jpg')" div id="body_2" div id="head" div id="head1" /div div id="head2" /div /div div id="main" div id="menu" div class="img1" img src="img/menu1.jpg" width="180" height="24" class="img1" /div ?php if($_SESSION['MM_Username'] == ""){ ? div class="img1" a href="[[account_cre2.php]]" class="img1" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image6','','img/account2.jpg',1)" img src="img/account.jpg" alt="アカウントを作成する" name="Image6" width="180" height="40" hspace="0" vspace="0" border="0" class="img1" /a /div div class="img1" img src="img/menu1.jpg" width="180" height="24" hspace="0" vspace="0" border="0" class="img1" /div div id="login" form name="form1" method="POST" action=" ?php echo $loginFormAction; ? " ユーザーID： input name="id" type="text" br パスワード： input name="pass" type="password" id="pass" br p input type="submit" name="Submit" value="ログイン" /p /form /div ?php }else{ ? div class="img1" ?php echo ("ようこそ " .$_SESSION['MM_Username']. " さん"); ? br br a href="admin2.php?doLogout=true" ログアウト /a /div ?php } ? div class="img1" img src="img/menu1.jpg" width="180" height="24" hspace="0" vspace="0" border="0" class="img1" /div div class="img1" a href="[[member_s.php]]" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image10','','img/member2.jpg',1)" img src="img/member.jpg" alt="メンバー検索" name="Image10" width="180" height="40" border="0" /a /div div class="img1" a href="[[category_s.php]]" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image11','','img/kate2.jpg',1)" img src="img/kate.jpg" alt="カテゴリー検索" name="Image11" width="180" height="40" border="0" /a /div div class="img1" a href="[[key_s.php]]" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image9','','img/key2.jpg',1)" img src="img/key.jpg" alt="キーワード検索" name="Image9" width="180" height="40" border="0" /a /div /div div id="text" img src="img/blank.jpg" table width="450" border="0" align="center" cellpadding="3" tr td p 最近の記事 ?php echo ($startRow_rsAmazonz2 + 1) ? ～ ?php echo min($startRow_rsAmazonz2 + $maxRows_rsAmazonz2, $totalRows_rsAmazonz2) ? 件 / 全 ?php echo $totalRows_rsAmazonz2 ? /p HR /td /tr ?php do { ? tr td a name=" ?php echo $row_rsAmazonz2['id']; ? " span class="style3" ?php echo $row_rsAmazonz2['uptime']; ? /span /name /td /tr tr td span class="style3" ?php echo $row_rsAmazonz2['title']; ? /span /td /tr tr td span class="style3" ?php if($row_rsAmazonz2['category'] == 'MUSIC'){ ? img src="img/music.gif" ?php }else if($row_rsAmazonz2['category'] == 'DVD'){ ? img src="img/dvd.gif" ?php }else if($row_rsAmazonz2['category'] == 'BOOK'){ ? img src="img/book.gif" ?php } ? /span /td /tr tr td span class="style3" ?php echo nl2br($row_rsAmazonz2['topic']); ? /span /td /tr tr td span class="style3" ?php echo $row_rsAmazonz2['uset_id']; ? /span /td /tr tr td hr /td /tr ?php } while ($row_rsAmazonz2 = mysql_fetch_assoc($rsAmazonz2)); ? /table table border="0" width="50%" align="center" tr td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 0) { // Show if not first page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, 0, $queryString_rsAmazonz2); ? " 先頭 /a ?php } // Show if not first page ? /td td width="31%" align="center" ?php if ($pageNum_rsAmazonz2 0) { // Show if not first page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, max(0, $pageNum_rsAmazonz2 - 1), $queryString_rsAmazonz2); ? " 戻る /a ?php } // Show if not first page ? /td td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 $totalPages_rsAmazonz2) { // Show if not last page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, min($totalPages_rsAmazonz2, $pageNum_rsAmazonz2 + 1), $queryString_rsAmazonz2); ? " 次へ /a ?php } // Show if not last page ? /td td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 $totalPages_rsAmazonz2) { // Show if not last page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, $totalPages_rsAmazonz2, $queryString_rsAmazonz2); ? " 最終 /a ?php } // Show if not last page ? /td /tr /table ?php mysql_free_result($rsAmazonz2); ? p nbsp; /p /div div id="under" div id="under1" /div div id="under2" /div /div /div /div /body /html
https://w.atwiki.jp/amazonz/pages/41.html
?php require_once('Connections/connAmazon2.php'); ? ?php $currentPage = $_SERVER["PHP_SELF"]; $maxRows_rsAmazonz2 = 10; $pageNum_rsAmazonz2 = 0; if (isset($_GET['pageNum_rsAmazonz2'])) { $pageNum_rsAmazonz2 = $_GET['pageNum_rsAmazonz2']; } $startRow_rsAmazonz2 = $pageNum_rsAmazonz2 * $maxRows_rsAmazonz2; $colname_rsAmazonz2 = "%"; if (isset($_GET['key'])) { //magic_quotes_gpcの設定に応じて取得した値を変換する $colname_rsAmazonz2 = (get_magic_quotes_gpc()) ? $_GET['key'] addslashes($_GET['key']); } $maxRows_rsAmazonz2 = 5; $pageNum_rsAmazonz2 = 0; if (isset($_GET['pageNum_rsAmazonz2'])) { $pageNum_rsAmazonz2 = $_GET['pageNum_rsAmazonz2']; } $startRow_rsAmazonz2 = $pageNum_rsAmazonz2 * $maxRows_rsAmazonz2; mysql_select_db($database_connAmazon2, $connAmazon2); $query_rsAmazonz2 = sprintf("SELECT * FROM amazonz_data WHERE uset_id LIKE '%s' ORDER BY uptime DESC", $colname_rsAmazonz2); $query_limit_rsAmazonz2 = sprintf("%s LIMIT %d, %d", $query_rsAmazonz2, $startRow_rsAmazonz2, $maxRows_rsAmazonz2); $rsAmazonz2 = mysql_query($query_limit_rsAmazonz2, $connAmazon2) or die(mysql_error()); $row_rsAmazonz2 = mysql_fetch_assoc($rsAmazonz2); if (isset($_GET['totalRows_rsAmazonz2'])) { $totalRows_rsAmazonz2 = $_GET['totalRows_rsAmazonz2']; } else { $all_rsAmazonz2 = mysql_query($query_rsAmazonz2); $totalRows_rsAmazonz2 = mysql_num_rows($all_rsAmazonz2); } $totalPages_rsAmazonz2 = ceil($totalRows_rsAmazonz2/$maxRows_rsAmazonz2)-1; mysql_select_db($database_connAmazon2, $connAmazon2); $query_rsMember = "SELECT * FROM amazonz_user ORDER BY id ASC"; $rsMember = mysql_query($query_rsMember, $connAmazon2) or die(mysql_error()); $row_rsMember = mysql_fetch_assoc($rsMember); $totalRows_rsMember = mysql_num_rows($rsMember); $queryString_rsAmazonz2 = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode(" ", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_rsAmazonz2") == false stristr($param, "totalRows_rsAmazonz2") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_rsAmazonz2 = " " . htmlentities(implode(" ", $newParams)); } } $queryString_rsAmazonz2 = sprintf(" totalRows_rsAmazonz2=%d%s", $totalRows_rsAmazonz2, $queryString_rsAmazonz2); ? ?php session_start(); $loginFormAction = $_SERVER['PHP_SELF']; if (isset($accesscheck)) { $GLOBALS['PrevUrl'] = $accesscheck; session_register('PrevUrl'); } if (isset($_POST['id'])) { $loginUsername=$_POST['id']; $password=$_POST['pass']; $MM_fldUserAuthorization = ""; $MM_redirectLoginSuccess = "[[admin2.php]]"; $MM_redirectLoginFailed = "[[account_cre2.php]]"; $MM_redirecttoReferrer = false; mysql_select_db($database_connAmazon2, $connAmazon2); $LoginRS__query=sprintf("SELECT id, pass FROM amazonz_user WHERE id='%s' AND pass='%s'", get_magic_quotes_gpc() ? $loginUsername addslashes($loginUsername), get_magic_quotes_gpc() ? $password addslashes($password)); $LoginRS = mysql_query($LoginRS__query, $connAmazon2) or die(mysql_error()); $loginFoundUser = mysql_num_rows($LoginRS); if ($loginFoundUser) { $loginStrGroup = ""; //declare two session variables and assign them $GLOBALS['MM_Username'] = $loginUsername; $GLOBALS['MM_UserGroup'] = $loginStrGroup; //register the session variables session_register("MM_Username"); session_register("MM_UserGroup"); if (isset($_SESSION['PrevUrl']) false) { $MM_redirectLoginSuccess = $_SESSION['PrevUrl']; } header("Location " . $MM_redirectLoginSuccess ); } else { header("Location ". $MM_redirectLoginFailed ); } } ? html head meta http-equiv="Content-Type" content="text/html; charset=euc-jp" title Amazonz -メンバ検索- /title link href="css.css" rel="stylesheet" type="text/css" script language="JavaScript" type="text/JavaScript" !-- function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a i a.length (x=a[i]) x.oSrc;i++) x.src=x.oSrc; } function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?")) 0 parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n]) d.all) x=d.all[n]; for (i=0;!x i d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x d.layers i d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x d.getElementById) x=d.getElementById(n); return x; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i (a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } /script /head body onLoad="MM_preloadImages('img/account2.jpg','img/key2.jpg','img/member2.jpg','img/kate2.jpg')" div id="body_2" div id="head" div id="head1" /div div id="head2" /div /div div id="main" div id="menu" div class="img1" img src="img/menu1.jpg" width="180" height="24" class="img1" /div ?php if($_SESSION['MM_Username'] == ""){ ? div class="img1" a href="account_cre2.php" class="img1" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image6','','img/account2.jpg',1)" img src="img/account.jpg" alt="アカウントを作成する" name="Image6" width="180" height="40" hspace="0" vspace="0" border="0" class="img1" /a /div div class="img1" img src="img/menu1.jpg" width="180" height="24" hspace="0" vspace="0" border="0" class="img1" /div div id="login" form name="form1" method="POST" action=" ?php echo $loginFormAction; ? " ユーザーID： input name="id" type="text" br パスワード： input name="pass" type="password" id="pass" br p input type="submit" name="Submit" value="ログイン" /p /form /div ?php }else{ ? div class="img1" ?php echo ("ようこそ " .$_SESSION['MM_Username']. " さん"); ? br br a href="admin2.php?doLogout=true" ログアウト /a br a href="admin2.php" 管理画面 /a br a href="[[top.php]]" home /a /div ?php } ? div class="img1" img src="img/menu1.jpg" width="180" height="24" hspace="0" vspace="0" border="0" class="img1" /div div class="img1" a href="member_s.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image10','','img/member2.jpg',1)" img src="img/member.jpg" alt="メンバー検索" name="Image10" width="180" height="40" border="0" /a /div div class="img1" a href="[[category_s.php]]" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image11','','img/kate2.jpg',1)" img src="img/kate.jpg" alt="カテゴリー検索" name="Image11" width="180" height="40" border="0" /a /div div class="img1" a href="[[key_s.php]]" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image9','','img/key2.jpg',1)" img src="img/key.jpg" alt="キーワード検索" name="Image9" width="180" height="40" border="0" /a /div /div div id="text" img src="img/blank.jpg" form name="form1" method="get" action="" div align="center" p メンバ検索 /p ?php do { ? table width="250" border="0" cellpadding="3" tr td input name="key" type="radio" id="key" value=" ?php echo $row_rsMember['id']; ? " ?php echo $row_rsMember['id']; ? /td /tr /table ?php } while ($row_rsMember = mysql_fetch_assoc($rsMember)); ? input type="submit" name="Submit" value="検索" /div /form p align="center" !-- セレクトKEYが空でない場合以後表示 -- ?php if($_GET['key'] !=""){ $key=$_GET['key']; $kensu=$totalRows_rsAmazonz2; print(" $key で検索した結果"); print(" $kensu 件ヒットしました"); } ? レコード ?php echo ($startRow_rsAmazonz2 + 1) ? ～ ?php echo min($startRow_rsAmazonz2 + $maxRows_rsAmazonz2, $totalRows_rsAmazonz2) ? 件 / 全 ?php echo $totalRows_rsAmazonz2 ? /p table width="400" border="0" align="center" cellpadding="3" ?php do { ? tr td span class="style3" ?php echo $row_rsAmazonz2['uptime']; ? /span /td /tr tr td span class="style3" ?php echo $row_rsAmazonz2['title']; ? /span /td /tr tr td span class="style3" ?php echo $row_rsAmazonz2['category']; ? /span /td /tr tr td span class="style3" ?php echo nl2br($row_rsAmazonz2['topic']); ? /span /td /tr tr td span class="style3" ?php echo $row_rsAmazonz2['uset_id']; ? /span /td /tr tr td hr /td /tr ?php } while ($row_rsAmazonz2 = mysql_fetch_assoc($rsAmazonz2)); ? /table table border="0" width="50%" align="center" tr td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 0) { // Show if not first page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, 0, $queryString_rsAmazonz2); ? " 先頭 /a ?php } // Show if not first page ? /td td width="31%" align="center" ?php if ($pageNum_rsAmazonz2 0) { // Show if not first page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, max(0, $pageNum_rsAmazonz2 - 1), $queryString_rsAmazonz2); ? " 戻る /a ?php } // Show if not first page ? /td td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 $totalPages_rsAmazonz2) { // Show if not last page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, min($totalPages_rsAmazonz2, $pageNum_rsAmazonz2 + 1), $queryString_rsAmazonz2); ? " 次へ /a ?php } // Show if not last page ? /td td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 $totalPages_rsAmazonz2) { // Show if not last page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, $totalPages_rsAmazonz2, $queryString_rsAmazonz2); ? " 最終 /a ?php } // Show if not last page ? /td /tr /table ?php mysql_free_result($rsAmazonz2); mysql_free_result($rsMember); ? p nbsp; /p /div div id="under" div id="under1" /div div id="under2" /div /div /div /div /body /html
https://w.atwiki.jp/amazonz/pages/42.html
?php require_once('Connections/connAmazon2.php'); ? ?php $currentPage = $_SERVER["PHP_SELF"]; $maxRows_rsAmazonz2 = 5; $pageNum_rsAmazonz2 = 0; if (isset($_GET['pageNum_rsAmazonz2'])) { $pageNum_rsAmazonz2 = $_GET['pageNum_rsAmazonz2']; } $startRow_rsAmazonz2 = $pageNum_rsAmazonz2 * $maxRows_rsAmazonz2; $colname_rsAmazonz2 = "%"; if (isset($_GET['key'])) { $colname_rsAmazonz2 = (get_magic_quotes_gpc()) ? $_GET['key'] addslashes($_GET['key']); } mysql_select_db($database_connAmazon2, $connAmazon2); $query_rsAmazonz2 = sprintf("SELECT * FROM amazonz_data WHERE category LIKE '%s' ORDER BY uptime DESC", $colname_rsAmazonz2); $query_limit_rsAmazonz2 = sprintf("%s LIMIT %d, %d", $query_rsAmazonz2, $startRow_rsAmazonz2, $maxRows_rsAmazonz2); $rsAmazonz2 = mysql_query($query_limit_rsAmazonz2, $connAmazon2) or die(mysql_error()); $row_rsAmazonz2 = mysql_fetch_assoc($rsAmazonz2); if (isset($_GET['totalRows_rsAmazonz2'])) { $totalRows_rsAmazonz2 = $_GET['totalRows_rsAmazonz2']; } else { $all_rsAmazonz2 = mysql_query($query_rsAmazonz2); $totalRows_rsAmazonz2 = mysql_num_rows($all_rsAmazonz2); } $totalPages_rsAmazonz2 = ceil($totalRows_rsAmazonz2/$maxRows_rsAmazonz2)-1; $queryString_rsAmazonz2 = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode(" ", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_rsAmazonz2") == false stristr($param, "totalRows_rsAmazonz2") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_rsAmazonz2 = " " . htmlentities(implode(" ", $newParams)); } } $queryString_rsAmazonz2 = sprintf(" totalRows_rsAmazonz2=%d%s", $totalRows_rsAmazonz2, $queryString_rsAmazonz2); ? ?php session_start(); $loginFormAction = $_SERVER['PHP_SELF']; if (isset($accesscheck)) { $GLOBALS['PrevUrl'] = $accesscheck; session_register('PrevUrl'); } if (isset($_POST['id'])) { $loginUsername=$_POST['id']; $password=$_POST['pass']; $MM_fldUserAuthorization = ""; $MM_redirectLoginSuccess = "[[admin2.php]]"; $MM_redirectLoginFailed = "[[account_cre2.php]]"; $MM_redirecttoReferrer = false; mysql_select_db($database_connAmazon2, $connAmazon2); $LoginRS__query=sprintf("SELECT id, pass FROM amazonz_user WHERE id='%s' AND pass='%s'", get_magic_quotes_gpc() ? $loginUsername addslashes($loginUsername), get_magic_quotes_gpc() ? $password addslashes($password)); $LoginRS = mysql_query($LoginRS__query, $connAmazon2) or die(mysql_error()); $loginFoundUser = mysql_num_rows($LoginRS); if ($loginFoundUser) { $loginStrGroup = ""; //declare two session variables and assign them $GLOBALS['MM_Username'] = $loginUsername; $GLOBALS['MM_UserGroup'] = $loginStrGroup; //register the session variables session_register("MM_Username"); session_register("MM_UserGroup"); if (isset($_SESSION['PrevUrl']) false) { $MM_redirectLoginSuccess = $_SESSION['PrevUrl']; } header("Location " . $MM_redirectLoginSuccess ); } else { header("Location ". $MM_redirectLoginFailed ); } } ? html head meta http-equiv="Content-Type" content="text/html; charset=euc-jp" title Amazonz -カテゴリ検索- /title link href="css.css" rel="stylesheet" type="text/css" script language="JavaScript" type="text/JavaScript" !-- function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a i a.length (x=a[i]) x.oSrc;i++) x.src=x.oSrc; } function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?")) 0 parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n]) d.all) x=d.all[n]; for (i=0;!x i d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x d.layers i d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x d.getElementById) x=d.getElementById(n); return x; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i (a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } /script /head body onLoad="MM_preloadImages('img/account2.jpg','img/key2.jpg','img/member2.jpg','img/kate2.jpg')" div id="body_2" div id="head" div id="head1" /div div id="head2" /div /div div id="main" div id="menu" div class="img1" img src="img/menu1.jpg" width="180" height="24" class="img1" /div ?php if($_SESSION['MM_Username'] == ""){ ? div class="img1" a href="account_cre2.php" class="img1" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image6','','img/account2.jpg',1)" img src="img/account.jpg" alt="アカウントを作成する" name="Image6" width="180" height="40" hspace="0" vspace="0" border="0" class="img1" /a /div div class="img1" img src="img/menu1.jpg" width="180" height="24" hspace="0" vspace="0" border="0" class="img1" /div div id="login" form name="form1" method="POST" action=" ?php echo $loginFormAction; ? " ユーザーID： input name="id" type="text" size="20" maxlength="22" br パスワード： input name="pass" type="password" id="pass3" size="20" maxlength="20" br p input type="submit" name="Submit" value="ログイン" /p /form /div ?php }else{ ? div id="logout" ?php echo ("ようこそ " .$_SESSION['MM_Username']. " さん"); ? br br a href="admin2.php?doLogout=true" ログアウト /a br a href="admin2.php" 管理画面 /a br a href="[[top.php]]" home /a /div ?php } ? div class="img1" img src="img/menu1.jpg" width="180" height="24" hspace="0" vspace="0" border="0" class="img1" /div div class="img1" a href="[[member_s.php]]" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image10','','img/member2.jpg',1)" img src="img/member.jpg" alt="メンバー検索" name="Image10" width="180" height="40" border="0" /a /div div class="img1" a href="category_s.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image11','','img/kate2.jpg',1)" img src="img/kate.jpg" alt="カテゴリー検索" name="Image11" width="180" height="40" border="0" /a /div div class="img1" a href="[[key_s.php]]" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image9','','img/key2.jpg',1)" img src="img/key.jpg" alt="キーワード検索" name="Image9" width="180" height="40" border="0" /a /div /div ?php if($kensu = 2){ ? div id="text" ?php }else if($kensu = 1){ ? div id="text2" ?php } ? img src="img/blank.jpg" form name="form1" method="get" action="" br div align="center" カテゴリ検索 select name="key" id="key" option value="" selected /option option value="DVD" DVD /option option value="MUSIC" MUSIC /option option value="BOOK" BOOK /option /select input type="submit" name="Submit" value="検索" /div /form p align="center" !-- セレクトKEYがからでない場合以後表示 -- ?php if($_GET['key'] !=""){ $key=$_GET['key']; $kensu=$totalRows_rsAmazonz2; print(" $key で検索した結果"); print(" $kensu 件ヒットしました"); ? 投稿 ?php echo ($startRow_rsAmazonz2 + 1) ? ～ ?php echo min($startRow_rsAmazonz2 + $maxRows_rsAmazonz2, $totalRows_rsAmazonz2) ? 件 / 全 ?php echo $totalRows_rsAmazonz2 ? ?php }? /p table width="400" border="0" align="center" cellpadding="3" class="style3" ?php do { ? tr td ?php echo $row_rsAmazonz2['uptime']; ? /td /tr tr td ?php echo $row_rsAmazonz2['title']; ? /td /tr tr td ?php echo $row_rsAmazonz2['category']; ? /td /tr tr td ?php echo nl2br($row_rsAmazonz2['topic']); ? /td /tr tr td ?php echo $row_rsAmazonz2['uset_id']; ? /td /tr tr td hr /td /tr ?php } while ($row_rsAmazonz2 = mysql_fetch_assoc($rsAmazonz2)); ? /table table border="0" width="50%" align="center" tr td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 0) { // Show if not first page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, 0, $queryString_rsAmazonz2); ? " 先頭 /a ?php } // Show if not first page ? /td td width="31%" align="center" ?php if ($pageNum_rsAmazonz2 0) { // Show if not first page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, max(0, $pageNum_rsAmazonz2 - 1), $queryString_rsAmazonz2); ? " 戻る /a ?php } // Show if not first page ? /td td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 $totalPages_rsAmazonz2) { // Show if not last page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, min($totalPages_rsAmazonz2, $pageNum_rsAmazonz2 + 1), $queryString_rsAmazonz2); ? " 次へ /a ?php } // Show if not last page ? /td td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 $totalPages_rsAmazonz2) { // Show if not last page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, $totalPages_rsAmazonz2, $queryString_rsAmazonz2); ? " 最終 /a ?php } // Show if not last page ? /td /tr /table ?php mysql_free_result($rsAmazonz2); ? p nbsp; /p /div div id="under" div id="under1" /div div id="under2" /div /div /div /div /body /html
https://w.atwiki.jp/amazonz/pages/40.html
?php require_once('Connections/connAmazon2.php'); ? ?php $currentPage = $_SERVER["PHP_SELF"]; $maxRows_rsAmazonz2 = 5; $pageNum_rsAmazonz2 = 0; if (isset($_GET['pageNum_rsAmazonz2'])) { $pageNum_rsAmazonz2 = $_GET['pageNum_rsAmazonz2']; } $startRow_rsAmazonz2 = $pageNum_rsAmazonz2 * $maxRows_rsAmazonz2; $colname_rsAmazonz2 = "%"; if (isset($_GET['key'])) { $colname_rsAmazonz2 = (get_magic_quotes_gpc()) ? $_GET['key'] addslashes($_GET['key']); } mysql_select_db($database_connAmazon2, $connAmazon2); $query_rsAmazonz2 = sprintf("SELECT * FROM amazonz_data WHERE topic LIKE '%s' ORDER BY uptime DESC", $colname_rsAmazonz2); $query_limit_rsAmazonz2 = sprintf("%s LIMIT %d, %d", $query_rsAmazonz2, $startRow_rsAmazonz2, $maxRows_rsAmazonz2); $rsAmazonz2 = mysql_query($query_limit_rsAmazonz2, $connAmazon2) or die(mysql_error()); $row_rsAmazonz2 = mysql_fetch_assoc($rsAmazonz2); if (isset($_GET['totalRows_rsAmazonz2'])) { $totalRows_rsAmazonz2 = $_GET['totalRows_rsAmazonz2']; } else { $all_rsAmazonz2 = mysql_query($query_rsAmazonz2); $totalRows_rsAmazonz2 = mysql_num_rows($all_rsAmazonz2); } $totalPages_rsAmazonz2 = ceil($totalRows_rsAmazonz2/$maxRows_rsAmazonz2)-1; $queryString_rsAmazonz2 = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode(" ", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_rsAmazonz2") == false stristr($param, "totalRows_rsAmazonz2") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_rsAmazonz2 = " " . htmlentities(implode(" ", $newParams)); } } $queryString_rsAmazonz2 = sprintf(" totalRows_rsAmazonz2=%d%s", $totalRows_rsAmazonz2, $queryString_rsAmazonz2); ? ?php session_start(); $loginFormAction = $_SERVER['PHP_SELF']; if (isset($accesscheck)) { $GLOBALS['PrevUrl'] = $accesscheck; session_register('PrevUrl'); } if (isset($_POST['id'])) { $loginUsername=$_POST['id']; $password=$_POST['pass']; $MM_fldUserAuthorization = ""; $MM_redirectLoginSuccess = "[[admin2.php]]"; $MM_redirectLoginFailed = "[[account_cre2.php]]"; $MM_redirecttoReferrer = false; mysql_select_db($database_connAmazon2, $connAmazon2); $LoginRS__query=sprintf("SELECT id, pass FROM amazonz_user WHERE id='%s' AND pass='%s'", get_magic_quotes_gpc() ? $loginUsername addslashes($loginUsername), get_magic_quotes_gpc() ? $password addslashes($password)); $LoginRS = mysql_query($LoginRS__query, $connAmazon2) or die(mysql_error()); $loginFoundUser = mysql_num_rows($LoginRS); if ($loginFoundUser) { $loginStrGroup = ""; //declare two session variables and assign them $GLOBALS['MM_Username'] = $loginUsername; $GLOBALS['MM_UserGroup'] = $loginStrGroup; //register the session variables session_register("MM_Username"); session_register("MM_UserGroup"); if (isset($_SESSION['PrevUrl']) false) { $MM_redirectLoginSuccess = $_SESSION['PrevUrl']; } header("Location " . $MM_redirectLoginSuccess ); } else { header("Location ". $MM_redirectLoginFailed ); } } ? html head meta http-equiv="Content-Type" content="text/html; charset=euc-jp" title Amazonz -キーワード検索- /title link href="css.css" rel="stylesheet" type="text/css" script language="JavaScript" type="text/JavaScript" !-- function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a i a.length (x=a[i]) x.oSrc;i++) x.src=x.oSrc; } function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?")) 0 parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n]) d.all) x=d.all[n]; for (i=0;!x i d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x d.layers i d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x d.getElementById) x=d.getElementById(n); return x; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i (a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } /script /head body onLoad="MM_preloadImages('img/account2.jpg','img/key2.jpg','img/member2.jpg','img/kate2.jpg')" div id="body_2" div id="head" div id="head1" /div div id="head2" /div /div div id="main" div id="menu" div class="img1" img src="img/menu1.jpg" width="180" height="24" class="img1" /div !-- ログインしていなかったら表示(ログイン画面) -- ?php if($_SESSION['MM_Username'] == ""){ ? div class="img1" a href="account_cre2.php" class="img1" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image6','','img/account2.jpg',1)" img src="img/account.jpg" alt="アカウントを作成する" name="Image6" width="180" height="40" hspace="0" vspace="0" border="0" class="img1" /a /div div class="img1" img src="img/menu1.jpg" width="180" height="24" hspace="0" vspace="0" border="0" class="img1" /div div id="login" form name="form1" method="POST" action=" ?php echo $loginFormAction; ? " ユーザーID： input name="id" type="text" br パスワード： input name="pass" type="password" id="pass" br p input type="submit" name="Submit" value="ログイン" /p /form /div !-- ログインしていたら表示（ようこそ＊＊＊さん） -- ?php }else{ ? div class="img1" ?php echo ("ようこそ " .$_SESSION['MM_Username']. " さん"); ? br br a href="admin2.php?doLogout=true" ログアウト /a br a href="admin2.php" 管理画面 /a br a href="[[top.php]]" home /a /div ?php } ? div class="img1" img src="img/menu1.jpg" width="180" height="24" hspace="0" vspace="0" border="0" class="img1" /div div class="img1" a href="[[member_s.php]]" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image10','','img/member2.jpg',1)" img src="img/member.jpg" alt="メンバー検索" name="Image10" width="180" height="40" border="0" /a /div div class="img1" a href="[[category_s.php]]" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image11','','img/kate2.jpg',1)" img src="img/kate.jpg" alt="カテゴリー検索" name="Image11" width="180" height="40" border="0" /a /div div class="img1" a href="key_s.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image9','','img/key2.jpg',1)" img src="img/key.jpg" alt="キーワード検索" name="Image9" width="180" height="40" border="0" /a /div /div div id="text" img src="img/blank.jpg" form name="form1" method="get" action="" br div align="center" キーワード検索 input name="key" type="text" id="key" input name="Submit" type="submit" value="検索" /div /form p align="center" ?php if($_GET['key'] !=""){ $key=$_GET['key']; $kensu=$totalRows_rsAmazonz2; print(" $key で検索した結果"); print("$kensu 件ヒットしました"); } ? 投稿 ?php echo ($startRow_rsAmazonz2 + 1) ? ～ ?php echo min($startRow_rsAmazonz2 + $maxRows_rsAmazonz2, $totalRows_rsAmazonz2) ? 件 / 全 ?php echo $totalRows_rsAmazonz2 ? /p table width="400" border="0" align="center" cellpadding="3" class="style3" ?php do { ? tr td ?php echo $row_rsAmazonz2['uptime']; ? /td /tr tr td ?php echo $row_rsAmazonz2['title']; ? /td /tr tr td ?php echo $row_rsAmazonz2['category']; ? /td /tr tr td ?php echo $row_rsAmazonz2['topic']; ? /td /tr tr td ?php echo $row_rsAmazonz2['uset_id']; ? /td /tr tr td hr /td /tr ?php } while ($row_rsAmazonz2 = mysql_fetch_assoc($rsAmazonz2)); ? /table table border="0" width="50%" align="center" tr td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 0) { // Show if not first page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, 0, $queryString_rsAmazonz2); ? " 先頭 /a ?php } // Show if not first page ? /td td width="31%" align="center" ?php if ($pageNum_rsAmazonz2 0) { // Show if not first page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, max(0, $pageNum_rsAmazonz2 - 1), $queryString_rsAmazonz2); ? " 戻る /a ?php } // Show if not first page ? /td td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 $totalPages_rsAmazonz2) { // Show if not last page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, min($totalPages_rsAmazonz2, $pageNum_rsAmazonz2 + 1), $queryString_rsAmazonz2); ? " 次へ /a ?php } // Show if not last page ? /td td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 $totalPages_rsAmazonz2) { // Show if not last page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, $totalPages_rsAmazonz2, $queryString_rsAmazonz2); ? " 最終 /a ?php } // Show if not last page ? /td /tr /table ?php mysql_free_result($rsAmazonz2); ? /div div id="under" div id="under1" /div div id="under2" /div /div /div /div /body /html
https://w.atwiki.jp/amazonz/pages/20.html
アップロード・ダウンロード ?php session_start(); $logoutAction = $_SERVER['PHP_SELF']."?doLogout=true"; if (*1) ($_SERVER['QUERY_STRING'] != "")){ $logoutAction .=" ". htmlentities($_SERVER['QUERY_STRING']); } if (*2) ($_GET['doLogout']=="true")){ //to fully log out a visitor we need to clear the session varialbles session_unregister('MM_Username'); session_unregister('MM_UserGroup'); $logoutGoTo = "[[view.php]]"; if ($logoutGoTo) { header("Location $logoutGoTo"); exit; } } ? ?php require_once('Connections/connAmazon2.php'); ? ?php session_start(); $MM_authorizedUsers = ""; $MM_donotCheckaccess = "true"; function isAuthorized($strUsers, $strGroups, $UserName, $UserGroup) { // For security, start by assuming the visitor is NOT authorized. $isValid = False; // When a visitor has logged into this site, the Session variable MM_Username set equal to their username. // Therefore, we know that a user is NOT logged in if that Session variable is blank. if (!empty($UserName)) { // Besides being logged in, you may restrict access to only certain users based on an ID established when they login. // Parse the strings into arrays. $arrUsers = Explode(",", $strUsers); $arrGroups = Explode(",", $strGroups); if (in_array($UserName, $arrUsers)) { $isValid = true; } // Or, you may restrict access to only certain users based on their username. if (in_array($UserGroup, $arrGroups)) { $isValid = true; } if (($strUsers == "") true) { $isValid = true; } } return $isValid; } $MM_restrictGoTo = "login.php"; if (!(*3) (isAuthorized("",$MM_authorizedUsers, $_SESSION['MM_Username'], $_SESSION['MM_UserGroup'])))) { $MM_qsChar = "?"; $MM_referrer = $_SERVER['PHP_SELF']; if (strpos($MM_restrictGoTo, "?")) $MM_qsChar = " "; if (isset($QUERY_STRING) strlen($QUERY_STRING) 0) $MM_referrer .= "?" . $QUERY_STRING; $MM_restrictGoTo = $MM_restrictGoTo. $MM_qsChar . "accesscheck=" . urlencode($MM_referrer); header("Location ". $MM_restrictGoTo); exit; } ? ?php $currentPage = $_SERVER["PHP_SELF"]; function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) $theValue; switch ($theType) { case "text" $theValue = ($theValue != "") ? "'" . $theValue . "'" "NULL"; break; case "long" case "int" $theValue = ($theValue != "") ? intval($theValue) "NULL"; break; case "double" $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" "NULL"; break; case "date" $theValue = ($theValue != "") ? "'" . $theValue . "'" "NULL"; break; case "defined" $theValue = ($theValue != "") ? $theDefinedValue $theNotDefinedValue; break; } return $theValue; } $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if (*4) ($_POST["MM_insert"] == "form2")) { $insertSQL = sprintf("INSERT INTO amazonz_data (id, title, category, topic, uptime, uset_id) VALUES (%s, %s, %s, %s, %s, %s)", GetSQLValueString($_POST['id'], "int"), GetSQLValueString($_POST['title'], "text"), GetSQLValueString($_POST['category'], "text"), GetSQLValueString($_POST['topic'], "text"), GetSQLValueString($_POST['uptime'], "date"), GetSQLValueString($_POST['uset_id'], "text")); mysql_select_db($database_connAmazon2, $connAmazon2); $Result1 = mysql_query($insertSQL, $connAmazon2) or die(mysql_error()); $insertGoTo = "admin.php"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? " " "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location %s", $insertGoTo)); } $maxRows_rsAmazonz2 = 10; $pageNum_rsAmazonz2 = 0; if (isset($_GET['pageNum_rsAmazonz2'])) { $pageNum_rsAmazonz2 = $_GET['pageNum_rsAmazonz2']; } $startRow_rsAmazonz2 = $pageNum_rsAmazonz2 * $maxRows_rsAmazonz2; $colname_rsAmazonz2 = "%"; if (isset($_GET['key'])) { $colname_rsAmazonz2 = (get_magic_quotes_gpc()) ? $_GET['key'] addslashes($_GET['key']); } mysql_select_db($database_connAmazon2, $connAmazon2); $sessionname=$_SESSION['MM_Username']; $query_rsAmazonz2 = sprintf("SELECT * FROM amazonz_data WHERE topic LIKE '%s' uset_id = '$sessionname' ORDER BY uptime DESC" , $colname_rsAmazonz2); $query_limit_rsAmazonz2 = sprintf("%s LIMIT %d, %d", $query_rsAmazonz2, $startRow_rsAmazonz2, $maxRows_rsAmazonz2); $rsAmazonz2 = mysql_query($query_limit_rsAmazonz2, $connAmazon2) or die(mysql_error()); $row_rsAmazonz2 = mysql_fetch_assoc($rsAmazonz2); if (isset($_GET['totalRows_rsAmazonz2'])) { $totalRows_rsAmazonz2 = $_GET['totalRows_rsAmazonz2']; } else { $all_rsAmazonz2 = mysql_query($query_rsAmazonz2); $totalRows_rsAmazonz2 = mysql_num_rows($all_rsAmazonz2); } $totalPages_rsAmazonz2 = ceil($totalRows_rsAmazonz2/$maxRows_rsAmazonz2)-1; $queryString_rsAmazonz2 = ""; if (!empty($_SERVER['QUERY_STRING'])) { $params = explode(" ", $_SERVER['QUERY_STRING']); $newParams = array(); foreach ($params as $param) { if (stristr($param, "pageNum_rsAmazonz2") == false stristr($param, "totalRows_rsAmazonz2") == false) { array_push($newParams, $param); } } if (count($newParams) != 0) { $queryString_rsAmazonz2 = " " . htmlentities(implode(" ", $newParams)); } } $queryString_rsAmazonz2 = sprintf(" totalRows_rsAmazonz2=%d%s", $totalRows_rsAmazonz2, $queryString_rsAmazonz2); ? !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http //www.w3.org/TR/html4/loose.dtd" html head meta http-equiv="Content-Type" content="text/html; charset=euc-jp" title ログ管理 /title style type="text/css" !-- .style6 {font-size 10px} /style /head body form name="form1" method="get" action="" div align="center" ?php echo ($_SESSION['MM_Username']. "さん こんにちわ！"); ? input name="key" type="text" id="key" input name="Submit" type="submit" value="検索" a href="[[add.php]]" 投稿 /a a href=" ?php echo $logoutAction ? " ログアウト /a a href="view.php" 投稿閲覧 /a /div /form br form method="post" name="form2" action=" ?php echo $editFormAction; ? " table width="250" height="100" align="center" tr valign="baseline" td align="left" nowrap class="style6" タイトル： input type="text" name="title" value="" size="32" /td /tr tr valign="baseline" td align="left" nowrap span class="style6" カテゴリ： select name="category" option value="BOOK" ?php if (!(strcmp("BOOK", ""))) {echo "SELECTED";} ? BOOK /option option value="DVD" ?php if (!(strcmp("DVD", ""))) {echo "SELECTED";} ? DVD /option option value="CD" ?php if (!(strcmp("CD", ""))) {echo "SELECTED";} ? CD /option /select /span /td /tr tr valign="baseline" td align="left" valign="top" nowrap p class="style6" トピック： br textarea name="topic" cols="40" rows="5" /textarea /p /td /tr tr valign="baseline" td align="left" nowrap input type="submit" value="投稿" /td /tr /table input type="hidden" name="id" value="" input type="hidden" name="uptime" value=" ?php echo date('Y/m/d H i s'); ? " input type="hidden" name="uset_id" value=" ?php echo($_SESSION['MM_Username']); ? " input type="hidden" name="MM_insert" value="form2" /form p nbsp; /p table width="400" border="0" align="center" cellpadding="3" ?php do { ? tr td span class="style6" ?php echo $row_rsAmazonz2['uptime']; ? /span /td /tr tr td span class="style6" ?php echo $row_rsAmazonz2['title']; ? /span /td /tr tr td span class="style6" ?php echo $row_rsAmazonz2['category']; ? /span /td /tr tr td span class="style6" ?php echo $row_rsAmazonz2['topic']; ? /span /td /tr tr td span class="style6" ?php echo $row_rsAmazonz2['uset_id']; ? /span /td /tr tr td span class="style6" a href="[[update.php]]?id= ?php echo $row_rsAmazonz2['id']; ? " 修正 /a a href="[[del.php]]?id= ?php echo $row_rsAmazonz2['id']; ? " 削除 /a /span hr /td /tr ?php } while ($row_rsAmazonz2 = mysql_fetch_assoc($rsAmazonz2)); ? /table table border="0" width="50%" align="center" tr td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 0) { // Show if not first page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, 0, $queryString_rsAmazonz2); ? " 先頭 /a ?php } // Show if not first page ? /td td width="31%" align="center" ?php if ($pageNum_rsAmazonz2 0) { // Show if not first page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, max(0, $pageNum_rsAmazonz2 - 1), $queryString_rsAmazonz2); ? " 戻る /a ?php } // Show if not first page ? /td td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 $totalPages_rsAmazonz2) { // Show if not last page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, min($totalPages_rsAmazonz2, $pageNum_rsAmazonz2 + 1), $queryString_rsAmazonz2); ? " 次へ /a ?php } // Show if not last page ? /td td width="23%" align="center" ?php if ($pageNum_rsAmazonz2 $totalPages_rsAmazonz2) { // Show if not last page ? a href=" ?php printf("%s?pageNum_rsAmazonz2=%d%s", $currentPage, $totalPages_rsAmazonz2, $queryString_rsAmazonz2); ? " 最終 /a ?php } // Show if not last page ? /td /tr /table /body /html ?php mysql_free_result($rsAmazonz2); ?