ManiruzzamanAkash

SELECT DISTINCT sku, COUNT(sku) as occur 
FROM `items` 
GROUP BY sku 
HAVING occur > 1

ManiruzzamanAkash

<?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

-- 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

<?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

<!--
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

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

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)}

ManiruzzamanAkash

import React, { useState } from "react";
import SimpleModal from "./SimpleModal";

const Task1Form = () => {
  const [task1Show, setTask1Show] = useState(false);
  return (
    <>
      <button
        className="btn btn-sm btn-info"
        onClick={() => setTask1Show(true)}

ManiruzzamanAkash

import React, { useState } from "react";
import SimpleModal from "./Components/SimpleModal";

export default function App() {
  const [show, setShow] = useState(false);
  return (
    <div className="App">
      <h2>Modal Demo</h2>
      <button className="btn btn-info btn-sm" onClick={() => setShow(true)}>Open Modal 1</button>
      <hr />

ManiruzzamanAkash

import React from "react";
import { Modal } from "react-bootstrap";

const SimpleModal = (props) => {
  const { show, handleClose, size, modalTitle } = props;
  return (
    <Modal onClose={handleClose} size={size} show={show} onHide={handleClose}>
      <Modal.Header closeButton>
        <Modal.Title>{modalTitle}</Modal.Title>
        <p className="btn-modal-close" onClick={() => handleClose()}>