Forem: Saquib Rizwan

Create & Manage User Registration System with Laravel Queues & Supervisor

Saquib Rizwan — Tue, 28 Nov 2017 08:48:56 +0000

With the recent release of Laravel 5.5 and Laravel Horizon, the framework now offer queue management. Laravel queues allow you to defer the processing of a time- consuming task (a good example is email sending) to a later time. This speeds up web request processing for your application.

In this article, I will create a user registration system, which sends a verification email to the user. To demonstrate the capabilities of Laravel queues and its impact on the application speed, I will let it manage the email sending process. so that the application performs faster.

For the purpose of this tutorial, I will use the Cloudways platform because it provides Supervised queue manager for Laravel applications. To begin, I will launch a Cloudways server with the Laravel application installed.

PS: If you need help with the signup and the server launch process, here’s a handy GIF:

Configure the .env file

Now that you have installed the Laravel application, the next step is database configuration.

I will use the Gmail to send verification emails. Open the Applications tab in the Cloudways platform. In the **Application Access **details, you will see the database path and credentials.

Now go to the .env file (located in the application’s public root folder) and add the credentials there:


QUEUE_DRIVER=database

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE= your.database.name                                                                                                                            

DB_USERNAME= your.database.username                                                                                                                             

DB_PASSWORD= your.database.password

MAIL_DRIVER=smtp

MAIL_HOST=smtp.gmail.com

MAIL_PORT=587

MAIL_USERNAME=Saquib.gt@xyz.com

MAIL_PASSWORD=

MAIL_ENCRYPTION=tls

MAIL_FROM_ADDRESS=Saquib.gt@xyz.com

MAIL_FROM_NAME="Saquib Rizwan”

Creating Laravel Auth

To make the user registration system, the first thing I need to do is to create a Laravel auth using:


php artisan make:auth

Update the Users Table

Let’s first update the existing migration file for the user. Open the user table migration file (located in the database/migrations folder) and add two new columns in it, one for email tokens, and the second to check whether the user has been verified.

The following is the updated schema for the User table:


Schema::create(‘users’, function (Blueprint $table) {

$table->increments(‘id’);

$table->string(‘name’);

$table->string(‘email’)->unique();

$table->string(‘password’);

$table->tinyInteger(‘verified’)->default(0);

$table->string(‘email_token’)->nullable();

$table->rememberToken();

$table->timestamps();

});

Create Table for Queues

I will now add the table for queued jobs and failed job. For that, run the following Artisan commands:


php artisan queue:table

php artisan queue:failed-table

Migrate the Tables

Now that I have all the required tables, I will migrate it using the following Artisan command:

php artisan migrate

Once the command is completed, all the tables will be generated.

Create Mail And the View For Email Verifications

Since I have setup SMTP to send emails, it’s time to create an email class which will return view and token to be sent with the email. Run the following Artisan command to create the email setup:

php artisan make:mail EmailVerification

Once the command finishes, a new folder with the name Mail along with the **EmailVerification **class file will be created inside the app folder. I will call this file when sending email(s).

Update the EmailVerification Class

This class comes with two methods. The first is the constructor(), and the second is the build(), which will do most of the work. It binds the view with the email.

I will send a user token along with the view so that the user can be verified. For this, add a new protected variable in the class with the name $user:


protected $user;

Now, add a new $user parameter in the constructor and pass this to the class variable $user.


public function __construct($user)

{

//.

$this->user = $user;

}

Next, update the **build()** method so that it can return a view along with the user token.

public function build()

{

return $this->view(‘email.email’)->with([

‘email_token’ => $this->user->email_token,

]);

}

Create the Email Template

For creating the email template, create a new folder inside views folder with name email, and then create a new file inside this folder with the name email.blade.php. This file will contain the following simple template:

<h1>Click the Link To Verify Your Email</h1>

Click the following link to verify your email {{url(‘/verifyemail/’.$email_token)}}

The view for the email is now complete. Next, I will create a new queue that will send the email(s) to the registered users.

Create the SendVerficationEmail Queue Job

Now run the following Artisan command to make a new queue job

php artisan make:job SendVerificationEmail

When the command finishes, a new folder with the name Jobs appears inside the app folder along with the SendVerificationEmail job class. I will now edit this file so that it could be used to send an email.

First, add Mail and EmailVerification namespaces in it.

use Mail;

use App\Mail\EmailVerification;

Now create a new protected variable, $user (also created in the EmailVerification class). Next, add a new parameter $user in the constructor() and pass its value to the class $user variable:


protected $user;

public function __construct($user)

{

$this->user = $user;

}

Next, I will set up email sending process inside the **handle()** method.

public function handle()

{

$email = new EmailVerification($this->user);

Mail::to($this->user->email)->send($email);

}

The handle **function creates an instance of email verification template that is passed to **Mail for sending off the email to a user.

Update the Auth Registration Process

Before getting started, add ‘email_token’ in $fillable array in the User Model.


protected $fillable = [

‘name’, ‘email’, ‘password’,’email_token’

];

Now open RegisterController.php file (located inside the Controller/Authfolder).

First add the following namespaces:


use Illuminate\Auth\Events\Registered;

use Illuminate\Http\Request;

use App\Jobs\SendVerificationEmail;

Now modify the create() method and add the email_token in it.


protected function create(array $data)

{

return User::create([

‘name’ => $data[‘name’],

‘email’ => $data[‘email’],

‘password’ => bcrypt($data[‘password’]),

‘email_token’ => base64_encode($data[‘email’])

]);

}

For the email token, I have used the base64 encoding for the user’s email address. Next I added the following two new functions in it:


/**

* Handle a registration request for the application.

*

* @param \Illuminate\Http\Request $request

* @return \Illuminate\Http\Response

*/

public function register(Request $request)

{

$this->validator($request->all())->validate();

event(new Registered($user = $this->create($request->all())));

dispatch(new SendVerificationEmail($user));

return view(‘verification’);

}

/**

* Handle a registration request for the application.

*

* @param $token

* @return \Illuminate\Http\Response

*/

public function verify($token)

{

$user = User::where(‘email_token’,$token)->first();

$user->verified = 1;

if($user->save()){

return view(‘emailconfirm’,[‘user’=>$user]);

}

}

What I have done is to override the **register() **parent method and added two new lines in it.

