StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Please see the full working example with databasse name <code>test</code> and table <code>table1</code>:</p> <pre><code><?php $mysqli = new mysqli("localhost", "root", "", "test"); /* check connection */ if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } $query = "SELECT * FROM table1"; $result = $mysqli->query($query); while($row = $result->fetch_row()) { $rows[]=$row['1']; //getting aal country } /* free result set */ $result->free(); /* close connection */ $mysqli->close(); ?> <form> <select> <?php foreach ($rows as $mod){?> <option value="<?php echo $mod?>"><?php echo $mod?></option> <?php }?> </select> </form> <?php $all_country = array(); foreach ($rows as $mod){ $arr = explode(',', $mod); foreach($arr as $row){ if(trim($row) != '') $all_country[] = trim($row); } } $input = array(); $input = array_unique($all_country); ?> <form> <select> <?php foreach ($input as $mod){?> <option value="<?php echo $mod?>"><?php echo $mod?></option> <?php }?> </select> </form> </code></pre> <p>This is result: note that Uk and UK have uper and lower case problem else it is unique.</p> <pre><code>Simple data: Array ( [0] => India [1] => Usa [2] => Germany [4] => usa [6] => Uk [8] => UK ) unique country; Array ( [0] => India [1] => Usa [2] => Germany [4] => usa [6] => Uk [8] => UK ) </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload