Re: Re: Not getting expected result from file()

[Jim Lucas <lists@xxxxxxxxx>]

kvigor wrote:
> Sorry I re-wrote for problem clarity.
>
> FYI whenever I do a var_dump it always shows $stringOne as being 2 
> characters less
>
> e.g.
> var_dump($foodlandPA[45]);
> var_dump($storeInfo);
>
> string(31) "Wellston Foodland Wellston OH " string(29) "Wellston Foodland 
> Wellston OH"

This would be because of the ' ' and "\n" at the end of the 31 char line

use trim to remove the white space before your comparison and it should 
work.

One other thing I noticed, in your SQL insert statement, are all 
variables coming from the post?  If so, do you need to reference the 
$_POST['..'] array instead and clean them??

or have you already done that?

> ""kvigor"" <k3cheese@xxxxxxxxxxxxx> wrote in message 
> news:D4.00.40822.064CC664@xxxxxxxxxxxxxxx
> > Hello,
> >
> > I'm using the file function to create an array.  I'm also using values 
> > from a form to see if it matches any elements in the array.
> >
> > My problem is I expect  the condition to be true, but my DB isn't 
> > populated as it should be if condition was true.
>  =================Code 
> Begins======================================================
> > $theFileArray = file('C:\htdocs\folder1\file.txt');
> >
> >
> > if(isset($_POST['strName'], $_POST['strCity'], $_POST['strState']))
> > {
> > $space = " ";
> > $stringOne = $_POST['strName']. $space. $_POST['strCity']. $space . 
> > $_POST['strState'];
> >
> > }
> > //I match the string "Grantsville Foodland Grantsville MD" letter for 
> > letter in the form and form info gets stored in unknown table and not 
> > central as it should...?
> >
> > if(in_array($stringOne, $theFileArray)) //Any Problem solvers, 
> > suggestions, or new ways to code welcome
> > {
> >  $queryCentral = "INSERT INTO central (conName, conAddress, conCity,
> >
> > conState, conZip, conPhone, schName, schAddress, schCity, schState, 
> > schZip, strName,
> >
> > strCity, strState) VALUES('$regName', '$regAddress', '$regCity', 
> > '$regState',
> >
> > '$regZip', '$regPhone', '$sclName', '$sclAddress', '$sclCity', 
> > '$sclState',
> >
> > '$sclZip', '$stoName', '$stoCity', '$stoState')";
> >
> >  mysql_query($queryCentral, $connection) or die("Query failed: ".
> >
> > mysql_error($connection));
> > }
> >
> >
> > else
> > {
> > $queryUnknown = "INSERT INTO unknown (conName, conAddress, conCity, 
> > conState,
> >
> > conZip, conPhone, schName, schAddress, schCity, schState, schZip, strName, 
> > strCity,
> >
> > strState) VALUES('$regName', '$regAddress', '$regCity', '$regState', 
> > '$regZip',
> >
> > '$regPhone', '$sclName', '$sclAddress', '$sclCity', '$sclState', 
> > '$sclZip',
> >
> > '$stoName', '$stoCity', '$stoState')";
> > mysql_query($queryUnknown, $connection) or die("Query failed: ".
> >
> > mysql_error($connection));
> > }
> >
> > THIS WHAT FILE LOOKS LIKE //Any Problem solvers and suggestion welcome
> > =================================================
> > Begin Row 1
> > Grantsville Foodland Grantsville MD
> > Deep Creek Foodland Fresh Mc Henry MD
> > Oakland Foodland Oakland MD
> > Bridgeport Foodland Bridgeport WV
> > Grafton Foodland Grafton WV
> > Morgan's Foodland Fresh Kingwood WV
> > Petersburg Foodland Petersburg WV
> > Rainelle Foodland Rainelle WV
> > 6th Avenue Foodland St. Albans WV
> > Weston Foodland Weston WV
> > Ambridge Foodland Ambridge PA
> > Curry Hollow Road Foodland Baldwin Pleasant Hills PA
> > Tusca Plaza Foodland Fresh Beaver PA
> > Bethel Park Foodland Bethel Park PA
> > Lebanon Shops Foodland Castle Shannon PA
> > Fatur's Foodland Delmont PA
> > Ford City Ford City PA
> > Glassport Foodland Glassport PA
> > Mount Royal Foodland Glenshaw PA
> > Grindstone Foodland Grindstone PA
> > Kittanning Foodland Kittanning PA
> > Mars Foodland Mars PA
> > Fifth Avenue Foodland Mc Keesport PA
> > Mckees Rocks Mckees Rocks PA
> > Monessen Foodland Fresh Monessen PA
> > Monongahela Foodland Monongahela PA
> > Great Valley Foodland N. Versailles PA
> > Gold Crown Foodland Nanty Glo PA
> > New Brighton Foodland New Brighton PA
> > J & J Foodland New Kensington PA
> > Brownsville Road Foodland Pittsburgh PA
> > Mt Washington Foodland Fresh Pittsburgh PA
> > Beechview Foodland Pittsburgh PA
> > Mcneilly Road Foodland Pittsburgh PA
> > Rochester Road Foodland Pittsburgh PA
> > Pines Plaza Foodland Pittsburgh PA
> > Point Marion Foodland Point Marion PA
> > Beulah Road Foodland Turtle Creek PA
> > Midtown Foodland Uniontown PA
> > Henderson Avenue Foodland Washington PA
> > Interstate Foodland Washington PA
> > Maiden Street Foodland Washington PA
> > Buttermilk Hollow Foodland West Mifflin PA
> > Village Foodland Fresh West Mifflin PA
> > Wellston Foodland Wellston OH
> > Westmoreland Foodland Fresh Huntington WV 


--
Jim Lucas

   "Some men are born to greatness, some achieve greatness,
       and some have greatness thrust upon them."

Unknown

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php