Is it time to move away from procedural?
Posted: Thu Jul 26, 2007 8:36 am
This page pulls a specific project from the databse
Code: Select all
<?php
# * WORK item * #
$pid=$_GET['id'];
require_once(DB);
$query="SELECT P.project_id, P.project_name, P.project_des, P.category_id, P.location_id, C.category_full FROM project P, category C WHERE project_id='$pid' AND P.category_id=C.category_id";
$result=mysql_query($query) OR DIE (mysql_error());
$row=mysql_fetch_assoc($result);
//Save for Later!
$location=$row['location_id'];
if (mysql_num_rows($result)){
echo "<h3>".$row['project_name']."</h3>\n";
echo "<p>".$row['project_des']."</p>\n";
/*Check for Images */
$path="images/work/".$row['project_id'].'/';
$dir=opendir($path);
while($name=readdir($dir)){
if (preg_match("/t+([0-9]+\.jpg)$/",$name,$sp)){
$nameb=ereg_replace('t','', $name);
echo '<a href="'.BASE_URL.$path.$sp[1].'" rel="lightbox" title="'.$row['project_name'].'">';
echo '<img class="work" src="'.BASE_URL.$path.$name.'" alt="'.$row['project_name'].'" width="140" />';
echo "</a> \r";
}
}
//PDF
echo '<p><img src="'.BASE_URL.'images/pdf-icon.gif" /> <a class="workU" href="'.BASE_URL.'modules/pdf.php?pid='.$pid.'"> View Project Brief.</a></p>';
//DEATAILS Section
echo "<p><strong>Details</strong><br />\n";
echo "Category: ";
//Categories the project is listed under
$a=explode(' ',$row['category_id']);
foreach ($a as $key=>$value){
$query="SELECT category_full, category_id FROM category where $value=category_id";
$result=mysql_query($query) OR DIE (mysql_error());
$row=mysql_fetch_assoc($result);
$cat=$row['category_id'];
if(mysql_num_rows($result)){
echo '<a class="workU" href="'.BASE_URL.'category-'.$cat.'.html" class="underline">'.$row['category_full']."</a>\n";
} else {
echo "The project is not categorized.";
}
}
echo "<br />\n";
// Locaton of the project
echo "Location: ";
$query="SELECT location_id, location_ct, location_st, location_st_full, location_co FROM location WHERE location_id='$location'";
$result=mysql_query($query) OR DIE (mysql_error());
$row=mysql_fetch_assoc($result);
$city=ereg_replace(' ','-', trim($row['location_ct']));
$state=ereg_replace(' ','-', trim($row['location_st']));
echo '<a class="workU" href="'.BASE_URL.'location-'.$city.'-'.$row['location_id'].'.html">'.$row['location_ct']."</a>";
//IN PROGRESS
if($row['location_st']){
echo ', <a class="workU" href="'.BASE_URL.'location-'.$state.'-'.$row['location_id'].'.html">'.$row['location_st_full']."</a>\n";
}
if ($row['location_co'] != "USA"){
echo ', <a class="workU" href="'.BASE_URL.'work.php?mode=loc&co='.$row['location_id'].'">'.$row['location_co'].'</a>';
}
echo "</p>\r";
$query="SELECT project_id, people_fname, people_lname, people_mem, people_id FROM people WHERE project_id LIKE '%$pid%'";
$result=mysql_query($query) or die (mysql_error());
if(!mysql_num_rows($result)){
echo'';
}else{
echo "<p><strong>People</strong><br />";
while($row=mysql_fetch_assoc($result)){
$membership=ereg_replace(' ',', ', $row['people_mem']);
echo '<a class="workU" href="'.BASE_URL.'bio-'.$row['people_fname'].'-'.$row['people_lname'].'-'.$row['people_id'].'.html">'.$row['people_fname'].' '.$row['people_lname'].', '.$membership.'</a><br />';
}
echo "</p>\n";
}
echo '<p><strong><a class="work" href="'.BASE_URL.'category-'.$cat.'.html">< Project List</a></strong></p>';
} else {
echo 'There are no additional details available.';
}
?>