Question

PHP

how a database query compares the submitted information against the stored information.

Discuss why sessions are generally more secure than cookies and can store much more information.

Discuss the merits of using object-oriented programming (OOP) with the PHP. Also, compare the benefits of using OOP over procedural programming.

Answer 1

How a database query compares the submitted information against the stored information

• When the server receives the query , there are number of steps are taking place.
• The query processing starts with parsing the query.
• Then it will optimize the query based on several optimization methods.
• There is a query execution plan, which tells how to execute a query.
• Then next two stages are logical and physical processing stages.
• In logical processing stage, the order of processing of different clauses in the query is determined.
• The physical processing stage includes query compilation which include the generation of execution plan.
• After completing all these steps, query is executed according to the plan and we get the result back.

Why sessions are generally more secure than cookies and can store much more information :

• Sessions are more secure than cookies , because sessions are stored in server.
• A Session is associated with every user.
• Cookies are stored in the machine of client.
• Cookies are sent to server based on the request.
• Sessions cannot be modified easily, because they are on server.
• Cookies can be easily modified, which is too risky.
• Cookies can be used to identify sessions.

Merits of using object-oriented programming (OOP) with the PHP :

• The merits of using object oriented concepts in PHP is code re-usability, encapsulation, polymorphism, inheritance etc..
• Encapsulation means hiding the inner details by binding data and function together.
• Polymorphism means ability to exist in different forms.
• Inheritance is the process by which a class inherits the properties of other class.
• Object oriented concept is mainly useful in constructing real world applications.

Benefits of using OOP over procedural programming :

• Easy to develop a real world application.
• Reusability of code.
• Data can be protected by specify access criteria such as public, private, protected etc..
• Same operator or function can be given different meanings , means polymorphism.