PHP concatenate values into array

Question

I'm new to php and would like to know how to make the following possible ...

Below I have several arrays populated from Database rows. Id like to have a new array mappingId that concatenates several rows to form the value for the mappingId array. Below I have used array_combine but this doesn't seem to work. Can anyone advise on what to use?

$appId = array();
$appDate = array();
$appTime = array();
$appDoctorId = array();
$mappingId = array(); // combined values

for ($i = 0; $i < mysqli_num_rows($resultAppointmentsBooked); $i++)
{
    $row = mysqli_fetch_row($resultAppointmentsBooked);
    $appId = $row[0];
    $ids[] = $row[0];
    $appTime[] = $row[3];
    $appDate[] = $row[4];
    $appDoctorId[] = $row[2];
    $mappingId = array_combine($row[4], $row[3], $row[2]);

    //Test output
    echo "MappingId: $row[4]$row[3]$row[2] <br />";
    echo "MappingId2: - $mappingId[$i] <br />";
}

I have also used 'array_merge' the following way ...

                $ids[] = $row[0];
                $appTime[] = $row[3];
                $appDate[] = $row[4];
                $appDoctorId[] = $row[2];

                $mappingId = array_merge($appDate, $appTime, $appDoctorId);

but when I print the values ...

             echo "MappingId2: $mappingId[$i] <br />";

It only output the value of the first array.

What data you are getting $resultAppointmentsBooked and how you want to structure $mappingId? — Deepak Biswal
– Deepak Biswal, Commented Dec 2, 2015 at 10:23
Just a nitpick, concatenation is a string operation, so you cannot concatenate values into an array. And array_combine wants two arrays as parameters (one for keys and one for values), so passing strings will not work. — Eike Pierstorff
– Eike Pierstorff, Commented Dec 2, 2015 at 10:25
I want 'MappingId' to told the value of appDate+appTime+appDoctorId. $resultAppointmentsBooked essentially rows from a database table. @deepakb @e — japes Sophey
– japes Sophey, Commented Dec 2, 2015 at 10:38
what does appDate+appTime+appDoctorId mean? Do you want those value with a + sign or something like this appDate apTime appDoctorId? Please let me know. Check my answer! — Deepak Biswal
– Deepak Biswal, Commented Dec 2, 2015 at 10:53

Deepak Biswal · Accepted Answer · 2015-12-02 10:58:24Z

1

Try something like this. If this is what you need. Here in the below codes $mappingId contains array of individual appDate, appTime, appDoctorId in array format. If you don't want array just want concatenate those value with one element then also you can do that. Please let me know!

$mappingId = array(); // combined values

for ($i = 0; $i < mysqli_num_rows($resultAppointmentsBooked); $i++)
{
    $row = mysqli_fetch_row($resultAppointmentsBooked);
    $appId = $row[0];
    $appTime = $row[3];
    $appDate = $row[4];
    $appDoctorId = $row[2];
    $myArr = array();
    //array_push($myArr, $appDate, $appTime, $appDoctorId);
    // If you want in concatenate format
    array_push($myArr, $appDate."".$appTime."".$appDoctorId);
    array_push($mappingId, $myArr);
}

edited Dec 2, 2015 at 10:58

answered Dec 2, 2015 at 10:50

Deepak Biswal

4,3302 gold badges22 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

japes Sophey Over a year ago

Array-push seem to do the job!

Cas Bloem · Accepted Answer · 2015-12-02 10:25:21Z

1

You can add values to an array by doing this:

 $mappingId[] = 'Hello';
 $mappingId[] = 'There';
 $mappingId[] = 'Friend';

Results in:

 $mappingId = array('Hello', 'There', 'Friend');

--

You can also use array_merge.

This merges the elements of one or more arrays together so that the values of one are appended to the end of the previous one. It returns the resulting array.

edited Dec 2, 2015 at 10:25

answered Dec 2, 2015 at 10:19

Cas Bloem

5,1102 gold badges26 silver badges23 bronze badges

Comments

Serginho · Accepted Answer · 2015-12-02 10:21:52Z

0

I think what you're looking for is array_merge

array_merge(array(1), array(2,3)); //return array(1,2,3)

edited Dec 2, 2015 at 10:21

answered Dec 2, 2015 at 10:17

Serginho

7,5303 gold badges31 silver badges54 bronze badges

1 Comment

ʰᵈˑ Over a year ago

Please provide a code example to further explain your answer. Also why array_merge.

David · Accepted Answer · 2015-12-02 10:23:40Z

0

try something like this , array_merge should work:

$ids = $row[0];
$appTime = $row[3];
$appDate = $row[4];
$appDoctorId = $row[2];
$mappingId = array_merge($ids, $appTime, $appDate, $appDoctorId);

echo "MappingId: $row[4]$row[3]$row[2] <br />";
echo "MappingId2: - $mappingId <br />";

answered Dec 2, 2015 at 10:23

David

277 bronze badges

1 Comment

japes Sophey Over a year ago

Hi there, I've tried this and it results is no output. @david

Collectives™ on Stack Overflow

PHP concatenate values into array

4 Answers 4

1 Comment

Comments

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related