dispatch(new SendVerificationEmail($user));

return view(‘verification’);

This way the email is dispatched into the queue. Instead of directly logging in the user, I will redirect him to another page, which will ask him to verify his email in order to continue. Next, I have created a new verify() method that will verify the user and the token.

I will next create the views that I called in these two methods.

Create a new file in the views folder with the name emailconfirm.blade.php and paste the following code in it.



@extends(‘layouts.app’)

@section(‘content’)

<div class="container”>

<div class="row”>

<div class="col-md-8 col-md-offset-2">

<div class="panel panel-default”>

<div class="panel-heading”>Registration Confirmed</div>

<div class="panel-body”>

Your Email is successfully verified. Click here to <a href="{{url(‘/login’)}}”>login</a>

</div>

</div>

</div>

</div>

</div>

@endsection

Create another file in the views folder with the name verification.blade.php. Paste the following code in it.


@extends(‘layouts.app’)

@section(‘content’)

<div class="container”>

<div class="row”>

<div class="col-md-8 col-md-offset-2">

<div class="panel panel-default”>

<div class="panel-heading”>Registration</div>

<div class="panel-body”>

You have successfully registered. An email is sent to you for verification.

</div>

</div>

</div>

</div>

</div>

@endsection

At this point the code is complete and ready for use. Let’s give it a try.

Add the following route in the web.php file for user verification:


Route::get(‘/verifyemail/{token}’, ‘Auth\RegisterController@verify’);

Test the Email Verification Process

At the command line, execute the following command to start listening for the queue.

php artisan queue:work

Leave the window of the command line open and open up the register page in another tab. Fill in the form and register a new user.

Once you click the Register button, you will notice that the registration confirmation page opens up quickly because it is dispatched into the queue.

Now look at command line: a new job has been processed successfully.

This means that an email has been sent to the user.

When the user click the link, he/she will be verified:

Once you close the terminal, the queue will stop working. If you want the queue to keep working, you need to use Supervised Queue Manager.

Installing Supervisord

Go to Server Management >> Settings & Packages >> Packages. Click the **Install **button next to Supervisord to start the installation process.

Before the process starts, you will be asked to install Redis on the server (if it is not already installed), as it is required for Laravel queues. Wait for the installation process to finish.

Note: You can check Supervisord service status from Manage Services section. You could even restart the service if required.

Add A New Job

Under Application Management, go to Application Settings **and select the tab for **Supervisor Jobs. Click the Add New Job button to add a job for Supervisord.

Note: Once a job has been created, Supervisord will use the platform default Artisan path which should be /home/master/applications/public_html/artisan.

Job Status and other options

The job status can be checked by clicking the Jobs Status button.

This will show the status of job and other related information including uptime.

If you want to restart any job, click the icon in front of it. There is also the option of removing any job by clicking the remove icon.

This will supervise your Laravel queues and keep them up and running.

Conclusion

In this article, I demonstrated how you can use Laravel queues by building a user registration system. Additionally, I also showed how you can keep your process up and run with the help of a supervisor. If you need any help, just post a comment.

Blackfriday, Cybermonday and ThanksGiving to Dev.to Community.

Saquib Rizwan — Tue, 21 Nov 2017 19:23:42 +0000

Dev.to is one of my favorite community of developers. Therefore on this year's Thanksgiving, I would like to thank you all for being such a great help at every step of development.

This is the Thanksgiving week. There is the Black Friday, then the Cyber Monday, then the Small Business Saturday, and there is a Sunday in between as well, So To enhance the joy of this week I would like to share 99+ Handpicked Black Friday Deals For WordPress, Magento, Laravel, Web Hosting & Web Dev Tools

Also We at Cloudways are Giving $150 Credit on promo code: BF150.

For more details.

Creating a Laravel Notification System

Saquib Rizwan — Thu, 09 Nov 2017 12:08:50 +0000

An important reason of the popularity of Laravel is the simple fact that provides feasible solutions to the common development issues such as authentication, contact forms, sessions, queues, routing, and caching etc.

A common project requirement in Laravel projects is notification generation. In this article, I will present the solution by creating a Laravel notification system. In this system, whenever a user visits the page, a notification will be sent to you through email. To sweeten the deal, I will also integrate Slack to setup the notification for a Slack channel.

Laravel’s notification system is simple to implement because it generate notifications by setting up a single class for each notification. This class defines how to notify users about the message using a particular channel.

Install Laravel Application

To quickly setup a Laravel application, I am using Laravel Hosting at Cloudways. Just sign up at Cloudways and install Laravel application in just few clicks for free.

Create a User Table

After the installation, create a User table. Launch the SSH terminal and login to your server using the Master Credentials (available in the Server Management tab)..

Now go to the root of the application by typing the following commands:


cd applications

cd applicationname/public_html

php artisan migrate

User table is now created in the database.

Now let's add some records into it so that the system can send notifications to that user. Go to the Database Manager and add a simple record in the table. Make sure to add a valid email id because the system will send the notification to this email address.

Now that the user model is created let’s take a look at it. Go to app/User.php that has the following code:


<?php

namespace App;

use Illuminate\Notifications\Notifiable;

use Illuminate\Foundation\Auth\User as Authenticatable;

class User extends Authenticatable

{

   use Notifiable;

   protected $fillable = [

       'name', 'email', 'password',

   ];

   protected $hidden = [

       'password', 'remember_token',

   ];

}

If you look closely, Notifiable trait is been used. Whenever you want to make your model notifiable, all you have to do is import use Illuminate\Notifications\Notifiable; trait in your model.

Just note that certain notification channels expects certain information available on the notifiable. For example, the mail channel expects the model to have an "email" property so it knows which email address to send the notification.

Notification Via Email

Go back to SSH, head to the root of your application and execute the following command:


php artisan make:notification Newvisit

Now, go to app/Notifications/Newvisit.php. In this file you will find the following code:


<?php

namespace App\Notifications;

use Illuminate\Bus\Queueable;

use Illuminate\Notifications\Notification;

use Illuminate\Contracts\Queue\ShouldQueue;

use Illuminate\Notifications\Messages\MailMessage;

class Newvisit extends Notification

{

   use Queueable;

   public function __construct()

   {

       //

   }

   public function via($notifiable)

   {

       return ['mail'];

   }

   public function toMail($notifiable)

   {

       return (new MailMessage)

                   ->line('The introduction to the notification.')

                   ->action('Notification Action', url('/'))

                   ->line('Thank you for using our application!');

   }

   public function toArray($notifiable)

   {

       return [

           //

       ];

   }

}

Let’s understand this code. First, it has the constructor, where any relevant data will be injected.

public function via($notifiable)

   {

       return ['mail'];

   }

Then, it has the via() method, which allows you to choose the notification method which will be used to send the notification to each individual instance.
Then, it has **toMail() **method, which returns three attributes. The first one is line, which specifies the starting body of the email. Then it has action, which specifies the button name and the URL to which the button will redirect. Finally, it has line again, which specifies the closing paragraph of the email. Here is a sample output:


       ->line('The introduction to the notification.')

       ->action('Notification Action', 'https://laravel.com')

       ->line('Thank you for using our application!');

Send Notifications Via Email in Laravel

Go to routes/web.php and paste the following code in the file:


<?php

use App\Notifications\Newvisit;

Route::get('/', function () {

$user = App\User::first();

$user->notify(new Newvisit("A new user has visited on your application."));

   return view('welcome');

});

You would have to import notification class through use App\Notifications\Newvisit; then in the route function, I have called the first record from the User table which I inserted by** $user = App\User::first();. Next, the notification is sent for which I used the **notify function and send the notification in Newvisit instance in the following line of code: $user->notify(new Newvisit("A new user has visited on your application."));

Now open app\Notifications\Newvisit.php and add the following code in it.


<?php

namespace App\Notifications;

use Illuminate\Bus\Queueable;

use Illuminate\Notifications\Notification;

use Illuminate\Contracts\Queue\ShouldQueue;

use Illuminate\Notifications\Messages\MailMessage;

class Newvisit extends Notification

{

   use Queueable;

   protected $my_notification; 

   public function __construct($msg)

   {

       $this->my_notification = $msg; 

   }

   public function via($notifiable)

   {

       return ['mail'];

   }

   public function toMail($notifiable)

   {

       return (new MailMessage)

                   ->line('Welcome '.$this->my_notification)

                   ->action('Welcome to Cloudways', url('www.cloudways.com'))

                   ->line('Thank you for using our application!');

   }

   public function toArray($notifiable)

   {

       return [

           //

       ];

   }

}

Next open .env file and set the database credentials and mailer function. Check out the Laravel Email article for details of this step. The .env file should look like the following:


DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=zzjudekqvs

DB_USERNAME=zzjudekqvs

DB_PASSWORD=

BROADCAST_DRIVER=log

CACHE_DRIVER=file

SESSION_DRIVER=file

QUEUE_DRIVER=sync

REDIS_HOST=127.0.0.1

REDIS_PASSWORD=null

REDIS_PORT=6379

MAIL_DRIVER=smtp

MAIL_HOST=smtp.gmail.com

MAIL_PORT=587

MAIL_USERNAME=saquib.gt@gmail.com

MAIL_PASSWORD=

MAIL_ENCRYPTION=tls

PUSHER_APP_ID=

PUSHER_APP_KEY=

PUSHER_APP_SECRET=

Now everything is ready. Go to the Application tab in the Cloudways platform and click the Launch Application button. You will be notified through an email.

Send Notifications Via Slack in Laravel

To create and send notification for Slack, you’ll need to install Guzzle in via Composer. Launch SSH and in the root of the application, run the following commands:


composer require guzzlehttp/guzzle

php artisan make:notification Newslack

You will need a new class for Slack notifications. For this, go to app/Notifications/Newslack.php and paste the following code.


<?php

namespace App\Notifications;

use Illuminate\Bus\Queueable;

use Illuminate\Notifications\Notification;

use Illuminate\Contracts\Queue\ShouldQueue;

use Illuminate\Notifications\Messages\MailMessage;

use Illuminate\Notifications\Messages\SlackMessage;

class Newslack extends Notification

{

   use Queueable;

   public function __construct()

   {

       //

   }

   public function via($notifiable)

   {

       return ['slack'];

   }

   public function toSlack($notifiable)

   {

       return (new SlackMessage)

           ->content('A new visitor has visited to your application . $this->user->first(1->name)');

   } 

}

Here, via() **method defines the medium for notification and **toSlack() method sends the notification onto Slack.

Set Incoming Webhook

Now to receive Slack notification, go to https://{yourteam}.slack.com/apps. Choose the "Incoming Webhook" type and add a new configuration.

Copy the Webhook URL and head back to your Laravel app.

Your model should implement a routeNotificationForSlack() method that returns this webhook. Therefore go to app/User.php and add the following function in it.


public function routeNotificationForSlack()

   {

       Return 'your_webhook_url';

   }

Now go to routes/web.php and add the following routes.


Route::get('/slack', function () {



$user = App\User::first();



$user->notify(new Newslack());



   echo "A slack notification has been send";



});

Now go to the Application tab in the Cloudways platform, click the Launch Application button and add /slack in the url. You will receive Slack notification as shown below:

Final Words

Laravel Notification system is a fascinating and very easy to implement feature that adds a lot of value to the project. You can use this example to create your own notification system that integrated into your Laravel app without any issues. If you need any help, you can comment below or DM me on twitter. Happy Coding.

How To Send Email Using Different Email Service Providers in Laravel

Saquib Rizwan — Tue, 31 Oct 2017 13:23:52 +0000

Laravel has become a popular choice for PHP project development because of the many developer-focused functionalities such as authentication, queues, cron jobs, emailing etc.

To provide email related functionalities, Laravel provides the Mail function which allows developers to send email through a local or cloud-based service.

The most efficient and effective way of utilizing the email functionalities is to use the email service instead of manually sending the emails. In this article, I will explain how to send emails in Laravel with the Mailable function. I will also explain in detail how to setup third party email service providers, to enhance the email function in Laravel.

If you are new to Laravel, you can take a look at getting started with Laravel 5.4, and introductions to Routing, Controllers, Models and Views.

Install Laravel

I will start by installing a Laravel application on Cloudways server. The good thing about the process is that it requires just a few clicks to deploy a live application on a cloud server.

Create Mailables

To setup the basic Laravel mail function, I will use php artisan command. Type the following command in the terminal:

php artisan make:mail <name of mailable>

This will create the mailable class. Next, go to app/Mail and open the mailable file. The default code for the class would look like this:

<?php



namespace App\Mail;



use Illuminate\Bus\Queueable;

use Illuminate\Mail\Mailable;

use Illuminate\Queue\SerializesModels;

use Illuminate\Contracts\Queue\ShouldQueue;



class mailme extends Mailable

{

   use Queueable, SerializesModels;



   /**

    * Create a new message instance.

    *

    * @return void

    */

   public function __construct()

   {

       //

   }



   /**

    * Build the message.

    *

    * @return $this

    */

   public function build()

   {

       return $this->view('view.name');

   }

}

Now add the following code in the **build **function: 


 public function build()

   {

$address = 'saquibrizwan@xyz.com';

       $name = 'Saquib Rizwan';

       $subject = 'Laravel Email';

       return $this->view('emails.mailme')

       ->from($address, $name) 

       ->subject($subject);

 }

Next, I will create the email template.

Create Email Template

Now go to resources/views and create a new folder with the name emails This folder will contain the email template. In the folder, create a new file mailme.blade.php and create the email template using HTML tags.

 <h1>Laravel Email</h1>

 <p>The email has been send</p>

Configuring the Routes

I will now configure the routes which will trigger the email. Go to routes/web.php and paste in the following code:


<?php

use App\Mail\mailme;

Route::get('/', function () {

    Mail::to('saquib.rizwan@xyz.com')->send(new mailme); 

    return view('emails.mailme');

});

Now that the route is ready, I will look into the configurations for different email services providers for sending the email.

Configurations for Gmail

First of all, login to your Gmail account. Under My account > Sign In & Security > Sign In to Google, enable two step verification, and then generate app password,

Now use the app password in .env file with the following configuration:


MAIL_DRIVER=smtp

MAIL_HOST=smtp.gmail.com

MAIL_PORT=587

MAIL_USERNAME= your.email@gmail.com

MAIL_PASSWORD= your.generated.app.password

MAIL_ENCRYPTION=tls

Now go to Cloudways Platform, and launch your application with the help of the free staging domain.

And, your email will be sent to the email address which you added to the routes.

Configurations for Mailtrap

First of all go to Mailtrap.io. Signup and create your account. Once you have logged in, you will see your dashboard.

Click on inbox and get your username and password.

Now use these credentials in .env file with the following configuration:


MAIL_DRIVER="smtp"

MAIL_HOST="mailtrap.io"

MAIL_PORT=2525

MAIL_USERNAME= your.mailtrap.user

MAIL_PASSWORD= your.mailtrap.pass

MAIL_ENCRYPTION=null

Now go to the Cloudways Platform and launch your application. Your email will be sent to your Mailtrap inbox.

Configuration for Mailgun

Go to Mailgun.com, signup and create your account. After the login, you will redirected to your dashboard.

I will use the Domain and API Key in .env file and add the following lines:

MAIL_DRIVER="mailgun"

MAILGUN_DOMAIN=https://api.mailgun.net/v3/sandbox3bafabb2ef66461ab331b8413425ab23.mailgun.org

MAILGUN_SECRET= your_api_key

Now go to the **routes/web.php **and add the following code:


require '../vendor/autoload.php';

use Mailgun\Mailgun;

$mgClient = new Mailgun('your.api.key');

$domain = "sandbox3bafabb2ef66461ab331b8413425ab23.mailgun.org";

# Make the call to the client.

$result = $mgClient->sendMessage("$domain",

          array('from'    => 'Mailgun Sandbox <postmaster@sandbox3bafabb2ef66461ab331b8413425ab23.mailgun.org>',

                'to'      => 'Saquib <saquib.rizwan@xyz.com>',

                'subject' => 'Hello Saquib',

                'text'    => 'Congratulations Saquib, you just sent an email with Mailgun!  You are truly awesome! '));

Finally, go to the root of your application in the terminal and execute the following command:

composer require mailgun/mailgun-php php-http/guzzle6-adapter php-http/message

That’s it. Go to the Cloudways Platform and launch your application using the free staging domain and the email will be sent to your given email address.

Conclusion

In this article, I demonstrated how you can easily use Laravel mailable for sending emails with different email service providers. If you need help with the code or would like to add to the discussion, do leave a comment below.

Note: To Host your Laravel application on Digital Ocean server FREE for 2 months,Signup at Cloudways and Use Coupon Code "PHP15".

Deploy Laravel Application On Cloud Easily With Cloudways

Saquib Rizwan — Fri, 15 Sep 2017 11:35:44 +0000

Even if you know all about it, setting up and configuring a dedicated server is a time consuming multi-step process. But thanks to managed hosting solutions available in the market today, setting up servers is no longer a major action item on project task lists.

Deploying Laravel application on cloud infrastructure is never been this fast and easy before. With Cloudways, you can deploy a dedicated cloud server with your required resources in just a few clicks! Cloudways offers server infrastructure from five top providers - Amazon, DigitalOcean, Vultr, KYUP and Google Compute Engine. On top of that, the hosting platform is uniquely optimized for Laravel developers!

Cloudways for Laravel

Cloudways provides an incredible platform for Laravel Community. It makes it easy to deploy and host laravel applications so that developers can focus on the development process rather than worrying about deployment and server level issues.

Cloudways take cares of the hosting pain points of Laravel developers through the following features:

Server Cost is included in the Cloudways price plan. Hence developers only need a single account and receive a single invoice.
Easily deploy Laravel applications from Github or Bitbucket.
Auto deployment for Laravel applications.
Team Collaboration feature assigns server and application access and roles to the members of the team.
Easy server management features including server cloning and server transfer.
One click auto backup with frequency ranging from hourly to weekly.
Configure scheduled cron jobs with cron job manager
Pre-configured firewall and security
Monitor everything with the New Relic monitoring system.
Scale up servers with easy vertical scaling.
Pre-installed Composer and Git
24x7 live chat support by cloud professionals.

The Cloudways ThunderStack

Cloudways has its own PHP stack called ThunderStack that consists of unique mix of server and caching technologies. Each server launched on the Cloudways Platform comes with:

Debian
Nginx
Varnish
Apache
PHP-FPM
MySQL or MariaDB
Redis
Memcached
PHP 5.6 or 7.0

Cloudways supports all major PHP frameworks including Laravel, Symfony, Codegniter and CakePHP, and allows one-click installation of your favorite PHP-based CMS like WordPress and Bolt.

Let’s run through a sample case of setting up PHP 7 on a DigitalOcean server using the Cloudways Platform.

Deploy the Server

To set up a PHP 7 server on DigitalOcean at Cloudways, simply sign up at Cloudways and login to your account.

Go to Launch server. Select your PHP stack, DigitalOcean as your infrastructure provider and identify your server resource needs along with other required details.

And you’re done! Your Digital Ocean server will now be deployed within minutes.

Use promo code** PHP15**** to get *$15 free credit *in your Cloudways account. **

Deploy Your Laravel App From GitHub

As a developer, you likely have your Laravel application on a GitHub repository. You can easily deploy it on your Cloudways server in a matter of minutes.

To deploy the application from a Git repo, first, in the Platform dashboard, click the ‘Applications’ tab from the top menu bar and select your application. Now, in order to deploy the application, you will now need an SSH key.

To generate the SSH key, click on the ‘Deployment via Git’ button on the ‘Application Management’ area and then click the ‘Generate SSH Keys’ button to generate your unique SSH key. To download these keys, simply click ‘Download SSH Keys’.

Now upload the ‘SSH Public Key’ to your GitHub account. In order to do this, login to your GitHub account, go to the desired repository, and then into the ‘Settings’ tab. Click the ‘Add Deploy Key’ button and add the Public SSH Key **which you have downloaded from Cloudways platform. Click the ‘Add Key**’ button to finalize the process.

Now copy the ‘Repository SSH Address that you will see in the top panel in your main GitHub dashboard. Copy and paste this address in your Cloudways’ ‘Git Remote Address’ field.

Next, you need to input the deployment path and click on ‘Start Deployment’ button to have your application code deployed onto the Cloudways platform!

That’s It! Cloudways makes it's that easy to deploy your Laravel application on the cloud infrastructure of your choice.

Conclusion

As you can see, you can easily deploy your Laravel application with Cloudways. It allows you to easily handle some of the most important Laravel application hosting issues. From setting up your server and server resources initially, deploying your application, to managing backend application tasks, everything is done effortlessly with Cloudways!

Click HERE to get started with Cloudways right away!

How to Create LAMP stack with Laravel on Digital Ocean Server

Saquib Rizwan — Wed, 23 Aug 2017 09:28:18 +0000

Laravel has become the PHP framework of choice for projects of all scopes. From a simple web app to huge corporate portals, laravel is up for tasks of all scopes. The robust framework is very versatile and is supported by a very passionate community of developers and users. One good thing about Laravel is the fact that it is easy to install and is compatible with all development environments except one exception; the installation of Laravel framework on cloud servers.

In this tutorial, I will take you through the steps required to setup a Laravel powered LAMP stack on Ubuntu. For the purpose of this tutorial, I will be using DigitalOcean (DO) cloud server running Ubuntu 16.04.2.

Connect to DO Cloud Server

The most common and convenient way of connecting to cloud servers is through Secure Shell (SSH). This shell offers a secure and safe communication channel for connecting to and executing commands on the cloud server.

SSH comes pre built in Linux environments. For MS Windows, you can use PuTTY to enable them. To connect to the cloud server, you must have the following credentials:

Server IP address
Username
Password or SSH key

Fire up PuTTY and fill in the server IP address.

Click Open. You will see a security alert notifying that you have not connected to this server before. If you are sure that you have got the IP address right, click Yes.

Next, insert the login credentials (username and password)) for the server.
Note: You will not be able to see the password in the console screen.

Now that you have inputted your username and password, you should be successfully connected to the server.

Introduction to the LAMP Stack

A LAMP stack is an integrated and interconnected setup of open source software. The setup comprises of Linux, Apache web server, MySQL which is an open source RDBMS and PHP.

LAMP stack is perhaps the most common solution for setting up servers for web development. An important reason for this universal choice is the cost factor - all components of the LAMP stack are free to use. In addition, the communities behind individual components are very active and patches and updates are frequently released to ensure that everything is in top working order.

Check Updates for Packages

Before going ahead with the LAMP stack installation, update all the packages available on the server. In order to do that, use the following command:

$ apt-get update
$ apt-get upgrade
$ apt-get dist-upgrade

This is an important step because the latest version of all the packages ensure that the rest of the process and the subsequent Laravel development process goes without a hitch.

Let’s start with deploying the LAMP stack! We begin with installing the Apache web server.

Install the Apache Web Server

Apache is an open source web server that hosts approximately 50% of the websites on the internet. To install Apache server on the DO cloud server, use the following command:

$ apt-get install apache2

During the installation process, you might be asked about the requirement for additional disk space. Press Y and Apache installation process will resume.

Once the installation is over, launch your browser and enter the server’s IP address in the address bar. In the case of successful installation, you should see the following page:

By default, Apache is configured to run server script located in the /var/www/html folder. To change this behavior and ensure that the server executes scripts from public_html folder. I will configure the 000-default.conf file (located in the apache2/sites-enabled folder. Use the following command to navigate to this folder:

$ cd /etc/apache2/sites-enabled

Now to open up the config file in Vim, use the following command:

$ vim 000-default.conf

Locate the entry for DocumentRoot, press i to edit the file, and then replace html with public_html. Check the screenshot below:

When done, press Esc and then press :wq to save and exit the editor. Next, rename the /var/www/html folder to public_html. For this, use the following set of commands:

$ cd /var/www
$ mv html public_html
$ ls

Now, that I have a working public_html folder, restart the web server services with the following command:

$ service apache2 restart

To try out the new settings, re-enter the IP address in the browser. You should see the Welcome Page of the Apache server. Your Apache server is up and running!

Install MySQL DBMS

Now let’s install the MySQL which is a popular relational database management system that usually powers PHP applications.

To install MySQL on the cloud server, go to the root folder and initiate the installation process by entering the following commands:

$ cd

$ apt-get install mysql-server

The process will pause to ask your permission. Type Y and press enter. In the next window, set the password of MySQL root user.

The process finishes in a matter of moments. Next, I will configure MySQL according to the requirements of the LAMP stack. Enter the following command:

$ mysql_secure_installation

The command will ask you to enter the password for the root.

Note: You will not be able to see the password when you enter it.

Next, set the following configurations:

Press Y to to setup Validate Password plugin.
Select the level of password validation policy. (I selected the lowest for the * purpose of this tutorial).
Enter N in order not to change the root password and hit Enter, then type Y to remove anonymous users and hit Enter.
Type N if you want to disallow root login remotely and hit Enter.
Now type Y to remove test tables and databases and hit Enter, and then type Y again and hit Enter.

When you are done with these steps, you should see All done! on the screen. MySQL database management system is now successfully installed and configured.

Install PHP

Now we go about installing PHP. Short for Hypertext Preprocessor, PHP is an open source web scripting language that is ideal for creating dynamic websites. To Install the latest version of PHP on your server, type the following command:

$ apt install php7.0-cli

This command will install PHP on the server. In the beginning of the process, you might be asked whether you want to continue? Press Y.

Once the installation finishes, install the lib_apache2 mod for PHP. Next, restart the Apache service. Use the following commands for these two tasks:

$ apt install libapache2-mod-php7.0
$ service apache2 restart

Go to the public_html folder and create a simple PHPinfo file. Use the following commands:

$ cd
$ cd /var/www/public_html
$ rm index.html
$ vim index.php

Now, press I and type in the following code:

<?php echo phpinfo(); ?>

Save it by pressing Esc and type :wq to save and exit. Now test this file by entering the server IP Address in the browser’s address bar. You should see something like this:

At this point, the LAMP stack has been successfully installed on the DO cloud server. However, there is still some work left to do.

Install PHPmyAdmin

Developers require a UI to manage MySQL. PHPmyAdmin is one of the most popular open source GUI for MySQL. To setup PHPmyAdmin on the server, execute the following commands:

$ apt-get install php7.0-mbstring
$ apt-get install mcrypt
$ service apache2 restart
$ apt-get install phpmyadmin

The process will ask you to select the server for installation. Select Apache and press Enter. Next, provide your MySQL credentials. PHPMyAdmin will be installed at /usr/share/phpmyadmin.

Next, I will create the relevant symlink inside the public_html folder. Type the following commands to go to the public_html folder and create the symlink:

$ cd
$ cd /var/www/public_html
$ ln -s /usr/share/phpmyadmin
$ ls

Now enter your_server_ip / phpmyadmin in the browser. You will see PHPmyAdmin’s login form:

Now, I will secure it by creating a .htaccess file using Vim inside PHPMyAdmin folder. This security measure will ensure that only allow your server’s IP communicates with PHPMyAdmin:

$ cd phpmyadmin
$ vim .htaccess

Press I and type in the following code:

order allow,deny
allow from <your server ip>

The LAMP stack is now ready for your Laravel project! But before you start working on your project, it is important to go about setting up some preliminary resources that you will need for your development project.

Install Git and Composer

Git and Composer are two essential resources for working with Laravel. Git is a free and open source distributed version control system designed to handle a host of projects. The Composer is a very useful tool to help manage dependencies in PHP. The Composer enables you to declare the libraries that your project is dependent on and it will manage them for you.

I will begin with the installation of git using a simple command:

$ apt-get install git-all

This command is all you need to get the git going for your Laravel project.

Now I will install Composer and move it to the Bin folder so that I could use it on command line. Use the following commands for the process:

$ php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"
$ php -r "if (hash_file('SHA384', 'composer-setup.php') === '669656bab3166a7aff8a7506b8cb2d1c292f042046c5a994c43155c0be6190fa0355160742ab2e1c88d40d5be660b410') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"

$ php composer-setup.php
$ php -r "unlink('composer-setup.php');"
$ apt install composer

Install Laravel Using Composer

Now to install Laravel, head to public_html folder and type the following command:

$ cd
$ cd /var/www/public_hmtl
$ composer create-project --prefer-dist laravel/laravel myapplication
$ cd myapplication
$ chmod 777 -R storage/

At this point, Laravel is installed and ready for use. To test the success of the installation, type your_server_Ip_address/myapplication/public in your browser. You will see the Laravel welcome page.

Deploying Laravel On Managed Hosting Platform

As you can see this is a perfectly legitimate but a long and tedious process of setting up a server directly on the cloud host. Not to mention the constant need of monitoring and maintaining your server! .

To experience high performing stacks, easy deployment process and hassle-free management and monitoring of your server and related resources, your best bet is signing up with a managed laravel hosting provider like Cloudways.

Cloudways has one of the best PHP stacks in the industry comprising of Nginx, Varnish, Apache, PHP-FPM, Memcached/Redis, MySQL, and full PHP 7 support. You can host your application to (Google,Amazon,Digital Ocean,Vultr and Kyup) in just few clicks.

There are also attractive discount offers and free credit. For example, using the coupon code: WPMUDEV gets you $50 credit for free!

Conclusion

In this tutorial, I introduced LAMP stack and then discussed the installation of the stack on DO cloud servers running Ubuntu. I next installed Laravel on the LAMP stack and then followed it up with mentioning a quicker alternative you can use to ready your Laravel environment using Cloudways.

Do note however, that LAMP stack is the most basic setup on any server that let's you run a PHP based website. But the industry has fast evolved to restrict LAMP stack as really a basic solution only. Other popular solutions use LEMP stack where Apache is replaced with the lightweight and powerful Nginx or a stack that utilizes Nginx and Apache together, with powerful caching technologies like Varnish cache etc.

Laravel Contact Form With Email

Saquib Rizwan — Mon, 17 Jul 2017 10:05:57 +0000

Laravel is a popular PHP framework for creating dynamic websites and web application. Laravel offers a wide range of functionalities that take care of routine project requirements such as routing, authentication, sessions and caching. A Contact Us form is another routine functionality present at all websites these days.

In this article, I am going to show you how to easily create a contact form in Laravel with email.

Install Laravel Application

For demonstrating the Laravel contact form, I will be creating and hosting Laravel application on Cloudways. Sign up at Cloudways for free and login to your account. Next:

Create a new server.
Fill in the server and the application details and select Laravel as the application.

That’s it, within a few clicks you have installed and setup a fully functional Laravel application.

Install Laravel Collective HTML Package

To create the form in Laravel, install the laravelcollective/html package for Form facade. Go to the Cloudways platform and open the Server tab. Launch the SSH terminal and login to your server using the Master Credentials.

Now go to the root of your application:

cd applications
cd applicationname/public_html
composer require laravelcollective/html

Now that the package is installed, goto config/app.php file and add the service provider and alias:

config/app.php


'providers' => [
....
'Collective\Html\HtmlServiceProvider',
],
'aliases' => [
....
'Form' => 'Collective\Html\FormFacade',
],

Database Configuration

The next step is to configure the database. Open the Application tab in the Cloudways platform and go to Application Access details. Use these database credentials.

Go to the .env file (located in the application public root folder) and add the credentials there:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE= your.database.name                                                                                                                            
DB_USERNAME= your.database.username                                                                                                                             
DB_PASSWORD= your.database.password

Create Migrations for Contact Us Table

Go to the public root folder of the application and run the following command to create the database migration for creating the Contact Us model.

php artisan make:migration create_contact_us_table

That will create the migration.

After that, go to database/migration/date_ create_contact_us_table.php and add the following code to it.


<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateContactUsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('contactus', function (Blueprint $table) { $table->increments('id'); $table->string('name'); $table->string('email'); $table->text('message'); $table->timestamps(); });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
       Schema::drop("contactus");
    }
}

