CodeKeyboard

CSS LINKING : {!!Html::style('assets/css/bootstrap.css')!!} JAVASCRIPT LINKING : {!!Html::script('assets/js/bootstrap.min.js')!!}

How to Install MySQL sudo apt-get install mysql-server How to Access the MySQL shell mysql -u root -p How to Create and Delete a MySQL Database mysql> SHOW DATABASES; mysql> CREATE DATABASE db_name; mysql> DROP DATABASE db_name ; mysql> USE db_name; mysql> SHOW tables; How to Create a MySQL Table CREATE TABLE tbl_name (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(20), food VARCHAR(30), confirmed CHAR(1), signup_date DATE); mysql> SHOW TABLES; mysql> DESCRIBE tbl_name; How to Add Information to a MySQL Table INSERT INTO `tbl_name` (`id`,`name`,`food`,`confirmed`,`signup_date`) VALUES (NULL, "John", "Casserole","Y", '2012-04-11'); mysql> SELECT * FROM tbl_name; How to Update Information in the Table UPDATE `tbl_name` SET `confirmed` = 'Y' WHERE `tbl_name`.`name`='Sandy'; How to Add and Delete a Column ALTER TABLE tbl_name ADD email VARCHAR(40); ALTER TABLE tbl_name ADD email VARCHAR(40)

{{ Form::open(array('url'=>'action_route','method'=>'post')) }}   <div class="form-group {{$errors->has('first_name')?'has-error':''}}">     {!!Form::label('first_name','First Name : ')!!}    {!!Form::text('first_name',$info->first_name,array('class'=>'form-control'))!!}    {!!$errors->first('first_name','<span class="help-block">:message</span>')!!}   </div> {{ Form::close() }}

{!! Request::segment(1)== 'contact' ? ' class="active" ' : '' !!}

{{ }} $first = "<b>Hasib Kamal</b>" ; {{ $first }} Output : <b>Hasib Kamal </b> {!! !!} $first = "<b>Hasib Kamal</b>" ; {!! $first !!} Output : Hasib Kamal

VIEW :     public function index(){         $info_list = infoModel::all();         return view('list',compact('info_list'));     } SAVE :     public function storeInfo(Request $request){         $first_name = $request->get('first_name');         $last_name = $request->get('last_name');         $email_address = $request->get('email_address');         $phone_number = $request->get('phone_number');         $info = new infoModel();         $info->first_name = $first_name;         $info->last_name = $last_name;         $info->email_address = $email_address;         $info->phone_number = $phone_number;         $info->save();         return redirect('/');     } DELETE :     public function delete($id){         infoModel::where('id',$id)->delete();         return redirect('/');     }

START> sudo service apache2 start STOP> sudo service apache2 stop RESTART> sudo service apache2 restart