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@xxxxxxxxxxxxxx> wrote in message
news:57.D0.40822.538CC664@xxxxxxxxxxxxxxx
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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
