This, That & Everything: PHP

Getting started with Codeigniter - Creating a CRUD Application

You can find the Source code of this article here.

Howdy Guys?This time I'll bring you another awesome PHP framework.CodeIgniter you heard it don't you? Well in this tutorial I am going to discuss basic configuration we need to have in CodeIgniter and then we move on to create a simple CRUD application.
It is a cool little framework. It is so popular among the developers because of it's simple and easy structure which provide a way to build basic operations fast and with less coding.Also it's a good framework for developers who familiar with PHP but getting start on a PHP framework for the first time.
Install the CodeIgniter if you don't have done it already.It's a really simple process and follow this if you need any help.
Now we'll look at file structure inside CodeIgniter. There is 3 main folders and index.php file.

application - This is where we create and update all the application specific changes.
system - This contains the core of the Framework.
user_guid - This contains the documentation of the CodeIgniter.
index.php - serves as the front controller, initializing the base resources needed to run CodeIgniter. Also it allows you to change the name and path of the application and sustem folders.

Ok folks let's get stat with configuring the database.Open Application/config/database.php file and change below values according to your database configuration.

Well not so much crux there ay? Just a simple configuration setting that any developer can understand.

It's time to create our first Controller. Go to application/controller folder and create Customer.php file.

What it does is create a new model by extending CI_Model and load the database library.So that you have the database class available via $this->$db object.

Then we'll create a method to get list of all the customer detail or one specific customer detail.

Here we use CodeIgniter's Query Builder.It make it possible to write your query once and make it use on all the available databases.To get good idea about Query Builder I recommend you to read this article.

$query = $this->db->get('customer'); line is same as select * from customer

and this

$query = $this->db->get_where('customer', array('username' => $username)); is same as
select * from customer where username='$username';

Pretty simple, Isn't it. Ok Now we are going to create the controller.Go to application/controller and create Customer.php file.

Here we create a Controller call 'Customer' and extend CI_Controller class.This controller is what become the center of your every request to your app.

Then the __construct() method: It calls the constructor of its parent class (CI_Controller) and loads the model, so it can be used in all other methods in this controller.

index method, First it invoke the get_customer method then assign a title to the page and finally load the view.

The view method,Unlike index method it pass $username as a argument and same as index method it calls the get_customer method,assign a value to the $title and load the view page.

Now lets create two view pages for these two method.Go to application/view folder and create a folder name customer inside that create a index.php file for index method.

Then create a view.php file for view method.

Since we are in view section we'll create another two pages for create and edit purpose.create a create.php file.

Then create edit.php file.

form_open function is use to render the form element and it's provide by form helper.form_validation is use to report errors related to form validation.

Go back to Customer.php and create a new method name create and add below code.

First we load the form helper which is use by form_open and then we load the form validation library.After loading those two we use set_rules method to add form validation rules.

$this->form_validation->set_rules('username', 'Username', 'required');

First argument is for name of the input field, second one is for the name that should use in error message and last one is the rule.

after form validation and if it's according to the rules we set method will invoke the set_customer method.

Now lets create edit method.

It's almost same as create method.only difference is,It take $username as argument and call get_customer method to show the initial values of the customer that you select and it invoke the update_customer method.

Since we are done with model methods we'll create set_customer method and update_customer methods.Open the Customer_model.php and create set_customer method.

Here we first take POST values and store it in $data array and we insert it to the customer table.

Finally we'll add the delete functionality to our app.In Customer_model.php create a method name delete_customer and add below code.
Inside Cutomer.php file create method call delete and put below code segment.
Guys we are almost over only thing left if create proper routing configuration.If you look at .htascces file inside application folder.It deny all the....
So we'll create a new .htaccess file in our root folder.

RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php/$1 [L]

Then go to application/config and open config.php file.change

$config['index_page'] = 'index.php';
to
$config['index_page'] = "";

Ok.Now we set the rules for routes.
open routes.php file inside application/config folder change the $route arrays values as below

$route['customer/index'] = 'customer/index';
$route['customer/create'] = 'customer/create';
$route['customer/view'] = 'customer/view';
$route['customer'] = 'customer';
$route['(:any)'] = 'customer/index';
$route['default_controller'] = 'customer/index';

I guess it's simple to understand and if you want to know more about CodeIngiter routing reffer this article.

So if you open your browser and go to

'Your_server'/root/customer or 'Your_server'/root/customer/index

will navigate you to the customer index(list) page and if you click any (View/Edit/Delete) link on Customer List it will bring you to the that particular customer operations respectively.

Note

I have add two more view files in source code project. header.php and footer.php. As name suggest those two will serve as header and footer for the each page.
I created another view file success.php to show a success message when ever operation is finished without errors.
I used bootstrap CSS and update font end html tags accordingly, to have a finished product.

2:19:00 PM
9 Comments

CRUD Application with AngularJS

AngularJS

This tutorial will teach you how to create a CRUD Application using AngularJS,PHP,MySQL and Slim framework.
You can find the source code of this article here

AngularJS is a Java Script framework for dynamic web apps.It lets you extend HTML tags.

Slim is a PHP micro framework which we are going to use for create REST service in php.

Below you can find file structure of the Application.

js - This folder include all the JavaScript files we use here.
api - This folder will contain Slim framework.
pages - This folder contains all the front end pages.

well let's get started with Installing Slim framework inside api folder . Follow the link, If you have any doubts over how to installing it. It's fairly easy process and I am not going write it in detail here.

After installing Slim you'll get a folder call Slim inside api folder.we'll leave it there for the current been.

Next create the index.html file and put below code segment inside it.

Well lets go through this code. We load AngularJS to our app and remember we have to load the angular-route.js too.I will tell you why later in this tutorial. Optionally I load bootstrap style sheet to have to have some sort of user friendly front end

<body ng-app="Application">

You can say this as a starting point of a Angular Application. ng-app directive responsible for auto-bootstrap angular application.

<div ng-view></div>

This directive is simply responsible for View of the Application.

Now inside JS folder create app.js file.

Here we have our 'Application' module.

In First line we declare our module.In this case it's Application. Second argument is a array. It consist of dependencies for the module.Here we need 'ng-Route' since it is the module that responsible for provide routing and deeplinking services and directives for angular apps.

Rest of the code is for set routs for the App.$routeProvider use for configuring routes.I recommend you to go through above link to get a better understand about $routeProvider. Actually this is where we need above discussed 'ng-Route' module to be installed as a dependency for $routeProvider.

Lets we move on to create our first Controller.

This is the controller for get the list of customer details.

AngularJs application are controlled by Controllers. 'CustomerListControler' is a JavaScript function and $scope is the application object. Which means it owns the application variable and objects.

$http use to communicate with web servers.

$http.get is the function use to read the server data and those data will store in property call customers.

What we have here is Controller for add a new customer.

One of new thing we come across here is $location. $location service parses the URL in the browser address bar and makes the URL available to your application.Changes to the URL in the address bar are reflected into $location service & changes to $location are reflected into the browser address bar.

Then we move onto create 'CustomerEditController', The Controller that will responsible for handle Edit and Delete.

Hm..looks like we don't have anything new to discuss here. So we'll move on to create database handling section.

Go to index.php file inside Slim folder.

In first two lines we call & create instance of Slim. Then comes the interesting part of Slim's route handling.As you can see it's really easy to understand .That is the one of main reason we use Slim framework here.If you want to know more about Slim routing follow this

Then we'll create actual database connection & database handling.

Now we almost end.All you have to do is create frond end pages for add,update and detailed list of customers.
Go to pages folder and create list.html,new.html and edit.html files
Well..It's done guys.Now we have your own little AngularJS application whichcapable of doing CRUD operation.I hope you enjoy the tutorial.
Happy coding.

You can find the source code of this article here

11:35:00 AM
29 Comments

Send Emails With PHPMailer Library

PHP

May it be an email sent to the customer, a confirmation email sent to your agent, or any requirement as such, systems which are being developed now a days incorporate extensive emailing facilities. Almost all the systems developed lately contain email functions and obviously the demand for this feature will increase drastically day by day.

The challenge we, PHP developers, have got in hand is to find an answer to the question “How do we tackle this requirement effectively?”. One might immediately say “Simple! Why not try out the PHP’s inbuilt email function?”. Well, let’s be honest, that’s a good answer, but not the BEST.The smartest answer is “PHPMailer Library”.

mailer() function; php inbuilt function for sending E-mail, hide a lot of underlying mechanism of it from developer while PHPMailer function gives the developer a vast play ground with all the fancy and cool (+geeky) stuff to play around with.

Let’s see how to deal with PHPMailer library.

First of all, you have to install and load the PHPMailer library. We can do this via Composer. All you have to do is, open your command prompt, go to your project folder and type

composer require phpmailer/phpmailer:~5.2

This will install PHP Mailer to your system and a folder named “vendor” will be created inside your project folder.

Here's a look at the inside of PHPMailer folder. Most vital files are listed below

class.phpmailer.php -Includes all the PHPMailer methods
class.pop3.php - Handles the POP functions
class.smtp.php - Handles the SMTP functions
PHPMailerAutoload.php -Handles the loading of the library. This is a SPL-compatible auto loader and using of this file is the preferred way of loading the library.

Lets start with loading PHPMailer library to our program.

require ('vendor/autoload.php');

That’s it..You are good to go with PHPMailer now. Important thing to note here is autoload class does not throw errors if it can't find classes,it keeps a list of errors, allowing you to use your own method to handle those errors.

STEP ONE - Create an instance of PHPMailer

$mail = new PHPMailer();

or better

$mail = new PHPMailer(true);

The “true” parameter means it will throw exceptions on errors, which we need to catch.

STEP TWO - Choice of protocol

We can chose either SMTP or POP protocol. In this tutorial we are going to use SMTP.

$mail = IsSMTP();

calling IsSMTP method tells PHPMailer that, this is the protocol we are going to use.

$mail->SMTPDebug = true

This enables the SMTP debug information. you can set this to true or false.

$mail->SMTPAuth = true;

This enables the SMTP authentication.If you set this to “false” there is no authentication. So you don’t need to set username or password parameters.(We are going to discuss about these parameters later)

STEP Three -Set up SMTP Server and related configuration

$mail->SMTPSecure = "tls";

you can use either “ssl” or “tls”. This configuration depends on your choice of SMTP server. If you are using gmail as your smtp server this should be set to “tls”. (SSL and TLS both provide a way to encrypt a communication channel between two computers )

$mail->Host = “smtp.gmail.com”

Set the gmail as your SMTP server.

$mail->Port=587;

Set the smtp port to access gmail server. Again this port number depends on your SMTP server.(for gmail server it’s 587)

$mail->Username = “GMAIL username”;

$mail->Password = “GMAIL password”;

If you set the authentication to “true” [SMTPAuth = true] you have to set both these parameters to connect with Gmail smtp server.

STEP Four - Set up E-mail parameters

$mail->SetFrom(“FROM_EMAIL ADDRESS”, “FROM_NAME”);

This will set the From address and name

$mail->AddReplyTo(“REPLY_EMAIL_ADDRESS”, “REPLY_NAME”);

If you set this, all the replies from the Email recipient will be sent to this address.

$mail->Subject = 'Subject of the Email';

This will Set the subject line.

$mail->AddAddress(“TO_EMAIL_ADDRESS”, “TO_NAME”);

Email address and name of the Email recipient.

$mail->AddCC(“CC_EMAIL”, “CC_NAME”);
$mail->AddBCC(“BCC_EMAIL”, “BCC_NAME”);

These will set the CC and BCC option related with Email sending

$mail->msgHTML(“HTML Message Content”);

This method initiate IsHTML() method to true(which means, this method processes Email body as a HTML content) and evaluates the message and returns modifications for inline images and backgrounds.

As an alternative to above method we can use,

$mail->AltBody = 'This is a plain-text message body';

Which returns plain text only Email body.

$mail->addAttachment('path_of_the_attachment file',’name of the file’);

(optionally you can add two more parameters to this method,

“encryption type” and “file type”. note that name parameter is optional too)

$mail->Send();

This is the End. This method creates message body and assigns Mailer. If the Email is not sent successfully then it returns false.

Finally we’ll look at our completed code.Here I have added PHPMailer exception handling too.

$FROM_NAME= "from_name";

$FROM_EMAIL=”from_email@gmail.com”;

$REPLY_EMAIL=”reply@gmail.com”;

$REPLY_NAME=”ReplyName”;

$CUSTOMER_EMAIL=”john@doye.com”;

$CUSTOMER_NAME=”John Doye”;

$CC_EMAIL="cc_email";

$CC_NAME = “cc_name”;

$GMAIL_USER_NAME=”username”;

$GMAIL_PASSWORD=”password”;

$Subject=”PHPMailer Email”;

$Message=”<h3>PHPMailer tutorial</h3><p>This tutorial will teach you how to send a email with PHPMAiler library</p><h4>Happy coding </h4>”;

$mail = new PHPMailer(true);

$mail->IsSMTP();

try{

$mail->SMTPDebug = true;

$mail->SMTPAuth = true;

$mail->SMTPSecure = "tls";

$mail->Host="smtp.gmail.com";

$mail->Port=587;

$mail->Username=$GMAIL_USER_NAME;

$mail->Password=$GMAIL_PASSWORD;

$mail->SetFrom(FROM_EMAIL,FROM_NAME);

$mail->AddReplyTo($REPLY_EMAIL, $REPLY_NAME);

$mail->AddAddress($CUSTOMER_EMAIL, $CUSTOMER_NAME);

$mail->AddCC($CC_EMAIL,$CC_NAME);

$mail->Subject = $Subject;

$mail->MsgHTML($Message);

$mail->Send();

} catch (phpmailerException $e) {

echo $e->errorMessage();

} catch (Exception $e) {

echo $e->getMessage();

}

Conclusion

Now we have a fully functioning mailer class. All you have to do is create a nice front end file like “Contact Us” or “Write to us” and submit it to above class we created. Fun part is, inside message body you can use any HTML tag you like and format your Email body in anyway you want.

Of Course PHPMailer is slightly slower than php in built mailer() function.But if you are looking for nicely formatted emails to be sent to a list of targeted recipients each day PHP Mailer is your best bet.

You can find the source code of this article from GitHub.

5:01:00 AM
0 Comments

Pages

This, That & Everything

Getting started with Codeigniter - Creating a CRUD Application

CRUD Application with AngularJS

Send Emails With PHPMailer Library

About me

Follow Me

Press

Labels

recent posts

Blog Archive

Popular Posts