The Lodge is members-only design/dev videos and Office Hours.

Next Office Hours Session: "Implementing an SVG Icon System" Nov 30 - 6:00 PM Eastern

MySQL offsite?

  • # December 11, 2009 at 12:47 pm

    Ok, i have an odd issue.

    The web server I’m working on does not have MySQL. My company has a SQL server but they are being slow at setting up the DNS on the web server. Until they do no one can access the tables on the SQL server. Since I need a database now I have been given clearance to use an offsite MySQL database.

    I created my forms and the data is stored to the database fine. Now I want create reports while staying within my companies website.

    What I want to do is have the report form on the site, the user fills in the report request that is sent to a php file on the mysql database. The database send the results back to the user that is displayed to the user on the company website.

    So, can I process the mysql on another server and send the results back all in a secure way so the results arent seen in the address bar. It may be important to note that the results could be quite long.

    I added a graphic example of what i’m trying to do.

    # December 11, 2009 at 1:19 pm

    after messing with the idea i’ve discovered that i cant send info with the address bar.

    the site was created before I started and uses a very odd way of building pages so:$item

    wont work.

    # December 12, 2009 at 12:16 pm

    You can just make the MySQL database accept external commands and then you can use it on the server that doesn’t have a database as if it has.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

There's a whole bunch of content on CSS-Tricks.

Search for Stuff   •   Browse the Archives

Get the Newsletter ... or get the RSS feed