2004-09-23
More PHP/MySQL
Hey, I got something working! :) I found another great tutorial, which you can look at here, and I talked to some of my #c-64 friends who know more about this stuff than I do.
Last time, I was wondering how to create the database that my PHP program would read from psw.ca. It ended up being really easy - my web host provides a control panel where I do things like create email accounts and stuff. Turns out I can just go in there and click "Databases" and make one in there! Then I was wondering about how to actually create the table and columns (like, the different fields that the data will go into, like MovieName, Description, etc.). My #c-64 friends suggested installing a program called PHPmyAdmin. I started working on that - it ate more than 6 MB of my web space - and then I realized it's already installed by my host. :)
PHPmyAdmin is a really nice GUI front-end where you can just click in fields and press buttons and make your database. Much much easier than writing little snippets of PHP code and uploading them and running them through the web browser.
So, I created the database and populated it with just the game names list I've compiled (I'll be adding more info later). Then I re-worked a PHP example from the tutorial I mentioned above, and here it is - the same list, but this time generated from a database! :)
Movie Games List
Yeah, yeah, it just looks like the same list from a couple blogs ago. The neat thing is all the potential this offers... next time I'll try to have it doing something slightly interactive.
Last time, I was wondering how to create the database that my PHP program would read from psw.ca. It ended up being really easy - my web host provides a control panel where I do things like create email accounts and stuff. Turns out I can just go in there and click "Databases" and make one in there! Then I was wondering about how to actually create the table and columns (like, the different fields that the data will go into, like MovieName, Description, etc.). My #c-64 friends suggested installing a program called PHPmyAdmin. I started working on that - it ate more than 6 MB of my web space - and then I realized it's already installed by my host. :)
PHPmyAdmin is a really nice GUI front-end where you can just click in fields and press buttons and make your database. Much much easier than writing little snippets of PHP code and uploading them and running them through the web browser.
So, I created the database and populated it with just the game names list I've compiled (I'll be adding more info later). Then I re-worked a PHP example from the tutorial I mentioned above, and here it is - the same list, but this time generated from a database! :)
Movie Games List
Yeah, yeah, it just looks like the same list from a couple blogs ago. The neat thing is all the potential this offers... next time I'll try to have it doing something slightly interactive.
