PHP - Changing Array Keys Using Another Array

hey guys im trying to result an array key and value if it has one...the code and results are below if anyone can help with this simple problem...thanks alot

Code: [Select]
<?php

$columns = array('news_id' => 'id', 'news');

foreach ($columns as $column => $column_alias)
{
echo $column . ' ' . $column_alias;
}
?>
the result im getting is:

news_id  id
0 news

but im just after the result of just result the column name and alias (if it has one)
so im looking for the result

news_id  id
news

I have an array of type
Code: [Select]
Array ( [2] => Array ( [name] => Shelby Baptist Medical Ctr [city] => Alabaster ) [1] => Array ( [name] => Andalusia Regional Hospital [city] => Andalusia ) [0] => Array ( [name] => Long Term Hospital of Anniston [city] => Anniston ))
How can sort the keys of an array but there content remains the same so that they are like
Code: [Select]
Array ( [0] => Array ( [name] => Shelby Baptist Medical Ctr [city] => Alabaster ) [1] => Array ( [name] => Andalusia Regional Hospital [city] => Andalusia ) [2] => Array ( [name] => Long Term Hospital of Anniston [city] => Anniston ))
Can someone please point me if there is any func. for this

is there a way to reset the array keys? to 0,1,2,3,...

also for example that i have something like this:

$array['dog']='dog';
$array['mouse']='mouse';
$array['cat']='cat';

and i want it like this:

$array[0]='dog';
$array[1]='mouse';
$array[2]='cat';

is there a function for that already in php?

Hello

I am having some trouble with array_keys

I have an array for which I want to return all the keys based on value X

This is my code:

Code: [Select]

