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[]="
  • $row[nome]
  • "; } $y=implode("", $x); mysql_close($con); return $y; } function getImages($product, $limit) { $db = connetti(); try { $results = $db->prepare('SELECT * FROM productImages WHERE product = ? ORDER BY itemOrder LIMIT ?'); $results->bindParam(1, $product, PDO::PARAM_INT); $results->bindParam(2, $limit, PDO::PARAM_INT); $results->execute(); } catch(Exception $e) { echo $e->getMessage(); die(); } if($limit == 1) $images = $results->fetch(PDO::FETCH_ASSOC); else $images = $results->fetchAll(PDO::FETCH_ASSOC); return $images; } function make_thumb($src, $dest, $desired_height) { $source_image = imagecreatefromjpeg($src); $width = imagesx($source_image); $height = imagesy($source_image); $desired_width = floor($width * ($desired_height / $height)); $virtual_image = imagecreatetruecolor($desired_width, $desired_height); imagecopyresampled($virtual_image, $source_image, 0, 0, 0, 0, $desired_width, $desired_height, $width, $height); imagejpeg($virtual_image, $dest); }