Now run the following command:

php artisan migrate

Create the Model

Go to the public root folder of the application and type in the following command:

php artisan make:model ContactUS

After successfully creating the ContactUS model, go to app/ContactUS.php and add the following code in the file:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class ContactUS extends Model
{

public $table = 'contactus';

public $fillable = ['name','email','message'];

}

Create the Route

Go to routes/web.php and add the following code to the route:

Route::get('contact-us', 'ContactUSController@contactUS');
Route::post('contact-us', ['as'=>'contactus.store','uses'=>'ContactUSController@contactUSPost']);

Create the Controller

Now create a controller for handling the requests from the routes. Now go to app/Http/Controllers/ContactUSController.php and add the following code to it:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Http\Requests;
use App\ContactUS;

class ContactUSController extends Controller
{
   /**
    * Show the application dashboard.
    *
    * @return \Illuminate\Http\Response
    */
   public function contactUS()
   {
       return view('contactUS');
   }

   /**
    * Show the application dashboard.
    *
    * @return \Illuminate\Http\Response
    */
   public function contactUSPost(Request $request)
   {
       $this->validate($request, [
        'name' => 'required',
        'email' => 'required|email',
        'message' => 'required'
        ]);

       ContactUS::create($request->all());

       return back()->with('success', 'Thanks for contacting us!');
   }
}

Create the View

Everything is now ready and I will now create the layout of the form. Go to resources/views/ and create a file contactUS.blade.php. Place the following code in it:

<!DOCTYPE html>
<html>
<head>
<title>Laravel 5.4 Cloudways Contact US Form Example</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
</head>
<body>

<div class="container">
<h1>Contact US Form</h1>

@if(Session::has('success'))
   <div class="alert alert-success">
     {{ Session::get('success') }}
   </div>
@endif

{!! Form::open(['route'=>'contactus.store']) !!}

<div class="form-group {{ $errors->has('name') ? 'has-error' : '' }}">
{!! Form::label('Name:') !!}
{!! Form::text('name', old('name'), ['class'=>'form-control', 'placeholder'=>'Enter Name']) !!}
<span class="text-danger">{{ $errors->first('name') }}</span>
</div>

<div class="form-group {{ $errors->has('email') ? 'has-error' : '' }}">
{!! Form::label('Email:') !!}
{!! Form::text('email', old('email'), ['class'=>'form-control', 'placeholder'=>'Enter Email']) !!}
<span class="text-danger">{{ $errors->first('email') }}</span>
</div>

<div class="form-group {{ $errors->has('message') ? 'has-error' : '' }}">
{!! Form::label('Message:') !!}
{!! Form::textarea('message', old('message'), ['class'=>'form-control', 'placeholder'=>'Enter Message']) !!}
<span class="text-danger">{{ $errors->first('message') }}</span>
</div>

<div class="form-group">
<button class="btn btn-success">Contact US!</button>
</div>

{!! Form::close() !!}

</div>

</body>
</html>

The contact form is now functional.

On submitting the form, the data will be stored in the database. The next step is of make the form email the information.

Now create another view, email.blade.php and add the following code in it.

You received a message from : {{ $name }}

<p>
Name: {{ $name }}
</p>

<p>
Email: {{ $email }}
</p>

<p>
Message: {{ $user_message }}
</p>

Sending the Email

To understand the steps involved in this step, read sending email in Laravel. Now that you have read the steps, it is time to implement the process. First, setup the basic Laravel mail function through PHP Artisan. Use the following command in the terminal:

php artisan make:mail <name of mailable>

After that, login to your Gmail account. Under My account > Sign In And Security > Sign In to Google, enable two-step verification, and then generate the app password. Next, add the app password in the .env file with the following configurations.

MAIL_DRIVER=smtp

MAIL_HOST=smtp.gmail.com

MAIL_PORT=587

MAIL_USERNAME= your.email@gmail.com

MAIL_PASSWORD= your.generated.app.password

MAIL_ENCRYPTION=tls

Now that the configuration is done, update ContactUsController.php with the following code:

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\Http\Requests;
use App\ContactUS;
use Mail;

class ContactUSController extends Controller
{
   public function contactUS()
{
return view('contactUS');
} 
   /** * Show the application dashboard. * * @return \Illuminate\Http\Response */
   public function contactUSPost(Request $request) 
   {
    $this->validate($request, [ 'name' => 'required', 'email' => 'required|email', 'message' => 'required' ]);
    ContactUS::create($request->all()); 

    Mail::send('email',
       array(
           'name' => $request->get('name'),
           'email' => $request->get('email'),
           'user_message' => $request->get('message')
       ), function($message)
   {
       $message->from('saquib.gt@gmail.com');
       $message->to('saquib.rizwan@cloudways.com', 'Admin')->subject('Cloudways Feedback');
   });

    return back()->with('success', 'Thanks for contacting us!'); 
   }
}

The contact form is now ready for deployment. It will save the data in the database and email it to the given email address as well. To test the Contact Us form, go to the application and click on Launch Application (remember to add /contact-us to the URL).

Check the DEMO to see the application in action.

The Final Words

In this tutorial, I showed you how to create a contact form in Laravel with the functionality of emailing the information to a prespecified email address.

