Simple just type
php -a
More info about php :
How to fix ?
NOTICE: [pool valet] ‘user’ directive is ignored when FPM is not running as root
or
ERROR: FPM initialization failed
or
Laravel Valet – This Site Can’t Be Reached
or
valet nginx 137 upstream timed out (60: Operation timed out) while reading response header from upstream, client: 127.0.0.1,
valet uninstall
rm -rf ~/.valet
rm -rf ~/.config/valet
valet install
valet link
valet open
#1 – Remove from composer Json the similar line
“doctrine/dbal”: “^2.10”,
#2 – Run
composer upgrade
#3 – Run
composer update
#4 – Voila ! The error should be fixed !
see example below of an upsert
Polls::updateOrInsert(['business_id'=> $business_id],
[
"$vote_value" => DB::raw('$vote_value + 1'),
'polls_name' => $theBusiness->BUSINESSNAME,
'source' => env('APP_CODE'),
'updated_at' => $lastupdated
]);
Example : for SQLITE the double quote is critical to make it work
Polls::updateOrInsert(['business_id'=> $business_id],
[
"$vote_value" => DB::raw('"$vote_value" + 1'),
'polls_name' => $theBusiness->BUSINESSNAME,
'source' => env('APP_CODE'),
'updated_at' => $lastupdated
]);
'ilike' or 'not ilike'
return $query->where('api_call', 'not ilike', '%TEST%');
#1 – Install Flag library via NPM
npm install flag-icon-css
#2 – Import css to your library
import 'flag-icon-css/css/flag-icon.css'
#3 – in your blade
<li > <a href="/en"> <i class=" flag-icon flag-icon-us"></i></a> </li>
use this command php artisan migrate --path=/database/migrations/my_migration.php
Â
const mix = require('laravel-mix'); /* |-------------------------------------------------------------------------- | Mix Asset Management |-------------------------------------------------------------------------- | | Mix provides a clean, fluent API for defining some Webpack build steps | for your Laravel application. By default, we are compiling the Sass | file for the application as well as bundling up all the JS files. | */ mix.js('resources/js/app.js', 'public/js') .sass('resources/sass/app.scss', 'public/css').version(); mix.version();
php artisan nova:resource Businesses php artisan make:model Businesses
<?php namespace App; use Illuminate\Database\Eloquent\Model; class Thetable extends Model { protected $connection = 'pgsql-api'; protected $table = 'mapi_admin_tool.THETABLE'; protected $primaryKey = 'id'; protected $dateFormat = 'Y-m-d H:i:sO'; public function __construct(array $attributes = []) { parent::__construct($attributes); } protected $dates = [ 'created_at', 'updated_at', 'deleted_at' ]; }
<?php namespace App\Nova; use Illuminate\Http\Request; use Laravel\Nova\Fields\Date; use Laravel\Nova\Fields\ID; use Laravel\Nova\Fields\Text; use Laravel\Nova\Http\Requests\NovaRequest; class Thetable extends Resource { /** * The model the resource corresponds to. * * @var string */ public static $model = 'App\M2TrackFileSubmissionToWindsurfer'; /** * The single value that should be used to represent the resource when being displayed. * * @var string */ public static $title = 'id'; /** * The columns that should be searched. * * @var array */ public static $search = [ 'id', ]; /** * Get the fields displayed by the resource. * * @param \Illuminate\Http\Request $request * @return array */ public function fields(Request $request) { return [ ID::make('id')->sortable(), Text::make('file_uuid')->sortable(), Text::make('set_uuid')->sortable(), Text::make('windsurfer_job_id')->sortable(), Text::make('cust_filename')->sortable(), Text::make('artwork_info')->sortable(), Date::make('created_at')->sortable(), Date::make('update_at')->sortable(), ]; }