Saturday, January 27, 2024

Thursday, March 16, 2023

MySQL Reset Root Password

1. first sudo mysql

sudo mysql -u root


2. check present db

select user, host from mysql.user


3. delete current 'root'@'localhost'

drop user 'root'@'localhost';


4. recreate root

create user 'root'@'localhost' identified by '';


5 Give permission

grant all privileges on *.* to 'root'@'localhost' with grant option;

flush privileges;

Thursday, April 5, 2018

[Laravel] Multiple Checkbox and Enable Checkbox



Controller

public getAccessories($request) {

$accessories = array(0=>'Charger',1=>'Battery',2=>'USB Cable',3=>'Others');

// retrieve accessories from db and convert to array
$save_accessories = unserialize($repair->accessories);

// Pass accessories to view page
 return view('view', compact('$accessories', '$save_accessories'));

}


view.blade 

@foreach($accessories as $i=>$accessory)
{!! Form::checkbox('accessories[]', $accessory,
in_array($accessories[$i],$save_accessories)) !!}
{!! Form::label($accessory, $accessory) !!}
<br/>
@endforeach