Editing MySQL Data Using PHP and the MySQLi Libraries

This tutorial is going to show you how to retrieve results from a database using PHP, then edit the row and save it back to the database. If you haven’t followed our other tutorials you might want to check out: Reading from a MySQL Database Using PHP and MySQLi Inserting Data Into a MySQL Database … Read more Editing MySQL Data Using PHP and the MySQLi Libraries

Inserting Data Into a MySQL Database Using PHP and MySQLi

This tutorial will show you how to insert data into a MySQL database using the latest MySQLi PHP libraries. This tutorial will replace our older tutorial on MySQL libraries and that post will redirect here in the future. Assumptions First, we will assume you have PHP, MySQL, and Apache running. I use MAMP for my … Read more Inserting Data Into a MySQL Database Using PHP and MySQLi

How to Push from Your Local WordPress Development Environment to Production

cpanel and local by flywheel

This tutorial assumes you have set up a local development environment using Local by Flywheel. Next, we will make a change to our local environment and push that change to our production environment. If you use Flywheel’s hosting this is dead simple. However, we’re using a dedicated server with cPanel so the process is a … Read more How to Push from Your Local WordPress Development Environment to Production

Reading from a MySQL Database Using PHP and MySQLi

mysqli php database tutorial

I had some old tutorials out there that use outdated PHP libraries to access a MySQL database. I wanted to update these to use the latest PHP library called MySQLi. MySQLi is the improved database driver for use in the PHP scripting language to provide an interface to MySQL databases. It replaces both PHP’s MySQL … Read more Reading from a MySQL Database Using PHP and MySQLi

Get the Best WordPress Hosting from Flywheel

get flywheel wordpress hosting

When it comes to hosting for your WordPress site there are a plethora of options out there. From traditional shared hosting, VPS, and dedicated servers to more advanced WordPress specific hosts. Choosing the best WordPress hosting can be a tough decision. Hopefully, we can make that decision easier for you with our review of Flywheel … Read more Get the Best WordPress Hosting from Flywheel

Copying a Production WordPress Site to Your Local Dev Environment

In a previous tutorial, I talked about Create a Local WordPress Installation Using Local by FlyWheel. Today we take that one step further and we will back up a live WordPress site to our local environment. This will give us a mirror of our live WordPress blog to do development on. Download and Install Local … Read more Copying a Production WordPress Site to Your Local Dev Environment

Awesome Black Friday Giveaways from WordPress Vendors

Many WordPress related companies are giving away amazing prizes for Black Friday this year. Not only can you anything from an iPad to a Mac Pro but these vendors also have some amazing deals going on for their WordPress Products. No Purchase is required to enter any of these Giveaways … They’re 100% FREE Win … Read more Awesome Black Friday Giveaways from WordPress Vendors

Create a Local WordPress Installation Using Local by FlyWheel

In in this tutorial we’re going to set up a local WordPress installation on our desktop environment for testing and development purposes. This installation is going to be an out-of-the-box WordPress installation with the default files and a new database. We’re going to use a newer tool called Local by FlyWheel. Local is a tool … Read more Create a Local WordPress Installation Using Local by FlyWheel

How to Setup a Local Development Environment for WordPress

Are you developing a WordPress site but want to make changes locally before applying them to your live site? Tired of breaking things in production? This tutorial will help you set up a local development environment for your WordPress site on your Mac or Windows desktop. We’ll also show you how to backup and import … Read more How to Setup a Local Development Environment for WordPress

How to parse a CSV file using ruby

Here’s a simple tip on how to parse a comma separated value or CSV file using ruby. Ruby has a standard library available that makes this task very simple. All we need to do is open a CSV file, read it, and parse it using the CSV parser that comes with ruby. Let’s say we … Read more How to parse a CSV file using ruby