0 )) { // Open Table echo (""); //Display header row echo (""); //Display each key pair foreach ($aArray as $aKey => $aValue) { echo ""; //if the current value is an array itself //recurse this function, otherwise just //display the value if (!is_array($aValue)) { //if value is empty display that fact. if (empty ($aValue)) {echo "";} else {echo "";} } else {echo ""; } echo "\n"; } echo "
KeyValue
$aKeyempty$aKey$aValue$aKey(array)"; DisplayArray($aValue); echo "
\n"; } else { echo "empty or invalid"; } } function getImageXY($PhotoID,$size){ $query="SELECT FileName FROM Photos WHERE PhotoID=$PhotoID"; $result=result_from_SQL($query); $picRow=mysql_fetch_row($result); $image="photos/$picRow[0]"; //echo "1
". $image ."
"; $srcImg=imagecreatefromjpeg($image); //echo "2
"; $imgSize=getimagesize($image); //echo "3
"; if($imgSize[0]>$imgSize[1]){ $destScaleX=1; $destScaleY=$imgSize[1] * 1 / $imgSize[0]; } else{ $destScaleY=1; $destScaleX=$imgSize[0] * 1 / $imgSize[1]; } if($size==0){ $desiredSize=144; $sample=1; } if($size==1){ $desiredSize=510; $sample=2; } if($desiredSize>$imgSize[0] && $desiredSize>$imgSize[1]){ return $imgSize; } else{ $finalSize[]=$destScaleX*$desiredSize; $finalSize[]=$destScaleY*$desiredSize; return $finalSize; } } // this function could be better! function getArrayOfTracks($conf2003,$conf2006) { $query="SELECT DISTINCT Track FROM Presentations WHERE Conf2003=$conf2003 AND Conf2006=$conf2006 ORDER BY Track"; $result=result_from_SQL($query); while($trackRow=mysql_fetch_row($result)){ $tracks[] = "$trackRow[0]"; } return $tracks; } // this function could be better! function getArrayOfAuthors($FName,$LName,$numCols,$conf2003 = 0,$conf2006 = 0) { $query="SELECT DISTINCT Participants.ParID, FName,LName FROM PresentationLink LEFT JOIN Participants ON PresentationLink.ParID=Participants.ParID LEFT JOIN Presentations ON PresentationLink.PresID=Presentations.PresID WHERE Presentations.Conf2003=$conf2003 AND Presentations.Conf2006=$conf2006 AND Presentations.Active=1 AND 1=1"; if(!empty($FName)){ $query .= " AND FName LIKE '$FName%'"; } if(!empty($LName)){ $query .= " AND LName LIKE '$LName%'"; } $query .= " ORDER BY LName"; $result=result_from_SQL($query); if(mysql_num_rows($result)>1){ $offset=floor(mysql_num_rows($result)/$numCols); $rowNum=0; $colNum=0; while($authorRow=mysql_fetch_row($result)){ $authors[$colNum][$rowNum][0]=$authorRow[0]; $authors[$colNum][$rowNum][1]="$authorRow[2], $authorRow[1]"; if($rowNum<$offset){ $rowNum++; } else{ $rowNum=0; $colNum++; } } } elseif(mysql_num_rows($result)==1){ $rowID=mysql_fetch_row($result); $authors=$rowID[0]; } else{ $authors=''; } return $authors; } function getPresentations($track = "",$title = "",$content = "",$ParID = "",$FName = "",$LName = "",$conf2003 = 0,$conf2006 = 0) { if($track=='Any') unset($track); $query="SELECT DISTINCT Presentations.PresID,Presentations.Title,PptFileName,AbstractText,AbstractFileName FROM Presentations LEFT JOIN PresentationLink ON Presentations.PresID=PresentationLink.PresID LEFT JOIN Participants ON PresentationLink.ParID=Participants.ParID WHERE Presentations.Active=1 AND Presentations.Conf2003=$conf2003 AND Presentations.Conf2006=$conf2006"; if(!empty($track)){ $query .= " AND Track='$track'"; } if(!empty($ParID)){ $query .= " AND Participants.ParID=$ParID"; } if(!empty($title)){ $query .= " AND (Presentations.Title LIKE '%$title%')"; } if(!empty($content)){ $query .= " AND (AbstractText LIKE '%$content%')"; } if(!empty($FName)){ $query .= " AND (FName LIKE '%$FName%')"; } if(!empty($LName)){ $query .= " AND (LName LIKE '%$LName%')"; } $query .= " ORDER BY Presentations.Title"; // print $query; $result=result_from_SQL($query); $PRES_LIS = createPresentationString($result); return $PRES_LIS; } function createPresentationString($result){ $PRES_LIS = ''; $trigger=false; while($presRow=mysql_fetch_row($result)){ $trigger=true; $PRES_LIS .= "

$presRow[1]

"; $query2 = "SELECT PresentationLink.ParID, Participants.FName, Participants.LName FROM PresentationLink LEFT JOIN Participants ON PresentationLink.ParID=Participants.ParID WHERE (PresID=$presRow[0]) AND ((AuthorType='presenter') OR (AuthorType='both')) ORDER BY Participants.LName"; $result2 = result_from_SQL($query2); if(mysql_num_rows($result2)>0) $PRES_LIS .= "Presented by: "; $counter=0; while($partRow=mysql_fetch_row($result2)){ if($counter!==0) $PRES_LIS .= ", "; $PRES_LIS .= "$partRow[1] $partRow[2]"; $counter++; } //$PRES_LIS .= "
"; //if(!empty($presRow[3])) $PRES_LIS .= "  "; //if(!empty($presRow[2])) $PRES_LIS .= "  "; //$PRES_LIS .= "
"; } if(!$trigger){ $PRES_LIS = "No matching records"; } return $PRES_LIS; } function lettersLinks($letter) { for ($i = 65; $i < (65+26); $i++ ) { $links[$i] = "".chr($i).""; } $active = ord($letter); if ($active >= 65 && $active < (65+26)) { $links[$active] = "".chr($active).""; } return join($links,", "); } ?>
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /net/web/dept.old/icadi/public.www/includes/db_functions.php on line 43

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /net/web/dept.old/icadi/public.www/includes/db_functions.php on line 46

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /net/web/dept.old/icadi/public.www/2003/photos.php on line 32

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /net/web/dept.old/icadi/public.www/2003/photos.php on line 34

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /net/web/dept.old/icadi/public.www/includes/db_functions.php on line 43

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /net/web/dept.old/icadi/public.www/includes/db_functions.php on line 46

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /net/web/dept.old/icadi/public.www/2003/photos.php on line 98
Access Denied! You must enter a username and password.

Login EOD; $PAGE_CONTENT .= <<
need password?

If you attended the 2003 conference and have not received a username and password, please complete the form below. All fields should be filled in.

EOD; $PAGE_CONTENT .= (isset($errmsg)) ? $errmsg : ''; if (!$success) { $PAGE_CONTENT .= << Full Name

Country

Email

Phone Number
EOD; } $PAGE_CONTENT .= "
"; $BODY_CLASS = "authorize"; } elseif($PHP_AUTH_USER != $username || $PHP_AUTH_PW != $password) { if (!$formsubmitted) { header("WWW-Authenticate: Basic realm=\"ICADI Restricted\""); header("HTTP/1.0 401 Unauthorized"); } $PAGE_CONTENT = <<Access Denied! Incorrect username or password.

Login EOD; $PAGE_CONTENT .= <<
need password?

If you attended the 2003 conference and have not received a username and password, please complete the form below. All fields should be filled in.

EOD; $PAGE_CONTENT .= (isset($errmsg)) ? $errmsg : ''; if (!$success) { $PAGE_CONTENT .= << Full Name

Country

Email

Phone Number
EOD; } $PAGE_CONTENT .= "
"; $BODY_CLASS = "authorize"; } } //} ?> ICADI : 2003 Conference Photos
ICADI: International Conference on Aging, Disability and Independence

2003 Conference Photos

View by Participant
photos