function connetti() { try { $db = new PDO("mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . "", DB_USER, DB_PASS); } catch(PDOException $e) { echo $e->getMessage(); } return $db; } function getCatInfo($id){ $db = connetti(); try { $results = $db->prepare('SELECT * FROM categorie WHERE id = ?'); $results->bindParam(1, $id); $results->execute(); } catch(Exception $e) { echo $e->getMessage(); die(); } return $results->fetch(PDO::FETCH_ASSOC); } function getSlider($i) { $db = connetti(); try { $results = $db->prepare('SELECT id, categoria, image, title, itemOrder FROM imageSlider WHERE categoria = ? ORDER BY itemOrder'); $results->bindParam(1, $i); $results->execute(); } catch(Exception $e) { echo $e->getMessage(); die(); } $itemNumber = $results->rowCount(); $itemSlider = $results->fetchAll(PDO::FETCH_ASSOC); return array("itemNumber" => $itemNumber, "itemSlider" => $itemSlider); } function getProductImages($i) { $db = connetti(); try { $results = $db->prepare('SELECT * FROM productImages WHERE product = ? ORDER BY itemOrder'); $results->bindParam(1, $i); $results->execute(); } catch(Exception $e) { echo $e->getMessage(); die(); } $itemNumber = $results->rowCount(); $itemProducts = $results->fetchAll(PDO::FETCH_ASSOC); return array("itemNumber" => $itemNumber, "itemProducts" => $itemProducts); } function subcat($id) { $con = connetti(); $query = "SELECT id,nome FROM subcat WHERE catID='$id' ORDER BY nome ASC"; $result = mysql_query($query, $con); while ($row = mysql_fetch_array($result)) { $x[]="