PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE city ( id int primary key, name varchar(64) ); INSERT INTO city VALUES (1, 'Moscow'), (2, 'St/ Pitersburg');
Copy Clear
Copy Format Clear
<?php $connect = &$mysqli; $citys = mysqli_query($connect, "SELECT * FROM `city`"); $citys = mysqli_fetch_all($citys); echo '<select name="magaz">'; foreach ($citys as $city) { echo '<option value=' . $city[0] . '>' . $city[1] . '</option>' . PHP_EOL; } echo '</select>';
Show:  
Copy Clear