Mahdi.Victory
شنبه 28 شهریور 1394, 17:18 عصر
سلام
میشه بگین کجای کارم اشکال داره
ممنون
فقط بجای جدول province از state استفاده کردم و بجای name از title
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-US" xmlns="http://www.w3.org/1999/xhtml" >
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<style>
select.selmenu {
font-size: 17px;
color: #676767;
padding: 9px !important;
border: 1px solid #aaa;
width: 200px;
}
</style>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js"></script>
<script >
$(document).ready(function() {
var optarray = $("#layout_select").children('option').map(function() {
return {
"value": this.value,
"option": "<option value='" + this.value + "'>" + this.text + "</option>"
}
})
$("#column_select").change(function() {
$("#layout_select").children('option').remove();
var addoptarr = [];
for (i = 0; i < optarray.length; i++) {
if (optarray[i].value.indexOf($(this).val()) > -1) {
addoptarr.push(optarray[i].option);
}
}
$("#layout_select").html(addoptarr.join(''))
}).change();
});
</script>
<?php
include_once 'config.php';
?>
</head>
<body>
<div dir="rtl">
<section id="recipientcase">
<h3 style="padding-bottom: 5px;color: #2894FF;">استان :</h3>
<select id="column_select" name="province" tabindex="6" class="selmenu">
<?php
$sth = $conn->query('SELECT * FROM state');
foreach($sth as $rows) {
?>
<option value="<?php echo $rows['id']; ?>" ><?php echo $rows['title']; ?></option>
<?php
};
?>
</select>
</section>
<br />
<section id="recipientcase">
<h3 style="padding-bottom: 5px; color: red;">شهر :</h3>
<select class="selmenu" id="layout_select" name="city" tabindex="6">
<?php
$sth = $conn->query("SELECT * FROM city");
foreach($sth as $rows) {
$sth = $conn->prepare('SELECT * FROM state WHERE id=:id');
$sth->execute(array(':id'=>$rows['id_state']));
$province = $sth->fetchObject();
?>
<option value="<?php echo $province->name; ?>^<?php echo $rows['id']; ?>" ><?php echo $rows['title']; ?></option>
<?php
};
?>
</section>
</div>
</body>
</html>