<html>

Images and databases (carrying address):

createimageadr.php

<html>

<head><title>PHP and MySQL</title></head>

<body>

<?php

$link = mysql_connect("localhost", "pgrocer", "abcdefg", "fortesting")

or die("Could not connect: " . mysql_error());

print ("Connected successfully");

mysql_select_db("fortesting");

$sql = "CREATE TABLE imageadrtable (imgid int(3) primary key, imgname varchar(25), imgadr varchar(50))";

$result= mysql_query($sql,$link) or die(mysql_error());

echo $result;

</body>

</html>

insertimageadr.php

<html>

<head><title>PHP and MySQL</title></head>

<body>

<?php

$link = mysql_connect("localhost", "pgrocer", "abcdefg", "fortesting")

or die("Could not connect: " . mysql_error());

print ("Connected successfully");

mysql_select_db("fortesting");

$sql = "INSERT INTO imageadrtable values (150, 'dog150', 'images/dog150.JPG')";

$result= mysql_query($sql,$link) or die(mysql_error());

echo $result;

$sql = "INSERT INTO imageadrtable values (250, 'dog250', 'images/dog250.JPG')";

$result= mysql_query($sql,$link) or die(mysql_error());

echo $result;

$sql = "INSERT INTO imageadrtable values (350, 'dog350', 'images/dog350.JPG')";

$result= mysql_query($sql,$link) or die(mysql_error());

echo $result;

</body>

</html>

seeimageadr.php

<html>

<head>

<title>Image</title>

</head>

<body>

<h1>Display image address</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());

while ($row = mysql_fetch_array($result))

{

print ($row[imgid] . "<br />" . $row[imgname] . "<br />" . $row[imgadr] . "<br />");

echo "<img src = $row[imgadr] />";

echo ("<br />");

}

</body>

</html>