Viewing file:  itjobs_placementlist.php (4.8 KB) -rw-rw-r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
// include 'connection_itjobs.php';
include 'connection.php';
$packages = "SELECT * FROM course_details where popular=1";
$packagesResult = $con->query($packages);
while ($packages = $packagesResult->fetch_assoc())
{
?>
<h3 class="training"><?php echo $packages['name']; ?></h3>
<?php }
$sql = "SELECT * from `tb_candidate_placed` order by `placed_id` desc";
$result = $con_it->query($sql);
$row = $result->fetch_assoc();
// print_r($row);
echo $row["candidate_name"]; echo "---";
echo $row["company_name"]; echo "---";
echo $row["position"]; echo "---";
echo $row["picture"]; echo "---";
$sql1 = "SELECT * from `tb_candidate_placed` order by `placed_id` desc LIMIT 1,1";
$result1 = $con_it->query($sql1);
$row1 = $result1->fetch_assoc();
echo $row1['candidate_name'];echo "---";
echo $row1['company_name'];echo "---";
echo $row1['position'];echo "---";
echo $row1['picture'];echo "---";
$sql2 = "SELECT * from `tb_candidate_placed` order by `placed_id` desc LIMIT 2,1";
$result2 = $con_it->query($sql2);
$row2 = $result2->fetch_assoc();
echo $row2["candidate_name"];echo "---";
echo $row2["company_name"];echo "---";
echo $row2["position"];echo "---";
echo $row2["picture"];echo "---";
$sql3 = "SELECT * from `tb_candidate_placed` order by `placed_id` desc LIMIT 3,1";
$result3 = $con_it->query($sql3);
$row3 = $result3->fetch_assoc();
echo $row3['candidate_name'];echo "---";
echo $row3['company_name'];echo "---";
echo $row3['position'];echo "---";
echo $row3['picture'];echo "---";
// while ($row = $result->fetch_assoc())
// {
// echo $row['candidte_name'];
// }
// $packages1 = "select * from tb_candidate_placed";
// $packagesResult1 = mysqli_query($con, $packages1) or die("database error:" . mysqli_error($con));
// while ($packages1 = mysqli_fetch_assoc($packagesResult1))
// {
// echo $packagesResult1['candidte_name'];
// }
?>
<?php
$sql11 = "SELECT * from `tb_add_jobs` order by `id` desc";
$result11 = $con_it->query($sql11);
$row11 = $result11->fetch_assoc();
// print_r($row);
echo $row["job_title"]; echo "---";
echo $row["qualification"]; echo "---";
echo $row["job_description"]; echo "---";
echo $row["prefered_skills"]; echo "---";
echo $row["job_location"]; echo "---";
echo $row["start_date"]; echo "---";
echo $row["end_date"]; echo "---";
echo $row["experience_from"]; echo "---";
echo $row["experience_to"]; echo "---";
$sql22 = "SELECT * from `tb_add_jobs` order by `id` desc LIMIT 1,1";
$result22 = $con_it->query($sql22);
$row22 = $result22->fetch_assoc();
echo $row22["job_title"]; echo "---";
echo $row22["qualification"]; echo "---";
echo $row22["job_description"]; echo "---";
echo $row22["prefered_skills"]; echo "---";
echo $row22["job_location"]; echo "---";
echo $row22["start_date"]; echo "---";
echo $row22["end_date"]; echo "---";
echo $row22["experience_from"]; echo "---";
echo $row22["experience_to"]; echo "---";
$sql3 = "SELECT * from `tb_add_jobs` order by `id` desc LIMIT 2,1";
$result3 = $con_it->query($sql3);
$row3 = $result3->fetch_assoc();
echo $row3["job_title"]; echo "---";
echo $row3["qualification"]; echo "---";
echo $row3["job_description"]; echo "---";
echo $row3["prefered_skills"]; echo "---";
echo $row3["job_location"]; echo "---";
echo $row3["start_date"]; echo "---";
echo $row3["end_date"]; echo "---";
echo $row3["experience_from"]; echo "---";
echo $row3["experience_to"]; echo "---";
$sql44 = "SELECT * from `tb_add_jobs` order by `id` desc LIMIT 3,1";
$result44 = $con_it->query($sql44);
$row44 = $result44->fetch_assoc();
echo $row44["job_title"]; echo "---";
echo $row44["qualification"]; echo "---";
echo $row44["job_description"]; echo "---";
echo $row44["prefered_skills"]; echo "---";
echo $row44["job_location"]; echo "---";
echo $row44["start_date"]; echo "---";
echo $row44["end_date"]; echo "---";
echo $row44["experience_from"]; echo "---";
echo $row44["experience_to"]; echo "---";
?>
|