2013.11.15 Friday | 16:06

  jQuery+¥¹¥È¥ê¡¼¥È¥Ó¥å¡¼¤Îɽ¼¨¥Æ¥¹¥È ¥×¥í¥°¥é¥Þ

<script src="http://winofsql.jp/jquery/plugins/street_view.js"></script>
<script>
$(function(){
	$('#pano')
	.StreetView(47.615471,1.518008)
	.StreetViewPov(-42.14,9.13)
	.css("width","600px")
	.css("height","450px");
});
</script>
<div id="pano"></div>



2011.02.22 Tuesday | 12:26

  SQL¡£¤ª¤Þ¤È¤á¥ê¥ó¥¯ ¥×¥í¥°¥é¥Þ



  1. inner join
  2. left outer join
  3. Æüì¤Ê·ë¹ç±é»»»Ò : TECHSCORE
  4. sql03_01 ( ¼«¸Ê·ë¹ç ) : ´ÉÍý¼ÔÊ̼Ұ÷°ìÍ÷


  1. ´Ø¿ô
  2. ʸ»úÎó·ë¹ç
  3. 񂯯
  4. ¾ò·ï


  1. group by
  2. having
  3. ¥°¥ë¡¼¥×´Ø¿ô


sql_point_01.png
  • NULL ¤¬´Þ¤Þ¤ì¤ë±é»»¤Ï NULL ¤Ë¤Ê¤ë¤Î¤Ç¡¢¤½¤¦¤Ê¤é¤Ê¤¤¤è¤¦¤Ë´Ø¿ô¤òÍøÍѤ¹¤ë
  • sql01_01 : ½ê°Ê̻ٵë³Û¾ðÊó


sql_point_01.png
  • ½ÅÊ£¤òÇÓ½ü¤¹¤ë¥­¡¼¥ï¡¼¥É¡£SELECT ¹½Ê¸¤È¡¢¥°¥ë¡¼¥×´Ø¿ô¤Ç»ÈÍѤǤ­¤ë
  • sql01_02 : 9·îÅÙÇä¾å¾¦ÉÊ¿ô


sql_point_01.png


sql_point_01.png
  • ¥Ó¥å¡¼¤òºîÀ®¤·¤Ê¤¤¤Ç¡¢µ­½Ò¤Ë¤è¤Ã¤Æ°ì»þŪ¤Ë¥Ó¥å¡¼¤ÈƱÅù¤Î½èÍý¤ò¹Ô¤¦¥Æ¥¯¥Ë¥Ã¥¯( ÉûÌä¹ç¤»¤Î°ì¼ï )


sql_point_01.png
  • SQL µ­½Ò¤Ë¤è¤ë¥Ç¡¼¥¿¥Ù¡¼¥¹Æâ¤Ç¤Î¥Ç¡¼¥¿¤Î¥³¥Ô¡¼ÊýË¡¡£Æó¼ïÎढ¤Ã¤Æ¡¢ÊÒÊý¤Ï ɽ¤µ¤¨¤âºîÀ®¤·¤Æ¤·¤Þ¤¦¡£
  • RDBMS ¤Ë¤è¤Ã¤Æ¤Ï¡¢CREATE ¹½Ê¸¤Ë SELECT ¤ò»ÈÍѤǤ­¤ë
  • »²¹Í SQL¤ÎÁë¥ê¥ó¥¯


sql_point_01.png


sql_point_01.png


sql_point_01.png


sql_point_01.png


sql_point_01.png





2010.12.17 Friday | 11:02

  SyntaxHighlighter ¥Ó¥ë¥É¥æ¥Ë¥Ã¥È( ¥Ö¥í¥°ÈÆÍÑ ) ¥×¥í¥°¥é¥Þ

