Code: Select all
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>jQuery Slideshow</title>
<script type="text/javascript" src="jquery-1.11.3.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$('.fadein img:gt(0)').hide();
setInterval(function(){
$('.fadein :first-child').fadeOut()
.next('img').fadeIn()
.end().appendTo('.fadein');},
3000);
});
</script>
<style type="text/css">
.fadein { position:relative; width:500px; height:332px; }
.fadein img { position:absolute; left:0; top:0; }
</style>
</head>
<body>
<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');
// Connects to your Database
include("conf.php");
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
mysql_select_db($db) or die ("Unable to select database!");
//Retrieves data from MySQL
$data = mysql_query("SELECT * FROM vehicles") or die(mysql_error());
echo "<div class=\"fadein\">";
while($info = mysql_fetch_array( $data ))
{
//Outputs the image and other data
echo "<img src='data:image/jpeg;base64,".base64_encode($info['image'])."'>";
echo "<br>";
echo $info['year'];
}
echo "</div>";
?>
</body>
</html>