PHP - Custom E-commerce Price Decrement

Hey everyone. I am making a site for my brother's band and having some trouble with the checkout to paypal. Unfortunately in layout I missed a pretty important variable, the size on shirts. I am trying to add it in as a drop down option just before submitting to paypal but I can't get it to show up on paypal and thus will have no idea what size they are ordering. The site is pretty basic and primitive but I really need this info on the checkout. Here is a link to the temporary site where i'm trying to get this to work:
http://www.theblack44s.com/t/index3.php
and this is what is up and running now:
http://www.theblack44s.com/Merchant%20pages/apparel/index3.php
this is the code i'm working on in cart.php:
Code: [Select]
<?php
require "dbconcart.php";
session_start();

//session_destroy();


$page = 'index.php';


$value2 = $_POST['size'];

//add to cart function
if (isset($_GET['add'])) {
                                        $quantity = mysql_query('SELECT id, quantity, imageurl FROM apparel WHERE id='.mysql_real_escape_string((int)$_GET['add']));
                                        while ($quantity_row = mysql_fetch_assoc($quantity)) {
                                                if ($quantity_row['quantity']!=$_SESSION['cart_'.(int)$_GET['add']]) {
                                                        $_SESSION['cart_'.(int)$_GET['add']]+='1';
}
}
                                          header('Location: '.$page);        
                                        }

//remove from cart
if (isset($_GET['remove'])) {
        $_SESSION['cart_'.(int)$_GET['remove']]--;
        header('Location: '.$page);
}

//delete from cart
if (isset($_GET['delete'])) {
        $_SESSION['cart_'.(int)$_GET['delete']]='0';
        header('Location: '.$page);
                 
}

                  
// products
function products() {
        $get = mysql_query('SELECT id, name, item_number, description, price, shipping FROM apparel WHERE quantity > 0 ORDER BY id DESC');
        if (mysql_num_rows($get)==0) {
                        echo "There are no products to display!";
        }
        else {
                while ($get_row = mysql_fetch_assoc($get)) {
                        echo $get_row['name'].'<br />';
echo $get_row['item_number'].'<br />';
echo $get_row['description'].'<br />';
echo 'Price: '.number_format($get_row['price'], 2).'<br />';
echo 'Shipping: '.number_format($get_row['shipping'], 2);
echo '<a href="cart.php?add='.$get_row['id'].'">Add to cart</a></p>';                                        
                }
        }
        
}


//paypal function
function paypal_items() {
        $num = 0;
        foreach($_SESSION as $name => $value) {
                if ($value!=0) {
                        if (substr($name, 0, 5)=='cart_') {
                                $id = substr($name, 5, strlen($name)-5);
                                $get = mysql_query('SELECT id, name, item_number, price, shipping FROM apparel WHERE id='.mysql_real_escape_string((int)$id));
                                while ($get_row = mysql_fetch_assoc($get)) {
                                        $num++;
                                        echo '<input type="hidden" name="item_number_'.$num.'" value="'.$get_row['item_number'].'">';
                                        echo '<input type="hidden" name="item_name_'.$num.'" value="'.$get_row['name'].'">';
                                        echo '<input type="hidden" name="size_" value="$_POST'.$value2.']">';

echo '<input type="hidden" name="amount_'.$num.'" value="'.$get_row['price'].'">';
                                        echo '<input type="hidden" name="shipping_'.$num.'" value="'.$get_row['shipping'].'">';
                                        echo '<input type="hidden" name="shipping2_'.$num.'" value="'.$get_row['shipping'].'">';
                                        echo '<input type="hidden" name="quantity_'.$num.'" value="'.$value.'">';


                                }
                        }
            
                           }
                           
       }
}



//cart function
function cart() {
        foreach($_SESSION as $name => $value) {
                if ($value>0) {
                  if (substr($name, 0, 5)=='cart_') {
                          $id = substr($name, 5, (strlen($name)-5)); 
                        $get = mysql_query('SELECT id, name, price, imageurl FROM apparel WHERE id='.mysql_real_escape_string((int)$id));
                        while ($get_row = mysql_fetch_assoc($get)) {
                                $sub = $get_row['price']*$value;
                                echo $get_row['name'].' x '.$value.' @ $'.number_format($get_row['price'], 2).' = $'.number_format($sub, 2).'<br />';
?>
<html>
<body>

<form action="size.php"  method="post" name="size">
  <label>Size
  <select name="size">
    <option selected="selected">Select</option>
    <option value="youth">Youth (for the brats)</option>
    <option value="small">Small (petite)</option>
    <option value="medium">Medium (average)</option>
    <option value="large">Large (healthy)</option>
    <option value="xlarge">X Large (large)</option>
    <option value="xxlarge">XX Large (full figured</option>
    <option value="xxxlarge">XXX Large (huge)</option>
    <option value="xxxxlarge">XXXXLarge (DAMN!!)</option>
  </select>
  <input type="hidden" name="size" value="selected" />
  <input type="hidden" name="size" value="submit()" />
  </label>
</form>

</body>
</html>


<?php


echo '<a href="cart.php?remove='.$id.'">[-]</a> <a href="cart.php?add='.$id.'">[+]</a> <a href="cart.php?delete='.$id.'">[delete]</a><br />';             
                                
                                }
                        }
                        $total += $sub;        
                }        
        }
        
        //cart totals and paypal function
        if ($total==0) {
                echo "Your cart is empty.";
        }
        else {
                
                                echo '<p><b>Total: $ '.number_format($total, 2).'</b></p>';
                                ?>
                                <p>
                <form action="https://www.paypal.com/cgi-bin/webscr" target="_blank" method="post">
                <input type="hidden" name="cmd" value="_cart">
                <input type="hidden" name="upload" value="1">
                <input type="hidden" name="business" value="webmaster@theblack44s.com">
                <?php paypal_items(); ?>
                <input type="hidden" name="currency_code" value="USD">
                <input type="hidden" name="amount" value="<?php echo $total; ?>">
<input type="hidden" name="size" value="<?php echo $value2; ?>">
                <input type="image" src="http://www.paypal.com/en_US/i/btn/x-click-but03.gif" target="_blank" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
                </form>
                </p>
               <?php
        }
}

?>

I am relatively new to php but I have been learning since the end of 2011.

At the moment, I am currently developing an E-Commerce website for a customer, using the Larry Ullman book "Effortless E-Commerce' as a guide.

I am hitting many brick walls at the moment though.

But before I state my long winded problem, I have attached all my work done thus far to this message.

HERES THE PROBLEM...

I have created a series of includes such as config.inc.php, form_functions.inc.php, login.inc.php and login_form.inc.php.

They are included/required with most of my other files.

However I have some major issues;

1. This is the code for my logout.php file;
Code: [Select]
<?php

require ('./includes/config.inc.php');

// If the user isn't logged in, redirect them:
redirect_invalid_user();

// Destroy the session:
$_SESSION = array(); // Destroy the variables.
session_destroy(); // Destroy the session itself.
setcookie (session_name(), '', time()-300); // Destroy the cookie.

// Include the header file:
$page_title = 'Logout';
include ('includes/header.html');

// Print a customized message:
include ('includes/main.html');
echo '<h3>Logged Out</h3><p>Thank you for visiting. You are now logged out. Please come back 

soon!</p>';

// Footer file needs the database connection:
require (MYSQL);

// Include the HTML footer:
include ('includes/footer.html');
?>
At the moment, I cannot determine if a user is logged in/when they logout, I cannot determine if there is an active session and also, when I log into the site, I have a database with values yet it seems to let any Tom, Dick and Harry onto the site to log in even though they are not stored in the database.

I apologise if this sounds confusing but I really need some major league help.

Help would be greatly appreciated

I'm sure it's not much, but I'm not understanding something with custom error handlers:

I've created a custom error handler, which I initially set when my page loads :

set_error_handler(array ( new ErrorHandler(), 'handleError' ));

 

It seems to catch all internal PHP errors, such as if I: var_dump($non_existing_var); right after the set_error_handler....

Now, I have an object that throws an exception after:

set_error_handler(array ( new ErrorHandler(), 'handleError' )); 
$locale = new \CorbeauPerdu\i18n\Locale(...); // this should throw an exception 
...

I thought that with an error handler set, I could 'skip' the try/catch for it, but doing so, PHP spits out in its internal log:

PHP Fatal error: Uncaught CorbeauPerdu\i18n\LocaleException: ....

 

My error handler doesn't catch it at all before, thus my page breaks!!

If I want it to go through the error handler, I have to init my Locale with a try/catch and use trigger_error() like so:

set_error_handler(array ( new ErrorHandler(), 'handleError' ));

try { 
  $locale = new \CorbeauPerdu\i18n\Locale(...); // this should throw an exception 
}
catch(Exception $e) { 
  trigger_error($e->getMessage(), E_USER_ERROR); 
} 
...

Is this normal ? I thought one of the goals of the error_handler was to catch anything that wasn't dealt with?

Thanks for your answers!

Hi, 

Hey guys I had created a while ago a script for my friend where you can buy points and then redeem stuff with those points, i'm looking for ways to keep my site secu currently what i have done-

- protected all mysql queries with mysql_real_escape_string, strip_tags, and addslashes
- have a valid SSL certificate on my website
- checked if emails are valid for account creation

what else can I do? Thank you.

I have an array that needs to display all titles and allow for a user to view titles based on the category, title, etc . I tried using the print_r() function but it didn't display the titles in a clean list. The only tutorials I've found utilize sql and i need to complete this without using SQL.
Code: [Select]
$books = array();
array_push($books,array("category" => "Nonfiction","title" => "The Innocent Man","author" => "Grisham","publisher" => "McGraw-Hill","price" => "34.99","isbn"
=> "5985420166"));
array_push($books,array("category" => "Business","title" => "How to Make Money","author" => "Richy","publisher" => "Prentice-Hall","price" => "49.99","isbn"
=> "8754739342"));
array_push($books,array("category" => "Romance","title" => "Twice Kissed","author" => "Jackson","publisher" => "McGraw-Hill","price" => "14.99","isbn"
=> "5671230987"));

I am building an e-commerce site and I am aiming to create a front end displaying my products with an option for customers to buy them, and have a content management system as a back end for an admin to edit product information.    Currently I am storing information about my products on a mysql database. I access and display the product info using a while loop. Below is a simplified version of what I am doing without any html to style it. This code will go through the database and each iteration will go the to the next row and display the info about the next product.

$query = mysql_query("SELECT * FROM truffleProducts");

while ($row = mysql_fetch_array($query)) {
	$id = $row['id'];
	$name = $row{'Name'};
	$price = $row{'Price'};
	$desc = $row{'Description'};
			
	echo $id;
	echo $name;
	echo $price;
        echo $desc;		
}

I have began to implement a 'buy' button so that customers are able to click on a button next to the product info and purchase it. However I have come across a problem which is where my program won't be able to tell which product you have selected as the number stored in the $id variable will  just be the last product it has fetched from the database. I can't differentiate between all the product's buy buttons, so it will impossible to place an order for a customer with the current system I have.   Can any one tell me how to get the id number of the specific product that a user has selected?   I only started learning PHP a month or two ago so assume I know nothing

This topic has been moved to PHP Applications.

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

This topic has been moved to PHP Applications.

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

My website, http://www.LawnBagSigns.com, has a lot of price tables, which I think, are getting bulky and hard to read. Like

this price page here, I think the table might be scaring people away.

So here is what I want to try - have a series of dropdown boxes where the user can choose the details a product one by one

(for example, first the size, then the quantity). I want to do this in PHP and XML, and I want to avoid JavaScript since,

believe it or not, not all of my website's visitors have JavaScript enabled.

My problem at the moment is that the XML document is full of white scape that is screwing over my system, but I don't want

to sacrifice readability by blobbing the whole xml file into one line with no spaces (because if I want to change or add

something... you get the idea).

So my question is, how do I get rid of the white scape?

Here is the prototype I've been working on:
http://www.lawnbagsigns.com/flyers-test.php
The XML:
Code: [Select]
<?xml version="1.0" encoding="ISO-8859-1"?>

<?xml-stylesheet type="text/xsl" href="whitespace_ripper.xsl"?>

<price_table>
<side>1
<qty>25
<size>3.5 x 8.5
<price>
37
</price>
</size>
<size>8.5 x 5.5
<price>
37
</price>
</size>
<size>4.25 x 11
<price>
37
</price>
</size>
<size>8.5 x 7
<price>
38
</price>
</size>
</qty>
</side>
<side>2
<qty>25
<size>3.5 x 8.5
<price>
37
</price>
</size>
<size>8.5 x 5.5
<price>
37
</price>
</size>
<size>4.25 x 11
<price>
37
</price>
</size>
<size>8.5 x 7
<price>
38
</price>
</size>
</qty>
</side>

</price_table>and the PHP code:
Code: [Select]
<?php

//P  Session

function priceSelect ($path)
{

if (!empty($_REQUEST['Previous']))
{

$_SESSION['xmlCursor'] = $_SESSION['xmlCursor']->parentNode;
echo 'test1<br />';
}
elseif (!empty($_REQUEST['Next']))
{

$exitLoop = false;
$childCursor = $_SESSION['xmlCursor']->firstChild;

while ($exitLoop == false)
{
if ($childCursor == $_SESSION['choice'])
{
$_SESSION['xmlCursor'] = $childCursor;
$exitLoop = true;
}
else
{
$childCursor = $childCursor->nextSibling;
}
}
echo 'test2<br />';
}
else
{

$_SESSION['userMadeChoices'] = array(array());
$_SESSION['xmlCursor'] = loadXML($path);
echo $_SESSION['xmlCursor']->firstChild->nodeValue;
echo $_SESSION['xmlCursor']->parentNode->nodeValue;
echo 'test3<br />';

}

$reload = $_SERVER['PHP_SELF'];

echo 
'<form action="'.$reload.'" method="post">';

displayChoices($_SESSION['userMadeChoices']);
echo 'test4<br />';
displayMenu($_SESSION['xmlCursor'], $_SESSION['userMadeChoices'] );
echo 'test5<br />';
displayButtons($_SESSION['xmlCursor']);
echo 'test6<br />';

echo '</form>';
}

function loadXML($path)
{
$xmlDoc = new DOMDocument();
$xmlDoc->load($path);
$xmlDoc = $xmlDoc->documentElement;
return $xmlDoc;
}

function displayChoices($data)
{
for ($i = 0; $i < count($data); $i ++)
{
echo $data[$i][0];
echo '</br>';
}
}

function displayMenu($xml, $data)
{
echo '<select name="choice">';
//$xml = $xml->documentElement;
//$data[$xml] = 

foreach($xml->childNodes AS $child)
{
echo '<option value="' . $child->firstChild->nodeValue . '">' . $child->firstChild->nodeValue . 

'</option>';
}

    echo '</select>';
}

function displayButtons($xml)
{
if ($xml->childNodes != null)
{
echo '<input type="submit" name="Previous" value="Previous Step" />';
}

if ($xml->parentNode != null)
{
echo '<input type="submit" name="Next" value="Next Step" />';
}
}

function stripWhitespace ($string)
{

return $string;
}
?>

Hi... have looked far and wide without success.

Can someone point me in the right direction to learn how to dynamically display a price as the client adds/subtracts items from a shopping cart without refreshing the page ?

Thanks

Hi

I have been trying to change the following for my website, so that
when my unit price is "0.00" it will show "call for price" but it don't
seem to work.

Base on the codes, the result was it'll show both "0.00" and "call for price"
on my website which is wrong.

Would greatly appreciate if anyone can help

Thanks in advance

priceFormat(0);

function priceFormat($price, $dispNull = FALSE){

if(is_numeric($price)){

global $currencyVars;

$price = $price * $currencyVars[0]['value'];

return $currencyVars[0]['symbolLeft'].sprintf("%.".$currencyVars[0]['decimalPlaces']."f", $price).$currencyVars[0]['symbolRight'];

} elseif($dispNull == TRUE){
global $currencyVars;
return $currencyVars[0]['symbolLeft'].sprintf("%.".$currencyVars[0]['decimalPlaces']."f",0.00).$currencyVars[0]['symbolRight'];

} else {

return "Call For Price";

}

}

hi,

i have a column in a list of products called 'price'. it's a varchar column. each price is in this format 8.00 or 12.00

always with 2 decimals.

when i try and sort by price it only goes by the first number, so something that's 1.00 will be next to something that's 100.00.

if i make the column INT then it works, but then i can't have a decimal.

anyone know how to fix this?

thanks,

jack

I have an HTML table with the following columns:
- Event
- Price
- # of Attendees
- Total
- Choose One

The values are populated from a database, and I am using a loop to create the Table.

The problem is that I have some syntax error where I am trying to calculate the Total Ticket Price?!

Can someone help me figure what is wrong with my code?

Code: [Select]
<!-- Body -->
<tbody>
<?php
// Fetch Comment record.
$x=0;
while (mysqli_stmt_fetch($stmt)){
//<!-- Row 1 -->
echo '
<tr>
<th scope="row" class="headerCol">';
echo 
$eventName . '<br />' .
$eventLocation . '<br />' .
$eventDate . '
</th>
<td class="col2">' .
$eventPrice .
'<input type="hidden" name="eventCost[' . $x . ']" value="' . $eventPrice . '" />
</td>
<td class="col3">
<select name="eventAttendees[' . $x . ']">
<option value="">--</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
</select>
</td>
<td class="col4">' . $eventCost*eventAttendees[$x] . '</td>
<td class="col5">
<input name="eventChosen[' . $x . ']" type="submit" value="Buy Tickets" />
</td>
</tr>';
}
?>
</tbody>

What I am trying to do/say on each row is "Take the Event Price and multiple it times the # of Attendees selected in the Row's Drop-Down field."

Thanks,


Debbie