Remove letter from numeric textbox
Posted on
16th Feb 2014 07:03 pm by
admin
I have a textbox that will search the employee database by entering in the employee ID and it will return the result on the same page.
Query
Code: if(isset($_GET['findagentid']) && $_GET['findagentid']<>""){
$emp_id = $_GET['findagentid'];
mysql_select_db($database_cnccoems, $cnccoems);
$query_rsagentquery1 = "SELECT tblEmployees.employee_pdl_mgr_id, tblManagerOverrides.manager_id, tblEmployees.employee_first_name, tblEmployees.employee_last_name, tblEmployees.employee_id FROM tblEmployees LEFT JOIN tblManagerOverrides ON tblEmployees.employee_id = tblManagerOverrides.employee_id WHERE tblEmployees.employee_id LIKE '%$emp_id%' ";
$rsagentquery1 = mysql_query($query_rsagentquery1, $cnccoems) or die(mysql_error());
$row_rsagentquery1 = mysql_fetch_assoc($rsagentquery1);
$totalRows_rsagentquery1 = mysql_num_rows($rsagentquery1);
if(!is_null($row_rsagentquery1['manager_id'])){
$manager_id=$row_rsagentquery1['manager_id'];
}
else
{
$manager_id=$row_rsagentquery1['employee_pdl_mgr_id'];
}
}
Form
Code: <form method="get" id="agentretrieval" action="callDetail1.php">
<table align="center" cellpadding="2" cellspacing="0">
<tr>
<td><div align="right">Find Agent Info :</div></td>
<td><div align="left"><input type="text" name="findagentid" id="findagentid" class="textboxstyle" size="10" maxlength="7" /> (Digits Only)</div><div class="accenttext"><?php echo $tNGs->displayFieldError("NS_data", "flagentTID"); ?></div> <div align="left"><input type="submit" class="button1" name="findagentbutton" id="findagentbutton" value="Find" /></div></td>
</tr>
</table>
</form>
This works great if entering in digits only like 845787 as they are stored in the database like 00845787. Problem I have is that the ID's are sometimes retrieved by users from another DB with a letter infront of the numbers (eg t845787 or x845787) in one database, but the one I retrieve from has no letter in front.
Hard to explain. Basically Im trying to accomplish this. They can put t845787 in the text box, hit search and it will strip off the t or x from the ID and search the database.
Did I explain that right? Can't figure this out
No comments posted yet
Your Answer:
Login to answer
88
24
Other forums
how do i display data on a page from mysql
1 - do i use this code at the top of each of my page i wish to only alow access if there as been a s
if statements problems
Hi. I'm trying to make a web form, but I kind of hit a dead end trying to figure out why it doesn't
losing session vars when arriving from an email link
Hi,
I've got a confirmation script made that sends an email with a link for a user to confirm
How to calculate days from variable date?
This will be easy for one of you gurus. I want to fetch the date from a variable date, for example:<
CRM?
I think that's what they're called. Customer Management System? Anyway. Is there any good free ones
explode() function problem maybe
Hi I'm having trouble searching my database. When I type two words in the search field it only searc
pls clear my confusion
Hi friends,
Pls solve my query .
what is the exact use of Scope Resolution Operator( i
How do I replace any number of character occurences with one occurrence?
How do I replace any number of character occurences with one occurrence?
Let's say I have:
TinyMCE / Ajax Postback Problem
Hiya all,
I have a page which loads the TinyMCE editor. On the postback I obviously want to f
how to get sn motherboard
Hello.
I want to get serial number motherboard, cpu and else hardware.
Can You show me sam