PHP - Add Up Weights Of Selected Items

Hi there,

I'm creating a shopping cart and to work out postage cost I need to add all the items weights together.

The weight of each item is in the database.

I currently have this code:

Code: [Select]

$basket = $_SESSION['basket'];
if ($basket) {
$items = explode(',',$basket);
$contents = array();
foreach ($items as $item) {
$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
}
foreach ($contents as $id=>$qty) {
$sql = "SELECT * FROM store WHERE id LIKE '$id' AND live LIKE '0'";
$result = mysql_query($sql);
while ($rows = mysql_fetch_array($result)) {
extract($row);

so to work out each item's weight I can do $rows['weight'] * $qty.

but how could i add all the item's weight together?

i hope that makes some sense.

thanks,

jack

I have this loop on a shorturl website i own that selects domains from my website and lists them in a dropdown list where users can select one domain to use as url shortener.

The problem is that when a users selects and entry from the dropdown list this created only the [[[main_url]]] entry from the database table bellow can be used. When someone selectes "coolartistname.site.com the submit button cannot be pressed. in other words it's not adding the SELECTED attribute other than the [[[main_url]]] domain.

Can anyone see on the code bellow why this would happen?

When i echo $shortUrlDomains it's just saying "Array" and $_REQUEST['shortUrlDomain'] shows nothing.

**Index.php**

    // get base urls
    $shortUrlDomains = getShortUrlDomains();
    
        <?php
        foreach ($shortUrlDomains AS $k => $shortUrlDomain)
        {
        
            // active domains only
            if (($shortUrlDomain['premium_only'] !== '1') && ($shortUrlDomain['premium_only'] !== $Auth->id))
            {
                continue;
            }
        
            echo '<option value="' . (int)$k . '"';
        
            if (isset($_REQUEST['shortUrlDomain']))
            {
                if ($k == (int)$_REQUEST['shortUrlDomain'])
                {
                    echo 'SELECTED';
                }
            }
        
            echo '>';
        
            echo $shortUrlDomain['domain'];
        
            if ($disabled == true)
            {
                echo ' (' . safeOutputToScreen(t('unavailable', 'unavailable')) . ')';
            }
        
            '</option>';
        }
        echo '</optgroup>';
        ?>

FUNCTIONS.PHP

    function getShortUrlDomains()
    {
        // if we already have it cached
        if(defined('_SETTINGS_SHORT_URL_DOMAINS'))
        {
            return unserialize(_SETTINGS_SHORT_URL_DOMAINS);
        }
        
        // get connection
        $db  = Database::getDatabase(true);
        
        // load from database
        $domains = $db->getRows("SELECT id, domain, premium_only, status FROM url_domain ORDER BY premium_only ASC, id ASC");
        
        // organise and replace site url
        $rs = array();
        foreach($domains AS $domain)
        {
            if($domain['domain'] == '[[[main_url]]]')
            {
                $domain['domain'] = _CONFIG_SITE_FULL_URL;
            }
            $rs[$domain{'id'}] = $domain;
        }

**MYSQL DATABASE**

    url_domain (id, domain, premium_only, status, date_created, owner) VALUES
    (1, '[[[main_url]]]', 0, 'enabled', '2019-03-02 08:13:00', 1) 
    (14, 'coolartistname.site.com', 6, 'enabled', '2020-04-18 19:21:59', 6);

 

Hi all,

I have a html drop down menu and want to show the initially selected value as the one stored in the mysql database that a member selected.

I have 180+ rows in mysql that a member could have selected and would like to basically do this:

IF (value of option == $row['value'] ) { echo "selected=\"selected\"; }
I could put this in every one of the rows it would be much better to have an if statement. As there are so many values I do not know where to begin.

Can someone point me in the right direction?

Thanks

How can I select the last 5 db items? I was thinking a timestamp or some thing.

Guys,
i want to display ads after 4 items to be displayed.

Iam fetching item using mysql database & iam showing 8 items per page.

I used below code but its not working because i used the item id to specify the first number but the items is not listed as correct order

Code: [Select]
<?php
// first number
$first = $row['id'];
// second number
$second = 4;

//checking if the first number is muliple of second. If true then display ads.
If($first % $second == "0") {
echo 'ads to display';
}

It will work if i list items in correct order. Please let me know correct solution.
Thanks in advance !

What is the best way to capture items that someone wants to purchase when they don't have an account yet?

And I prefer not using cookies.

 

 

Right now I have a link list a-z and 0-9.
you click one of those links and your taken to page listing all items that start with that character.
currently I'm using:
Code: [Select]
SELECT * FROM my_table where LEFT(`my_item`,1)='$show' ORDER BY my_title ASCall I do right now is just add a link like ?show=a and everything that starts with a is listed.

Now here is my problem. I want to listen all items that start with a numeric value listed all on one page instead of being spread across 0-9.

If another solution becomes available I'd be more then happy to hear you out. But does anyone know how I can change my query to only list items that start with numbers?

I would like to add another count that after every 4 items, it loops and create  a added piece of script, by adding <ul><li> tags after every 4 items.

I want to addthis piece of code, every fours items after it close </div>

Code: [Select]
            <ul>
               <li>
                <div class="box">
             <!--All fields and information here-->
                </div>
               <div class="h2"></div>
                <div class="box">
             <!--All fields and information here-->
                </div>
               <div class="h2"></div>
                <div class="box">
             <!--All fields and information here-->
                </div>
               <div class="h2"></div>
                <div class="box">
             <!--All fields and information here-->
                </div>
               <div class="h2"></div>
                   </li>
              </ul>

I currently have this piece of code, which builds a list per every <div class="box">, then closes the item </div> and start another one as same.
SEE current CODE.
Code: [Select]

 <?php
    $dealList = $this->dealList;
    if(count($dealList)==0) echo '<h3>'.JText::_('NO_DEAL_MESSAGE').'</h3>';
$count = 1; 
foreach ( $dealList as $row): 
$link = 'index.php?xxx=' . $row->id;
if(!Helper::is_urlEncoded($row->pic_dir))
 {
  $imageUrl = $row->pic_dir;
 }
 else
 {
$imageUrlArr= unserialize(urldecode($row->pic_dir));
$imageUrl = str_replace("\\","/",$imageUrlArr[0]);
 }
?>

<div class="box">
information fields here
</div>


  <?php if ($count%2==1){?>
     <div class="h2"></div>
    <?php }
    else if($count%2==0){?>
    <div class="h3"></div>
   <?php  }$count++ ; endforeach;?>

How do I added the Additonal count for efter four items <div class=box"> it places and start over with
Code: [Select]
<ul>
  <li>
     <div class="box">
      information fields
     </div>
 </li>
</ul>

I have an array of products. The array has an ID and price. I'd like to know the most efficient way of adding up all the same ID fields in the array.

Code: [Select]
<?php
$items[] = array(
'id' => 1,
'price' => 5.99,
);
$items[] = array(
'id' => 2,
'price' => 1.99,
);
$items[] = array(
'id' => 3,
'price' => 2.40,
);
$items[] = array(
'id' => 2,
'price' => 6.99,
);
$items[] = array(
'id' => 4,
'price' => 8,
);
$items[] = array(
'id' => 2,
'price' => 3,
);
$items[] = array(
'id' => 3,
'price' => 1,
);

function add_like_items($items)
{
//manipulation

return $sums;
}

//$sums would be an array like 
//$sum[1] = 5.99
//$sum[2] = 11.98
//$sum[3] = 3.40
//$sum[4] = 8 

?>
Anybody have suggestions on the best way to go about doing this?

Hi,

i have had some help from these forums building a shopping cart system and i can add items to cart, empty cart but i need some help on how to update quantities.

Here is the code i use to add items

Code: [Select]
$pid = $_POST['prodid'];
$q = $_POST['qty'];

if(array_key_exists($pid, $_SESSION['cart']))
{
$_SESSION['cart'][$pid]=$_SESSION['cart'][$pid]+$q;
}
ELSE
{
$_SESSION['cart'][$pid]=$q;
}
Im displaying my items in a table with a text field for quantities which can be changed then click update. i see there is 2 things i need to do, first is to somehow create a loop for all the items in my table, i have no clue where to start on that, and then in that loop i have my update command.

im assuming the code to update would be something like

Code: [Select]
$_SESSION['cart'][$pid]=$_SESSION['cart'][$pid][$qty]
where $qty is the value of the text box in my table.

Any help would be appreciated.

Hi,

I have this menu code which displays a drop down menu:


<ul>
<li><a href="<?php echo URL_PUBLIC; ?>">Home</a></li>
<?php 
function submenu($list, $ul){
if($ul){
echo "
<ul>";}
foreach($list->children() as $newList){
echo '
<li>'.$newList->link($newList->title, (in_array($newList->slug, explode('/', $newList->url)) ? ' class="current"': null));
if ($newList->childrenCount() > 0) {
submenu($newList, true);
}else{echo "</li>";}
}
if($ul){echo "

</ul></li>";}
}

submenu($this->find('/'), false);
?>
<br style="clear: left" />
</ul>


I am trying to exclude certain menu items based on their slug.

I have this code, but can't work it into the above:


$omit_pages = array('page1', 'page2');
if (in_array($menu->slug, $omit_pages)) {
    continue;
}


Does anyone have any ideas how I can work it in?

Thanks

Hello,

In my Mysql database, it has a datetime field.

and I have created a $today = date('Y-m-d H:i:s');  <-  today's date and time

How do I write a query to run in PHP in order to get all today's items by comparing datetime field and $today?

Thanks!

am currently building the cart system of a product, now there is this part wherein, the non-logged-in OR logged-in user should also be able to see the items that he/she viewed, how to do that?., am not asking for code snippets , just give me some ideas/hints/strategies/tips that may help me get the big picture on how to do this thing and proceed coding.

How can I check if an array contains two items that are the same?

For example ("apples", "bananas", "oranges") returns false
But ("apples", "bananas", "bananas") returns true

Hi Guys, I am trying to get the while function to list four of my items on a row however I have no idea how and every time I try, I fail. Please give me a hand? Here is the code I have so far

Code: [Select]



if($row['photo'] == "#no_photo")
$photo = ('<img src="images/item_pictures/default_item.png" width="150" height="150" alt="Default Item">');
else
$photo = $row['photo'];


echo "<br /> <br />" ;


echo "<br />
<font face='Comic Sans MS, cursive'>Click on an item to view it in full.</font>
<br />
<br />";


if($row['photo'] == "#no_photo")
$photo = ('<img src="images/item_pictures/default_item.png" width="100" height="100" alt="Default Item">');
else
$photo = $row['photo'];


echo "<br /> <br />" ;


$i = 0;
while ($i < $num) {




$f1 = "<tr><td><font size='6'><a href='item.php?id=" . mysql_result($result,$i,"item_id") . "'>" . mysql_result($result,$i,"item_name") . "</a></font></td><td> "    . $photo . "</td></tr>";




echo "" .  $f1 ."" ;
$i++;




Thanks, Jacbey