Migration Project

I recently went through a painful process of upgrading my website to use the newest version of PHP, version 7. Before I tell you about that, let me give you a little background on what PHP is and why I use PHP.

Have you ever heard of PHP? Have you at least heard of HTML? These are both programming languages that are used to build websites. HTML is more commonly known. These two languages can work together well to make a great system. HTML is a client side language and PHP is a server side language. That means when you go to a HTML web page, the file is retrieved by your web browser (Internet Explorer, Mozilla Firefox, Google Chrome, Safari, Opera, etc.) and all of its contents are displayed to you. When you go to a PHP web page, the server that is hosting the file, like Facebook for example, interprets the file. Then the results are sent as HTML to your browser. PHP is great at communicating with a database and sending output to you. This allows the private database communication and credentials to stay on the server and only results be sent to your web browser as HTML.

When I was in college, I was in a project management class. My group was assigned a project of a organization out in the community. If I remember correctly, the organization wanted a way to track donations. Most people would think to use Microsoft Excel to track things like that. Well two problems with that, you can only access the Excel spreadsheet on one computer and only one person can access it at a time. So most of the other groups in the class, that had similar projects, decided to use Microsoft Access. Which is basically Excel on steroids. It turns the spreadsheet concept of Excel into a database management system, while still being pretty user friendly. It allows multiple people to access the database on multiple computers at the same time. That was not good enough for me. So the next step up was using a true database product and some way to communicate with it. Some example of database products are: Oracle, Microsoft SQL, and MySQL. The only one that is free is MySQL paired with PHP. I already had my own website at the time and the hosting company allows you to have MySQL databases. So I started building a tracking system for them using PHP and MySQL. The great thing about this is that it can be accessed anywhere, even outside of that organization’s office like in the field. They loved the system when we presented it to them! I am always curious if it ever got put into use. I decided I had uses of my own for a system like that.

Have you ever tried to look up a transaction in your checking account or credit card from months ago on the bank website? You really can’t unless you know which statement to go look at and that is if they haven’t “archived” your old statements. So I decided to create a tracking system for my finances using the same concept as the college project. It may seem like double work, but I enter all of my checking and credit card transactions into my own little tracking system. I am able to categorize everything for research later on down the road and it makes me be accountable for everything I spend. For example, I can go look at how much I spent on Groceries or Dining Out or Gas.

I have been using my finance tracking system for about eight years now. I recently ran into an issue with my PHP version and my hosting environment. I use GoDaddy for website hosting and I found it was cheaper to purchase three years of hosting in a new product than to renew my old hosting product for one year. I built the original systems using PHP version 5. When I setup the new hosting environment, it recommended PHP version 7. In recent versions of PHP, they have deprecated (removed support for) certain commands that I used to communicate with the MySQL database. So I either had to run my website using an old version of PHP that is not getting security updates or update my PHP programming to use the new and more secure commands to communicate with the database.

Over the years, I started tracking my credit cards along with my checking account. So I would have to copy all the files from one folder to another and then go in and update a couple commands on all of the 20 or so files. When I decided to update my PHP commands to meet PHP 7 standards, I didn’t want to do it 5 times, once for each account’s folder. I redesigned it to where I only have one folder with the true PHP files and the other account’s folders just reference the commands in the other. It took a while to update all the PHP files to use the proper commands. I did it on my laptop so that I wouldn’t have to keep downloading and uploading changes to my website until I got it right. The files all have an “account” variable. So each folder just needs one unique file that tells the files which account to query. It will be great going forward. Adding new accounts will be easy and adding features will apply to all account sites at once!

I learned a lot from my college project and personal finance project. I was able to build upon it when I got into my career in IT. Database work is one of my favorite parts of my career. It is very fulfilling to figure out just the right way to get the data someone wants out of a database.

Cisco Certified


I finally did it! I am now Cisco Certified! I passed my Cisco ICND1 exam last night which makes me a Cisco Certified Entry Network Technician (CCENT). Like I have said in previous posts, I have wanted a Cisco Networking Certification since I got into IT 11 years ago. I finally got serious about it last year. I read through the Cisco Press book, did the accompanying labs, watched countless videos and practiced what I learned on the Cisco Packet Tracer network simulator software. I believe the trick is to make sure you understand the topics instead of just memorizing everything. If I read over something that didn’t click, I would look it up or try to apply it in the network simulator to see it in action. With 4 kids and my wife in paramedic school, I just studied whenever I could get a little time here and there. Even with my many years of experience in the IT field it was still a difficult exam for me. I don’t get into network equipment everyday at my current job, so I don’t get as much hands on practice as some people do. I feel like it took me longer to prepare than most people, but I am just happy I made it! As the title implies, this is an entry level certification. I now plan to start working towards the ICND2 exam which would make me a Cisco Certified Network Associate.

Certifications: Update


