Newbie trying to create Asset Database Frontend, need suggestions

Tyrant

I am pretty new to this php and sql stuff but i have done html before. I have been reading lots of tutorials and such on how to setup mysql and start coding php into pages to make queries to retrieve/modify/delete info.

I am trying to create a frontend for the database i have at work. We need to monitor all of the assets, modify them sometimes in batches, and delete them sometimes in batches. It would also be nice to be able to pick certain assets to create a packing slip and then remove the assets. At our warehouse we have to receive and tag the units with asset stickers, place them in racks, move them if necessary, and ship them. There are currently 3000+ assets.

I have already installed mysql and exported the information from an access database into a table in mysql. I have this feeling though that coding all of this into a web frontend will prove to be difficult for a newbie like myself. Does anyone have any suggestions as far as software or is asp possibly a better way to do this?

planetsim

If you know heaps of ASP you may want to use that if this is an urgent thing. However if you dont know either, you may need to decide which you want to learn. As this is a PHP Board, im gonna seem bias.

Id say learn PHP and try and do it that way,ASP is much harder to learn, and if you havent learnt any other language before it id say your wasting your time learning it.

Tyrant

i have experience with c++ and a little java, i guess i just have to learn the queries and loops for the code

DeltaRho2K

What you are wanting to do isn't that difficult in either (just understanding the sturcture differences can be tricky) I would recommend using php, since you will find more tutorials, help, and code snippets to learn from... I created an ASP site for my company, and am revamping the entire Intranet over to php now... (Ugh!) I wish I had given more consideration to php, and convinced my boss the first time around that we would have been better ofof. Oh well, good learning experience.

scoppc

Originally posted by planetsim
im gonna seem bias.

Id say learn PHP and try and do it that way,ASP is much harder to learn, and if you havent learnt any other language before it id say your wasting your time learning it.

See... bias... hehe 😃

PHP is in some way similar to C++. So, this might be your first choice as ASP is more like VB.