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

gettext translates ALWAYS?
I'm using gettext with the new version of XAMPP (5.3.0) on Windows Seven RTM (build 7600)
gettext

How to get the previous months last date....
Here's my wittle problem. I suck at working with dates.

So today is 10/20/2009, i need to fig

Linux socket programming
Where can I find a good introduction to socket programming?

Material Master Update through BAPI - Follow up material not updated
Hi Experts,

I am updating the material master through a custom transaction using the BAPI

BI in Upstream Production operations
Appreciate if you can assist in the following areas:
1) Examples of life before and after BI i

php not working written for consumption of slots
1. Here is the function where i will be allowed to consume the slot booked by me.

2. Here i c

CHECK A STRING FOR ' " ' (DOUBLE QUOTES)
I am checking for delimiter (.!?) and if there is a " after a sentence then it should neglect a

Progress bar tracking file downloads
Hey guys, was wondering if there was a way to track how far a file has been downloaded. I know there

Table colours fail when extra row added
Hey Gurus,

I got a weird problem with formating the colour of a table made in php. Everything

Form a inline view based on the results of the previous query?
Hi Experts,
Can we form a inline view on the results of a previous query (another inline view)?