Hello, please, I have a request for you I do not know advice about searching from mysql db

I will give you an example of my situation
I have a database in which I have written all cities, street, zip code number, descriptive and indicative and I need to formulate them into 4 div tables.
In the first will City. In the second street, in the third number of descriptive and orientation and in the fourth zip code.

I need to after the entering the first table of the city, in the second table automatically attempted to suggest to the client with the address from which it results that in the given city that entered those streets and the next After entering the street he will be advised again with a descriptive and orientation number and the fourth table should automatically write a zip code based on the address given in the previous tables.

if you would advise me how I will be incredibly grateful I do not know too much advice.

[KK]

Hi,

If the number of records is not too big, you may use @cheesypoof's suggestion in the following thread -
viewtopic.php?f=4&t=8221

Hope it helps.

Db has just over 3 million rows i needed help how to make it when it enters the city so it would throw POST and when entering a street it would be advised by the customer when writing the street for example entering the city xxxx this city has many streets and one has the name XXA When entering the street when he writes XX so he should throw him whisper that street XXA is available

[trendoman]

Looks like this task stretches a bit further than just CouchCMS
At least tell us more - are there going to be many people simultaneously trying to pull data from db? I also wonder if you did any mockups. If yes, then please post screens. And remember that couch adapts to ready-made design much easier than to a blank page.

I have a demonstration here how it should look like i have unfortunately only got the function get: term

This link is demonstration of how it should look

Code: Select all

https://www.kolibazarys.cz/thathowIwantit.mp4

And in attachments are the images of the structure and the row of my db

Calling the database with Typeahead.js could maybe do the trick. Found a while back a small tutorial how to do this https://www.upwork.com/hiring/development/creating-autocomplete-functionality-with-php-and-mysql/.

But I have a problem with something else, I do not know how to properly download the data from the database in the php database to connect these parts, for example, once again when I enter the city XXX so in the second column automatically after entering the data in the first column the whisper will select data from the database street Only on the given city XXX and then another street corner on the given street will select from the database in the box 3 only from the specified city and the post code will be entered automatically in the 4 columns at the expense of this data this is my problem no typehead

[trendoman]

Your data is in a custom mysql table. You'd need to put together php code to connect to that database and run SQL queries.
After user selects first data, a second SQL query selects next portion of data (dependent to user-selected data in the first input) and puts the list of values into the second dropdown.

For example, try googling for "populating multiple dependent dropdowns from database +php +mysql"