php regular expressions

[simbarashe]

Hie

could someone please help me> I'm trying to use a regular expression to validate and address and it is as follows.

eregi('(^[a-zA-Z0-9 \\\.,-]+)$',$value4)

$value4 = 10/54 kent street;

I want to allow the users to put in slashes as part of their addresses so I'm looking 4 a simple regular expression to do that.

Thank you

[Atli]

Hie

could someone please help me> I'm trying to use a regular expression to validate and address and it is as follows.

eregi('(^[a-zA-Z0-9 \\\.,-]+)$',$value4)

$value4 = 10/54 kent street;

I want to allow the users to put in slashes as part of their addresses so I'm looking 4 a simple regular expression to do that.

Thank you

If I'm not very much mistaken, putting a '/' in front of your '\\\' would do the trick.

[pbmods]

You'll probably want something like this:

preg_match('/^[\d]+(\/[\d]+)?(\b\w)+$/', $value4);
 

That would most closely match '10/54 kent street'.

The regular expression there matches at least one number, then optionally (a slash followed by at least one number), then at least one word.

If you want to be able to do something like '10/54 west 3rd street', you'll have to modify it slightly (assumes that street names only start with numbers and never have numbers in the middle or end):

preg_match('/^[\d]+(\/[\d]+)?(\b\d*\w)+$/', $value4);
 

For more info:
http://www.regular-expressions.info/reference.html

[simbarashe]

You'll probably want something like this:

preg_match('/^[\d]+(\/[\d]+)?(\b\w)+$/', $value4);
 

That would most closely match '10/54 kent street'.

The regular expression there matches at least one number, then optionally (a slash followed by at least one number), then at least one word.

If you want to be able to do something like '10/54 west 3rd street', you'll have to modify it slightly (assumes that street names only start with numbers and never have numbers in the middle or end):

preg_match('/^[\d]+(\/[\d]+)?(\b\d*\w)+$/', $value4);
 

For more info:
http://www.regular-expressions.info/reference.html

I tried that script but it didnt do the trick, thanks for it though maybe I needed to twist and turn a little bit to make it suitable for my use. I managed to use the script that i had made before but however I have encountered and even bigger problem and it is as follows:

Could someone please help me with my regular expresssions because my script is behaving in a rather wierd way when I implement the regular expressions. I am checking names and addresses before I insert them into my database but the regular expression function is not working when the MYSQL INSERT QUERIES are running. Below is my script and I'm just going to briefly explain it. The isWord($value,$pageURL) funtion is in a file called dbFunction.php and its as follows:

function isWord($value,$pageURL){
$value2 = trim(stripslashes($value));
f((strlen($value2) == 0) or (!ereg("^[[:alpha:]'-]{1,100}$",$value2))){
$uri = "//" . $_SERVER["SERVER_NAME"]. rtrim(dirname($_SERVER['PHP_SELF']), '/\\');
header("Location: http:".$uri.$pageURL."&err=1");
}else{
return $value2;
}
}

[Please use CODE tags when posting source code. Thanks! --pbmods]

I then called it in dbJobsheet as follows:

$firstName = isWord($_POST['firstName'],$errorPageURL);

this works perfectly because if I put in invalid characters I get redirected to the error page. However when I put in the script to insert the data into the database the above isWord($value,$pageURL) doesnt work.

the script that stops all this from working is as follows:

<?
$timeQuery = mysql_query("SELECT date_assinged,time_assigned,assStaffID 
 
FROM FOLLOW_UP WHERE
time_assigned ='$newTime' AND 
date_assinged = '$newAssignedDate' 
AND assStaffID = '$assStaffID' ")
or die(mysql_error());
 
$results = mysql_fetch_array($timeQuery);
//checks if there is a time clash and redirects user to the page to re-enter the information. 
if ((count($results)-1)>0){ 
header('Location: index.php? 
page=redirectOldClientsJobSheet.php&err=6'); } 
 
//checks is the contact exists
elseif(mysql_num_rows(mysql_query("SELECT contactID FROM 
CONTACTS WHERE first_name = '$firstName' 
AND last_name = '$lastName' AND 
email_address = '$email_address' "))){
 
mysql_query("INSERT INTO STATUS VALUES(
NULL,'$status','$description') ") 
or die (mysql_error());
 
$statusID = mysql_query("SELECT statusID FROM STATUS WHERE
statusID = 'LAST_INSERT_ID()' ") or die (mysql_error());
 
mysql_query("INSERT INTO JOBSHEET VALUES(
NULL,'$clientID',LAST_INSERT_ID(),'$staffID','$COD','$billed',
CURRENT_DATE(),'$warranty','$jobID','$contactID','$title',
'$complete','$log')") or die (mysql_error()); 
 
header('Location: index.php?page=oldClientsEnteredInfoDisplay.php'); 
}
else{ 
header('Location: index.php?page=redirectOldClientsJobSheet.php&err=7');
} 
}
?>