Re: Not getting expected result from file()
| From: | kvigor | Date: | Mon, 11 Jun 2007 05:27:07 +0000 |
| Subject: | Re: Not getting expected result from file() | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-256587@lists.php.net to get a copy of this message | ||
Trimmed elements in the array. I still can't get it to store in central
table. No MySQL errors either. :-(
(Also, all form values are escaped.) Strings compared in if condition are
now identical.
newcode
===============================================
theFileArray = file('C:\htdocs\folder1\file.txt');
function trim_value(&$value)
{
$value = trim($value);
}
array_walk($theFileArray, 'trim_value');
if(isset($_POST['strName'], $_POST['strCity'], $_POST['strState']))
{
$space = " ";
$stringOne = $_POST['strName']. $space. $_POST['strCity']. $space .
$_POST['strState'];
}
if(in_array($stringOne, $theFileArray)) // string were identical after I
trimmed an did var_dump on $stringOne and $theFileArray[2]
{
$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));
}
============================================================================
"David Robley" <robleyd@ozemail.com.au> wrote in message
news:57.D0.40822.538CC664@pb1.pair.com...
> kvigor wrote:
>
>> Hello,
>>
>> I'm using the file function create an array. I'm using a value from a
>> form to see if it matches in elements in the array.
>>
>> My problem is I expect the condition to be true but info but my DB isn't
>> populated as I in the right DB...
>> =================Code
>> Begins======================================================
>> $theFileArray = file('C:\htdocs\folder1\file.txt');
>>
>
> Your problem starts here - file returns the file in an array. Each element
> of the array corresponds to a line in the file, with the newline still
> attached. When you compare to a string without the newline at the end, the
> comparison fails.
>
> If you have php > 5.0.0 you can use the FILE_IGNORE_NEW_LINES flag in the
> file() arguments, otherwise use trim() to remove trailing whitespace from
> the array elements.
>
>
>
> Cheers
> --
> David Robley
>
> "I hate playing craps," Tom said dicily.
> Today is Boomtime, the 16th day of Confusion in the YOLD 3173.