Home arrow PHP arrow Page 9 - Cracking The Vault (part 1)

Red And Green Clouds - PHP

Electronic documents are all well and good - but when you work onthem collaboratively, they can end up being more difficult to handle thanordinary pieces of paper. Multiple versions, competing standards, accesspermissions and revision history tracking are just some of the issues thatarise in a paperless office. This article discusses building and deployinga document management system across your network - and also teachesbeginnners a little bit about designing Web-based applications with PHP andmySQL in the process.

  1. Cracking The Vault (part 1)
  2. Just Another Day At The Office
  3. An Evil Plan Is Born
  4. Setting The Ground Rules
  5. Design Time
  6. Start Me Up
  7. Entry Points
  8. Seeding The System
  9. Red And Green Clouds
  10. Digging Deeper
  11. Basic Maintenance
  12. The D Word
By: Vikram Vaswani, (c) Melonfire
Rating: starstarstarstarstar / 2
May 14, 2001

print this article


Let's now take a look at "out.php", the PHP code used to generate the file list.

<table border="0" cellspacing="0" cellpadding="0"> <? // get a list of documents the user has "view" permission for $connection = mysql_connect($hostname, $user, $pass) or die ("Unable to connect!"); $query = "SELECT data.id, user.username, data.realname, data.created, data.description, data.comment, data.status FROM data, user, perms WHERE data.id = perms.fid AND user.id = data.owner AND perms.uid = '$SESSION_UID' AND perms.rights = '1'"; $result = mysql_db_query($database, $query, $connection) or die ("Error in query: $query. " . mysql_error()); // how many records returned? $count = mysql_num_rows($result); ?> <tr> <td><? echo $count; ?> document(s) found<p></td> </tr> <? // iterate through resultset while(list($id, $owner, $realname, $created, $description, $comment, $status) = mysql_fetch_row($result)) { // correction for empty description if ($description == "") { $description = "No description available"; } // set filename for filesize() call below $filename = $dataDir . $id . ".dat"; // begin displaying file list with basic information ?> <tr> <td><b><? echo "<a href=\"details.php?id=$id\">$realname</a>"; ?></b></td> </tr> <tr> <td><font size="-1"><? echo $description; ?></font></td> </tr> <tr> <td><font size="-1">Document created on <? echo fixDate($created); ?> by <b><? echo $owner; ?></b> | <? echo filesize($filename); ?> bytes</font></td> </tr> <? // code to display status message and icon for each file - snipped ?> <tr> <td>   </td> </tr> <? } // clean up mysql_free_result ($result); mysql_close($connection); ?> </table>

Pay attention to the query - I'm joining the "user", "data" and "perms" tables together to obtain detailed information (description, creation date, owner) for those files which contain the logged-in user's ID and a permission value of 1 (view). Once I have a dataset, I use a "while" loop to iterate through it and display the file list.

Next, the $filename variable. As I've already mentioned, once a document is entered into the repository, I don't plan to retain the original file name, but rather hope to rename it in the form "fileID.dat". So I've generated a filename on the basis of each file ID, and am using the filesize() function to display the size of the file as part of the description.

The fixDate() function is used to turn the mySQL timestamp into something a little more readable.

// function to format mySQL DATETIME values function fixDate($val) { //split it up into components $arr = explode(" ", $val); $timearr = explode(":", $arr[1]); $datearr = explode("-", $arr[0]); // create a timestamp with mktime(), format it with date() return date("d M Y (H:i)", mktime($timearr[0], $timearr[1], $timearr[2], $datearr[1], $datearr[2], $datearr[0])); }

Finally, before we leave this script, let's explore the section used to display a message indicating whether or not the file is available for check-out.

<? // check the status of each file // 0 -> file is not checked out // display appropriate message and icon if ($status == 0) { ?> <tr> <td><img src="images/a.jpg" width=40 height=33 alt="" border=0 align="absmiddle"><font size="-1" color="#43c343"><b>This document is available to be checked out</b></font></td> </tr> <? } else { // not 0 -> implies file is checked out to another user // run a query to find out user's name $query2 = "SELECT username FROM user WHERE id = '$status'"; $result2 = mysql_db_query($database, $query2, $connection) or die ("Error in query: $query2 . " . mysql_error()); list($username) = mysql_fetch_row($result2); // and display message and icon ?> <tr> <td> <img src="images/na.jpg" width=40 height=33 alt="" border=0 align="absmiddle"><font size="-1" color="#e9202a">This document is currently checked out to <b><? echo $username; ?></b></font> </td> </tr> <? } ?>

Depending on the value of the "status" column, an icon and message is displayed for each file; green indicates that the file is available, while red indicates that it is not.

And here's what it all looks like.

This article copyright Melonfire 2001. All rights reserved.

>>> More PHP Articles          >>> More By Vikram Vaswani, (c) Melonfire

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Hackers Compromise PHP Sites to Launch Attac...
- Red Hat, Zend Form OpenShift PaaS Alliance
- PHP IDE News
- BCD, Zend Extend PHP Partnership
- PHP FAQ Highlight
- PHP Creator Didn't Set Out to Create a Langu...
- PHP Trends Revealed in Zend Study
- PHP: Best Methods for Running Scheduled Jobs
- PHP Array Functions: array_change_key_case
- PHP array_combine Function
- PHP array_chunk Function
- PHP Closures as View Helpers: Lazy-Loading F...
- Using PHP Closures as View Helpers
- PHP File and Operating System Program Execut...
- PHP: Effects of Wrapping Code in Class Const...

Developer Shed Affiliates


Dev Shed Tutorial Topics: