Skip to main content

Fun with MySQL + PHP

Lately, I've been getting a lot of requests to build websites driven by lots of data, so I've been reading heavily into MySQL and PHP. I've been relying "Beginning PHP and MySQL: From Novice to Professional, Third Edition" by W. Jason Gilmore. I was concerned with his use of connecting to MySQL with a plaintext user name and password, so I went through a few tutorials online:

[hvassing.com]

[studiolounge.net]

and the SQL reference manual: [dev.mysql.com]

Of course, they did the same thing. I'm working on trying to implement an SSL solution to login, but unfortunately I think it'll require an X.509 certificate.
Labels:

Comments

Post a Comment

Popular posts from this blog

Software Design Principles - SOLID

The SOLID software design principles weren't called SOLID while I was in grad school, but the concepts were there in my Object Oriented Design course. They're worth mentioning here, primarily because I think once you start coding and become dangerous, it's one of the best ways to stay organized once you incorporate it into your daily coding routines, and it even changes your way of thinking for the better: https://en.wikipedia.org/wiki/SOLID
Post a Comment
Read more

reveille and caelumvox.com are live!

As part of a series of projects I'm putting together in an online portfolio, I created reveille (reveille.caelumvox.com) , a website that shows articles of local websites inserted by an AWS Step Function job whose lambdas scrape the website and load it into a MariaDB instance. Some details: The Step Function Lambdas are written in Python, The backend API is written in the Express Node Framework, The frontend app is written in the Angular Node Framework using bootstrap for frontend styling and placement for desktop and mobile browsing. To keep costs low, the frontend, backend, and database are all hosted on one EC2 instance. The frontend and backend are hosted by the same nginx container with a Let's Encrypt certificate. I also created a home page at caelumvox.com as a starting place for visitors, but it still needs a bit of work. The site is hosted on an AWS Cloudfront distribution. HTTPS only!
Post a Comment
Read more

The TL;DR guide to git

While in the past I've held a pretty high opinion to using mercurial for version control, the majority of version control these days seems to done in git.  Here were the commands I found most useful to get productive with git right away. # Clone a repository from an origin, i.e. my github MaskingUtils repository git clone git@github.com:caelumvox/masking-utils.git # Add a file after it's been updated to stage it for commit, or add a new file git add filename # Commit the file to local repo git commit # Push the file to the origin so the rest of the team can see it git push # List all locally tracked branches git branch git branch --list # Get a list of all branches from the remote git branch -r # Create branch locally git branch develop # Push the branch to the origin repository to make sure it is tracked there git push --set-upstream origin develop # Pulls latest from all local branches tracked from origin; won't pull non-tracked branches git pull --all # Fetch the branch ...
Post a Comment
Read more