There are many commands in MySQL that web developers will use on a frequent basis. However, they do not use them often enough to have to commit them to memory. This is a list of MySQL commands I find myself using quite often.
Recently, I came across an issue when installing
mysql-server on Ubuntu 18.04. What I found is that after I installed
mysql-server using my standard approach of
sudo apt install mysql-server, and after running
mysql_secure_installation, my root user was denied access to MySql when trying to access with
mysql -u root -p. I would always get the following error:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'
As a web developer, it can become frustrating sometimes to deal with 301 redirects when developing website. For example, when using localhost, some of your projects might force SSL. In most cases, when forcing SSL, web servers will send a 301 response along with the redirect headers to point the browser back to https:// requests.
I was recently working on a project and found that I had to merge two very complex objects using PHP. I went to search for a solution and of course found
array_merge_recursively(). So naturally, I thought I would start out by converting my objects into arrays and using array_merge_recursively.
One thing software developers do very well is name things. Typically, after an engineer gets done developing a piece of software or a concept, they look around for a name. Quite literally, they look around at objects that are sitting near them and adopt that as the name for their new widget. If you’ve been developing anything recently, you will see many funny names. For example, I had no clue this actually existed, but I searched for “bananajs” and guess what!? Github hosts a project called BananaJS. You get my point? We know that there are many funny names for libraries, but I’ve always been intrigued by that text file the browser uses to store data about your session, the Browser Cookie! How did browser cookies get their name?
Recently, I had to figure out how to change <img> tag src using only PHP. I had to change the request from HTTP to HTTPS. I was given the task to convert a site over to HTTPS. The website is managed on Big Commerce. As we already know, when you are changing a site over to HTTPS, you have to hunt down all of the images/assets of the site and convert them to request HTTPS as well. Otherwise, you will end up with the dreaded, mixed-content error and your site is deemed as unsecured by the browser you are visiting your site from.
It was more than 10 years ago that the iPhone was first revealed. I’ll never forget learning about the ability to create apps for the iPhone while watching the 2007 WWDC Keynote. Steve Jobs talked at length about how developers would be able to contribute to the iPhone ecosphere with apps they created. Never once, however, was it mentioned that apps were to exist natively on the iPhone. Instead, Steve Jobs talked about how apps could be created for Safari (the mobile web browser bundled with the iPhone). Since then, native apps have taken over the mobile ecosystem. Web Apps never really took off like they were intended. Now, we are starting to see a decline in developers cranking out native apps. Instead developers are looking for alternative solutions to building great mobile experiences. Native apps are slowly being replaced by another type of web app, the Progressive Web App (PWA). What is a Progressive Web App you ask? Keep reading, as the intention of this article is to get you up to speed on the latest technology developers are looking at to create mobile apps.
It’s that time of year again! You need to find a gift for that programmer, software engineer, or coder in your life! You might be looking for those perfect gadgets for computer programmers, the best gifts for coders, or even funny gifts for software engineers. You’ve found the right spot! I’ve put together a collection of unique gifts for programmers that I’m sure will help you find the right gift.
Gimp is a powerful image manipulation tool. It is very similar to Photoshop! If you have been using Gimp for any amount of time, you will already know its power. It an do most things that Photoshop is capable of. Compared to Photoshop, however, Gimp lacks some features that makes life so easy when you are creating beautiful images. For example, Gimp lacks native support for converting a standard RGB images to CMYK. It becomes more of a process with Gimp! In this tutorial, I will show you how to convert standard RGB images to CMYK.
If you found this article, most likely you have become interested in the idea of making extra money as a freelance web developer. If you aren’t sure where to start in web development, you may find my article about becoming a web developer helpful. I know for me, 10 years ago I was looking to do just that. My ultimate goal was to own my own business. Web development had become my path achieving those goals. Much like you feel now, I had no clue where to start. I had several questions including even the most basic how do I get paid (do I collect a check, how do I process credit cards, etc). At that time, there were no guides I could follow. I simply had to keep forging ahead through all of my concerns and uncertainties. Becoming the freelance web developer I had envisioned was not an easy path. Mostly because I was going about it blindly. In this article, I will to provide you with that guide I didn’t have. Giving you all the tips and tricks I wish someone would have given me.