PHP - Sql > Php > Table With Grouped Totals.

Hi, I'm having issues trying to add up the totals of each product type in a while loop- I'm sure it's straightforward to fix but for some reason I can't find a way to get it to add up all the totals of the various product types and list them so we have say 5 of product 1, 11 of product 2, 8 of product 3 and so on.

So firstly the user searches between two different dates / times to get the orders made during that time period: (I'm using separare date and time fields as the datetime-local input doesn't work in a lot of browsers)

if($_POST['search'])
{
    $searchdate1 = mysqli_real_escape_string($conn, $_POST['_Date1']);
    $searchdate2 = mysqli_real_escape_string($conn, $_POST['_Date2']);
    
    $searchtime1 = mysqli_real_escape_string($conn, $_POST['_Time1']);
    $searchtime2 = mysqli_real_escape_string($conn, $_POST['_Time2']);
    
    $datetime1 = $searchdate1 . ' ' . $searchtime1;
    $datetime2 = $searchdate2 . ' ' . $searchtime2;
    
    $nicedate1 = date("l F j, Y", strtotime($searchdate1) ); //Just used for readability in the report
    $nicedate2 = date("l F j, Y", strtotime($searchdate2) );

//Now get the orders from the db

$getorders = $oc_conn->query("SELECT * FROM oc_order WHERE date_added >= '$datetime1' AND date_added <= '$datetime2' AND order_status_id != 0 ORDER BY order_id DESC");

//Then generate start of a table in HTML, the while loop that follows will populate the rows

while ($row = $getorders->fetch_assoc()) { //Get the order data

          $firstname = $row["firstname"];
          $lastname = $row["lastname"];
          $fullname = $firstname . ' ' . $lastname;
        $orderid = $row["order_id"];
        $orderdate = $row["date_added"];    
          $email = $row["email"];
        $total = $row['total'];
          $total = number_format($total, 2);
            
        $niceorderdate = date('F j, Y H:i', strtotime($orderdate));    
            
             echo '<tr><td>'.$fullname.'</td><td>'. $orderid . '</td><td>';
    
            $getproducts = $oc_conn->query('SELECT * FROM oc_order_product WHERE order_id = '.$orderid); //Product names and details are held in a separate table
        
                while ($row = $getproducts->fetch_assoc()) {
                    
                    $orderproductid = $row["order_product_id"];
                    $productname = $row["name"];            
                    $quantity = $row["quantity"];
                    echo $quantity . ' x '.$productname.' <br>'; //This works for each individual order, but what I need is the total $quantity of each $productname, across ALL orders in the time range
                
                }
            echo '</td><td>'. $niceorderdate.'</td></tr>';           
        }
    echo '</tbody></table>';
}
?>

[/PHP]

As mentioned in the comment above, what I need is the total $quantity of each $productname, across ALL orders in the time range, so that I can see how many of each product ($productname) were ordered in total.

I tried using SUM for quantity in the mySQL, and COUNT for adding up the different product names but for some reason it didn't work. Can someone let me know what I need to do? Thanks :)

$input_table=array('1'=>'toto','2'=>'tota','3'=>'hello','4'=>'TOTO','5'=>'toto');
$input_table_2 = array_map('strtolower', $input_table);
$value_to_look_for='Tot';
$value_to_look_for_2=strtolower($value_to_look_for);
$output_table=array();
foreach ($input_table_2 as $k=>$v)
  {
  if(false !== strpos($v, $value_to_look_for_2))
    {
    $output_table[]=$input_table[$k];
    }
}

Hello everyone.

I need help with the following PHP APP. I am running on (Version PHP 7.2.10) I am trying to have a page table form on table.php pass the input variable of “5-Numbers” to another page called table_results.php

I want that variable string of “5-Numbers” to be compared against 4 arrays and output any duplicates found within each of those 4 lists. If nothing is found, I still want some visual output that reads “None found”.

Lets pretend I have the following example ..

On table.php, I typed inside my table form the 5-Numbers ..

INPUT:  2,15,37,13,28

On table_results.php, the 4 arrays to be compared against my input numbers “ 2,15,37,13,28” are ..

$array_A = array(2,6,8,11,14,18,24); 

$array_B = array(1,2,9,10,13,14,25,28,);  

$array_C = array(1,3,7,9,13,15,20,21,24); 

$array_D = array(4,5,12,22,23,27,28,29); 

So my output should read as follows below ..

OUTPUT: 

TABLE

COLUMN 1   COLUMN 2

ROW 1 Matches Found Results ..

ROW 2 GROUP A:            2 

ROW 3 GROUP B:             2,13,28

ROW 4 GROUP ?            13,15

ROW 5 GROUP ?            28

ROW 6 5#s Input:              2,15,37,13,28

Please let me know if anyone has any suggestions on how to go about it. 

Thanks.

$query = "SELECT cv.day_id, cv.dues, cv.last_visit, cv.points
FROM clubvisit cv
WHERE last_visit >=
(
SELECT MAX(last_visit) FROM clubvisit
WHERE points <>
(
SELECT points as lastpoints
FROM clubvisit
JOIN
(
SELECT MAX(last_visit) as last_visit
FROM clubvisit
) as latest USING (last_visit)
)
)";

hi...

i have a table ...

i add and remove data in the table...when i add new record , information add to center of the table ! whats problem?   i want add data in first of table.   please guide me.thanks

<?php



$con = mysql_connect("localhost","root","aaa");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


mysql_select_db("ccc", $con);


$PI_No = $_POST['PI_No'];
$PO_No = $_POST['PO_No'];


$qry = "INSERT INTO wm_order_entry (
Order_No,
PI_No,
PO_No) 


VALUES(
NULL,
  '$PI_No',
 '$PO_No')";
$result = @mysql_query($qry);




$val1=$_POST['Size'];
$val2=$_POST['Style'];
$val3=$_POST['Colour'];
$val4=$_POST['Season_Code'];
$val5=$_POST['Dept'];
$val6=$_POST['Sub_Item'];
$val7=$_POST['Item_Desc'];
$val8=$_POST['UPC'];
$val9=$_POST['Qty'];
$N = count($val1);
for($i=0; $i < $N; $i++)
{


$profile_query = "INSERT INTO order_entry(Size,
Style,
Colour,
Season_Code,
Dept,
Sub_Item,
Item_Desc,
UPC,
Qty,
Order_No
) VALUES( '$val1[$i]','$val2[$i]','$val3[$i]','$val4[$i]','$val5[$i]','$val6[$i]','$val7[$i]','$val8[$i]','$val9[$i]',LAST_INSERT_ID())";
$t_query=mysql_query($profile_query);
}
header("location: WMView.php");
mysql_close($con);
?>