Php, Laravel

Title Code
table [show]
<?php 	
	$sql="select*from child";
	$result=mysqli_query($conn,$sql);	
?>
    <h1 class="text-center mb">User information</h1>

    <table class="table"  border="1">
      	<thead>
                <th>Id</th>        
        	<th>Name</th> 
      	</thead>
      	<tbody>
		<?php while ($row=mysqli_fetch_assoc($result)) { ?>
			<tr>
		       	  <td><?php echo $row['id'];?></td>
		          <td><?php echo $row['name'];?></td>          
		        </tr>
			<td>
  				<a class="btn btn-info" href="view.php?id=<?php echo $row['id']; ?>">View</a>
  				<a class="btn btn-danger" onclick="return confirm('Are you sure?')"
					href="delete.php?id=<?php echo $row['id']; ?>">Delete</a>
  			</td>
	     	<?php } ?>
      	</tbody>
    </table>
alert
(1st part) ex: edit.php
	header("Location: index.php?success=1");
	<a class="btn btn-info" href="view.php?success=1">
	$_SESSION['success']=1;  //true
NB: number not mandatory

(2nd part...) 
<div class="col-md-9">
	<?php if(isset($_GET['success'])) { ?>
		<div class="alert alert-success">
			<strong>Success!</strong> Added successfully.
		</div>
	<?php } ?>
</div>

session_start();

<div class="col-md-9">
	<?php if(isset($_SESSION['success'])) { ?>
		<div class="alert alert-success">
			<strong>Success!</strong> Added successfully.
		</div>
	<?php } ?>
</div>
unset($_SESSION['success']);

NB: alert list
success, danger, info, warning

CSS: .alert {
  padding: 20px;
  background-color: #f44336;
  color: white;
}


<a href="index.php" class="confirmation"></a>
<script>
    $('.confirmation').on('click', function () {
        return confirm('Are you sure?');
    });
</script>

<a class="btn btn-danger btn-fill pull-center" onclick="return confir
table [show]
<?php $sql="select*from child where id=$id";
	$result=mysqli_query($conn,$sql);
  $row=mysqli_fetch_assoc($result); ?>

<table class="table">
	<tr>
		<th width="100" class="text-right">Name : </th>     
		<td class="text-left"> <?= $row['name']; ?></td>     
	</tr>
	<tr>
		<th width="100" class="text-right">Roll : </th> 
		<td class="text-left"> <?= $row['roll']; ?> </td>     
	</tr>
	<tr>
		<th width="100" class="text-right">Age : </th>    
		<td class="text-left"> <?= $row['age']; ?> </td>     
	</tr>					
</table>
table [edit]
<?php 
  	$id= $_GET['id']; 
	$conn=connectDB();
	$sql="select*from child where id=$id";
	$result=mysqli_query($conn,$sql);	
  	$row=mysqli_fetch_assoc($result);  
?>
  <h2>Edit Student</h2>

  <form action="update.php?id=<?php echo $id ?>" method="POST">

    	<div class="form-group">
      	<label for="name">Name: </label>
      	<input type="text" class="form-control" name="" placeholder="" value="<?= $row['name']; ?>" >
    	</div>

    	<div class="form-group">
      	<label>Roll: </label>
      	<input type="text" class="form-control" name="" placeholder="" value="<?= $row['roll']; ?>">
    	</div>

    	<div class="form-group">
      	<label>Age: </label>
      	<input type="text" class="form-control" name="" placeholder="" value="<?= $row['age']; ?>">
    	</div>
    
    	<button type="submit" class="btn btn-primary">Submit</button>
</form>
auth
laravel: 5.9 last
php artisan make:auth

laravel: 6.0 
composer require laravel/ui
php artisan ui vue --auth

laravel: 7.0
composer require laravel/ui:^2.4
php artisan ui vue --auth

laravel: 9
composer require laravel/ui
php artisan ui bootstrap
php artisan ui bootstrap --auth
database & backend code
1) create only database name in phpmysql
2) In project select [.env] see line no 9-14
	change it 
	DB_DATABASE=DB Name
	DB_USERNAME=root
	DB_PASSWORD=
3) Restart [php artisan serve] Off (Ctrl+C) then On
1st time Go
app/Providers/AppServiceProvider
write:  use IlluminateSupportFacadesSchema;  [line 6]
	   Schema::defaultStringLength(191); [function booth line 26]

php artisan migrate
php artisan migrate:status	[see create database]
php artisan migrate:rollback [remove data from database]
php artisan migrate:refresh or fresh  [remove data then create database]
1071 laravel error
edit your AppServiceProvider.php file and
 inside the boot method set a default string length:

use IlluminateSupportFacadesSchema;
public function boot()
{
    Schema::defaultStringLength(191);
}

app/Providers/AppServiceProvider
write:  use IlluminateSupportFacadesSchema;  [line 6]
	   Schema::defaultStringLength(191); [function booth line 26]
Session
Controller:
      return back()->with('status', 'Product insert successfully');

page.blade.php:

	@if (session('status'))
        	<div class="alert alert-success" role="alert">
                	{{ session('status') }}
                 </div>
        @endif
all in one
create model
$php artisan make:model Model_name -m

migrate
$ php artisan migrate

create controller
$ php artisan make:controller Controller_name

model, controler, migration all

$php artisan make:model Category -mc

Output all and also controller seen like CategoryController
but we put only Category
Laravel timeZone
https://carbon.nesbot.com/docs/
//All time zone set  [go config/app.config/line no 70]
'timezone' => 'UTC',  
to 
'timezone' => 'Asia/Dhaka', 

php artisan config:clear

Controller: 
Carbon::now('Asia/Dhaka')

Blade:
{{ $category->created_at->diffForHumans() }}
Laravel latest value show
@php
	$menus=App\Category::latest()->take(5)->get();
@endphp

@foreach ($menus as $menu)
	{{$menu->category_name}}	
@endforeach

Output: Now show the latest five(5) category name
view() redirect() back() with()
suppose your page location: 'contact' page
blog
---->views
	----->layouts
			--->home
			--->about
			--->contact
My present location 'contact' page and a action page working now
1) return view('layouts/contact', compact('something'));
	N:B: session   with()  not allow

2) return redirect(contact)->with('status', 'message allow');
	N:B: session with() allow

3) return back()->with('status', 'message allow');
	N:B: session with() allow


Session:

withStatus('Message send successfully!);

same meaning but 'status' should capital letter


@if (session('status'))
       <div class="alert alert-success" role="alert">
              {{ session('status') }}
       </div>
@endif
Laravel Mail
link: https://www.youtube.com/watch?v=iQoRh_9LkjU

video :9  duration: 33:55

https://laravel.com/docs/5.8/mail

#Driver Prerequisites
composer require guzzlehttp/guzzle

#generating-mailables
php artisan make:mail OrderShipped

N:B: Sometime it don't work when compact send the variable file.
So it is better to follow video link
error reporting
@php
	error_reporting(0);
@endphp
laravel github project run
Hello friends... Today I am going to show how to run github laravel projects.
link: https://www.youtube.com/watch?v=ngzOHoyITfM

1. download the laravel project from github.
2. copy that project in hotdocs folder and open the folder location in cmd.
3. now first rename the "env.example file to.env"
4. you can configure the database information here.
5. now open cmd and run some commands...
  composer install or php composer.phar install
  php artisan key:generate
  php artisan migrate
  php artisan db:seed to run seeders, if any.
  php artisan serve

that's all.. 
Problems discussion::
you may have the problem with the composer or the php...
check all are installed.. and the paths are added as the environment variable...
These two paths have to be added to run laravel project...
1. C:ProgramDataComposerSetupin
2. C:xamppphp 

if these are not added.. then add them 
.. thank you very much for watching... Please subscribe and share...:)
Categ
image upload
[video 6 [00.20.00]]
http://image.intervention.io/getting_started/installation
1st step: 
$composer require intervention/image

2nd step:
go-> config/app.php

search-> $providers [array]

paste: Intervention\Image\ImageServiceProvider::class,


search-> $aliases [array]
'Image' => Intervention\Image\Facades\Image::class,

3rd step:
use Image;

function insert_product(Request $request) {

//this part not need for image upload...
	$last_inserted_id = Product::insertGetId([
        	 'category_id'=>$request->category_id,
         	'name'=>$request->name
]);
      if ($request->hasFile('product_image')) {  //please link image upper... use Image;
            $photo_to_upload=$request->product_image;
            $fileName=$last_inserted_id.".".$photo_to_upload->getClientOriginalExtension();
            Image::make($photo_to_upload)->resize(400,380)
->save(base_path('public/Full_Project/images/product_images/'.$fileName));  
            //Image quality   save(ba
laravel project upload
https://www.youtube.com/watch?v=e7eSJCevo4c
Simple Laravel Layouts
https://scotch.io/tutorials/simple-laravel-layouts-using-blade
Laravel Calculate Age
<td>
       {{ $SingerList->DOB}} <br>
       {{\Carbon\Carbon::parse($SingerList->DOB)
	->diff(\Carbon\Carbon::now())
	->format('%y years, %m months and %d days')}}
</td>

Example:
Input: 1994-08-06

Output: 
1994-08-06 
25 years, 5 months and 16 days
Laravel pagination
Note : GET method
1) blade.php
   <form action="{{ url('all_singerName')}}" method="get">
      <input type="text" name="singerName" value="{{ old('singerName')}}" class="form-control" placeholder="Name">        
      <button class="btn btn-success btn-block" type="submit">Add Now</button>         
   </form>

2) web.php
   Route::get('all_singerName', 'Singer@all_singerName');

3)
   public function all_singerName(Request $request){
      $email = Auth::user()->email;

      $singerName = $request->singerName;

      {{-- 1st way input --}}
      $all_songs = AllSong::where('email', $email)->where('singerName', $singerName)->paginate(5);

      {{-- 2nd way input --}}
      $all_songs = AllSong::where('email', 'Like', '%'.$email.'%')->where('singerName', 'Like', '%'.$singerName.'%')->paginate(5);
      $all_songs->appends($request->only('singerName')); //get request

      return view('singerName', compact('all_songs'));
   }

4) Output 

   <div class="card-body">
      <table class="table">
            <tr class="text-center">
               <th>Sl. No</th>
               <th>Song name</th>                                             
            </tr>
         </thead>
         <tbody>
         
            @forelse($all_songs as $all_song)
               <tr class="text-center">
                  <td>{{$loop->index + $all_songs->firstItem()}}</td>
                  <td>{{ $all_song->songName}}</td> 
               </tr>
            @empty
               <tr class="text-center text-danger">
                  <td colspan="2">No data found...</td>
               </tr>
            @endforelse
         </tbody>
      </table>

      {{-- 1st way input --}}
      {{$all_songs->appends($_GET)->links()}}

      {{-- 2nd way input --}}
      {{$all_songs->links()}} 
      Or
      {{$all_songs->appends($_GET)->links()}}
   </div>
