PHP - Multidimensional Arrays Via Post.

How do I find out how large a dimension of an array is?

I have an array with an X and a Y coordinate, and in the 3rd dimension I store it as the value of an ID.

so an array might be x,y,560; x,y,415, etc. I can run a counter within the loop to determine the total number of iterations of the loop, but that isn't an accurate picture of how large the 3rd dimension of the array is.
 

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...

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

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 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>";
?>

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'];
}

Ok so I need to know how this code:
Code: [Select]
<form>
<?php
// Query member data from the database and ready it for display
$sql1 = mysql_query("SELECT * FROM products where id='".$pid."'");
while($row = mysql_fetch_array($sql1)){
$product =$row["product"];
$pid=$row["id"];

?>
<?php
// Query member data from the database and ready it for display
$sql4 = mysql_query("SELECT * FROM labels where item_id='".$pid."'");
while($row = mysql_fetch_array($sql4))for($i=0; $i<1; $i++){

$label =$row["label"];
$lid=$row['id'];
echo $label; 
?>

<select name="name1[]">
<?php
// Query member data from the database and ready it for display
$sql3 = mysql_query("SELECT * FROM options where item_id='".$pid."' && label_id='".$lid."'");
while($row = mysql_fetch_array($sql3)){
$option =$row["option"];
?>
<option value="<?php echo $option; ?>">
<?php echo $option; ?>
</option>
<?php

}
?>
</select>
</br>
<?php }
?>
<?php
}?>
If this product is for someone other than the listed, change it, otherwise leave it:<br />

<input ID="outputField<?php echo $id; ?>" name="name123" type="text" VALUE="..." />
<input name="qty" type="hidden" value="<?php echo $qty; ?>" />


  <input type="submit" id="hellobob<?php echo $id; ?>"  value="Submit" />

 </form>specifically this part:
