<form action="<? echo $PHP_SELF ?> " method=GET
<?php
function getmicrotime (){
$usec , $sec ) = explode ( " " , microtime ());
$usec + (float) $sec );
/*Define your photo database. make it a .csv file with records on separate lines*/
$db = "db.csv" ;
/*Define the fields in the database: 0= unique record number (id), 1=category ... etc*/
$id = 0 ;
$cat = 1 ;
$dir = 2 ;
$pic = 3 ;
$title = 4 ;
$comment = 5 ;
/*Check which page is required, and set to 1 if unknown*/
if ( $p == "" ){
$p = 1 ;
/*Define Possible categories*/
$catarray = array( holiday , this , that , the_other );
/*Look for pictures in a particular category if $c is given and*/
if ( in_array ( $c , $catarray )){
"<div class=cyan> Category: $c " ;
$recs_returned = 0 ;
$fp = fopen ( $db , "r" );
$data = fgetcsv ( $fp , 1000 , ";" )) {
$srch = " $data [ $cat ] " ;
preg_match ( "/ $c /i" , $srch )) {
$recs_returned ++;
fclose ( $fp );
/*Split up records returned into blocks of 10*/
$roundrecs = $recs_returned / 10 ;
$pages = ceil ( $roundrecs );
". $recs_returned records are in this category. Page $p of
$pages </div>" ;
$recs_returned > 10 ){
$k = 1 ;
"<center>" ;
$k <= $pages ){
$p == $k ){
"[" . $k . "]" ;
$k ++;
"<b><a href=" . $PHP_SELF . "?c=" . $c . "&t=" . $t . "&p=" . $k . ">[" . $k . "]</a></b>" ;
$k ++;
"</center>" ;
"<br><table border=0 cellspacing=4 cellpadding=2 width=\"100%\">" ;
$fp = fopen ( $db , "r" );
$l = 0 ;
$even = 0 ;
$start_record = 10 * ( $p - 1 );
$end_record = $start_record + 10 ;
$data = fgetcsv ( $fp , 1000 , ";" )) {
$srch = " $data [ $cat ] " ;
preg_match ( "/ $c /i" , $srch )) {
$l >= $start_record ) {
$t == 1 ) {
$even == 0 ){
"<tr>" ;
$even = 3 ;
"<td width=\"50%\"><center>" . $data [ $title ] . "<br>" ;
"<a href=pics/process4.php3?id=" . $data [ $id ] . ">" .
"<img src=pics/" . $data [ $dir ]
"/thumbs/" . $data [ $pic ] . "></a>" ;
"<font size=-1>" . $data [ $id ] . "</font><br>" ;
"<i>" . $data [ $comment ]. "</center></i></td>" ;
$even == 1 ){
"</tr><tr><td colspan=2><hr size=1 width=\"50%\"></td></tr>" ;
$even = 0 ;
$even == 3 ){
$even = 1 ;
$data [ $id ] . ": " ;
$data [ $title ] . "</a> - <i>" ;
$data [ $comment ] . "</i><br>" ;
/*END if ($t == 1)*/
} /*END if ($l >= $start_record)*/
$l ++;
$l == $end_record ){
/* END if (preg_match ("/$c/i", $srch))*/
} /*END while ($data = fgetcsv ($fp, 1000, ";"))*/
print "</table>" ;
fclose ( $fp );
$q == "" ){
"pic.inc" );
/* ~~~~~~~~~~~~~~ Searchy Loopy ~~~~~~~~~~~~~~~~~ */
$i = "0" ; /* Count Records Searched */
$start_time = getmicrotime ();
$recs_returned = 0 ;
$fp = fopen ( $db , "r" );
$data = fgetcsv ( $fp , 1000 , ";" )) {
$srch = " $data [ 3 ] $data [ 4 ] $data [ 5 ] $data [ 6 ] $data [ 7 ] " ;
preg_match ( "/ $q /i" , $srch )) {
$recs_returned ++;
$i ++;
fclose ( $fp );
$roundrecs = $recs_returned / 10 ;
$pages = ceil ( $roundrecs );
"<div class=cyan><font color=#000000>Searched for
$q \". $recs_returned records found. Displaying page $p of
$pages </font></div>" ;
/*This bit outputs the other pages available*/
if ( $recs_returned > 10 ){
$k = 1 ;
"<center>" ;
$k <= $pages ){
$p == $k ){
"[" . $k . "]" ;
$k ++;
"<b><a href=" . $PHP_SELF . "?q=" . $q . "&t=" . $t . "&p=" . $k . ">[" . $k . "]</a></b>" ;
$k ++;
"</center>" ;
$fp = fopen ( $db , "r" );
$l = 0 ;
$even = 0 ;
$start_record = 10 * ( $p - 1 );
$end_record = $start_record + 10 ;
"<br><table border=0 cellspacing=4 cellpadding=2 width=\"100%\">" ;
$fp = fopen ( "pics/db/" . $album . ".csv" , "r" );
$data = fgetcsv ( $fp , 1000 , ";" )) {
$srch = " $data [ 3 ] $data [ 4 ] $data [ 5 ] $data [ 6 ] $data [ 7 ] " ;
preg_match ( "/ $q /i" , $srch )) {
$l >= $start_record ) {
$t == 1 ) {
$even == 0 ){
"<tr>" ;
$even = 3 ;
"<td width=\"50%\"><center>" . $data [ $title ] . "<br>" ;
"<a href=pics/process4.php3?id=" . $data [ $id ] . ">" .
"<img src=pics/" . $data [ $dir ]
"/thumbs/" . $data [ $pic ] . "></a>" ;
"<font size=-1>" . $data [ $id ] . "</font><br>" ;
"<i>" . $data [ $comment ]. "</center></i></td>" ;
$even == 1 ){
"</tr><tr><td colspan=2><hr size=1 width=\"50%\"></td></tr>" ;
$even = 0 ;
$even == 3 ){
$even = 1 ;
$data [ $id ] . ": " ;
$data [ $title ] . "</a> - <i>" ;
$data [ $comment ] . "</i><br>" ;
$j ++;
/*END if ($l >= $start_record) {*/
$l ++;
$l == $end_record ){
$i ++;
"</table>" ;
"<hr size=1 width=50%>" ;
$j == "0" ) {
$i . " records searched<br>Sorry, nothing found." );
$i . " records searched, " . $recs_returned . " items found." );
$end_time = getmicrotime ();
$long_time = 1000 * ( $end_time - $start_time );
$time = round ( $long_time );
"<br>Search took $time milliseconds" ;
?>
phpEasyMail: An easy way to send data from HTML-forms via EMail. Categories : Email , HTML and PHP , Complete Programs , PHP Tropicalm Genetree Family (MySQL based family tree) Categories : PHP , Interfaces , Databases , MySQL , Complete Programs phpYellow Pages Standard Categories : PHP , Complete Programs , Databases , Directories , Search Client classes for Dictionary servers UPDATED: 2000-06-06 Categories : Network , Search , Complete Programs , PHP Classes , PHP BBS system for easy customization. Utilizes mySQL. Categories : Complete Programs , MySQL , PHP , Databases Validator 98 - a PHP-script to generate form-validation-code in JavaScript. Categories : Complete Programs , Java Script , PHP , HTML and PHP Modification of Shane Caraveo's guestbook. Uses ODBC...some code modifications Categories : ODBC , Databases , Complete Programs , PHP simple shopping cart for php3 Categories : PHP , PHP Classes , Complete Programs , Ecommerce phpFreeChat Categories : PHP , AJAX , Complete Programs PHP-MySQL shopping cart
Categories : PHP , Ecommerce , Complete Programs databases administration remote Web Categories : mSQL , PHP , Complete Programs , Databases This is a very simple BBS that uses MySQL Categories : MySQL , Databases , Complete Programs , PHP GuestBook Light - a plug and play application for any website. Categories : PHP , Complete Programs , Filesystem , Sessions DBE - Database Expander: Edit PostgreSQL individual database tables online via your Web browser! Categories : PostgreSQL , Complete Programs , Databases , PHP Classes , PHP GroupIT Content Management and Community Engine Categories : PHP , Complete Programs , Content Management
Adam Hayward wrote : 664
Sorry, just re-read that submission. I know, I can`t spell. I`ve just spent 8 hours infront of the computer, my eyes are square, my exams are looming, it`s 4am, my nose runs, my feet smell and I don`t love Jesus. Oh well, here`s the script in full for cuttin` `n` pastin` (and seing how naff it is before you download it). And peeps, I REALLY would appreciate helpful feedback. just remove "DONTSPAMMEPLEASE." from my addy.