email (smtp)
MAIL_DRIVER=smtp
MAIL_HOST=smtp.gmail.com
MAIL_PORT=587
MAIL_USERNAME=aslamhossainctg@gmail.com
MAIL_PASSWORD=swnwfctznnjruscc
MAIL_ENCRYPTION=tls
laravel date
<td>
      {{ $category->created_at->format('d-M-Y  h:i:s A')}}
      {{ date('Y-m-d  h:i A', strtotime($category->created_at)) }}
      <br>
      {{ $category->created_at->diffForHumans()}}
</td>

date age

{{\Carbon\Carbon::parse($SingerList->DOB)->diff(\Carbon\Carbon::now())->format(' %y years ')}} 

{{ \Carbon\Carbon::parse($Song->created_at)->diffForHumans() }}
last five years
@foreach(range(date('Y')-5, date('Y')) as $y)
      {{$y}}
@endforeach 

output: 
2015 	2016	2017 	2018	 2019	 2020
.env.example to .env
https://www.youtube.com/watch?v=xBFPGTle7nU

cmd

C:\Users\Aslam>cd C:\xampp\htdocs\folderName

dir

ren .env.example .env
Tinker
https://artisansweb.net/use-laravel-tinker/

composer require laravel/tinker
php artisan make:model Product
php artisan tinker

$p = new App\Product;
$p->name = 'Test Product';
$p->description = 'Test Product Body';
$p->password = Hash::make(12345678)
$p->save();

Output:
$a = new App\user;
$a = \App\user::first();
=> App\User {
     id: 1,
     name: "aslam2",
     email: "admin@admin.com",
     email_verified_at: null,
     created_at: "2020-07-15 15:47:09",
     updated_at: "2020-07-15 15:47:09",
   }
date & time
date_default_timezone_set("Asia/Dhaka");
$today= date("Y-m-d-D");

$lastDay = 
date ("Y-m-d", strtotime("-1 day", strtotime($today))); 
$lastMonth = 
date ("Y-m-d", strtotime("-1 month", strtotime($today))); 
$NextYear = 
date ("Y-m-d", strtotime("1 year", strtotime($today))); 

$todayday = date('l', strtotime($today));
small [L]
Ex: saturday, sunday etc...

$day = date('d', strtotime($lastMonth));
$month = date('m', strtotime($lastMonth));
$year = date('Y', strtotime($lastMonth));

Time	
//Example Y-m-d H:i:s date string.
$date = '2019-02-15 16:56:01';
 
//12 hour format with lowercase AM/PM
echo date("g:ia", strtotime($date))
echo date("h:ia", strtotime($date))
Ex: g= 05=5 without zero
	h=05=05 full
a= small am/pm  A=capital AM/PM

 $total=strtotime($end_time) - strtotime(date("H:i:s"));
   $minute=$total/60;
   $total=$minute/60;

Different two date
$startdate->diff($endDate)->format('%y years, %m months and %d days')
db connection
input 1: $conn
<?php
	function connectDB() {
	$conn =mysqli_connect('localhost','root','','bazar');
	return $conn;
	}
?> NB: server, user name, pass, db name

Call this function
<?php  $code = conn() ;?>

input 2: $result
<?php
	$conn=connectDB();
	$sql="select*from userinfo";
	$result=mysqli_query($conn,$sql);
	return $result;
?>
session
session_start();
 $_SESSION['adminLogin']=true; 
 $_SESSION['login']=$admin;
unset($_SESSION['id_pass_fail']);

/*logout*/
session_start();
session_destroy();

<?php $_SESSION['successfully']=true; ?>

<?php if(isset($_SESSION['successfully'])) { ?>
    <?php 
        if (isset($_GET['type'])) {
            $code_type =  $_GET['type'];
        }
        echo '<script type="text/javascript">
                alert("Hellow [  '.$code_type.'  ] code insert successfully.");
                </script>';
    ?>
<?php } ?>
include
<?php  include('connection.php'); ?>
header
<?php header("Location: index.php?id=$id"); ?>

<a href="index.php?id=$id"></a>

 echo "<script>window.location.href='index.php?id=$id'</script>";

$id= $_GET['id'];
isset
session_start();
if(!isset($_SESSION['login'])){
    header("location: index.php");
}
if(isset($_SESSION['login'])){
    header("location: about.php");
}
login, logout
(1st page) ex: login.php
up page:  <?php session_start(); ?>
..............
..............
(2nd page) ex: confirmLogin.php
$email=$_POST['email'];
$pass=$_POST['password'];

$sql="select * from admin where email='$email' AND password='$pass'";
$rowcount=mysqli_num_rows($result);

if($rowcount==1) {
	$_SESSION['login']=true;	
	header("Location: index.php");
} else {
......................
......................

(3rd page) ex: index.php

up page:  <?php session_start(); 
if(!isset($_SESSION['login'])){
header("Location: login.php");
}

(4th page) ex:logout.php
<?php 
session_start();
session_destroy();
header("Location: login.php");

description limitation
<a href="view.php" class="btn btn-default">
<?= substr($row['description'], 0, 80) . '...' ?>
</a>
confirm password
(2nd page )
<?php
$name=$_POST['name'];
$pass=$_POST['pass'];
$conPass=$_Post['con_pass'];

	if($pass !=$conPass) {
	session_start();
	$_SESSION['error_msg']="password and confirm Password don't match";
	heade("Location: registration.php");
?>
	$con=.....
	$sql="insert into ....";

(1st page registration.php)
<?php if(isset($_SESSION['error_msg'])) { ?>
	<div class="alert alert-warning">
	<strong>Warning!</strong> <?php echo $_SESSION['error_msg']; ?>
	</div>
<?php } ?>
root path
<?php
	$url='http://localhost/class/blog/admin/';
?>

<a href="<?php echo $url; ?> post/index.php"> Post </a>
image upload
image is (varchar(150))
(1st page)
<form action="store.php" enctype="multipart/form-data" method="POST">
	<label	for="image">Image</lable>
	<input	type="file" name="president_photo">	
</form>

(2nd)
N:B: "upload" folder will be root position
$president_photo='profile_picture/'. $_FILES['president_photo']['name'];
move_uploaded_file($_FILES['president_photo']['tmp_name'],$president_photo);
$sql= "insert.... (null, $president_photo);

(3rd index.php)
image show when click the "view" button

<img src="<?php echo $row['image']; ?>" width='100'>
	
(4th) click 'delete' button

$id=$_GET['id'];
$sql="select*from posts where id=$id'";
$data=mysqli_fetch_assoc($reslt);
$image_location='$data['image'];

if(file_exists($image_location)){
unlink($image_location);=> for image delete code(unlink)
}

$sql="delete*from posts where id=$id'";
$result;
header ('Location: index.php');

if(file_exists($image_location)){
	echo "File have";
}else{
echo "don't have";
}
calculating Age
$_age = floor((time() - strtotime('1986-09-16')) / 31556926);

31556926 is the number of seconds in a year.

[365*24*60*60]
random number
use Illuminate\Support\Str;
 echo Str::random(10);

echo time()."<br>";
echo microtime(true)."<br>";
echo uniqid()."<br>";
echo rand()."<br>";
echo rand(2,50)."<br>";

$uniqid = uniqid();
$rand_start = rand(1,5);
$rand_8_char = substr($uniqid,$rand_start,8);

echo '<script type="text/javascript">
	alert("See Logic: Result will be 8 digit:
Full: '.$uniqid.'
Distance:  '.$rand_start.'
Result:   '.$rand_8_char.'");
		      </script>';
replace
$search = array("_", "-", "A");
$replace  = array("/", "_", "a");
$target='A_s-lAm';
$result=str_replace($search, $replace, $dob.$today);

echo $result;
input		A_s-lAm
Output		a/slam
time
Time to time minus or plus

$total=strtotime("12:10") - strtotime("12:00");
Ans: 600

only time: 
$total=strtotime("10:10");
ans: 1564373400
because it convert to year from now then convert to second

So u should convert it...
$total=strtotime("10:10") - strtotime("09:00");
ans:4200

$total=strtotime("10:10") - strtotime("00:00");
ans:36600 [10h*60m + 10=610m*60s=36600s]






php page code
// Only page name
//Smart way
echo basename($_SERVER['PHP_SELF']);
Output: page.php

// Old way
$folder = "/job/";
$link = $_SERVER['PHP_SELF']; 
Output:  /job/page.php
$page = str_replace($folder, "", $link);
Output: page.php

Suppose my server URL now....  
http://localhost/job/page.php?id=1

php code...
1) echo $_SERVER['PHP_SELF'];	
Output: /job/page.php

2) echo $_SERVER['SERVER_NAME'];	
Output: localhost

3) echo $_SERVER['REQUEST_URI'];	
Output: /job/page.php?id=1

So if i want full URL i can use
1) echo $_SERVER['SERVER_NAME'] . $_SERVER['PHP_SELF'];
Output: localhost/job/page.php

2) echo $_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'];
Output: localhost/job/page.php?id=1 

3) Full URL
$_SERVER['SCRIPT_FILENAME'];
Output: E:/laragon/www/job/page.php?id=1 

4)  After all
$from	= $_SERVER['REQUEST_URI'];
$to	= $_SERVER['PHP_SELF'];

$goTo = str_replace($from, $to, $from);

N:B: It work only project name then show URL.
So it is helpfull for redirect to final page 

Example:
from) /project/page.php
to)   /project/loginPage.php?id=2

goTo) /project/loginPage.php?id=2
How to remove -index.php- from the URL
This is the basic rule to hide index.php 
from the URL. Put this in your root .htaccess file. 
mod_rewrite must be enabled with PHP 
and this will work for the PHP version 
higher than 5.2.6.
RewriteEngine On

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ /index.php?/$1 [L]
For PHP version less than 5.2.6 try this:
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ /index.php/$1 [L]
You can also use the following code:
RewriteEngine On
RewriteCond %{THE_REQUEST} ^[A-Z]{3,9} /(.*)index.php($| |?)
RewriteRule ^ /%1 [R=301,L]
Code for Database Class (PHP-MySQLi Connection)
config.php
<?php
define("DB_HOST", "localhost");
define("DB_USER", "root");
define("DB_PASS", "");
define("DB_NAME", "your_db_name");
?>
Database Calss:
<?php
Class Database{
 public $host   = DB_HOST;
 public $user   = DB_USER;
 public $pass   = DB_PASS;
 public $dbname = DB_NAME;
 
 
 public $link;
 public $error;
 
 public function __construct(){
  $this->connectDB();
 }
 
private function connectDB(){
 $this->link = new mysqli($this->host, $this->user, $this->pass, 
  $this->dbname);
 if(!$this->link){
   $this->error ="Connection fail".$this->link->connect_error;
  return false;
 }
 }
 
// Select or Read data
public function select($query){
  $result = $this->link->query($query) or 
   die($this->link->error.__LINE__);
  if($result->num_rows > 0){
    return $result;
  } else {
    return false;
  }
 }
 
// Insert data
public function insert($query){
 $insert_row = $this->link->query($query) or 
   die($this->link->error.__LINE__);
 i
Session Class for any PHP Project
Session.php
<?php
/**
*Session Class
**/
class Session{
 public static function init(){
  if (version_compare(phpversion(), '5.4.0', '<')) {
        if (session_id() == '') {
            session_start();
        }
    } else {
        if (session_status() == PHP_SESSION_NONE) {
            session_start();
        }
    }
 }

 public static function set($key, $val){
  $_SESSION[$key] = $val;
 }

 public static function get($key){
  if (isset($_SESSION[$key])) {
   return $_SESSION[$key];
  } else {
   return false;
  }
 }

 public static function checkSession(){
  self::init();
  if (self::get("login")== false) {
   self::destroy();
   header("Location:login.php");
  }
 }

 public static function checkLogin(){
  self::init();
  if (self::get("login")== true) {
   header("Location:index.php");
  }
 }

 public static function destroy(){
  session_destroy();
  header("Location:login.php");
 }
}
?>
Use for Login Controller:
<?php
/**
* 
Use for Sample Login Page:
<?php 
 include '../lib/Session.php';
 Session::init();
?>

<?php include '../config/config.php'; ?>
<?php include '../lib/Database.php'; ?>
<!DOCTYPE html>
<head>
<meta charset="utf-8">
<title>Login</title>
<link rel="stylesheet" type="text/css" href="css/stylelogin.css"/>
</head>
<body>
<div class="container">
<section id="content">
<?php
 $db = new Database();

 if($_SERVER["REQUEST_METHOD"] == "POST"){
 $username = mysqli_real_escape_string($db->link, $username);
 $password = mysqli_real_escape_string($db->link, $password);

    $query = "SELECT * FROM user WHERE username='$username' 
     and password='$password'";
    $result = $db->select($query);
    if ($result != false) {
        $value = $result->fetch_assoc(); 
        Session::set("login", true);
        Session::set("username", $value['username']);
        Session::set("userId", $value['id']);
        header("Location: index.php");
       //echo "<script>window.location = 'index.php';</scri
if (ternary operator)
{{ ($category->menu_status == 1) ? 'Yes':'No'}}

it means

if($category->menu_status == 1){
    echo "Yes";
}else{
    echo "No";
}
DatePicker
Linl: https://gijgo.com/datepicker/example/bootstrap

<html>
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Bootstrap DatePicker</title>
    <script src="https://code.jquery.com/jquery-3.3.1.min.js"></script>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
    <script src="https://unpkg.com/gijgo@1.9.13/js/gijgo.min.js" type="text/javascript"></script>
    <link href="https://unpkg.com/gijgo@1.9.13/css/gijgo.min.css" rel="stylesheet" type="text/css" />
</head>
<body>
    <input id="datepicker" width="270" />
    <script>
        $('#datepicker').datepicker({
            uiLibrary: 'bootstrap'
        });
    </script>
</body>
</html>
datatable
Source : 
server side rendering
https://datatables.net/

head:
-----
   <link rel="stylesheet" href=" //cdn.datatables.net/1.10.20/css/jquery.dataTables.min.css">

body:
-----
   <table class="table table-bordered">
      <thead>
         <th>Sl</th>
         <th>Name</th>
         <th>age</th>
         <th>Action</th>
      </thead>
      <tbody>
         <tr>
            <td width="10">1</td>
            <td>Mr Jhon</td>
            <td>20</td>
            <td width="15">
               <div class="btn-group">
                  <a class="btn btn-sm btn-outline-info py-0 " href=" ">View</a>
                  <a class="btn btn-sm btn-outline-danger py-0 " href="">Delete</a>
               </div>
            </td>
         </tr>
         <tr>
            <td width="10">1</td>
            <td>Mr Jhon2</td>
            <td>19</td>
            <td width="15">
               <div class="btn-group">
                  <a class="btn btn-sm btn-outline-info py-0 " href=" ">View</a>
                  <a class="btn btn-sm btn-outline-danger py-0 " href="">Delete</a>
               </div>
            </td>
         </tr>
      </tbody>
   </table>

end body:
footer:
---------
   <script src="//cdn.datatables.net/1.11.4/js/jquery.dataTables.min.js"></script>

   <script type="text/javascript">
      $(document).ready( function () {
         $('.table').DataTable();
      } );

      $('.table').DataTable({
         "lengthMenu": [ [5, 10, 25, 50, -1], [5, 10, 25, 50, "All"] ]
      });
   </script>


stylesheet:
-----------
/*Datatable*/
/*header & footer*/
.dataTables_wrapper .dataTables_length, 
.dataTables_filter, 
.dataTables_info, 
.dataTables_paginate {
   background-color: paleturquoise;

}

.dataTables_wrapper .dataTables_filter, 
.dataTables_wrapper .dataTables_paginate{ 
   float: none;
}

.dataTables_wrapper .dataTables_length label, 
.dataTables_wrapper .dataTables_filter label{ 
   padding: 0.175rem 0.5rem; 
   margin-bottom: 0rem; 
}

/*header left + right*/
.dataTables_wrapper .dataTables_length select,
.dataTables_wrapper .dataTables_filter input {
   background-color: #fff; padding: 0px;
}

/*Table body*/

table.dataTable { margin: 5px 0px; border-collapse: collapse; }

.table-bordered, .table-bordered td, .table-bordered th { /*border: 1px solid #dee2e6; border: 1px dashed;*/ }

table.dataTable thead th, table.dataTable.no-footer{ border-bottom: unset; }

table.dataTable thead th, 
table.dataTable thead td { padding: 2px 20px; text-transform: capitalize; 
   background-color: turquoise; text-align: center;
}

table.dataTable tbody td { text-align: center; vertical-align: middle; padding: 2px; }
table.dataTable tbody tr { background-color: whitesmoke; }


/*Buttom*/
.dataTables_wrapper .dataTables_info { padding: 0.5rem; }
.dataTables_wrapper .dataTables_paginate { padding: 0.25em; }

.dataTables_wrapper .dataTables_paginate .paginate_button { 
   min-width: 1.5em; padding: 0.2em 0.6em; margin-left: 2px;
}

<--The end-->
datatable order by
 // datatable order by
         // https://datatables.net/reference/api/order()
<script>
         var table = $('.table').DataTable();
 
         // Sort by column 1 and then re-draw
         table
             .order( [ 0, 'desc' ] )      //[ 0, 'asc' ], [ 1, 'asc' ] ist part work properly, 
             .draw();                     // 0, 1, 2 colum number

</script>
join table
create table student_info(
	roll int NOT NULL AUTO_INCREMENT,
	name varchar(30) NOT NULL,
	gender varchar(30),
	age int,
	PRIMARY KEY (roll)
	);

create table result_info(
	reg_number int NOT NULL ,
	roll int,
	gpa double(3,2),
	group_name varchar(30),
	gender varchar(30),
	PRIMARY KEY (reg_number)
	);

Query for details=>>

select student_info.roll, reg_number, name, student_info.gender, group_name, gpa
from student_info,result_info
where student_info.roll=result_info.roll;
insert
1)	$sql="insert into child values(null,'Raiz',15)";

2) 	suppose: 4 cloumn	(id, name, age, mobile)

if u insert all

insert into child (name, age, mobile) values ('Raiz',15, 0168060)";
id: auto increment...

3) 	if insert only name, mobile 

insert into child (name, mobile) values ('Raiz' 01680607293)";
N:B: Always fill up the 2nd column.
After (id) auto increment the 2nd column(name) must be filled.  123222333111
Search string
$search = "companyLogo/companyLogo";
      $row = CompanyLogo::where('id', 1)->where('imageSource', 'LIKE', '%'.$search.'%')->first();

      if ($row && $row!=null) {
         unlink($row->imageSource);
         
         CompanyLogo::find(1)->update([
            'imageSource'=>"backend/images/companyLogo/logo.jpeg",
            'created_at' => Carbon::now()
         ]);
         return back()->with('success',' Default logo selected..');

      }
      if($row==null){
         return back()->with('success',' Default logo already selected..');
      }
htaccess make
<IfModule mod_rewrite.c>
    <IfModule mod_negotiation.c>
        Options -MultiViews
    </IfModule>

    RewriteEngine On

    RewriteCond %{REQUEST_FILENAME} -d [OR]
    RewriteCond %{REQUEST_FILENAME} -f
    RewriteRule ^ ^$1 [N]

    RewriteCond %{REQUEST_URI} (\.\w+$) [NC]
    RewriteRule ^(.*)$ public/$1 

    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteRule ^ server.php

</IfModule>
delete
<!-- Blade file -->
	<div class="btn-group" role="group" aria-label="Basic example">
	   <a class="btn" href="{{ url('softDelete', $all_Code->id)}}" onclick="return confirm('Alert message')">Soft-Delete</a>
	   <a class="btn" href="{{ url('forceDelete', $all_Code->id)}}" onclick="return confirm('Alert message')">Fource Delete</a>
	   <a class="btn" href="{{ url('restore', $all_Code->id)}}">Restore</a>
           <a class="btn" href="{{ url('trashedCode')}}">Trashed Code</a>
	</div>


<!-- web.php -->
	Route::get('softDelete/{id}', 'CodeController@softDelete')->name('softDelete');
	Route::get('forceDelete/{id}', 'CodeController@forceDelete')->name('forceDelete');
	Route::get('restore/{id}', 'CodeController@restore')->name('restore');
	Route::get('trashedCode', 'CodeController@trashedCode')->name('trashedCode');


<!-- Controller -->

	public function softDelete($id){
	   AllCode::find($id)->delete();
	   return back()->with('danger', 'Code soft delete successfully');
	}

	public function forceDelete($id){
	   AllCode::onlyTrashed()->find($id)->forceDelete();
	   return back()->with('forceDelete', 'Code permanently delete successfully');
	}

	public function restore($id){
	   AllCode::onlyTrashed()->find($id)->restore();
	   return back()->with('success', 'Code restore successfully');
	}
	public function trashedCode(){
	   $AllCodes = App\AllCode::onlyTrashed()->get();
           
           foreach($AllCodes as $all_Code){
              echo $all_Code->id;
           }
	}
composer & version
Composer
	composer
Update : composer self-update [Ex: 1.0 to 2.0]
return old : composer self-update --rollback [Ex: 2.0 to 1.0]

Laravel
	php artisan --version
        Laravel v{{ Illuminate\Foundation\Application::VERSION }} (PHP v{{ PHP_VERSION }})

php
	php -v
        php -version
        php --version
laravel collection
$LanguageKeys = App\LanguageKey::pluck('id');

$dataList  = collect($subtitleKeys)->unique()->pluck('languagekey_id');
double id pass
<a class="btn" href="{{url('/edit', [$user->id, $user->age])}}">

Route::get('edit/{id}/{age}', 'Controller@edit')->name('edit');

