get the text of the selected option in PHP - MySQL

Example

<select name="pais">
<option value="USA">USA</option>
<option value="Canada">Canada</option>
</select>

< ?
$pais = strip_tags($_POST['pais']);
? >

Reset MySQL Autoincrement Column

Directly Reset Autoincrement Value
Alter table syntax provides a way to reset autoincrement column. Take a look at following example.

ALTER TABLE `table_name` AUTO_INCREMENT=1

Example

ALTER TABLE `id_estudiantes` AUTO_INCREMENT=1