proscar Posted December 20, 2012 Report Share Posted December 20, 2012 Hi I would like to connect my shopping cart PHP website on MVC pattern through PDO format, can you help me? Quote Link to comment Share on other sites More sharing options...
falkencreative Posted December 20, 2012 Report Share Posted December 20, 2012 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/ Quote Link to comment Share on other sites More sharing options...
proscar Posted December 21, 2012 Author Report Share Posted December 21, 2012 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.