| Server IP : 192.249.121.117 / Your IP : 216.73.216.251 Web Server : Apache System : Linux ded4606.inmotionhosting.com 3.10.0-1160.81.1.el7.x86_64 #1 SMP Fri Dec 16 17:29:43 UTC 2022 x86_64 User : oakben5 ( 1001) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/oakben5/public_html/career/ |
Upload File : |
<!DOCTYPE html>
<html>
<head>
<style>
table {
font-family: arial, sans-serif;
border-collapse: collapse;
width: 100%;
}
td, th {
border: 1px solid #dddddd;
text-align: left;
padding: 8px;
}
tr:nth-child(even) {
background-color: #dddddd;
}
</style>
</head>
<body>
<?php
$servername = "mysqlv113";
$username = "obmc_onboard";
$password = "Obmc#123";
$dbname="obmc_onboard";
$scheme = 'https://';
// Create connection
$conn = new mysqli("mysqlv113", "obmc_onboard", "Obmc#123","obmc_onboard");
/*SELECT preapp . * , tbl_vacancy.fld_vacancy_requisitionid, tbl_vacancy.fld_vacancy_position, tbl_vacancy.fld_vacancy_uniqposition
FROM `preapp`
INNER JOIN tbl_vacancy ON fld_vacancy_id = `vacencyid`
*/
$sql = "SELECT preapp . * , tbl_vacancy.fld_vacancy_requisitionid, tbl_vacancy.fld_vacancy_position, tbl_vacancy.fld_vacancy_uniqposition
FROM `preapp`
INNER JOIN tbl_vacancy ON fld_vacancy_id = `vacencyid` ";
$result = mysqli_query($conn, $sql);
$i=1;
?>
<table>
<tr>
<th>#</th>
<th>Name</th>
<th>Email</th>
<th>Phone</th>
<th>Vacency </th>
<th>Vacency Code </th>
<th>Apply time</th>
</tr>
<?php
if (mysqli_num_rows($result) > 0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
?>
<tr>
<td>
<?php echo $i ;$i++; ?></td>
<td><?php echo $row["name"] ; ?></td>
<td><?php echo $row["email"] ; ?></td>
<td><?php echo $row["phone"] ; ?></td>
<td><?php echo $row["fld_vacancy_position"] ; ?></td>
<td><?php echo $row["fld_vacancy_uniqposition"]; ?></td>
<td><?php echo $row["time"] ; ?></td>
</tr>
<?php
}
} else {
echo "0 results";
}
?>
</table>
</body>
</html>