¥é¥¤¥Ö¥é¥ê¤Ï¤³¤Á¤é¤Î¥µ¥¤¥È¤Ç¥Û¥¹¥Æ¥£¥ó¥°¤·¤Æ¤¤¤ë¤Î¤Ç¡¢½ÐÍè¾å¤¬¤Ã¤¿
·ë²Ì¤ò¼«Ê¬¤Î¥Ö¥í¥°¤ËŽ¤ë¤À¤±¤Ç¡¢¤´ÍøÍѤǤ­¤Þ¤¹¡£¤Þ¤¿¡¢¤³¤Îµ­»öËö¤Î
¥³¡¼¥É¤ò¥Ö¥í¥°¤ËŽ¤ë¤È¡¢¥æ¥Ë¥Ã¥È¤òÀßÃÖ¤¹¤ë»ö¤¬¤Ç¤­¤Þ¤¹¡£
utf-8
<script type="text/javascript" src="http://winofsql.jp/sh/load_sh_unit.php?charset=utf-8"></script>
shift_jis
<script type="text/javascript" src="http://winofsql.jp/sh/load_sh_unit.php?charset=shift_jis"></script>
euc-jp
<script type="text/javascript" src="http://winofsql.jp/sh/load_sh_unit.php?charset=euc-jp"></script>
¾¤ÎÀßÃÖ¾ì½ê

Seesaa
Ǧ¼Ô¥Ö¥í¥°
JUGEM
livedoor
FC2





2010.10.31 Sunday | 14:43

  ¥¢¥Þ¥¾¥ó¤Î Product Advertising API ¤Î¥«¥¹¥¿¥Þ¡¼¥ì¥Ó¥å¡¼¤ÎÂбþ ¥×¥í¥°¥é¥Þ

Creview

Êѹ¹ÆâÍƤϤ¿¤¤¤·¤¿»ö¤Ç¤Ï¤Ê¤¤¤Î¤ÇÊü¤Ã¤Æ¤ª¤¤¤Æ¤Þ¤·¤¿¤¬¡¢¤µ¤¹¤¬¤Ë¤½¤í¤½¤í
¤·¤Æ¤ª¤«¤Ê¤¤¤È˺¤ì¤Æ¤·¤Þ¤¤¤Þ¤¹¡£¤½¤â¤½¤â¡¢Â¾¿Í¤Îʸ¾Ï¤ò¤½¤Î¤Þ¤Þ¼è¤Ã¤Æ¤³
¤ì¤Æ¤¤¤¿¤Î¤¬¤ª¤«¤·¤¤¤Î¤Ç¤¹¤¬¡¢¥ê¥ó¥¯¤ò»È¤Ã¤Æ IFRAME ²½¤·¤Æ¤â¤¢¤Þ¤ê³Ê¹¥
Îɤ¯Ìµ¤¤¤Î¤Ç¡¢shadowbox ¤ò»È¤Ã¤Æ¡¢¤«¤Ã¤³¤è¤¯¥Ú¡¼¥¸Æâ¤Ë¤Ç¤­¤ë¤«¤®¤êÂ礭
¤¯É½¼¨¤¹¤ë¤è¤¦¤Ë¤·¤Þ¤·¤¿¡£

¤Ç¤Þ¤¢¡¢¼«Ê¬¤Î¥Ö¥í¥°¤Ç½ñ¤¤¤¿¥ì¥Ó¥å¡¼¤ò¸ÄÊ̤ËÁÞÆþ¤Ç¤­¤ë¤è¤¦¤Ë¤·¤Æ¡¢
¤·¤Ð¤é¤¯ÍͻҤò¸«¤è¤¦¤È»×¤¤¤Þ¤¹¡£


¢¨ »È¤¤Êý¤Ï¡¢¾å¤Î¥µ¥ó¥×¥ë¤Î¥½¡¼¥¹¤ò¸«¤ì¤Ð²ò¤ê¤Þ¤¹


¤½¤ì¤È¡¢Ëº¤ì¤¬¤Á¤Ê¤Î¤Ç¡¢API ¤Î¥­¡¼¤Î³Îǧ¡£

1) Product Advertising API ¥¿¥Ö
2) ¤Á¤ç¤Ã¤È¥¹¥¯¥í¡¼¥ë¤·¤Æ¡¢¥ê¥½¡¼¥¹¤Î ¥¢¥«¥¦¥ó¥ÈÀßÄê 
3) ¥¢¥¯¥»¥¹¥­¡¼¾ðÊó ¤Ç¡¢API ÍÑ¤Î¥í¥°¥¤¥ó





2010.10.31 Sunday | 10:31

  ¤Û¤Ü¡¢Á´¤Æ JavaScript ¤ÇºîÀ®¤µ¤ì¤ë Twitter ¤Î¥Ú¡¼¥¸¤ÇÌܤò°ú¤¯3¤Ä¤Î¥¹¥¯¥ê¥×¥Èµ­½Ò ¥×¥í¥°¥é¥Þ

¤½¤Î£±

¤¿¤Ö¤ó¡¢IE ¤ËÂФ¹¤ë¥Ö¥Ã¥¯¥Þ¡¼¥¯¥ì¥Ã¥ÈÍѤΥץí¥Æ¥¯¥È¤Ç¤¹¡£
³°Éô¥É¥á¥¤¥ó¤ò»²¾È¤¹¤ë¤è¤¦¤Ê¥Ö¥Ã¥¯¥Þ¡¼¥¯¥ì¥Ã¥È¤¬Æ°¤«¤Ê¤¯¤Ê¤ê¤Þ¤¹¡£

( IE °Ê³°¤Ç¤Ï»î¤·¤¿»ö¤¢¤ê¤Þ¤»¤ó¡£)
<script type="text/javascript" charset="utf-8">
  // this must be set absolutely before any other script on the app is loaded for IE7
  document.domain = 'twitter.com';
</script>


¤½¤Î£²

Firebug ¤¬¼Â¹ÔÃæ¤Ç̵¤¤¾ì¹ç¤Ë¥¨¥é¡¼¤Ë¤Ê¤é¤Ê¤¤¤è¤¦¤Ë¤·¤¿¤â¤Î¤Ç¡¢
¥Ú¡¼¥¸¤Î¥Ç¥Ð¥Ã¥°¤ò¤¤¤Ä¤Ç¤â¤Ç¤­¤ë¤è¤¦¤Ë¤¹¤ë°Ù¤ÎÆü쥪¥×¥·¥ç¥ó¤À¤È»×¤¤¤Þ¤¹¡£

»È¤¤Êý¤È¤·¤Æ¤Ï¡¢JavaScript ¤«¤é Firebug ¤Î¥³¥ó¥½¡¼¥ë¤ËľÀܽÐÎϤ¹¤ë¤è¤¦¤Ê
¥Æ¥¹¥È¤ò¤¹¤ë¤Î¤Ç¤·¤ç¤¦¤¬¡¢¤½¤Î½èÍý¤òËä¤á¹þ¤ó¤À¤Þ¤Þ¤Ç¤â±¿ÍѤǤ­¤ë¤è¤¦¤Ë¤¹¤ë
°Ù¤À¤È»×¤ï¤ì¤Þ¤¹¡£

Console API - FirebugWiki
<script>
  var TIME = +new Date;
  if (!window.console) {
    var names = ["log", "debug", "info", "warn", "error", "assert", "dir", "dirxml",
      "group", "groupEnd", "time", "timeEnd", "count", "trace", "profile", "profileEnd"];
    window.console = {};
    for (var i = 0; i < names.length; ++i)
      window.console[ names[ i ] ] = function() {}
  }
</script>


¤½¤Î£³

¤ß¤¿¤Þ¤Þ¤Ç¤¹¤¬¡¢IE6 °ÊÁ°¤Î¥Ö¥é¥¦¥¶¤Î°Ù¤Î¤Ê¤ó¤é¤«¤Î½èÍý¤Ç¤¹¤¬¡¢
²Ë¤Ê»þ¤Ë¸«¤Æ¤ß¤Þ¤¹¡£¤Þ¤À IE6 Æ°¤¯´Ä¶­¤¢¤ë¤Î¤Ç¡£
<!--[if lte IE 6]>
<script src="http://a0.twimg.com/a/1288470193/javascripts/phoenix/phxie6.bundle.js"></script>
<![endif]-->

IE ÍѾò·ï¥³¥á¥ó¥È : ¥Ð¡¼¥¸¥ç¥ó ¥Ù¥¯¥¿





2010.10.30 Saturday | 19:45

  PHP 5.3.0 °Ê¹ß¤Î̵̾´Ø¿ô ¥×¥í¥°¥é¥Þ

¼Ú¤ê¤Æ¤¤¤ë¡Ö¤µ¤¯¤é¥¤¥ó¥¿¡¼¥Í¥Ã¥È¡×¤Ç¤Ï¤Þ¤À 5.3.0 ¤Ï»È¤¨¤Ê¤¤¤ß¤¿¤¤¤Ç¤¹¤¬¡¢
¥í¡¼¥«¥ë¤Î 5.3.0 ¤ÇÆ°¤«¤·¤Æ¤ß¤ë¤Èµ¤»ý¤ÁÎɤ¯Æ°¤¤¤¿¤Î¤Ç¤¹¡£

