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

Your Answer:

Login to answer

Other forums

Php navigation
I have four buttons on a php page.
If i click a button it will redirect to different php pages.

Looping Problem
I've got a client that has a database with about 200 events at any given time. I'm trying to loop t

PHP hyperlinks generator - HELP plz
Hi

I need some help to get this done using php:


1 - I have few hyperlinks say 500

Generate multilayered array from string.
ok so i have a string that looks like this:
Code: [Select]blog:edit_all,delete_all|users:edit_all

Text Not Displaying Correctly With PHP:GD
I recently moved servers and since then I have noticed that one line of text is showing weirdly.

Count of reciepients in php mailer
How can i sent a mail to large no of reciepients say 10,00,00 Using PHP MAILER

Mouseover to edit (Ajax)
hi friends, can anyone help with the code behind to get this application working, please in VB (new

need help with mail()
hi i want to send an email with attaching pdf file using php. i have the following script but the pr

Place specific image in html page when specific name is typed.
Hello,

Fairly new to PHP and was curious if someone might know how to solve a fairly simple r

Adding delete feature to my forum
Hello I am currently trying to add a delete feature to my forum. I believe I have everything built r