public function edit(Request $request){
      echo $request->id;
      echo $request->age;
}
status change
Blade :
<td>
    @if($social->status == 1)
        <a href="{{ url('change', [$social->id, $social->status])}}" class="btn">Active</a>
    @else
        <a href="{{ url('change', [$social->id, $social->status])}}" class="btn">Inactive</a>
    @endif
</td>

web.php :
Route::get('/change/{id}/{status}', 'Controller@change')->name('change');

Controller :
public function change($id, $status){

   	$socialId = SocialMedia::find($id);

      if ($status == 0) {
         $socialId->status = true;
      }
      if ($status == 1) {
         $socialId->status = false;
      }      
      $socialId->save();
      
      return back()->with('success','Social media status change');
   }

N:B: if change have 1 button
public function change($id){
    if(SocialMedia::find($id)->status==0){
         SocialMedia::find($id)->update([
             "status" => true
         ]);
   }else{
         SocialMedia::find($id)->update([
            "status" => false
         ]);
   }
}
Relationship error
ErrorException
Trying to get property 'name' of non-object 
Solve : 
{{$alluser->admin->name}}
{{$alluser->admin['name']}}
Trying to access array offset on value of type null
catch the relationship error on missing foreign key
------
public function ApproveBy(){
     return $this->belongsTo(Admin::class, 'approveBy', 'id')->withDefault();
}
------
{{ $term->ApproveBy['name']}}
Redirect to a Specific Tab in Laravel
blade:

   <header class="panel-heading panel-heading-gray custom-tab ">
      <ul class="nav nav-tabs mt-2" id="tabMenu">
         <li class="nav-item">
            <a href="#firstTab" data-toggle="tab" class="active">1st tab</a>
         </li>
         <li class="nav-item">
            <a href="#secondTab" data-toggle="tab">2nd tab</a>
         </li>                      
      </ul>
   </header>

   <div class="panel-body">
      <div class="tab-content">  
         <div class="tab-pane active" id="adminSocialMedia">
            <a href='{{ url('firstTab') }}' target="_blank">Click 1st tab</a>
         </div>
          <div class="tab-pane active" id="adminSocialMedia">
            <a href='{{ url('secondTab') }}' target="_blank">Click 2nd tab</a>
         </div>
      </div>
   </div>

Controller:
   public function secondTab(){
      return back()->with('success', 'This 2nd tab alert')
      ->withInput(['tab' => 'secondTab']);
   }

Js :
   <script>
      //redirect to specific tab
      $(document).ready(function () {
         $('#tabMenu a[href="#{{ old('tab') }}"]').tab('show')
      });
   </script>

Link: https://medium.com/@grmcameron/redirect-to-a-specific-tab-in-laravel-149398a9e655
Route hightlight [Side bar]
<li class="nav-item start {{ (request()->routeIs('socialMedia*'))  ? 'active' : '' }}">
   <a href="#" class="nav-link nav-toggle">
      <i class="far fa-share-square" aria-hidden="true"></i>
      <span class="title">Social Media</span>
      <span class="selected"></span>
      <span class="arrow open"></span>
   </a>
   <ul class="sub-menu">
      <li class="nav-item {{ (request()->routeIs('socialMedia.admin*'))  ? 'active' : '' }}">
         <a href="{{ route('socialMedia.admin') }}" class="nav-link ">
            <span class="title">Admin</span>
         </a>
      </li>
      <li class="nav-item {{ (request()->routeIs('socialMedia.owner*'))  ? 'active' : '' }}">
         <a href="{{ route('socialMedia.owner') }}" class="nav-link ">
            <span class="title">Owner</span>
         </a>
      </li>
   </ul>
</li>

Route hit [route name]
	<li class="nav-item {{ (request()->routeIs('socialMedia.admin*'))  ? 'active' : '' }}">
      <a href="{{ route('socialMedia.admin') }}" class="nav-link">
         <span class="title">Admin</span>
      </a>
   </li>

	Route::get('/social-media/admin','Admin\SocialMediaController@admin')->name('socialMedia.admin');


url hit [route url]
   <a class="btn btn-primary" href='{{ url('social-media/admin') }}'>Admin Social Link</a>

   Route::get('/social-media/admin','Admin\SocialMediaController@admin')->name('socialMedia.admin');
Clear
Route::get('/clear', function() {
   Artisan::call('cache:clear');
   Artisan::call('config:clear');
   Artisan::call('config:cache');
   Artisan::call('view:clear');
   Artisan::call('route:clear');   
   
   return "Cleared!";
});

php artisan optimize
migrate
migrate                                                                                                                            
      migrate:fresh                                                                                                                      
      migrate:install                                                                                                                    
      migrate:refresh                                                                                                                    
      migrate:reset                                                                                                                      
      migrate:rollback                                                                                                                   
      migrate:status 

Rollback[Drop] Last table
N:B: Migrate table's "batch" colum's value will be big
php artisan migrate:rollback
then
php artisan migrate

[Special]
if batch serial no :: 2,2,2,2
if i want rollback last one by primary key
php artisan migrate:rollback --step=1
output : 2,2,2
if i want rollback last two by primary key
php artisan migrate:rollback --step=2
output : 2
then migrate

Warning for below
Be careful! This command will drop all data from your DB:

Rollback[Drop] all table
php artisan migrate:reset

Rollback[Drop] & migrate all table
php artisan migrate:fresh
or
php artisan migrate:refresh
google map api key
https://www.youtube.com/watch?v=OGTG1l7yin4&ab_channel=ImranEmu

1. Firstly Go to Google Maps - https://console.cloud.google.com/​
2. Sign In with your Google account and agree with the terms and conditions
3. Create a project and name it as you want
4. Select the project and click on it
5. Navigate to APIs and Services and  click on Libraries
6. Enable the following Libraries one by one 
   1. Google Javascript API 
   2. Google Place API 
   3. Google Direction  API 
   4. Google Geolocation API 
   5. Google Geocoding  API
7. Navigate to APIs and Services and  click on Credentials 
8. Click on Create Credentials and then the API key and it will show up a screen with API Key
9. Now you can optionally restrict the API key.


https://developers.google.com/maps/documentation/javascript/overview#Inline

<script async
    src="https://maps.googleapis.com/maps/api/js?key=YOUR_API_KEY&callback=initMap">
</script>

if my key abc123
AIzaSyD6V8wBnr9Yb_kcXWFpTsT68okra7TxPCw

<script async
    src="https://maps.googleapis.com/maps/api/js?key=abc123&callback=loadMap">
</script>
route vs url
<li class="nav-item start {{ (request()->routeIs('socialMedia*'))  ? 'active' : '' }}">
   <a href="#" class="nav-link nav-toggle">
      <i class="far fa-share-square" aria-hidden="true"></i>
      <span class="title">Social Media</span>
      <span class="selected"></span>
      <span class="arrow open"></span>
   </a>
   <ul class="sub-menu">
      <li class="nav-item {{ (request()->routeIs('socialMedia.admin*'))  ? 'active' : '' }}">
         <a href="{{ route('socialMedia.admin') }}" class="nav-link ">
            <span class="title">Admin</span>
         </a>
      </li>
      <li class="nav-item {{ (request()->routeIs('socialMedia.owner*'))  ? 'active' : '' }}">
         <a href="{{ route('socialMedia.owner') }}" class="nav-link ">
            <span class="title">Owner</span>
         </a>
      </li>
   </ul>
</li>

Route hit [route name]
	<li class="nav-item {{ (request()->routeIs('socialMedia.admin*'))  ? 'active' : '' }}">
      <a href="{{ route('socialMedia.admin') }}" class="nav-link">
         <span class="title">Admin</span>
      </a>
   </li>

	Route::get('/social-media/admin','Admin\SocialMediaController@admin')->name('socialMedia.admin');


url hit [route url]
   <a class="btn btn-primary" href='{{ url('social-media/admin') }}'>Admin Social Link</a>

   Route::get('/social-media/admin','Admin\SocialMediaController@admin')->name('socialMedia.admin');
value to ignore
unique:users,username,id,1 // table, field, idcolumn, value to ignore
Ternary Operator
<a href="{{ url('owner/mealStatus', [$meal->id, 'breakfast'])}}"

Route::get('/mealStatus/{id}/{tab}','Owner\MealController@mealStatus')->name('owner.mealStatus');        

public function mealStatus($id, $tab){
      $mealId = Meal::find($id);
      ($mealId->status == true) ? $mealId->status = false : $mealId->status = true;     
      $mealId->save();  
      return back()->with('success','Meal status change')->withInput(['tab' => $tab]);
   }
laravel column
if (Schema::hasTable('users')) {
    // The "users" table exists...
}

if (Schema::hasColumn('users', 'email')) {
    // The "users" table exists and has an "email" column...
}
Order By Action
Sql table's[skill] column name : orderBy

Controller::
$data['Skill'] = Skill::orderBy('orderBy')->get();
return view('backend.pages.skills', $data);

Blade.php
@foreach($Skill as $item)
   <tr>
      <td width="8%">
         <div class="btn-group">
            <button type="button" class="btn dropdown-toggle" data-toggle="dropdown">
               <i class="far fa-check-circle"></i>
               {{$item->orderBy}}
            </button>
            <div class="dropdown-menu" style="min-width: 4rem; background-color: thistle;">
               @for($i=1; $i <= $Skill->count(); $i++)                                          
                  <a href="{{ url('orderBy', ['skills', $item->id, $i, 'tabName'])}}"
                     class="{{$i==$item->orderBy ? 'bg-info disabled pl-2' : 'text-center'}} dropdown-item">
                     @if($i==$item->orderBy)
                        <i class="far fa-check-circle"></i>
                     @endif
                     {{$i}}
                  </a>
               @endfor
            </div>
         </div>
      </td>
   </tr>
@endforeach

// Web.php   
Route::get('orderBy/{model}/{id}/{targetId}/{tab}','BackendController@orderBy')->name('orderBy');

// Controller
public function orderBy($model, $id, $targetId, $tab){
   DB::table($model)->where('id', $id)->update(['orderBy' => $targetId]);
   return back()->with('success', $model.' orderBy change')->withInput(['tab' => $tab]);
}
Return back
header("Location: home.php");
header('Location: ' . $_SERVER['HTTP_REFERER']);
Php faker
Base
   randomNumber // 79907610
   randomFloat // 48.8932
   randomLetter // 'b'

Lorem
   word // 'aut'
   sentence // 'Sit vitae voluptas sint non voluptates.'
   paragraph // 'Ut ab voluptas sed a nam. Sint autem inventore aut officia aut aut blanditiis.'
   text //($maxNbChars = 200) // 'Fuga totam reiciendis qui architecto fugiat nemo.'
   realText //Meaning full sentence...
   
Person                                       // 'Jr.'
   name($gender = null|'male'|'female')      // 'Dr. Zane Stroman'
   ssn                                       // '123-45-6789' [Social Security Number]
   
Address
   city                                // 'West Judge' //A city is a large and permanent settlement //Smaller than a state
   state                               // 'NewMexico' //A state is a larger area, which is often governed by its own government. 
                                       //Larger than a city
   postcode                            // '17916'
   address                             // '8888 Cummings Vista Apt. 101, Susanbury, NY 95473'
   country                             // 'Falkland Islands (Malvinas)'
   latitude($min = -90, $max = 90)     // 77.147489
   longitude($min = -180, $max = 180)  // 86.211205

PhoneNumber   
   phoneNumber             // '201-886-0269 x3767'
   
Company
   company                 // 'Bogan-Treutel'
   jobTitle                // 'Cashier'

DateTime
   unixTime($max = 'now')                // 58781813
   date($format = 'Y-m-d', $max = 'now') // '1979-06-09'
   time($format = 'H:i:s', $max = 'now') // '20:49:42'
   amPm($max = 'now')                    // 'pm'
   dayOfWeek($max = 'now')               // 'Friday'
   monthName($max = 'now')               // 'January'
   year($max = 'now')                    // '1993'   
   timezone                              // 'Europe/Paris'

Internet
   email                   // 'tkshlerin@collins.com'
   userName                // 'wade55'
   password                // 'k&|X+a45*2['
   url                     // 'http://www.skilesdonnelly.biz/aut-accusantium-ut-architecto-sit-et.html'
   slug                    // 'aut-repellat-commodi-vel-itaque-nihil-id-saepe-nostrum'
   macAddress              // '43:85:B7:08:10:CA'

Payment
   creditCardType          // 'MasterCard'
   creditCardNumber        // '4485480221084675'
   bankAccountNumber       // "SA0218IBYZVZJSEC8536V4XC"
   creditCardExpirationDateString // '04/13'
   iban($countryCode)      // 'IT31A8497112740YZ575DJ28BP4'
   swiftBicNumber          // 'RZTIAT22263'

Color
   hexcolor               // '#fa3cc2'
   rgbcolor               // '0,255,122'
   rgbCssColor            // 'rgb(0,255,122)'
   safeColorName          // 'yellow'
   colorName              // 'SkyBlue'
   
File
   fileExtension          // 'avi/jap/png'

Image
   imageUrl($width = 640, $height = 480) // 'http://lorempixel.com/640/480/'
   image($dir = '/tmp', $width = 640, $height = 480) // '/tmp/13b73edae8443990be1aa8f1a483bc27.jpg'
   
   uuid                    // '7e57d004-2b97-0e7a-b45f-5387367791cd'
                           [Universally unique identifier]

Barcode
   ean13          // '4006381333931' //International Article Number(ean)
   ean8           // '73513537'
   isbn13         // '9790404436093' //International Standard Book Number(isbn)
   isbn10         // '4881416324'

Miscellaneous
   boolean // false/true
   md5           // 'de99a620c50f2990e87144735cd357e7'
   sha1          // 'f08e7f04ca1a413807ebc47551a40a20a0b4de5c'
   sha256        // '0061e4c60dac5c1d82db0135a42e00c89ae3a333e7c26485321f24348c7e98a5'
   locale        // en_UK
   countryCode   // UK
   languageCode  // en
   currencyCode  // EUR
   emoji         // 😁

HtmlLorem
   randomHtml    // <html><head><title><table>any code</table></body></html>
--------------
   total : 63
auth 6
composer create-project laravel/laravel name
composer require laravel/ui
php artisan ui vue --auth
npm install && npm run dev


laravel 6

composer create-project --prefer-dist laravel/laravel blog "6.*"
composer require laravel/ui "^1.0" --dev
php artisan ui vue --auth
npm install && npm run dev
auto refresh
Database :
----------
   CREATE TABLE `refresh_status` (
     `id` bigint(20) NOT NULL AUTO_INCREMENT,
     `time` bigint(20) NOT NULL DEFAULT '5' COMMENT 'Second',
     `status` tinyint(4) NOT NULL COMMENT '0=hide, 1=show',
    PRIMARY KEY (`id`)
   );
   INSERT INTO `refresh_status` (`id`, `time`, `status`) VALUES (1, 5, 1);

==============
head.blade.php
--------------
    <head>
      @php 
         $time = DB::table('refresh_status')->where('status', true)->first();
      @endphp               
      <meta http-equiv="refresh" content="{{ ($time==true)? $time->time:''}}">
   </head>

----------------
header.blade.php
----------------
   <ul class="navbar-nav m-auto">         
      <li class="nav-item pl-2" style="margin-top: -6.5px;">
         
         <small class="title">Refresh Status</small>         
         @php 
            $status = DB::table('refresh_status')->first();
         @endphp
         
         <!-- 1st style -->
         <a style="line-height: 18px; display: block;" href="{{ url('refreshStatus', 'status') }}"
            class="btn btn-sm py-0 {{($status->status==true) ? 'btn-success':'btn-danger'}}" title="Click for {{($status->status==true) ? 'Off':'On'}}">{{($status->status==true) ? 'On':'Off'}}
         </a> 

         <!-- 2nd style -->
         <div style="display: flex;" class="btn-group">
            <a class="p-0 btn btn-sm btn-danger" href="{{ url('refreshStatus', 'decrease') }}" title="Click for {{($status->status==true) ? 'decrease[-]':''}}" {{($status->status==true) ? '':'hidden'}} {{($status->time==0) ? 'hidden':''}} {{$status->time}}>−</a>
            <a class="p-0 btn btn-sm {{($status->status==true) ? 'btn-secondary':'btn-danger'}}" href="{{ url('refreshStatus', 'status') }}" title="Click for {{($status->status==true) ? 'Off':'On'}}" style="line-height: {{($status->status==true) ? 'normal':'18px'}};">{{($status->status==true) ? 'On ['.$status->time.'”]':'Off'}}</a>
            <a class="p-0 btn btn-sm btn-success" href="{{ url('refreshStatus', 'increase') }}" title="Click for {{($status->status==true) ? 'increase[+]':''}}" {{($status->status==true) ? '':'hidden'}}>+</a>
         </div>
      </li>
   </ul>

=======
web.php
-------
   // Page refresh status
   Route::get('/refreshStatus/{value}', 'HomeController@refreshStatus')->name('refreshStatus');

==================
HomeController.php
------------------
use DB;
class HomeController extends Controller {

   public function refreshStatus($value){
      $dbInfo = DB::table('refresh_status')->first();
      if ($value=='status'){
         $refreshStatus = $dbInfo->status;
         ($refreshStatus==1) ? $changeValue=false : $changeValue=true;         
         $field = 'status';

      }elseif($value=='decrease' || $value=='increase'){
         $time = $dbInfo->time;         
         ($value=='decrease') ? $changeValue=$time-1 : $changeValue=$time+1;        
         $field = 'time';
      }      
      DB::table('refresh_status')->update([$field => $changeValue]);
      return back();
   }
}
<-------The End-------->
seeder
php artisan make:seeder UserSeeder
---
UserSeeder:
   
   public function run(){
      DB::table('user')->insert([
         'name' => 'Aslam',
         'email' => 'aslam@email.com',
         'email_verified_at' => now(),
         'password' => '12345678', // password
         'remember_token' => '123321',
      ]);  
   }
}
---
DatabaseSeeder:

   public function run(){      
      $this->call([
         UserSeeder::class,
         AdminSeeder::class,
         ClientSeeder::class,
      ]);
   }

php artisan db:seed
or
php artisan migrate:refresh --seed

If use laravel faker

UserSeeder:
   use Faker\Factory as Faker;
   
   public function run(){
      $faker = Faker::create();
      foreach (range(1, 5) as $value) {
         
         DB::table('users')->insert([
            'name' => $faker->name,
            'email' => $faker->email,
            'email_verified_at' => now(),
            'password' => Hash::make('123456'), // password
            'remember_token' => '123321',
         ]);

         NB: also use another DB;
      }
   }
}
get previous array values in foreach
$arr = array('January', 'February', 'July', 'August', 'March', 'April', 'May', 'June', 'September', 'October', 'November', 'December');
  
      $arr2 = $arr;
      $loop=1;

      foreach ($arr as $k => $currVal) {
         unset($arr2[$k]);
         foreach ($arr2 as $k => $v) {
            $nextVal = $v;
            break;
         }
         echo $loop.") "."Current=>".$currVal;
         echo "<-->";
         echo "Next=>".$nextVal."<br>";
         $loop++;
      }
Link: https://stackoverflow.com/questions/4148501/get-previous-array-values-in-foreach
Dynamic route & controller
Blade.php
=========
<?php $array = array('country','city', 'area'); ?>
   @foreach($array as $key => $country)
      <form action="{{url($country)}}" method="post">
         @csrf
         <button type="submit" class="mt-2 btn btn-success">{{$country}}</button>
      </form>
   @endforeach

web.php
=======
$pages = ltrim(\Request::getRequestUri(), '/');
Route::post($pages, [CountryController::class, 'itrerate'])->name($pages);

CountryController.php
=====================
public function itrerate(Request $request){
   echo $request->route()->uri;
   echo 'Anything';
}
Dynamic arrayList
1) One-dimensional array
========================
    Input
    -----
    $array = array('country', 'city', 'area');
    or
    $array = ['country', 'city', 'area'];

    Output
    ------
    @foreach($array as $k => $country)
    {{$country}}
    @endforeach

    // Smart way to call array
    Controller.php
    ==============
    $data['trees'] = Tree::all();

    Blade.php
    =========
    //array_column() expects at least 2 parameters

    $array = array_column($trees->toArray(), 'name_column');
    @foreach($array as $k => $country)
    {{$country}}
    @endforeach

*********************************************

2) Two-dimensional array
========================
    Input
    -----
    @php
        $teams = [
            [
                'name' => 'Abc',
                'age' => 12
            ],
            [
                'name' => 'Abc2',
                'age' => 15
            ]
        ];
    @endphp

    Output
    ------
    @foreach ($teams as $team)
        {{$team['name']}}
        {{$team['age']}}
    @endforeach

array:3 [▼
  "base" => "EUR"
  "date" => "2023-01-19"
  "rates" => array:168 [▼
    "AED" => 4.147043
    "AFN" => 118.466773
    "ALL" => 120.73174
];
or

$lists =
                [
                    [1, 'private', 'withdraw', '0.003'],
                    [2, 'private', 'deposit', '0.0003'],
                    [3, 'business', 'withdraw', '0.005'],
                    [4, 'business', 'deposit', '0.0003']
                ];

        foreach($lists as $list){
            foreach($list as $value){
                echo $value;
            }
        }
==========
 $currencyAPI = 'https://developers.paysera.com/tasks/api/currency-exchange-rates';

$data['todayCurrency'] = json_decode(file_get_contents($currencyAPI), true);
@foreach($todayCurrency['rates'] as $name => $value)
      <tr>
            <td>{{ $name }}</td>
            <td>{{ $value }}</td>
      </tr>
@endforeach

*********************************************

3) Three-dimensional array
==========================
    Input
    -----
    @php
        $teams = [
            'management_team' => [
                'name' => 'Management Team',
                'data' => [
                    [
                        'name' => 'Abc',
                        'age' => 15
                    ],
                    [
                        'name' => 'Abc2',
                        'age' => 18
                    ]
                ]
            ]
        ];
    @endphp

    output
    ------
    {{$teams['management_team']['name']}} 
    @foreach ($teams['management_team']['data'] as $team) 
        {{$team['name']}}
        {{$team['designation']}}
    @endforeach  

