PHP/MySQL knowledge needed for this project?

[lifeisbetterwithketchup]

Alright, I work at the local Dairy Queen, and I'd like to set up an online work schedule for it. My question is: how much PHP/MySQL knowledge is needed to do such a thing? Basically, all I would want is something that will show what days and what hours people work, after my boss logs in and updates it, nothing terribly fancy. The key is simplicity: I want it to be really easy for him to update the schedule.

Would the knowledge to create such a thing be feasible to learn in about a month (that's when the store re-opens)? I already have decent knowledge of HTML (and VB.NET and TI-BASIC, but I don't think those are relevant here).

[Skyone]

PHP and MySQL are unbearably easy to learn, and your application seems nothing short of simple. Once you learn about PHP/MySQL, you'll find this for yourself.

[lifeisbetterwithketchup]

PHP and MySQL are unbearably easy to learn, and your application seems nothing short of simple. Once you learn about PHP/MySQL, you'll find this for yourself.

Thanks for the quick replay, Sky. Do you know of any good places to learn PHP/MySQL?

[Skyone]

Since it's so easy to learn, generic tutorials found through Google are simply enough. I usually use:

http://www.freewebmasterhelp.com/tutorials/phpmysql
http://www.php-mysql-tutorial.com/

For reference.

[lifeisbetterwithketchup]

Thanks again, Sky.

[Skyone]

Sure thing, post if/when you need help or get confused.

[ZN13]

I'm using http://www.w3schools.com

[myersn024]

Unless you just really want to know mySQL and PHP, Visual Web Developer Express and SQL Express are a lot more noob friendly.....and free. You can build all your pages without actually having to write any code. You just have to have a web server capable of hosting ASP .NET 2.0 pages.

[lifeisbetterwithketchup]

Unless you just really want to know mySQL and PHP, Visual Web Developer Express and SQL Express are a lot more noob friendly.....and free. You can build all your pages without actually having to write any code. You just have to have a web server capable of hosting ASP .NET 2.0 pages.

Thanks for the info, but I like to do my stuff as unaided-by-software as possible.

[myersn024]

I used to be the same way until I got over the need to constantly re-invent the wheel.

[Electric Rain]

You want to use Tizag. Trust me. They have amazing tutorials. I learned what I needed to know to write something like what you're talking about in a week thanks to those tutorials.

Edit: *looks at thread creation date* Oh... Nobody ever posts in the Development Center, it seems! This thread was still towards the top... I though it was new-ish.

So, did you get it built?

[lifeisbetterwithketchup]

No, I haven't gotten around to it yet. This semester I have honors Chem, and it takes up way too much time. Also, the Dairy Queen opened last week, but I'm not going back until summer due to Chem sucking and taking all my free time.

And yeah, the Dev forum is way to slow.

[bobbypig]

GOOGLE CALENDER!
It's free, easy, and reliable...

but if you must do things your own way, I suggest php and mysql. Pretty much, you'll want your database to have the following tables (feel free to change the names):
-workers
-classes
-shifts
-assignments

columns:
workers should contain workerID, classID, name
classes should contain classID, className
shifts should contain shiftID, startTime, endTime
assignments should contain assignmentED, date, workerID, shiftID

explanation:
-workers are entered into the system so that they can be attached with assignments.
They have a class only for the site (so that when you make your php web app, only some classes can edit some data)

-classes simply pair numbers with names so that the site can display a user's class.
feel free to delete this table if it makes more sense for php to parse the classID

-Shifts identify the start and end time of a shift. You can enter many sifts with different (and even overlapping) hours so long as each shift has it's own row.

-Assignments pull everything together, allowing workers and shifts to be paired on a specific date.

with this database, you can design just about any php app to edit it (and I also recommend setting up a cron job to erase old shift data)

[Electric Rain]

Dude, seriously... a year and a half... >.>

[lifeisbetterwithketchup]

Yeah... this is a long since abandoned project.