Category Archives: MySQL

What I’m Proud Of

So, I have a B.A. from one university and I completed 10 of 12 classes toward a Master’s (I stopped going when my former employer stopped paying) at another but I never put a bumper sticker on my car for … Continue reading

Posted in myLearning, MySQL | Tagged | Leave a comment

Fine. One bite and baby step at a time.

Tasks Script gets Artist Name and ID from Spotify and puts into artist table that stores IDs and Names. Script gets Artist(s) popularity for day one and puts it into artistPop table that has, in each row: a datetime stamp, artist id, and … Continue reading

Posted in Databases, MySQL, Spotify | Leave a comment

So I’m Good Then

“Golly,” I thought to myself, “if my request(s) return 470 rows of data just for Alice Cooper, and I have a few other artists for whom I want to store data, and I’m considering a different table for each item’s popularity … Continue reading

Posted in MySQL | Leave a comment

Resuming PHP Schooling

I’m always thinking, “I should finish my Presidents project,” but always putting it off because there’s something more urgent like FreeCodeCamp, Codecademy, CS50, etc. but today I decided to do something fun, productive, etc. and not stress out about that … Continue reading

Posted in myProjects, MySQL, PHP | Leave a comment

Creating a MySQL Database with PHPMyAdmin

I need forms for, among other things, users to enter character information but that information also needs a home after leaving the form so, first, I’ll create a database using MySQL. MySQL is free as is PHPMyAdmin, the handy interface … Continue reading

Posted in MySQL, PHP | Leave a comment

Pretty Presidents

Not sitting presidents, but presidents sitting pretty. Bathed my presidents in Bootstrap (with some jQuery bathsalts) today and learned more than expected. I started with just a little jQuery to give my form fields focus: I couldn’t stop there and … Continue reading

Posted in Bootstrap, jQuery, MySQL | Tagged | Leave a comment

PHP President Parade o’ Victory

I knew I’d seen PHP and HTML code mixed together. I’ve seen PHP code create HTML tables for displaying results from a database. My form for inputting presidents is a .htm file so, naturally(?), that was the file format I … Continue reading

Posted in MySQL, PHP | Tagged | Leave a comment