[code=config.php]
<?php
$username="USERNAME";
$password="PASSWORD";
$database="DATABASE_NAME";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
?>
[/code]
[code=index.php]
<?php
include_once ("/gallery/inc/config.php");
?>
<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>Administration Panel :: Gallery</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" type="text/css" href="/gallery/styles/style.css?nocache />
<?
$mode = $_GET['mode'];
if ($mode == "addimage"){
$countResult = mysql_query("SELECT * FROM gallery");
$imgID = mysql_num_rows($countResult);
$imgID = $imgID + 1;
$imgName = $_POST['imgName'];
$imgDesc = $_POST['imgDesc'];
$uploadLocation = "/gallery/photos/";
if ($imgName == "" && $imgDesc == "") {
?>
<form name="imgUpload" method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>" enctype="multipart/form-data">
<table width="60" border="0" cellspacing="0" cellpadding="0">
<tr class="style1">
<td nowrap><div align="right">Image ID:</div></td>
<td><?php echo $imgID; ?></td>
</tr>
<tr class="style1">
<td nowrap><div align="right">Description: </div></td>
<td><textarea name="imgDesc" cols="70" rows="20" class="style1" id="imgDesc"></textarea></td>
</tr>
<tr class="style1">
<td nowrap><div align="right">Image Filename: </div></td>
<td><input type="file" name="imgName"><br /></td>
</tr>
<tr>
<td> </td>
<td><input type="hidden" name="MAX_FILE_SIZE" value="25000"><input name="Submit" type="submit" value="Submit"></td>
</tr>
</table>
</form>
</body>
</html>
<?
} else {
if (is_uploaded_file($_FILES['imgName']['tmp_name'])){
$newImgLoc = $uploadLocation . $_FILES['imgName']['name'];
if (!copy($imgName, $newImgLoc)){
print "Error Uploading File.";
exit();
} else {
$query = mysql_query("INSERT INTO gallery (imgID,imgName,imgDesc) VALUES ('$imgID','$imgName','$imgDesc')");
if(!$query) {
$err=mysql_error();
echo "There was an error reported. The error was:" . $err;
exit();
} else {
echo "<p class='style1'>Photo has been uploaded. <a href='index.php'>Go back to Admin Panel.</a></p>";
exit;
}
}
}
}
} else {
?>
<p class="style1">Please choose an option..</p>
<p class="style1"><a href="index.php?mode=addimage">1) Upload Photo</a></p>
<br />
<br />
<span class="style1">Current Date/Time : <?php echo date("H:i d-M-Y"); ?></span><br />
<?
}
?>
[/code]
Untested (as I don't have time to). Should let you upload an image to webspace, and allows for additions to the code (delete image, view images, edit image description, etc). I've not included the client-facing code to display the images and descriptions, again as I don't have time (but I'm sure somebody on here can help out with that).
