Skip to content

Instantly share code, notes, and snippets.

Avatar
👨‍💻
Building the Better World By Writing Stuffs...

Maniruzzaman Akash ManiruzzamanAkash

👨‍💻
Building the Better World By Writing Stuffs...
View GitHub Profile
@ManiruzzamanAkash
ManiruzzamanAkash / update-after-join-two-table.sql
Created Jan 22, 2022
Update Concating MySQL two table after JOIN
View update-after-join-two-table.sql
UPDATE words
JOIN categories ON categories.id = words.chapter_id
SET words.image=CONCAT(categories.slug, "/", words.en, ".jpg")
@ManiruzzamanAkash
ManiruzzamanAkash / .storybook-preview.js
Last active Jan 21, 2022
Storybook preview js file to support tailwind version > 3.0
View .storybook-preview.js
import '!style-loader!css-loader!postcss-loader!tailwindcss/tailwind.css';
import '!style-loader!css-loader!sass-loader!../src/scss/style.scss';
export const parameters = {
actions: { argTypesRegex: '^on[A-Z].*' },
controls: {
matchers: {
color: /(background|color)$/i,
date: /Date$/,
},
@ManiruzzamanAkash
ManiruzzamanAkash / duplicate-product-checker-by-sku.sql
Created Dec 13, 2021
Duplicate Product Check By SKU in MySQL
View duplicate-product-checker-by-sku.sql
SELECT DISTINCT sku, COUNT(sku) as occur
FROM `items`
GROUP BY sku
HAVING occur > 1
@ManiruzzamanAkash
ManiruzzamanAkash / Dfs.c
Created Feb 16, 2017
DFS code in C language
View Dfs.c
/***
BFS code in C language
@author: Maniruzzaman Akash<manirujjamanakash@gmail.com>
**/
#include<stdio.h>
int a[20][20], reach[20],n;
@ManiruzzamanAkash
ManiruzzamanAkash / regex-examples.php
Last active Jun 5, 2021
All Possible basic to advance level regex pattern example in depth example
View regex-examples.php
<?php
/** EXAMPLE 1: With Digit check **/
echo "Digit Check\n-------------------\n";
// Basic Concept : /pattern/i
// / : start delimeter
// pattern : Here will be the pattern, [ eg: \d - Check if one digit match and then space ]
// i :for case insensitive [ eg: mg, mgi, i, m ]
@ManiruzzamanAkash
ManiruzzamanAkash / concat-multiple-row-in-a-row-mysql.sql
Last active May 20, 2021
Concat multiple row data in a single row mysql Complete example
View concat-multiple-row-in-a-row-mysql.sql
-- Approach 1: Add <br /> tag after each row
---------------------------------------------------
SET session group_concat_max_len=20000;
INSERT INTO `terms` (`id`, `category`, `country`, `language`, `menu`, `content`, `page_id`, `footer`, `key`, `en`, `fi`, `se`, `no`, `dk`, `de`, `it`, `fr`, `es`, `pl`, `al`, `ru`, `ar`, `bn`, `so`, `ku`, `vi`, `cn`, `sr`, `tr`, `order_nr`, `ja`, `uk`, `ro`, `nl`, `el`, `ind`, `th`, `pt`, `lt`, `fa`, `hi`, `status`, `created_by`, `updated_by`, `deleted_by`, `deleted_at`, `created_at`, `updated_at`)
VALUES ( 805, NULL, NULL, NULL, '0', '0', NULL, '0', 'pd805', (SELECT GROUP_CONCAT(en SEPARATOR '<br>') FROM terms as t WHERE id IN (811,812,809)), (SELECT GROUP_CONCAT(fi SEPARATOR '<br>') FROM terms as t WHERE id IN (811,812,809)), (SELECT GROUP_CONCAT(se SEPARATOR '<br>') FROM terms as t WHERE id IN (811,812,809)), (SELECT GROUP_CONCAT(`no` SEPARATOR '<br>') FROM terms as t WHERE id IN (811,812,809)), (SELECT GROUP_CONCAT(`dk` SEPARATOR '<br>') FROM terms as t WHERE id IN (8
@ManiruzzamanAkash
ManiruzzamanAkash / GetDatesFromDay.php
Created Apr 18, 2021
Get dates of a day range from input using php
View GetDatesFromDay.php
<?php
/**
Author : MD. Maniruzzaman Akash
Live Link: https://paiza.io/projects/e/TwNe185C_A2kJPZlXE6SGw?theme=twilight
**/
$days = ['Saturday', 'Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday'];
@ManiruzzamanAkash
ManiruzzamanAkash / Bootstrap4-User-Comment-View.html
Created Apr 5, 2018
This is a demo user comment form snippet built on Bootstrap 4 CSS framework and with card basically. There is also added font awesome.
View Bootstrap4-User-Comment-View.html
<!--
Author : Maniruzzaman Akash
Email : manirujjamanakash@gmail.com
-->
<!--To Work with icons-->
<link href="https://stackpath.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css" rel="stylesheet" integrity="sha384-wvfXpqpZZVQGK6TAh5PVlGOfQNHSoD2xbE+QkPxCAFlNEevoEH3Sl0sibVcOQVnN" crossorigin="anonymous">
<div class="container">
<h2 class="text-center">Bootstrap 4 User Rating Form / Comment Form</h2>
@ManiruzzamanAkash
ManiruzzamanAkash / App.js
Created Feb 9, 2021
Use of Demo Modal in APp
View App.js
import React, { useState } from "react";
import SimpleModal from "./Components/SimpleModal";
import Task1Form from "./Components/Task1Form";
import Task2Form from "./Components/Task2Form";
export default function App() {
const [show, setShow] = useState(false);
return (
<div className="App">
<h2>Modal Demo</h2>
@ManiruzzamanAkash
ManiruzzamanAkash / Task2Form.jsx
Created Feb 9, 2021
Task2Form For Simple Modal React
View Task2Form.jsx
import React, { useState } from "react";
import SimpleModal from "./SimpleModal";
const Task2Form = () => {
const [task1Show, setTask1Show] = useState(false);
return (
<>
<button
className="btn btn-sm btn-info"
onClick={() => setTask1Show(true)}