Devam Ediyor

477425 php / mysql script update 2

1) Current script selects stores by distance. Max. distance is set once for all stores.

I wanna keep this max. distance feature and add another distance filter.

Each store must be able to set the max. distance to get listed in search results.

I.e. you must modify the script to select only stores where (whithin) distance < "maxdist_store"

Max. distance setting of each store is saved in database table "stores" field "maxdist_store" (kilometer, value example: "3,5")

2) Current script uses a search filter for "languages", "services" and "categories".

Values are fetched from mysql tables. If the user selects one or more of those filter options

and there is no store that matches all filter options, script returns no search result.

I like to get a search result even if no search option filter matches. (no fulltext search possible)

I.e. you have to

a) count matched search options and order by matched_search_options DESC / order by distance ASC (as it is)

b) prepare template variables for search result as information which search options where matched

1) variables: {services_matched} / {categories_matched} / {languages_matched}

2) use 2 css styles to display text for matched / no match (.services_match / .services_nomatch, cat_match...)

3) additionally i wanna show a 3 state graphic image together for all search options in result ([url removed, login to view] / [url removed, login to view] / [url removed, login to view])

scripts are attached

Beceriler: Her şey Kabul, CSS, MySQL, PHP, Kabuk Betiği, Şablonlar, Web Sitesi Yönetimi

Daha fazlasını görün: asc it, value stores, update store, together mysql, script update database mysql, mysql select filter, mysql search table, php fulltext, php mysql database template, table css add, mysql update field, mysql update values, php show information mysql, example mysql script, mysql search database table, update values mysql, modify css table, update image database, modify table php, php mysql filter results, css table display php, script update mysql tables, add search feature php, filter modify, php search database table

İşveren Hakkında:
( 10 değerlendirme ) Austria

Proje NO: #2223332