File manager - Edit - /home/autoph/public_html/portal/includes/searchpage/b_gender.php
Back
<?php $bb=$_GET['bb']; $qq = mysql_query("SELECT * FROM `talents_profile` WHERE `status`='1' AND `gender`='$bb' ORDER BY `lname` ASC"); echo "<div STYLE='height: 400px; width: 100%; font-size: 12px; overflow: auto;'>"; echo "<table style='width:100%; height:100% border:1px solid gray; border-collapse:collapse;'>"; echo "<tr> <th class='Gradient' style='text-align:center;width:10px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;height:35px'></th> <th class='Gradient' align='left' style='width:148px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>LAST NAME</th> <th class='Gradient' align='left' style='width:100px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>FIRST NAME</th> <th class='Gradient' align='left' style='width:150px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>M.I</th> <th class='Gradient' align='left' style='width:150px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>ALIAS</th> <th class='Gradient' align='left' style='width:50px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>GENDER</th> <th class='Gradient' align='left' style='width:50px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>AGE</th> <th class='Gradient' align='left' style='width:63px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>DATE HIRED</th>"; echo "</tr>"; while($row = mysql_fetch_array($qq)){ $dateOfBirth = $row['birthdate']; $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); //echo "My Age: ".$newAge; if($newAge == $aa){ echo "<tr>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:center;width:10px;height:18px'> <a href='main_new.php?view=100&sview=1024&sid=&search=&view=plist&id=".$row['id']."&tab=0#id-0'><img src='images/rica/edit_a.png'></img></a> </td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;width:150px;height:18px;padding-left:5px'>" . STRTOUPPER($row['lname']) . "</td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;width:100px;height:18px;padding-left:5px'>" . STRTOUPPER($row['fname']) . "</td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;width:150px;height:18px;padding-left:5px'>" . STRTOUPPER($row['mname']) . "</td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;width:50px;height:18px;padding-left:5px'>" .STRTOUPPER($row['alias']) . "</td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;width:50px;height:18px;padding-left:5px'>" .STRTOUPPER($row['gender']) . "</td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:right;width:30px;height:25px;padding-right:10px;padding-left:5px;background:yellow'>"; $dateOfBirth = $row['birthdate']; $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); if($newAge > 0){ echo $newAge; } echo "</td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:center;width:50px;height:18px;padding-left:5px'>" .STRTOUPPER($row['date_hired']) . "</td>"; echo "</tr>"; } } echo "</table>"; echo "</div>"; ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings