Table Cross reference

cschotch

Ok, I got a page which displays information per person whether they have been somewhere or not. Now the ones mean they were there that day. The 0's mean they havent. Problem is the formatting is atrocious....
here it is... http://www.invisiblewarriors.com/weekly/weekdec915.html

Now problem was I lost my whole computer down the drain. I have been slowly rebuilding this php script but I am horribly stuck. I want to do the names via a text file, read that file as a "config" file and also the other 7 days are also files.
What it used to do is look through each daily file search for that name then output a 1 or 0.....
Anybody got any ideas on how to advance through the days and make it look better?

Kerry_Kobashi

Really not much you can do with the list. But I would do the following to make it look a little better:

a) Use two columns, one for the user name, the other for the boolean visit. Make column 1 be a fixed width either in percent or in pixel size. Make column 2 the remainder.

Name Visit

User1 1
User2 0
User3 0
User4 1

b) Sort the list out alphabetically

c) Change the font to verdana or some sans-serif font

d) Alternate the colors for each row. Say white for all even numbers and a light cray #cccccc for the odd colors.

e) Use a background color for the column headings

Use CSS to pull this off.

planetsim

Depending if this list is gonna be big. If it reaches more than 100 in the textfile you may wanna use MySQL. Textfiles are pretty slow once they reach a certain amount i found 100 columns to slow mine down considerably.

cschotch

ok heres th code for my script for the link above....now where would I change this ..... im stuck in the listings of the names every single time it goes through... don't know where to go

<?php
$monday = $_POST['monday'];
$tuesday = $_POST['tuesday'];
function Chk_File($filename) {

$fp = fopen($filename,"r") or die("Failed!");  

$end_report = fread($fp, filesize($filename));

$names['WhereArtThou'] = 0;
$names['BlackBart'] = 0;
$names['Jonesey'] = 0;

foreach(array_keys($names) as $value){ 
    $names[$value] = substr_count($end_report, $value); 
}  

foreach($names as $key=>$value) { 
    echo "$key: ";                    //$names[$key] <br />\n"; 
    if ($value >= '1') echo "1";
    else echo "0";
    echo '<br />';

} 
fclose($fp);  

}
echo '<center><b>These are the results for the files you specified.</b></center>';

echo "<TABLE>\n";
echo '<th>Monday</th>';
echo '<th>Tuesday</th>';
echo "     <TR>\n";
$filename = array($monday,$tuesday);
for($i = 0; $i < count($filename); $i++) {
     echo "          <TD>";
     Chk_File($filename[$i]);
     echo "          </TD>";
}
echo "     </TR>\n";
echo "</TABLE>\n";

?>

I dont know if maybe I should change it to a different kind of looping or what....is there a way to store the results into a associtive array then sort it out later??

Thanks for your help on this its greatly appreciated

cschotch

bump...can someone help me please?