Learn VBA & Macros in 1 Week!

PHP - Sending Basket To Sagepay

Full Excel VBA Course - Beginner to Expert

Sending Basket To Sagepay	View Content

Hi all
I am writing a script to send the contents of my SQL table to SagePay as a string $basket. I have got it to work OK with adding one item in. My code is this:

$query_basket = mysql_query("SELECT * FROM `store_basket` WHERE sessionid='".$sessionid."'");
$rows = mysql_num_rows($query_basket);
      $allitems = count($rows);
while($result_basket = mysql_fetch_array($query_basket)) {
$price_without_tax = $result_basket['price'];
$tax = 17.5;
$price_with_tax = $result_basket['price'] + $tax;
$price_times_qty = $result_basket['price'] * $result_basket['qty'];
   $basket_item = $result_basket['item'];
   $basket_qty = $result_basket['qty'];
}

if($allitems == 1) {
$basket .= "1".":".$basket_item.":".$basket_qty.":".$price_without_tax.":".$tax.":".$price_with_tax.":".$price_times_qty;
} else {
$basket .= $allitems.":".$basket_item.":".$basket_qty.":".$price_without_tax.":".$tax.":".$price_with_tax.":".$price_times_qty;
}

$rows++;

However, it only shows one item in the basket when there is more than one in my table.

I need to do a loop so that each item in the table is outputted in the $basket string.

Thanks
Pete

Full Excel VBA Course - Beginner to Expert

Php Shopping Basket

Similar Tutorials

View Content

Hey,

I'm having some problems getting my store website to show the contents of a shopping cart.

At the moment all the IDs of the items that have been added to the basket are being stored as $basket = $_SESSIONS['basket'].

This is the function I have to show those items, but it's not showing up anything. Can anywhere see the problem or offer some help?

Thanks

Code: [Select]

function showBasket() {
$basket = $_SESSION['basket'];
if ($basket) {
$items = explode(',',$basket);
$contents = array();
foreach ($items as $item) {
$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
}
$output[] = '<form action="basket.php?action=update" method="post" id="basket">';
$output[] = '<table>';
foreach ($contents as $id=>$qty) {
$sql = 'SELECT * FROM store WHERE id = '.$id;
$result = $db->query($sql);
$row = $result->fetch();
extract($row);
$output[] = '<tr>';
$output[] = '<td><a href="basket.php?action=delete&id='.$id.'" class="r">Remove</a></td>';
$output[] = '<td>'.$title.' by '.$author.'</td>';
$output[] = '<td>£'.$price.'</td>';
$output[] = '<td><input type="text" name="qty'.$id.'" value="'.$qty.'" size="3" maxlength="3" /></td>';
$output[] = '<td>£'.($price * $qty).'</td>';
$total += $price * $qty;
$output[] = '</tr>';
}
$output[] = '</table>';
$output[] = '<p>Grand total: <strong>£'.$total.'</strong></p>';
$output[] = '<div><button type="submit">Update basket</button></div>';
$output[] = '</form>';
} else {
$output[] = '<p>You shopping basket is empty.</p>';
}
return join('',$output);
}

Loop Issue With Basket

Similar Tutorials

View Content

Hi all. How do I loop the below script?

$query_basket = mysql_query("SELECT * FROM `store_basket` WHERE sessionid='".$sessionid."'");
$rows = mysql_num_rows($query_basket);
$r = mysql_fetch_array($query_basket);
$allitems = $rows;
while($result_basket = mysql_fetch_array($query_basket)) {

$price_without_tax = $result_basket['price'];
$tax = 17.5;
$price_with_tax = $result_basket['price'] + $tax;
$price_times_qty = $result_basket['price'] * $result_basket['qty'];
$basket_item = $result_basket['item'];
$basket_qty = $result_basket['qty'];
$basket_initial1 = $result_basket['initial1'];
$basket_initial2 = $result_basket['initial2'];
$basket_initial3 = $result_basket['initial3'];

}

if($allitems == 1) {
$basket .= $allitems.":".$basket_item." ".strtoupper($basket_initial1)."-".strtoupper($basket_initial2)."-".strtoupper($basket_initial3).":".$basket_qty.":".$price_without_tax.":".$tax.":".$price_with_tax.":".$price_times_qty;
} else {
$allitems = $rows;

$basket .= ":".$basket_item." ".strtoupper($basket_initial1)."-".strtoupper($basket_initial2)."-".strtoupper($basket_initial3).":".$basket_qty.":".$price_without_tax.":".$tax.":".$price_with_tax.":".$price_times_qty;

}

Basically if there is more than one row I need to loop the $basket string so that it shows the values for each item.

Thanks
Pete

Adding Item And Size To Basket

Similar Tutorials

View Content

OK, so I have a form which submits the id of an item on a shopping site as well as the size selected by the customer.

Size S/M is 1
Size M/L is 2

To get what has been submitted when they click "Add To Basket" i have this code:

