raldje

$donnees = $stmt->fetch_all(); Fatal error: Call to undefined method PDOStatement::fetch_all()

<?php $stmt = $bdd->query('SELECT image FROM matable'); $donnees = $stmt->fetchAll(); var_dump($donnees); $images = $donnees['image']; echo '<img src="image/'.$images.'" id="my-image" />'; ?> <script type="text/javascript"> var imgs = new Array( <?php for ($i = 0; $i < count($images); $i++) { echo '"'. htmlspecialchars($images[$i]) .'"'; if ($i < count($images) -1) { echo ','; } } ?> ); var position = 0; var taille = imgs.length; var image = document.ge

Exactly what i'm looking for, but i don't know how to do. I tried different way to do this without success.

Happy new year everybody. Thank you Dsonesuk, it's work. Is it possible to do it without ajax?

I'l try to explain with more precision. In my table i have several entries of event, some with image, some without I also have an image by default . I try to make a header with all the present images in my table switching every 10 seconds, or my image by default if no event or only events without image.

$rst = $bdd->query('SELECT image from matable order by Rand() LIMIT 0, 1'); while($donnees = $rst->fetch()) { $image = nl2br($donnees['image']); echo '<img src="defaultimg.jpg" alt="image_by_default" id="img1"/>'; echo '<img src="image/'.$donnees['image'].'" alt="image" id="img2"/>'; } $rst->closeCursor(); <script> var x=1; var myVar = setInterval(myTimer, 1000); function myTimer() { if(x%2==0){ document.getElementById("img1").style.display = "none"; document.getElementById("img2").style.display = "block"; x=1; } else{ document.getEle

$rst = $bdd->query('SELECT image from matable order by Rand() LIMIT 0, 1'); while($donnees = $rst->fetch()) { $image = nl2br($donnees['image']); echo '<img src="defaultimg.jpg" alt="image_by_default" id="img1"/>'; echo '<img src="image/'.$donnees['image'].'" alt="image" id="img2"/>'; } $rst->closeCursor(); <script> var x=1; var myVar = setInterval(myTimer, 1000); function myTimer() { if(x%2==0){ document.getElementById("img1").style.display = "none"; document.getElementById("img2").style.display = "block"; x=1; } else{ document.getEle

Hi, first sorry for my english, i'm french i got a table in my database to announced events with this fields: id, event_date, announce, image. I want to make a header with images changing each 10 secondes, but i don't want to refresh all the page. This is what i use actually: $rst = $bdd->query('SELECT image from matable order by Rand() LIMIT 0, 1'); while($donnees = $rst->fetch()) { $image = nl2br($donnees['image']); if (empty($image)) { echo '<img src="imagedefaut.jpg" />'; } else { echo '<img src="image/'.$donnees['image'].'" alt="image"/>'; } } $rst->