I have created an obituary form to gather text and an image, post the text and the image location to a mysql database, and then listing out the rows where the user can select a name, click on that person and then see the image of that person and the text, all gathered from the form.
I cannot get the image to get onto the server and then get the image to render on the web page after the user clicks on the person's name.
I am so close, with another example that works but is not exactly quite the thing I require.
Here are my files....
input form....
<form enctype="multipart/form-data" action="insert-obits.php" method="post">
<table width="500">
<tr>
<td>Obituary ID Number: </td>
<td><input type="text" name="obit_id" /><br/></td>
</tr>
<tr>
<td>First Name: </td>
<td><input type="text" name="first_name" /><br/></td>
</tr>
<tr>
<td>Last Name: </td>
<td><input type="text" name="last_name" /><br/></td>
</tr>
<tr>
<td>Age: </td>
<td><input type="text" name="age" /><br/></td>
</tr>
<tr>
<td>Date of birth: </td>
<td><input type="text" value="yyyy-mm-dd" name="dob" /><br/></td>
</tr>
<tr>
<td>Date of decease: </td>
<td><input type="text" value="yyyy-mm-dd" name="dod" /><br/></td>
</tr>
<tr>
<td>Obituary Text: </td>
<td><textarea rows="20" cols="40" name="obit_text" /></textarea><br/></td>
</tr>
<tr>
<td>Picture: </td>
<td><input type="file" name="pic" /></td>
</table>
<input type="submit" /> <input type="reset" />
</form>
>>>>>>>>>>>>>>>>>>>>>>
the file that does the stuff....
<?php
//This is the directory where images will be saved
$target = "images/"; $target = $target . basename( $_FILES['pic']['name']);
$con = mysql_connect("#*$!.xx.#*$!.x","#*$!x","#*$!x");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("foxfuneralho", $con);
$sql="INSERT INTO obits (obit_id, first_name, last_name, age, dob, dod, obit_text, pic)
VALUES
('$_POST[obit_id]','$_POST[first_name]','$_POST[last_name]','$_POST[age]','$_POST[dob]','$_POST[dod]','$_POST[obit_text]','$_POST[pic]')";
//Writes the photo to the server
if(move_uploaded_file($_FILES['pic']['tmp_name'], $target)) {
//Tells you if its all ok
echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded and your information has been added to the obituary system."; }
else {
//Gives and error if its not
echo "We could not upload this file.";
}
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con)
?>
>>>>>>>>>>>>>>>>>>>>>>
this file lists the names...
<?php
//make a MySQL connection
include('config.php');
// echo " <a href=\"insert.php\">INSERT PHP</a><br>";
//get all the data from the page table
//*=select everything from the table page
$result = mysql_query("SELECT * FROM obits")
or die(mysql_error());
//echo "<table border='2' width= '1000'>
//<tr>
//<th>obit_id</th>
//<th>lastname</th>
//<th>firstname</th>
//<th>dod</th>
//<th>obit</th>
//</tr>";
while($obit_data = mysql_fetch_array($result))
// {
// echo "<tr>";
// echo "<td width='4'>" . $row['obit_id'] . "</td>";
// echo "<td width='30'>" . $row['last_name'] . "</td>";
// echo "<td width='30'>" . $row['first_name'] . "</td>";
// echo "<td width='10'>" . $row['dod'] . "</td>";
// echo "<td width='500'>" . $row['obit_text'] . "</td>";
// echo "</tr>";
// }
//echo "</table>";
//while($obit_data=mysql_fetch_array($result)){
//echo "<a href=\"show-obituaries.php?id=".$obit_data['obit_id']."#*$! you";
//echo $obit_data['first_name']." ".$obit_data['last_name']." </a>";
//echo "<br><br>";
//}
//date("l, F d, Y",strtotime($myrow['date'])); <<< from erika stokes' cool website [
erikaqstokes.com...]
echo "<a href='show-obituaries.php?id=$obit_data[obit_id]'>" . $obit_data['first_name'] . " " . $obit_data['last_name'] . " " . date("l, F d, Y",strtotime($obit_data['dod'])) . "</a>" . "<br/>";
//echo "<a href=\webpage.php?id=$row[obit_id]\>" . "Person Here" . "</a>" . $row['first_name'] . " " . $row['last_name'] . "<br/>";
//<a href=\"EDIT.php?id=" . $id . "\">
//print "pagename.php?hackid=".$result["hackid"];
//mysql_close($con);
//while($link=mysql_fetch_array($result)){
//echo (display) a link using $link[linkid]
//echo "<p>" . $link['lastname'] . "</p>";
//echo " <a href=\"webpage.php?id=$link[linkid]\">Web Page 1</a><br>";
//echo "<a href=\"webpage.php?id=$row[obit_id]\">obits list</a><br>";
?>
<<<<<<<<<<<<<<<<<<<<<<
this file will output the stuff for each name on the page list from above....
<?php
//make a MySQL connection
include('config.php');
//$the_id = $_GET['id'];
//$result = mysql_query("select * from obits where obit_id = '$the_id'")
//or die(mysql_error());
$the_id = (int)$_GET['id'];
$result = mysql_query("SELECT * FROM `obits` WHERE `obit_id` = ".$the_id." ")
or die(mysql_error());
//$result = mysql_query("select * from obits")
//or die(mysql_error());
//while($obit_data=mysql_fetch_array($result)){
while($obit_data=mysql_fetch_array($result)){
echo "<img src='http://www.foxfuneralhomes.com/admin/images/" . $obit_data['pic'] . "' />" . "<br/><br/>";
echo "<h4>" . $obit_data['first_name'] . " ";
echo $obit_data['last_name'] . " " . $obit_data['age'] . "</h4>";
//echo $obit_data['age'];
//echo $obit_data['dod'];
//echo $obit_data['dob'];
echo $obit_data['obit_text'] . "<br/><br/>";
echo "<br/><br/>";
}
//the_id = $_GET['id']
//$result = mysql_query("select * from obit where obit_id = " + $the_id)
//or die(mysql_error());
//while($obit_data=mysql_fetch_array($result)){
//echo "$obit_data['first_name'] $obit_data['last_name'] <br>";
//echo "$obit_data['dob']
//and so on...
//echo "<br><br>";
//}
?>
If someone could "fix" my code haha, I would "gladly pay you Tuesday..."
Thanks for any help with this nettlesome project...
