PHP - Loop To Update Products Grouped By Catalogid

i have the following problem:
im trying to update the region_id in citylist2233 according to the region_id in regionlist2233.

i can compare regionlist2233.region_name = worldregionlist22.regionname and get the new and old id

im messing the loop somewhe

Code: [Select]
<?php
//Insert Unique region id and update 



 $query1 = 'SELECT country_id from worldcountrylist where enable =1 LIMIT 1 ';
 $results1 = mysql_query($query1);

if (mysql_num_rows($results1) > 0) {
while($row1 = mysql_fetch_array($results1)) {
$query2 = 'SELECT * from citylist2233 where country_id ="'.$row1['country_id'].'" ';
 $results2 = mysql_query($query2);
 if (mysql_num_rows($results2) > 0) {
while($row2 = mysql_fetch_array($results2)) {
//echo $row2['city_id'].''.$row2['city_name'].'-'.$row2['region_id'].'-';
echo $row2['city_name'].'-'.$row2['city_id'].'-'.$row2['region_id'].'<BR>';

$query3='select regionlist2233.region_name ,regionlist2233.region_id from worldregionlist22 
LEFT JOIN regionlist2233 on worldregionlist22.regionname = regionlist2233.region_name AND worldregionlist22.region_id <> regionlist2233.region_id AND  worldregionlist22.country_id = regionlist2233.country_id WHERE  regionlist2233.region_id="'.$row2['region_id'].'" AND  regionlist2233.country_id="'.$row1['country_id'].'" ';
$results3 = mysql_query($query3);
if (mysql_num_rows($results3) > 0) {
while($row3 = mysql_fetch_array($results3)) {


echo $updatequery='UPDATE citylist2233 SET region_id='.$row3['region_id'].' WHERE region_id='.$row2['region_id'].' AND country_id='.$row1['country_id'].'';}}
$update = mysql_query($updatequery)
}
}
}
}

?>

I am trying to get info from a table, add rows in that table, and put the added value back into the table in another field...I want to add field1 and field2 of every row and put the total in the total row.
Heres what the echo gives me

Susan 14

Mary 18

Bob 13

Sam 21

heres the database
mysql> SELECT total_val FROM table;

+-----------+
| total_val |
+-----------+
|        21 |
|        21 |
|        21 |
|        21 |
+-----------+



heres the code....


<?php

require("connection.php");


mysql_select_db("database", $connection);
echo "<br />";

$result = mysql_query("SELECT * FROM table");

while($row = mysql_fetch_array($result))
  {
   
     $values = ($row['field1'] + $row['field2']);
    
    
   
   
   $sql=mysql_query("UPDATE table SET total = '$values'");
   
      
  echo $row['user_name'] . " " . $values;
  echo "<br />";
   
  }

?>

also note that if I put a INT in place of $values - the echo changes to match...why??

PLEASE help...I have been working on this for 2 entire days....

This way seems not good.

<?php
$username ="MANCENT";
$user_input_x = _xmouse.movement ;//FLASH
$user_input_y = _ymouse.movement ;//FLASH

while(true)
{
$updatepos = mysql_query("UPDATE users_float SET user_input_x = '$user_input_x' , user_input_y = '$user_input_y' WHERE username = '$username'");
}

This way works but whats a better way?

?>

Hi there, hope have some help. I have a form where a user select time and days of the week (monday, tuesday..) that he is available. The insert script works fine, it insert and the days of week he checked in the table, the only problme is when i try to update each of them. I used this code above, but is not working, instead of updating/inserting days that is selected is inserting multi-records with the same day of the week value. here it is:

foreach($weekDay as $DaysofWeek){

$sql_days = "UPDATE available SET day_time = '$day_time', week_day = '$DaysofWeek' WHERE user_id = '$id_user'";

$update_availability = mysql_query($sql_days);

}

This topic has been moved to Ajax Help.

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

I have a php script that I've been running that seems to have been working but now I'm wondering if some of my logic is potentially off.

I select records from a db table within a date range which I put into an array called ```$validCount```

If that array is not empty, that means I have valid records to update with my values, and if it's empty I just insert. The trick with the insert is that if the ```STORES```  is less than the ```Quantity``` then it only inserts as many as the ```STORES``` otherwise it inserts as many as ```Quantity```.

So if a record being inserted with had 

    Stores: 14 Quantity:12

Then it would only insert 12 records but if it had
  
    Stores:1  Quantity:20

It would only insert 1 record.

