Q: Hi. I'm a PHP beginner and I need some help with PHP. Where is the best place to go and learn php and to find php help? A: PHP is a great language for web programming and it would serve you well to learn it. My first suggestion for learning PHP is to sit down with a good php book. Your best bet is to go to Amazon.com and search for PHP introductory books or books for PHP … [Read more...] about Where do I go for PHP help?
Though it positively has its uses, not everyone like phpMyAdmin for managing databases. Personally I still like to use the good old MySQL Query Browser, but when your database is hosted via cPanel, getting remote access from your local machine (e.g. your development laptop) can be a pain in the neck. I've done extensive research and while there doesn't seem to be a solid … [Read more...] about MySQL Remote Acccess via cPanel – DHCP – Dynamic IP
In this tutorial we will go over how to change the root password in MySql. Note that we are not going to use the MySql console, and like with the mysqldump command, we will be using the windows command prompt. The root password can also be changed by direct manipulation of the sql tables via the MySql console, but I believe that the method in the video below (using the … [Read more...] about How to Change the Root MySql Password in Windows (video)
One of the most important things we do as web developers is test websites. While it’s easy to test static .html pages on your local development machine, it’s not as easy to test dynamic pages without some tweaking first. In this tutorial I will review how to quickly and easily setup a PHP/MySql development environment on your local PC using WAMPSERVER. For this tutorial I … [Read more...] about How to Setup a Local PHP/MySql Test Environment with WAMPSERVER
I've been working with mysql/php for many years, and although there is no substitute for the command line when it comes to certain tasks (like running mysqldump), there are a few MySql GUI programs that I use for almost all of my mysql database development. I've tested many commercial products, but in the end I still wind up using these free GUI tools for MySql … [Read more...] about Free MySQL GUI tools for Database Development and Maintenance