*********************************************

4) Three-dimensional array(Multiple)
===================================
    Input
    -----
    @php
        $teams = [
            'management_team' => [
                'name' => 'Management Team',
                'data' => [
                    [
                        'name' => 'Abc',
                        'age' => 18
                    ],
                    [
                        'name' => 'Abc2',
                        'age' => 20
                    ]
                ]
            ],
            
            'management_team2' => [
                'name' => 'Management Team2',
                'data' => [
                    [
                        'name2' => 'Abc',
                        'age2' => 18
                    ],
                    [
                        'name2' => 'Abc2',
                        'age2' => 20
                    ]
                ]
            ]        
        ];
    @endphp

    output
    ------
    @foreach ($teams as $key => $team)               
        {{$team['name']}}
        @foreach ($team['data'] as $info) 

            {{$info['name']}}
            {{$info['designation']}}

        @endforeach       
    @endforeach 

=== The end ===
Laravel 404 page
1) Default:

web.php
Auth::routes();
Route::fallback(function () {
   return abort(404);
});

2) If u want register not working
web.php
//Auth::routes();
Auth::routes(['register' => false]);
Route::fallback(function () {
   return abort(404);
});

3) Coustom 404 make

Route::fallback(function () {
   return view('404');
});

views/404.blade.php
/*
<!DOCTYPE html>
<html lang="{{ str_replace('_', '-', app()->getLocale()) }}">
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>404 : Error Page</title>
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css">
</head>
<body>
    <div class="container mt-5 pt-5">
        <div class="alert alert-danger text-center">
            <h2 class="display-3">404</h2>
            <p class="display-5">Oops! Something is wrong.</p>
            <a href="https://aslambd.com" class="btn btn-primary">Return homepage</a>
        </div>
    </div>
</body>
</html>
*/
laravel error message
// App\Http\Controllers\Redirect;

use Redirect;

$validator = Validator::make($request->all(),[
   'iconName'=> 'required|unique:code_type_icons,iconName',
   'iconLink'=> 'required|unique:code_type_icons,iconLink'
]);

if($validator->fails()) {
   $messages = $validator->messages();// get the error message.       
   return Redirect::back()->withErrors($validator);
}

1st...

 @if($errors)
    @foreach ($errors->all() as $error)
        <div class="alert alert-danger text-center alert-block">
         <button type="button" class="close" data-dismiss="alert">×</button>  
         <strong>{{ $error }}</strong>
      </div>
    @endforeach
@endif

2nd...  
return back()->with('success', 'Code type add successfully');

@foreach (['success', 'danger', 'warning', 'info'] as $alert)         
   @if ($message = Session::get($alert))
      <div class="alert alert-{{$alert}} text-center alert-block">
         <button type="button" class="close" data-dismiss="alert">×</button>  
         <strong>{{ $message }}</strong>
      </div>
   @endif
@endforeach

<script type="text/javascript">
   window.setTimeout(function() {
      $(".alert").fadeTo(500, 0).slideUp(500, function(){
         $(this).remove(); 
      });
   }, 5000);
</script>

another way...

return back()->with('success', 'Code type icon add successfully');
return back()->with('danger', 'Code type icon add successfully');
return back()->with('info', 'Code type icon add successfully');

@foreach (['success', 'danger', 'warning', 'info'] as $alert)         
   @if ($message = Session::get($alert))
      <div class="alert alert-{{$alert}} text-center alert-block">
         <button type="button" class="close" data-dismiss="alert">×</button>  
         <strong>{{ $message }}</strong>
      </div>
   @endif
@endforeach

<script type="text/javascript">
   window.setTimeout(function() {
      $(".alert").fadeTo(500, 0).slideUp(500, function(){
         $(this).remove(); 
      });
   }, 5000);
</script>


<style type="text/css">
   .alert { 
      margin-top: 0px; 
      position: absolute; 
      right: 0px; 
      z-index: 1; 
      color: white;
   }
   .close { color: #000 !important; margin: 0 -8px 0px 10px; line-height: 20px; }
   ul li { list-style: none; margin-top: 20px; }
   .close:hover { color: black; }
</style>
laravel switch
@php
   $languageId = session()->get('languageId');
   $id=$languageId;
   switch ($languageId) {
       case $id:
         $Language = App\Language::find($id);
         echo $Language->name;
           break;
       default:
           echo "321";
   }
@endphp
migration last one
in db
migration batch id inclise  [1->2]
php artisan migrate:rollback
php artisan migrate
unick number find
$uniqueNumberFound = false;
		while (!$uniqueNumberFound){

    		$employee_id=rand(1, 5);
    		$sql3="SELECT * FROM employee where employee_id='$employee_id'";
			$rowcount=mysqli_query($hrm, $sql3);
			$num= mysqli_num_rows($rowcount); 
			   if ($num==0){  
			      $uniqueNumberFound = true;  
			   }
		}
		echo $employee_id; 
 	?>  
unique validation
$validated = $request->validate([     
    'codeType' => 'required|unique:code_types,codeType,userId'.\Auth::user()->id,
 ]);   

or


$id = $request->id;
$validator = Validator::make($request->all(),[
       'field'=>"required|unique:table,colum,$id"
]);
Laravel sql query
Add new column
public function new(){
      $table  = 'members';
      $column = 'abc';
      DB::select("ALTER TABLE $table ADD $column VARCHAR(255)");
      DB::statement("ALTER TABLE $table ADD $column VARCHAR(255)");
      return view('admin.member.registration');
}
link::https://blog.quickadminpanel.com/5-ways-to-use-raw-database-queries-in-laravel/
SoftDeletes Model
namespace App\Models;
use Illuminate\Database\Eloquent\Model;

class Notice extends Model{
   use SoftDeletes;
   protected $guarded = [];
}
Seed sql file
1st:
php artisan make:seeder SqlFileSeeder
----------

2nd:
put the sql file here
database\test.sql
----------

3rd:
database\seeds\SqlFileSeeder.php;
<?php
use Illuminate\Database\Seeder;
class SqlFileSeeder extends Seeder {   
   public function run(){
      $path = 'database\test.sql'; 
      $sql = file_get_contents($path);
      DB::unprepared($sql);
   }
}
----------

4th:
database\seeds\DatabaseSeeder.php

<?php
use Illuminate\Database\Seeder;
class DatabaseSeeder extends Seeder {
    public function run() {
        $this->call(SqlFileSeeder::class);
    }
}

----------
3rd + 4th: Shortcuts way
database\seeds\DatabaseSeeder.php
use DB;
class DatabaseSeeder extends Seeder {    
    public function run(){
        $path = 'database\test.sql';
        $sql = file_get_contents($path);
        DB::unprepared($sql);
    }
}
----------
5th:
php artisan db:seed
php artisan db:seed --class=SqlFileSeeder
----------

6th:
Delete full db's table from phpmysql
php artisan db:wipe
==========

Link::
https://www.nicesnippets.com/blog/how-to-run-sql-file-or-query-in-laravel-seeder
gather than lass than
'min'=>"required|numeric",
'max'=>"required|numeric|gt:min",

lt lessthan
gt gatherthan
gte gatherthan equal

https://github.com/laravel/framework/issues/24650
Print array list
name="user_type[]"
$user_type = $request->input('user_type');
            
      $array = [];
      $serial = 0;
      foreach ($user_type as $field) {
         $array[$serial] = $field;
         $serial = $serial + 1;
      }      
      $field = "(".implode(', ', $array).")";
image upload
$path="images/general/";
      $default="default.jpg";
      if ($request->hasFile('photo')){
         if($files=$request->file('photo')){
            $photo = $request->photo;
            $fullName=time().".".$photo->getClientOriginalExtension();
            $files->move(public_path($path), $fullName);
            $photoLink = $path . $fullName;
         }
      }else{
         $photoLink = $path . $default;
      }

https://www.codegrepper.com/code-examples/php/laravel+upload+image+to+public+folder
multiple-checkboxes insert
html
====
<div class="form-group col-4">
    <select class="multiple-checkboxes" multiple="multiple" name="user_type[]">
        @foreach($userTypes as $user)
            <option value="{{$user->name}}">{{$user->name}}</option>
        @endforeach
    </select>
</div>

Controller
==========
$user_type = $request->input('user_type');
if ($user_type){
    $array = [];
    $serial = 0;
    foreach ($user_type as $field) {
    $array[$serial] = $field;
    $serial = $serial + 1;
    }      
    $user_type = implode(', ', $array);         
}

output
======
user, user2, user3...
file_put_contents
composer dump-autoload
composer install
php artisan cache:clear
php artisan clear-compiled
<-- OR -->
Deleted the file "/public_html/bootstrap/cache/config.php"
then I ran "php artisan config:cache"
Laravel Redirect to page & data
return Redirect::to('Blade page name');

With data
return Redirect::route('settings')->with(['data' => $data])->withInput(['tab' => $tab]);
insert last id
insert() [Does not insert (created_at, updated_at)]	
create() [Insert (created_at, updated_at)]
----------------------------
$user = User::insertGetId([
             'name' => $request->name
              [Does not insert (created_at, updated_at)]
]);
Answer: $user = 2;
--------------------
$user = User::create([
             'name' => $request->name
              [Insert (created_at, updated_at)]
]);
Answer: $user->id = 2;
-------------------------
N:B: createGetId [Not working]
laravel print Alphabet
Capital : A-Z, small : a-z
@foreach(range('a','z') as $letter)                                                  
   {{$letter}}         
@endforeach
Answer: a, b, c, d
------------------
@foreach($users as $user)
   {{ chr(64+ $loop->iteration) }}) {{$user->name}}
@endforeach
Answer: A) user, B)User2
------------------------
@foreach($users as $user)
   {{ chr(96+ $loop->iteration) }}) {{$user->name}}
@endforeach
Answer: a) user, b)User2
------------------------
https://laracasts.com/discuss/channels/site-improvements/loop-iteration-as-a-in-blade
Sql filter row
$questionList = QuestionList::with('getOption')->pluck('id');
$answerList = AnswerList::where('userId', $user)->pluck('questionId');
 
$unVoteQuestion = $questionList->diff($answerList);
$data['addVote'] = QuestionList::with('getOption')->whereIn('id', $unVoteQuestion)->get(); 
      
return view('home', $data);
Laravel csv file read
https://blog.quickadminpanel.com/how-to-import-csv-in-laravel-and-choose-matching-fields/

https://www.itsolutionstuff.com/post/laravel-create-csv-file-from-custom-array-using-maatwebsiteexample.html

