Bhavesh Posted October 25, 2013 Posted October 25, 2013 Hi Guys It's Friday thanks god.. LOL Im doing school project doing School Inventory on PHP and MYSQL.. i have no clue where to start.. anyone have any other idea how i can create school inventory etc thanks guys and have a nice week off too Bhav
LosOjos Posted October 25, 2013 Posted October 25, 2013 Hi Guys It's Friday thanks god.. LOL Im doing school project doing School Inventory on PHP and MYSQL.. i have no clue where to start.. anyone have any other idea how i can create school inventory etc thanks guys and have a nice week off too Bhav Why are you doing a project on something you know nothing about? If it's that you've been told to do it but don't know what it is, Google some existing inventory software, see how it works, what's required. Talk to someone in your school who's likely to use it, see what they have to record, what features they'd find useful etc.
RichCowell Posted October 25, 2013 Posted October 25, 2013 It was always done on a spreadsheet here, with labels printed ourselves, but has never been ideal for various reasons... We're just trialling School Asset Manager at the moment, after looking into a few options to cover everything needed, we finally decided to invest in a proper solution with support... It's a lot cheaper than it used to be, and is really easy to set up and use...
Bhavesh Posted October 25, 2013 Author Posted October 25, 2013 Well it's part of my Performace management where i have to do school inventory on PCs, printers with mac address ip address , warranties, smartboards etc as before there were it technician did inventory on excel and everything is mixed up . so i thou to do on php and mysql to give it nice and neat and update.
RichCowell Posted October 25, 2013 Posted October 25, 2013 Well it's part of my Performace management where i have to do school inventory on PCs, printers with mac address ip address , warranties, smartboards etc as before there were it technician did inventory on excel and everything is mixed up . so i thou to do on php and mysql to give it nice and neat and update. There are various tools to scan the network for anything with an IP address, we also use Spiceworks as a helpdesk system, that does have an inventry system built in and won't cost you anything, but not quite user friendly enough for an Asset Manager Solution...
Bhavesh Posted October 25, 2013 Author Posted October 25, 2013 true.. i also use spiceworks aswel, i wil try and give a go.. thanks mate
LosOjos Posted October 25, 2013 Posted October 25, 2013 Sorry, I got the wrong end of the stick, thought you were planning on writing your own system
Bhavesh Posted October 25, 2013 Author Posted October 25, 2013 Hi LosOjos Yeah im trying planning my own system in PHP and Mysql to built Inventroy for school, its a 1yrs project to do .. so i might have time to read php and mysql etc then will post here for you guys to try it out
SovietRussia Posted October 25, 2013 Posted October 25, 2013 1 year?! I reckon i could whip something up like this in a few days, but best of luck!
LosOjos Posted October 25, 2013 Posted October 25, 2013 Hi LosOjos Yeah im trying planning my own system in PHP and Mysql to built Inventroy for school, its a 1yrs project to do .. so i might have time to read php and mysql etc then will post here for you guys to try it out A year! Plenty of time I get the impression you are new to PHP and MySQL and this is a project to help you learn, am I right?
Bhavesh Posted October 25, 2013 Author Posted October 25, 2013 yeah 1 yr project is going to be a mission but end of the day its worth it...n yep im new into php n mysql..
LosOjos Posted October 25, 2013 Posted October 25, 2013 yeah 1 yr project is going to be a mission but end of the day its worth it...n yep im new into php n mysql.. In that case, W3Schools is going to be your friend: PHP 5 Tutorial Work through those, then move on to more in-depth tutorials, you'll know what you're looking for by the time you've worked through that little lot.
SovietRussia Posted October 25, 2013 Posted October 25, 2013 In that case, W3Schools is going to be your friend: PHP 5 Tutorial Work through those, then move on to more in-depth tutorials, you'll know what you're looking for by the time you've worked through that little lot. +1 for W3Schools, also the PHP Site and Stackoverflow work wonders for overcoming specific issues.
Bradlys Posted November 6, 2013 Posted November 6, 2013 Can I just throw in a spanner in the works? W3Fools I hate w3schools with passion. Everything you need for PHP and MYSQLI (Not MYSQL as that is old and outdated and shouldn't be used) is in the php documentation here: PHP: Hypertext Preprocessor using a mysql table etc: PHP: mysqli_result::fetch_fields - Manual Also use these: Stack Overflow Create html table and populate with records from databse in php | DaniWeb That last link should be really helpful as I pretty much give you the tools
LosOjos Posted November 6, 2013 Posted November 6, 2013 Can I just throw in a spanner in the works? W3Fools I hate w3schools with passion. Why? You're probably the first person I've ever heard of with that opinion. Sure, they might not go in to great detail on anything, but they provide you with a solid grounding to advance from. Everything you need for PHP and MYSQLI (Not MYSQL as that is old and outdated and shouldn't be used) is in the php documentation here: MySQLi is a PHP extension, the database it interfaces will still be MySQL. Also use these: Stack Overflow Create html table and populate with records from databse in php | DaniWeb That last link should be really helpful as I pretty much give you the tools The problem with relying on forums is knowing where to start, knowing when you're looking at something relevant, hoping the answer is enough for you to truly understand what you're doing as opposed to copy pasting and knowing when what you're reading is BS. Not a great place to go and learn IMO, but very good for getting help with specific problems once you have an idea what you're doing.
mavhc Posted November 6, 2013 Posted November 6, 2013 MySQL is now MariaDB - Wikipedia, the free encyclopedia
Bradlys Posted November 6, 2013 Posted November 6, 2013 Why? You're probably the first person I've ever heard of with that opinion. Sure, they might not go in to great detail on anything, but they provide you with a solid grounding to advance from. w3 doesn't really explain anything they do, they don't explain the functionality and why 'this' method is better than another etc. MySQLi is a PHP extension, the database it interfaces will still be MySQL. PHP used to use MYSQL as their extension and now it is MySQLi. The database may still be MySQL but the OP will need to use MySQLi to connect to it for security reasons and whatnot. The problem with relying on forums is knowing where to start, knowing when you're looking at something relevant, hoping the answer is enough for you to truly understand what you're doing as opposed to copy pasting and knowing when what you're reading is BS. Not a great place to go and learn IMO, but very good for getting help with specific problems once you have an idea what you're doing. The problem with relying on w3 is it isn't part of the php site and therefore is just as opinionated as a forum. Using forums and refering to the php website is a great way to learn each segment, I didn't say to copy and paste, as you can do that from W3. Heck, when I was learning I copy pasted from w3 but learnt from forums. Also Forums can be great for learning: PHP Tutorials | DaniWeb
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