javascript - How to pass items id url on select option search using php?
one text
Here I want to paginate my search by select option and tired to pass id of selected and searched items on select option. could you help me please? this is my search select option code; $query= mysqli_query($con, "select distinct occupation from ttlm");
<form class="form-control-sm" method="post">
<label>Occupation</label>
<select class="form-control-sm" name="occup">
<option>Select occupation</option>
<?php
include("config.php");
$query= mysqli_query($con, "select distinct occupation from ttlm");
while($row=mysqli_fetch_assoc($query))
{
?>
<option value="<?php echo $row['occupation'];?>" class="form-control">
<?php echo $row['occupation'];?>
</option>
<?php
}
?>
<input type="submit" name="filt" class="form-control-sm" value="Filter">
</select>
</form>
//my pagination query
$result_count = mysqli_query($con, "SELECT COUNT(*) As total_records FROM ttlm where occupation='".$_GET['occuptaion']."' ");
Source