Variable not populating from array

[gfrank]

I can't seem to figure out where I am messing up here...

I don't have the actual script in front of me, otherwise I would just post it... but let me describe it...

I have a script that is loading data from a tab delimited file into an array row by row. Each row has 23 columns/data elements. After each row of data loads into the array I am trying to capture only 8 of the elements and save them into a mySQL table.

So at each row I am trying to populate varibles, to clean and place into the database, with the info in the array varibles... something simple like this...

$elementOne = $array[2];
$elementTwo = $array[6];
$elementThree= $array[9];

It seems that if the data in the array element is text... the normal varible will properly be populated, but if the data in the array element is numerical... the normal variable does NOT populate. I can't figure out why.

I even tried this to test it by printing both the array variable and the normal varible to see if it is populating...

$elementOne = $array[2];
echo $array[2]."<BR>";
echo $elementOne."<BR>";

The print of the $array[2] produces a number,
but the print of the normal variable produces nothing.

so the data is loading into the array varible but not into the normal varible... what am I missing?

[tekky]

would really help to see the code.... sounds like a code issue....

[gfrank]

I'll try to post the code tomorrow when I can get to it on my other computer.

thanks

[gfrank]

Ok, here is the code that is giving me trouble...

if (is_uploaded_file($FILES['file']['tmp_name'])) // if the file uploaded
{
$file_realname = $FILES['file']['name'];
copy($_FILES['file']['tmp_name'], "$file_realname"); //Copy to server
if(@$filetype == "qbooks") // did this come from a certain form on the site?
{
$query = "TRUNCATE TABLE quickbooks_inv"; // clear old data out of table
$updated = mysql_query($query) or die ("Could not Clear Database");
//insert data from IIF file into table from file uploaded
$num = 0;
$row = 0;
$id = fopen("FILE URL GOES HERE".$file_realname,"r"); //open the file
while ($data = fgetcsv($id, 5000, "\t"))
{
$num = count ($data);
$row++;
for ($c=0; $c < $num; $c++)
{
if($data[$c] == "INVITEM") // This entry in the data indicates the beginning of an inventory item in the file
{
if($data[4] == "INVENTORY") // make sure it is of this catagory
{
if(($data[10] != "") AND ($data[10] != 0)) // only if there is one or more in inv
{
$itemnumber = $data[1];
$itemnumber = htmlspecialchars("$itemnumber", ENT_QUOTES);

																$mfg_= $data[22];
																$mfg = htmlspecialchars("$mfg", ENT_QUOTES);

																$datecode_= $data[23];
																$datecode = htmlspecialchars("$datecode", ENT_QUOTES);

																$quant_= $data[10];
																$quant = htmlspecialchars("$quant", ENT_QUOTES);

																$description_= $data[5];
																$description = htmlspecialchars("$description", ENT_QUOTES);

																$nsn = $data[26];
																$nsn = htmlspecialchars("$nsn", ENT_QUOTES);

																$condition = $data[25];
																$condition = htmlspecialchars("$condition", ENT_QUOTES);

																$crossref = $data[24];
             $crossref = htmlspecialchars("$crossref", ENT_QUOTES);

             $query = "INSERT INTO quickbooks_inv (qb_itemnumber, qb_mfg, qb_datecode, qb_quantity, qb_description, qb_nsn, qb_condition, qb_crossref) VALUES ('$itemnumber','$mfg','$datecode','$quant','$description','$nsn','$condition','$crossref')";
																$updated = mysql_query($query) or die ("Could not update record ($row-1) - $c");
															}

													}
												}

							}
								}

						//delete file uploaded
						unlink("$file_realname");
						echo "TEMP FILE DELETED FROM SERVER<BR><BR>";
					} // end if qbooks
			} 
			else // (not uploaded)
			{ 
						echo "<b><font color=red>No file uploaded.</font></b><BR>No file available or file too big to upload.";
						$file_realname = "";
					}

Can anyone see why any of those variables that I an trying to put into the database would not be populating with numerical data (Especially the $quant variable)?

Thanks

[tekky]

have you tried to print_r($arrayname) to see what your arrays are actually recieving?

[gfrank]

I have done this...

$elementOne = $array[2];
echo $array[2]."<BR>";
echo $elementOne."<BR>";

result...

a number prints from the array variable... but not from the normal variable which should be the same.

at one time I put hte array variables into the mySQL statement and it properly transfered the data... but because the data needs to be cleaned of single quotes I have to transfer it to a varible and clean it with htmlspecialchars("$variblename", ENT_QUOTES) before I can put it into the mySQL statment.

[tekky]

try doing this

echo '<pre>';
print_r($array);
echo '</pre>';

and posting what your array looks like... i'm thinking the array isnt quite what you are expecting

[gfrank]

Where do i put that code?

