<?php
require_once "header.php";
require_once "function.php";
require_once "sidemenu.php";
?>
<?php
if (!isset($_GET['id'])) {
echo "<script>window.location='index.php';</script>";
exit;
}
$job = job_type($_GET['id']);
$project = get_project_details($_GET['id']);
$total_mp = total_mp_pmb($_GET['id']);
$project_job = get_user_profile($_GET['id']);
if ($project['username'] == NULL) {
echo "<script>window.location='index.php'</script>";
exit;
}
?>
<SCRIPT>
function GetXmlHttpObject()
{
var XMLHttpRequestObject=null;
try
{
// Firefox, Opera 8.0+, Safari
XMLHttpRequestObject=new XMLHttpRequest();
}
</table>
<table width="96%" cellpadding="1" cellspacing="1" align="center">
<tr height="20" bgcolor="#dde1e8">
<td class="header_text"> Projects Name</td>
<td class="header_text"> Bids</td>
<td class="header_text"> Avg Bids</td>
<td class="header_text"> Job type</td>
<td class="header_text"> Stated Time</td>
<td class="header_text"> End Time</td>
</tr>
<?php
$r = retrive_project("featured");
foreach ($r as $project) {
$project_status = get_project_details($project['id']);
$job = job_type($project['id']);
if ($project_status['status'] != "Expired") {
?>
<tr height="20" class="dark">
<td>
<a href="project.php?id=<?php
echo $project['id'];
?>
"><?php
echo $project["project_title"];
?>
</a>
<?php
if ($project['featured'] == 1) {
echo "[F]";
}
function search($keyword)
{
$sql = "SELECT *,DATE_FORMAT(created_time,'%m/%d/%Y at %H:%i:%s') AS created_time FROM `projects` WHERE MATCH (`project_title`) AGAINST ('" . $keyword . "' IN BOOLEAN MODE)";
$link = mysql_query($sql, $_SESSION['cn']) or die("Error Search Data : " . mysql_error());
echo "Project Search Results :";
echo "<table border='0' cellpadding='2' cellspacing='2'><tr bgcolor='#dde1e8'>\r\n\t\t<td class=\"header_text\">Project Name</td><td class=\"header_text\">Description</td>\r\n\t\t<td class=\"header_text\">Job Type</td><td class=\"header_text\">Bids</td>\r\n\t\t<td class=\"header_text\">Avg Bid</td><td class=\"header_text\">Status</td>\r\n\t\t<td class=\"header_text\">Started Date</td>\r\n\t\t</tr>";
while ($row = mysql_fetch_assoc($link)) {
?>
<tr class="dark">
<td class="dark" align="">
<a href="project.php?id=<?php
echo $row['id'];
?>
"><?php
echo ucwords($row['project_title']);
?>
</a>
<?php
if ($row['featured'] == 1) {
echo "[F]";
}
if ($row['private'] == 1) {
echo "[P]";
}
?>
</td>
<td ><?php
echo $row['description'];
?>
</td>
<td><?php
echo job_type($row['id']);
?>
</td>
<td><?php
echo count_bids($row['id']);
?>
</td>
<td>Avg Bid</td>
<td align="center" width="2%">
<?php
if ($row['status'] == 1) {
echo "<img src='admin/right.jpg'>";
} else {
echo "<img src='admin/wrong.gif'>";
}
?>
</td>
<td align="center"><?php
echo $row['created_time'];
?>
</td>
</tr>
<?php
}
// Secound Statement
$sql = "SELECT *,DATE_FORMAT(created_time,'%m/%d/%Y at %H:%i:%s') AS created_time FROM `projects` WHERE MATCH (`description`) AGAINST ('" . $keyword . "')";
$link = mysql_query($sql, $_SESSION['cn']) or die("Error Search Data : " . mysql_error());
while ($row = mysql_fetch_assoc($link)) {
?>
<tr class="dark">
<td>
<a href="project.php?id=<?php
echo $row['id'];
?>
"><?php
echo ucwords($row['project_title']);
?>
</a>
<?php
if ($row['featured'] == 1) {
echo "[F]";
}
if ($row['private'] == 1) {
echo "[P]";
}
?>
</td>
<td><?php
echo $row['description'];
?>
</td>
<td><?php
echo job_type($row['id']);
?>
</td>
<td><?php
echo count_bids($row['id']);
?>
</td>
<td>
Avg Bid
</td>
<td align="center" width="2%">
<?php
if ($row['status'] == 1) {
echo "<img src='admin/right.jpg'>";
} else {
echo "<img src='admin/wrong.gif'>";
}
?>
</td>
<td align="center"><?php
echo $row['created_time'];
?>
</td>
</tr>
<?php
}
echo "</table>";
}
