NoID10ts
aka Noddy
Are any of you PHQ/MySQL wizards?
-
OK, it's on.
PHP/MySQL
- Thread starter NoID10ts
- Start date
Cybernetist
Member
- Local time
- Today 12:29 AM
- Joined
- Apr 30, 2008
- Messages
- 37
- Location
- The Great White (Barely) North.
Wizard? No, but I can get by with anything I can find with Google.
What are you trying to do ?
What are you trying to do ?
Artifice Orisit
Guest
Novice, but formally educated in their usage.
Razare
Well-Known Member
I've used both before. The problem with that stuff is once you're out of it for a while you forget the details. I could pick it up again pretty easily, but no, I wouldn't be a wizard presently.
I do recall getting apache + mySQL + php all working harmoniously on windows was difficult.
I do recall getting apache + mySQL + php all working harmoniously on windows was difficult.
EloquentBohemian
MysticDragon
Apache + mySQL + php work so much better on Unix. I had to shift to Unix on my ISP when I uploaded Wordpress for the blog part of my site.
What's your problem with php/mySQL, Noddy?
What's your problem with php/mySQL, Noddy?
NoID10ts
aka Noddy
Your new avatar is disturbing as hell, EB. 
Man, I forgot I created this thread. I'm mainly just being lazy, I think I can figure it out, but I thought that maybe someone with a lot of expertise could save me some time.
I work at a middle school and a couple of years ago I created an employee portal using mainly php/mysql. I had no prior experience with php/mysql, but the school bought me some books and I muddled through it. It may not be pretty, it may not be up to proper coding standards, but it works like a charm and that's all I care about.
One of the parts of the portal is a computer lab reservation form. The way it works is there is a list of available dates, the available class periods for each date, and a little box that says "Reserve" for each period. All they have to do is click "Reserve" and it inserts their username in that slot.
I also programed it so that it compares the usernames in the reserved slots and the currently logged in user and where there is a match they can delete their reservation. This way they can only delete their own reservations and no one elses. Of course, being a form of a God, I have the ability to delete everyone.
Here's what it looks like:
Now the only problem I have is that the teachers started complaining that some people were either reserving huge blocks of time, were only reserving so they could babysit (just let the kids play games), or they wouldn't show up for the reservation which left an open lab that could be used by someone else.
Therefore, I need to design a way to limit the number of reservations to 15 periods at a time. This will eliminate the mass reservations, and force them to really consider whether they need it or not, since they have a finite number of reservations.
It will have to take into account the present day and all days beyond it, but not past days. If the count goes over 15, it should give them a message like "You have exceeded your alloted number of reservations."
I think this should be easy, but it's been so long since I did this. Here's the present code (don't laugh, geniuses, like I said, it works):
Man, I forgot I created this thread. I'm mainly just being lazy, I think I can figure it out, but I thought that maybe someone with a lot of expertise could save me some time.
I work at a middle school and a couple of years ago I created an employee portal using mainly php/mysql. I had no prior experience with php/mysql, but the school bought me some books and I muddled through it. It may not be pretty, it may not be up to proper coding standards, but it works like a charm and that's all I care about.
One of the parts of the portal is a computer lab reservation form. The way it works is there is a list of available dates, the available class periods for each date, and a little box that says "Reserve" for each period. All they have to do is click "Reserve" and it inserts their username in that slot.
I also programed it so that it compares the usernames in the reserved slots and the currently logged in user and where there is a match they can delete their reservation. This way they can only delete their own reservations and no one elses. Of course, being a form of a God, I have the ability to delete everyone.
Here's what it looks like:
Now the only problem I have is that the teachers started complaining that some people were either reserving huge blocks of time, were only reserving so they could babysit (just let the kids play games), or they wouldn't show up for the reservation which left an open lab that could be used by someone else.
Therefore, I need to design a way to limit the number of reservations to 15 periods at a time. This will eliminate the mass reservations, and force them to really consider whether they need it or not, since they have a finite number of reservations.
It will have to take into account the present day and all days beyond it, but not past days. If the count goes over 15, it should give them a message like "You have exceeded your alloted number of reservations."
I think this should be easy, but it's been so long since I did this. Here's the present code (don't laugh, geniuses, like I said, it works):
Last edited:
Artifice Orisit
Guest
Just tell them to f**k off and stop bothering IT staff with HR issues.
Razare
Well-Known Member
When they activate a button by clicking on it, perform a loop search that goes through the entire list of reservations. Have it count the number of times their user name appears and if it exceeds 15, cancel out of the reservation process and just display text at the top of the page or some such saying they're at their limit.
I don't have a PhP editor currently and trying to view that stuff without formatting is impossible, but that's the basics of what should be done.
I don't have a PhP editor currently and trying to view that stuff without formatting is impossible, but that's the basics of what should be done.
Razare
Well-Known Member
Well let me put a disclaimer on that. That's the solution if your list is only a few hundred units long. Since they can reserve weeks in advance, I presume, you may have a list of many thousands of units. If this is the case you may want to store data containing the number of reservations for each user, incrementing and decrementing as necessary. That's the more efficient solution if it's large.
NoID10ts
aka Noddy
I know what needs to happen, I'm just wondering if anyone knows what the code would actually look like.
Off the top of my head it would be something like:
If userid = current user
then count all occurences from today's date, and beyond
create variable with that number
If variable > 15 then echo "you have exceeded your allotted number of reservations"
I'm just not sure of the correct verbage to make this happen, nor where I need to insert it into the code I posted previously.
I'll figure it out, but like I said before, I'm lazy. Or am I too busy to get to it? I don't know.
And Cog, I wish I could say something like that, but I actually am a school administrator, so there is an hr component to my job especially where computers and computer labs are concerned. I even have to do a bit of training at times.
Off the top of my head it would be something like:
If userid = current user
then count all occurences from today's date, and beyond
create variable with that number
If variable > 15 then echo "you have exceeded your allotted number of reservations"
I'm just not sure of the correct verbage to make this happen, nor where I need to insert it into the code I posted previously.
I'll figure it out, but like I said before, I'm lazy. Or am I too busy to get to it? I don't know.
And Cog, I wish I could say something like that, but I actually am a school administrator, so there is an hr component to my job especially where computers and computer labs are concerned. I even have to do a bit of training at times.
Artifice Orisit
Guest
Aww that sucks all the fun out of being a bad employee, but at least you're trying to ego trip random people into doing your work for you.
*two thumbs up and a broad smile on his face*
Way to go!
Felan
Prolific Member
- Local time
- Yesterday 11:29 PM
- Joined
- Apr 20, 2009
- Messages
- 1,064
- Location
- Unauthorized personnel only
Let me preface with I'm familiar with .NET and SQL Server.
Looping in code or keeping a field in the database to track that information seems unnecessary when most SQL implementations offer date comparisons and count function, I would be hard-pressed to believe MySQL lacks these. If the query returns a count that is 15 or greater for the logged in user than display a message and disable the Reserve buttons so they don't get a chance to click any of them.
Additionally you can re-use the function to quickly verify that they don't have 15 reservations in the database. So if they did circumvent your protection (multiple sessions or javascript hacks) you would catch it server side and deny them there.
Looping in code or keeping a field in the database to track that information seems unnecessary when most SQL implementations offer date comparisons and count function, I would be hard-pressed to believe MySQL lacks these. If the query returns a count that is 15 or greater for the logged in user than display a message and disable the Reserve buttons so they don't get a chance to click any of them.
Additionally you can re-use the function to quickly verify that they don't have 15 reservations in the database. So if they did circumvent your protection (multiple sessions or javascript hacks) you would catch it server side and deny them there.
Last edited:
"SELECT * FROM lab103 WHERE AMTutorial='".$_SESSION('MM_Username')."' OR PMTutorial='".$_SESSION('MM_Username')
etc etc. for SPARK et al.
Maybe you can store the field names in an array and iterate through a for loop to build the query.
add your date requirements in the query, count the rows in the recordset (sorry I don't know what the mysql term is, I used to use ADO, the old one). Why'd that be hard? Make the DBMS do the work.
Or maybe I didn't really understand your question, I'm a little rusty, sorry. Speed shouldn't be that much of a concern, right?
etc etc. for SPARK et al.
Maybe you can store the field names in an array and iterate through a for loop to build the query.
add your date requirements in the query, count the rows in the recordset (sorry I don't know what the mysql term is, I used to use ADO, the old one). Why'd that be hard? Make the DBMS do the work.
Or maybe I didn't really understand your question, I'm a little rusty, sorry. Speed shouldn't be that much of a concern, right?