PHP - Count Multidimensional Arrays

Hi,

I am building an online store, and have been using a tutorial to get me started.
I have been adjusting the code as I require additional functionality and I have hit a brick wall...

I have a multidimensional array that contains all of the information I have passed from the product page.
What I want to do is write a piece of PHP code that will increase the quantity of a particular item based on 2 of 3 variables matching the data in the array.
Below is the full working code which runs the adjustment based on...

Code: [Select]
<?php
if ($key == "item_id" && $value == $item_to_adjust) {
?>

What I want to do is add to the if statement like so...

Code: [Select]
<?php
if (($key == "item_id" && $value == $item_to_adjust) && (($key == "custom_txt" && $value == $custom_txt) || ($key == "img" && $value == $fileName))) {
?>

But this code doesn't seem to work, Is there another way to get the result I am after?

Code: [Select]
<?php 
//       Section 3 (if user chooses to adjust item quantity)
if (isset($_POST['item_to_adjust']) && $_POST['item_to_adjust'] != "") {

$item_to_adjust = $_POST['item_to_adjust'];
$custom_txt = $_POST['custom_txt'];
$fileName = $_POST['fileName'];
$quantity = $_POST['quantity'];
$quantity = preg_replace('#[^0-9]#i', '', $quantity); // filter everything but numbers
if ($quantity >= 100) { $quantity = 99; }
if ($quantity < 1) { $quantity = 1; }
if ($quantity == "") { $quantity = 1; }
$i = 0;
foreach ($_SESSION["cart_array"] as $each_item) { 
      $i++;
      while (list($key, $value) = each($each_item)) {
  if ($key == "item_id" && $value == $item_to_adjust) {
  // That item is in cart already so let's adjust its quantity using array_splice()
  array_splice($_SESSION["cart_array"], $i-1, 1, array(array("item_id" => $item_to_adjust, "quantity" => $quantity)));
  } // close if condition
      } // close while loop
} // close foreach loop
}
?>

Thanks in advance!
Richi

How do i ouput it like this

Code: [Select]
Array
(
[Griffin] => Array
  (
  [0] => Peter
  [1] => Lois
  [2] => Megan
  )
[Quagmire] => Array
  (
  [0] => Glenn
  )
[Brown] => Array
  (
  [0] => Cleveland
  [1] => Loretta
  [2] => Junior
  )
)
rather than this

Code: [Select]
Array ( [field_name] => first_name [field_type] => 1 [max_length] => 20 ) Array ( [field_name] => last_name [field_type] => 1 [max_length] => 40 ) Array ( [field_name] => email [field_type] => 1 [max_length] => 80 )
Code: [Select]
  $fields = array();
 
  foreach ($_POST['use'] as $field){
 
      $fields = array(
  "field_name"=>$field,
  "field_type"=>$match_types[$i],
  "max_length"=>$match_length[$i]);

print_r($fields);

echo $fields[0]['field_name'];
 
  //echo $field.' - Type: '.$match_types[$i].' - Lenght: '.$match_length[$i]."<br />";
 
  $i++;
 
      }

I have an array titled $uhits that looks like this:

Array (
    => Array ( [user] => test
      [hits] => 20 )
   [3] => Array (
      [user] => test3
      [hits] => 6 )
   [4] => Array (
      [user] => test4
      [hits] => 6 )
   [1] => Array (
      [user] => test1
      [hits] => 4 ) 
   [2] => Array (
      [user] => test2
      [hits] => 4 ) )

I've searched and tried so many different functions and  am losing my mind after trying for 3 hours to be able to search for a specific user's value and then display it and the hits value.  How in the world can I achieve this?

Suppose I have a multidimensional array...

$AnArray[1][$j]

I'd like to count how many $j

So if $AnArray = array(0 => array('orange', 'banana', 'apple'), 1 => array('carrot', 'collard', 'pea','tuna'));

The count I'm after would be 4...

Code: [Select]
array ( 0 => array ( 'id' => '6', 't' => 'Food & Beverage', ), 1 => array ( 'id' => '6', 't' => 'Food & Beverage', ), 2 => array ( 'id' => '6', 't' => 'Food & Beverage', ), 3 => array ( 'id' => '6', 't' => 'Food & Beverage', ), 4 => array ( 'id' => '2', 't' => 'Automotive', ), 5 => array ( 'id' => '2', 't' => 'Automotive', ), )
I've get after launching.

foreach($array as $value) {
    if(!isset($new_array[$value['id']])) {
        $new_array[$value['id']] = $value;
        $new_array[$value['id']]['cnt'] = 0;
    }
    $new_array[$value['id']]['cnt']++;
}

I get.

Code: [Select]
array ( 6 => array ( 'id' => '6', 't' => 'Food & Beverage', 'cnt' => 10, ), 2 => array ( 'id' => '2', 't' => 'Automotive', 'cnt' => 2, ), )
where I should get.

Code: [Select]
array ( 6 => array ( 'id' => '6', 't' => 'Food & Beverage', 'cnt' => [b]4[/b], ), 2 => array ( 'id' => '2', 't' => 'Automotive', 'cnt' => 2, ), )
How can I fix this issue?

-----------------------------------------------------

I've received solution on other board.

$array = array ( 0 => array ( 'id' => '6', 't' => 'Food & Beverage', ), 1 => array ( 'id' => '6', 't' => 'Food & Beverage', ), 2 => array ( 'id' => '2', 't' => 'Automotive', ), );
 
$return = array();
$count = array();
foreach( $array as $item ) {
    if ( !in_array($item, $return) ) {
        $return[] = $item;
        $count[ $item['id'] ] = 1;
    } else {
        $count[ $item['id'] ]++;
    }
}
 
foreach( $return as & $item ) {
    $item['cnt'] = (int)$count[ $item['id'] ];
}
 
var_dump( $return );


thank you

---

the code above works too, I've put it in WHILE() and didn't noticed it. Sorry

Thanks

I'm very beginner with arrays.... i KNOW, databases exist, it's more easy.. I can't use a database.. I have to use, this.. or similar.. that doesn't requiring a database engine... 

So... that array...

array (
     array(string, int, int, string, string),
     array(string, int, int, string, string),
     array(string, int, int, string, string),
    ....+250
     array(string, int, int, string, string)

);

I search by the element [#][0].. in the +250 some will contain the same infos and I would like to make them point to the element containing the info instead of repeating it and have to update at 3-4 places when it's time. Like what it's in "10" also good for "ten", "dix" and "diez"...

anyway to make that simple?  by reference or...???

I'm crying.. last time I used arrays... Turbo Pascal.. at school... or was it Turbo C++ 3.0?? Maybe it was with cobol... well it was the good ol' time of the 90s!

 

Thanks!

 

-TRP-
 

 

 

Hi wondering if there's a simple way to merge or update the data from one array to another . I've tried merge data but it just adds additional records rather than merging them off one common key.   The array is just simply adding a name to another array the format of both is as follows   Array 1   [0] => stdClass Object
(
[name] =>
[market] => Football
[selection] => 7051575

)   )   Array 2   Array
(
[0] => stdClass Object
(
[name] => Something
[market] =>
[selection] => 7051575

) )     There are other fields but I'm just trying to merge the name from Array two into Array one using the selection as a common key. Is there an easy command like merge or do I have to loop thru the arrays to add the data.   Thanks

I have a MySQL query that pulls multiple columns with many rows.  I want to break each column into its own array.
Here is what I have to this point but doesn't seem to be working.  Is this the right direction or is there something easier?
Thanks!

Code: [Select]

$query = "SELECT name, address, city, state FROM customers WHERE sku = '12345'";
$result = mysqli_query($dbc, $query) or die();

$name = array();
$address = array();
$city = array();
state = array();

while ($data = mysqli_fetch_assoc($result)) {
  $name = $data['name'];
  $address = $data['address'];
  $city = $data['city'];
  $state = $data['state'];
}

Hi all

I have an array and within that array that list categories. Each category has a sub category.
I am trying to output in JSON and my problem is this:

I am looping through each category and displaying the results. As the category has sub categories I am then looping through them and displaying the sub categories.
This works fine, but my JSON is not valid because of a single comma:

Code: [Select]
{
   "config":{
      "logo":"uploads\/global_config\/scaled_",
      "deliveryCost":19.99,
      "showPrice":"true"
   }
},
"range":[
   {
      "title":"Classic",

      "doors":[
         {
            "id":19,
            "title":"Rembrandt"
         },
         {
            "id":66,
            "title":"Picasso"
         },
         {
            "title":"Heritage",
            "doors":[
               {
                  "id":29,
                  "title":"Broadway"
               },
               {
                  "id":30,
                  "title":"Draycott"

               },
 
               {
                  "title":"Regency",

                  "doors":[
                     {
                        "id":36,
                        "title":"Canterbury"
                     },
 
                     {
                        "id":47,
                        "title":"Exeter"
                     },      <---- this comma is failing my json

                  ],
                  "product":{
                     "glass":[
                        {
                           "id":7,
                           "title":"Pad"
                        },
                        {
                           "id":6,
                           "title":"Scroll"
                        }
                     ]
                  }
               }
My PHP:

<?php
    echo '{';
        $count = count($config) - 1;

        foreach($config as $key=>$conf)
        {
             $conf_price = $conf->getPrice() == '1';
                if($conf_price)
                     $conf_p = 'true';  else  $conf_p = 'false';
                        echo "\"config\"".":","";
                            $config_array = array('logo'=>strtolower(str_replace(' ','-','uploads/global_config/scaled_'.$conf->getImage1())), 'deliveryCost'=>$conf->getDeliveryCost(), 'showPrice'=>$conf_p);
                                if($key == $count){
                                    echo json_encode($config_array).","."\n";
                                } else {
                                    echo json_encode($config_array).'},'."\n";
                                }

       }
          echo json_encode("range").": [\n";

              $last_key = end(array_keys($categories));

              foreach ($categories as $key => $cat)
              {
                if ($key == $last_key)
                {
                    echo "{".   "\"title\"".':'.'"'.$cat->getTitle().'"'.","."\"src\"".':'.'"'."-".strtolower(str_replace('.png','*.png',(str_replace(' ', '-', 'uploads/ranges/scaled_'.$cat->getImage1())))).'"' .","."\"info\"".':'.'"'.strip_tags($cat->getDescription()).'"'.","."\n";
                } else {
                    echo "{".   "\"title\"".':'.'"'.$cat->getTitle().'"'.","."\"src\"".':'.'"'."-".strtolower(str_replace('.png','*.png',(str_replace(' ', '-', 'uploads/ranges/scaled_'.$cat->getImage1())))).'"' .","."\"info\"".':'.'"'.strip_tags($cat->getDescription()).'"'.","."\n";
                }

                            echo json_encode("doors").": [\n";

                                $count = count($cat->getAllDoorStyles()) - 1;
                                foreach ($cat->getAllDoorStyles() as $key=>$door)
                                {
                                     $array2 = array('id'=>$door->getId(), 'title'=>$door->getTitle(), 'src'=>strtolower(str_replace('.png','*.png',(str_replace(' ', '-', 'uploads/doors/scaled_'.$door->getImage1())))), 'price'=>$door->getPrice(), 'description'=>strip_tags($door->getDescription()));
                                     if($key == $count)
                                     {
                                         echo json_encode($array2).''."\n"."".",";
                                     } else {
                                            echo json_encode($array2).''."\n".""."";
                                     }
                                }
                        }
                   echo "\n";
                   echo "],"."\"Product:\"". '{ ';

                   echo json_encode("glass").": [\n";

                     $count = count($glass) - 1;
                     foreach($glass as $key => $glass_cat)
                     {
                     $glass_array = array('id'=>$glass_cat->getId(), 'title'=>$glass_cat->getTitle(), 'price'=>$glass_cat->getPrice(),'src'=>strtolower(str_replace('.png','*.png',(str_replace(' ', '-', 'uploads/glass_option/scaled_'.$glass_cat->getImage1())))));
                     if($key == $count)
                     {
                            echo json_encode($glass_array)."\n";
                     } else {
                            echo json_encode($glass_array).','."\n";
                     }
                    }
                    echo ']';

                             echo '}';
                             echo '}';

I need to omit the comma that is causing me my problem

All help welcomed

Hi everyone,

If you take a look at my code below I am having trouble echoing the key/ value pair of the 'sex' array which is a sub array of 'pens'.  I have tried so many different ways but to no avail, thanks Chris!

Code: [Select]
<?php
$products = array(
'paper' => array(
'copier' => "Copier & Multipurpose",
'inkjet' => "Inkjet Printer",
'laser'  => "Laser Printer",
'photo'  => "Photographic Paper"),

'pens' => array(
'ball'   => "Ball Point",
'hilite' => "Highlighters",
'marker' => "Markers",
'sex' => array (
'condom' => "Protection")),

'misc' => array(
'tape'   => "Sticky Tape",
'glue'   => "Adhesives",
'clips'  => "Paperclips") );

echo "<pre>";
foreach ($products as $section => $items )

foreach ($items as $key => $value)
echo "$section:\t$key\t($value)<br>";

echo "</pre>";
?>

I have created a basic array by pulling values from a database but now need to count how many of the array values are 0.

Here is my code so far:

$qty_array = array();
$qty_array[0] = $product_row["WF_qty"];
$qty_array[1] = $product_row["SD_qty"];
$qty_array[2] = $product_row["DD_qty"];
$qty_array[3] = $product_row["CD_qty"];
$qty_array[4] = $product_row["PD_qty"];
$qty_array[5] = $product_row["SP_qty"];
$qty_array[6] = $product_row["VS_qty"];
$qty_array[7] = $product_row["RO_qty"];
$qty_array[8] = $product_row["PO_qty"];

$qty_count = count($qty_array);

This is returning the value 9 as I expected but I am not sure how to change the count function so that I count values that are 0 and ignore the rest.

Can anyone help?

Hello again   Sorry, I come back cap in hand to ask for one last bit of help. After this I should be done never to bother you again.   I posted just previously regarding outputting the results of a MySQL COUNT query to a PDF file. Staying on that subject to an extent, I've been wracking my brains on why this conundrum isn't working. As before, I wish to display the information from one table but unlike before there are multiple rows as opposed to multiple columns.   I have my table 'faults' and wish to query the top ten, or top most occurring 'site_id' in this table. The following MySLQ query as before works just fine in phpMyAdmin:   "SELECT `site_id` AS `site`, COUNT(*) AS `count` FROM `faults` GROUP BY `site` ORDER BY count(*) DESC;"   Not much in the DB right now but it yields the following as I expect:   Site     Count     1            7   2            6   3            6     I was hoping getting this into a PDF wouldn't be so tricky but as usual I've come unstuck. Essentially what is happening is that it's only displays the bottom row, not all. Here's my code:  

<?php


require('pdf/fpdf/fpdf.php');
include('core/connect.php');


//Create new pdf file
$pdf=new FPDF();


$pdf->Open();


//Disable automatic page break
$pdf->SetAutoPageBreak(false);


//Add first page
$pdf->AddPage();


//Heading
$pdf->SetFillColor(255,255,255);
$pdf->SetFont('Arial','BU',12);
$pdf->SetY(25);
$pdf->SetX(25);
$pdf->Cell(25,6,'Top Site:',9,0,'L',1);


$result_topten = mysqli_query($con, 


"SELECT `site_id` AS `site`, COUNT(*) AS `count`
    FROM `faults`
    GROUP BY `site`
    ORDER BY count(*) DESC;");
  
while($row = mysqli_fetch_array($result_topten))
{


$site   = $row['site'];
$num_faults   = $row['count'];


}
$pdf->SetFillColor(192,192,192);
$pdf->SetFont('Arial','B',10);
$pdf->SetY(35);
$pdf->SetX(25);
$pdf->Cell(50,6,'Site',1,0,'C',1);
$pdf->Cell(50,6,'Number of faults',1,0,'C',1);


$pdf->SetFillColor(232,232,232);
$pdf->SetFont('Arial','',10);
$pdf->SetY(45);
$pdf->SetX(25);
$pdf->Cell(50,6,$site,1,0,'C',1);
$pdf->Cell(50,6,$num_faults,1,0,'C',1);


$i = $i++;


//Send file
$pdf->Output();
?>

Resulting output in the PDF:   Top Site:

Hi everyone   I have a requirement to create some reports and outputting these to a PDF. I'm using FPDF which seems to be rather user-friendly. I was hoping someone could help with me a problem I have regarding MySQL COUNT and PHP arrays.   I have a table named 'faults' and within this a row called 'level'. There are three 'levels' = P1, P2, P3 that could populate this row. I wish to display the output into a PDF so it looks something like this:   Total number of faults;   P1           P2           P3   1              2              3   Where I'm falling short is how to perform the COUNT and then grab the data stick it into an array and output it to the PDF. The MySQL statement you see below, if put directly into phpMyAdmin, seems to do the trick, so I'm hoping I'm on the right track. So far I have this:

<----OUTPUT OMITTED---->

$result=mysqli_query($con, 


"SELECT
 COUNT(IF(level='P1',1, NULL)) 'P1', 
 COUNT(IF(level='P2',1, NULL)) 'P2', 
 COUNT(IF(level='P3',1, NULL)) 'P3' 
 FROM faults");


//initialize counter
$i = 0;


//Set maximum rows per page
$max = 25;


while($row = mysqli_fetch_array($result))
{
//If the current row is the last one, create new page and print column title
if ($i == $max)
{
$pdf->AddPage();


//print column titles for the current page
$pdf->SetY($y_axis);
$pdf->SetX(25);
$pdf->Cell(50,6,'Total P1s',1,0,'L',1);
$pdf->Cell(50,6,'Total P2s',1,0,'L',1);
$pdf->Cell(50,6,'Total P3s',1,0,'L',1);


//Go to next row
$y_axis = $y_axis + $row_height;


//Set $i variable to 0 (first row)
$i = 0;
}


//This bit definitely ain't right
$p1 = $row['level'];
$p2 = $row['level'];
$p3 = $row['level'];




$pdf->SetY($y_axis);
$pdf->SetX(25);
$pdf->Cell(50,6,$p1,1,0,'L',1);
$pdf->Cell(50,6,$p2,1,0,'L',1);
$pdf->Cell(50,6,$p3,1,0,'R',1);


//Go to next row
$y_axis = $y_axis + $row_height;
$i = $i + 1;
}


//Send file
$pdf->Output();


?>

Appreciate it must look a mess, but would appreciate someone cleverer than me pointing me in the right direction.

Hi guys,

I need your help. I am trying to insert the rows in the mysql database as I input the values in the url bar which it would be like this:

Code: [Select]
www.mysite.com/testupdate.php?user=tester&pass=test&user1=tester&email=me@shitmail.com&ip=myisp

However i have got a error which i don't know how to fix it.


Error: Column count doesn't match value count at row 1


<?php
session_start();
    define('DB_HOST', 'localhost');
    define('DB_USER', 'mydbusername');
    define('DB_PASSWORD', 'mydbpassword');
    define('DB_DATABASE', 'mydbname');

$errmsg_arr = array();
    $errflag = false;

    $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
    if(!$link) {

die('Failed to connect to server: ' . mysql_error());
    }

    $db = mysql_select_db(DB_DATABASE);
    if(!$db) {

die("Unable to select database");
    }

   function clean($var){

return mysql_real_escape_string(strip_tags($var));
    }
  $username = clean($_GET['user']);
    $password = clean($_GET['pass']);
    $adduser = clean($_GET['user1']);
    $email = clean($_GET['email']);
    $IP = clean($_GET['ip']);
    if($username == '') {
  $errmsg_arr[] = 'username is missing';
  $errflag = true;
    }
    if($password == '') {
  $errmsg_arr[] = 'PASSWORD is missing';
  $errflag = true;
    }
    if($errflag) {
  $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
  echo implode('<br />',$errmsg_arr);
   }
   else {
   $sql = "INSERT INTO `members` (`username`,`email`,`IP`) VALUES ('$adduser','$email','$IP')";

if (!mysql_query($sql,$link))
  {
  die('Error: ' . mysql_error());
  }
echo "The information have been updated.";
  }
?>


Here's the name of the columns i have got in my database:

Code: [Select]
username
email
IP


I have input the correct columns names, so I can't correct the problem I am getting.

Please can you help?