Project #23: Recreating the GurenCodes page out of SQL data that is fetched from the database at page load

aircraft airplane azuki-iro black_hair blue_impulse_(team) blue_sailor_collar blunt_bangs brown_eyes fighter_jet hair_ribbon hatsuyuki_(kancolle) highres hime_cut holding holding_umbrella kantai_collection long_hair military military_vehicle neckerchief red_umbrella ribbon sailor_collar school_uniform serafuku tress_ribbon umbrella

Link

Estimated date of creation: May 12th, 2025

Status: Online 🟢

Is it annoying you how I’m breaking these projects up into little pieces? One could say that a single project should be an entire major website made, or a massive app made, and little side projects shouldn’t be included. However, this was a major step for me. This may be the first time I’ve used SQL for anything practical before. And I had to learn how to route PHP’s MySQLi driver to communicate between PHP, HTML, and SQL.

This main homepage is currently just typed out in text as HTML. It just sits in an HTML file. It’s not fancy. What was cool about this homepage was that I used Bootstrap and had put this on a server. But what’s cool about this other project is that I learned PHP, SQL, and MySQLi in order to use it. As of this writing, I only put two tables on the page, and other than that the page is a remake of this page you’re already on, but the table is entirely scraped out of PHP and SQL code. A PHP file tends to contain a bunch of HTML code that just is left untouched and treated like an HTML file. But in this case, we echoed out entire tables worth of data, that was sitting in a database, that was written into the HTML file by the PHP. I think that’s cool.

The other thing is that this is a major step, because now that I know how to pull data out of a database and display it on a webpage, I can soon make a modern changing mechanical sort of site like Reddit or Newgrounds or something.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *