Object Oriented PHP and PDO

[RyanMinor]

Hi everyone,

 

It was recommended that I should make the switch from using procedural code to object oriented code with pdo for queries and such. So, I have been doing some reading on both topics, but am finding it rather hard to wrap my head around. I managed to get a PDO query to work with the help of a tutorial that I found online. My next step is to create an object oriented member registration class. I was wondering if anyone on here could provide any advice as far as the setup goes. I will want my member class to be able to:

1) connect to db

2) gather, validate, and send user data to payment processor

3) receive postback data, insert into database, and notify new member.

 

I have already created these functionalities for other websites using procedural coding so once I get pushed in the right direction I should be find to add the other functionalities, which will include

4) Logging a member in

5) Logging a member out

6) Update member information

7) Change password

Forgot password

9) Cancel membership

 

Below is my snippet of PDO code that I wrote. Let me know if you guys would do anything differently. I really appreciate your help in this.

 

<?php
// DECLARE DATABASE CONNECTION VARIABLES //
$host = 'localhost';
$database = 'database';
$username = 'user';
$password = 'password';
// CONNECT TO DATABASE //
try {
$connect = new PDO("mysql:host=$host;dbname=$database", $username, $password);
}
catch(PDOException $e) {
echo $e->getMessage();
}


$sql = "SELECT siteInfoPage, siteInfoKeywords, siteInfoDescription FROM siteInfo WHERE siteInfoPage = '$page'";
// FETCH INTO A PDOStatement OBJECT //
$query = $connect->query($sql);
// ECHO THE NUMBER OF COLUMNS //
$data = $query->fetch(PDO::FETCH_OBJ);
// ASSIGN TO VARIABLES
$page_title =  $data->siteInfoPage;
$keywords = $data->siteInfoKeywords;
$description = $data->siteInfoDescription;

// CLOSE THE DATABASE CONNECTION //
$connect = null;

?>