File manager - Edit - /home/autoph/public_html/portal/includes/menu/masterfile/pms_search_department_results.php
Back
<?php $compCode = $user_data['company_assignment']; echo "<h3 style='padding-left:5px;padding-top:2px'>SEARCH RESULTS</h3>"; echo "<div style='top:114px;left:97.8%;position:absolute;z-index:3'> <a href='main_new.php?view=100&sid=M1&sview=100&tab=0&#id-0' style='display:block;width:17px;height:17px;border:1px solid gray;background:lightgray;border-radius:2px'> <center>X</center> </a> </div>"; echo "<div style='width:99.8%;height:100%;border:1px solid gray;min-height:480px;background:#f4f4f4'>"; ?> <div style='width:97.9%;height:40px;border:1px solid lightgray;background:#f2f2f2;padding-left:20px;padding-top:3px'> <a href='main_new.php?view=100&sview=100&sid=M1&action=new&tab=0#id-0'><ABBR title='Add New Record'><img src='./images/new.png' onmouseover="this.src='images/new_.png';" onmouseout="this.src='images/new.png';" /></ABBR></a> <a href='main_new.php?view=100&sview=721&sid=ADV&action=edit&tab=0#id-0'><ABBR title='Advance Search Module'><img src='./images/filter_a.png' onmouseover="this.src='images/filter_b.png';" onmouseout="this.src='images/filter_a.png';" /></ABBR></a> <div style='position:relative;height:30px;width:500px;border:1px solid #f2f2f2;background:#f2f2f2;top:-40px;left:100px;padding-top:4px;border-left:1px solid lightgray;padding-left:30px'> <form action='' method='GET'> <input type='hidden' name='view' value='102'> <input type='hidden' name='sview' value='100'> <input type='hidden' name='tab' value='1'> <input type='hidden' name='sid' value='P1S'> Search : <input type='text' name='searchBox' value='' style='padding-left:10px;width:300px;border:1px solid gray;background:white;height:30px;border-radius:5px 0px 0px 5px'> <input type='submit' name='goSearch' value='Search' style='width:70px;border:1px solid gray;height:30px;border-radius:0px 5px 5px 0px'> </form> </div> </div> <div style='width:99.5%;height:430px;border:0px solid lightgray;background:#f2f2f2;padding:2px;overflow:auto'> <?php $searchString = $_GET['searchBox']; $qq=mysql_query("SELECT * FROM `departments` WHERE `name` LIKE '%$searchString%' || `code` LIKE '%$searchString%' ORDER by `name` ASC "); //$qq=mysql_query("SELECT * FROM `dealers` WHERE `status`='1' ORDER by `name` DESC "); echo "<div STYLE='height: 490px; width: 100%; font-size: 12px; overflow: auto;'> <table style='width:100%; height:100% border:1px solid gray; border-collapse:collapse;'>"; echo "<tr> <th class='Gradient' align='left' style='width:2%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'></th> <th class='Gradient' align='left' style='width:7%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>DEPT. CODE</th> <th class='Gradient' align='left' style='width:25%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>DEPARTMENT NAME</th> <th class='Gradient' align='left' style='width:15%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>DIRECT LINE</th> <th class='Gradient' align='left' style='width:15%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>DIRECT FAX</th> <th class='Gradient' align='left' style='width:25%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>DEPT. EMAIL</th> <th class='Gradient' align='left' style='width:6%;background:#f5f5f5;border:1px solid lightgray;font-size:12px'>STATUS</th>"; echo "</tr>"; while($row = mysql_fetch_array($qq)){ echo "<tr>"; echo "<td class='tableList'> <a href='main_new.php?id=".$row['id']."&view=102&sview=100&sid=P1P&action=edit&tab=1#id-0'> <img src='images/rica/edit_a.png'></img></a> </td>"; echo "<td class='tableList'>" . STRTOUPPER($row['code']) . "</td>"; echo "<td class='tableList'>" . STRTOUPPER($row['name']) . "</td>"; echo "<td class='tableList'>" . STRTOUPPER($row['trunk_line']) . "</td>"; echo "<td class='tableList'>" . STRTOUPPER($row['fax_number']) . "</td>"; echo "<td class='tableList'>" . STRTOUPPER($row['email']) . "</td>"; echo "<td class='tableList'>"; $stat = $row['status']; if($stat == 1){ echo 'ACTIVE'; }else { echo 'INACTIVE'; } echo "</td>"; echo "</tr>"; } echo "</table>"; ?> </div> <?php echo "</div>"; ?>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings