Skip to content

Instantly share code, notes, and snippets.

View wasipo's full-sized avatar

Kouhei Horiguchi wasipo

1 follower · 10 following
View GitHub Profile
@wasipo
wasipo / gist:28537fa9d3b9aa79b956ee44ee9354d3
Created September 25, 2020 20:50
```SQL
create schema test_1 collate utf8mb4_general_ci;
use test_1;
create table estimate
(
estimate_id int not null
primary key,
customer_id int null,
invoice_id int null,
host_id int null,
@wasipo
wasipo / php
Last active August 18, 2020 03:10
WordPressのナビゲーションを親子関係を持った配列で取得するスクリプト
function get_navigation_data($navigation_name) {
$locations = get_nav_menu_locations();
$menu = wp_get_nav_menu_object($locations[$navigation_name]);
$menu_items = wp_get_nav_menu_items($menu->term_id);
$result = [];
foreach($menu_items as $key => $item) {
if(array_key_exists((string)$item->menu_item_parent,$result)) {
$result[$item->menu_item_parent]['children'][] = ['title'=>$item->title,'url'=>$item->url];
@wasipo
wasipo / test.php
Created May 29, 2020 05:40
1行に入力項目が配列として入っているので、入力項目の配列を行にして、行に対して各項目の値を入れたい。
public function testRowArrayConvert() {
$ar = [
'a' => ['123','123','123','123'],
'b' => ['123','123','123','123'],
'c' => ['123','','123','123'],
'd' => ['123','123',null,'123'],
'e' => ['123','123','','123'],
'f' => ['','123','123','123'],
];
@wasipo
wasipo / gist:0b4a4ec54a7a6c83b4f51c58db799ced
Created May 29, 2020 05:39
1行に項目の配列が入ってるから項目の配列を行にして、各行に項目の値を入れたい
public function testRowArrayConvert() {
$ar = [
'a' => ['123','123','123','123'],
'b' => ['123','123','123','123'],
'c' => ['123','','123','123'],
'd' => ['123','123',null,'123'],
'e' => ['123','123','','123'],
'f' => ['','123','123','123'],
];
@wasipo
wasipo / php
Created November 20, 2019 01:36
<?php
$箱 = [];
$箱[] = '人形';
$箱[] = 'プラレール';
$箱[] = 'トミカ';
var_dump($箱);
$タンス = [];
@wasipo
wasipo / js
Created February 20, 2019 14:07
<!-- うごかない -->
<html>
<head>
<script>
jQuery(function(){
alert("age")
});
</scirpt>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<meta charset="utf-8" />
@wasipo
wasipo / jQuery
Created February 20, 2019 14:00
jQuery('#form').after('<div>message</div>')
jQuery('form').after('<div>message</div>')
jQuery('.form').after('<div>message</div>')
@wasipo
wasipo / js
Created October 1, 2018 17:14
jQuery散らかるので、JSを機能毎にまとめる方法ないか考察中
var event = {
page_a : function() {
jQuery("#b").on("click",function(){alert("mogekiti")})
},
}
@wasipo
wasipo / domdocument
Created September 12, 2018 17:24
DOMMMM
$image = getFirstImage(get_the_content());
if(!empty($image)) {
$doc = new DOMDocument();
@$doc->loadHTML($image);
$finder = new DomXPath($doc);
$ele = $finder->query("//*[contains(@class, 'alignnone')]")->item(0)->removeAttribute; // <- こいつがエラーするんだ
var_dump($ele);
}
@wasipo
wasipo / regexp img
Created September 12, 2018 17:16
setumei
function getFirstImage($content) {
$pattern = "/<img.*?src\s*=\s*[\"|\'](.*?)[\"|\'].*?>/i";
preg_match($pattern,$content,$images);
if(empty($images)) {
$result = false;
} else {
$result = $images[0];
}