Working some PHP & mySQL magic here. :)

Claire’s accomplishments from this week.

• Built a mySQL database in two ways (1. Using mySQL’s built-in command line, 2. Through a PHP function stored inside a variable)
• Connected PHP input to the mySQL database, and wrote functions that would echo confirmation
• Built a mySQL table and assigned the fields (whether it was primary key, null, etc.) through PHP exclusively
• Created a front-end user-friendly UI for other employees in the company to use 🙂

Below is just test material. The real form is more detailed than this, but I just created a database that would accept “First Name”, “Last Name”, and “Age” as fields. So, office workers will never have to touch PHP code, or mySQL syntax to update the database, thanks to my front-end UI form! （´・ω・｀）I’m feeling really proud. Or maybe its just that day-old scone I ate…..

Basic front-end UI for the other employees to use. This was just a test form, the real database will have document name, date of creation, directory, etc.

Graphic Design & Magazine Editing

You can check out my inter-collegiate fashion & lifestyle magazine at http://www.dahliachic.com

Be sure to like us on facebook, and follow our social media!
http://www.facebook.com/dahliachicmagazine
http://www.instagram.com/dahliachic
http://www.twitter.com/DahliaChic
http://www.tumblr.com/blog/dahliachic

The graphic design work below is some of my handiwork from Issue #5 of Dahlia Chic Magazine.

This was a garden photospread of a photography team called La Femme Lazar, in San Diego. I also shadowed them for a day pretty recently , and have lots of video footage going up on Dahlia Chic’s youtube channel soon!

This was an article from a student at NYU. I did the graphics work for her piece on fashion inspired by classical artwork.

And of course, here is the cover of issue 5. We’re hoping to get some physical copies of the magazine printed soon! 🙂

Building my first mySQL database!

Just made a break-through. I’m learning the basics of building a MySQL database. Now what can I do with it?

Spent the morning at work understanding and getting acquainted with MySQL 5.6’s Command Line Client. It feels just like DOS so I wasn’t intimidated. Its just a matter of getting familiar with MySQL’s custom syntax. I wanted to build a basic database with two tables, just to show a proof of concept to my boss, before I dig into relational tables, and relational databases (oh my, I’m going to need some more coffee for this!).

Just needed something basic, with information I could populate and re-arrange. I figured that my favorite gangster rap artists, their albums, and distribution year would not be appropriate for the workplace, so I created some fields for senators from the 2013 U.S. House of Congress.

“We approve of this decision, Claire.”

This geeky collision of government, and programming is a result of being addicted to “House of Cards” recently. Let’s see how much I can build on this.