Learn VBA & Macros in 1 Week!

PHP - Create A 2d Array From 2 Single D Array

Full Excel VBA Course - Beginner to Expert

Create A 2d Array From 2 Single D Array	View Content

Hello
can anyone help me out with code to create a 2 dimension array from 2 single dimension array. for example
$path = array('base', 'category', 'subcategory', 'item');
$location=array('india','USA','UK','RUSSIA',);
now i need to have a @D array which have the following structure
$final[0]=array('base','india');
$final[1]=array('category','USA');
$final[2]=array('subcategory','UK');
$final[3]=array('item','RUSSIA');

Full Excel VBA Course - Beginner to Expert

Creating Multidimesional Array Out Of Single Array

Similar Tutorials

View Content

I am retrieving values in form of array from a database table and out of the I have to build multidimensional array depending upon the parent->child relationship in the same array.
The result is as

=> Array
(
=> Array
(
[label] => Shirt
[uri] => #
)

[1] => Array
(
[label] => Jeans
[uri] => #
)

[2] => Array
(
[label] => Lowers
[uri] => #
)

[3] => Array
(
[label] => T-Shirts
[uri] => #
)

[4] => Array
(
[label] => cotton shirt
[uri] => #
)

[5] => Array
(
[label] => Trousers
[uri] => #
)

)
each is related to some parent-id.
Can any body me any idea.

Php Create An Array Map / Matrix Using Existing Array Of Numbers With Rules / Conditions

Similar Tutorials

View Content

NOTE - Please read the information first as it contains important information to understand the problem.

Rules →

• There are 9 Columns(C1,C2,C3,C4,C5,C6,C7,C8,C9) [ Max columns will be 9]

• The number of Rows can vary from 3,6,9,12,15,18 (Max). In this case Number of Rows shall be 12

Number of Rows = No of Tickets (Max Allowed 6) x Rows Per Ticket (Max Allowed 3). Thus, Max Rows can be 18

• Each Row is required to have 4 Blank Spaces and 5 Filled with Numbers

• All numbers available in the Column Array have to be utilized

• This configuration of an shall create a matrix of 9 Columns & 12 Rows (3 x 4 Tickets), which is 108 MATRIX BLOCKS where only a maximum of 60 numbers can be filled out of 108 available blocksrandomly with the above conditions being met 100%.

