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!";
}

?>

No comments posted yet

Your Answer:

Login to answer
137 Like 53 Dislike
Previous forums Next forums
Other forums

Extracting URL pointer within XML tag
Hi.

I'm trying to extract text between two quotation marks in XML. For example, I want to ex

Filtering an Array Based on Value
I have a very simple script set up that pulls data from a database and is output using this code:

Post PHP form to non-existing page
The company that I work for host their PHP code on IIS on a Windows server, no Apache, so no mod_rew

How to make a mail Form secure?
I want to create an email Form on my web site. How can I make the Form secure so the submitted info

need help in creating captcha
hi i have a problem creating captcha system. i create some basic script for image displaying but it

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash