Molson31 Posted May 6, 2013 Share Posted May 6, 2013 Hi there. I work at a small company of 25 people and am looking to create an inventory system from the ground up. My question is which way to go: ASP, or PHP. This is a completely internal system for only our employees. It needs to be linked to a database that can be changed on the fly via a webpage. Basically, an excel sheet styled view access from a website hosted on our web server. The key features are the ability to change data on the fly, to track changes via timestamps (such as a user changing the location of an object), and that's really about it. We are just trying to upgrade from using shared Excel files to track our inventory. I'm pretty fluent in HTML and CSS and have enough time to learn PHP or ASP. I am wondering which is more powerful, easier, and will allow us to create such a system. Thank you. Link to comment Share on other sites More sharing options...
birbal Posted May 6, 2013 Share Posted May 6, 2013 (edited) You can use either. they can both do the things you want. With PHP you probabl;y will get better support. Edited May 6, 2013 by birbal Link to comment Share on other sites More sharing options...
jeffman Posted May 6, 2013 Share Posted May 6, 2013 (edited) What birbal said. Support is the bigger question here. The online PHP Manual is 1000 times more user friendly than Microsoft documentation. The online community of PHP developers is very friendly (like us). And since PHP syntax is almost the same as JavaScript syntax, that's also an argument for PHP. Edited May 6, 2013 by Deirdre's Dad Link to comment Share on other sites More sharing options...
justsomeguy Posted May 6, 2013 Share Posted May 6, 2013 If you're talking about ASP classic, that shouldn't be an option. You can use either ASP.NET or PHP, not ASP classic. Link to comment Share on other sites More sharing options...
Molson31 Posted May 6, 2013 Author Share Posted May 6, 2013 (edited) Of course. Thank you for the replies. One further question: I want to make editing the tables dynamic. No form submission necessary (otherwise, may as well continue to use Excel sheets.) Will I need to implement AJAX? So far I have seen AJAX used for fancy search fields like Google does, but none for on-the-fly editing of database tables. Edit: found this! http://demos.9lessons.info/table_edit/TableEdit.htm Edited May 6, 2013 by Molson31 Link to comment Share on other sites More sharing options...
justsomeguy Posted May 6, 2013 Share Posted May 6, 2013 Ajax is basically just a way to submit the form without the page reloading. You still need a way to send data to the server, ajax is a way to do that with Javascript without requiring the page to refresh. Link to comment Share on other sites More sharing options...
Molson31 Posted May 7, 2013 Author Share Posted May 7, 2013 Great! I know Java requires external js files and to be installed on a user's PC. But I am unfamiliar with AJAX. Is it browser based? Does the user need anything? And does the server need something to run AJAX? Link to comment Share on other sites More sharing options...
Ingolme Posted May 7, 2013 Share Posted May 7, 2013 Java has nothing to do with Javascript. AJAX is just a system for Javascript to make requests to the server without reloading the page, it runs on the client. The server cannot tell if a request was sent by AJAX or by the browser. Link to comment Share on other sites More sharing options...
jeffman Posted May 7, 2013 Share Posted May 7, 2013 (edited) To address your other question more directly: AJAX is built into all modern browsers. You do not need to link to any special libraries or install any special files to use it. You can. (jQuery is a common example.) But you don't have to. Start here. Also, you might be surprised how often AJAX is being used to update pages that you visit frequently. Certainly it can do what you want. I am a college professor, and years ago I wrote a web-app that handles my students' grades. It is essentially an online spreadsheet. If I gave access to another user, I would create the kind of situation you are describing. EDIT. Actually, my students do have read-only access. Not a big deal. Edited May 7, 2013 by Deirdre's Dad Link to comment Share on other sites More sharing options...
Molson31 Posted May 7, 2013 Author Share Posted May 7, 2013 Great. Thanks for the replies. If anyone is interested I have used a jquery project called jqGrid and it works phenomenally. http://www.trirand.com/blog/jqgrid/jqgrid.htmlEasy as it gets to set up and start creating your own grids. Thanks for all the helpful info! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now