• The numbers in column must be arranged / sorted in ASCENDING ORDER (For coding logic purpose, as soon as the number is assigned to the new MATRIX MAP use array_shift() or unset() the number so as to avoid repetition

Example - Row 1 and Column 1 shall generate a MATRIX BLOCK - R1C1

Row 3 and Column 7 shall generate a MATRIX BLOCK - R3C7

Matrix Block can also be termed as Matrix Cell for your ease (if needed)

MASTER SET OF ARRAY WITH NUMBERS

array( "C1"=> array( 1, 2, 3, 5, 6, 7, 9 ), //7 Numbers "C2"=> array( 13, 14, 15, 17, 18, 19 ), //6 Numbers "C3"=> array( 21, 22, 23, 24, 25, 26, 30 ), //7 Numbers "C4"=> array( 31, 33, 34, 36, 37, 38, 39 ), //7 Numbers "C5"=> array( 41, 42, 46, 47, 48, 49, 50 ), //7 Numbers "C6"=> array( 51, 52, 53, 54, 55, 57, 58 ), //7 Numbers "C7"=> array( 61, 62, 64, 65, 69, 70 ), //6 Numbers "C8"=> array( 71, 74, 75, 76, 77, 78 ), //6 Numbers "C9"=> array( 82, 83, 85, 87, 88, 89, 90 ) //7 Numbers );

The above array has 60 Numbers to be filled out of 108 MATRIX BLOCK / CELL which meets the condition that for a FULL BLOCK containing 4 MINI BLOCKS WITH 3 ROWS (max. allowed) EACH

I have been able to generate this without any issue meeting all the conditions of the Columns

My Allocation Matrix Array will look like

array( "R1"=> array( "C1"=> true, // Means that MATRIX BLOCK R1C1 will be NOT EMPTY "C2"=> false, // Means that MATRIX BLOCK R1C2 will be EMPTY "C3"=> true, "C4"=> false, "C5"=> true, "C6"=> false, "C7"=> true, "C8"=> true, "C9"=> false ), "R2"=> array( "C1"=> false, "C2"=> true, "C3"=> false, "C4"=> true, "C5"=> false, "C6"=> true, "C7"=> true, "C8"=> true, "C9"=> false ), "R3"=> array( "C1"=> true, "C2"=> true, "C3"=> true, "C4"=> true, "C5"=> false, "C6"=> false, "C7"=> false, "C8"=> false, "C9"=> true ), "R4"=> array( "C1"=> true, "C2"=> true, "C3"=> true, "C4"=> false, "C5"=> true, "C6"=> true, "C7"=> false, "C8"=> false, "C9"=> false ), "R5"=> array( "C1"=> false, "C2"=> false, "C3"=> false, "C4"=> false, "C5"=> true, "C6"=> true, "C7"=> true, "C8"=> true, "C9"=> true ), "R6"=> array( "C1"=> true, "C2"=> true, "C3"=> false, "C4"=> true, "C5"=> false, "C6"=> true, "C7"=> false, "C8"=> false, "C9"=> true ), "R7"=> array( "C1"=> false, "C2"=> false, "C3"=> true, "C4"=> false, "C5"=> true, "C6"=> false, "C7"=> true, "C8"=> true, "C9"=> true ), "R8"=> array( "C1"=> true, "C2"=> false, "C3"=> false, "C4"=> true, "C5"=> false, "C6"=> false, "C7"=> true, "C8"=> true, "C9"=> true ), "R9"=> array( "C1"=> true, "C2"=> false, "C3"=> true, "C4"=> false, "C5"=> true, "C6"=> true, "C7"=> false, "C8"=> false, "C9"=> true ), "R10"=> array( "C1"=> false, "C2"=> true, "C3"=> true, "C4"=> true, "C5"=> true, "C6"=> false, "C7"=> true, "C8"=> false, "C9"=> false ), "R11"=> array( "C1"=> false, "C2"=> true, "C3"=> false, "C4"=> true, "C5"=> true, "C6"=> true, "C7"=> false, "C8"=> true, "C9"=> false ), "R12"=> array( "C1"=> true, "C2"=> false, "C3"=> true, "C4"=> true, "C5"=> false, "C6"=> true, "C7"=> false, "C8"=> false, "C9"=> true ) );

In the above array R stands for Row, C for Column, TRUE/FALSE (Boolean) means that if TRUE a Number can be filled in the resulting MATRIX BLOCK / CELL ( Row[Number]Column[Number] ) else if FALSE the MATRIX BLOCK / CELL shall be EMPTY

The result for the above shall be

PROBLEM :

I am unable to understand what should possibly be the logic & loop used here for creating a MATRIX ALLOCATION MAP as shown above

I have tried while, foreach & for but unable determine the perfect combination which would meet the conditions.

(Tried all of the above with Nested Loops also)

Edited May 1, 2020 by AlphaMike
Tags

Create An Array Based On Array Key

Similar Tutorials

View Content

Hi,

I am working on a betting API, The data comes from an XML Feed.

I am using a PHPPhar file to iterate the XML data, Seems to work really well. What I need to do now is iterate each "outcome" type and order it by the highest decimal to lowest decimal value (Best odds)

My current array of data from the XML looks like this (See pastebin for full version) :

Is it possible build an array of outcomes, Then sort by the best decimal price. (I have a function built that can convert the "currentPrice" to decimal. Thnak You!

Trouble Getting Single Value From Array

Similar Tutorials

View Content

Hi, learning as I go here, and I appreciate the help in advance ..

I have some working php code that retrieves sql results using php. I assign the resutls to an array by doing this

$bobreport = array();
while ($row=db2_fetch_array($querystmt)) {
array_push($bobreport, $row);
}

i can then write the rows of returned data after some column headers using this...

foreach ($bobreport as $value) {

echo "<tr><td>$value[0]</td><td>$value[1] .....

}

The particular report I'm working on now has a redundant date and time in every row that I omit in the foreach loop because I just want to show it once above the table somewhere. This doesn't seem to work in accomplishing that...

echo "This data was updated ".$bobreport[0][9]." at ".$bobreport[0][10] ;

All I seem to get in the report is "This data was updated at".

Please help.

Need Help To Assign An Array To A Single Value

Similar Tutorials

View Content

hey everyone

will you please assist.

I'm getting data from a mysql database.

And I want to assign the data to a single value, if possible

For example, in my database I have 2 columns, name and group

Lets say John, Peter and Cathy belongs to group 555, where Sally and Marcus belongs to group 777.

So my sql query outputs all users in group 555

Is there a way to assign the search result to a vlue, for example $result = ???

and If I said echo $result, it should show the users who belongs to group 555 as an example.

I tried to use row[Name][1]; but it doesnt work.

The thing is, I can display the data the way I am familiar with, but I'm sending an automated email to myself, containing the users. So if I would used a for each statement, the mail will trigger and send a copy for every count, in this case, 3 times. And thats my huge problem.

The mail must trigger only once, containing the users in my search query, in this case, group 555.

Any help will be appreciated

Thank you

How To Output A Single Value From An Associative Array, Given The Key

Similar Tutorials

View Content

I came up with this but it outputs the value 3 times... (because there are 3 variables)

ie mathsmathsmaths

How do I fix this or do it the correct way? Thanks

Code: [Select]
$subject = "maths";
$phone = "1235";
$colour = "red";
$all_vars = compact("subject", "phone", "colour");

get_value($subject);

function get_value($variable){
global $all_vars;
foreach($all_vars as $key=>$value){
if ($key = $variable) {
echo $key;
}
}
}

Returning A Single Error From An Array

Similar Tutorials

View Content

Hi Guys,

I have 6 file upload fileds in an array. When i try to return the error messages at this link: http://www.php.net/manual/en/features.file-upload.errors.php i get an error displayed for every upload box. I was wondering if it is possible to simply return 1 error instead of the 6? For example rather than getting "No File Uploaded No File Uploaded No File Uploaded No File Uploaded No File Uploaded No File Uploaded" i simply get "No File Uploaded". Also If only some files are uploaded no error should be displayed.

The code i am using is:

foreach ($_FILES['image']['error'] as $key => $error)

{

if ($error == UPLOAD_ERR_NO_FILE)

{

echo "No File Uploaded";

}

I have tried using "break;" which works in leaving only 1 error, however the error is still displayed if less than 6 files are uploaded.

All help greatly appreciated.

Thanks

Pdo Returning Single String Not Associative Array.

Similar Tutorials

View Content

Hi guys,
I am using this oAuth library https://github.com/elbunce/oauth2-php
But more specifically these lines of code:

protected function getToken($token, $isRefresh = true) {
try {
$tableName = $isRefresh ? self::TABLE_REFRESH : self::TABLE_TOKENS;
$tokenName = $isRefresh ? 'refresh_token' : 'oauth_token';

$sql = "SELECT $tokenName, client_id, expires, scope, user_id FROM $tableName WHERE token = :token";
$stmt = $this->db->prepare($sql);
$stmt->bindParam(':token', $token, PDO::PARAM_STR);
$stmt->execute();

$result = $stmt->fetch(PDO::FETCH_ASSOC);

return $result !== FALSE ? $result : NULL;
} catch (PDOException $e) {
$this->handleException($e);
}
}

However, this is retuning no value.
If I modify the code to be:

protected function getToken($token, $isRefresh = true) {
return $token;
}

It returns the $token value, so the $token is definitely being passed to the function.

The code should return an associative array: i.e., $token["expires"], $token["client_id"], $token["userd_id"], $token["scope"], etc
Also $token should not === NULL.

PS. I run a few checks on

$tableName = $isRefresh ? self::TABLE_REFRESH : self::TABLE_TOKENS;
$tokenName = $isRefresh ? 'refresh_token' : 'oauth_token';

And they are returning the correct values.

Which from my thinking narrows it down to:

$sql = "SELECT $tokenName, client_id, expires, scope, user_id FROM $tableName WHERE token = :token";
$stmt = $this->db->prepare($sql);
$stmt->bindParam(':token', $token, PDO::PARAM_STR);
$stmt->execute();

$result = $stmt->fetch(PDO::FETCH_ASSOC);

return $result !== FALSE ? $result : NULL;

Any and all help is greatly appreciated.

Thanks in advance.

Converting Strings From Foreach Into A Single Array

Similar Tutorials

View Content

Hi all, I am using foreach statement to gather records and program levenshtein to detect any misspellings and suggesting the correct words. The thing is i am unable to convert all those strings into a single array. After trying to correct this issue so many times, i wonder if it is really possible to convert strings into a single array? Any input is welcome

Updating A Single Row From Within A Array Result Of 10 Items

Similar Tutorials

View Content

Quote from: Hollows on August 20, 2010, 11:29:25 AM

I have an array that is pulling 10 results from a db like this -

<?php
$result = mysql_query("SELECT * FROM inbox ORDER BY id DESC LIMIT 0,10");
while ($row = mysql_fetch_array($result)) {

<div class="<?php echo $row['class']; ?>">
<?php
echo $row['name'];
echo $row['message'];
?>
</div>

basically 'class' is defined in an earlyier part of the script and is used to tell the css what class to display - as I'm sure you can see.

What I'd like todo then be able to update the class of a message once I have read it, so update the class table with something like 'read' so the css will then be based on .read not what ever was set by the form, either using a link or form button inside each of the 10 results from the array.

I've managed to update one by using -
Code: [Select]
mysql_query("UPDATE shoutbox SET class = 'read' WHERE id = ''XX"); // XX should be row id

But I had to set that myself and point the id to the row id I wanted to change - How can I have that already populated with the row for the id that triggered it?

To be clear so it looks like -

Name
Message
read button
_____________
Name
Message
read button
_____________
Name
Message
read button
_____________

and so on...

Would I be better going by check boxes and one submit button? If so how could I implement that?

I can provide the full code I've written if it helps

Thank you in advance

Store Multiple Selection From Pagination Info Into Single Array

Similar Tutorials

View Content

Hi

I have a results page from a MySQL query and I have implemented pagination to present data in chunks of 25 per page in a table view (each row => 1 entry).

My problem is that next to each data row, I have a selection checkbox, and if the user clicks on it, he can download the selected entries. This thing worked OK before I employed paginated view, when I presented all data in one page. Now, if I select e.g. 2 entries in page 1, then I jump to page 12 and select another 2 entries, if I click on the "Retrieve" button, I get only the last 2 entries (from the last page visited).

How can I solve this problem? With JS? Can I use PHP only?

Create Array Key From Value

Similar Tutorials

View Content

Hi, Here is simple question.

I have this array:
array([0]=>name [1]=>Tony);
How can i change into
array(name=>Tony);
?

Thank you,
ayok

Create Array With Offset?

Similar Tutorials

View Content

First off, what are the names for the types of arrays?

What do you call an array that uses integers for the key?

I think when the key is text it is called an associative array?

Anyways...

Is there a way to create an array where they keys are integers, but you are defining the first entry?

I would like my array to either start with a "1" or maybe "1001".

How do I do that?

Create Array From Mysql

Similar Tutorials

View Content

i want to create array from mysql what is the script for this...?

value like
$data = array("1" => .0032, "2" => .0028, "3" => .0021, "4" => .0033,
"5" => .0034, "6" => .0031, "7" => .0036, "8" => .0027, "9" => .0024,
"10" => .0021, "11" => .0026, "12" => .0024, "13" => .0036,
"14" => .0028, "15" => .0025);

Using An Array To Create Database

Similar Tutorials

View Content

I was just wondering would it be possible to create a database from a input statement and array, if so would it be also possible to create a table with fields the same way?

Dynamically Create An Array - Help

Similar Tutorials

View Content

Friends,

I have a PHP script that populates a calendar based on an array as follows:

$days = array(2=>array('javascript:showWhatsOnText(2);','linked-day'),
3=>array('javascript:showWhatsOnText(3);','linked-day'),
4=>array('javascript:showWhatsOnText(4);','linked-day'));
echo generate_calendar(2011, 4, $days, 1, '#');

where, for instance, the 2, 3 4 are the days of the month,

By extracting a series values from a MySQL database how would I generate this array dynamically.
E.g I have startday, startmonth, name and text fields in the database and would need to loop through them all to create the array.

I tried playing around with something like this without any luck:

$queryCat1 = "SELECT * FROM $dbCalendarEvents ORDER BY id ASC"; // WHERE visible = '1'
         $result1 = mysql_query($queryCat1) or die (mysql_error());
         $num1 = mysql_num_rows($result1);
         $i=0;
         $daysArray = array();
         while ($i < $num1) {
            $startday=mysql_result($result1,$i,"startday");
            $startmonth=mysql_result($result1,$i,"startmonth");
            $name=mysql_result($result1,$i,"name");
            $name=mysql_result($result1,$i,"name");
            $copy=mysql_result($result1,$i,"copy");

            $daysArray[$i] = $startday=>array('/weblog/archive/2004/Jan/02','linked-day');

            $i++;
         }

Your help is appreciated.

Dynamically Create An Array

Similar Tutorials

View Content

I have a slideshow that I am having to modify for my needs. The data file uses an array and i need this to be dynamic. I need to loop through all images in a directory and create the array. I have the directory being stored in a variable already. Now i just need to loop though all images in that directory to create the array like you see in the below code. You can also see the directory variable at the top. Can someone give me a hand with this please?

Code: [Select]
<?php

echo $slideimagefolder; //http://localhost:82/images/groupphotos/1/1/

$slides = array(
// --- Start slide list ---

// slide elements
array(
"slidelink" => "http://www.frontpageslideshow.net",
"title" => "Frontpage Slideshow 1.7",
"category" => "About Frontpage Slideshow",
"tagline" => "Image taken from the movie \"Shoot 'em up\"",
"text" => "\"Frontpage SlideShow\" is the most eye-catching way to display your featured articles, stories or even products in your php based website or CMS, like Time.com, Joost.com or Yahoo! Movies do. \"Frontpage SlideShow\" creates an uber-cool slideshow with text snippets laying on top of images. These \"slides\" are being rotated one after the other with a nice fade effect. The slideshow features navigation and play/pause buttons, so the visitor has complete control over the slideshow's \"playback\"! And best of all, Frontpage Slideshow can be skinned!",
"slideimage" => "ao4.jpg"
),

// slide elements
array(
"slidelink" => "http://www.frontpageslideshow.net",
"title" => "Use Frontpage Slideshow on any PHP based site!",
"category" => "About Frontpage Slideshow",
"tagline" => "Image taken from the movie \"The Kingdom\"",
"text" => "JoomlaWorks has developed this modification of Frontpage Slideshow to work on every website that supports PHP as a minimum requirement. We call this modification the \"Static PHP\" version of Frontpage Slideshow. It's ideal for use on non-Joomla!/Mambo websites, like for example your corporate PHP based website or your Wordpress blog or Drupal website! You can obviously use this version on any CMS that is based on PHP!",
"slideimage" => "the_kingdom_20070820114258369.jpg"
),

// slide elements
array(
"slidelink" => "http://www.frontpageslideshow.net/content/view/14/37/",
"title" => "FPSS is Search Engine Friendly!",
"category" => "About Frontpage Slideshow",
"tagline" => "Image taken from the movie \"Invaders\"",
"text" => "Unlike Flash based slideshows, Frontpage Slideshow uses unobtrusive javascript and some CSS wizardry only. The content of the slides is laid out as html code, which means it can be \"read\" by search engines. The proper usage (and order) of h1, h2, p (and more) tags will make sure Google (or any other search engine) regularly \"scans\" your latest/featured items.",
"slideimage" => "TVD_TR_02183_2.jpg"
),

// slide elements (***TIP***: copy this data block and paste it below itself to add more slides)
array(
"slidelink" => "http://www.joomlaworks.gr",
"title" => "About JoomlaWorks",
"category" => "",
"tagline" => "Image taken from the movie \"Transformers\"",
"text" => "JoomlaWorks is a team of professional web designers and developers dedicated to delivering high-quality extensions and templates for Joomla! (the most popular open source Content Management System (CMS) worldwide) and Mambo (award winning CMS). JoomlaWorks has established a solid reputation in the Joomla! & Mambo communities, having developed some of the most popular and innovative free & commercial extensions & templates, since 2006.",
"slideimage" => "2007_transformers_014_1.jpg"
),

// --- End slide list ---
);

?>

Create A While Loop From An Array

Similar Tutorials

View Content

HI all,

I need help to get data out of an array using a while loop or something simalar.

What I have, is this:

<?php

$data = array(

1 => array(
"name" => "Jordan Smith",

"age" => "16 Years 0 Months"

),
2 => array(
"name" => "Olivia Smith",

"age" => "13 Years 12 Months"

)
);

Now, what I did, is I constructed this:

while($result=$data[1]) {
echo $result['name'];
}

But it echoed "Jordan Smith" for infinity down the page.

If anyone can help be do this, it will be great. Thanks

How To Create Multidimensional Array In Php

Similar Tutorials

View Content

how to create multidimensional array in php

Create And Add To An Array, Then Sort By A Key.

Similar Tutorials

View Content

Hello,

Im struggling with this, probably because of my lack of fundamental knowledge of arrays.

What i want to do is:
make an array with two keys. 'id' and 'distance'.

I want to sort the results by distance, displaying the id's...

im looking at ksort() as the solution, however i don't think im implementing it properly as i dont think i have set the array up properly!!

what i have is not good...

Code: [Select]
<?php
while ($row = mysql_fetch_array($result)) {
//get the photographers postcode and split it into 2 pieces
$p_postcode = explode(' ',$row['address_post_code']);
//get the photographers postcode and split it into 2 pieces
$u_postcode_a = explode(' ',$u_postcode);
//run the two postcodes throught the function to determin the deistance
$final_distance = return_distance($u_postcode_a[0], $p_postcode[0]);
//start the variable so we can add to it later on
$photographers_inrange = "";
//declare this variable to help with the comma spacing too EDIT LOOK TO LINE 46
//$i2 = 1;
$photographers_inrange = array();
//if the distance is smaller or equal to the distance the photographer covers
if($final_distance <= $row['cover_distance']){
//get their id
$photographers_inrange['id'] = $row['ID'].',';
$photographers_inrange['distance'] = ''.$final_distance;
//echo $photographers_inrange;
//EDIT: this method does not work when just one result is returned. now i use substr -1.
//if this isnt the last result
//if($i++ <= $i2++){
//then add a comma for the sql statement
//$photographers_inrange .= ',';
//}
}

ksort($photographers_inrange);
foreach ($photographers_inrange as $key => $val) {
echo "togs[" . $key . "] = " . $val . "<br/>";
}
?>
with $photographers_inrange being where it is, i am getting alot of empty arrays. not what i want.
i just need to know how to add to the original array, and how to then sort it.

thanks for your ongoing help!!