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

Facebook status update API
Hello,

So, I'm trying to create my first Facebook application with PHP.

Basic ideas fo

Dynamic Array using glob?
Is there an easier way to do this?

I am trying to get create a dyamic array based on files wi

rdns with php
I am trying to build a script that will show all of the different domains that are hosted on the sam

Export hangs
Hi all, please help

I have a Oracle 10.2.0.3.0 database. When I want to query the dba_segmen

Batch update record with Pagination
Hoping someone can help me with this issue I'm having, im trying to batch update records from a resu

form help
this doesn't work. i want the form action to go the location.href of the submit button chosen.. how

Only add new information from XML to MySQL
What I am doing, is taking a xml file, and adding the values to a database. However, what I want to

Problem with php's rename function
So, i'm having a problem with the php rename function. Basically my script 'delete_user.php' attempt

Getting the full city list from maxminds geoip database
I am suprised I can't find any references to this.

I have maxminds geoip lite installed and i

PHP url branch??
Functionally, using PHP, I'm doing a test of login input submitted by a user via an html form in a f