STHS Forum

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

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?

Well, it's a bug in the code. This code is for demonstration purpose only and far from being ready to be used.

So there's not way to pull age from the SQLite database?

Look here : http://sths.simont.info/DatabaseInfo.php

You have the information you need.

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?

Hi.

I add the age value for the next version (2.3.2) already. That probably why you see in PHP code then.

Awesome! Thanks Simon.

Bmoney0313 wrote:So there's not way to pull age from the SQLite database?

You can also use SQLite browser, it is very useful for working with SQLite databases