randimagecon.php
<html>
<head>
<title>Random
Image</title>
</head>
<body>
<h1>Display a random
image</h1>
<?php
$link =
mysql_connect("localhost", "pgrocer", "abcdefg",
"fortesting")
or die("Could not
connect: " . mysql_error());
print ("Connected successfully");
mysql_select_db("fortesting");
$result =
mysql_query("SELECT imgid, imgname, imgadr from imageadrtable")
or die("Invalid query:
" . mysql_error());
$indx = rand(0, 2);
if ($indx == 0)
{
$getimg = '150';
}
else
if ($indx == 1)
{
$getimg = '250';
}
else
{
$getimg = '350';
}
echo ("<br
/>");
echo ($getimg);
echo ("<br
/>");
$result =
mysql_query("SELECT imgid, imgname, imgadr from imageadrtable where imgid
= '$getimg'")
or die("Invalid query: " . mysql_error());
$row =
mysql_fetch_array($result);
print ($row['imgid'] .
"<br />" . $row[imgname] . "<br />" .
$row["imgadr"] . "<br />");
echo ($row['imgid'] .
"<br />" . $row[imgname] . "<br />" .
$row["imgadr"] . "<br />");
echo $row['imgid'] .
"<br />" . $row[imgname] . "<br />" .
$row["imgadr"] . "<br />";
echo "<img src =
$row[imgadr] />";
echo "<img src =
{$row['imgadr']} />";
echo "<img src =
" . $row[imgadr] . " />";
echo "<img src =
" . $row['imgadr'] . " />";
print ("<img src =
$row[imgadr] />");
print ("<img src =
{$row['imgadr']} />");
echo ("<br
/>");
?>
</body>
</html>