¤Ê¤ó¤À¤« JavaScript ½ñ¤¤¤Æ¤ë¤ß¤¿¤¤¤Ç¡£

ÆäËÊ£»¨¤ÊÊÑ¿ô¤òÌÀ¼¨¤¹¤ë°Ù¤Î {} ¤¬Ìò¤ËΩ¤Ã¤Æ¤Þ¤¹¤Í¤§¡¼¡¼

5.3.0 ¤Ç¤Î°ã¤¤¤ò¤Ï¤Ã¤­¤êǧ¼±¤·¤¿¤Î¤Ïº£²ó½é¤á¤Æ¤À¤Ã¤¿¤Î¤Ç¤¹¤¬¡¢
¤½¤ó¤Ê¤Ë¤¤¤Á¤¤¤Á¥É¥­¥å¥á¥ó¥È¤ËÌܤòÄ̤¹¤ï¤±¤Ç¤â̵¤¯¡£¤¿¤À¡¢É¬¤º
¤µ¤¯¤é¥¤¥ó¥¿¡¼¥Í¥Ã¥È¤Ë¥¢¥Ã¥×¤·¤Æ¼Â¹Ô¤ò³Î¤«¤á¤ë¤Î¤¬¾ï¤Ê¤Î¤Ç¡¢
¥µ¡¼¥Ð¡¼¤ÇÆ°¤«¤Ê¤¯¤Ã¤Æ¡¢¡Ö¤¢¤ì¤ì¤ì¤ì¡×

º£¸å¤Ï¤â¤Ã¤Èµ¤¤òÉÕ¤±¤Þ¤·¤ç¤¦¡£
<?
// **********************************************************
// n ·å¤ÎÁ°¥¼¥íʸ»úÎó¤òºîÀ®¤¹¤ë¤Ë¤Ï
// °Ê²¼¤Ç´Êñ¤ËºîÀ®¤Ç¤­¤Þ¤¹¤¬¡¢
// **********************************************************
$a = sprintf("%05d", 1);
print "$a<br>";

// **********************************************************
// ¤É¤ó¤Ê¸À¸ì¤Ç¤â¤¿¤Ö¤ó¤¢¤ë´Ø¿ô(¥á¥½¥Ã¥É)¤ò»È¤Ã¤Æ¹Ô¤¦¤Ë¤Ï
// **********************************************************

// 1) n ·å¤Î 0 ¤òÌÜŪ¤Îʸ»úÎó¤ÎÁ°¤ËÏ¢·ë¤¹¤ë

$a = "00000" . 1;

// 2) Á´ÂΤÎŤµ¤ò¼èÆÀ¤¹¤ë

$len = strlen($a);

// 3) Á´ÂΤÎŤµ - Íߤ·¤¤Ä¹¤µ¤ò³«»Ï°ÌÃ֤Ȥ¹¤ë

$start = $len - 5;

// 4) ¤½¤Î°ÌÃÖ¤«¤éÍߤ·¤¤Ä¹¤µ¤Ö¤óÀÚ¤ê¼è¤ë

$x = substr( $a, $start, 5 );

print "$x<br>";

// **********************************************************
// PHP 5.3.0 ¤è¤ê¼Â¹Ô²Äǽ¤Ê̵̾´Ø¿ô
// **********************************************************
$f = function( $target, $n ) {

	$target = str_repeat("0",$n) . $target;
	$len = strlen($target);
	$start = $len - $n;
	$target = substr( $target, $start, $n );
	return $target;

};

print "{$f(1,5)}<br>";
print "{$f("AA",5)}<br>";
print "{$f("¤¢A",5)}<br>";
print "{$f(1234,5)}<br>";
print "{$f(12345,5)}<br>";

?>

´ØÏ¢¤¹¤ëµ­»ö

PHP : Á°¥¼¥íʸ»úÎóºîÀ®¤È±¦¤«¤éɬÍפÊŤµÊ¸»úÎó¤ò¼èÆÀ¤¹¤ë½èÍý





1/2 >>