Embedding html into PHP

Question

I have the below code

$Query='SELECT * FROM  `courses`';
$result=mysqli_query($connection,$Query);
echo'<select name="courses" multiple>';
while($data=mysqli_fetch_array($result))
{ echo"<option value=\"";$data['title'];echo"\">";$data['title'];echo'</option>';}
echo"</select>";

I am trying to return values from a table,Database into a Multiple Selection menu. but it keeps giving me the below error

Parse error: syntax error, unexpected 'echo' (T_ECHO) in C:\wamp\www\ETT Logo\Controlpanel\addteacher.php on line 51

Please note that Line 51 is the line inside of the 'while' brackets.

Will Appreciate any solutions.

score 0 · Accepted Answer · edited Nov 14 '16 at 11:34

0

Your problem is you can not make echo option in right way. Try below code it's works for you

$Query='SELECT * FROM  `courses`';
$result=mysqli_query($connection,$Query);
echo'<select name="courses[]" multiple>';
while($data=mysqli_fetch_array($result)){
     echo "<option value='".$data['title']."'>".$data['title']."</option>";
}
echo"</select>";

edited Nov 14 '16 at 11:34

Mayank Pandeyz

25,704
4
40
59

answered Nov 14 '16 at 09:33

Nikhil Vaghela

2,088
2
15
30

name="courses" will hold multiple selected value in it ?? – Mayank Pandeyz Nov 14 '16 at 09:35
I update code try now – Nikhil Vaghela Nov 14 '16 at 09:36
This one worked. thanks alot. I appreciate it. – Mustafa Azad Nov 14 '16 at 09:40
may I ask, what's with the dots you added? it seems like the dots did the job.. – Mustafa Azad Nov 14 '16 at 09:41
Dot means it join your string..dot use to CONCAT string. – Nikhil Vaghela Nov 14 '16 at 09:46
For more detail see below link http://php.net/manual/en/language.operators.string.php – Nikhil Vaghela Nov 14 '16 at 09:47

score 0 · Answer 2 · answered Nov 14 '16 at 09:33

0

{ 
     echo "<option value='{$data['title']}'>{$data['title']}</option>";
}

answered Nov 14 '16 at 09:33

nospor

4,190
1
16
25

Tried it, but didn't work. thanks for the help though – Mustafa Azad Nov 14 '16 at 09:40
Now it is proper code. Maybe you have another error now? – nospor Nov 14 '16 at 09:41

score 0 · Answer 3 · edited Nov 14 '16 at 11:02

0

Use this, it's a lot easier to understand:

$title = $data['title'];
echo "<option value='{$title}'>{$title}</option>";

edited Nov 14 '16 at 11:02

smottt

3,272
11
37
44

answered Nov 14 '16 at 09:34

Semi-Friends

480
5
17

Tried this one, didnt work, still gave me the same error. – Mustafa Azad Nov 14 '16 at 09:39
please take note of the use of single quote and double quote – Semi-Friends Nov 14 '16 at 09:41

score 0 · Answer 4 · answered Nov 14 '16 at 09:34

Try this:

echo'<select name="courses[]" multiple>';    
// to hold multiple selected values name must be an array

while($data=mysqli_fetch_array($result))
{ 
    echo '<option value="'. $data['title'] .'">'. $data['title'] .'</option>';
}
echo'</select>';

score -2 · Answer 5 · answered Nov 14 '16 at 09:34

-2

you need to use '.' for this one...

echo"<option value=' .$data[title]. '>;

answered Nov 14 '16 at 09:34

fernando

814
1
9
24

Embedding html into PHP

5 Answers5