I just wanted to post a quick update. It has been a while since my last post. Things have come up that kept me from being able to practice for my certification exam. I finally took a couple practice tests and I got a passing grade on the one I took tonight! So I scheduled a certification exam for Saturday. I am so excited that I just had to make a blog post about. I will make a post regarding Saturday no matter how it goes and I hope and pray it will be a celebratory post!



Ever since I got into the IT field about 11 years ago, I have wanted to get a computer networking certification. In this field, certifications mean a lot. Having a college degree is almost expected now and a certification can assure a company that you truly know your stuff. The most well recognized networking certifications are attained from Cisco. They are the largest networking company in the World. They have many levels of certifications from entry all the way to expert architect. I just want to attain the entry level certification and prove to myself that I can do it. I have heard that some people get an itch once they pass their first level exam to keep moving up the ladder. In my opinion, you really have to work with network equipment hands on everyday to be able to or need to attain the professional and expert levels. You have to re-certify or attain a higher certification every three years to be able to keep your previously attained certifications current.

I have been working hard to get through the material for the first level certification, CCENT. CCENT stands for Cisco Certified Entry Networking Technician. It is the first step to the CCNA or Cisco Certified Network Associate certification. I have been reading the book off and on for the past year. It is hard to find time with four kids! I finally finished the book about a month ago and I have finished doing all the lab work that is available with the book. All that is left now is doing practice tests and scheduling the test. The practice test software recommends you set aside two hours to take the practice test and to get rid of all distractions just like in the testing center. My wife is in Paramedic school so it is difficult to get two hours to myself without the kids.

My brother, Jonathan has passed two CCNA exams. They are many versions of the certification, the most common being Network Routing and Switching. He has the Routing and Switching and has recently gotten the CCNA Wireless certification. I would love to get both of those, because Wireless has always been an aggravating part of my job. So I am hoping that certification can help me become better friends with Wireless Networking.

I truly hope that one day soon I will have a blog post about the fact that I passed my exam and got certified. Stay tuned!

Microsoft Product Woes

Fail Error Wrong Question Mark Trouble Mistake

I recently started rolling out some computers that came preloaded with Windows 10 Professional and Office 2016 Home & Business OEM. We rolled them out earlier this month and about a week ago all 4 of them lost the ability to use their Microsoft Office Applications. I don’t know if it was an Microsoft Office update or some other issue. I tried the Quick Repair and Online Repair and both failed. I tried uninstalling Microsoft Office and running all the clean-up utilities and still I was unable to reinstall Microsoft Office 2016. I was able to get a copy of Microsoft Office 2013 to install, but that doesn’t solve the issue. I worked with Dell and Microsoft for at least 8 hours each and none of them were able to resolve the issue either. Both companies ended the conversation with recommending a fresh Windows 10 install. That wasn’t going to work for us.

So we bought a few licenses of Office 365 Premium but even that would not install. We discovered that if we uninstalled our Kaspersky Endpoint Security that we could get Office 365 to install. Then we could reinstall Kaspersky. We were never able to get Microsoft Office 2016 Home & Business OEM to install. So hopefully Dell can refund us for those licenses. My coworker is contacting Kaspersky support to try to figure out what could be causing the Endpoint Security to not allow Office to install. I just wanted to share this in case someone else comes across this same “Perfect Storm” of software products and its associated woes


Computer Brains


It has been an exciting year for computer brains or as they are more commonly known, CPUs or processors. Every computer has a processor or CPU, which stands for Central Processing Unit. Look down at your laptop or desktop and you will likely see an AMD or an Intel sticker on it somewhere. It more than likely has an Intel sticker since they have dominated the market for the last several years.

My early years in IT were spent working at Tim’s Computers in Baton Rouge. I eventually moved up to building custom PCs for the company which is my fondest memory there. I loved putting all the new computer parts together and getting to put my initials on the bottom of it. At that time Intel and AMD were fierce competitors, so I built a pretty even amount of computers using each CPU manufacturer. But at some point, Intel starting leaving AMD in the dust. I believe it was when they moved from the Pentium 4 and Pentium D to Core 2 Duo in 2007 and eventually Core i3, Core i5 and Core i7 lineup in 2010. That was when the CPU fight stopped being about how fast the CPU runs, represented by GHz or Gigahertz, and more about how many cores and threads the CPU contains. AMD became mostly only relevant in the budget PC market. If you wanted to play video games, you bought a computer with an Intel Core CPU in it.

This year AMD has come out of ashes with its new Ryzen 3, 5 and 7 CPUs to compete with the Intel Core i3, i5, and i7. They have also released their Threadripper CPU lineup which is cheaper then Intel’s top of the line desktop CPUs and even out-performs them in some cases. Intel’s top available desktop CPU has 10 cores and costs a little over $1000. AMD’s top desktop CPU costs $999 and has 16 cores! AMD is even taking on Intel’s business market with their Epyc server CPU lineup which has been dominated by Intel Xeons for a very long time. AMD’s top Epyc processor will have 32 cores. We have left the days of dual core and quad core processors being top of the line!