Hi I've been trying to configure an nginx to accept a complex dynamic url, so far I got this. (http://pastebin.com/aSmW5GPn), this what I got so far.

Here is the deal, the url should be working like these:

mydomain.com - will be the normal domain with information, user registration and user authentication. (http://mydomain.com/signin, http://mydomain.com/register)

the user can create database from their account. mydomain.com/database/create, view the database information mydomain.com/database/view, and list all the database htey have created http://mydomain.com/database/list

so far everything can be done and I can manage this.

The issue start here. to the user manage their database, create tables, etc, I want the url format to be: http://{user}.mydomain.com/{database}, this should proxy to a system/program that handles the database management (that should be hidden and only accessed by the url mention before).

If user go to http://{user}.mydomain.com/{database}/login, they are actually going to the another database manager, pre-filling the username and database to be used.

Thanks for you help in advance

PS. mydomain.com is using nginx+php and the database management software is using htaccess+php+nginx