PHP - Dynamicly Create N-dimensional Arrays?

Hello, I've been struggling to get array_multisort to work...   If I have this array output... I'd like to sort on the product sub-array.   The array is called orders and that number 15 is the specific order id.

Array
(
    [15] => Array
        (
            [clientId] => 1
            [clientName] => Bob
            [o_date] => 2014-01-02
            [o_number] => 1 july-append
            [o_notes] => order on 1 july-append
            [i_date] => 2014-01-17
            [i_number] => 18072014-append
            [i_notes] => invoiced on 18 july 14 -append
            [products] => Array
                (
                    [0] => Array
                        (
                            [id] => 37
                            [prod_id] => 1
                            [product] => door
                            [qty] => 2
                            [cost] => 12.121
                        )

                    [1] => Array
                        (
                            [id] => 38
                            [prod_id] => 2
                            [product] => window
                            [qty] => 3
                            [cost] => 22.5
                        )

                    [2] => Array
                        (
                            [id] => 36
                            [prod_id] => 3
                            [product] => chair
                            [qty] => 1
                            [cost] => 300
                        )

                )

        )

)

So, I've tried a number of variations of this...

array_multisort($orders[$theOrder]['products'], SORT_DESC, SORT_NUMERIC, $orders[$theOrder]['products'], SORT_ASC, SORT_STRING);

array_multisort($orders[$theOrder]['products']['id'], SORT_DESC, SORT_NUMERIC);

etc. etc.
  - but I seem to get no-where. Can some-one kindly point out my error, please?   Thank you.

This has been so much FUN  for me that I couldn't wait to share!

I have a page on a Wordpress site using some special functions in the Theme I am running that displays custom fields in a List after a Form has been filled out for a Particular Post Category.

On this page the User can see the results of the Form they just filled out and review them before finally submitting them.

I have one function which gathers all of the Custom fields associated with that particular post they have made from the "holding table"--an interim saving instead of keeping them all in a session value exclusively.

The form they have just filled out produces one string or value per field EXCEPT in the case of multi-value checkboxes.

If on this review page any values are gathered whose $field_type is equal to 'checkbox' then it is guaranteed that those values are stored in an array.  Right now the problem is that the existing function that gathers and displays all these custom fields simply shows "Array" everytime it handles the values of one of these checkboxes.

In those cases where a row's $field_type = 'checkbox' then in every case there will be an associative array stored in brackets [] that I want when detected to be put into visible list of however many values are found.

In the sql statement when it gathers the field $field_type values it will find either "text", "dropdown", "textarea", or "checkbox" in the same id row along with the $field_label, $field_name, $field_values for each record.


I want to build more conditions and actions here to handle a situation where it runs into an associative array inside the first array of all of the custom fields.


I include the whole function I want to modify further down:
It starts out --
        echo cp_formbuilder_review($results);

and I guess I want something along the lines of--

