G+_Matthew Bowe Posted September 5, 2015 Share Posted September 5, 2015 Good morning internet. I'm looking for management software that can show a map of a locker room, indicate lockers in use, and store guest info. I don't need any other bell or whistle. Suggestions? I could probably build a database program out of MS Access, but I wouldn't know how to have the map display available lockers. Link to comment Share on other sites More sharing options...
G+_E. Matt Armstrong Posted September 5, 2015 Share Posted September 5, 2015 I would use some form of SQL for the database. Then have a web page in php or asp if you like M$ products as the front end. Use an html table to display the map. You could change cell background colors to indicate in use or not. Link to comment Share on other sites More sharing options...
G+_Matthew Bowe Posted September 5, 2015 Author Share Posted September 5, 2015 That would work. I'm not a fantastic coder, though. I'd need something stable enough for 20 Ski bums to use and not require my constant babysitting. Link to comment Share on other sites More sharing options...
G+_Ben Yanke Posted September 5, 2015 Share Posted September 5, 2015 Custom mySQL might be your easiest route to get all the functionality. All you'd really need is a db entry for each locker then a layout frontend. Link to comment Share on other sites More sharing options...
G+_Matthew Bowe Posted September 5, 2015 Author Share Posted September 5, 2015 How do you suggest making the layout front end? Link to comment Share on other sites More sharing options...
G+_Ben Yanke Posted September 5, 2015 Share Posted September 5, 2015 PHP to read the DB info and HTML+CSS for final output and formatting. An HTML table might be the simplest route. Link to comment Share on other sites More sharing options...
G+_E. Matt Armstrong Posted September 6, 2015 Share Posted September 6, 2015 Start here, http://www.w3schools.com/asp/ado_intro.asp Keep going until you get to the last demonstration that ties everything together. If you still want to use Access, I have a book for you "Mastering MS Access 97" it is 1140 pages long and is still mostly relevant. If you pay postage I will ship it to you. I haven't used it since I learned this. If you could get me some ski rentals and lift tickets, I would write the the program for you. Link to comment Share on other sites More sharing options...
G+_Matthew Bowe Posted September 6, 2015 Author Share Posted September 6, 2015 Hmm... I actually could get you the tickets. Ever come to Deer Valley? Link to comment Share on other sites More sharing options...
G+_E. Matt Armstrong Posted September 6, 2015 Share Posted September 6, 2015 No, I love to ski but I live in South Carolina. I usually make a trip to western NC once a year. The conditions are usually icey or mash potatoes. I heard Utah has the best powder. Link to comment Share on other sites More sharing options...
G+_Ben Yanke Posted September 7, 2015 Share Posted September 7, 2015 Eh, I'd steer clear of Microsoft server stuff... Link to comment Share on other sites More sharing options...
G+_Matthew Bowe Posted September 7, 2015 Author Share Posted September 7, 2015 Okee. Link to comment Share on other sites More sharing options...
G+_Matthew Bowe Posted September 12, 2015 Author Share Posted September 12, 2015 Edward Armstrong That we do. Link to comment Share on other sites More sharing options...
G+_Matthew Bowe Posted September 12, 2015 Author Share Posted September 12, 2015 Ok. I've settled on using MySQL and PHP, unless any of you can think of anything easier. What I need is the following: -A graphical representation of the locker room -An easily editable table showing Guest Name (and other guest info as needed) -Clicking the locker on the graphical representation highlights and selects the respective table entry -Clicking the table entry highlights the graphical representation of the respective locker. -Color code the graphical representation to determine locker occupancy state. Ideas? Link to comment Share on other sites More sharing options...
G+_Ben Yanke Posted September 12, 2015 Share Posted September 12, 2015 you might want/need a bit of JavaScript as well, to make the whole thing more responsive. Would be required but could certainly be a nice touch Link to comment Share on other sites More sharing options...
G+_E. Matt Armstrong Posted September 12, 2015 Share Posted September 12, 2015 Ben Yanke? This would be simpler on a LAMP server setup. This example just has basic SQL and db connectios. I used the example on an XP workstation just turning on IIS. It was on its own network and not connected to the internet. I used the example to do an inventory web app with over 300,00 records. It ran fine for M$.? Link to comment Share on other sites More sharing options...
G+_Ben Yanke Posted September 12, 2015 Share Posted September 12, 2015 I was just suggesting using js for frontend ui enhancements, not any actual functionality Link to comment Share on other sites More sharing options...
Recommended Posts