in the loop afterwhile ($data = fgetcsv($id, 5000, "\t"))
{

?

[tekky]

after your array is finished being created so its fully populated
or you could do it in each while loop to see what data the fgetcsv is pulling out

[gfrank]

I put your check code in the loop to show the array after each loop...

so it is showing an array for each product row it pulls out of the file...

and I got what I expected to be there. Here is an example of what I got from your check code for one of the products in the file:

Array
(
[0] => INVITEM
[1] => .22UF630V10
[2] => 4
[3] => 922491716
[4] => INVENTORY
[5] => CAPACITOR
[6] => CAPACITOR
[7] => Resale Income
[8] => Inventory
[9] => Cost of Goods Sold
[10] => 50
[11] => 26
[12] => 1.05
[13] => 0.52
[14] => N
[15] => Non
[16] =>
[17] =>
[18] =>
[19] => STANDARD RADIO ELECTRICAL PRODUCTS
[20] =>
[21] =>
[22] => PLESSEY
[23] =>
[24] =>
[25] => NE
[26] =>
[27] => 0
[28] => N
[29] => N
[30] => 0
[31] => N
)

#10 is the quantity amount that I am especially concerned about.

[tekky]

ahah... hmmmm

if (is_uploaded_file($_FILES['file']['tmp_name'])) // if the file uploaded 
{ 
$file_realname = $_FILES['file']['name']; 
copy($_FILES['file']['tmp_name'], "$file_realname"); //Copy to server 
if(@$filetype == "qbooks") // did this come from a certain form on the site? 
{ 
$query = "TRUNCATE TABLE quickbooks_inv"; // clear old data out of table 
$updated = mysql_query($query) or die ("Could not Clear Database"); 
//insert data from IIF file into table from file uploaded 
$num = 0; 
$row = 0; 
$id = fopen("FILE URL GOES HERE".$file_realname,"r"); //open the file 
while ($data = fgetcsv($id, 5000, "\t")) 
{ 
$num = count ($data); 
$row++; 
for ($c=0; $c < $num; $c++) 
{ 
if($data[$c] == "INVITEM") // This entry in the data indicates the beginning of an inventory item in the file 
{ 
if($data[4] == "INVENTORY") // make sure it is of this catagory 
{ 
if(($data[10] != "") AND ($data[10] != 0)) // only if there is one or more in inv 
{ 
$itemnumber = $data[1]; 
$itemnumber = htmlspecialchars($itemnumber, ENT_QUOTES); //removed surrounding " not needed in variable inputs to functions

$mfg = $data[22]; //removed _ from end of $mfg
$mfg = htmlspecialchars($mfg, ENT_QUOTES); //removed " again

$datecode = $data[23]; //removed _ from end of $datecode
$datecode = htmlspecialchars($datecode, ENT_QUOTES); //removed " again

$quant = $data[10]; //removed _ from end of $quant
$quant = htmlspecialchars($quant, ENT_QUOTES);  //removed " again

$description = $data[5]; //removed _ from end of $description
$description = htmlspecialchars($description, ENT_QUOTES); //removed " again

$nsn = $data[26]; 
$nsn = htmlspecialchars($nsn, ENT_QUOTES); //removed " again

$condition = $data[25]; 
$condition = htmlspecialchars($condition, ENT_QUOTES); //removed " again

$crossref = $data[24]; 
$crossref = htmlspecialchars($crossref, ENT_QUOTES); //removed " again

$query = "INSERT INTO quickbooks_inv (qb_itemnumber, qb_mfg, qb_datecode, qb_quantity, qb_description, qb_nsn, qb_condition, qb_crossref) VALUES ('$itemnumber','$mfg','$datecode','$quant','$descr
iption','$nsn','$condition','$crossref')"; 
$updated = mysql_query($query) or die ("Could not update record ($row-1) - $c"); 
} 

} 
} 

} 
} 

//delete file uploaded 
unlink($file_realname); //removed " not needed in function calls for variables
echo "TEMP FILE DELETED FROM SERVER<BR><BR>"; 
} // end if qbooks 
} 
else // (not uploaded) 
{ 
echo "<b><font color=red>No file uploaded.</font></b><BR>No file available or file too big to upload."; 
$file_realname = ""; 
} 

that should work for you... commented any change I made at the end of the respective lines

[gfrank]

Thanks... that worked.

I don't know why that Underscore space was in the code... I didn't see it... Using Macromedia Dreamweaver MX... and the underscore spaces did not show. I just backed up the = signs to remove any space and removed the quotes as you noted... and it works now.

Thanks.
;-)

[tekky]

cool beans, the quotes wouldnt make it NOT work... they would just slow PHP down as when it says double quotes (") it parses that text between those quotes for variables.... which is not necessary when you are using ONLY a variable...

another thing that slows php down is using "around non varible strings" use 'single quotes around static strings' so PHP knows not to parse over them for variables

just some tips/advise for future reference.. .glad everythings working now 🙂