In short, for each customer I should only ever have as many valid records (within a valid date range) as they have stores. If they have 20 stores, I can have 1 or 2 records but should never have 30.

It seems like updating works fine but I'm not sure if it's updating the proper records, though it seems like in some instances it's just inserting too many and not accounting for past updated records.

This is the logic I have been working with:

 

  if(!empty($validCount)){
            for($i=0; $i<$row2['QUANTITY']; $i++){
                try{
                    $updateRslt = $update->execute($updateParams);
                }catch(PDOException $ex){
                    $out[] = $failedUpdate;
                }
            }
    }else{    
        if($row2["QUANTITY"] >= $row2["STORES"]){
            for($i=0; $i<$row2["STORES"]; $i++){     
                try{
                    $insertRslt = $insert->execute($insertParams);
                }catch(PDOException $ex){
                    $out[] = $failedInsertStore;
                }
            }
        }elseif($row2["QUANTITY"] < $row2["STORES"]){
            for($i=0; $i<$row2["QUANTITY"]; $i++){     
                try{
                    $insertRslt = $insert->execute($insertParams);
                }catch(PDOException $ex){
                    $out[] = $failedInsertQuantity;
                }
            }
        }
    }

 

Let's say customer 123 bought 4 of product A and they have 10 locations

    customerNumber  |  product  |  category  |  startDate  |  expireDate  | stores
    ----------------------------------------------------------------------------------
    123                 1           A           2018-08-01    2019-03-01      10
    123                 1           A           2018-08-01    2019-03-01      10
    123                 1           A           2018-08-01    2019-03-01      10
    123                 1           A           2018-08-01    2019-03-01      10

Because they purchased less than their store count, I insert 4 records. Now if my ```$validCheck``` query selects all 4 of those records (since they fall in a valid date range) and my loop sees that the array isn't empty, it knows it needs to update those or insert. Let's say they bought 15 this time. Then I would need to insert 6 records, and then update the expiration date of the other 9 records. 

    customerNumber  |  product  |  category  |  startDate  |  expireDate  | stores
    ----------------------------------------------------------------------------------
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10
    123                 1           A           2018-08-01    2019-03-11      10

There can only ever be a maximum of 10 (store count) records for that customer and product within the valid date range. As soon as the row count for that customer/product reaches the equivalent of stores, it needs to now go through and update equal to the quantity

so now I'm running this but it's not running and no errors, but it just returns back to the command line   

