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 Like 24 Dislike
Previous forums Next forums
Other forums

php redirecting
i wont open a new thread but i have a question about redirecting....
i wonder why my code doesnt

gather checkbox data from form into email
Hello all,

First, i'd like to thank everyone who responded to my previous posts regarding set

mail with attachment problems
Hi. I have the following code:
Code: else if(file_exists("site".$timp.".zip")

Why is my row count 0?
Here's the MySQL query i'm running. It basically pulls data from 2 tables based on some data passed.

simple ping code
been searchin the site/web and found code thats simple but doesnt work.

I have a personal we

Need help with a mail notify function
I was tasked with setting up a site that's been prewritten. The site is basically a form that captur

tell csv import script to ignore blank rows?
Hi i have the below script but i get an error if a row is blank ie a return in the csv file at the e

Why will this program not run if the variables are not global?
Hey guys I have a kind of perplexing situation that is probably simple, but I can't seem to understa

How to ... (FAQs)
... get e-mail notifications As several people asked how to get e-mail notifications when new posti

Dynamic memory problem
Hey,

At the beginning of my code, I have this line:

Shape* gShape = 0;

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash