while ($topic = mysql_fetch_assoc ($result)); {
echo "{$topic["overtag "]} ";
}
The results from my while loop are displayed as such: apples orange banana
I want to be able to take all those results and put them in a variable and make it look like this: $fruits = apples orange banana
How would I be able to do this?
concatenation operator .=
$fruits = '';
while ($topic = mysql_fetch_assoc ($result)); {
$fruits .= "{$topic["overtag "]} ";
}
// I love arrays.
$fruits = array();
while ($topic = mysql_fetch_assoc ($result)); {
$fruits[] = (string)$topic["overtag "];
}
// If you don't want an array, but a string instead, use implode:
$fruits = implode(' ', $fruits)
implode as demonstrated in the line of code under the loop. You could of course just concatenate the strings, but in in practise in many cases you'll need to use the independent values that are retrieved from a database, that's why I put them in an array. Arrays are very powerful tools to keep lists of data in. In cases where you'd like to convert the values in a array to a single string, you can use implode.You merely need to concatenate each one onto the variable inside the loop
$fruits = "";
while ($topic = mysql_fetch_assoc ($result)); {
echo "{$topic["overtag "]} ";
$fruits .= $topic['overtag'] . " ";
}
// This is going to result in an extra space at the end, so:
$fruits = trim($fruits);
Oh, also, you have an errant semicolon which is going to break your while loop:
while ($topic = mysql_fetch_assoc ($result)); {
--------^^^--
Should be:
while ($topic = mysql_fetch_assoc ($result)) {
Using the PHP code below, you can get data from database table and display on webpage:
$sql_query="select * from yourTable";
$result=mysqli_query($connection,$sql_query);
if(mysqli_num_rows($result) > 0)
{
while($row = $result->fetch_array(MYSQLI_ASSOC))
{
echo "ID ".$row[0];//echo "ID ".$row["ID"];
echo "Name ".$row[1];//echo "Name ".$row["Name"];
}
}
else
{
echo "No Record";
}