Code: [Select]
<?php
// Query member data from the database and ready it for display
$sql4 = mysql_query("SELECT * FROM labels where item_id='".$pid."'");
while($row = mysql_fetch_array($sql4))for($i=0; $i<1; $i++){

$label =$row["label"];
$lid=$row['id'];
echo $label; 
?>
<input type="text" name="name[]" />
<input type="text" name="name2[]" />
<select name="name1[]">
<?php
// Query member data from the database and ready it for display
$sql3 = mysql_query("SELECT * FROM options where item_id='".$pid."' && label_id='".$lid."'");
while($row = mysql_fetch_array($sql3)){
$option =$row["option"];
?>
<option value="<?php echo $option; ?>">
<?php echo $option; ?>
</option>
<?php

}
?>
</select>
</br>I need to create an array from the name(1,2)[] parts.  The thing is, they are going to be pulled in a loop and return all results.  so there could be multiple name1[]'s name2[]'s or name[]'s.   I need to know how I would combine each one in it's loop to make part of a string.  thing is, the first time name[] would be included, second time it wouldn't be included.  then the arrays combine to make one.  so the final array looks like this
name[] name1[] name2[] name1[] name2[] name1[] name2[].  etc.  anyhelp on this?

Hi there,

I am wanting to insert post data into my DB, this is guest information

if i do a 

 $safePost = filter_input_array(INPUT_POST);
        print_r($safePost);

i get the following output.

Array

(

[action] => addGuestInfo

[guestno] => 2

[bookingid] => 151

[customerid] => 22

[Guestname-0] => Jamie

[Guestname-1] => Joe

[GuestAge-0] => 4-3

[GuestInfo-0] => celiac

[GuestAge-1] => 18

[GuestInfo-1] => wheat

)

normally the guestname-0, guestage-0, guestinfo-0 would be in correct order but we have to ensure the just incase it isns't (see output above) we cater for that aswell, we can have upto 6 guest details coming in at once.

so I need to loop through the data and insert into my DB. I have tried various for / foreach loops but cant seem to get it to group the data together

I have tried things like below, but it inserts each record multiple times.

$safePost = filter_input_array(INPUT_POST);
foreach($safePost as $key => $value){                 
            $exp_key = explode('-', $key);
          // for ($i =0; $i <= $guestcount; $i++) {
      switch ($exp_key[0]) {
        case 'Guestname':
            $booking->guestno = $exp_key[1];
            $booking->guestname = $val;
        break;
        case 'GuestAge':
            $booking->guestno = $exp_key[1];
            $booking->guestage = $val;

        break;
        case 'GuestInfo':
            $booking->guestno = $exp_key[1];
            $booking->guestinfo = $val;

        break;
        default:
        break;
  }
 //CALLS FUNCTION TO INSERT TO DB result = lastInsertId();
  $result= $booking->insertGuestDetails();
//}
}

 

Hi,

I have an HTML and a PHP script inserting data into DB.
My problem is when i submit the form, one of the arrays cannot be posted to my PHP Script.
The first SELECT-OPTION Values (mail_select[]) are being posted correctly, however the second SELECT-OPTION Values (OS[]) are not. It brings empty value at all.
If i put OS[] SELECT TAG to first place, -i mean put it before mail_select[] SELECT TAG-, this time mail_select[] brings nothing. And OS[] is being posted correctly.

What could the possible problems be?

Here is the HTML:

Code: [Select]
bla..bla..
<html>
<form id="SK" action="post.php" method="POST">
<tr>
<td>
<?php
$conn = getConn();
mysql_select_db(getDBName(),$conn);
$query = "select MEMBERS,NAME from mail;";
$result = mysql_query($query,$conn);

echo "<form>";
echo "<select name=\"mail_select[]\" id=\"mail_select[]\" multiple=\"multiple\">";

while($row = mysql_fetch_array($result)) {

$NAME = $row['NAME '];
$MEMBERS = $row['MEMBERS'];

echo "<option value='$MEMBERS'>$NAME</option>";
}

echo "</select></form>";
mysql_close($conn);
?>


</td>
</tr>
<tr><td>
<?php
$conn = getConn();
mysql_select_db(getDBName(),$conn);
$query = "select mark from olsystem;";
$result = mysql_query($query,$conn);

   echo "<form style=\"margin:20px 0\">";
   echo "<select name=\"OS[]\" id=\"OS[]\" multiple=\"multiple\">";
while($row = mysql_fetch_array($result)) {
   $isim = $row['mark'];
   echo "<option value='$mark'>$mark</option>";

}

echo "</select></form>";
mysql_close($conn);

?>

</td>
</tr>
<tr height="40"><td width="170"><div class="rowElem"><input type="submit" value="GO!" /><input type="reset" value="Clear" /></div></td></tr>
</form>
</html>
Here is my PHP script:

Code: [Select]
<?php
include("DB.php");

if(isset($_POST['OS'])){

$OS = implode(",",$_POST['OS']);
$mail_select = implode(",",$_POST['mail_select']);

register($OS,$mail_select);
}

function register($OS,$mail_select)

{
$conn = getConn();
mysql_select_db(getDBName(),$conn);
$query ="insert into outage(OS,mail_select) values ('$OS','$mail_select')";
mysql_query($query,$conn);

if(mysql_affected_rows()>0){

BLA BLA

} else {

}
mysql_close($conn);
}
?>

I have this thing that i am trying to make but i cant get it to work.. can anyone help?

Code: [Select]
function sql_read( $dbname,$dbusername,$dbpassword )
{
$names = array();
$password = array();


$connect = @mysql_connect("mysql11.000webhost.com",$dbusername,$dbpassword) or die("Could Not Connect");
@mysql_select_db ($dbname) or die("Could not find DataBase");


$query = mysql_query("select * from users");
$numrows = mysql_num_rows($query);

if ($numrows > 0){

while($row = mysql_fetch_assoc($query)){

$names[] = $row["uname"];
$password[] = $row["password"];
$id = $row["id"];

}
$return = array($names,$password,$id);

}else{
$return = array();
}


return $return[];
}



$names = array();

$names = sql_read("XXXXXX","XXXXXX","XXXXXXX")[0];


The error i get is
Code: [Select]
Parse error: syntax error, unexpected '[' in /home/a5480952/public_html/sql/index.php on line 28
Line 28 is "$names = sql_read("XXXXXX","XXXXXX","XXXXXXX")[0];"

Please help... i REALLLLD need help with this.. ask questions if you want to know more about what i am trying to do... thanks!

I'm having troubling with trying to create a function to spit out a single array with the following array. I can write it in a away that looks through the arrays manually. 

the results i am trying to generate is that each item in generated array.

Array to convert

array(
    "account" => array(
        "login",
        "register",
        "logout",
        "edit",
    ),
    "p" => array( 
        "report",
    ),
    "array1.0" => array( 
        "array2.0" => array(
            "array3.0",
            "array3.1
        ),
        "array2.1",
    ),

generating the array will look like this

 

Array ( 
[0] => account 
[1] => account/login 
[2] => account/register 
[3] => account/logout 
[4] => account/edit 
[5] => p 
[6] => p/report 
[7] => array1.0 
[8] => array1.0/array2.0
[9] => array1.0/array2.0/array3.0
[10] => array1.0/array2.0/array3.1
[11] => array1.0/array2.1

)

The idea is that id generates a single array with combined labels and arrays inside, etc. I just can't figure out how to create a script that will create this array even If I add a new value or array.