tilhom’s gists

tilhom / gist:099f3658cc248cb8cefd2d9851c017da

Created March 19, 2019 07:36

to get field names from mysql table

	SELECT COLUMN_NAME
	FROM INFORMATION_SCHEMA.COLUMNS
	WHERE TABLE_SCHEMA = 'committee' AND TABLE_NAME = 'users'

tilhom / gist:351f0f14c86bbff56d305b87140aab20

Last active December 16, 2018 06:15

js invoice maker

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<title>L2-4</title>
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
	<link href="https://stackpath.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet" integrity="sha384-wvfXpqpZZVQGK6TAh5PVlGOfQNHSoD2xbE+QkPxCAFlNEevoEH3Sl0sibVcOQVnN" crossorigin="anonymous">
	<style type="text/css">table thead {
	text-align:center;
	}

tilhom / gist:c83de2e2ab3a42c719c56ebeb054560f

Last active December 4, 2018 16:58

sort search table

	<!DOCTYPE html>
	<html>
	<head>
	<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
	<title>Codeclass Tutorial \| Search HTML Table Data by using JQuery</title>
	<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous">
	<script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js" integrity="sha384-ZMP7rVo3mIykV+2+9J3UJ46jBk0WLaUAdn689aCwoqbBJiSnjAK/l8WvCWPIPm49" crossorigin="anonymous"></script>
	<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js" integrity="sha384-ChfqqxuZUCnJSK3+MXmPNIyE6ZbWh2IMqE241rYiqJxyMiZ6OW/JmZQ5stwEULTy" crossorigin="anonymous"></script>
	<script src="

tilhom / gist:94dbb833d5dd03856e0254843ad24436

Created December 4, 2018 15:58

table for filtr

	<div class="table-responsive" >
	<table class="table table-striped" id="employee_table">
	<thead class="text-light bg-dark sticky-top">
	<tr>
	<th width="5%" data-sort="int">ID</th>
	<th width="25%" data-sort="string">Name</th>
	<th width="35%" data-sort="string">Address</th>
	<th width="10%" data-sort="string">Gender</th>
	<th width="20%" data-sort="string">Designation</th>
	<th width="5%" data-sort="string">Age</th>

tilhom / gist:a27255265de7fce7ff37ef1e7730fb67

Created December 4, 2018 15:12

jquery 1

	<!DOCTYPE html>
	<html>
	<head>
	<title>jQuery Crash Course \| Selectors</title>
	<style>
	body{
	font-size: 17px;
	font-family: arial;
	background: #f4f4f4;
	line-height: 1.5em;

tilhom / gist:c50badb6a384afb6c76abfa9fd9889dc

Created November 23, 2018 11:33

laravel search with

	$categories = Categories::whereHas('products', function ($query) use ($searchString){
	$query->where('name', 'like', '%'.$searchString.'%');
	})
	->with(['products' => function($query) use ($searchString){
	$query->where('name', 'like', '%'.$searchString.'%');
	}])->get();

	foreach($categories as $category){
	echo $category->name . ':' . PHP_EOL;
	foreach($category->products as $product){

tilhom / gist:c793a08033041500503468ac4658bb3b

Created November 20, 2018 08:23

For, while, date

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="UTF-8">
	<title>For</title>
	<link href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous">
	</head>
	<body>
	<div class="container">
	<h1>Hello loops!</h1>

tilhom / gist:eef1b6566afd4c958222432249632fcf

Last active November 17, 2018 06:47

Рекурсивное отображение категорий


	function getCategories($categories, &$result, $parent_id = 0, $depth = 0)
	{
	//filter only categories under current "parent"
	$cats = $categories->filter(function ($item) use ($parent_id) {
	return $item->parent_id == $parent_id;
	});

	//loop through them
	foreach ($cats as $cat)

tilhom / gist:33f72c998c2d3cd60eb28a588cf36e0d

Created November 7, 2018 14:46

dom_manipulation

	<!DOCTYPE html>
	<html>
	<head>
	<title>jQuery Crash Course \| DOM Manipulation</title>
	<script src="https://code.jquery.com/jquery-3.1.0.min.js"></script>
	<style>
	body{
	font-size: 17px;
	font-family: arial;
	background: #f4f4f4;

tilhom / gist:a5ee77336dff6dd62692dc4d93a12864

Created November 6, 2018 16:52

md5.min.js

!function(n){"use strict";function t(n,t){var r=(65535&n)+(65535&t);return(n>>16)+(t>>16)+(r>>16)<<16|65535&r}function r(n,t){return n<<t|n>>>32-t}function e(n,e,o,u,c,f){return t(r(t(t(e,n),t(u,f)),c),o)}function o(n,t,r,o,u,c,f){return e(t&r|~t&o,n,t,u,c,f)}function u(n,t,r,o,u,c,f){return e(t&o|r&~o,n,t,u,c,f)}function c(n,t,r,o,u,c,f){return e(t^r^o,n,t,u,c,f)}function f(n,t,r,o,u,c,f){return e(r^(t|~o),n,t,u,c,f)}function i(n,r){n[r>>5]|=128<<r%32,n[14+(r+64>>>9<<4)]=r;var e,i,a,d,h,l=1732584193,g=-271733879,v=-1732584194,m=271733878;for(e=0;e<n.length;e+=16)i=l,a=g,d=v,h=m,g=f(g=f(g=f(g=f(g=c(g=c(g=c(g=c(g=u(g=u(g=u(g=u(g=o(g=o(g=o(g=o(g,v=o(v,m=o(m,l=o(l,g,v,m,n[e],7,-680876936),g,v,n[e+1],12,-389564586),l,g,n[e+2],17,606105819),m,l,n[e+3],22,-1044525330),v=o(v,m=o(m,l=o(l,g,v,m,n[e+4],7,-176418897),g,v,n[e+5],12,1200080426),l,g,n[e+6],17,-1473231341),m,l,n[e+7],22,-45705983),v=o(v,m=o(m,l=o(l,g,v,m,n[e+8],7,1770035416),g,v,n[e+9],12,-1958414417),l,g,n[e+10],17,-42063),m,l,n[e+11],22,-1990404162),v=o(v

Ilyos Xizr tilhom