$total = $row2['QUANTITY'] + $validCheck;
    if ($total < $row2['STORES']) {
        $insert_count = $row2['QUANTITY'];
        $update_count = 0;
    } else {
        $insert_count = $row2['STORES'] - $validCheck; // insert enough to fill all stores
        $update_count = ($total - $insert_count); // update remainder
    }

        
    for($i=0; $i<$row2['QUANTITY']; $i++){
        try{
            $updateRslt = $update->execute($updateParams);
        }catch(PDOException $ex){
            $failedUpdate = "UPDATE_FAILED";
            print_r($failedUpdate);
            $out[] = $failedUpdate;
        }
    }
    
        
    for($i=0; $i<$insert_count; $i++){
        try{
            $insertRslt = $insert->execute($insertParams);
        }catch(PDOException $ex){
            $failedInsertStore = "INSERT_STORE_FAILED!!!: " . $ex->getMessage();
            print_r($failedInsertStore);
            $out[] = $failedInsertStore;
        }
    }```

    

in my mysql query, after the results have been grouped is there any way to count the results?

i have a end result like this:

784    | x.x.x.x
754    | x.x.x.x
784    | x.x.x.x

so how can i count the first column after its been grouped by IPs?

here is my query:
SELECT * FROM `hits`GROUP BY ip

Currently we have a Microsoft Access database which we use to display a report, we are rolling over to PHP/SQL online for greater control e.t.c.

So far we have the report pulling all the information from the database however we need to group this information by Day followed by Employee, sorted by time and then totaled for each Employee for each day.

Below is the code we have so far which only prints columns how do we go about displaying it like the access screenshot. Attached is an example of the Microsoft Access report we have.

Code: [Select]
<?php
 $username='admin';
 $password='password';
 $database='planner';

 mysql_connect(localhost,$username,$password);
 @mysql_select_db($database) or die( "Unable to select database");
 $query="SELECT * FROM reservations ORDER BY start_date, machid, starttime";
 $result=mysql_query($query);

 $num=mysql_numrows($result);

 mysql_close();

 ?>

 <?php
 $i=0;
 while ($i < $num) {
 $f0=mysql_result($result,$i,"machid");
 $f1=mysql_result($result,$i,"start_date");
 $f2=mysql_result($result,$i,"end_date");
 $f3=mysql_result($result,$i,"starttime");
 $f4=mysql_result($result,$i,"endtime");
 $f5=mysql_result($result,$i,"first_name");
 $f6=mysql_result($result,$i,"last_name");
 $f7=mysql_result($result,$i,"company");
 $f8=mysql_result($result,$i,"phone_number");
 $f9=mysql_result($result,$i,"site_address");
 $f10=mysql_result($result,$i,"site_suburb");
 $f11=mysql_result($result,$i,"site_postcode");
 $f12=mysql_result($result,$i,"postal_address");
 $f13=mysql_result($result,$i,"postal_suburb");
 $f14=mysql_result($result,$i,"postal_postcode");
 $f15=mysql_result($result,$i,"job_type");
 $f16=mysql_result($result,$i,"payment_type");
 $f17=mysql_result($result,$i,"payment_status");
 $f18=mysql_result($result,$i,"quote_outcome");
 $f19=mysql_result($result,$i,"quote_amount");
 $f20=mysql_result($result,$i,"quote_employee");
 $f21=mysql_result($result,$i,"job_income");
 $f22=mysql_result($result,$i,"job_materials");
 $f23=mysql_result($result,$i,"invoice_number");
 $f24=mysql_result($result,$i,"job_notes");

/* START TIME */
$stime = $f3;

$shour = floor($stime/60);
$smin = str_pad($stime % 60,2,0,STR_PAD_LEFT);

//echo $hour.':'.$min;
//echo '<br><br>';

// For AM/PM
$shalf = 'am';
if( $shour > 12 ) {
$shalf = 'pm';
$shour -= 12;
}

$stime = $shour.':'.$smin.' '.$shalf;

/* END TIME */
$etime = $f4;

$ehour = floor($etime/60);
$emin = str_pad($etime % 60,2,0,STR_PAD_LEFT);

//echo $hour.':'.$min;
//echo '<br><br>';

// For AM/PM
$ehalf = 'am';
if( $ehour > 12 ) {
$ehalf = 'pm';
$ehour -= 12;
}

$etime = $ehour.':'.$emin.' '.$ehalf;

 ?>
 <table width="3500px" border="0" cellspacing="0" cellpadding="0">
 <tr>
 <td width="125px"><?php echo $f0; ?></td>
 <td width="80px"><?php echo date('d-m-y', "$f1"); ?></td>
 <td width="50px" style="text-align:right;"><?php echo $stime; ?></td>
 <td width="50px" style="text-align:right; padding-right:20px;"><?php echo $etime; ?></td>
 <td width="100px"><?php echo $f5; ?></td>
 <td width="100px"><?php echo $f6; ?></td>
 <td width="100px"><?php echo $f7; ?></td>
 <td width="100px"><?php echo $f8; ?></td>
 <td width="100px"><?php echo $f9; ?></td>
 <td width="100px"><?php echo $f10; ?></td>
 <td width="100px"><?php echo $f11; ?></td>
 <td width="100px"><?php echo $f12; ?></td>
 <td width="100px"><?php echo $f13; ?></td>
 <td width="100px"><?php echo $f14; ?></td>
 <td width="100px"><?php echo $f15; ?></td>
 <td width="100px"><?php echo $f16; ?></td>
 <td width="100px"><?php echo $f17; ?></td>
 <td width="100px"><?php echo $f18; ?></td>
 <td width="100px"><?php echo $f19; ?></td>
 <td width="100px"><?php echo $f20; ?></td>
 <td width="100px"><?php echo $f21; ?></td>
 <td width="100px"><?php echo $f22; ?></td>
 <td width="100px"><?php echo $f23; ?></td>
 <td width="100px"><?php echo $f24; ?></td>
 <?php
 $i++;
 }
 ?>
Once again thanks everyone at phpfreaks!

Ok I have some data that I would like to have grouped by date. There are dates that have multiple entries for the same date.  I would like to have that data listed under one date. I would like it to look like this

Date
        Location     Weather
        Location     Weather
Date
        Location      Weather

Here is the code I have so far and it lists the data by date but only the data for first date in the table.  If there is data listed for the same date but different location it will not list that data.  What am I missing.  Any help would be great.
!
<?php
// Connect to server and select database.
include ("opendb.php");
$tbl_name="dbnwaterfowl";

$sql="SELECT huntDate, huntLocation, huntWeather, waterfowlSpecies, waterfowlNumberKilled, waterfowlBandedNumber, DATE_FORMAT(huntDate,'%m %d, %Y') FROM dbnwaterfowl GROUP BY `huntDate` ORDER BY `huntDate` ASC";
$result=mysql_query($sql);
?>
<td>
  <p>&nbsp;</p>
  <table width="100%" border="2" cellpadding="1" cellspacing="0" bordercolor="#FA6103" bgcolor="#FFFFFF">
<tr>
<td colspan="7"><div align="center">
  <p><img src="images/hl-logo.jpg" /></p>
  <p align="center"><strong><a href="login.php">Login</a> | <a href="insert.php">Log Hunt</a> | <a href="logout.php">Logout</a></strong></p>
</div></td>
</tr>

<tr>
<td align="center" bordercolor="#FA6103" ><span class="style4">Hunting Date</span></td>
<td align="center" bordercolor="#FA6103" ><span class="style4">Hunting Location</span></td>
<td align="center" bordercolor="#FA6103"><span class="style4">Weather</span></td>
<td align="center" bordercolor="#FA6103"><span class="style4">Waterfowl Species</span></td>
<td align="center" bordercolor="#FA6103"><span class="style4">Number Killed</span></td>
<td align="center" bordercolor="#FA6103"><span class="style4">Number of Bands</span></td>
<td align="center">&nbsp;</td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td><? echo $rows['huntDate']; ?></td>
<td><? echo $rows['huntLocation']; ?></td>
<td><? echo $rows['huntWeather']; ?></td>
<td><? echo $rows['waterfowlSpecies']; ?></td>
<td><? echo $rows['waterfowlNumberKilled']; ?></td>
<td><? echo $rows['waterfowlBandedNumber']; ?></td>
<td align="center"><a href="update.php?id=<? echo $rows['id']; ?>">update</a></td>
</tr>
<?php
}
?>
</table>
</td>
</tr>
</table>
<?php
mysql_close();
?>

Hi. I have the following code where I grab the names and average overall rating from my database and group by the name.

Code: [Select]
$sql="SELECT name, AVG(overall) AS overall FROM $tbl_name GROUP BY name ORDER BY AVG(overall) DESC";
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){
Does anybody know how I can count the number of names that have been grouped together?

For instance:

Name     Overal ratingl
John       2
Pete       5
John       8

It should group the john's, calculate the average rating (8+2)/2=5, and then show that there have been 2 johns making up the 5 rating?

I've tried using the code below and messed around with it loads but cant get it to work:

Code: [Select]
$sql="SELECT name, AVG(overall) AS overall FROM $tbl_name COUNT name GROUP BY name ORDER BY AVG(overall) DESC";
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){

echo $rows['Count name'];
Thanks in advance.

Here is my database:

receipt_id       |       item_id       |       something_here

      21                           1                          2
      29                           1                          10
      30                           1                          3
      31                           2                          9

What i would like to do is display the above data from my database in a table looking like this:

receipt_id       |       item_id       |       total_something_here

      21                           1                          15
      31                           2                          9


in short, i want to show only different item_id with the sum of something_here field for all records where item_id is the same

ie 10 + 3 + 2 = 15
in the above example
please help me

Howdy,

I'm trying to display text from a table in a database. It's a list of quotes, so I just need to pull out the quote and the author name. However, the quote and name are not fields in the same record; they are separate records. Example data:

Code: [Select]
quoteid    name        value
1            content You guys are great! Thanks for being awesome.
1            author John Jackson
2            content Gosh you're amazing! Always been so darn helpful!
2            author Peter Davis
So, I just need to rip out the data from 'content' and 'author', and then group them together based on the quoteid. This is my code thus far:

$testimonial_resource = mysql_query("SELECT name, value FROM quotes GROUP BY quoteid ORDER BY author ASC") or die(mysql_error());

while ($testimonial = mysql_fetch_assoc($testimonial_resource)) {

echo '<p>'.$testimonial['value']'.<br /><strong>'.$testimonial['value'].'</strong></p>';

}

Any help would be greatly appreciated for this novice.

Cheers.

right now it displays the first column of the array as a header for each foreach loop then i've got the data displayed under each header and it has 4 columns or a number of my choosing with data displayed under the Table Headings. I am trying to make it display 4 or so columns but with the each group having a certain number of grouped table (data/header) in each column. a different amount for each column that i can choose

IF Possible i'd like the choice of being able to remove the headers eg. Z when there is no data in them.

This is an example of how it is being displayed right now

Any Help would be greatly appreciated

Quote

A
Airlie Beach   Andergrove   Alexandra   Armstrong Beach
Alligator Creek
B
Bucasia   Blacks Beach   Beaconsfield   Bakers Creek
Balberra   Bloomsbury   Breadalbane   Ball Bay
Belmunda
C
Cannonvale   Calen   Crystal Brook   Cremorne
Chelona   Campwin Beach   Cape Hillsborough
Conway


Heres The Code i have so far.

Code: [Select]
<?php
  $file = "widget.csv";
@$fp = fopen($file, "r") or die("Could not open file for reading");
$outputArray = array();
$count = 0;

while(($shop = fgetcsv($fp, 1000, ",")) !== FALSE)
{
    $outputArray[array_shift($shop)] =  array_filter($shop);
}

echo "<table>";
foreach ($outputArray as $alphabetical=>$value){
    echo "<th colspan='4'><b>" . $alphabetical ."</b></th>";
    echo "<tr>";
foreach ($value as $key){
$afterkey=preg_replace('/\s+/','-',$key);
    if ($count == 4){
    echo '</tr><tr><td><a href="map.php?mapaddress='.$afterkey.'-qld&mapname='.$key.'">'.$key.'</a></td>';
    $count = 0;
    }else{
    echo '<td><a href="map.php?mapaddress='.$afterkey.'-qld&mapname='.$key.'">'.$key.'</a></td>';
    }
$count++;    
}
    echo "</tr>";
$count = 0;
}
    echo "</table>";

    echo "\n<br />";

?>


Heres an example of what i am trying to do.

A D K N S AlexandraHeadlands DickyBeach KingsBeach Nambour SandstonePoint Aroona Diddillibah KielMountain Ninderry ShellyBeach Doonan KundaPark NoosaHeads SippyDowns B Dulong Kuluin Ningi SunriseBeach Beachmere DeceptionBay Kilcoy NorthArm SunshineBeach BanksiaBeach Noosaville Scarborough Beerburrum E L Beerwah EerwahVale Landsborough O T Bellara Elimbah Tanawha Bellmere Eudlo M P TowenMountain Birtinya Eumundi Maleny Petrie Tewantin Bongaree Mapleton Palmview TwinWaters Bokarina F Marcoola Palmwoods BribieIslandArea Flaxton MarcusBeach Parklands U Buddina ForestGlen MaroochyRiver Parrearra UpperCaboolture Burnside Maroochydore PeregianBeach Buderim G Minyama Pinbarren V Burpengary GlassHouseMountains MoffatBeach PointArkwright Valdora BliBli Mons PelicanWaters H Montville PacificParadise W C Highworth Mooloolaba WeybaDowns CoolumBeach Hunchy Mooloolah Q Warana Caboolture MountainCreek WestWoombye CabooltureSouth I MountCoolum R Woombye Caloundra ImageFlat Morayfield Rosemount Woorim CastawaysBeach Mudjimba Redcliffe WamuranBasin Chevallum J Woodford CoesCreek WoodyPoint Cooroy Wamuran Currimundi Wurtulla X Y YandinaCreek Yandina Z

can someone help to add new products and increase the quantity of the product when pressing the + button, but it works for [-]

Code: [Select]
<?php
include "./php/connection.php";

function products () {
$query = "SELECT * FROM product";
if (@mysql_num_rows($query)==0) {
echo "There are no products to display!";
}
else {
while ($query_row = mysql_fetch_array($query)) {
print
"<div class='product'>" .
"<img class='img' src=". $row["Image"]." alt='phone' width='100' height='150' />" .
"<p class='name'>".$row["Name"]."</p>".
"<p class='price'>&pound;". $row["Price"] ."</p>".
"<p><a href='./cart.php?ProductID=". $row["ProductID"]."' class='myButton'>More Info</a></p>".
"</div>";
}
}
}

if (isset($_GET['ProductID'])) {
$quantity = mysql_query('SELECT * FROM product WHERE ProductID = ' .$_GET["ProductID"]);
while ($quantity_row = mysql_fetch_array($quantity)) {
if ($quantity_row["Quantity"]!=@$_SESSION["cart_".$_GET["ProductID"]]) {
@$_SESSION["cart_".$_GET["ProductID"]]+="1";
}

}
}

if (isset($_GET["remove"])) {
$_SESSION["cart_".$_GET["remove"]]--;
header("Location: ./cart.php"); # Go back to the login pages
}

if (isset($_GET["delete"])) {
$_SESSION["cart_".$_GET["delete"]]="0";
header("Location: ./cart.php"); # Go back to the login pages
}

function paypal_items() {
$num = 0;
foreach($_SESSION as $name => $value) {
if ($value!=0) {
if (substr($name, 0, 5) == "cart_") {
$productid = substr($name, 5, (strlen($name)-5));
$query = mysql_query('SELECT ProductID, Manufacturer, model, Price FROM product WHERE ProductID =' .$productid);
while ($query_row = @mysql_fetch_array($query)) {
$num++;
echo '<input type="hidden" name="item_number_'.$num.'" value="'.$productid.'">';
echo '<input type="hidden" name="item_name_'.$num.'" value="'.$query_row['Name'].'">';
echo '<input type="hidden" name="amount_'.$num.'" value="'.$query_row['Price'].'">';
echo '<input type="hidden" name="shpping_'.$num.'" value="0">';
echo '<input type="hidden" name="shpping_'.$num.'" value="0">';
echo '<input type="hidden" name="quantity_'.$num.'" value="'.$value.'">';
}
}
}
}
}



function cart () {
print
"<table id='producttable' border='1'>".
"<tr>".
"<td class='td top'>Delete</td>".
"<td class='td top'>Product Name</td>".
"<td class='td top'>Quantity</td>".
"<td class='td top'>Price</td>".
"<td class='td top'>Sub Total</td>".
"</tr>";
foreach($_SESSION as $name => $value) {
if ($value>0) {
if (substr($name, 0, 5) == "cart_") {
$productid = substr($name, 5, (strlen($name)-5));
$query = mysql_query('SELECT * FROM product WHERE ProductID =' .$productid);
while ($query_row = @mysql_fetch_array($query)) {
$sub = $query_row["Price"] * $value;
print
"<tr>".
"<td class='td'><a href='./cart.php?delete=".$productid."'> [Delete] </a></td>".
"<td class='td'>".$query_row["Manufacturer"]."</td>".
"<td class='td'>".$value."</td>".
"<td class='td'><a href='./cart.php?ProductID=".$productid."'> [+] </a>&pound;".$query_row["Price"]."<a href='./cart.php?remove=".$productid."'> [-] </a></td>".
"<td class='td'>&pound;".$sub."</td>".
"</tr>";
}
}
@$total += $sub;
}
}
if (@$total==0) {
echo "<p>Your basket is empty</p>";
}
else {
echo @" Total: &pound" .$total;
?>
                            <form action="https://www.paypal.com/cgi-bin/webscr" method="post">
                                <input type="hidden" name="cmd" value="_cart">
<input type="hidden" name="upload" value="1">
                                <input type="hidden" name="business" value="kamran193@hotmail.co.uk">
                                <?php
paypal_items();
?>
                                <input type="hidden" name="currency_code" value="GBP">
                                <input type="hidden" name="amount" value="<?php echo $total; ?>">
                                <input type="image" src="http://www.paypal.com/en_US/i/btn/x-click-but03.gif" name="submit" alt="Make payments with PayPal - it's fast, free and secure!">
                            </form>
<?php
}
echo "</table>";
}

echo cart();
echo products();
?>
           

Hi, 

I'm trying to display the products for a certain tag in the email for new order in wooCommerce. For example, I want that when a client buys a product with a certain tag, all the products that have that tag to be added automatically to the order email too. 

For now I achieved to display the tag in the email but not the products that have that tag. I don't know how get the products that belongs to that tag and add them to the cart to so I can display them in the email.

Any help as small as it may be, it is very welcomed, please. I'm a bit stuck. I'm not very skilled in php...

Thank you very much

function email_products_per_tag( $order, $item ) {
    $items = $order->get_items();
    foreach ( $items as $item ) {
        $terms = wp_get_post_terms( $item['product_id'], 'product_tag' );
        foreach($terms as $term){
            $term_names[] = $term->name; // Product tag Name
           // $item2 = 'product_tag'=> ; // not very sure about this line...
        }
    }
}
    add_action( 'woocommerce_email_after_order_table', 'email_products_per_tag', 10, 4 );

 

Edited September 15, 2020 by cimita