Reputation: 117
I'm putting together a form in which it is possible to perform a query which is informing the url fields return. The relationship of the tables is as follows:
TB_USER> TB_PEOPLE> TB_PHONE
I'm going through the following url structure for the fields that should return:
http://localhost?fields=ID,USERNAME,TB_PEOPLE.fields(FIRST, LAST, TB_PEOPLE.TB_PHONE.fields(PHONE)
Note that I am returning fields from related table stating "table name". Fields (fields from related table) that can be recursive.
But I am in doubt how could parse that string without losing the idea of relationship.
Thank you.
Upvotes: 0
Views: 152
Reputation: 156
I would advise to use the POST method instead of sending it in such a reconstituted url. It is more secure than showing all the structure of your database.
Upvotes: 1