Code: [Select]
$sizechoice = $_POST['sizechoice'];
$basket = $_SESSION['basket'];
$action = $_GET['action'];
switch ($action) {
case 'add':
if ($basket) {
$basket .= ','.$_GET['id'].'-'.$sizechoice;
} else {
$basket = $_GET['id'];
}
}

I used to have it like that, but minus $sizechoice, so the basket was just ids like 1,5,3,2. Now each id is accompanied by a size choice, so it would be 1-1,5-1,3-2,2-1 for example.

How can I later separate the id from the size again using the dash?

Thanks,

Jack

Changing A Working Basket To A Wishlist

Similar Tutorials

View Content

Quantity In Shopping Basket Add And Subtract Buttons Not Working

Similar Tutorials

View Content

I have setup a website that has a shopping basket and it displays the objects ordered in a table before being purchased, i have added a plus and minus button to adjust the quantity using the following code:

$add ="<form action='cart.php' method='post'><input type='hidden' name='additem' value='$id'/><input type='submit' name='itemadd' onclick='CheckQty()' value='+'/></form>";
    $sub ="<form name='sub' action='cart.php' method='post'><input type='hidden' name='subitem' value='$id'/><input type='submit' name='itemsub' value='-'/></form>";

//add to quantity of item
    if (isset($_POST['itemadd'])){
    $additem = $_POST['additem'];
        if ($qty < 5){
        $addqty = $qty + 1;
        $adding = "UPDATE orders SET quantity = '$addqty' WHERE id = '$additem'";
        $add_query = mysqli_query($db_conx, $adding);
        header('Location: http://www.quichlicious.co.uk/cart.php');
        //print $additem;
        exit();
        }
        else
        {
        $usemes = "You have reached maximum quantity";
        }
    }
    //subtract to quantity of item
    if (isset($_POST['itemsub']) && ($_POST['itemsub'] !="")){
    $subitem = $_POST['subitem'];
            if ($qty > 1){
            $subqty = $qty - 1;
            $subing = "UPDATE orders SET quantity = '$subqty' WHERE id = '$subitem'";
            $sub_query = mysqli_query($db_conx, $subing);
            header("location: cart.php");
            exit();
            }
            else
            {
            $usemes = "<font color='red'>Please use delete to remove item</font>";
            }
    }

Similar Tutorials

View Content

Hey guys,
Coding something for a survey as no solution exists for our needs. I have not finished the code as I still need to do error checks + making it spam proof. Anyway I am not reciving the email even though it says that I have been sent it.
Any suggestions are appreciated, please ask if you need additional info to be able to help, and thank you in advanced.

Code: [Select]
<?php
error_reporting(0);
if(isset($_POST['submit'])){
//Check that all fields that are mandatory are filled in and that the $Email variable is real
$Title = $_POST['Title'];
$FirstName = $_POST['FirstName'];
$LastName = $_POST['LastName'];
$Email= $_POST['Email'];
$Country= $_POST['Country'];
$State= $_POST['State'];
$List= $_POST['List'];
$Nav= $_POST['Nav'];
$IssuesYes= $_POST['IssuesCheck'];
$IssuesList= $_POST['IssuesList'];
$Satisfaction= $_POST['Satisfaction'];
$Improvement= $_POST['Improvement'];
$ValueSatisfaction= $_POST['Value'];
$Recommendation= $_POST['Recommend'];
$Knowledge= $_POST['Knowledge'];
$Comments= $_POST['Comments'];
$Gender= $_POST['Gender'];
$Age= $_POST['Age'];
$Source= $_POST['Source'];
$ContactNumber= $_POST['Contact'];
$Newsletter= $_POST['Newsletter'];
$errors = array();
//Check that the fields above are not empty:

$to = "email@email.com";//Obviously not real one that I am sending to.
$subject = "Survey Form Submission";
$from = $to;
$ip = isset($_SERVER['REMOTE_ADDR']) ? $_SERVER['REMOTE_ADDR'] : '';
$body = "$name submitted the survey form:\n".
    "This is what they responded with to each question: <br>".
"Their Name: $Title $FirstName $LastName <br>"."Email: $Email <br>"."Country: $Country <br>"."State: $State<br>"."Bought: $List<br>"."Website Navigation: $Nav<br>"."Issues: $IssuesYes " ." $IssuesList"."Satisfaction: $Satisfaction<br>"."Improvement: $Improvement<br>"."Value Satisfaction: $ValueSatisfaction<br>"."Reccomend: $Recommendation<br>"."Knowledge: $Knowledge<br>"."Comments: $Comments <br>"."Gender: $Gender<br>"."Age: $Age <br>"."Source for Finding Us: $Source <br>"."Contact: $ContactNumber<br>"."Subscribe to Newsletter?: $Newsletter<br>";
    $headers = "From: $from \r\n";
    $headers .= "Reply-To: $visitor_email \r\n";
   if( mail($to, $subject, $body,$headers)){
   echo "Email Send!";
   }else{
   echo "Somethings wrong :\ ";
   }

   // header('Location: http://www.********/thank-you-for-survey');
}

?>