I spent most of the day trying to figure this image upload stuff out. I've read a bazillion tutorials and posts and forums...and this is the best i could do. I found a tutorial, wrote the below script. Its great, its simple, it works...but it's still a seperate form. How do I get it so that this form is part of my other one?
And this is my other form. I'd like the image upload to be where the "Thumb A", "Thumb B", etc are currently. What am I missing?!? Is it even possible to combine these functions?
Code: Select all
<?
$host="******";
$user="******";
$password="******";
$dbname="******";
$dbtable="******";
$homepage="******";
$dbh=mysql_connect ("******", "******", "******") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("******");
print "<html>\n";
print "<head>\n";
print "<title>Untitled</title>\n";
print "</head>\n\n";
print "<body>\n\n";
print "<table width='640' cellspacing='5' cellpadding='5'>\n";
print "<tr>\n";
print "<td width='40'></td>\n";
print "<td>\n\n";
// PREADD CONTENT
if ($action == "preadd")
{
?>
You are adding a new item:<p>
<form action="<? print $homepage ?>" method="post" enctype="multipart/form-data">
<table border="0" cellpadding="3" cellspacing="3">
<tr>
<td>First Name:</td>
<td>
<input type="text" name="first" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Last Name:</td>
<td>
<input type="text" name="last" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Team:</td>
<td>
<input type="text" name="team" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Number:</td>
<td>
<input type="text" name="number" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>League:</td>
<td>
<input type="text" name="league" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Year:</td>
<td>
<input type="text" name="year" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Home</td>
<td>
<input type="text" name="home" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Brand:</td>
<td>
<input type="text" name="brand" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>LOA:</td>
<td>
<input type="text" name="loa" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Size:</td>
<td>
<input type="text" name="size" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Description:</td>
<td>
<input type="text" name="description" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Drafted:</td>
<td>
<input type="text" name="draft" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Current:</td>
<td>
<input type="text" name="current" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Thumb A:</td>
<td>
<input type="file" name="thumba" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Thumb B:</td>
<td>
<input type="file" name="thumbb" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Thumb C:</td>
<td>
<input type="file" name="thumbc" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Thumb D:</td>
<td>
<input type="file" name="thumbd" size="40" maxlength="80">
</td>
</tr>
<tr>
<td></td>
<td>
<input type="submit" value="Add item">
</td>
</tr>
</table>
<input type="hidden" name="action" value="add">
</form>
<?
}
// ADD CONTENT
if ($action == "add")
{
$body = addslashes($body);
$sql = "insert into $dbtable (first,last,thumba,thumbb,thumbc,thumbd,team,number,league,year,home,brand,loa,size,description,draft,current) values ('$first','$last','$thumba','$thumbb','$thumbc','$thumbd','$team','$number','$league','$year','$home','$brand','$loa','$size','$description','$draft','$current'
);";
$result = mysql_query($sql, $dbh) or die( mysql_error() );
if ($result)
{
print "You have added a item for <b>$first $last</b>.<br>\n";
}
else
{
print "Error: Could Not Add item.<br>";
}
print "<br>If no errors are encountered, please check the appropriate area of the website to make sure it appears correctly.<p>";
print "<b><a href='$homepage'>Return to Admin</a></b>";
}
// EDIT CONTENT
if ($action == "edit")
{
$sql = "select id,first,last,thumba,thumbb,thumbc,thumbd,team,number,league,year,home,brand,loa,size,description,draft,current from $dbtable where id=$id;";
$result = mysql_query($sql, $dbh) or die( mysql_error() );
$first = mysql_result($result, 0, "first");
$last = mysql_result($result, 0, "last");
$thumba = mysql_result($result, 0, "thumba");
$thumbb = mysql_result($result, 0, "thumbb");
$thumbc = mysql_result($result, 0, "thumbc");
$thumbd = mysql_result($result, 0, "thumbd");
$team = mysql_result($result, 0, "team");
$number = mysql_result($result, 0, "number");
$league = mysql_result($result, 0, "league");
$year = mysql_result($result, 0, "year");
$home = mysql_result($result, 0, "home");
$brand = mysql_result($result, 0, "brand");
$loa = mysql_result($result, 0, "loa");
$size = mysql_result($result, 0, "size");
$description = mysql_result($result, 0, "description");
$draft = mysql_result($result, 0, "draft");
$current = mysql_result($result, 0, "current");
?>
You are editing a item:
<p>
<form action="<? print $homepage ?>" method="post" enctype="multipart/form-data">
<table border="0" cellpadding="3" cellspacing="3">
<tr>
<td>First:</td>
<td>
<input type="text" name="first" value="<? print $first ?>" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Last:</td>
<td>
<input type="text" name="last" value="<? print $last ?>" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Team:</td>
<td>
<input type="text" name="team" value="<? print $team ?>" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Number:</td>
<td>
<input type="text" name="number" value="<? print $number ?>" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>League:</td>
<td>
<input type="text" name="league" value="<? print $league ?>" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Year:</td>
<td>
<input type="text" name="year" value="<? print $year ?>" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Home/Road/Alt:</td>
<td>
<input type="text" name="home" value="<? print $home ?>" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Brand:</td>
<td>
<input type="text" name="brand" value="<? print $brand ?>" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Team LOA:</td>
<td>
<input type="text" name="loa" value="<? print $loa ?>" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Size:</td>
<td>
<input type="text" name="size" value="<? print $size ?>" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Description:</td>
<td>
<input type="text" name="description" value="<? print $description ?>" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Drafted:</td>
<td>
<input type="text" name="draft" value="<? print $draft ?>" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Current League:</td>
<td>
<input type="text" name="current" value="<? print $current ?>" size="40" maxlength="80">
</td>
</tr> <tr>
<td>Thumb A:</td>
<td>
<input type="file" name="thumba" value="<? print $thumba ?>" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Thumb B:</td>
<td>
<input type="file" name="thumbb" value="<? print $thumbb ?>" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Thumb C:</td>
<td>
<input type="file" name="thumbc" value="<? print $thumbc ?>" size="40" maxlength="80">
</td>
</tr>
<tr>
<td>Thumb D:</td>
<td>
<input type="file" name="thumbd" value="<? print $thumbd ?>" size="40" maxlength="80">
</td>
</tr>
<tr>
<td></td>
<td>
<input type="submit" value="Edit item">
</td>
</tr>
</table>
<input type="hidden" name="id" value="<? print $id ?>">
<input type="hidden" name="action" value="update">
</form>
<?
}
// UPDATE CONTENT
if ($action == "update")
{
$body = addslashes($body);
$sql = "update $dbtable set first='$first',last='$last',team='$team',number='$number',league='$league' ,year='$year',home='$home',brand='$brand',loa='$loa',size='$size',description='$description',draft='$draft',current='$current',thumba='$thumba',thumbb='$thumbb',thumbc='$thumbc',thumbd='$thumbd' where id='$id'";
$result = mysql_query($sql, $dbh) or die( mysql_error() );
if ($result)
{
print "You have edited a item entitled <b>$first $last</b>.<br>\n";
}
else
{
print "Error: Could Not Edit item<br>";
}
print "<br>If no errors are encountered, please check the appropriate area of the website to make sure it appears correctly.<p>";
print "<b><a href='$homepage'>Return to Admin</a></b>";
}
// DELETE CONTENT
if ($action == "delete_check")
{
print "Are you sure you want to PERMANENTLY DELETE the item entitled <b>$first $last</b>?<p>\n\n";
print "<b><a href='$homepage?action=delete&id=$id'>Yes</a></b><br><br>";
print "<b><a href='$homepage'>No - Return to Admin</a></b>";
}
if ($action == "delete")
{
$sql = "delete from $dbtable where id='$id';";
$result = mysql_query($sql, $dbh) or die( mysql_error() );
if ($result)
{
print "You have permanently deleted the item entitled <b>$first $last</b>.<p>";
}
else
{
print "Error: Could Not Delete item.<p>";
}
print "<b><a href='$homepage'>Return to Admin</a></b>";
}
// LIST ENTRIES (DEFAULT)
if ($action == "list" || $action == "")
{
?>
ї<a href="<? print $homepage ?>?action=preadd">Add New item</a>]
<p>
<?
$sql = "select id, first, last from $dbtable order by id desc;";
$result = mysql_query($sql, $dbh) or die( mysql_error() );
?>
<table border="1" cellspacing="0" cellpadding="5">
<tr>
<td>ID</td>
<td>First</td>
<td>Last</td>
<td>Functions</td>
</tr>
<?
for ($x = 0; $x < mysql_num_rows($result); $x++)
{
$id = mysql_result($result, $x, "id");
$first = mysql_result($result, $x, "first");
$last = mysql_result($result, $x, "last");
print " <tr>\n";
print " <td bgcolor='#aaaaaa' align='center'>";
print "$id";
print "</td>\n";
print "<td bgcolor='#bbbbbb'>";
print "$first";
print "</td>\n";
print "<td bgcolor='#bbbbbb'>";
print "$last";
print "</td>\n";
print "<td>";
print "ї<a href='$homepage?action=edit&id=$id&first=$first&last=$last'>Edit</a>] ї<a href='$homepage?action=delete_check&id=$id&first=$first&last=$last'>Delete</a>]";
print "</td>\n";
print " </tr>\n\n";
}
print "</table>\n";
}
?>
</td> </tr>
</table>
</body>
</html>