File manager

File manager - Edit - /home/autoph/public_html/portal/includes/searchpage/s_talent.php

Back
<?php $tsA=$_GET['tsA']; $tsB=$_GET['tsB']; $tsC=$_GET['tsC']; if(empty($tsB) && empty($tsC)){ // A ONLY $qq = mysql_query("SELECT * FROM `skills` WHERE `status`='1' AND `title` LIKE '%$tsA%' \|\| `description` LIKE '%$tsA%' ORDER BY `title` ASC"); }else if(!empty($tsB) && empty($tsC)){ // A AND B ONLY $qq = mysql_query("SELECT * FROM `skills` WHERE `status`='1' AND `title` LIKE '%$tsA%' \|\| `title` LIKE '%$tsB%' \|\| `description` LIKE '%$tsA%' \|\| `description` LIKE '%$tsB%' ORDER BY `title` ASC"); }if(empty($tsB) && !empty($tsC)){ // A & C ONLY $qq = mysql_query("SELECT * FROM `skills` WHERE `status`='1' AND `title` LIKE '%$tsA%' \|\| `title` LIKE '%$tsC%' \|\| `description` LIKE '%$tsA%' \|\| `description` LIKE '%$tsC%' ORDER BY `title` ASC"); } //$qq = mysql_query("SELECT * FROM `skills` WHERE `status`='1' AND `title` LIKE '%$tsA%' \|\| `title` LIKE '%$tsB%' \|\| `title` LIKE '%$tsC%' \|\| `description` LIKE '%$tsA%' \|\| `description` LIKE '%$tsB%' \|\| `description` LIKE '%$tsC%' ORDER BY `title` 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:15%;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>LAST NAME</th> <th class='Gradient' align='left' style='width:15%;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>FIRST NAME</th> <th class='Gradient' align='left' style='width:10%;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>ALIAS</th> <th class='Gradient' align='left' style='width:5%;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>GENDER</th> <th class='Gradient' align='left' style='width:5%;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>AGE</th> <th class='Gradient' align='left' style='width:45%;background:#f5f5f5;border:1px solid lightgray;font-size:12px;padding-left:5px'>SKILLS / TALENTS</th>"; echo "</tr>"; while($row = mysql_fetch_array($qq)){ $tID = $row['talent_id']; $dateOfBirth = mysql_result(mysql_query("SELECT `birthdate` FROM `talents_profile` WHERE `id`='$tID'"),0); $today = date("m/d/Y"); $diff = date_diff(date_create($dateOfBirth), date_create($today)); $newAge = $diff->format('%y'); $lName = mysql_result(mysql_query("SELECT `lname` FROM `talents_profile` WHERE `id`='$tID'"),0); $fName = mysql_result(mysql_query("SELECT `fname` FROM `talents_profile` WHERE `id`='$tID'"),0); $Alias = mysql_result(mysql_query("SELECT `alias` FROM `talents_profile` WHERE `id`='$tID'"),0); $gender = mysql_result(mysql_query("SELECT `gender` FROM `talents_profile` WHERE `id`='$tID'"),0); 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=".$tID."&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($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($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($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($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;'>"; echo $newAge; echo "</td>"; echo "<td style='font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;width:50px;height:18px;padding-left:5px;background:yellow'>" .STRTOUPPER($row['title']).": " .STRTOUPPER($row['description']) . "</td>"; echo "</tr>"; } echo "</table>"; echo "</div>"; ?>

| ver. 1.4 | . | PHP 8.1.32 | Generation time: 0.01 | proxy | phpinfo | Settings