PHP and SQL - Tech Support Forums

**GroundZero3** · June 29th, 2005, 08:19 AM

I am interested in developing a inventory database for my work to keep track of all the equipment we have in the field and in stock. I would like something that has a web interface so that it can be accessed anywhere on the network at any given time.

I was reading around and a it seems like PHP and SQL migrated together would be the best solution. I have no experience in either so im wondering how difficult of a task is this that im looking to create?

If you feel this is a big step to take for someone novice does anyone else have a solution for my needs? I dont feel like paying for software if this is something i can create on my own.

I found this site http://us3.php.net/tut.php and was also wondering whats some good PHP tutorial sites. I learn best by seeing example after example to get an understanding on what im doing. Thanks!

Agent_Embryo · June 29th, 2005, 08:25 AM

That's the best place to start right there, the PHP.net page. If you know HTML and some basic SQL syntax, what you want to do isn't all too hard to do. I'm no PHP expert by far though.

http://www.devshed.com/Server_Side/PHP

I've used that page a little. Kindof messy if you ask me but some good tutorials.

**GroundZero3** · June 29th, 2005, 08:28 AM

Hrm i guess i should ask where i can get some good information on SQL, never really played with it.

I have the basic abilities to do HTML so thats a relief. Thanks for the link ill check it out!

vass0922 · June 29th, 2005, 08:40 AM

Quote:

Originally Posted by GroundZero3

Hrm i guess i should ask where i can get some good information on SQL, never really played with it.

I have the basic abilities to do HTML so thats a relief. Thanks for the link ill check it out!

funny you should ask about beginner sql

http://www.techimo.com/forum/t145258.html

**GroundZero3** · June 29th, 2005, 08:44 AM

Quote:

Originally Posted by vass0922

funny you should ask about beginner sql

http://www.techimo.com/forum/t145258.html

Yah i was looking at that, im not really looking for a book solution (work wont spot the charge)

We do have an ebook account with Safari Bookshelf. Ill check out what they suggest to see if its on thier site.

Siliconjunkie · June 29th, 2005, 08:45 AM

I would check over at sourceforge first. No need to reinvent the wheel if someone has already done it.

**GroundZero3** · June 29th, 2005, 08:48 AM

Good point but i guess i was looking into learning something new at the same time

Never really played with that stuff, just something i thought would be enjoyable or useful down the road.

BeatYouWithShoe · June 29th, 2005, 02:23 PM

This looks extremely promising! http://phpmyinventory.sourceforge.net/ - I might end up using this at school as well.

Quote:

phpMyInventory (PMI) is a web-based inventory program designed to keep track of all your systems, software and peripherals. "Systems" include: PCs, servers, laptops, network printers, etc

SF Project Page - http://sourceforge.net/projects/phpmyinventory/

Siliconjunkie · June 29th, 2005, 02:25 PM

I agree GZ, I do the same thing. Just a thought, but I understand completely where you are coming from.

**GroundZero3** · June 29th, 2005, 06:32 PM

Quote:

Originally Posted by BeatYouWithShoe

This looks extremely promising! http://phpmyinventory.sourceforge.net/ - I might end up using this at school as well.

SF Project Page - http://sourceforge.net/projects/phpmyinventory/

Okay point taken SJ and thanks for the link Beat, i guess i will just play around with PHP and SQL on my own time.

This looks like a very feasible solution ill see what the boss thinks