How To Connect Php Mysql To Database Through Pdo Format

[proscar]

Hi

I would like to connect my shopping cart PHP website on MVC pattern

through PDO format, can you help me?

[falkencreative]

Hi

I would like to connect my shopping cart PHP website on MVC pattern

through PDO format, can you help me?

This tutorial has a pretty good overview of PDO and how to use it: http://net.tutsplus.com/tutorials/php/why-you-should-be-using-phps-pdo-for-database-access/

[proscar]

Thanks for the reply

Now I have the error:

Undefined property: PDOStatement::$num_rows

for the following:

 

public function get_categories($id = NULL){

$data = array();

if ($id != NULL){

// get specific category

if ($stmt = $this->dbh->prepare("SELECT id, name FROM "

. $this->db_table . " WHERE id = ? LIMIT 1")){

$stmt->bind_param("i", $id);

$stmt->execute();

$stmt->store_result();

 

$stmt->bind_result($cat_id, $cat_name);

$stmt->fetch();

 

if ($stmt->num_rows > 0){

$data = array('id' => $cat_id, 'name' => $cat_name);

}

$stmt->close();

}

}

else {

// get all categories

if ($result = $this->dbh->query("SELECT * FROM " .

$this->db_table . " ORDER BY name")){

if ($result->num_rows > 0){

while ($row = $result->fetch_array()){

$data[] = array('id' => $row['id'], 'name' => $row['name']);

}

}

}

}

return $data;

}

 

How can I sort this out?

Thanks