Menu
Community /Pin to ProfileBookmark
@NogDogMay 10.2019 — #Not sure what you really want to happen, but by definition every element of an array has an index/key, and
@NogDogMay 10.2019 — #
No, they're actually delimited with newlines, as in my example. But that should be beside the point: it's mainly a debug function -- if you want to output an array in a specific format, you should control it explicitly, as I did in a fairly simple manner with the
values from associative array to indexed array?
I’m creating an indexed array from JUST values of an associative array (fetched from a database) which I can then reassign to different variables by index
`$runSql = mysqli_query($connect, $queryTitle);
if ($runSql) {
if (mysqli_num_rows($runSql) > 0) {
$indxarrTitleResult = array();
while ($assocarrResultTitle = mysqli_fetch_assoc($runSql)) {
$indxarrTitleResult[] = $assocarrResultTitle[‘Title’];
}
print_r($indxarrTitleResult);
}
}
this produces:
Array ( [0] => Traditional Favourites [1] => Starters [2] => Mains )
but what I really want is:
Array ( “Traditional Favourites”, “Starters”, “Mains”)
what is going wrong? From the result I got, I can only assign Traditional Favourites to another variable but nothing else
Sign in
to post a comment9 Comments(s) ↴
0
@NogDogMay 10.2019 — #Not sure what you really want to happen, but by definition every element of an array has an index/key, and print_r()<i>
</i>$ php -a
Interactive shell
php > $test = array("Traditional Favourites", "Starters", "Mains");
php > print_r($test);
Array
(
[0] => Traditional Favourites
[1] => Starters
[2] => Mains
)
php > echo implode(', ', $test)."n";
Traditional Favourites, Starters, Mains
php >
0
@NogDogMay 10.2019 — #>@nsath#1603560 print_r will show the indexes/keys but shouldn't they be delimited using commas?
No, they're actually delimited with newlines, as in my example. But that should be beside the point: it's mainly a debug function -- if you want to output an array in a specific format, you should control it explicitly, as I did in a fairly simple manner with the
implode()