nirna

Is this not possible?

I have many stores and every store has his own sevice area.

The user shold only give a position.

Later i would like to be able to extend that. For example, with the opening hours; only show stores that are currently open.

Maybe can I somehow give ever list-element a Id like= “ListId” . distance – service-area .”

And in js i can write if (id < 0) display: none
?

I do not understand how its possible to depict relationships.

I have something like this:

A store has several groups. In a group are several persons. A person can also be in several groups.

Store-Table

StoreID| Name | Phone | ….

Group-Table

GroupID | StoreID | Name

PersonGroup-Table

GroupPersonID | GroupID | PersonID

Person-table

PersonID | Name

How can I add a record for this?
With JSON i can only create Objects or Arrays,or not?

• This reply was modified 6 years, 7 months ago by nirna.
• This reply was modified 6 years, 7 months ago by nirna.

Each store has additional data. For these custom tables are needed. One of them has a relationship to the store table.

When a user clicks on a store, it should be redirected to a page. On this the additional data are displayed.

Two Ideas:

1. Add tables to the existing ones

Which entries of the post and post_meta tables contain the stores? How can I create a table with a relationship to them?

How does the database connection work? How can I access the sparred data in WordPress for the frontend, how can I add new entries in the backend?

2. Create a new independent database or tables

There will then be two store tables with redundant data. But that’s not a Problem for my application.

Here again the question:
How does the database connection work? How can I access the sparred data in WordPress or the frontend, how can I add new entries for the backend?

Thank you. I could now customize the design.

I did not understand yet where the data stores are stored.

phpmyadmin: WordPress -> but there I find nothing.

Thank you.

Whenn I copy the code from wpsl_listing_template in the functions.php, the result list disappear. And the map show only one in three stores.

I flush the store locator transient cache.
Sorry for my bad english.

• This reply was modified 6 years, 7 months ago by nirna.