IDIOT DEVELOPER

Querying Data using PDO (PHP Data Object)
Querying Data using PDO (PHP Data Object)

This article is about fetching or retrieving data from the database using PDO (PHP Data Object). So if you are new to PDO then see some of my previous post.   1. Introduction to PDO 2. Connecting to Database using PDO 3. Exceptions in PDO 4. Prepared Statement in PDO .   Querying data is […]

Read More
Prepared Statement in PDO (PHP Data Object)
Prepared Statement in PDO (PHP Data Object)

A prepared statement is a precompiled SQL statement that can be executed multiple times by sending just the data to the server. It has the added advantage of automatically making the data used in the placeholders safe from SQL injection attacks.   Using prepared statements will help protect you from SQL injection.   PDO supports […]

Read More
Exceptions in PDO (PHP Data Object)
Exceptions in PDO (PHP Data Object)

In some of the previous posts, we have learn about the PDO (PHP Data Object). In this article we are going to deal with Exceptions in PDO. It is always necessary to wrap a PDO statement in a try/catch block. As there can be chance that any error may occur, so to handle those errors we […]

Read More
User Login System in PHP using PDO
User Login System in PHP using PDO

In the previous post, we have made  User Registration System in PHP Using PDO. In this post we going to build a User Login System in PHP Using PDO with better password encryption, which has an advantage of working on different database systems. PDO is a PHP extension that allow us to implement code which is […]

Read More
User Registration System in PHP Using PDO
User Registration System in PHP Using PDO

In this post we are going to learn about creating a user registration system in PHP using PDO for database connection. As we new PDO is a new technology, and is more secure than MySql and MySqli.   User Table Structures   CREATE TABLE `users` ( `uid` int NOT NULL PRIMARY KEY AUTO_INCREMENT , `name` […]

Read More
Introduction to PDO (PHP Data Object)
PDO (PHP Data Obejct)

Many PHP programmers learned how to access databases by using either the MySQL or MySQLi extensions. As of PHP 5.1, there’s a better way. PHP Data Objects (PDO) provide methods for prepared statements and working with objects that will make you far more productive!   PDO is an acronym for PHP Data Objects. PDO is […]

Read More