Karen Liddy
asked on
displaying more than one image from database php
Hi,
i have a slideshow that i am altering to be able to use with php file upload, below is the page that displays the images. i can only get it to display one image at a time, well multiple instances of the same image. How can i make it show all the images (and related info) from the database, the number of images in the database might change sometimes only 6 others 16.
thanks,
Mskazza
i have a slideshow that i am altering to be able to use with php file upload, below is the page that displays the images. i can only get it to display one image at a time, well multiple instances of the same image. How can i make it show all the images (and related info) from the database, the number of images in the database might change sometimes only 6 others 16.
thanks,
Mskazza
<?php require_once('Connections/imageflow.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_imageflow, $imageflow);
$query_images = "SELECT * FROM images ORDER BY `path` ASC";
$images = mysql_query($query_images, $imageflow) or die(mysql_error());
$row_images = mysql_fetch_assoc($images);
$totalRows_images = mysql_num_rows($images);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>ImageFlow</title>
<meta name="robots" content="index, follow, noarchive" />
<link rel="stylesheet" href="style.css" type="text/css" />
<!-- This includes the ImageFlow CSS and JavaScript -->
<link rel="stylesheet" href="imageflow.css" type="text/css" />
<script type="text/javascript" src="imageflow.js"></script>
</head>
<body>
<h1>ImageFlow</h1>
<!-- This is all the XHTML ImageFlow needs -->
<div id="myImageFlow" class="imageflow">
<img src="img/<?php echo $row_images['path']; ?>" longdesc="<?php echo $row_images['desc']; ?>" alt="Image 1" />
<img src="img/<?php echo $row_images['path']; ?>" longdesc="img/img2.gif" alt="Image 2" />
<img src="img/<?php echo $row_images['path']; ?>" longdesc="img/img3.gif" alt="Image 3" />
<img src="img/img1.gif" longdesc="img/img1.gif" width="400" height="300" alt="Image 4" />
<img src="img/img2.gif" longdesc="img/img2.gif" width="300" height="400" alt="Image 5" />
<img src="img/img1.gif" longdesc="img/img1.gif" width="400" height="300" alt="Image 6" />
<img src="img/img2.gif" longdesc="img/img2.gif" width="300" height="400" alt="Image 7" />
<img src="img/img3.gif" longdesc="img/img3.gif" width="400" height="400" alt="Image 8" />
<img src="img/img1.gif" longdesc="img/img1.gif" width="400" height="300" alt="Image 9" />
<img src="img/img1.gif" longdesc="img/img1.gif" width="400" height="300" alt="Image 10" />
<img src="img/img2.gif" longdesc="img/img2.gif" width="300" height="400" alt="Image 11" />
<img src="img/img3.gif" longdesc="img/img3.gif" width="400" height="400" alt="Image 12" />
<img src="img/img2.gif" longdesc="img/img2.gif" width="300" height="400" alt="Image 13" />
<img src="img/img3.gif" longdesc="img/img3.gif" width="400" height="400" alt="Image 14" />
<img src="img/img3.gif" longdesc="img/img3.gif" width="400" height="400" alt="Image 15" />
</div>
</body>
</html>
<?php
mysql_free_result($images);
?>
ASKER
thanks for your reply.
the above is not returning anything, i must be doing something wrong, please find my code below. it just gets stuck saying loading images, but nothing ever loads.
the only thing visible in the brower is :
the above is not returning anything, i must be doing something wrong, please find my code below. it just gets stuck saying loading images, but nothing ever loads.
<?php require_once('Connections/imageflow.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_imageflow, $imageflow);
$query_images = "SELECT * FROM images ORDER BY `path` ASC";
$images = mysql_query($query_images, $imageflow) or die(mysql_error());
$row_images = mysql_fetch_assoc($images);
$totalRows_images = mysql_num_rows($images);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>ImageFlow</title>
<meta name="robots" content="index, follow, noarchive" />
<link rel="stylesheet" href="style.css" type="text/css" />
<!-- This includes the ImageFlow CSS and JavaScript -->
<link rel="stylesheet" href="imageflow.css" type="text/css" />
<script type="text/javascript" src="imageflow.js"></script>
</head>
<body>
<h1>ImageFlow</h1>
<!-- This is all the XHTML ImageFlow needs -->
<div id="myImageFlow" class="imageflow">
<?php
while($row_images = mysql_fetch_assoc($images)){
?>
<img src="img/<?php echo $row_images['path']; ?>" longdesc="<?php echo $row_images['desc']; ?>" alt="Image 1" />
<?php
}
?>
</div>
</body>
</html>
<?php
mysql_free_result($images);
?>
the only thing visible in the brower is :
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>ImageFlow</title>
<meta name="robots" content="index, follow, noarchive" />
<link rel="stylesheet" href="style.css" type="text/css" />
<!-- This includes the ImageFlow CSS and JavaScript -->
<link rel="stylesheet" href="imageflow.css" type="text/css" />
<script type="text/javascript" src="imageflow.js"></script>
</head>
<body>
<h1>ImageFlow</h1>
<!-- This is all the XHTML ImageFlow needs -->
<div id="myImageFlow" class="imageflow">
</div>
</body>
</html>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks very much for the speedy reply. brilliant :)
Open in new window