Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function saveImage($name,$image_name){
- $stmt = $this->db->prepare("INSERT INTO images(image_name,image_image)
- VALUES(:name, :image_name)");
- $stmt->bindparam(":name", $name);
- $stmt->bindparam(":image_name", $image_name);
- $stmt->execute();
- return $stmt;
- }
- public function getImages(){
- $limit = 50;
- $stmt = $this->db->prepare("SELECT * FROM images ORDER BY image_id DESC LIMIT :limit");
- $stmt->bindParam(':limit', $limit, PDO:: PARAM_INT);
- $stmt->execute();
- if ($stmt->rowCount() > 0) {
- $stmt->setFetchmode(PDO::FETCH_ASSOC);
- $iterator = new IteratorIterator($stmt);
- foreach ($iterator as $row) {
- echo '<div class="articles"><img src="images/'.$row['image_name'].'"';
- echo '</div>';
- }
- }
- else {
- echo "Er zijn geen foto's";
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement