Skip to content

Instantly share code, notes, and snippets.

View akrez's full-sized avatar
😋
Work Partially

AliAkbar Rezaei akrez

😋
Work Partially
View GitHub Profile
@akrez
akrez / sql.php
Last active February 3, 2022 13:47
insert on update #php #yii2
<?php
Yii::$app->db->createCommand("
INSERT INTO `post_static` (`type`,`value`,`isbn`,`vol`,`book`) (SELECT `type`,`value`,`isbn`,COUNT(`id`) as cnt,1 as book FROM `post_abstract` GROUP BY `type`,`value`,`isbn` HAVING SUM(`static`)>0)
ON DUPLICATE KEY UPDATE
`vol`=VALUES(`vol`),
`book`=1
")->execute();
?>
@akrez
akrez / AkrezHelper.php
Last active February 3, 2022 13:53
#php #helper
<?php
//multiple delimiters in explode without using regex
function iexplode($delimiters, $string, $limit = PHP_INT_MAX)
{
if (!is_array($delimiters))
{
$delimiters = [$delimiters];
}
$del = reset($delimiters);
@akrez
akrez / iso-3166-2.json
Created July 29, 2021 09:46
iso-3166-2.json
{
"AD": {
"id": "AD",
"name": "Andorra",
"level": 1,
"parent_id": null,
"title": ""
},
"AE": {
"id": "AE",
@akrez
akrez / validateIranianNationalCode.php
Created July 29, 2021 10:05
PHP: اعتبارسنجی کد ملی ایرانیان
<?php
function validateNationalCode($NationalCode)
{
$NationalCode = preg_replace("/[^0-9]/", '', $NationalCode);
$notNationalCode = [
"1111111111",
"2222222222",
"3333333333",
"4444444444",
"5555555555",
@akrez
akrez / ConsoleController.php
Last active December 31, 2021 10:23
yii2: run migrate by web interface
<?php
namespace app\controllers;
use Yii;
use yii\console\controllers\MigrateController;
class ConsoleController extends Controller
{
public function actionMigrate()
@akrez
akrez / colors.json
Created February 3, 2022 13:45
لیست رنگهای استاندارد وب به فارسی و انگلیسی
{
"fa": {
"CD5C5C": "جگری",
"F08080": "بژ تیره",
"FA8072": "حنایی روشن",
"E9967A": "قهوه‌ای حنایی",
"FFA07A": "نارنجی کرم",
"FF0000": "قرمز",
"DC143C": "زرشکی",
"B22222": "شرابی",
@akrez
akrez / create-project-laravel.sh
Created March 25, 2022 21:23
Installing specific laravel version with composer create-project
composer create-project laravel/laravel="8.*" lara8
git archive --format=zip --output asd.zip 56a4e42e
@akrez
akrez / Database.php
Last active June 1, 2023 11:07
simple sample database wrapper worked with pdo and sqlite
<?php
class Database
{
protected $pdo;
protected function setPdo(PDO $pdo)
{
return $this->pdo = $pdo;
}
protected function getPdo()
#!/usr/bin/env bash
PACKAGES="$*"
ABSOLUTE_PATH=$(realpath $(dirname ${BASH_SOURCE[0]}))
function error {
echo "$1" 1>&2
exit 1
}