Working on a small google maps project for work to help visualize open sales orders. Most of the core functionality works. Map markers are generated from MySQL db via PHP and JSON. Right now the I just pass a get parameter to help filter results based on who the sales order is assigned. I’m looking for good techniques or best practices for a more robust method to pass query parameters. I don’t want to find myself boxed-in later on. I’m kind of thinking of using JS/jQuery to build a JSON array and let php parse it out to build MySQL queries. Testing a zillion different get parameters seems silly. Any ideas would be appreciated. I’m getting ready to restructure the db, so major changes will soon be a PITA. Thanx.
