background preloader

Php & mysql

Facebook Twitter

Peach. PHP Manual. How to Edit the Hosts File Mac OS X Snow Leopard | DotResults. There are times during DNS changes or other testing that you may want to specify a particular IP for a domain name. To do this, you’ll need to edit your hosts file. This way you can “trick” your computer before DNS actually changes or point a domain to another IP, even a local one. Some of the instructions out there on how to do this are a little too bloated, so I tried to simplify them as much as possible here on DotResults. If you have any questions about this, please leave a comment and we’ll get back to you as soon as we read it. 1. Open Terminal 2. 3. 4. 5. 6. 13 Useful WordPress SQL Queries You Wish You Knew Earlier. WordPress WordPress is driven by a MySQL database.

This is something active WordPress users would know. However, if you only just read about it here from us, here’s what you should know. MySQL is a free relational database management system available in most web hosting services. All of the WordPress data like the posts, comments, categories, and settings are stored within the MySQL database. If you wish to read up more about MySQL, you can take a look at WordPress’s Database Schema. For example, if you needed to change some information across the board in WordPress, going through each record is very time consuming and prone to human error. Shown below are some SQL queries that can be of great assistance to you when using WordPress. Backup your WordPress Database Before you proceed with any changes, be sure to backup your database. You can download WP-DB-Backup or WP-DBManager plugin to backup your database through your WordPress admin panel. 13 SQL Queries for WordPress Solution:

The Blog of Brady J. Frey + How to find and replace in MySQL PHPmyAdmin.