$depth = array_keys(X', $Array);

echo print_r ($depth,1);



I have checked the content of my array $Array and it contains at least 1 instance of 'X' but I am getting nothing when I do the print_r

Any suggestions would be appreciated

Thanks

Hi ..
i have an array format like (mysql result array)
$new_array=Array ( [0] => Array ( [quantity] => 5 )  [1] => Array ( [quantity] => 25 )  [2] => Array ( [quantity] => 20 ) )

I have to convert this array into the following format
$new_array['quantity'][0]=5
$new_array['quantity'][1]=25
$new_array['quantity'][2]=20


How to convert this array format using any standard array method.

Say i have two arrays with custom keys. What would be the easiest way to write a function that would determine if all the keys in arrayOne are in arrayTwo? The example below would return false because keys 3 and 4 are missing in arrayTwo. Any help would be much appreciate. thanks!

Code: [Select]
<?php

$arrayOne['1'] = "adg";
$arrayOne['2'] = "a4g";
$arrayOne['3'] = "346";
$arrayOne['4'] = "etwe";

$arrayTwo['1'] = "xcb";
$arrayTwo['2'] = "acbr";
$arrayTwo['6'] = "yiy";
$arrayTwo['7'] = "mmm";
?>

Code: [Select]
array ( 0 => array ( 'id' => '6', 't' => 'Food & Beverage', ), 1 => array ( 'id' => '6', 't' => 'Food & Beverage', ), 2 => array ( 'id' => '2', 't' => 'Automotive', ), )
how to sum it, to get:

Code: [Select]
array ( 0 => array ( 'id' => '6', 't' => 'Food & Beverage', 'cnt' => '2' ), 1 => array ( 'id' => '2', 't' => 'Automotive', 'cnt' => '1' ), )

I need some help converting my captured array values into keys and later add arrays as the values.

This might help explain what I'm looking for:

I currently have Code: [Select]
Array
(
    [0] => Meat
    [1] => Veg
)
But I'm after Code: [Select]
Array
(
    Meat =>
    Veg =>
)
My end result will be:
Code: [Select]
[Veg] => Array
                (
                    [Potatoe] => 12
                    [Cabbage] => 24
                    [Cucumber] => 56
                )

[Meat] => Array
                (
                    [Chicken] => 23
                    [Beef] => 90
                )

I think either array_values() may help but I'm not too sure how to use it.

Hey guys so I've been trying to figure something out for a day now but I really don't know where to start, basically I'm trying to create some kind of function that goes through my array and checks if the keys value is less than 5, if it is then I want to unset the key removing it from the array,   I programmed this underneath as this is basically what I want to achieve however there's a syntax issue as the array_key_excists function doesn't seem to allow the if statement, if anyone knows anything about it it would be very helpful!

if (array_key_exists(($key > 5),$data))
 {
    unset($data[$key]);
 }

any help is very much appreciated,   Thanks very much in advance!

Hi,

I have the following code that takes a list from a mySQL db and puts it into an array that shows 'gig date, venue, city' per entry: -

 
Code: [Select]
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{

$array[] = ($row['date'].', '.$row['gl_venue'].', '.$row['gl_city']);
}

$output = json_encode($array);
this outputs JSON like so:
Code: [Select]
["06-05-2011, O'neills, Southend","07-05-2011, Power League, Peterborough","14-05-2011, Queen Victoria hall, Oundle",.......]
how do I add keys into the array so I get something like:
Code: [Select]

{"gigs":[
 { "gig": "date, venue, city",}
]}
 
at least I think so anyway!?!

What I want to do is eventually be able to parse a JSON listing into Objective-C and be able to call key/pairs into various different parts of an app.

I'm pretty new to this so any advice would be great.

Hi, I'm not sure if this is a wierd one, I have lots of arrays i'm looping through like this to see them:-


for($i=0; $i <count($confirmed); $i++){//loop through
     print_r_html($confirmed[$i]);
}


Which shows the following :-

Code: [Select]
Array
(
    [0] => AAAAAA-BBBBBB
    [1] => 2
    [2] => 2010-09-29
)
Array
(
    [0] => AAAAAA-BBBBBB
    [1] => 2
    [2] => 2010-09-28
)
Array
(
    [0] => CCCCCC-DDDDDD-EEEEEE
    [1] => 3
    [2] => 2010-09-29
)
Key 0 is a Groupconcat split by "-"
Key 1 shows how many fields are in 0
Key 2 is just the date

What I would like to do is split the first array into 2 arrays, the second in 2, and the third into 3 (therefore ungrouping the groupconcat if you will)
as such:-

Code: [Select]
First into these two:-
Array
(
    [0] => AAAAAA
    [1] => 2
    [2] => 2010-09-29
)
Array
(
    [0] => BBBBBB
    [1] => 2
    [2] => 2010-09-29
)
Second into these two:-
Array
(
    [0] => AAAAAA
    [1] => 2
    [2] => 2010-09-28
)
Array
(
    [0] => BBBBBB
    [1] => 2
    [2] => 2010-09-28
)
Third into these two:-
Array
(
    [0] => CCCCCC
    [1] => 3
    [2] => 2010-09-29
)
Array
(
    [0] => DDDDDD
    [1] => 3
    [2] => 2010-09-29
)
Array
(
    [0] => EEEEEE
    [1] => 3
    [2] => 2010-09-29
)
)
I know I can get out the info from the first of the keys in each array by putting this into the loop:-


for($i=0; $i <count($confirmed); $i++){//loop through
     if($i==0){
             $seperated[] = explode("-",$confirmed[$i]);//split by "-"
     } 
}
    print_r_html($seperated);



but i'm not sure how to copy the other keys at the same time? If anyone has got any ideas that would be great!
thanks in advance
Kev.

Hi guys,

I am getting data from a json source:

```

$jsondata = file_get_contents($url);
  $response = json_decode($jsondata, true)
  echo "<pre>"; print_r(array_keys($response));; echo "</pre>";

```

and this returns:

```

Array
(
    [0] => jsonapi
    [1] => data
    [2] => links
)

```

I want  to extract data from specific key in the data array (eg 'title'):

