Jump to content

Problem displaying images from mysql database


mjgdunne

Recommended Posts

Hi I am having trouble displaying images stored in a mysql database, when i run the script all i am getting is the location path to the image, is there any way of displaying the images, here is my my code:

<?php

session_start();

ini_set( 'display_errors', '1' );
error_reporting ( 2047 );

$host="localhost"; // Host name
$username="root"; // Mysql username
$password="root"; // Mysql password
$db_name="test"; // Database name
$tbl_name="pix"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "root", "root")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$myq=$_POST['myq'];


if (isset($_POST['myq'])) {
    $myq = mysql_real_escape_string($_POST['myq']);
    $result = mysql_query("SELECT * FROM pix WHERE title LIKE '%$myq' OR registration LIKE '%$myq'");


    while ($row = mysql_fetch_array($result)) {

echo "<p>You searched for: "" . $myq . ""</p>";


echo "<table border=\"1\" align=\"center\">";
echo "<tr><th>Car Make</th>";
	echo "<td>";
        echo $row['title'];
echo "</td>";


echo "<tr><th>Image</th>";
	echo "<td>";

        echo $row["imgdata"];

echo "</td>";

echo "<tr><th>Registration</th>";
	echo "<td>";
    echo $row['registration'];
echo "</td>";


    }
}

if (!$result) {
    $message  = 'Invalid query: ' . mysql_error() . "\n";
    $message .= 'Whole query: ' . $query;
    die($message);
}

if (mysql_num_rows($result) == 0) {
    echo "No records found";
    exit;
}
exit();
?>

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.