Database Level CRUD Operations Using PDO

Saquib Rizwan — Mon, 22 May 2017 10:58:08 +0000

No real world PHP application could function without a database.

This is why PHP offers three powerful ways of manipulating and interacting with databases. The list comprises of MySQL, MySQLi and PDO.

To remove all the problems caused by these different database management approaches, PHP has standardized PHP Data Objects (PDO) as the database layer of choice. PDO provides easy and very streamlined interface for interacting with the databases in the PHP applications. To work with PDO, the database specific driver(s) must be installed.

Supported Databases

PDO supports all popular databases through specific drivers. In effect, the following database drivers are available in PDO.

Cubrid (PDO_CUBRID)
FreeTDS / Microsoft SQL Server / Sybase (PDO_DBLIB)
Firebird (PDO_FIREBIRD)
IBM DB2 (PDO_IBM)
IBM Informix Dynamic Server (PDO_INFORMIX)
MySQL 3.x/4.x/5.x (PDO_MYSQL)
Oracle Call Interface(PDO_OCI)
ODBC v3 (IBM DB2, unixODBC and win32 ODBC) (PDO_ODBC)
PostgreSQL (PDO_PGSQL)
SQLite 3 and SQLite 2 (PDO_SQLITE)
Microsoft SQL Server / SQL Azure (PDO_SQLSRV)
4D (PDO_4D).

By default, PHP has a PDO_SQLite driver installed. However, if you wish to work with other databases, you must first install the relevant driver.

In order to check which drivers are installed on your system, create a new PHP file, and add the following code to it:

<?php
print_r(PDO::getAvailableDrivers());
?>

Performing CRUD Operations Through PDO

PDO is the best way of performing CRUD and related DBMS operations in PHP because PDO standardizes code that can be reused without major issues. In effect, PDO acts as an abstraction layer that separates database related operations from the rest of the code.

Database Connections

Connectivity in PDO is simple. Consider the following code snippet that is used to set up connections with a database. Note that when the underlying database changes, the only change that you need to make in this code is the database type.

 <?php

Class Connection {

private  $server = "mysql:host=localhost;dbname=cloudways";
private  $user = "root";
private  $pass = "";
private $options  = array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,);
protected $con;
       public function openConnection()
       {
            try
            {
            $this->con = new PDO($this->server, $this->user,$this->pass,$this->options);
            return $this->con;
             }

catch (PDOException $e)
             {
                                                echo "There is some problem in connection: " . $e->getMessage();
              }
                }
public function closeConnection() {
        $this->con = null;
    }

}
?>

In the above code snippet, notice that the database is MySQL. However, if you need to change the database to MS SQL Server, the only change will be the replacement of mysql with mssql.

Note: PDO can handle exceptions. Therefore, always wrap its operation in a try and catch block.

Table Creation

To create a table, I will first declare a query string and then execute it with exec function. Note that this will not return any data.

<?php
include_once 'connection.php';
try
{
                $database = new Connection();
                $db = $database->openConnection();

                // sql to create table
                $sql = "CREATE TABLE `Student` ( `ID` INT NOT NULL AUTO_INCREMENT , `name`VARCHAR(40) NOT NULL , `last_ame` VARCHAR(40) NOT NULL , `email` VARCHAR(40)NOT NULL , PRIMARY KEY (`ID`)) ";

                // use exec() because no results are returned
                $db->exec($sql);
                echo "Table Student created successfully";

                $database->closeConnection();
}
catch (PDOException $e)
{
                echo "There is some problem in connection: " . $e->getMessage();
}

?>

Data Insertion

To insert data into a table using PDO, I will first use prepared statements to protect the query from SQL injections. Next, I will execute this query with the execute function.

<?php
include_once 'connection.php';
try
{
                $database = new Connection();
                $db = $database->openConnection();

                // inserting data into create table using prepare statement to prevent from sql injections
                $stm = $db->prepare("INSERT INTO student (ID,name,last_name,email) VALUES ( :id, :name, :lastname, :email)") ;

    // inserting a record
    $stm->execute(array(':id' => 0 , ':name' => 'Saquib' , ':lastname' => 'Rizwan' , ':email' => 'saquib.rizwan@cloudways.com'));

                echo "New record created successfully";
}

catch (PDOException $e)
{
                echo "There is some problem in connection: " . $e->getMessage();
}
?>

Select Data

In order to select data, first create a query string and then execute it in a foreach loop to fetch records from the table:

<?php
include_once 'connection.php';
try
{
                $database = new Connection();
                $db = $database->openConnection();
                $sql = "SELECT * FROM student " ;
                foreach ($db->query($sql) as $row) {
            echo " ID: ".$row['ID'] . "<br>";
            echo " Name: ".$row['name'] . "<br>";
            echo " Last Name: ".$row['last_name'] . "<br>";
            echo " Email: ".$row['email'] . "<br>";
        }

}

catch (PDOException $e)
{
                echo "There is some problem in connection: " . $e->getMessage();
}

?>

Update Data With PDO

In order to update a record in the table, first, declare a query string, and then execute it with exec function.

<?php
include_once 'connection.php';
try
{
                $database = new Connection();
                $db = $database->openConnection();
                $sql = "UPDATE `student` SET `name`= 'yourname' , `last_name` = 'your lastname' , `email` = 'your email' WHERE `id` = 8" ;
                $affectedrows  = $db->exec($sql);
    if(isset($affectedrows))
    {
                echo "Record has been successfully updated";
    }       
}
catch (PDOException $e)
{
                echo "There is some problem in connection: " . $e->getMessage();
}
?>

Delete Data With PDO

In order to delete a record from the table, first declare a query string and then execute it with exec function.

<?php
include_once 'connection.php';
try
{
                $database = new Connection();
                $db = $database->openConnection();
                $sql = "DELETE FROM student WHERE `id` = 8" ;
                $affectedrows  = $db->exec($sql);
    if(isset($affectedrows))
    {
                echo "Record has been successfully deleted";
    }       
}
catch (PDOException $e)
{
                echo "There is some problem in connection: " . $e->getMessage();
}
?>

Conclusion

PDO is the data access layer that greatly streamlines the process of connecting and working with databases. Using PDO, you could easily carry out all database related operations without dealing with the nitty-gritty of database level problems. If you have questions or would like to add to the discussion, do leave a comment below