ایجاد لیست های کشویی استان و شهرهای هر استان

[mazoolagh]

اگر فقط اطلاعات استان/شهر نیاز باشه:

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>