What is the best development environment for quick web-based data-oriented apps?

[montan]

Hi all,

I need to develop a few small data-oriented applications.
Basically a few data-capture screens and a couple of reports.

This is the kind of applications a moderately skilled user can produce with MS Access. I would like to develop these small apps in a web-server environment (possibly on linux).

Is there any platform that allows such simple development? (e.g. design easily the DB structure, draw the interface, do base logic and validation rules through object properties as opposed to programming from scratch, ...)

Thanks,

Roberto

[improvcornartist]

You might look into Ruby on Rails.

[Markus]

I say PHP ;)

[ifedi]

@Markus
I have a patient management (medical) software in the process of being completed. Basically run on PHP in a background of Apache and MySQL. On the front end, there's plenty of JavaScript and AJAX, without which the software would be quite sub-functional.
At present, I have deployed on one hospital intranet. However, I dream of hosting the system online, such that access can be unlimited. Something tells me I may have to take a couple of security measures in this case. I am not quite sure what're the most important ones, and what options I have for achieving these.
Anyone's help would be appreciated.

PS: I have a zillion hyperlinks sending information via the URL into the $_GET variable. I hate to see those stuff in the address bar. I guess there's no way of blacking them out, huh?

[Markus]

$_POST is an option. $_SESSION, $_COOKIE, too.

If you have a PHP specific question, ask it in that forum please.

Thanks,
Mark.

[donr]

I highly recommend Digital-Clay. that is what I use, especially for these kinds of projects.

[r035198x]

Many options are available.The choice generally depends on what you already know and the platform on which the system will be run.