PHP - Build A Multilevel Table

I have an array which can contain nth number of arrays. These arrays contain data from a query joining three tables and a where clause

Code: [Select]
array
  0 =>
    array
      'account_num' => string '1' (length=1)
      'icd9_code' => string '1' (length=1)
      'dob' => string '12-12-1955' (length=10)
      'sex' => string 'Male' (length=4)
      'study' => string 'study 2' (length=7)
      'prescription' => string 'script 1' (length=8)
  1 =>
    array
      'account_num' => string '1' (length=1)
      'icd9_code' => string '1' (length=1)
      'dob' => string '12-12-1955' (length=10)
      'sex' => string 'Male' (length=4)
      'study' => string 'study 2' (length=7)
      'prescription' => string 'script 2' (length=8)
  2 =>
    array
      'account_num' => string '1' (length=1)
      'icd9_code' => string '1' (length=1)
      'dob' => string '12-12-1955' (length=10)
      'sex' => string 'Male' (length=4)
      'study' => string 'study 2' (length=7)
      'prescription' => string 'script 3' (length=8)
  3 =>
    array
      'account_num' => string '1' (length=1)
      'icd9_code' => string '1' (length=1)
      'dob' => string '12-12-1955' (length=10)
      'sex' => string 'Male' (length=4)
      'study' => string 'study 2' (length=7)
      'prescription' => string 'script 4' (length=8)
  4 =>
    array
      'account_num' => string '2' (length=1)
      'icd9_code' => string '2' (length=1)
      'dob' => string '11-11-1958' (length=10)
      'sex' => string 'Female' (length=6)
      'study' => string 'study 2' (length=7)
      'prescription' => string 'script 1' (length=8)
  5 =>
    array
      'account_num' => string '2' (length=1)
      'icd9_code' => string '2' (length=1)
      'dob' => string '11-11-1958' (length=10)
      'sex' => string 'Female' (length=6)
      'study' => string 'study 2' (length=7)
      'prescription' => string 'script 3' (length=8)
  6 =>
    array
      'account_num' => string '2' (length=1)
      'icd9_code' => string '2' (length=1)
      'dob' => string '11-11-1958' (length=10)
      'sex' => string 'Female' (length=6)
      'study' => string 'study 2' (length=7)
      'prescription' => string 'script 4' (length=8)
  7 =>
    array
      'account_num' => string '3' (length=1)
      'icd9_code' => string '3' (length=1)
      'dob' => string '03-11-1958' (length=10)
      'sex' => string 'Female' (length=6)
      'study' => string 'study 2' (length=7)
      'prescription' => string 'script 3' (length=8)
  8 =>
    array
      'account_num' => string '3' (length=1)
      'icd9_code' => string '3' (length=1)
      'dob' => string '03-11-1958' (length=10)
      'sex' => string 'Female' (length=6)
      'study' => string 'study 2' (length=7)
      'prescription' => string 'script 4' (length=8)



As you can see most of the information is repeated. How would I loop thru each array and consolidate the data so i could output it as follows

account num 1
icd9 code 1
dob 12-12-1955
sex Male
study study 2
prescriptions script 1, script 2, script 3, script 4

account num 2
icd9 code 2
dob 11-11-1958Femsex Male
study study 2
prescriptions script 1, script 3, script 4

and so on.

I tried using array_unique but all I cant figure out how to consolidate the data.

Hi!
I need a "very simple" PHP script which can compress a directory and all its multi-(infinite)level sub-directories using with .tar and .gz
I have tried many complex scripts so far which don't work as most of them use ZIP and I don't have access to ZIP
And a few of the simple ones, just don't function.

Please help!

Thank you !

- Xeirus.

Instead of breaking down and actually learning how to use ajax, I'm thinking about trying to do something so I don't need a page refresh every time, and the filtered data is nearly instant. I just use the session array var, and build a new array from the rows that meet the conditions.

I'm thinking of loading a two dimensional array into a session var, then use some input buttons, and use the post vars to filter the array based on a set of predefined conditions. ie status = 0, status = 1. It's a fairly small number of conditions applied to two different fields.

So, I need to access specific fields within a row, and essentially create a new array either including or excluding that row depending on whether it met the condition.

I'm struggling on several parts.
1. not sure how to build the array so that I can access specific fields, then not sure how to access those fields.
Do I do this..... to build the array? ....
Code: [Select]
while($row = mysql_fetch_assoc($result)){
   $array[] = array($row['field1'], $row['field2']);
}


I was thinking about using a foreach and is_array() to get to each row...
Code: [Select]
foreach($array as $key => $value){
   if(is_array){
      foreach($value as $k => $v){
         if($v[0] == 1){  //stuck here $v[0] is not a field, it's the first char of the string. not sure how to access a field
            $new_array[] = $value;  //stuck here. I need to put the whole row back into the array if the condition was true. seems like I would have to use the field selectors and rebuild the array.
         }
      }
  }

}


What would you do? Open to any ideas.

Hi there,

i have a problem regarding a editor that I am building, I am fairly new to php, but this is what i have so far:

Code: [Select]
<?php

$dirname = ".";
$dir = opendir($dirname);
?>
<form action="editor.php" method="POST">
<select>
<?php
while(false != ($file = readdir($dir)))
if (strpos($file, '.php',1)||strpos($file, '.html',1)||strpos($file, '.css',1) ) { 
{
if(($file != ".") and ($file != ".."))
{
echo("<option><a href='$file'>$file</a></option>");
}
}}
?>
</select>
<input type="submit" value="Submit" />
</form>

<br />
<center>
<form >
<textarea rows="80" cols="130">
<?php include $_POST["$file"]; ?>

</textarea>

</center>

The code produces a drop down list of any html, php or css files in the current directory and I want it to be able to show the selected file from the drop down list in the textarea so that I can edit it, I also am not sure how to save the file, would this be a file write method?

any help would really be appreciated as I've been stuck on this issue for hours an its doing my nut in!!!

Thanks
SF

I have two questions, I was wondering what would be the best method to go about building client side API functions on top of a already built API eg. http://docs.whmcs.com/API:Functions We would like to provide our clients access to API functions related to their accounts without giving them access to the whole Admin API where they can see a lot of our other client information.   The other question we have an API built using Basic HTTP Auth for API authenication (HTTPS). eg curl username:password http://api.etc.com) If so what would be the best way to secure this method?       Thank you