اگر فقط اطلاعات استان/شهر نیاز باشه:
USE IRAN;
SELECT
States.State , States.StateID,
Cities.City , Cities.CityID
FROM States
INNER JOIN Cities ON Cities.StateID=States.StateID
ORDER BY States.State, Cities.City
FOR JSON AUTO
Screenshot 2024-05-09 215827.png
<script src="data.js"></script>
<script>
var Cities; // شهرها
window.onload = function () {
States.forEach(function (x) {
cb_State.add(new Option(x.State, x.StateID));
});
cb_State.selectedIndex = 0;
cb_State.onchange = function () {
cb_City.length = 1;
var selected_StateID = this.value;
if (selected_StateID !== '-1') {
Cities = States.find(x => x.StateID == selected_StateID).Cities;
Cities.forEach(function (x) {
cb_City.add(new Option(x.City, x.CityID));
});
};
};
};
</script>