Displaying image pathname instead of image

Posted on 16th Feb 2014 07:03 pm by admin

Hello

Im trying to upload and then display images from a mysql database - Its only basic and i only need one pic per user on the database hence why using mysql

I really need osme help as ive been going round in circles for a couple of days now - I know its probably very simple but my head is spinning - any help would be amazing - Be very gratefull

The database has blob specified for the pic

Here is my post data

<form id="form1" method="post" action="djregistercheck.php" enctype="multipart/form-data">
<p>
<label>Dj Name
<input type="text" name="DJName" id="DJName" />
</label> * - Must Be Entered
</p>
<p>
<label>Your Email
<input type="text" name="Email" id="Email" />
</label>* - Must Be Valid Email Address
</p>
<p>
<label>Password
<input type="password" name="Password" id="Password" />
</label>* - Must be more than 6 charachters
</p>
<p>
<label>Name
<input type="text" name="Name" id="Name" />
</label>
* - Must Be Entered </p>
<p>
<label>Surname
<input type="text" name="Name" id="Name" />
</label>
* - Must Be Entered </p>
<p>
<label>Description
<input type="text" name="Description" id="Description" />
</label> * - Must Be Entered
</p>
<p>
<label>Expierience
<input type="text" name="Expierience" id="Expierience" />
</label> * - Must Be Entered
</p>
<p>
<label>Website
<input type="text" name="Website" id="Website" />
</label> * - Must Be Entered
</p>
<p>
<label>Location
<input type="text" name="Location" id="Location" />
</label> * - Must Be Entered </p>
<p>
<label>Mobilephone
<input type="text" name="Mobilephone" id="Mobilephone" />
</label> * - Must Be Entered
</p>
<p>
<label>Picture
<input type="file" name="Pic" size="50" id="Pic" />
</label> * - Must Be Entered
</p>
<p>
<input type="submit" name="button" id="button" value="Submit" />
</p>
</form>

and here is the djregistercheck page

<?php
include 'connection.php';
// Main ----------
session_start();
// Get the data collected from the user
$DJName = $_POST['DJName'];
$Email = $_POST['Email'];
$Password = $_POST['Password'];
$Name = $_POST['Name'];
$Surname = $_POST['Surname'];
$Description = $_POST['Description'];
$Expierience = $_POST['Expierience'];
$Website = $_POST['Website'];
$Location = $_POST['Location'];
$Mobilephone = $_POST['Mobilephone'];
$Pic = $_POST['Pic'];

if (empty($Email))
{
$_SESSION["message"] = "Email Address is Empty - Please re-enter" ;
header("Location: djregister.php");
exit; //Ends the script and redirects to above
}
//Check to see if the email contains '@'
else if (strpos($Email,'@') < 1)
{
$_SESSION["message"] = "Email Address is Invalid - Please re-enter" ;
header("Location: djregister.php");
exit; //Ends the script and redirects to above
}
//Checks to see if the password is less than 6 charachters
else if (strlen($Password)<6)
{
$_SESSION["message"] = "Password must be longer than 6 charachters" ;
header("Location: djregister.php");
exit; //Ends the script and redirects to above }
}
//All was OK - Log details to Customer Database and re-direct to login so customer can now login
else
$query = "INSERT INTO Dj (DJName, Email, Password, Name, Surname, Description, Expierience, Website, Location, Mobilephone, Pic) VALUES ('$DJName', '$Email', '$Password', '$Name', '$Surname', '$Description', '$Expierience', '$Website', '$Location', '$Mobilephone', '$Pic')";
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

$_SESSION["message"] = "Thank You $DJName For Registering - Please now log in to View Site" ;
header("Location: login.php"); //This sets the redirection information
exit; //Ends the script and redirects to above
// execute query

// print $query;

$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

// close connection
mysql_close($connection);
?>


So im not sure if that works correctley but i presume it does as when i do the below a file path is displayed

Here is the code for the display

//Include the connection details, open $connection and select database
include ("connection.php");

//Prepare query
$query = "SELECT DJName, Email, Description, Expierience, Website, Pic
FROM Dj";


// execute query
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

// see if any rows were returned
if (mysql_num_rows($result)>0) {
echo "<table border=1>n<tr>" .
"<th>DJName</th>" .
"<th>Email</th>" .
"<th>Description</th>" .
"<th>Expierience</th>" .
"<th>Website</th>".
"<th>Pic</th>";

while ($row = @ mysql_fetch_array($result)) {
//while($row = mysql_fetch_row($result)) {
echo "<tr>";
echo "<td class=BorderMeRed>".$row["DJName"]."</td>";
echo "<td class=BorderMeRed>".$row["Email"]."</td>";
echo "<td class=BorderMeRed>".$row["Description"]."</td>";
echo "<td class=BorderMeRed>".$row["Expierience"]."</td>";
echo "<td class=BorderMeRed>".$row["Website"]."</td>";
echo "<td class=BorderMeRed>".$row["Pic"]."</td>";
echo "</tr>";
}
echo "</table>";
}
else {
// no
// print status message
print "No rows found!";
}

?>

Your Answer:

Login to answer

Other forums

Guixt issue
Hello all,

We are experiencing the following problem with Guixt:

Some transact

question about n
I was looking at some of the things you could do with php and one of the things I have tried is n.<

Help Import Animoto and Youtube
CAn someone help me urgently want to allow users on my website to import youtube/revver/dailymotion

php code to accept and delete incoming data
Using following HTML Code please show me how to write PHP code to accept and delete the incoming dat

Alterar a hora do servidor
Se alguém souber, ajude-me a adicionar 6 horas, obrigado
<tr>
&

session variable problem
Session variable is not working in Fire fox i am getting null value but it is working fine in IE.

php/mysql problem
Hey all,

Problem: im trying to setup a shop where people can use a drop-down list to select t

pop3 and fsockopen
So I am able to connect to the pop3 server, log in, and check how many messages there are. I am hav

list files from folder, only one for each date
I have many files in a folder and wish to only list one of each date

these are the file names

Sessions work for me and not others?
I'm having a bit of bad luck with sessions. In the past they have worked fine for me, but this time