[medo]

Hi,

I have 2 arrays

PHP Code:

$x = array('a','b','c');

$y = array('s','t','u','v'); 

I want to merge the arrays values to become in the result

PHP Code:

"'a'='t','b'='u','c'='v'" 

please note the 1st value in the 2nd array [ y ] I want to disable it .

please help me to do that .
Regards

[phpdoctor]

Why is 's' in the second array disabled? is it because array $x only has 3 values?
Also are the arrays going to be different sizes?

Cheers

[medo]

I will use this to mysql class in update query from POST array

I will disable the 's' from the 2nd array becasue it will be the ID and I will use ID in where id = '1' for example

I will get the values for the 2nd array from the table by this function

PHP Code:

function get_fields($table)
{
$result = mysql_query("SHOW COLUMNS FROM $table ");

     while ($row = mysql_fetch_assoc($result))
       {
          $fields[] = $row[Field];
       }
       $fields = join(",",$fields);
} 

[phpdoctor]

Im still not really sure what you mean >.> What are you trying to create or do?

Have a look at this:

PHP Code:

$x = array('a','b','c'); 

$y = array('s','t','u','v');  



$merged = array();



foreach ($x as $key => $val)

{

    $merged[$y[$key]] = $val;

} 

Havent tested it but it should work.
Only thing is, I haven't done any disabling... not sure what you mean yet.

Lex

[wirehopper]

PHP: array_combine - Manual

[job0107]

If you use wirehopper's suggestion and combine it with array_shift() then you can do it with two lines of code.

PHP Code:

<?php
$x = array('a','b','c');
$y = array('s','t','u','v');

$id = array_shift($y);
$z = array_combine($x,$y);

// Output the results. //
echo "ID = ".$id."<br />";
foreach($z as $key => $value){echo $key." = ".$value."<br />";}
?>

[medo]

Jerry I tried your code and it was success but in the last of result there was a comma ,

PHP Code:

$x = array('id','a','b','c'); 
$y = array('s','t','u','v');

$id = array_shift($y);
$z = array_combine($x,$y);

// Output the results. //

foreach($z as $key => $value){echo "'".$key."' = '".$value."',";} 

the result is

PHP Code:

'a' = 't','b' = 'u','c' = 'v', 

I want to remove , after v only


Regards
Medo

[phpdoctor]

Wow I totally look like a noob... array_combine()!!!! Havent used that in ages :/

Well here's one way:

PHP Code:

$ids = array();

foreach($z as $key => $value)

{

    $ids[] = "'$key' = '$value'";

}



echo implode(', ', $ids); 

[wirehopper]

Jerry's code was correct. The comma is just an output issue - the array is good.

[job0107]

Originally Posted by medo

Jerry I tried your code and it was success but in the last of result there was a comma ,

PHP Code:

$x = array('id','a','b','c'); 
$y = array('s','t','u','v');

$id = array_shift($y);
$z = array_combine($x,$y);

// Output the results. //

foreach($z as $key => $value){echo "'".$key."' = '".$value."',";} 

the result is

PHP Code:

'a' = 't','b' = 'u','c' = 'v', 

I want to remove , after v only


Regards
Medo

If you are going to use identically sized arrays, then you don't need the array_shift() command.
As a matter of fact, you will get an error if you use it.
And to answer your question;
You are separating the array elements by commas, which leaves an extra comma at the end.
So, to remove the last comma, you can use the substr() function along with the strlen() function.
Like this:

PHP Code:

<?php
$x = array('id','a','b','c');
$y = array('s','t','u','v');

$z = array_combine($x,$y);

// Output the results. //
foreach($z as $key => $value){$output .= "'".$key."' = '".$value."',";}
$output = substr($output,0,strlen($output)-1);
echo $output;
?>

If we use your original arrays, then the code would look like this:

PHP Code:

<?php
$x = array('a','b','c');
$y = array('s','t','u','v');

$id = array_shift($y);
$z = array_combine($x,$y);

// Output the results. //
foreach($z as $key => $value){$output .= "'".$key."' = '".$value."',";}
$output = substr($output,0,strlen($output)-1);
echo $output;
?>

And in this example we add the 'id' element to the $z array:

PHP Code:

<?php
$x = array('a','b','c');
$y = array('s','t','u','v');

$id["id"] = array_shift($y);
$z = array_merge($id,array_combine($x,$y));

// Output the results. //
foreach($z as $key => $value){$output .= "'".$key."' = '".$value."',";}
$output = substr($output,0,strlen($output)-1);
echo $output;
?>