Skip to content

Instantly share code, notes, and snippets.

View tilhom's full-sized avatar
😎
On vacation

Ilyos Xizr tilhom

😎
On vacation
13 followers · 5 following
  • Uzbekistan, Tashkent
View GitHub Profile
@tilhom
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
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
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
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
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
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
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
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
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
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