Requesting data from a database

Demo for reading data from a database with a fixed parameter

The following database query with the name "state_by_city" will be used in the script:

SELECT DISTINCT bundesland FROM bundesland_plz_ort WHERE ort like concat(?,'%')

Read state by city

Enable JavaScript to see the sample code