Create form in PHP, Xtemplate and MySQL and speed up the site.
Form:
For an hotel comparison site we want to have created a form with ‘linked selectable options’. There are three options to select: country, region and city and they are linked through each other. So if you select country ‘Nederland’ (‘the Netherlands’ in Dutch) at region it should display all regions of the Netherlands and at city it should display all cities in the Netherlands. Then when you select a region, at city it should only display the cities in that region. By default the country should be set to ‘Nederland’.
All data (country, region, city) is present in the MySQL database in separate columns. We use the tool Affilistore for this site and it is build in PHP and uses template files (Xtemplate) for displaying the content.
We have tried to program this by ourselves but it didn’t work out. The form doesn’t work correctly and every time the site is loaded, the form gets all the data of the country, region and city out of the database which takes a lot of time. So the requirement for the new form is that is loads quickly.
Speed things up:
The site’s overall performance is very slow (server is very fast). We think it’s because we have inserted a lot of categories (1223) and the site is not programmed optimally to get this info out of the database. Also in the admin when you want to add another category, the listing of the current categories takes a lot of time. This needs to be speed up.
We’re building the site right now, so it’s not finished. There’s a copy of it on another domain, you can see it on www.taalles.net. Please send me a message for the ftp and database connection info.
