Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
A tutorial for storing paths to images in db (upload, display)
- Thread starter pugs421
- Start date
Hi,
Make a folder that is public for your images. The below sript calls up the path and inserts it into the img tag in html. ******************************************************
<?php
// open the connection
$conn = mysql_connect("localhost", "", ""
;
// pick the database to use
mysql_select_db("dbase",$conn);
// create the sql statement
$sql = "SELECT picture FROM table";
// execute the sql statement
$result = mysql_query($sql, $conn) or die(mysql_error());
print "<table border=1><tr><th>Picture</th></tr>";
// go through each row in the result set and display data
while ($newArray = mysql_fetch_array($result)) {
// give a name to the fields
$picture = $newArray['picture'];
//echo the results on screen
echo "
<tr>
<td><img src=\"$picture\"></td>
</tr>";
}
print "</table>";
?>
*****************************************************
Create a form that you can type in the image path to be posted to your database
<?php
session_start();
?>
<html>
<head>
<title>
Inserting info to database
</title>
</head>
<body>
<form method="post" action="insert.php">
Path:<input type="text" name="path"><br>
<input type="Submit" name="submit" value="Enter information">
</form>
</body>
</html>
******************************************************
<?php
// open the connection
$conn = mysql_connect("localhost","",""
// pick the database to use
mysql_select_db("dbase", $conn);
// create the SQL statement
$sql = "INSERT INTO table values ('$_POST[path]')";
if ($_POST[path] == ""
{die ("<P>Please Enter A Path!<P><FORM><INPUT TYPE=\"BUTTON\" VALUE=\"BACK\" onClick=\"history.back()\"></FORM>"}
else
//execute the statement
if (mysql_query($sql, $conn)) {
echo "record added!";
}else{
echo "something went wrong or username already in use";
}
?>
add just place theimage in manually or get a normal html file upload to load it up to your folder.
Reality is built on a foundation of dreams.
Make a folder that is public for your images. The below sript calls up the path and inserts it into the img tag in html. ******************************************************
<?php
// open the connection
$conn = mysql_connect("localhost", "", ""
;// pick the database to use
mysql_select_db("dbase",$conn);
// create the sql statement
$sql = "SELECT picture FROM table";
// execute the sql statement
$result = mysql_query($sql, $conn) or die(mysql_error());
print "<table border=1><tr><th>Picture</th></tr>";
// go through each row in the result set and display data
while ($newArray = mysql_fetch_array($result)) {
// give a name to the fields
$picture = $newArray['picture'];
//echo the results on screen
echo "
<tr>
<td><img src=\"$picture\"></td>
</tr>";
}
print "</table>";
?>
*****************************************************
Create a form that you can type in the image path to be posted to your database
<?php
session_start();
?>
<html>
<head>
<title>
Inserting info to database
</title>
</head>
<body>
<form method="post" action="insert.php">
Path:<input type="text" name="path"><br>
<input type="Submit" name="submit" value="Enter information">
</form>
</body>
</html>
******************************************************
<?php
// open the connection
$conn = mysql_connect("localhost","",""
;// pick the database to use
mysql_select_db("dbase", $conn);
// create the SQL statement
$sql = "INSERT INTO table values ('$_POST[path]')";
if ($_POST[path] == ""
{die ("<P>Please Enter A Path!<P><FORM><INPUT TYPE=\"BUTTON\" VALUE=\"BACK\" onClick=\"history.back()\"></FORM>"
;}else
//execute the statement
if (mysql_query($sql, $conn)) {
echo "record added!";
}else{
echo "something went wrong or username already in use";
}
?>
add just place theimage in manually or get a normal html file upload to load it up to your folder.
Reality is built on a foundation of dreams.
- Thread starter
- #3
Thanks for the response. I am a beginner but I think I understand whats going on in the code. One thing I dont understand is that in the input form, a path to the file is supposed to be given...correct?
My goal is to let the user upload the picture and then have it displayed on their member info page, so they wouldn't be typing in the path to the image, just uploading it. Can that be done from the code you gave?
My goal is to let the user upload the picture and then have it displayed on their member info page, so they wouldn't be typing in the path to the image, just uploading it. Can that be done from the code you gave?
- Status
Similar threads
