PHP - Add String to Array

Question

I am wondering how I can add a string variable to the current array. For example, I have an array called $finalarray. Then I have a loop that adds a value on every run. Basically:

$finalarray = $results_array + string;

A very basic structure. I am using this for MySQL so that I can retrieve the final array of the column.

$query = "SELECT * FROM table";
$showresult = mysql_query($query);

while($results_array = mysql_fetch_assoc($showresult))
{
  $finalarray =  $finalarray + $results_array["column"];
}

Edit:

Currently using this code (still not working):

    $query = “SELECT * FROM table”;
$showresult = mysql_query($query);

while($results_array = mysql_fetch_assoc($showresult))
{
  $finalarray[] = $results_array["name"];
}

echo $finalarray;

The problem is that it just says "Array"

Thanks,

Kevin

codaddict · Accepted Answer · 2010-08-25 03:55:18Z

4

Answer to your edited question:

You cannot use just a single echo to print the entire array contents. Instead

Use

var_dump($finalarray);

or

print_r($finalarray);

to print the array contents..

answered Aug 25, 2010 at 3:55

codaddict

457k83 gold badges501 silver badges537 bronze badges

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

Comments

deceze · Accepted Answer · 2010-08-25 02:56:26Z

4

Use the [] notation. + is for unioning two arrays.

$array = array('foo');

$array[] = 'bar'.

// $array == array('foo', 'bar')

answered Aug 25, 2010 at 2:56

deceze♦

525k89 gold badges806 silver badges954 bronze badges

2 Comments

lab12 Over a year ago

If I add the two brackets, my array is a list of strings that say "Array" over and over again.

deceze Over a year ago

@Kevin Could you show us the actual code with which this is happening?

Jacob Relkin · Accepted Answer · 2010-08-25 02:59:50Z

3

You can use the function array_push or [] notation:

array_push($array, 'hi');

$array[] = 'hi';

answered Aug 25, 2010 at 2:59

Jacob Relkin

163k34 gold badges351 silver badges321 bronze badges

1 Comment

NDEIGU Over a year ago

what is this code actually doing? I don't get why you "push" 'hi' to array, but then you assign hi to the end of the array. Aren't you essentially adding it twice, then?

Jake N · Accepted Answer · 2010-08-25 02:57:03Z

1

Take a look at this

$query = "SELECT * FROM table";
$showresult = mysql_query($query);

while($results_array = mysql_fetch_assoc($showresult))
{
    $finalarray[] = $results_array["column"];
}

// Add X to the end of the array
$finalarray[] = "X";

answered Aug 25, 2010 at 2:57

Jake N

10.6k12 gold badges69 silver badges114 bronze badges

Comments

LynxStar · Accepted Answer · 2010-08-25 04:01:28Z

0

Codaddict is correct. You are looking to output the last element that was added to the array.

echo end($final_array);

That will move the array's pointer to the last element added to it and then output it. Since you're adding the elements to the array in this manner...

$finalarray[] = $results_array["name"];

The key for each of your elements will be sequential, 0,1,2,3...so on and so forth. Another less elegant solution to get the last element would be...

echo $final_array[count($final_array) - 1];

answered Aug 25, 2010 at 4:01

LynxStar

1

Comments

Sean Huber · Accepted Answer · 2010-08-25 06:12:23Z

0

echo implode($finalarray);

Or with a custom join "glue"

echo implode(', ', $finalarray);

answered Aug 25, 2010 at 6:12

Sean Huber

6404 silver badges7 bronze badges

Collectives™ on Stack Overflow

PHP - Add String to Array

6 Answers 6

Comments

2 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

2 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related