約 5,222,114 件
https://w.atwiki.jp/scratchpad/pages/16.html
PDO_OCI PHPExcel PDO_OCI tns指定時には、余分な空白があるとダメみたい。一行で記述するのが手っ取り早い? $tns = "(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = yourip)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = orcl)))" $db_username = "youname"; $db_password = "yourpassword"; try{ $conn = new PDO("oci dbname=".$tns,$db_username,$db_password); }catch(PDOException $e){ echo ($e- getMessage()); } PHPExcel 特徴 PHPで、Excelファイルの作成・編集・保存等ができる。 COMを使わないため、サーバがWindows以外(FreeBSD,Linux他)でもよい。 導入 PHP Excel 2007 classesよりダウンロード。(version 1.6.0;2007/2/14現在) 解凍してパスの通ったところに配置する。 使用 読み書きExcelファイル形式に合わせたライブラリを読み込む。 Excelファイルの形式 処理 備考 xlsx 読込み Reader/Excel2007.phpをrequire 書込み Writer/Excel2007.phpをrequire xls 読込み 不可 書込み Writer/Excel5.phpをriquire 日本語フォント xlsx形式 特に問題なし。 xls形式 フォント名が半角英数字のもののみ使用可 (どれが使えるかは、Fontsディレクトリで確認)標準でつかえそうなのは、以下の4つ。 MS Gothic MS PGothic MS Mincho MS PMincho 動作感 Excel2000等をメインで使っている環境の場合、雛形ファイルをExcel2007で作成→PHPExcelで操作→xls形式で保存という流れに。 条件付き書式等は、保存時に失われる模様。(xls,xlsxとも) 日本語フォントもデフォルトに戻る?(該当セルに合わせてみるとフォント名が崩れている) 日本語はUTF−8で使用可。
https://w.atwiki.jp/fujimo-dia/pages/127.html
リンク集 http //hp-html.jp/ http //www.sumnet.ne.jp/domp/hplink/ http //affiliate.aki-f.com/prog/link/ タグ http //heo.jp/tag/ 画像系 バナー http //www.bannerkoubou.com/ http //youbig.zero-city.com/otoku/banahp.htm テキスト http //ja.cooltext.com/ フラッシュ http //www.anvsoft.jp/photo-flash-maker-free.html 画像 http //jirox.net/AsButtonGen/ http //www.my-standard.co.jp/1240.html http //www.forest.impress.co.jp/lib/inet/homepage/logobutton/aquamaker.html http //labs.wanokoto.jp/olds http //decojiro.net/ http //bighugelabs.com/ http //tegaki-maker.com/ 素材 http //sozai-hp.com/ http //www.sozainomori.com/ http //www.image-life.com/ http //iconworld.aine.biz/ http //hp-sozai.net/ http //tegaki-maker.com/ フォント http //akibatec.net/freefont/ SEO http //googlewebmastercentral-ja.blogspot.com/2009/06/google.html http //oshiete.goo.ne.jp/plus/qa/9253/ http //www.google.com/support/webmasters/bin/answer.py?hl=jp answer=35256 http //kumacrow.blog111.fc2.com/blog-entry-631.html 検索エンジン登録 http //www.google.co.jp/addurl/ http //www.bing.com/webmaster/SubmitSitePage.aspx http //submit.search.yahoo.co.jp/add/request ウェブマスターツール http //www.alphaseo.jp/seo-column/080121_103304.html http //google-mania.net/for-webmaster/webmaster-tool http //googlewebmastercentral-ja.blogspot.com/search/label/%E3%82%A6%E3%82%A7%E3%83%96%E3%83%9E%E3%82%B9%E3%82%BF%E3%83%BC%E3%82%AC%E3%82%A4%E3%83%89%E3%83%A9%E3%82%A4%E3%83%B3 Jimdo http //jp.jimdo.com/ http //kumacrow.blog111.fc2.com/blog-category-48.html http //how-to.jimdo.com/ googleサイト http //google-mania.net/archives/1108 http //www.webword.jp/google-sites/index.html http //g.1o4.jp/ http //blog.browncat.org/2008/02/google_appsgoogle_sites.html http //g-tips.net/apps/ http //www.appsupport.jp/category/sites/ マイクロソフト http //www.microsoft.com/japan/office/officelive/sb/p_top.mspx http //allabout.co.jp/career/corporateit/closeup/CU20070107A/ 図表 http //netplus.nikkei.co.jp/netnavi/life/lif100120.html アドセンス http //gigazine.net/index.php?/news/comments/20060912_costs_per_click/ キーワード https //adwords.google.co.jp/select/KeywordToolExternal http //automedia.sakura.ne.jp/seo_keyword/ トップハテナー(関連も) http //tophatenar.com/ http //ascii.jp/elem/000/000/473/473837/ http //eatspot.jp/ http //native-checker.com/ http //www.keyman.or.jp/3w/prd/53/30002953/ http //apiblog.kakaku.com/2007/01/com_webmozilla_japan.html Alexa http //www.alexa.com/topsites/countries/JP ファビコン http //www.ideaxidea.com/archives/2008/02/faviconico.html http //www.degraeve.com/favicon/ テフなど http //maru.bonyari.jp/texclip/texclip.php http //oku.edu.mie-u.ac.jp/~okumura/texwiki/ http //www.hyuki.com/d/200912.html#i20091219090000 http //arataka.wordpress.com/2008/12/20/equations-in-web/ http //d.hatena.ne.jp/actuary_math/20080921 ドメインやレンタル鯖 http //muumuu-domain.com/ http //www.archive.org/web/web.php http //lolipop.jp/ http //www.xserver.ne.jp/ http //www.sakura.ad.jp/ http //g-tips.net/apps/ PHP http //aineko.com/function/ http //e0166.blog89.fc2.com/blog-entry-151.html http //www.shoshinsha.com/hp/tools/auto.htm http //affiliate.aki-f.com/prog/ javaスクリプト http //javascript.eweb-design.com/index.html http //www.archive.org/web/web.php http //html-time.com/ appsスクリプト http //codezine.jp/article/detail/5036?p=2 http //webiitoko.blog42.fc2.com/blog-entry-222.html HP売買 http //sitecatcher.net/ http //www.sitema.jp/ http //www.sitestock.jp/ http //www.site-trade.jp/ コンテンツ http //e0166.blog89.fc2.com/ Wordpress http //kachibito.net/wordpress/17-free-beautiful-design-themes.html
https://w.atwiki.jp/mainichi-matome/pages/1820.html
JDorama.com http //www.jdorama.com/ ドメイン管理者の国はシンガポール Q:誰がウェブサイトを所有しているか? A:シンガポールの日本のドラマ愛好家。 Kegareta Shita [汚れた舌] 部分転載:http //www.jdorama.com/drama.936.htm "Naoko s Filthy Tongue has fans licking lips" Yu Yamada gets leg over actor Shun Oguri to get leg up in career http //www.jdorama.com/viewtopic.php?p=766917#766917 The Nakamura-Takeuchi split she gets the kid, alimony and a new career, he gets hosed 部分転載:http //www.jdorama.com/viewtopic.php?p=748428#748428 Sexy thespian Tomoko Yamaguchi uses booby trap to snare audience for TV show http //www.jdorama.com/viewtopic.php?p=727787#727787 Offbeat panty bar offers uninhibited lust with the improper stranger http //www.jdorama.com/viewtopic.php?p=695445#695445 How low can they go? Pseudo pedo-porn peddlers loll in lascivious limbo http //www.jdorama.com/viewtopic.php?p=682741#682741 Sulky Erika Sawajiri not quite big enough to pull off prima donna pouting http //www.jdorama.com/viewtopic.php?p=681841#681841 Catfights common as females fiercely flay one other in the workplace http //www.jdorama.com/viewtopic.php?p=674719#674719 Latest Akihabara geek fetish? One-eyed virginal maid mummies http //www.jdorama.com/viewtopic.php?p=668311#668311 Kumi Koda Masahiro Nakai getting intimate while SMAP and Avex just flirt http //www.jdorama.com/viewtopic.php?p=668297#668297 Queen of the cover girls asked to turn over a new leaf http //www.jdorama.com/viewtopic.php?p=665191#665191 Stressed teachers indulging their wild sides with coworkers, parents -- and students http //www.jdorama.com/viewtopic.php?p=656423#656423 Egos, abortion or mutts -- what caused the Ayu-Nagase split? http //www.jdorama.com/viewtopic.php?p=654386#654386 Train Cafe takes hands-on approach in fight against molesting http //www.jdorama.com/viewtopic.php?p=653907#653907 Money burning a hole in your pocket? Learn how to flash the cash, Hamasaki-style http //www.jdorama.com/viewtopic.php?p=624491#624491 Koyuki set to return after agency agonies kick her out of the spotlight http //www.jdorama.com/viewtopic.php?p=616856#616856 Seafood fanatics forget fugu you ve a new poison to pick http //www.jdorama.com/viewtopic.php?p=545719#545719 Tell-all actress blasts Japanese showbiz world http //www.jdorama.com/viewtopic.php?p=539736#539736 Train Cafe takes hands-on approach in fight against molesting http //www.jdorama.com/viewtopic.php?p=514919#514919 Supermodel suffers slings and arrows of outrageous fortune http //www.jdorama.com/viewtopic.php?p=514591#514591 Pesky perverts pry on otaku s dolled-up maids http //www.jdorama.com/viewtopic.php?p=515120#515120 English teaching DVDs get low down and dirty http //www.jdorama.com/viewtopic.php?p=509986#509986 Top baseball commentator the latest to strike out in NTVs string of sex scandals http //www.jdorama.com/viewtopic.php?p=490833#490833 Train Cafe takes hands-on approach in fight against molesting http //www.jdorama.com/viewtopic.php?p=487938#487938 Yumiko Shaku s romantic dreams exposed by legendarily leaky lover http //www.jdorama.com/viewtopic.php?p=449401#449401 One, two, poo in your shoe; three, four, wee on the floor http //www.jdorama.com/viewtopic.php?p=449092#449092 Good girl pays the price for being naughty instead of nice http //www.jdorama.com/viewtopic.php?p=440187#440187 Hand jiving pro-wrestler Koriki is the foul face of new cute http //www.jdorama.com/viewtopic.php?p=439126#439126 Sex workers on the ball with World Cup fever http //www.jdorama.com/viewtopic.php?p=420100#420100 Fallen Horiemon s new digs -- 3 tatami mats with bento and butt service 部分転載:http //www.jdorama.com/viewtopic.php?p=363876#363876 Pop-culture vultures spy cracks in famous family unit http //www.jdorama.com/viewtopic.php?p=353222#353222 Memoirs of a cocksure Kyoto rickshaw runner http //www.jdorama.com/viewtopic.php?p=339494#339494 Norika gets Octopussy-whipped over her Bond-age fantasy http //www.jdorama.com/viewtopic.php?p=337494#337494 TV dramas inspire privileged princesses to dress up lives as nightclub hostesses http //www.jdorama.com/viewtopic.php?p=323420#323420 Butchered kisses give man-eating Yuko taste of success http //www.jdorama.com/viewtopic.php?p=314689#314689 Fresh-faced drama queen told to act her age http //www.jdorama.com/viewtopic.php?p=312603#312603 Mobile phones making a monkey out of Japanese http //www.jdorama.com/viewtopic.php?p=310820#310820 From past beauty to buddy pregnancy, changes transform Japanese ladies lexicons 部分転載:http //www.jdorama.com/viewtopic.php?p=306291#306291 Gal geeks jump aboard hip to be square boom http //www.jdorama.com/viewtopic.php?p=271017#271017 Sweaty, smelly, cramped commuters squashed into state of rail rage http //www.jdorama.com/viewtopic.php?p=268288#268288 Bold women bathers spring the trapdoor of love http //www.jdorama.com/viewtopic.php?p=215808#215808 Guitar-wielding boyfriend strums Takako s chord http //www.jdorama.com/viewtopic.php?p=171495#171495 Naoko s Filthy Tongue has fans licking lips 部分転載:http //www.jdorama.com/viewtopic.php?p=163607#163607 Chocolate-flavored potato chips not hard to swallow http //www.jdorama.com/viewtopic.php?p=128715#128715 Kimutaku canned for walking tall at Cannes http //www.jdorama.com/viewtopic.php?p=99350#99350 Newborn won t stop rebirth of Ryoko s TV career http //www.jdorama.com/viewtopic.php?p=84557#84557 Ripe-figured Kyoka appears ready to bare fruit http //www.jdorama.com/viewtopic.php?p=72286#72286 Hirosue Ryoko shoots self in foot with shotgun wedding http //www.jdorama.com/viewtopic.php?p=42339#42339 関連ページ Catfights common as females fiercely flay one other in the workplace English teaching DVDs get low down and dirty Good girl pays the price for being naughty instead of nice How low can they go? Pseudo pedo-porn peddlers loll in lascivious limbo Latest Akihabara geek fetish? One-eyed virginal maid mummies Offbeat 'panty bar' offers uninhibited lust with the improper stranger One, Two, Poo in Your Shoe; Three, Four, Wee on the Floor Pesky perverts pry on otaku's dolled-up maids Sex workers on the ball with World Cup fever Stressed teachers indulging their wild sides with coworkers, parents -- and Top baseball commentator the latest to strike out in NTVs string of sex scandals WaiWaiの記事を転載した英語サイト:J 毎日新聞謝罪記事の問題点
https://w.atwiki.jp/knight_9999/pages/36.html
トップページ PHP 無名関数 PHP 5.3では、無名関数が使える。 無名関数を使えば、変数に関数を代入して実行できる。 http //php.net/manual/ja/functions.anonymous.php $greet = function($name) { print("hello ".$name); }; $greet("World"); $greet("PHP"); しかし、メンバ変数に入れた場合は、そのままえは実行できない。 http //site.oukasei.com/?p=984 class Hoge { public $fn; } $h = new Hoge(); $h- fn = function($name) { print("hello ".$name); } 上記のような定義の後、普通に呼び出そうとすると $h- fn("World"); //エラー Fatal error Call to undefined method Hoge fn() 括弧でくくっても ($h- fn)("World"); //エラー Parse error syntax error, unexpected ( 一度、通常の変数に入れなおして呼び出すか $x = $h- fn; $x("World"); //動作する もしくは、call_user_func();を利用する call_user_func($h- fn,"World"); //動作する 2013/7/8
https://w.atwiki.jp/emeditor/pages/96.html
function CodeBeautifier() { CodeBeautifier = function(options) { this.program = "phpCB.exe"; this.options = options || [ ]; this.temporaryExtension = ".pbftmp"; this.temporaryFileName = ScriptFullName + this.temporaryExtension; } var self = CodeBeautifier.prototype; self.beautifyFile = function(fileName) { if (!fileName) fileName = document.FullName; var command = [ "cmd /c", this.program, this.options.join(" "), " + fileName + " , " + this.temporaryFileName + " ].join(" "); var shell = new ActiveXObject("WScript.Shell"); shell.Run(command, 7, true); return this.temporaryFileName; } self.beautifyDocument = function(doc) { if (!doc) doc = document; if (!doc.Saved) throw "セーブされていません"; var tmp = this.beautifyFile(doc.FullName); doc.selection.SelectAll(); doc.selection.InsertFromFile(tmp, doc.Encoding, 0); var fso = new ActiveXObject("Scripting.FileSystemObject"); fso.DeleteFile(tmp); } } CodeBeautifier(); var beautifier = new CodeBeautifier(); /* 設定ここから */ beautifier.options = [ //"-space-after-start-bracket", //"-space-before-end-bracket", "-space-after-if", "-space-after-switch", "-space-after-while", "-space-before-start-angle-bracket", "-space-after-end-angle-bracket", "-extra-padding-for-case-statement", "-one-true-brace-function-declaration", "-glue-amperscore", "-change-shell-comment-to-double-slashes-comment", //"-indent-with-tab", "-force-large-php-code-tag", "-force-true-false-null-contant-lowercase", "-align-equal-statements", "--equal-align-position 50", "--comment-rendering-style PEAR", "--padding-char-count 4", "-optimize-eol" ]; /* 設定ここまで */ if (!document.Saved) { if (confirm("保存されていません\n上書き保存してもよろしいですか?")) { try { document.Save(document.FullName); } catch(e) { alert("保存できませんでした"); Quit(); } } else { Quit(); } } beautifier.beautifyDocument(); document.selection.StartOfDocument(); alert("整形完了しました"); 秀丸用マクロ「秀丸でPHPをインデントして読みやすくするマクロ」http //www.lyricfathom.com/pukiwiki/pukiwiki.php にインスパイヤされました。 実行には http //www.waterproof.fr/products/phpCodeBeautifier/ の phpCodeBeautifier に含まれる phpCB.exe をパスの通った場所(C \WINDOWSなど)に置いておく必要があります。 Changelog 2006-05-05 WshShell.Execute() ではなく WshShell.Run() を使って、出力をテンポラリファイル経由で読み込むようにした 使用者追記 2007-09-19 phpCodeBeautifier1.0.1でオプションの頭の-は全て--にするようにバグフィックスが行われました。使用者の方はお気をつけください。
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); ?
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/handsrecs/pages/36.html
PHP セッション // セッションスタート session_start(); // セッション変数初期化 $_SESSION = array(); // セッション破棄 session_destroy(); セッションを破棄する前にセッション変数を初期化する 日付 文字列日付形式変換 // 2009年10月5日 → 2009-10-5 date( Y-m-d , strtotime( 2009年10月5日 )); 2038年問題 http //www.revulo.com/blog/20070412.html http //www.syuhari.jp/blog/archives/198 DateTimeによる日付操作 オブジェクト生成 $datetime = new DateTime( 2009-02-10 ); 出力形式(xxxx年xx月xx日) $datetime- format( Y年m月d日 ); 翌日 $datetime- modify("+1 day"); 配列 削除 unset($data[ delete_key ]); ソート ksort($dateArray); // キーソート昇順 krsort($dateArray); // キーソート降順 配列の検索 in_array(検索値, 検索配列); // true あり false なし 型変換 数値→文字列 strval($int) 文字列 小文字→大文字 strtoupper( yyy )
https://w.atwiki.jp/mapcaps/pages/15.html
【課題1】 JavaScript を PHP で作成し、HTML に埋め込み可能なアクセスカウンタを作成 ( アクセスのカウントは、DB を使用する ) ? header( "Content-Type text/javascript; Charset=shift_jis" ); header( "Expires Wed, 31 May 2000 14 59 58 GMT" ); # ********************************************************** # 接続 # ********************************************************** $Connect = @mysql_connect( "localhost", "root", "" ); mysql_select_db( "lightbox", $Connect ); # 一行一列しかないテーブル( 初期値 0 ) $Query = "update counter set access_count = access_count + 1"; mysql_query( $Query, $Connect ); $Query = "select * from counter"; $Result = mysql_query( $Query, $Connect ); $Column = mysql_fetch_array( $Result ); # ********************************************************** # 接続解除 # ********************************************************** mysql_close( $Connect ); ? document.write( " SPAN style= color red ?= $Column[0] ? /SPAN " ); 【課題2】 GD を PHP で作成し、HTML に IMG ~ で埋め込み可能なアクセスカウンタを作成 ( アクセスのカウントは、DB を使用する ) ? # ********************************************************** # このソースコードは、EUC-JP で記述されています # ********************************************************** header("Content-type image/png"); header( "Content-Type text/javascript; Charset=shift_jis" ); header( "Expires Wed, 31 May 2000 14 59 58 GMT" ); $target = "http //127.0.0.1/php/pg080118/"; if ( substr( $_SERVER[ HTTP_REFERER ], 0, strlen( $target ) ) == $target ) { # ********************************************************** # 接続 # ********************************************************** $Connect = @mysql_connect( "localhost", "root", "" ); mysql_select_db( "lightbox", $Connect ); # 一行一列しかないテーブル( 初期値 0 ) $Query = "update counter set access_count = access_count + 1"; mysql_query( $Query, $Connect ); $Query = "select * from counter"; $Result = mysql_query( $Query, $Connect ); $Column = mysql_fetch_array( $Result ); $font_path = "./ArmedBanana.ttf"; # ********************************************************** # 内部コードは、UTF-8 ( EUC-JP でも良い ) # ********************************************************** mb_language( "ja" ); mb_internal_encoding( "UTF-8" ); # ********************************************************** # 対象文字列 # ********************************************************** $img_text = $Column[0]; $img_text = mb_convert_encoding( $img_text, "UTF-8", "EUC-JP" ); # ********************************************************** # キャンバス作成 # ********************************************************** $im = imagecreate( 150, 30 ); # *********************************************************** # 画像の背景色 # imagecolorallocate() の最初のコールで背景色がセットされます # *********************************************************** $white = imagecolorallocate( $im, 255, 255, 255 ); # *********************************************************** # 画像の文字色 # *********************************************************** $black = imagecolorallocate( $im, 0, 0, 0 ); imagettftext( $im, 20,# サイズ 0,# 角度 5,# x 座標 22,# y 座標 $black, $font_path, $img_text); # *********************************************************** # PNG 出力 # *********************************************************** imagepng($im); # *********************************************************** # 終了処理 # *********************************************************** imagecolordeallocate( $im, $black ); imagecolordeallocate( $im, $white ); imagedestroy($im); # ********************************************************** # 接続解除 # ********************************************************** mysql_close( $Connect ); } else { $Column[0] = アクセスできません ; } ? 【課題3】 JavaScript を PHP で作成し、HTML に埋め込み可能なGoogleサイト検索を作成 ( php に引数を渡して、サイトを選択できるようにする ) ? header( "Content-Type text/javascript; Charset=euc-jp" ); header( "Expires Wed, 31 May 2000 14 59 58 GMT" ); ? str= ; str+=" center "; str+=" form method=get action=\"http //www.google.co.jp/search\" target=\"_blank\" "; str+=" table bgcolor=\"#FFFFFF\" "; str+=" tr valign=top "; str+=" td "; str+=" a href=\"http //www.google.co.jp/\" "; str+=" img src=\"http //www.google.com/logos/Logo_40wht.gif\" nborder=\"0\" alt=\"Google\" align=\"absmiddle\" /a "; str+=" /td "; str+=" td "; str+=" input type=text name=q size=31 maxlength=255 value=\"\" "; str+=" input type=hidden name=ie value=euc-jp "; str+=" input type=hidden name=oe value=euc-jp "; str+=" input type=hidden name=hl value=\"ja\" "; str+=" input type=submit name=btnG value=\"Google 検索\" "; str+=" font size=-1 "; str+=" input type=hidden name=domains value=\"www.oracle.com/lang/jp/\" br "; str+=" input type=radio name=sitesearch value=\"\" "; str+="WWW を検索"; str+=" input type=radio name=sitesearch value=\"www.oracle.com/lang/jp/\" checked "; str+="Oracle を検索 /font /td /tr /table "; str+=" /form "; /* str+=" form method=get action=\"http //www.google.co.jp/search\" target=\"_blank\" 入力したキーワードを検索 br "; str+=" input type=text name=q size=60 maxlength=255 value=\"\" "; str+=" input type=submit name=btnG value=\"検索\" "; str+=" input type=hidden name=ie value=euc-jp "; str+=" input type=hidden name=oe value=euc-jp "; str+=" input type=hidden name=hl value=\"ja\" "; str+=" input style= display none type=radio name=sitesearch value=\"\" "; str+=" input style= display none type=radio name=sitesearch value=\"\" checked "; str+=" br ↓対象サイトを入力して下さい br "; str+=" input type=text name=domains value=\"\" size=\"60\" "; str+=" br "; str+=" /form "; / str+=" /center "; document.write( ?= str ? ); 【課題4】 ファイルアップローダを PHP で作成 GD を使って、日本語を表示して、その日本語を入力させて認証する メッセージを IFRAME 内に出力する 【課題5】 上記アプリケーションで、アップロードファイルの存在チェックを Ajax で行う。 新たな IFRAME を開いて、ファイルの詳細リストを表示する
https://w.atwiki.jp/father/pages/5.html
最新バージョン 2006/08/08現在 DB API PEAR PECL PHP 5.1.4 Released PHP 4.4.3 Released PHP Hypertext Preprocessor 3大美徳(http //www.lanl.gov/Document/) 無精 短気 傲慢 自分用のライブラリとか関数とか作っちゃったりしてます? でも大抵それって車輪の再発明だったりします。 例えば独自に作った関数などは世界中の誰かがもう クラスライブラリとして提供しているはずです。 運用形態は一般的に3つ DSO(Dynamic Shared Objects)普通こっちだけど遅い? CGI CLI モジュール mbstring GD ライブラリ バンドルエクステンション PEAR クラスライブラリ PECL パッケージ ADOdb クラスライブラリ JpGraph Smarty FPDF PHPLIB クラスライブラリ Pat PHP Application Tools クラスライブラリ ZendCodeギャラリ FLASH Ming関数 AMFPHP PDO http //www.thinkit.co.jp/free/marugoto/1/4/1/1.html debian の install # apt-get install libapache2-mod-php4 # apt-get install php4 これだけでいける .