Hello.
Quick background as I dont wish to hog anyones time. I am a customer of a
PHP/SQL programmer. A website that I had the programmer build for me is
working great, with one exception.
I have limited programming experience, most of it Pascal/C++ and I haven't
programmed for many years now even then it was mediocre programming of small
this and thats.
Here is the code:
-----------------------------------------------------------------------
function check_deliver_price($product_id, $product_quantity, $price_level,
$delivery_city_address, $delivery_state_address, $delivery_zip,
$values_price_inc)
{
global $db_prefix, $ups_dropOffChoice, $ups_container, $ups_billToUPS,
$ups_currency, $ups_document, $ups_22_destCountry, $ups_origCity,
$ups_15_origPostal, $ups_14_origCountry, $ups_13_product, $ups_10_action;
$result = 0;
@$result = mysql_query("select * from ".$db_prefix."_products WHERE
id='$product_id'");
@$myrow = mysql_fetch_array($result);
$value = $myrow['price_'.$price_level.'_level'] + $values_price_inc;
if ($value < 100) {$value = 100;}
$html = implode ('', file
('http://wwwapps.ups.com/ctc/htmlTool?accept_UPS_license_agreement=yes&destR
esident=01&49_residential=1&10_action='.$ups_10_ac tion.'&13_product='.$ups_1
3_product.'&14_origCountry='.$ups_14_origCountry.' &origCity='.$ups_origCity.
'&15_origPostal='.$ups_15_origPostal.'&22_destCoun try='.$ups_22_destCountry.
'&shipDate='.date("Y-m-d").'&document='.$ups_document.'¤cy='.$ups_c urr
ency.'&container='.$ups_container.'&billToUPS='.$u ps_billToUPS.'&dropOffChoi
ce='.$ups_dropOffChoice.'&20_destCity='.$delivery_ city_address.'&19_destPost
al='.$delivery_zip.'&23_weight='.$myrow['weight'].'&24_value='.$value.'&25_l
ength='.$myrow['size_x'].'&26_width='.$myrow['size_y'].'&27_height='.$myrow[
'size_z']));
if (strstr($html, 'UPS United States'))
{
if (strstr($html, 'Provide Package Information'))
{
$result = 0;
}
elseif (strstr($html, 'Provide Shipment Information'))
{
$result = -1;
}
elseif (strstr($html, 'Detailed Results'))
{
eregi('Shipment Total:</span><img alt="" height="1" src="/img/1.gif"
width="12">(.+)<img alt="" height="1" src="/img/1.gif" width="6"><span
class="bold">USD</span></div></td>', $html, $temp);
$result = $temp[1];
}
else
{
order_step_1('', '', '', 'delivery_address_incorrect');
break;
}
}
if ($result < 0) {order_step_1('', '', '', 'delivery_address_incorrect');}
if ($myrow['price_'.$price_level.'_shipping'] == 1) {$result = 0;}
$result = $result * $product_quantity;
return $result;
}
-----------------------------------------------------------------------
Basically, from what I can gather, its looking within the webpage result
from UPS to see if something exists, in essence to give the
"check_deliver_price" function a result.
The use of "implode" in the above code (as in any PHP coding I would
imagine) is a concatenation function from what I can tell by my research.
However, it seems that the implode function call as used above is stripping
the space in between a customers City address (ie. Santa Fe, Los Angelos,
etc.) creating a situation where "Santa Fe" would be just "Santa" by the
time it is concatenated. Therefore, only "Santa" gets passed onto UPS by
use of the URL, which of course UPS returns an error.
Only customers with a space in the city name have this issue. Now, my
programmer while capable of resolving this issue, is absent and since she is
not even in the US, I cannot contact her.
I am asking the NG for any help in modifying the above code or any
suggestions as to what I can do. I dont mind keeping backups of her coding,
then modifying the original.. besides, I dont imagine I could make matters
much worse, since the "check_deliver_price" function is called both for
address verfication upon customer sign up, but, to find out the delivery
charges of the products that they purchase.
The key portion of the code (I think) would be:
$html = implode ('', file
('http://wwwapps.ups.com/ctc/htmlTool?accept_UPS_license_agreement=yes&destR
esident=01&49_residential=1&10_action='.$ups_10_ac tion.'&13_product='.$ups_1
3_product.'&14_origCountry='.$ups_14_origCountry.' &origCity='.$ups_origCity.
'&15_origPostal='.$ups_15_origPostal.'&22_destCoun try='.$ups_22_destCountry.
'&shipDate='.date("Y-m-d").'&document='.$ups_document.'¤cy='.$ups_c urr
ency.'&container='.$ups_container.'&billToUPS='.$u ps_billToUPS.'&dropOffChoi
ce='.$ups_dropOffChoice.'&20_destCity='.$delivery_ city_address.'&19_destPost
al='.$delivery_zip.'&23_weight='.$myrow['weight'].'&24_value='.$value.'&25_l
ength='.$myrow['size_x'].'&26_width='.$myrow['size_y'].'&27_height='.$myrow[
'size_z']));
What I seek is an overall resolution to the code sniplet, though, I think if
I can find out from anyone here on how to fill in any spaces that may exist
in the $delivery_city_address variable with a %20, that would pretty much
resolve my issue?
Any guideance would be greatly appreciated, albeit, a modified code
resolving my issue would make it much easier and would be the most
appreciated assistance for this wannabe PHP programmer. :)
Jeff
