File manager

File manager - Edit - /home/autoph/public_html/ahglegal/includes/menu/masterfile/search_patient_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:110px;left:97.5%;position:absolute;z-index:3'> <a href='main_new.php?view=100&sid=NB&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=100&sid=M1&action=edit&tab=0#id-0'><ABBR title='Edit Record'><img src='./images/edit.png' onmouseover="this.src='images/edit_.png';" onmouseout="this.src='images/edit.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='100'> <input type='hidden' name='sview' value='100'> <input type='hidden' name='tab' value='0'> <input type='hidden' name='sid' value='MS'> 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 `notary_public` WHERE `status`='1' AND `book_id`='$book_id' ORDER by `doc_no` DESC"); $qq=mysql_query("SELECT * FROM `notary_public` WHERE `date` LIKE '%$searchString%' \|\| `des` LIKE '%$searchString%' \|\| `signatory` LIKE '%$searchString%' \|\| `account` LIKE '%$searchString%' \|\| `encoded_by` LIKE '%$searchString%' ORDER by `date` 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:5px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;height:28px'></th> <th class='Gradient' align='left' style='width:50px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;height:28px'>BOOK NO.</th> <th class='Gradient' align='left' style='width:50px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;height:28px'>DOC. NO.</th> <th class='Gradient' align='left' style='width:80px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;height:28px'>PAGE. NO.</th> <th class='Gradient' align='center' style='width:100px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;height:28px'>DATE</th> <th class='Gradient' align='center' style='width:300px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;height:28px'>DESCRIPTION</th> <th class='Gradient' align='center' style='width:150px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;height:28px'>NAME OF SIGNATORIES</th> <th class='Gradient' align='center' style='width:250px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;height:28px'>COMPANY / ACCOUNT</th> <th class='Gradient' align='center' style='width:250px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;height:28px'>GOVT. ID NO.</th> <th class='Gradient' align='center' style='width:100px;background:#f5f5f5;border:1px solid lightgray;font-size:12px;height:28px'>BY</th>"; while($row = mysql_fetch_array($qq)){ $myColor = mysql_result(mysql_query("SELECT `color` FROM `c_users` WHERE `u_name`='".$row['encoded_by']."'"),0); $bookName = mysql_result(mysql_query("SELECT `book_name` FROM `my_book` WHERE `id`='".$row['book_id']."'"),0); echo "<tr>"; echo "<td style='background:$myColor;font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:center;height:25px'> <a href='#'><img src='images/rica/edit_a.png'></img></a> </td>"; echo "<td style='background:$myColor;font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;height:25px;padding-left:5px'>" . STRTOUPPER($bookName) . "</td>"; echo "<td style='background:$myColor;font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;height:25px;padding-left:5px'>" . STRTOUPPER($row['doc_no']) . "</td>"; echo "<td style='background:$myColor;font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;height:25px;padding-left:5px'>" . STRTOUPPER($row['page_no']) . "</td>"; echo "<td style='background:$myColor;font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:center;height:25px;padding-left:5px'>" .STRTOUPPER($row['date']) . "</td>"; echo "<td style='background:$myColor;font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;height:25px;padding-left:5px'>" .STRTOUPPER($row['des']) . "</td>"; echo "<td style='background:$myColor;font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;height:25px;padding-left:5px'>" .STRTOUPPER($row['signatory']) . "</td>"; echo "<td style='background:$myColor;font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;height:25px;padding-left:5px'>" .STRTOUPPER($row['account']) . "</td>"; echo "<td style='background:$myColor;font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:left;height:25px;padding-left:5px'>" .STRTOUPPER($row['gov_id']) . "</td>"; echo "<td style='background:$myColor;font-size:10px;color:$fontColor;border:1px solid lightgray;text-align:center;height:25px;padding-left:5px'>" .STRTOUPPER($row['encoded_by']) . "</td>"; //<a href='main_new.php?view=100&sview=100&sid=M1&action=update&search=".$row['patient_fname']."&view=plist&id=".$row['patient_id']."&tab=0#id-0'>View</a>"; // echo "</td>"; echo "</tr>"; } echo "</table>"; ?> </div> <?php echo "</div>"; ?>

| ver. 1.4 | . | PHP 7.3.33 | Generation time: 0 | proxy | phpinfo | Settings