「～」と「～」

「～」と「～」

見た目は同じですが文字コードは別のものです。

file_get_contentsでPOST

$url = "https://southzone.sakura.ne.jp/posted.php";

$data = array(

'vids' => array(0=> "1" , 1=> "2"),

'tids' => array(0=> "10" , 1=> "20")

);

$content = http_build_query($data , '' , '&');

$options = array('http' => array(

'method' => 'POST',

'content' => $content

));

file_get_contents($url , false, stream_context_create($options));

MySQL 複数カラムにinを使うwhere句

SELECT

FROM

table_name

WHERE

(col1, col2) IN (

("hoge", "fuga"),

("foo", "bar")

)

#は\\でエスケープしないとシンタックスエラー

$(function(){

// #で始まるアンカーをクリックした場合に処理

$('a[href^=\\#]').click(function() {

// スクロールの速度

var speed = 400; // ミリ秒

// アンカーの値取得

var href= $(this).attr("href");

// 移動先を取得

var target = $(href == "#" || href == "" ? 'html' : href);

// 移動先を数値で取得

var position = target.offset().top;

// スムーススクロール

$('body,html').animate({scrollTop:position}, speed, 'swing');

return false;

});

php header

header('HTTP', true, 400);//phpのバージョンで正しく動きません

http_response_code(400);

explodeの挙動

<?php

$search = "スペースとか無いし";

$keywords = explode(" ", $search);

var_dump($keywords);

結果
array(1) { [0]=> string(27) "スペースとか無いし" }

--

$search = "";

$keywords = explode(" ", $search);

var_dump($keywords);

結果
array(1) { [0]=> string(0) "" }

--

$search = false;

$keywords = explode(" ", $search);

var_dump($keywords);

結果

array(1) { [0]=> string(0) "" }

google api console

検索しても見つからないこんなコンソールじゃポイズン
https://console.developers.google.com/apis/dashboard

カタカナ⇒ひらがな　力わざ

UPDATE `_table_` SET _column_ = REPLACE(_column_,"ア", "あ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"イ", "い");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ウ", "う");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"エ", "え");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"オ", "お");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"カ", "か");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"キ", "き");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ク", "く");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ケ", "け");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"コ", "こ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"サ", "さ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"シ", "し");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ス", "す");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"セ", "せ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ソ", "そ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"タ", "た");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"チ", "ち");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ツ", "つ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"テ", "て");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ト", "と");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ナ", "な");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ニ", "に");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ヌ", "ぬ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ネ", "ね");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ノ", "の");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ハ", "は");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ヒ", "ひ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"フ", "ふ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ヘ", "へ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ホ", "ほ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"マ", "ま");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ミ", "み");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ム", "む");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"メ", "め");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"モ", "も");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ヤ", "や");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ユ", "ゆ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ヨ", "よ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ラ", "ら");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"リ", "り");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ル", "る");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"レ", "れ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ロ", "ろ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ワ", "わ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ヲ", "を");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ン", "ん");

UPDATE `_table_` SET _column_ = REPLACE(_column_,"ガ", "が");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ギ", "ぎ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"グ", "ぐ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ゲ", "げ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ゴ", "ご");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ザ", "ざ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ジ", "じ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ズ", "ず");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ゼ", "ぜ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ゾ", "ぞ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ダ", "だ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ヂ", "ぢ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ヅ", "づ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"デ", "で");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ド", "ど");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"バ", "ば");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ビ", "び");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ブ", "ぶ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ベ", "べ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ボ", "ぼ");

UPDATE `_table_` SET _column_ = REPLACE(_column_,"パ", "ぱ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ピ", "ぴ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"プ", "ぷ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ペ", "ぺ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ポ", "ぽ");

UPDATE `_table_` SET _column_ = REPLACE(_column_,"ャ", "ゃ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ュ", "ゅ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ョ", "ょ");
UPDATE `_table_` SET _column_ = REPLACE(_column_,"ッ", "っ");

IE

インターネットエクスプローラーは、
input要素のform属性をformタグの外に配置した場合、反応しない

全角⇒半角

//全角⇒半角 function to_han(elm){ var v = $(elm).val(); v = v.replace(/[Ａ-Ｚａ-ｚ０-９]/g, function(s) { return String.fromCharCode(s.charCodeAt(0) - 0xFEE0);}); $(elm).val(v); }; function val_to_han(val){ return val.replace(/[Ａ-Ｚａ-ｚ０-９]/g, function(s) { return String.fromCharCode(s.charCodeAt(0) - 0xFEE0);}); };

southzone tech blog

「～」と「～」

file_get_contentsでPOST

MySQL 複数カラムにinを使うwhere句

#は\\でエスケープしないとシンタックスエラー

php header

explodeの挙動

google api console

カタカナ⇒ひらがな 力わざ

IE

全角⇒半角

カタカナ⇒ひらがな　力わざ