User Image Upload Script

job0107 · #11 (**permalink**) 07-15-08, 09:16 PM

Do you still need a program that will fetch the data from the database and allow you to read it?

Phrozen44 · #12 (**permalink**) 07-15-08, 09:34 PM

If it would not be to much trouble for you then sure, why not? While I can read the data in the database itself, a program to speed it up sure would be welcomed. Thanks again! -Phrozen44

job0107 · #13 (**permalink**) 07-16-08, 12:15 AM

Ok, here is a simple viewer with a paging system built in.
This will allow you to flip through the records.
I included a reset in case you want to reset it back to the beginning.

This program uses $_SESSION arrays to store the records, so it only queries the database once.

Use the reset to force the database to be queried again and reset the pointer ($ct) to the first record.

Copy and save this program with a file name like viewer.php

Then ftp it to your site in the same location as the other program.

Then you can use it by typing in you web address and viewer.php.

Example: http://YourWebAddress.com/viewer.php

PHP Code:


			
<?php session_start(); ?>
<html>
<head>
<title></title>
<style>
table
{
 background:#fafafa;
 color:#3399cc;
 width:750px;
 }
.no_border
{
 border:0px;
 }
</style>
</head>
<body>
<?php
if(!empty($_GET["rst"])){unset($_SESSION["name"]);}
if(empty($_SESSION["name"]))
{
 $ct = 0;
 // Insert the values for these variables //
 $server   = ""; // MySql server         *required*
 $username = ""; // MySQL username       *required*
 $password = ""; // MySQL password       *optional*
 $dbname   = ""; // MySQL database name  *required*
 $table    = ""; // MySql table name     *required*
 $path     = "images/";
 //////////////////////////////////////////
 mysql_connect($server,$username,$password) or die("Could not connect to server ".mysql_error());
 mysql_select_db($dbname) or die(mysql_error());
 $results = mysql_query("SELECT * FROM $table") or die(mysql_error());
 if($results)
 {
  while($row = mysql_fetch_assoc($results))
  {
   $_SESSION["name"][] = $row["name"];
   $_SESSION["basename"][] = str_replace($path,"",$row["name"]);
   $_SESSION["size"][] = $row["size"];
   $_SESSION["width"][] = $row["width"];
   $_SESSION["height"][] = $row["height"];
   $_SESSION["mime_type"][] = $row["mime_type"];
   $_SESSION["comments"][] = $row["comments"];
   }
  }
 mysql_free_result($results);
 mysql_close();
 }
if(!empty($_GET["action"]))
{
 $ct = $_GET["action"] == "prev" ? $_GET["ct"] - 1 : $_GET["ct"] + 1;
 if($ct < 0){$ct = 0;}
 if($ct>=count($_SESSION["name"])){$ct = count($_SESSION["name"]) - 1;}
 }
$p = $ct != 0 ? "Prev" : "";
$n = $ct < count($_SESSION["name"]) - 1 ? "Next" : "";
echo "<table border='1'>
       <tr><td colspan='5' align='center'><img src='".$_SESSION["name"][$ct]."' width='".$_SESSION["width"][$ct]."' height='".$_SESSION["height"][$ct]."' /></td></tr>
       <tr><td align='center'>".$_SESSION["basename"][$ct]."</td><td align='center'>Width - ".$_SESSION["width"][$ct]."px</td><td align='center'>Height - ".$_SESSION["height"][$ct]."px</td><td align='center'>Size - ".$_SESSION["size"][$ct]."</td><td align='center'>Mime - ".$_SESSION["mime_type"][$ct]."</td></tr>
       <tr><td colspan='5' align='center'>".$_SESSION["comments"][$ct]."</td></tr>
       <tr><td class='no_border' align='center'><a href='?ct=$ct&action=prev'>$p</a></td><td class='no_border' colspan='3' align='center'><a href='?rst=reset'>Reset</a></td><td class='no_border' align='center'><a href='?ct=$ct&action=next'>$n</a></td></tr>
      </table>";
?>
</body>
</html>