How can a PHP script randomly select and display a banner image from a database on an HTML page?

To randomly select and display a banner image from a database on an HTML page using PHP, you can first query the database to fetch all banner images, then use the rand() function to select a random image from the result set. Finally, display the selected banner image on the HTML page using an <img> tag with the src attribute set to the image URL. 

&lt;?php
// Connect to the database
$pdo = new PDO(&#039;mysql:host=localhost;dbname=your_database&#039;, &#039;username&#039;, &#039;password&#039;);

// Fetch all banner images from the database
$statement = $pdo-&gt;query(&quot;SELECT * FROM banners&quot;);
$banners = $statement-&gt;fetchAll();

// Select a random banner image
$randomBanner = $banners[array_rand($banners)];

// Display the selected banner image on the HTML page
echo &#039;&lt;img src=&quot;&#039; . $randomBanner[&#039;image_url&#039;] . &#039;&quot; alt=&quot;Banner Image&quot;&gt;&#039;;
?&gt;

Keywords

PHP database random selection banner image HTML page

Related Questions