PHP - How To Remove Extra Fees If Shipping Method Pick From Store?

This topic has been moved to Miscellaneous.

http://www.phpfreaks.com/forums/index.php?topic=345769.0

Hi there, I would like to customize $shippingCost in my shopping cart. I follow a tutorial from:
http://www.phpwebcommerce.com/plaincart/index.php

This tutorial using flat shipping rate, how to customize shippingCost based on the product weight ? 

Example: shipping method will based on weight & place within Malaysia:

west malaysia, up to 1kg = rm9
east malaysia, up to 1kg = rm12

west malaysia, up to 2kg = rm12
east malaysia, up to 2kg = rm16

west malaysia, up to 5kg = rm18
east malaysia, up to 5kg = rm32

west malaysia, up to 10kg = rm24
east malaysia, up to 10kg = rm48


Do i need to create a new field inside my database for product weight ? is it $weight * $product_quantity ?  Does anyone know how to accomplish this customization? . Please help because I am very confuse. Thank you in advanced 


checkout-functions.php:
Code: [Select]
<?php
require_once 'config.php';

/*********************************************************
*                 CHECKOUT FUNCTIONS 
*********************************************************/
function saveOrder()
{
$orderId       = 0;
$shippingCost  = 5;
$requiredField = array('hidShippingFirstName', 'hidShippingLastName', 'hidShippingAddress1', 'hidShippingCity', 'hidShippingPostalCode',
   'hidPaymentFirstName', 'hidPaymentLastName', 'hidPaymentAddress1', 'hidPaymentCity', 'hidPaymentPostalCode');
   
if (checkRequiredPost($requiredField)) {
    extract($_POST);

// make sure the first character in the 
// customer and city name are properly upper cased
$hidShippingFirstName = ucwords($hidShippingFirstName);
$hidShippingLastName  = ucwords($hidShippingLastName);
$hidPaymentFirstName  = ucwords($hidPaymentFirstName);
$hidPaymentLastName   = ucwords($hidPaymentLastName);
$hidShippingCity      = ucwords($hidShippingCity);
$hidPaymentCity       = ucwords($hidPaymentCity);

$cartContent = getCartContent();
$numItem     = count($cartContent);

// save order & get order id
$sql = "INSERT INTO tbl_order(od_date, od_last_update, od_shipping_first_name, od_shipping_last_name, od_shipping_address1, 
                              od_shipping_address2, od_shipping_phone, od_shipping_state, od_shipping_city, od_shipping_postal_code, od_shipping_cost,
                                      od_payment_first_name, od_payment_last_name, od_payment_address1, od_payment_address2, 
  od_payment_phone, od_payment_state, od_payment_city, od_payment_postal_code)
                VALUES (NOW(), NOW(), '$hidShippingFirstName', '$hidShippingLastName', '$hidShippingAddress1', 
        '$hidShippingAddress2', '$hidShippingPhone', '$hidShippingState', '$hidShippingCity', '$hidShippingPostalCode', '$shippingCost',
'$hidPaymentFirstName', '$hidPaymentLastName', '$hidPaymentAddress1', 
'$hidPaymentAddress2', '$hidPaymentPhone', '$hidPaymentState', '$hidPaymentCity', '$hidPaymentPostalCode')";
$result = dbQuery($sql);

// get the order id
$orderId = dbInsertId();

if ($orderId) {
// save order items
for ($i = 0; $i < $numItem; $i++) {
$sql = "INSERT INTO tbl_order_item(od_id, pd_id, od_qty)
VALUES ($orderId, {$cartContent[$i]['pd_id']}, {$cartContent[$i]['ct_qty']})";
$result = dbQuery($sql);
}


// update product stock
for ($i = 0; $i < $numItem; $i++) {
$sql = "UPDATE tbl_product 
        SET pd_qty = pd_qty - {$cartContent[$i]['ct_qty']}
WHERE pd_id = {$cartContent[$i]['pd_id']}";
$result = dbQuery($sql);
}


// then remove the ordered items from cart
for ($i = 0; $i < $numItem; $i++) {
$sql = "DELETE FROM tbl_cart
        WHERE ct_id = {$cartContent[$i]['ct_id']}";
$result = dbQuery($sql);
}
}
}

return $orderId;
}

/*
Get order total amount ( total purchase + shipping cost )
*/
function getOrderAmount($orderId)
{
$orderAmount = 0;

$sql = "SELECT SUM(pd_price * od_qty)
        FROM tbl_order_item oi, tbl_product p 
    WHERE oi.pd_id = p.pd_id and oi.od_id = $orderId

UNION

SELECT od_shipping_cost 
FROM tbl_order
WHERE od_id = $orderId";
$result = dbQuery($sql);

if (dbNumRows($result) == 2) {
$row = dbFetchRow($result);
$totalPurchase = $row[0];

$row = dbFetchRow($result);
$shippingCost = $row[0];

$orderAmount = $totalPurchase + $shippingCost;
}

return $orderAmount;
}