if($results) {foreach ($results as $result)
if (is_array($result) { loop through and put individual array elements in an unordered list with the $field_label associated with each checkbox array}

else { continue the loop for all other types of custom fields which are not $field_type=checkbox because all of these custom fields will have values in just one string or one value}

For testing purposes, so you know what the values look like underlying this page if I use this statement on the page

    echo '<br/><br/>("$postvals")-- $postvals PRINT<br/>';
    print_r;

I will get back this for $_POST

    echo '$_POST PRINT<br/>just the post and nothing more';
    print_r($_POST);
( [post_title] => Stunning rental [cp_checkbox_days] => Array ( => Thursday [1] => Friday ) [cp_checkbox_amenities] => Array ( => Gardener [1] => Watchman ) [cp_checkbox_hello] => Array ( => Smoking Allowed: Outdoor areas only ) [cp_price] => 98888 [cp_street] => 888 Flange [cp_city] => Reynaldo [cp_state] => Virginia [cp_country] => Antartica [cp_zipcode] => 1080 [tags_input] => stunner [post_content] => Wow is all we can say about this one.
Right now the visual display shows this for Arrays
<ul>

                    
        <li><label><strong>Category:</strong></label>
        <div id="review">Affordable Rentals</div>
            <div class="clr"></div>
        </li>

    
        <li>
            <label><strong>Title:</strong></label>

            <div id="review">Stunning stunner</div>
            <div class="clr"></div>
        </li>

    
        <li>
            <label><strong>help checkbox:</strong></label>
            <div id="review">Array</div>
            <div class="clr"></div>

        </li>

    
        <li>
            <label><strong>Staff Provided:</strong></label>
            <div id="review">Array</div>
            <div class="clr"></div>
        </li>

    
        <li>

            <label><strong>Suitability:</strong></label>
            <div id="review">Array</div>
            <div class="clr"></div>
        </li>

    
        <li>
            <label><strong>Price:</strong></label>
            <div id="review">98888</div>

            <div class="clr"></div>
        </li>

    
        <li>
            <label><strong>Street:</strong></label>
            <div id="review">888 Flange</div>
            <div class="clr"></div>
        </li>
</ul>



So, wherever a value shows up like this [cp_checkbox_days] => Array ( => Thursday [1] => Friday )  I need for this array to be iterated and broken up into <li>Thursday</li> <li>Friday</li>


HERE IS THE CODE MORSEL that is UNDERPERFORMING!

I am hoping a genius like DavidAM can soup this thing up!





function cp_show_review($postvals) {
    global $wpdb;


    // if there's no form id it must mean the default form is being used so let's go grab those fields
    if(!($postvals['fid'])) {
        // use this if there's no custom form being used and give us the default form
        $sql = $wpdb->prepare("SELECT field_label, field_name, field_type, field_values, field_req "
             . "FROM ". $wpdb->prefix . "cp_ad_fields "
             . "WHERE field_core = '1' "
             . "ORDER BY field_id asc");

    } else {
        // now we should have the formid so show the form layout based on the category selected
        $sql = $wpdb->prepare("SELECT f.field_label,f.field_name,f.field_type,f.field_values,f.field_perm,m.meta_id,m.field_pos,m.field_req,m.form_id "
             . "FROM ". $wpdb->prefix . "cp_ad_fields f "
             . "INNER JOIN ". $wpdb->prefix . "cp_ad_meta m "
             . "ON f.field_id = m.field_id "
             . "WHERE m.form_id = '". $postvals['fid'] ."'"
             . "ORDER BY m.field_pos asc");
    }


    $results = $wpdb->get_results($sql);

    if($results) {

        // loop through the custom form fields and display them
        echo cp_formbuilder_review($results);

   //from here is where I have to switch to detecting the Arrays associated with checkboxes and explode them and loop them separately into something pretty with its own field_label   
//and when it has looped through all the Arrays and made them visible it continues looping through the rest of the single value strings and fields

    } else {

        echo sprintf(__('ERROR: The form template for form ID %s does not exist or the session variable is empty.', 'cp'), $postvals['fid'] . "\n\n");
    }
    ?>

Looks pretty darn easy doesn't it??

Hello!   First of all, I'm new here. I've been working with PHP for a few months and am really enjoying its capabilities   A little background on the project I'm doing at the mo, I'm creating a small dashboard for grabbing Twitter stats via the API. The result will eventually output in a pretty table showing the daily followers, follower gains (or losses) etc. Here's an example of the table I eventually want to end up with.   So far I have two arrays of data:   $accounts_data is a list of all account names and their associated ID's $followers_data is a list of all follower counts, for a specific time of day, with an associated account ID (which matches the ID found in $accounts_data, thus pairing the follower count to a specific account)   I'm now trying to combine these two arrays into something more sensible that can then be used to output the table as shown in the link above.   $accounts_data:

array(4) {
  [0]=> array(2) {
    ["id"]=> string(4) "1279"
    ["name"]=> string(13) "AccountName1"
  }
  [1]=> array(2) {
    ["id"]=> string(4) "1280"
    ["name"]=> string(10) "AccountName2"
  }
  [2]=> array(2) {
    ["id"]=> string(4) "1281"
    ["name"]=> string(12) "AccountName3"
  }
  [3]=> array(2) {
    ["id"]=> string(4) "1283"
    ["name"]=> string(11) "AccountName4"
  }
}

$followers_data (truncated this data)  

array(12) {
  [0]=>
  array(3) {
    ["account_id"]=> string(4) "1279"
    ["date_time"]=> string(19) "2014-11-14 09:00:03"
    ["followers"]=> string(4) "1567"
  }
  [1]=>
  array(3) {
    ["account_id"]=> string(4) "1280"
    ["date_time"]=> string(19) "2014-11-14 09:00:29"
    ["followers"]=> string(4) "7688"
  }
  [4]=>
  array(3) {
    ["account_id"]=>
    string(4) "1279"
    ["date_time"]=>
    string(19) "2014-11-14 16:30:35"
    ["followers"]=>
    string(4) "1566"
  }
}

Hello, here is the PHP situation I'm in. I'll type it out in pseudo-ish code first.

<?php
            $multi_array = array(
                 array("cats", "dogs", "sheep", "walruses"),
                 array("jazz", "larva", "pencils", "derp"),
                 array("to", "much")
            );
            $string = array("the", "cats", "ate", "too", "many", "pencils");
            $count = count($string);
            for($i = 0; $i < $count; ++$i) {
                  if($string[$i] IN ARRAY $multi_array) {
                            THEN replace $string[$i] with a random word in the sub array of the multi-array
                             for example, if $string[$i] is cat, then it would replace it with any of the words in the sub array of multi-array, so it could be "cats", "dogs", "sheep", or "walruses"
                  }
           }
?>



I have no idea how to do this and tried thinking of ways for an hour and a half. 

Hello,

I hope someone can help me with this as I really cant seem to get it to work!

I am wanting to create a navigation menu from data on a SQL database table, I know how I need to present the data to create the menu but I can not get it to work.

Here is an example of what I need:

//get the top menu
$sql = "SELECT name, link FROM menu WHERE category = 'none'";
$result = mysql_query($sql,$conn);
while($row=mysql_fetch_assoc($result))
{
  $topmenu[] = $row['name'];
}

//go through the top menu names
foreach($topmenu as $top)
{
       //echo the current top meny name
echo $top."<br />\n";

//get menu name and link if it matched the current top menu name
$sql = "SELECT name, link FROM menu WHERE category = ".$top."";
$result2 = mysql_query($sql,$conn);
while($row2=mysql_fetch_assoc($result2))
{
                //show the menu name and link
echo $row2['name']."<br />\n";
echo $row2['link']."<br />\n";
}
     
        //create space between top menu names
        echo "<br /><br />";
}

This was my first attempt which did not work at all but since then I have tried multiple things such as putting all the data into multiple arrays, in to one array etc but I couldnt get anything to produce the result that I need.

what I am hoping to produce is something like:

Home
Information
    Info1
    Info2
    Info3
About us
    About us1
    About us1
etc
etc

Once I can produce the data in this way I can then add the html, css etc to create the menu.

I will be very greateful for any help and advice that you can provide.

Kind Regards
Ben

Here are the two arrays to compare.

Peopleskills            
PeopleID   SkillID
2          2   
2          7   
2          9
2              11
3          2
3                  12
3          14   
4          5
            
Equipskills            
EquipID   SkillID   
1                2          
1                9   
1               11   
2               5      
2               7      
2               9      
2               12   
2               13   
2               14   
3               2   
4               11      

The common link is SkillID.
Each EquipID has some required SkillIDs that people must have to operate that machine.
As long as a PeopleID has the required SkillIDs from the EquipSkills, that person has permission to that machine.
This will be used create a third array.
It will look something like the following.

                          EquipIDs
                      1     2     3     4     5     6     7     8      9      10       11     12
PeopleIDs   
2                    x     x
3                           x
4
5

What might be the best way to code this?

In case you guys don't know what lisp is, tl;dr is that is an old language without syntax that uses polish notation and parentheses to represent all language constructs. You can also create your own language constructs. For example, this mysql statement :

UPDATE table_name SET column1=value1,column2=value2 WHERE some_column=some_value

Can be represented as

 (update "table_name" (set ('column1 "value1") ('column2 "value2") (where (= some_column "some_value")))

One advantage of this whole thing is that you don't have to mix multiple languages to create a site. When you program in php, you actually use html, css, php and MySQL. When you program in lisp, you only use lisp. Another advantage is that the language with no syntax is easier to programaticaly generate than one with it. I can auto generate various sql statements as lisp trees. The disadvantage is that lisp is obscure as hell and no one uses it.
 
So I was thinking of using php arrays to get some of that expressiveness of lisp in PHP and to abstract away necessity to glue together sql strings. So far it has been mixed results. One way to represent update is this

 ["update", "table_name", ["column1" => "value1", "column2" => "value2"], ["where", [ "=", "some_column", "some_value"]]]

I represent columns to be updated as key=>value pairs since column names are unique anyway. One advantage of this method is that I don't have to use mysql_real_escape_string on variables for updating. My interpreter automatically escapes everything inside SET bracket and adds quotes to values. This is however, less than practical in its WHERE part. That's because it is less clear what part you can and can't escape, since column names, functions and values can all be mixed up in WHERE part, and arrays are not nearly as flexible as s-expressions.
 
Anyone has any idea how best to do this?
Edited by Goat, 24 July 2014 - 02:46 PM.

Ok i am stuck, i created a php script that draws data from a mysql dB into a php page. How can I send the page as the body in email? I do not need to preview the page, but can send it without ever viewing if that helps. When I put my code into a variable it does nothing. Is it caching? Should I load the results into mysql then send?please advise..

Hi.

We have a Joomla Site with a SMF forum (Simple Machine Forum). And with php, we load the 10 recent topics in a module in Joomla.
So when someone click the URLs from the 10 recent topics clicked, we hope that those URLs will open in the "wrapper" in Joomla
The "wrapper" constantly have this URL:
http://localhost/~2ms/FFS-VPS/index.php?option=com_wrapper&view=wrapper&Itemid=148
The URLs of the recent topics are always changing (dynamicly).

In a php file called "recentTopics.php" we have this php:
<?php require("/Users/2ms/Sites/FFS-VPS/latin1/SSI.php"); ?> 
<?php ssi_recentTopics(10); ?>
The first php script  points to the SSI.php file in the SMF directory and the second pic up the 10 recent topics and shows those in a module pointing to the "recentTopics.php file in Joomla.

Hope someone can help.

toloekka 

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. 

 

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!

Hiya peeps!

Here are my scripts;

test.php

<?php
include 'formValidation.php';
$new = new formValidation(
array(
array(
'formname' => 'firstname',
'value' => 'james',
'options' => 'required, alllowercase, onlyletters',
'name' => 'First Name'
),
array(
'formname' => 'password',
'value' => 'blahblah',
'options' => 'required, oneuppercase, alphanumerical',
'name' => 'Password'
),
array(
'formname' => 'username',
'value' => 'blahblah',
'options' => 'required, oneuppercase, alphanumerical',
'name' => 'Username'
)
)
);
?>


formValidation.php

<?php
class formValidation {

private $inputs;

function __construct($inputs = array()) {
foreach($inputs as $input_key => $input_value) {
foreach($input_value as $key => $value) {
echo $value . '<br />';
}
}
}

public function __prep($formname, $options, $value, $name) {

echo $formname . ' ' . $options . ' ' . $value . ' ' . $name . '<br />';

}
}
?>


This outputs;


firstname
james
required, alllowercase, onlyletters
First Name
password
blahblah
required, oneuppercase, alphanumerical
Password
username
blahblah
required, oneuppercase, alphanumerical
Username


But what i need to do is for every four values I need them to be sent to the __prep function. EG;


$this->__prep('firstname', 'required, alllowercase, onlyletters', 'james', 'First Name');


I have no idea how to do this tho, I have tried a for() loop, another foreach loop, array the first four values then foreaching them again. I'm stuck, someone please help!

Many thanks,

James.

hello freaks,   I have a four-element array, which is the result of a mysql query. The array is like below. (This is of course just a snippet to show the structure; the hours of course go up to 24, then repeat; there are about ten days' worth of data.)       Array
(
[dayname] => day1
[hour] => 1
[widtype] => type1
[Output] => 20
)
Array
(
[dayname] => day1
[hour] => 2
[widtype] => type1
[Output] => 9
)
Array
(
[dayname] => day1
[hour] => 1
[widtype] => type2
[Output] => 450
)
Array
(
[dayname] => day1
[hour] => 2
[widtype] => type2
[Output] => 650
)  I want to loop through this data and output each hour's data in a separate line, like below (I included the headings just for clarity):     Day Hour Type1_total Type2_total day1 1 20 450 day1 2 9 650     ... and can't seem to make this happen. Here's the code I've written:

		$prevday = '';
		while ( $row = mysql_fetch_assoc($result))
	{	
		extract($row);
		$currentday = $row['dayname'];
		$currenthour = $row['hour'];
		$currentwid = $row['widtype'];
		while($currentday !== $prevday){
		 for($currenthour = 1; $currenthour <=24; $currenthour++){
					
		if($row['widtype'] == 'type1'){	$type1_total = $row['Output'];}
		if($row['fuel'] == 'type2'){$type2_total = $row['Output'];}
			print "<pre>";
			echo "$currentday, $currenthour, $type1_total, $type2_total";
			print "</pre>";
					}
		$prevday = $currentday;
			}
			}

... and here's what it outputs:   day1, 1, 20, ,
day1, 2, 20, ,   Clearly I have written this loop wrong but have banged my head against it for a while and wonder if it's just not possible to do what I want.   Any suggestions would be hugely appreciated!

Hi,

I have a question: I have a CSV file where the first row are the names of the columns. The format of the CSV file is:

Name   |   Surname    | Adress      | Date of birth
Robert |    Miller          |   Athome 1|    29. Februar 1976
.
.
.

How should I import the CSV.

Thanks in advance.

I have been trying to solve this problem for a few days now and can't seem to work it out. I'm sure i'm missing some simple point..
I am using a mysql PDO fetch to return 2 fields in each row and then put them into an array of their own:
foreach ($st->fetchAll() as $row){
$subs[] = array($row['subscriber'],$row['plant']);
Some of the rows share the same $row[0], which is the 'subscriber' field. What I want to do is make up another array with each smaller array having a single, unique $row[0] and any number of added 'plant' fields following (e.g $row[1],$row[2] etc).
I've tried all sorts of ways to achieve this but am at a loss. Would someone be able to point me in the right direction ? Thanks.