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

If you are not able to get anything into your DB (and your connection is ok), then two things might be wrong: your input or the query string itself. Echo out the query string and try to use the query "manually" (directly with a MySQL client). If the query string is ok, you might check your MySQL connection settings (var_dump, echo etc). If the query string is not ok, you have to look at the input values for the query ($regName, $regAddress etc). //frank 11 jun 2007 kl. 07.27 skrev kvigor:

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.

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