https://makitweb.com/export-data-to-csv-excel-format-in-laravel-8/
Three table
<!-- All Column -->
                  <?php if(isset($_SESSION['tableName'])){ ?>
                     <div class="tab-pane" id="column">
                        <p class="bg-success text-center mb-2"><?= $_SESSION['tableName']; ?>'s [columns]</p>
                        <?php
                           // $tableName = $_SESSION['tableName'];
                           $column = "SHOW columns FROM $tableName";
                           $columnResult = mysqli_query($conn, $column);
                           $TotalColumn = mysqli_num_rows($columnResult);
                           $col_4 = 1;
                           $loop = 1;
                           $headFirst = 1;
                        ?>
                        <form action="action.php" method="POST">
                           <div class="row">
                              <?php while($row = mysqli_fetch_array($columnResult)){ ?>
                                 <?php if($col_4=='1'){ ?>
                                    <table id="example1" class="table table-bordered table-striped col-4 mb-0">
                                       <?php if($headFirst=='1'){?>
                                          <thead>
                                             <tr class="text-center">
                                                <th class="bg-secondary">No</th>
                                                <th>Column name</th>
                                                <th>Action</th>
                                             </tr>
                                          </thead>
                                       <?php } ?>
                                       <tbody>
                                          <tr>
                                             <td width="20%" class="bg-secondary text-center"><?= $loop; ?></td>
                                             <td width="auto"><?= $row['Field']; ?></td>
                                             <?php if($row['Field']!='id') {?>
                                                <td width="20%" class="text-center"><a class="btn btn-sm btn-danger" href="action.php?columnName=<?=$row['Field']; ?>&tab=column">Delete</a></td>
                                             <?php }else{ ?>
                                                <td width="20%" class="bg-warning text-center p-0">
                                                   Primary key can't delete
                                                </td>
                                             <?php } ?>
                                          <tr>                                           
                                       </tbody>
                                    </table>
                                 <?php }elseif($col_4=='2'){ ?>
                                    <table id="example1" class="table table-bordered table-striped col-4 mb-0">
                                       <?php if($headFirst=='2'){?>
                                          <thead>
                                             <tr class="text-center">
                                                <th class="bg-secondary">No</th>                                                
                                                <th>Column name</th>
                                                <th>Action</th>
                                             </tr>
                                          </thead>
                                       <?php } ?>
                                       <tbody>
                                          <tr>
                                             <td width="20%" class="bg-secondary text-center"><?= $loop; ?></td>
                                             <td width="auto"><?= $row['Field']; ?></td>
                                             <?php if($row['Field']!='id') {?>
                                                <td width="25%" class="text-center"><a class="btn btn-sm btn-danger" href="action.php?columnName=<?=$row['Field']; ?>&tab=column">Delete</a></td>
                                             <?php }else{ ?>
                                                <td width="25%" class="bg-warning text-center p-0">
                                                   Primary key can't delete
                                                </td>
                                             <?php } ?>
                                          <tr>
                                       </tbody>
                                    </table>
                                 <?php }else{ ?>
                                    <table id="example1" class="table table-bordered table-striped col-4 mb-0">
                                       <?php if($headFirst=='3'){?>
                                          <thead>
                                             <tr class="text-center">
                                                <th class="bg-secondary">No</th>                                                
                                                <th>Column name</th>
                                                <th>Action</th>
                                             </tr>
                                          </thead>
                                       <?php } ?>
                                       <tbody>
                                          <tr>
                                             <td width="20%" class="bg-secondary text-center"><?= $loop; ?></td>                                            
                                             <td width="auto"><?= $row['Field']; ?></td>
                                             <?php if($row['Field']!='id') {?>
                                                <td width="20%" class="text-center"><a class="btn btn-sm btn-danger" href="action.php?columnName=<?=$row['Field']; ?>&tab=column">Delete</a></td>
                                             <?php }else{ ?>
                                                <td width="20%" class="bg-warning text-center p-0">
                                                   Primary key can't delete
                                                </td>
                                             <?php } ?>
                                          <tr>
                                       </tbody>
                                    </table>
                                 <?php } ?>
                              <?php (($col_4=='1'||'2') ?  $col_4++ : $col_4='1' ); $loop++; $headFirst++; } ?>              
                           </div>
                        </form>
                     </div>
                  <?php } ?>
Download file
<td>
                              <a href="{{asset('')}}/{{$report->file}}" class="btn btn-large pull-right" target="_blank" download="">
                                 <i class="fas fa-download pr-2"></i>Download
                              </a>
                            </td>
Group by with single print
Controller
$data['patients'] = Appointment::where('doctor_id', Auth::id())->get()->groupBy('patient_id');

Blade
 @foreach($patients as $patient2)
     @foreach($patient2->take(1) as $patient)
         {!!$patient->date!!}
     @endforeach
@endforeach
Room booking search
Rooms [id, room_no] -> Ex:1, 2, 3, 4, 5;
CabinBooking [id, check_in, check_out, room_no] -> 2, 5

UnBook: 1, 3, 4

// All rooms
$rooms = Room::where('room_type', 'cabin')->orderBy('room_no', 'Asc')->pluck('room_no');
***********

// Booked
$booked = CabinBooking::where([
        ['cabin_bookings.check_in', '<=', $check_in],
        ['cabin_bookings.check_out', '>=', $check_out]
    ])
    ->orwhere([
        ['cabin_bookings.check_in', '>=', $check_in],
        ['cabin_bookings.check_out', '<=', $check_out]
    ])->pluck('room_no');
-----------
// Or
$booked = CabinBooking::where([
    ['cabin_bookings.check_in', '<=', $check_in],
    ['cabin_bookings.check_out', '>=', $check_in]
])
->orwhere([
    ['cabin_bookings.check_in', '>=', $check_out],
    ['cabin_bookings.check_out', '<=', $check_out]
])->pluck('room_no');
-----------
// Or
$booked = CabinBooking::whereBetween('cabin_bookings.check_in', [$check_in, $check_out])
->orWhereBetween('cabin_bookings.check_out', [$check_in, $check_out])
->orWhere(function ($query) use ($check_in, $check_out) {
    $query->where('cabin_bookings.check_in', '<', $check_in)
        ->where('cabin_bookings.check_out', '>', $check_out);
})->pluck('room_no');

***********
// UnBook filter
$data['unBook'] = $rooms->diff($booked);
Check if a query has results
@if (count($posts))
@if($query->isEmpty())
Time date
@php
                           $hours_start = strtotime('08:00:00');
                           $hours_end = strtotime('18:00:00');

                           $hours = $hours_end - $hours_start; //amount of hours working in day
                           $hours = $hours / 1800; // 30 munite slot
                           
                           for($i = 0; $i <= $hours; $i++){ // double hours for 30 minute increments
                              $minutes_to_add = 1800 * $i; // add 30 - 60 - 90 etc.
                              $timeslot = date('h:i:s', strtotime($hours_start)+$minutes_to_add);
                              date('h:i a', strtotime($timeslot)). "<br>";
                           }
                         @endphp

06:00 am
06:30 am
07:00 am
07:30 am
08:00 am
Convert 12 hours to 24 hours in PHP
mktime(hour, minute, second, month, day, year, is_dst);

<?php
                        $iTimestamp = mktime(1,0,0,1,1,date('Y'));
                        for ($i = 0; $i < 48; $i++) {
                            echo 1+$i.") ". date('h:i a', $iTimestamp) . "\n<br />";
                            $iTimestamp += 1800;
                        } 
                    ?>

======================

$hour = -1;
                    while($hour++ < 23)
                    {
                        $timetoprint = date('h:i a',mktime($hour,0,0,1,1,2011));
                        echo 1+$hour.")" .$timetoprint . "<br>";
                    }

{{-- # 24 hrs 
H:i 
// output 14:20

# 12 hrs 
h:i 
// output 2:20 --}}
check_in check_out validation
$validator = Validator::make($request->all(),[            
'check_in'=>'required|date|before_or_equal:check_out',
'check_out'=>'required|date|after_or_equal:check_in',
]);

return [
        'pay_period_start'=>'date',
        'pay_period_end' => 'date',
        'work_date' => 'date|after_or_equal:pay_period_start|before_or_equal:pay_period_end',
    ];
multiple column check sql
https://stackoverflow.com/questions/54775177/select-where-all-3-columns-are-not-null-at-the-same-time-laravel-query-builder
Add appointment
1) Html
=======
<form action="{{ route('appointment.add') }}" method="post" enctype="multipart/form-data">
    @csrf
    <input type="hidden" name="user_id" value="{{ $doctorId = $doctor->user_id }}">
    <input type="text" class="select-date datepicker" name="date" id="date" placeholder="Day-Month-Year"/>
    <select class="select-time" name="time" id="time">
        <option value="">Select time</option>
    </select>
    <button type="submit">Add now</button>
</form>

2) Js action
=========
<script>
    $(document).ready(function() {
        $('.select-date').change(function() {
            var date = $(this).val();
            var doctorId = '{{ $doctorId }}';
            $('.select-time').html('');
            $.ajax({
                url: "{{ route('search.date') }}",
                method: "get",
                data: {
                    date: date,
                    doctorId: doctorId
                },
                success: function(result) {
                    $('.select-time').append('<option selected>Select time</option>');
                    $.each(result, function(key, value) {
                        $('.select-time').append('<option disabled2 value="' + value + '">' + value + '</option>');
                    });
                }
            })
        });
    });
</script>

3) web.php
==========
Route::get('search-date', 'PatientController@search_date')->name('search.date');   

4) PatientController
====================
public function search_date(Request $request) {
    $allTime = array('8:10 AM', '8:15 AM', '8:20 AM', '8:25 AM', '8:30 AM');
    $booked =   Appointment::where('doctor_id', $request->doctorId)
                ->where('date', date('Y-m-d', strtotime($request->date)))
                ->pluck('time')->toArray();   
    $unBook = array_diff($allTime, $booked);
    return response()->json($unBook);
}

5) web.php
==========
Route::post('appointment-add', 'PatientController@appointment_add')->name('appointment.add');

6) PatientController
=================
public function appointment_add(Request $request){   
    Appointment::Create([            
        'appointment_id' => uniqid(),
        'patient_id' => Auth::id(),
        'doctor_id' => $request->user_id,
        'date' => date('Y-m-d', strtotime($request->date)),
        'time' => $request->time
    ]);
    return back()->with('success', 'Appointment add successfully');
}

database table
==============
Schema::create('appointments', function (Blueprint $table) {
    $table->id();
    $table->string('appointment_id')->nullable();
    $table->integer('patient_id');
    $table->integer('doctor_id');
    $table->date('date')->nullable();
    $table->string('time')->nullable();
});
Two array add
https://stackoverflow.com/questions/32387575/how-to-properly-merge-multiple-collections-in-laravel

$paid = Payment::pluck('id')->toArray();
$newCompete = array(2=>'Others');
$paid2 =    collect($paid)->concat($newCompete)->toArray();
Install XSender WhatsApp on cPanel
https://youtu.be/_xOAdCprXY0
Basic Microservices
https://www.youtube.com/watch?v=iaj4rQ8UH24&t=1010s&ab_channel=JustSteveKing
calculation
<style>
                                        input{width: 100%; text-align: center;}
                                        input::-webkit-outer-spin-button,
                                        input::-webkit-inner-spin-button {
                                            display: none;
                                        }
                                    </style>
                                    <tbody style="font-weight: bold;">
                                        <tr>
                                            <td colspan="5">Subtotal:</td>
                                            <td id="sb_total"></td>
                                        </tr>
                                        <tr>
                                            <td colspan="5">Discount:</td>
                                            <td width="10">
                                                <input type="number" min="0" id="a_discount" value="0">
                                            </td>
                                        </tr>
                                        <tr>
                                            <td colspan="5">Less Amount:</td>
                                            <td>
                                                <input type="number" min="0" id="b_less" value="0">
                                            </td>
                                        </tr>
                                        <tr>
                                            <td colspan="5">Vat:</td>
                                            <td>
                                                <input type="number" min="0" id="c_vat" value="0">
                                            </td>
                                        </tr>
                                        <tr>
                                            <td colspan="5">Total:</td>
                                            <td id="t_amount"></td>
                                        </tr>
                                    </tbody>



    <script>
        $('#sb_total, #a_discount, #b_less, #c_vat').blur(function(){

            var list_total = $('#subtotal').val();
            var vat_amount = 0;
            var less_amount = 0;

            // $('#a_discount').each(function(){
                var discount = $('#a_discount').val();
                var discount_type = $('#a_discount').attr('data');
                if(!(discount)){
                    discount = 0;
                }if(!(discount_type)){
                    discount_type = 0;
                }
                var discount_amount = (list_total*(discount/100));
                if(discount_type == '1'){
                    discount_amount = discount;
                }    

                // Less
                var less_amount = $('#b_less').val();
                if(!(less_amount)){
                    less_amount = 0;
                }

                // vat
                var vat = $('#c_vat').val();
                if(!(vat)){
                    vat = 0;
                }
                var vat_amount = (list_total*(vat/100));
            // });
            var total_amount = (parseInt(list_total)+parseInt(vat_amount))-(parseInt(discount_amount)+parseInt(less_amount));  

            $('#t_amount').html(total_amount.toFixed(2));
            $('#t_amount').append('<input type="hidden" name="t_amount" value="'+total_amount+'"/>');


        })
        // $('#t_amount').text(discount.toFixed(2));
    </script>
                  

    function load_cart(){
        $.ajax({
            url:"includes/cart_process.php",
            method:"GET",
            dataType:"json",
            success:function(data) {
                $('#cart_details').html(data.cart_details);
                $('#sb_total').text(data.sub_total);
                $('#total').html(data.total);
                $(".mem_details").html(data.member.member_details);
                $("#m_info").html(data.member.member_info);
                calculation();
            }
        });
    }
foreach
<?php
$sql = "SELECT * FROM users";
$result = mysqli_query($con, $sql);
// if single output
$result->fetch_assoc()['name'];
// Loop data
foreach($result as $row): 
           echo $row["name"];
endforeach; 
?>
Select single
$sql2 = "SELECT count(id) as id, sum(total_rcv) as total FROM sd_order_more WHERE (mobile= '$mobile' && customerID = 0) and activity = 1";
                                    $result2 = mysqli_query($mysqli, $sql2);
                                    $result3 = mysqli_query($mysqli, $sql2);
                                    $service_number =  $result2->fetch_assoc()['id'];
                                    $total_expense = $result3->fetch_assoc()['total'];
Sql import command
λ mysql -u root -p
show databases;
use databaseName;
source sqlPath; // also File drag and drop allow.
Session time for timer
$_SESSION['postTimer'] = (time()+(24*60*60))*1000;

<?php if(isset($_SESSION['postTimer']) && (time()*1000 < $_SESSION['postTimer'])){ ?> 
		<script>
			// Set the date we're counting down to
			var countDownDate = <?= $_SESSION['postTimer']; ?>;

			var x = setInterval(function() {

				var now = new Date().getTime();
				var distance = countDownDate - now;
				
				// var days = Math.floor(distance / (1000 * 60 * 60 * 24));
				var hours = Math.floor((distance % (1000 * 60 * 60 * 24)) / (1000 * 60 * 60));
				var minutes = Math.floor((distance % (1000 * 60 * 60)) / (1000 * 60));
				var seconds = Math.floor((distance % (1000 * 60)) / 1000);				
				document.getElementById("timeCount").innerHTML = hours + "h " + minutes + "m " + seconds + "s ";
				
				if (distance < 0) {
					clearInterval(x);
					document.getElementById("submitButton").disabled = false;
					document.getElementById("timeCount").style.display = "none";
				}else{
					document.getElementById("submitButton").disabled = true;
				}
			}, 1000);
		</script>
	<?php }else{
		unset($_SESSION['postTimer']);
	} ?>
Faker
$faker = Faker\Factory::create();
        foreach (range(1, 10) as $value) {
            DB::table('subjects')->insert([               
                'name' => $faker->name
            ]);
        }
Laravel Eloquent exists() and doesntExist() Example
https://www.itsolutionstuff.com/post/laravel-eloquent-exists-and-doesntexist-exampleexample.html
laravel pdf
https://spatie.be/docs/laravel-pdf/v1/introduction
spatie::pdf package requires PHP 8.2+, Laravel 10+.

All see another four(4) pdf generator
https://spatie.be/docs/laravel-pdf/v1/alternatives
1) laravel-dompdf
2) wkhtmltopdf 
3) mPDF
4) FPDF
insert all
$input = $request->except('_token', 'image_path');
How to fix Error: laravel.log could not be opened?
https://stackoverflow.com/questions/23411520/how-to-fix-error-laravel-log-could-not-be-opened
colors
@php 
                                            $colors = array('bg-info', 'bg-secondary', 'bg-dark', 'bg-primary', 'bg-white', 'bg-success', 'bg-warning', 'bg-secondary', 'bg-danger', 'bg-dark'); 
                                        @endphp
email setup
MAIL_MAILER=smtp
MAIL_HOST=smtp.gmail.com
MAIL_PORT=587
MAIL_USERNAME=abc@gmail.com
MAIL_PASSWORD=abc
MAIL_FROM_ADDRESS=abc@gmail.com
MAIL_FROM_NAME=Name
MAIL_ENCRYPTION=tls
session cart quantity add
if($_POST["action"] == "add" && $_POST["type"] == "service"){                        
            if(!empty($_SESSION["shopping_cart"])){
                $itemList = array();    
                
                foreach($_SESSION["shopping_cart"] as $keys => $values) {
                    $itemList[] = array('itm_id'=>$values["itm_id"], 'qty_id'=>$values["qty_id"]);
                }

                $key = array_search($_POST["itm_id"], array_column($itemList, 'itm_id'));

                if ($key !== false) {
                    $qty_id = $itemList[$key]['qty_id'];
                    // this line add quantity...
                    $_SESSION["shopping_cart"][$key]['qty_id'] =  $qty_id+1;
                }else{
                    $item_array = array('itm_id'=>$_POST["itm_id"], 'qty_id'=>1, 'type'=>$_POST["type"]);
                    $_SESSION["shopping_cart"][] = $item_array;
                }                
            }else{
                $item_array = array('itm_id'=>$_POST["itm_id"], 'qty_id'=>1, 'type'=>$_POST["type"]);
                $_SESSION["shopping_cart"][] = $item_array;
            }
        }
auto invoice id create
if ($stmt_m1->num_rows == 0) {
        $orderID = 'INV-0000001';
    }else{
        if ($stmt_m = $mysqli->prepare("SELECT id, CONCAT( '" . $prefix . "-', LPAD(id + 1,7,'0') )
                    FROM sd_order_more ORDER BY id DESC")) {
            $stmt_m->execute();
            $stmt_m->store_result();
            $stmt_m->bind_result($prefx_id, $orderID);
            $stmt_m->fetch();
            $stmt_m->close();
        }
    }
2d arraay create and save
<?php
    session_start();
    require_once("db_connect.php");

    $p_cart = array();
    $c_cart = array();
    foreach($_SESSION["shopping_cart"] as $keys => $values){
        if($values["type"] == "product"){
            $p_cart[] = array('itm_id'=>$values['itm_id'], 'qty_id'=>$values["qty_id"]);
        }
    }

    foreach($_SESSION["combo_cart"] as $keys => $values){
        $c_cart[] = $values['combo_id'];
    }
    
    $product = json_encode($p_cart);
    $combo = json_encode($c_cart);


    if(isset($_POST["action"])){
        $cartName = $_POST["cartName"];

        $sql = "INSERT INTO cart_hold VALUES(null, '$cartName', '$product', '$combo')";
        $result = mysqli_query($mysqli, $sql);
    }

    unset($_SESSION["shopping_cart"]);
    unset($_SESSION["combo_cart"]);

    $data = array(
        'cart'     => $cartName
    );      
    echo json_encode($data);
?>
Dynamic Variable Names in PHP
$payment_mtd = 'bKash';
$paid = 20;
$bkash = 10;

$lists = ['bkash', 'cash'];
    foreach($lists as $name){
        if($name == $payment_mtd){
            $$name = $paid;
            or
             ${$name} = $paid;
        }
    }
echo bkash;
print : 20;

https://wholesomecode.net/dynamic-variable-names-in-php/
sql query where condition array colluction
https://www.geeksforgeeks.org/how-to-bind-an-array-to-an-in-condition-in-php/

 <?php
                                                            $category = ['salary', 'bonus', 'other'];
                                                            $type2 = implode('\', \'', $category);

                                                            $sql = "SELECT * FROM sd_expns_c WHERE type2 IN ('$type2') && activity = 1 ORDER BY id ASC";
                                                            $result = mysqli_query($mysqli, $sql);
                                                            while ($row = $result->fetch_assoc()) { ?>
                                                                <option value="<?= $row['id']; ?>"><?= $row['menu_name']; ?></option>
                                                            <?php } ?>
compare a variable to multiple values
$test_variable = 'value1';

// 1st way
if ($test_variable === 'value1' || $test_variable === 'value2' || $test_variable === 'value3' || $test_variable === 'value4') {
    // code
}

// 2nd way
if (in_array($test_variable, ['value1', 'value2', 'value3', 'value4'])) {
    // code
}

// 3rd way
$test_array = ['value1', 'value2', 'value3', 'value4'];
if (in_array($test_variable, $test_array)) {
    // code
}

https://inthedigital.co.uk/use-phps-in_array-to-compare-a-variable-to-multiple-values/#:~:text=August%2028th%2C%202020-,Use%20PHP's%20in_array()%20to%20compare%20a%20variable%20to%20multiple,instead%20of%20complex%20if%20expressions.