Hey.
Since I start building the SQLite database, I create some PHP webpage leveraging the SQLite database information for my own pleasure and personal challenge. Today, I upload them on GitHub where you can read them, copy them and even fork them. In the long run (After a lot more work), I’ll probably add some of them directly into the STHS default website.
If you want to contribute to the code directly in repository, please contact me by email so we can discuss about it.
Link : https://github.com/SimonT-STHS/STHS-PHP-Code
SimonT STHS PHP Code for SQLite
-
- STHS Owner / Propriétaire du STHS
- Posts: 14785
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
SimonT STHS PHP Code for SQLite
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
-
- New in Town / Le Ptit Nouveau
- Posts: 43
- Joined: Tue Jun 19, 2012 1:25 pm
Re: SimonT STHS PHP Code for SQLite
In the PlayerInfo.php file you have an echo from PlayerInfo table column 'Age'. I'm not seeing that column at all in the database that I created from the demo nor the database from the league I'm in. Is there a setting somewhere within STHS to output the Age column to the SQLite database?
-
- STHS Owner / Propriétaire du STHS
- Posts: 14785
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: SimonT STHS PHP Code for SQLite
Well, it's a bug in the code. This code is for demonstration purpose only and far from being ready to be used.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
-
- New in Town / Le Ptit Nouveau
- Posts: 43
- Joined: Tue Jun 19, 2012 1:25 pm
Re: SimonT STHS PHP Code for SQLite
So there's not way to pull age from the SQLite database?
-
- STHS Owner / Propriétaire du STHS
- Posts: 14785
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: SimonT STHS PHP Code for SQLite
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
-
- New in Town / Le Ptit Nouveau
- Posts: 43
- Joined: Tue Jun 19, 2012 1:25 pm
Re: SimonT STHS PHP Code for SQLite
Yeah I see the birthday is in the database but there's nothing in the database that actually has the age of the players? I guess I would need to find some SQLite 3 formula to take today's date and figure out the difference in years?
-
- STHS Owner / Propriétaire du STHS
- Posts: 14785
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: SimonT STHS PHP Code for SQLite
Hi.
I add the age value for the next version (2.3.2) already. That probably why you see in PHP code then.
I add the age value for the next version (2.3.2) already. That probably why you see in PHP code then.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
-
- New in Town / Le Ptit Nouveau
- Posts: 43
- Joined: Tue Jun 19, 2012 1:25 pm
Re: SimonT STHS PHP Code for SQLite
Awesome! Thanks Simon.
Re: SimonT STHS PHP Code for SQLite
You can also use SQLite browser, it is very useful for working with SQLite databasesBmoney0313 wrote:So there's not way to pull age from the SQLite database?