?>


any help will be greatly appreciated   

I have five names in an array and also numbers 5,2,1,3 and what i want to do is php to look at the numbers and print out the name that corresponds to the number.

so for my example the name it should echo out is 'Lee'

 

 $names = array ("Stan", "John", "Dean", "Sam", "Lee");

here are the five names.

The idea is to learn php with making a little fixture list with these five names.

The problem i have is to make php read the number and then look up the array for the name that corresponds to the number.

I hope this explains what I would like to do?

 

Hi there   
Does anyone know where can i get php/mysql calculation weight & shipping cost tutorial ?

Thank you in advanced!

Hey guys,   I need some help with a simple script a friend wrote for me but isn't returning the correct values. I'm looking to get this script working but my PHP skills are abysmal and I can't for the life of me figure out whats the best way to do this. I've tried contacting my friend but he's moving cross-country so I'm hoping you guys can give me some advice.   The script is supposed to return a total shipping price based on the weight of products that are passed to it via an API and the location of the visitor. There are a total of 3 different products (Product A, Product B, Product C) each with it's own weight in grams and it's own shipping rate. The script is needs to follow the following rules: When 1 product (either Product A, B, or C) is in the cart it returns the full fixed shipping price for either US or International Shipping based on $isInternational When 2 or more of Product A or B are added to the cart the full shipping is taken for the heaviest item and a fixed price is added for each additional item (Product and B each have their own fixed prices) When Product C is added to the cart it returns a fixed based on US or International (Product C ships separately and doesn't depend on the weight/prices of Product A or B) The product weights/prices a Product A:

Hi there,

I am trying to edit my shopping cart page so that i can use a different shipping rate for each country that i ship to. At the minute this is the code i use:


*/
if(isset($_GET['eushipping'])||(isset($_POST['rec_country'])&&$_POST['rec_country']!='uk')){
$shipping = ceil($total/30.00)*20.00;
   }
   
I though it if i just changed the value 'eushipping' to the country option value it would work but it doesn't.



Can anyone point me in the write direction of what i need to change? 


Many thanks.

Hash

Hi guys,

I need to pick the middle five numbers from a range of numbers

example

$lowest number = 0;  // this will allways be 0

$highest_number = 10; // this can very from 1 to 10000

$selected_number = 5; // this can also very but it will allways be between 0 and highest number

the middles numbers from the above 3 varuables should be
3 4 5 6 7 --- the $selected_number number allways needs to be the middle number


// some of the issue we need to watch out for is, if hughest number is 4 then it should just go
1 2 3 4




Thank you guys

Hey,

I have an array which stores a bunch of numbers lets say:
Code: [Select]
[0] = 1[1] = 6
Now a second array has:
Code: [Select]
[0] = 5 [1] = 6
What im trying to do - is find the first highest number from the second array that is not found in the first array.Both arrays are sorted already by the way using sort().

What is the best way to do this?

I am not getting any error messages as I just think the codes are wrong. I am trying to get the $sql(s) to choose and print out the the looking_for in the database. However it is not printing anything. Any ideas of where I am need to fix this. I have tried a few ways with no luck.


$sql = mysql_query("SELECT id,gender,looking_for FROM Members");
$nr = mysql_num_rows($sql);

$sql2 = mysql_query("SELECT * FROM Members WHERE id='".($_POST['$looking_for'])."' LIMIT $pn, $itemsPerPage"); 
$outputList = '';
while($row = mysql_fetch_array($sql2)) { 

$id = $row["id"];

$username = $row["username"];

$firstname = $row["firstname"];

if (!$firstname) {

$firstname = $username;

}

$gender='';
$looking_for='';


 

Hi there,

I am working on an e-commerce website on PHP and MySql. The website has products that suppliers can add and edit, which works fine.

Now we are required to create and add a shipping profile to the products. That is, a supplier can set up a profile where he'll specify, for example:

Setting Shipping charges of Product weight
$10/kg for US shipping
$20/Kg for Europe
$25/Kg for Rest of the world.

Once this profile is setup, I would need to attach this profile to a product.

Well, I can create a table named ProductProfile and enter this weight info and how do I go about attaching this to a product.

Any comment/feedback are always welcome!

Thank you

Code: [Select]
function choose_numbers($number,$max) {
global $ibforums,$std;
srand( (double)microtime() * 1000000 );
$array = array();
$i = 0;
while($i!=$number)
{
$array[] = mt_rand(1,$max);
$i++;
}
$c = count($array);
while($c != $number)
{
$array[] = mt_rand(1,$max);
$c = count($array);
if($c == $number)
{
$array = array_unique($array);
$c = count($array);
}
}
return $array;
}
$newnumbers = $this->choose_numbers(3,36);
echo "{$newnumbers['0']}|{$newnumbers['1']}|{$newnumbers['2']}";

This echo's out my lottery balls 0|32|22 or technically RANDNuMbER|RANDNUMBER|RANDNUMBER

up to 36 is the highest number.

Now my issue is, I don't want 2 numbers of the same Value, EVER. Sometimes it does 2|3|2 which is BAD (for my lottery system) is there anyway I can make it so it never will echo out 2 (OR 3) of the same number?

I Have the following issue and I spend my whole day looking for it.

I have a database with a simple admin where I add/delete values.

The database structure is the following:

id, zip, email
The database is called zipdatabase

Here is the mailing part:

Code: [Select]
//headers
$headers = "From: <$Email>";
$headers .= "\r\nBcc: <$Bcc>\r\n\r\n";

// send email
$success = mail($EmailTo, $Subject, $Body, $headers);The variable $Bcc must come from the database. I am really ignorant so I only got to a point on how to echo the results I need (and this works):
Code: [Select]
$query  = "SELECT email FROM zipdatabase WHERE zip = '$ZIP'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
   echo "{$r['email']}, ";
}
?>
For a zip I get more than one result so when I tried using this

Code: [Select]
$query  = "SELECT email FROM zipdatabase WHERE zip = '$ZIP'";
$result = mysql_query($query);
while($row = mysql_fetch_array($result))
{
   $Bcc = "{$r['email']}, ";
}
echo "Bcc"
?>
It only gives me one result.

What I noticed is I have 2 issues:
- I can't extract the BCC from the database
- I don't know how to add more email addresses to the bcc field, I only managed to add more addresses to the $Emailto like:
Code: [Select]
$EmailTo = "address1@domain.com, address2@domain.com";
$Bcc = "address3@domain.com";
All these variables are defined by a webform and it works flawlessly except the database problem:

Code: [Select]
$Name = Trim(stripslashes($_POST['Name']));
$Phone = Trim(stripslashes($_POST['Phone']));
$ZIP = Trim(stripslashes($_POST['ZIP']));
$Email = Trim(stripslashes($_POST['Email']));
$Message = Trim(stripslashes($_POST['Message']));

// validation
$validationOK=true;
if (!$validationOK) {
  print "<meta http-equiv=\"refresh\" content=\"0;URL=contacterror.htm\">";
  exit;
}

// prepare email body text
$Body = "";
$Body .= "Name: ";
$Body .= $Name;
$Body .= "\n";
$Body .= "Phone: ";
$Body .= $Phone;
$Body .= "\n";
$Body .= "ZIP: ";
$Body .= $ZIP;
$Body .= "\n";
$Body .= "Email: ";
$Body .= $Email;
$Body .= "\n";
$Body .= "Message: ";
$Body .= $Message;
$Body .= "\n";

Sorry for my ignorance and hope someone here can help.
The webform works perfectly except the bcc from the database part.

I am creating a program to simulate the Powerball Lottery game, I have everything working but i forgot to add the Quick Pick Option, having alittle bit of an issue with my "if" statement I believe. My confusion is whether it should be a nested "if", or should it be it's own entity?
Here's what i have so far:

Code: [Select]
<?php
 
        $intGrandPize = 10000000;
         $intRegCount = 5;
         $intMaxReg = 59;
         $intMaxPB = 39;
 //$quick = rand(1, 59);
 //$quickPB = rand(1, 49);
 if (isset($_POST['Quick Pick'])){
 
        if (count($_POST)>0) {
             $aryPick = array();
             $intPower = 0;
             for($t=1;$t<=$intRegCount;$t++) {
                 if (isset($_POST['num'.$t])) {
                     $intPick = (int)$_POST['num'.$t];
                     if ($intPick > 0 && $intPick <= $intMaxReg && !in_array($intPick,$aryPick)) {
                         $aryPick[] = $intPick;
                     }
                 }
             }
             if (isset($_POST['Power']) && (int)$_POST['Power'] > 0 && $_POST['Power'] <= $intMaxPB) {
                 $intPower = (int)$_POST['Power'];
             }
             if (count($aryPick) < 5 || $intPower == 0) {
                 echo "<font color='red'>'*Five unique numbers and a PowerBall selection are Required*'</font>";;
             }
             else {
                 // Have valid numbers...
 
                sort($aryPick); // For if you are going to display them, they will be in order...
 
                // Pick your winners
 
                $aryAllBalls = range(1,$intMaxReg); // array of numbers 1 - 59
                 shuffle($aryAllBalls); // Randomize their order
                 $aryAllBalls = array_chunk($aryAllBalls,$intRegCount); 
                // The above breaks up into an array with 5 numbers each
                 // [0] contains the first 5 balls of all balls randomized, these are what are "picked"
                 $aryPickedBalls = $aryAllBalls[0]; 
                sort($aryPickedBalls); // Sort them for display
 
                $intPowerBall = rand(1,$intMaxPB);
 
                echo "YOUR WINNING NUMBERS A  <br>",implode(' &nbsp; ',$aryPickedBalls),' &nbsp; PB: ',$intPowerBall,"<br>\n<br>\n";
 
                echo "You Picked: ";
                 foreach($aryPick as $key=>$val) {
                     if (in_array($val,$aryPickedBalls)) {
                         echo '<strong>',$val,'</strong> ';
                     }
                     else {
                         echo $val,' ';
                         unset($aryPick[$key]); // Remove it since it didn't match
                     }
                 }
                 $bMatchPB = ($intPower == $intPowerBall); // Set here since checked in 3 places...
                 if ($bMatchPB) {
                     echo 'PB: <strong>',$intPower,"</strong><br>\n<br>\n";
                 }
                 else {
                     echo 'PB: '.$intPower,"<br>\n<br>\n";
                 }
 
                // At this point, $aryPick will only contain matching numbers...
                 $intMatches = count($aryPick);
                 echo 'You matched '.$intMatches,' numbers and did ';
                 if (!$bMatchPB) { echo 'not '; }
                 echo "match the PowerBall number.<br><br>\n\n";
 
                // HERE YOU WOULD DO SOMETHING TO SAY HOW MUCH THEY WON
                 if ($intMatches>=3 || $bMatchPB) {
                     $intWinnings = 0;
                     switch ($intMatches) {
                         case 0:
                                 if ($bMatchPB) { $intWinnings = 3; }
                                 break;
                         case 1:
                                 if ($bMatchPB) { $intWinnings = 4; }
                                 break;
                         case 2:
                                 if ($bMatchPB) { $intWinnings = 7; }
                                 break;
                         case 3:
                                 if ($bMatchPB) {
                                     $intWinnings = 100;
                                 } else {
                                     $intWinnings = 7;
                                 }
                                 break;
                         case 4:
                                 if ($bMatchPB) {
                                     $intWinnings = 10000;
                                 } else {
                                     $intWinnings = 100;
                                 }
                                 break;
                         case 5:
                                 if ($bMatchPB) {
                                 $intWinnings = $intGrandPize;
                                 } else {
                                     $intWinnings = 200000;
                                 }
                                 break;
                         default:
                                 echo "ERROR: Winning Combination not defined in systen!!!<br>\n";
                     }
                     echo "<strong>YOU ARE A WINNER!!!!</strong><br>\n";
                     echo 'You Won: $'.number_format($intWinnings,0),"<br>\n";
                 }
                 else {
                     echo "Sorry, you didn't win. Try again!<br>\n";
                 }
             } // END: if (had valid numbers picked)
         } // END: There was data posted (ie. Form submitted)
     ?>

Posted this in the help section but I realized I would have better luck posting this in this forum. I need some urgent help with a simple script a friend wrote for me but isn't returning the correct values. I'm looking to get this script working but my PHP skills are abysmal and I can't for the life of me figure out whats the best way to do this. I've tried contacting my friend but he's moving cross-country so I'm hoping someone could help me quickly. I require the script to be working for a small project of mine so I need some help within the next 3-4 hrs if possible.   The script is supposed to return a total shipping price based on the weight of products that are passed to it via an API and the location of the visitor. There are a total of 3 different products (Product A, Product B, Product C) each with it's own weight in grams and it's own shipping rate. The script is needs to follow the following rules: When 1 product (either Product A, B, or C) is in the cart it returns the full fixed shipping price for either US or International Shipping based on $isInternational When 2 or more of Product A or B are added to the cart the full shipping is taken for the heaviest item and a fixed price is added for each additional item (Product and B each have their own fixed prices) When Product C is added to the cart it returns a fixed based on US or International (Product C ships separately and doesn't depend on the weight/prices of Product A or B) The product weights/prices a Product A:

Hi,

I need to write some code for this but unsure where to start.

Basically i have a database of say 10 rows. I need to be able to input a number and some sort of fair algorithm will choose one of the rows.

The number will be from 6 to 10 numbers long, and will need to pick the same result each time based on that number.

Its for a lotto game