```

    [data] => Array
        (
            [0] => Array
                (
                    [type] => recipes
                    [id] => d6cd7643-6e44-4d26-9ed9-9da7196cef12
                    [attributes] => Array
                        (
                            [internalId] => 7
                            [isPublished] => 1
                            [title] => Deep mediterranean quiche
                            [createdAt] => 2019-05-07T13:34:27+0200
                            [updatedAt] => 2019-05-07T13:34:27+0200
                            [isPromoted] => 1
                            [path] => /recipes/deep-mediterranean-quiche
                            [cookingTime] => 30
                            [difficulty] => medium
                            [ingredients] => Array
                                (
                                    [0] => For the pastry:
                                    [1] => 280g plain flour
                                    [2] => 140g butter
                                    [3] => Cold water
                                    [4] => For the filling:
                                    [5] => 1 onion
                                    [6] => 2 garlic cloves
                                    [7] => Half a courgette
                                    [8] => 450ml soya milk
                                    [9] => 500g grated parmesan
                                    [10] => 2 eggs
                                    [11] => 200g sun dried tomatoes
                                    [12] => 100g feta
                                )

                            [numberOfservings] => 8
                            [preparationTime] => 40
                            [instructions] => 

```

How do I loop through the data array and select just the 'title' and 'difficulty' for example?

Edited May 12, 2019 by ludo1960

I'm trying to develop some php that will execute a MySQL query and move the results into XML.  In this particular instance, only one record is expected to be returned, and that one row will contain all the customer data, such as last name, first name, address1, etc.

While I can get my code to work and create the xml if I hard-code in all the keys (MySQL column names), I would like it to dynamically step through all the keys/MySQL column names so that if the db changes later (add more columns, for instance) the code generating the XML won't need to be altered.   

It should take the MySQL column name, create an element based on the column name, then create a text node and insert the value. 

Currently I'm just at the spot of testing by echoing the appropriate key/value pairs.  The code is stopping after the first key/value without going through the rest of the columns.  What do I need to do in order to get it to dynamically step through each column and get the key/value?

Here's the relevant code:
if($_POST['buscode'])

{echo "buscode is: ".$_POST['buscode']."<HR>";}
else 

{echo "ERROR WITH RETRIEVING BUSCODE<HR>";}
$buscode = $_POST['buscode'];
$query = "SELECT * " 

."FROM customers " 

."WHERE buscode = '$buscode'";
echo "Query will be: ".$query."<HR>";
$result = mysql_query($query);
if($result){echo "Success retrieving data from ats_ajax.<HR>";}
else{echo "Error retrieving data from ats_ajax\; MySQL error is:".mysql_error($result)."<HR>";}

////////////////////////////////////////
//  Let's test getting the keys and values from the array....
///////////////////////////////////////
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) 
{

echo "This is step ".$i."<BR>"; 

$key = key($row);

echo "Key is: ".$key."<BR>";

echo "Value is: ".$row[$key]."<BR>";

$i++;

}//close of while

the code is simple but the output is wrong.

Code: [Select]
$str = <<<EOF
a:2:{s:7:"visible";a:7:{i:0;s:5:"email";i:1;s:5:"print";i:2;s:8:"facebook";i:3;s:4:"digg";i:4;s:11:"stumbleupon";i:5;s:7:"twitter";i:6;s:6:"reddit";}s:6:"hidden";a:0:{}}
EOF;
echo "<textarea rows='10' cols='90'>";print_r(unserialize($str));echo "</textarea>";
the ouput is
Code: [Select]
Array
(
    [visible] => Array
        (
            [0] => email
            [1] => print
            [2] => facebook
            [3] => digg
            [4] => stumbleupon
            [5] => twitter
            [6] => reddit
        )

    [hidden] => Array
        (
        )

)
This is wrong I need something like this:
Code: [Select]
array (
  'visible' =>
  array (
    0 => 'email',
    1 => 'print',
    2 => 'facebook',
    3 => 'digg',
    4 => 'stumbleupon',
    5 => 'twitter',
    6 => 'reddit',
  ),
  'hidden' =>
  array (
  ),
)
What am I doing wrong? How do I fix it?