The following warnings occurred:
Warning [2] Undefined variable $unreadreports - Line: 26 - File: global.php(961) : eval()'d code PHP 8.2.25 (Linux)
File Line Function
/global.php(961) : eval()'d code 26 errorHandler->error
/global.php 961 eval
/showthread.php 28 require_once





× This forum is read only. As of July 23, 2019, the UserSpice forums have been closed. To receive support, please join our Discord by clicking here. Thank you!
UserSpice   ›   Miscellaneous   ›   Modifications and Hackery   ›   Retrieving data from database

  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Retrieving data from database
mudmin
Lead Developer
*******
Joined: Dec 2015
Posts: 2,285

Reputation: 17
#11
01-04-2019, 10:22 AM
Absolutely. Happy to help. If any of it doesn't make sense, let me know. I can help with the sign up or whatever you need.
  Reply
LBC
User
Joined: May 2016
Posts: 152

Reputation: 0
#12
01-04-2019, 10:39 AM
(01-04-2019, 10:22 AM)mudmin Wrote: Absolutely. Happy to help. If any of it doesn't make sense, let me know.  I can help with the sign up or whatever you need.

How would I go about it to get it like this:

Monday: 4
Tuesday: 6
Wednesday: ..
Thursday: ..
Friday: ..
Saturday: ..
Sunday: ..

Is there a line of code that i can just paste anywhere?
  Reply
mudmin
Lead Developer
*******
Joined: Dec 2015
Posts: 2,285

Reputation: 17
#13
01-04-2019, 10:42 AM
Sure. Get rid of the entire table from <table to /table and paste this
https://pastebin.com/n0v0hQTC
  Reply
LBC
User
Joined: May 2016
Posts: 152

Reputation: 0
#14
01-04-2019, 10:44 AM
Wow! So simple...geeze Blush 

I'll definitely get back to you for that sign up, but I'm going to try it by myself first.

Thanks again mudmin!
  Reply
mudmin
Lead Developer
*******
Joined: Dec 2015
Posts: 2,285

Reputation: 17
#15
01-04-2019, 10:45 AM
Sure. No problem at all. And that's definitely the benefit of defining the days and writing that function. Once you have it, you can really do whatever you want with it.
  Reply
LBC
User
Joined: May 2016
Posts: 152

Reputation: 0
#16
01-10-2019, 09:12 AM (This post was last modified: 01-10-2019, 09:13 AM by LBC.)
Hello Mudmin,

Would it be possible to drop the weekday and just display the number of that particular weekday somewhere?
Like...hide the weekday or something?

I would like to display the number of spots available in a table.
Something like this:

Day                 | Time     | Activity | Spots available
Wednesday     | 19:00   | yoga     |  3
Friday              | 10:00   | yoga     |  5
  Reply
mudmin
Lead Developer
*******
Joined: Dec 2015
Posts: 2,285

Reputation: 17
#17
01-10-2019, 09:23 AM
Let me see if I can help you a little better.
When I see that table, you're going from Wed to Friday. Are you saying that you want to only show days that have availability?

So Thursday has no days available, so it's skipped?

Also, do you expect to have multiple activities?
  Reply
LBC
User
Joined: May 2016
Posts: 152

Reputation: 0
#18
01-10-2019, 09:43 AM
no no, this was just a quick example.

It should be all days of the week...showing availability of each weekday.
And yes, there will be several activities (Eventually). I will have to add extra columns to the users table for that.

What would be great if I could just echo the availability numbers of any particular event anywhere i want Smile
  Reply
mudmin
Lead Developer
*******
Joined: Dec 2015
Posts: 2,285

Reputation: 17
#19
01-10-2019, 09:58 AM
Ok. So the way you're doing it will make it a little trickier to be more dynamic. Like what if you don't want to offer any dodgeball on Sundays or something like that? Do you want help making it dynamic?
  Reply
mudmin
Lead Developer
*******
Joined: Dec 2015
Posts: 2,285

Reputation: 17
#20
01-10-2019, 09:59 AM
(01-10-2019, 09:58 AM)mudmin Wrote: Ok.  So the way you're doing it will make it a little trickier to be more dynamic.  Like what if you don't want to offer any dodgeball on Sundays or something like that? Do you want help making it dynamic?

Or I can just write the function to edit the table.
  Reply


Forum Jump:


Users browsing this thread: 4 Guest(s)