rcleon
asked on
Searching and display a result.
I have a page that list all of my employees in aphabeticcal order.
I would like to create a box where I could type a persons lastname and it would bring that record to the top or would hightlight the record.
Any ideas?
Thanks
Rafael
I would like to create a box where I could type a persons lastname and it would bring that record to the top or would hightlight the record.
Any ideas?
Thanks
Rafael
How do you get the list? Is it a text file? Or is it from a database query?
ASKER
Is from a MySQL database the query display all the records on a page.
You could have a query that will bring only the employe you are looking for.
ASKER
I think that may do the trick I will try. Thanks
If you can show your code I can help you out with this
ASKER
Great you asked for it so here it is:
<?php
session_start();
require('../dbc.php');
require('../tables.php');
$display = 10;
if (isset($_GET['p']) && is_numeric($_GET['p'])) {
$pages = $_GET['p'];
} else {
$Query = "SELECT COUNT(EID) FROM $Table2";
$Result = mysql_query($Query);
$Row = mysql_fetch_array($Result) ;
$records = $Row[0];
if ($records > $display) {
$pages = ceil($records/$display);
} else { $Pages = 1;
}
} // End of p IF
// Determine where in the database to start returning results...
if (isset($_GET['s']) && is_numeric($_GET['s'])) {
$start = $_GET['s'];
} else {
$start = 0;
}
// Determine where in the database to start returning results...
if (isset($_GET['s']) && is_numeric($_GET['s'])) {
$start = $_GET['s'];
} else {
$start = 0;
}
// Determine the sort...
// Default is by registration date.
$sort = (isset($_GET['sort'])) ? $_GET['sort'] : 'rd';
// Determine the sorting order:
switch ($sort) {
case 'ln':
$order_by = 'LastName ASC';
break;
case 'fn':
$order_by = 'FirstName ASC';
break;
case 'rd':
$order_by = 'EID ASC';
break;
default:
$order_by = 'EID ASC';
$sort = 'rd';
break;
}
$Query = "SELECT *
FROM $Table1, $Table2
WHERE $Table1.CompanyNumber = '$_SESSION[CompanyNumber]' AND $Table2.CompanyNumber = '$_SESSION[CompanyNumber]'
ORDER BY $order_by
LIMIT $start,$display";
$Result = mysql_query($Query);
echo '<tr>
<td class="SubHeader"><a href="UserMaintenance.php? sort=EID"> EID</a></t d>
<td class="SubHeader">View</td >
<td class="SubHeader">Print</t d>
<td class="SubHeader">Edit</td >
<td class="SubHeader">Delete</ td>
<td class="SubHeader"><a href="UserMaintenance.php? sort=ln">L ast Name</a></td>
<td class="SubHeader"><a href="UserMaintenance.php? sort=fn">F irst Name</a></td>
<td class="SubHeader">Username </td>
<td class="SubHeader"> </ td>
</tr>';
$bg = '#eeeeee';
while ($EmpInfo=mysql_fetch_obje ct($Result )) {
$bg = ($bg=='#eeeeee' ? '#ffffff' : '#eeeeee');
echo '<tr bgcolor="' . $bg . '">
<td valign="top" class="GeneralText">' . $EmpInfo->EID . '</td>';
echo '<td>
<form action="../home.php" id="View" method="post" target="_blank">
<input type="hidden" name="UID" value="' . $EmpInfo->UID . '">
<input type="hidden" name="EID" value="' . $EmpInfo->EID . '">
<input type="hidden" name="submitted" value="' . TRUE . '">
<input type="submit" name="submit" value="View"></form>
</td>';
echo '<td>';
if( $EmpInfo->PrintFormat == "S") {
echo '<form action="../pfv/stdindex.ph p" id="Print" method="post" target="_blank">
<input type="hidden" name="UID" value="' . $EmpInfo->UID . '">
<input type="hidden" name="EID" value="' . $EmpInfo->EID . '">
<input type="submit" name="admin" value="Print"></form>';
}
if($EmpInfo->PrintFormat == "N") {
echo '<form action="../pfv/newsindex.p hp" id="Print" method="post" target="_blank">
<input type="hidden" name="UID" value="' . $EmpInfo->UID . '">
<input type="hidden" name="EID" value="' . $EmpInfo->EID . '">
<input type="submit" name="admin" value="Print"></form>';
}
if($EmpInfo->PrintFormat == "B") {
echo '<form action="../pfv/bookindex.p hp" id="Print" method="post" target="_blank">
<input type="hidden" name="UID" value="' . $EmpInfo->UID . '">
<input type="hidden" name="EID" value="' . $EmpInfo->EID . '">
<input type="submit" name="admin" value="Print"></form>';
}
echo '</td>';
echo '<td>
<form action="EditEmployee.php" id="Edit" method="post">
<input type="hidden" name="UID" value="' . $EmpInfo->UID . '">
<input type="hidden" name="EID" value="' . $EmpInfo->EID . '">
<input type="submit" name="admin" value="Edit"></form>
</td>
<td>
<form action="Delete.php" id="Delete" method="post">
<input type="hidden" name="UID" value="' . $EmpInfo->UID . '">
<input type="hidden" name="EID" value="' . $EmpInfo->EID . '">
<input type="submit" name="submit" value="Delete"></form>
</td>
<td valign="top" class="GeneralText">' . $EmpInfo->LastName . '</td>
<td valign="top" class="GeneralText">' . $EmpInfo->FirstName . '</td>
<td valign="top" class="GeneralText">' . $EmpInfo->Username . '</td>
<td valign="top" class="GeneralText"><img src="../images/Spacer.gif" alt="" width="50" height="1" border="0"></td>
</tr>';
} // End While loop
echo '<tr><td colspan="7"><img src="images/Spacer.gif" alt="" width="1" height="20" border="0"></td></tr>
</table>';
mysql_free_result($Result) ;
mysql_close($dbc);
// Make the links to other pages, if necessary.
if ($pages > 1) {
echo '<br /><div class="pagination">';
$current_page = ($start/$display) + 1;
// If it's not the first page, make a Previous button:
if ($current_page != 1) {
echo '<a href="UserMaintenance.php? s=' . ($start - $display) . '&p=' . $pages . '&sort=' . $sort . '">Previous</a> ';
}
// Make all the numbered pages:
for ($i = 1; $i <= $pages; $i++) {
if ($i != $current_page) {
echo '<a href="UserMaintenance.php? s=' . (($display * ($i - 1))) . '&p=' . $pages . '&sort=' . $sort . '">' . $i . '</a>';
} else {
echo '<span class=current>' . $i . ' ' . '</span>' ;
}
} // End of FOR loop.
// If it's not the last page, make a Next button:
if ($current_page != $pages) {
echo '<a href="UserMaintenance.php? s=' . ($start + $display) . '&p=' . $pages . '&sort=' . $sort . '">Next</a>';
}
echo '</div>'; // Close the paragraph.
} // End of links section.
?>
<?php
session_start();
require('../dbc.php');
require('../tables.php');
$display = 10;
if (isset($_GET['p']) && is_numeric($_GET['p'])) {
$pages = $_GET['p'];
} else {
$Query = "SELECT COUNT(EID) FROM $Table2";
$Result = mysql_query($Query);
$Row = mysql_fetch_array($Result)
$records = $Row[0];
if ($records > $display) {
$pages = ceil($records/$display);
} else { $Pages = 1;
}
} // End of p IF
// Determine where in the database to start returning results...
if (isset($_GET['s']) && is_numeric($_GET['s'])) {
$start = $_GET['s'];
} else {
$start = 0;
}
// Determine where in the database to start returning results...
if (isset($_GET['s']) && is_numeric($_GET['s'])) {
$start = $_GET['s'];
} else {
$start = 0;
}
// Determine the sort...
// Default is by registration date.
$sort = (isset($_GET['sort'])) ? $_GET['sort'] : 'rd';
// Determine the sorting order:
switch ($sort) {
case 'ln':
$order_by = 'LastName ASC';
break;
case 'fn':
$order_by = 'FirstName ASC';
break;
case 'rd':
$order_by = 'EID ASC';
break;
default:
$order_by = 'EID ASC';
$sort = 'rd';
break;
}
$Query = "SELECT *
FROM $Table1, $Table2
WHERE $Table1.CompanyNumber = '$_SESSION[CompanyNumber]'
ORDER BY $order_by
LIMIT $start,$display";
$Result = mysql_query($Query);
echo '<tr>
<td class="SubHeader"><a href="UserMaintenance.php?
<td class="SubHeader">View</td
<td class="SubHeader">Print</t
<td class="SubHeader">Edit</td
<td class="SubHeader">Delete</
<td class="SubHeader"><a href="UserMaintenance.php?
<td class="SubHeader"><a href="UserMaintenance.php?
<td class="SubHeader">Username
<td class="SubHeader"> </
</tr>';
$bg = '#eeeeee';
while ($EmpInfo=mysql_fetch_obje
$bg = ($bg=='#eeeeee' ? '#ffffff' : '#eeeeee');
echo '<tr bgcolor="' . $bg . '">
<td valign="top" class="GeneralText">' . $EmpInfo->EID . '</td>';
echo '<td>
<form action="../home.php" id="View" method="post" target="_blank">
<input type="hidden" name="UID" value="' . $EmpInfo->UID . '">
<input type="hidden" name="EID" value="' . $EmpInfo->EID . '">
<input type="hidden" name="submitted" value="' . TRUE . '">
<input type="submit" name="submit" value="View"></form>
</td>';
echo '<td>';
if( $EmpInfo->PrintFormat == "S") {
echo '<form action="../pfv/stdindex.ph
<input type="hidden" name="UID" value="' . $EmpInfo->UID . '">
<input type="hidden" name="EID" value="' . $EmpInfo->EID . '">
<input type="submit" name="admin" value="Print"></form>';
}
if($EmpInfo->PrintFormat == "N") {
echo '<form action="../pfv/newsindex.p
<input type="hidden" name="UID" value="' . $EmpInfo->UID . '">
<input type="hidden" name="EID" value="' . $EmpInfo->EID . '">
<input type="submit" name="admin" value="Print"></form>';
}
if($EmpInfo->PrintFormat == "B") {
echo '<form action="../pfv/bookindex.p
<input type="hidden" name="UID" value="' . $EmpInfo->UID . '">
<input type="hidden" name="EID" value="' . $EmpInfo->EID . '">
<input type="submit" name="admin" value="Print"></form>';
}
echo '</td>';
echo '<td>
<form action="EditEmployee.php" id="Edit" method="post">
<input type="hidden" name="UID" value="' . $EmpInfo->UID . '">
<input type="hidden" name="EID" value="' . $EmpInfo->EID . '">
<input type="submit" name="admin" value="Edit"></form>
</td>
<td>
<form action="Delete.php" id="Delete" method="post">
<input type="hidden" name="UID" value="' . $EmpInfo->UID . '">
<input type="hidden" name="EID" value="' . $EmpInfo->EID . '">
<input type="submit" name="submit" value="Delete"></form>
</td>
<td valign="top" class="GeneralText">' . $EmpInfo->LastName . '</td>
<td valign="top" class="GeneralText">' . $EmpInfo->FirstName . '</td>
<td valign="top" class="GeneralText">' . $EmpInfo->Username . '</td>
<td valign="top" class="GeneralText"><img src="../images/Spacer.gif"
</tr>';
} // End While loop
echo '<tr><td colspan="7"><img src="images/Spacer.gif" alt="" width="1" height="20" border="0"></td></tr>
</table>';
mysql_free_result($Result)
mysql_close($dbc);
// Make the links to other pages, if necessary.
if ($pages > 1) {
echo '<br /><div class="pagination">';
$current_page = ($start/$display) + 1;
// If it's not the first page, make a Previous button:
if ($current_page != 1) {
echo '<a href="UserMaintenance.php?
}
// Make all the numbered pages:
for ($i = 1; $i <= $pages; $i++) {
if ($i != $current_page) {
echo '<a href="UserMaintenance.php?
} else {
echo '<span class=current>' . $i . ' ' . '</span>' ;
}
} // End of FOR loop.
// If it's not the last page, make a Next button:
if ($current_page != $pages) {
echo '<a href="UserMaintenance.php?
}
echo '</div>'; // Close the paragraph.
} // End of links section.
?>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
gamebits, sorry I took so long to get back to the question but had couple of emergencies,
Thanks for your response with a little actualy very little twicking it worked great just what I was looking for.
Thanks for all your time and effort
Rafael
Thanks for your response with a little actualy very little twicking it worked great just what I was looking for.
Thanks for all your time and effort
Rafael
ASKER
Thanks soooooooooooooooo much for all your help