Php & mysql
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. How to Edit the Hosts File Mac OS X Snow Leopard | DotResults
13 Useful WordPress SQL Queries You Wish You Knew Earlier | Onextrapixel - Showcasing Web Treats Without A HitchWordPress 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.
Just because someone asked, here’s a quick way to find and replace content in MySQL using PHPmyAdmin. This technique works the same command line, and it’s possible it works similar in applications such as Navicat, but I have little experience in GUI tools. To manage: Login to PHPmyAdmin Select the database you want in the left frame, if you have multiple Choose the ‘SQL’ tab in the right frame Add the following code and updateUPDATE `table` SET tablefield = replace(tablefield,"your mom","my mom"); Replace table with the name of your table, the tablefield with the title of the tablefield you want to search, the first value (your mom) will be replaced by the second (my mom). The Blog of Brady J. Frey + How to find and replace in MySQL PHPmyAdmin