Categories
Coupons and Promo Codes Hosting Tips & Deals My Personal Reviews

RackSpace Cloud Hosting Launched!

the rackspace cloud

Dating back 1 or 2 years ago when RackSpace acquired Mosso, it has long been preparing to start its own cloud hosting business. Now here it is, Rackspace has officially launched the RackSpace Cloud from Mosso:

http://www.rackspacecloud.com

All hosting service packages remain fundamentally the same with those of Mosso: Cloud Sites, Cloud Servers and Cloud Files. While the old company Mosso’s domain mosso.com goes under, all existing traffic is being redirected to the new RackSpace domain rackspacecloud.com.

I’m currently hosted on their Cloud Servers plan, a great deal considering the fact that you really don’t need much support at all because of their remarkable network and underselling hardware. You can feel the responsiveness and robustness when you are developing and debugging on their servers.

However on the other hand, I don’t have any experience with Cloud Sites, one of the best high end cloud hosting you can find anywhere, I guess. The ultimate benefit is the ease to scale, use whatever you need at any time without having the hassle to move things around and interrupting website performance.

Well, here’s a coupon promo code of RackSpace cloud: (Reveal Code) should it interests you to give cloud sites a try. They have a 30-day unconditional money back policy and with the coupon you can still cancel anytime in the first 30 days to get a full refund. So absolutely nothing to worry about.

If you do go with them, feel free to leave a review of Rackspace cloud and let more people know how they come out.

Categories
Linux Server Administration Tips SQL / MySQL Tips and Tutorials

How to Recover or Reset MySQL root Password after You Forgot and Lost It

MySQL has come with a safe mode wherein access privileges are not checked, which essentially enables you to log in anonymously to change anything in any database.

And we are going to get in this safe mode to reset the lost MySQL root password.

  1. First, you need to stop the current MySQL daemon by:
    /etc/init.d/mysql stop
  2. Then you can start the safe mode of MySQL and skip privileges check by:
    mysqld_safe --skip-grant-tables &
    The & in the end gets it to run in the background so we can continue to reset the root password.
  3. Now you can log into the MySQL server anonymously (well not anonymously but without privilege check):
    mysql --user=root mysql
  4. And reset the root password by updating the user table of the mysql database:
    UPDATE user SET Password=PASSWORD('newrootpwd') WHERE user='root';
    FLUSH PRIVILEGES;
  5. Get out of the safe mode and restart the normal MySQL daemon:
    /etc/init.d/mysql restart
  6. At last, you should be able to connect to the database server by your new root password.

As always, you will have to log in as root of the entire server or you won’t be able to stop the MySQL daemon and start the safe mode in the first place.

Note that I’m recovering the root password of MySQL in Ubuntu 9.04 Jaunty with MySQL installed by aptitude. Specific procedures may vary distribution by distribution but I’m sure the fundamental logic remains the same: getting in the safe mode to reset the root password.

Categories
PHP Tips & Tutorials Web Applications & Online Software

Work Around Zend Studio 5.5 PHP Class / Object / Method Auto-complete Problem

Don’t know if it’s a glitch of Zend itself but I frequently encounter this problem on Windows with Zend Studio when writing PHP. Function / object methods names auto-completion saves a lot of time by suggesting candidates and a quick flyover tooltip with the synopsis, however sometimes it doesn’t work with newly created functions and object methods. It’s really annoying and it severely damages your productivity in that you have to check manually the usage of a function or object method yourself by switching to other file tabs.

Enough is enough.

Up to my god damn instinct, I tried to unload the current project by ‘Project‘ => ‘Close Project‘ and load it again by ‘Project‘ => ‘Open Project‘ => select the php project file *.zpj (eg. project.zpj) then ‘Open‘.

No, that’s not all.

The key is that it’s a different project.zpj file that you should be opening, rather than the erroneous one that’s having problems with auto-completion. The new Zend project file project.zpj is just created according to the configurations of the previous one and pointing to the same directory containing your php codes.

Therefore, you are very probably going to have to create a new project file pointing to the same directory containing your php project and then load it instead.

Now that’d solve the issue.

Categories
Client Side Coding Books CSS & HTML Tips Web Design Tips and Insights

Best CSS Books to Learn CSS Web Design

While HTML is the concrete of all web pages and websites, CSS is the spirit. It specifies the aesthetic aspect of all the web pages by design through presentation, conveying the ideas and sensations by visual languages. The first class of all web designers start with CSS.

These are some of the best CSS books out there reviewed indispensable for those who want to be a web designer or / and developer.

Web Developers / Designers’ Books:

  1. Best HTML Books
  2. Best CSS Books
  3. Best JavaScript Books
  4. Best PHP Books
  5. Best MySQL Books
  6. Best Linux Books
  7. Best Apache Books (mod_rewrite Books)
  8. Best Web Hosting Books

CSS: The Missing Manual

CSS The Missing Manual

CSS: The Definitive Guide

CSS The Definitive Guide

CSS Mastery: Advanced Web Standards Solutions, Second Edition

CSS Mastery Advanced Web Standards Solutions, Second Edition

Stylin’ with CSS: A Designer’s Guide (2nd Edition) (Voices That Matter)

Stylin' with CSS A Designer's Guide (2nd Edition) (Voices That Matter)

CSS Pocket Reference: Visual Presentation for the Web (Pocket Reference (O’Reilly))

CSS Pocket Reference Visual Presentation for the Web (Pocket Reference (O'Reilly))

Pro CSS and HTML Design Patterns

Pro CSS and HTML Design Patterns

The Ultimate CSS Reference

The Ultimate CSS Reference

Transcending CSS: The Fine Art of Web Design (Voices That Matter)

Transcending CSS The Fine Art of Web Design (Voices That Matter)

Beginning CSS Web Development: From Novice to Professional

Beginning CSS Web Development From Novice to Professional

Bulletproof Web Design: Improving flexibility and protecting against worst-case scenarios with XHTML and CSS (2nd Edition) (Voices That Matter)

Bulletproof Web Design Improving flexibility and protecting against worst-case scenarios with XHTML and CSS (2nd Edition) (Voices That Matter)

Handcrafted CSS: More Bulletproof Web Design

Handcrafted CSS: More Bulletproof Web Design

The Zen of CSS Design: Visual Enlightenment for the Web

The Zen of CSS Design: Visual Enlightenment for the Web

More Eric Meyer on CSS (Voices That Matter)

More Eric Meyer on CSS (Voices That Matter)

Designing with Web Standards (2nd Edition)

Designing with Web Standards (2nd Edition)

Categories
Client Side Coding Books CSS & HTML Tips Web Design Tips and Insights

Best Books of HTML and XHTML to Learn How to Create Web Pages / Sites with HTML and CSS

HTML is the language of the Web and all websites are written in HTML (XHTML). To learn creating website, the first thing you will need to learn is HTML. Period.

Some of the selected books below are for beginners and some are for intermediary coders to consolidate your knowledge of HTML and CSS and practice along reading the books.

Web Developers / Designers’ Books:

  1. Best HTML Books
  2. Best CSS Books
  3. Best JavaScript Books
  4. Best PHP Books
  5. Best MySQL Books
  6. Best Linux Books
  7. Best Apache Books (mod_rewrite Books)
  8. Best Web Hosting Books

HTML, XHTML, and CSS, Sixth Edition (Visual Quickstart Guide)

HTML, XHTML, and CSS, Sixth Edition (Visual Quickstart Guide)

Head First HTML with CSS & XHTML

Head First HTML with CSS & XHTML

Build Your Own Web Site The Right Way Using HTML & CSS

Build Your Own Web Site The Right Way Using HTML & CSS

HTML, XHTML, and CSS All-in-One Desk Reference For Dummies (For Dummies (Computer/Tech))

HTML, XHTML, and CSS All-in-One Desk Reference For Dummies (For Dummies (Computer Tech))

The Ultimate HTML Reference

The Ultimate HTML Reference

HTML and XHTML Pocket Reference (Pocket Reference (O’Reilly))

HTML and XHTML Pocket Reference (Pocket Reference (O'Reilly))

HTML A Beginner’s Guide (Beginner’s Guide (Osborne Mcgraw Hill))

HTML A Beginner's Guide (Beginner's Guide (Osborne Mcgraw Hill))

HTML & XHTML: The Complete Reference (Osborne Complete Reference Series)

HTML & XHTML The Complete Reference (Osborne Complete Reference Series)

Creating a Web Page with HTML: Visual QuickProject Guide

Creating a Web Page with HTML Visual QuickProject Guide

Categories
Client Side Coding Books JavaScript Tips & Tutorials

Best JavaScript Books for Learning JavaScript Programming and Development

Thanks to the computer scientists who set the standards of JavaScript, in the arena of event programming and behavioral manipulations of windows and objects, it is the one programming script that is so powerful that you can virtually build any possible interactive applications with it.

That said, learning JavaScript to the mastery of it takes lots of time and practice. These are some JavaScript books I have selected from Amazon that may be a good guide to you when you are learning JavaScript front end programming.

Web Developers / Designers’ Books:

  1. Best HTML Books
  2. Best CSS Books
  3. Best JavaScript Books
  4. Best PHP Books
  5. Best MySQL Books
  6. Best Linux Books
  7. Best Apache Books (mod_rewrite Books)
  8. Best Web Hosting Books

JavaScript: The Good Parts

JavaScript: The Good Parts

JavaScript: The Definitive Guide

JavaScript The Definitive Guide

Professional JavaScript for Web Developers (Wrox Programmer to Programmer)

Professional JavaScript for Web Developers (Wrox Programmer to Programmer)

JavaScript: A Beginner’s Guide, Second Edition, Third Edition

JavaScript A Beginner's Guide, Second Edition

Murach’s JavaScript and DOM Scripting (Murach: Training & Reference)

Murach's JavaScript and DOM Scripting (Murach: Training & Reference)

JavaScript(TM) Step by Step

JavaScript(TM) Step by Step 

Pro JavaScript Techniques

Pro JavaScript Techniques

JavaScript & DHTML Cookbook (2nd edition)

JavaScript & DHTML Cookbook (2nd edition)

Object-Oriented JavaScript: Create scalable, reusable high-quality JavaScript applications and libraries

Object-Oriented JavaScript Create scalable, reusable high-quality JavaScript applications and libraries

Pro JavaScript Design Patterns (Recipes: a Problem-Solution Ap)

Pro JavaScript Design Patterns (Recipes a Problem-Solution Ap)

Beginning JavaScript

Beginning JavaScript

Categories
Apache Web Server Tutorials & Tips LAMP Developer Books

Best Books of Apache Web Server to Learn Apache and Use It

As the most popular web server for hosting websites, Apache is second to none. It thrives for a reason, that is, it’s versatile and adapts to all situations and answer to even the slightest demands of a website. Below are some books from Amazon about administering Apache that may give you a new perspective and upper hand in handling the web server.

Web Developers / Designers’ Books:

  1. Best HTML Books
  2. Best CSS Books
  3. Best JavaScript Books
  4. Best PHP Books
  5. Best MySQL Books
  6. Best Linux Books
  7. Best Apache Books (mod_rewrite Books)
  8. Best Web Hosting Books

Apache Cookbook: Solutions and Examples for Apache Administrators

Apache Cookbook Solutions and Examples for Apache Administrators

Apache 2 Pocket Reference: For Apache Programmers & Administrators (Pocket Reference (O’Reilly))

Apache 2 Pocket Reference For Apache Programmers & Administrators (Pocket Reference (O'Reilly))

Apache Security

Apache Security

Apache Administrator’s Handbook (Developer’s Library)

Apache Administrator's Handbook (Developer's Library)

Linux Apache Web Server Administration, Second Edition (Craig Hunt Linux Library)

Linux Apache Web Server Administration, Second Edition (Craig Hunt Linux Library)

Categories
LAMP Developer Books SQL / MySQL Tips and Tutorials

Best MySQL Books to Learn MySQL Database Programming and Development (+ PHP Applications)

MySQL is by far the most popular and widespread database on the entire planet. It’s used in a wide array of industries and the Web is probably the most prominent scenario, websites database. Below are some hand selected books for you to learn MySQL: both database administration and database SQL programming, for both professionals and beginners.

Web Developers / Designers’ Books:

  1. Best HTML Books
  2. Best CSS Books
  3. Best JavaScript Books
  4. Best PHP Books
  5. Best MySQL Books
  6. Best Linux Books
  7. Best Apache Books (mod_rewrite Books)
  8. Best Web Hosting Books

MySQL Crash Course (Sams Teach Yourself in 10 Minutes)

MySQL Crash Course (Sams Teach Yourself in 10 Minutes)

High Performance MySQL: Optimization, Backups, Replication, and More

High Performance MySQL Optimization, Backups, Replication, and More

MySQL (4th Edition) (Developer’s Library)

MySQL (4th Edition) (Developer's Library)

Learning MySQL

Learning MySQL 

MySQL Cookbook

MySQL Cookbook

MySQL in a Nutshell (In a Nutshell (O’Reilly))

MySQL in a Nutshell (In a Nutshell (O'Reilly))

MySQL 5.0 Certification Study Guide (MySQL Press)

MySQL 5.0 Certification Study Guide (MySQL Press)

Pro MySQL (Expert’s Voice in Open Source)

Pro MySQL (Expert's Voice in Open Source)

PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide

PHP 6 and MySQL 5 for Dynamic Web Sites Visual QuickPro Guide

Understanding MySQL Internals

Understanding MySQL Internals

Web Database Applications with PHP & MySQL, 2nd Edition

Web Database Applications with PHP & MySQL, 2nd Edition

MySQL Pocket Reference

MySQL Pocket Reference

Categories
LAMP Developer Books PHP Tips & Tutorials

Best PHP Books for Learning PHP Development and Programming (with MySQL)

PHP is by far the most popular and easiest to use web programming language in the world. If your goal is to enter PHP programming and development as a novice beginner and start from the very basics, these books are reviewed the best by actual readers. Some of the books contain chapters dealing with MySQL, the most popular database system in the world that is usually combined with PHP to create websites or web applications.

Update: I have also hand picked a few PHP security books for people who develop web applications.

Web Developers / Designers’ Books:

  1. Best HTML Books
  2. Best CSS Books
  3. Best JavaScript Books
  4. Best PHP Books
  5. Best MySQL Books
  6. Best Linux Books
  7. Best Apache Books (mod_rewrite Books)
  8. Best Web Hosting Books

Beginning PHP and MySQL: From Novice to Professional, Third Edition (Beginning from Novice to Professional)

Beginning PHP and MySQL From Novice to Professional, Third Edition (Beginning from Novice to Professional)

PHP and MySQL Web Development (4th Edition) (Developer’s Library)

PHP and MySQL Web Development (4th Edition) (Developer's Library)

Learning PHP, MySQL, and JavaScript: A Step-By-Step Guide to Creating Dynamic Websites

Learning PHP, MySQL, and JavaScript: A Step-By-Step Guide to Creating Dynamic Websites

Wicked Cool PHP: Real-World Scripts That Solve Difficult Problems

Wicked Cool PHP Real-World Scripts That Solve Difficult Problems

PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide

PHP 6 and MySQL 5 for Dynamic Web Sites Visual QuickPro Guide

Programming PHP

Programming PHP

Head First PHP & MySQL

Head First PHP & MySQL

PHP Cookbook (Cookbooks (O’Reilly))

PHP Cookbook (Cookbooks (O'Reilly))

Practical Web 2.0 Applications with PHP

Practical Web 2.0 Applications with PHP

Web Database Applications with PHP & MySQL, 2nd Edition

Web Database Applications with PHP & MySQL, 2nd Edition

PHP Object-Oriented Solutions

PHP Object-Oriented Solutions

PHP Objects, Patterns, and Practice, Second Edition

PHP Objects, Patterns, and Practice, Second Edition

Categories
JavaScript Tips & Tutorials

JavaScript: Open or Redirect to Another Page / Site / Location

One of the most common uses of JavaScript is to redirect the user to or automatically open up another web page location. For example, when the user clicks a button, the JavaScript will redirect the user to the location selected in the drop down select menu. It’s just like the user has typed the web page location URL.

There are 2 ways to use JavaScript to navigate to another web page. The first is to rely on the window object:

<script type="text/javascript">
	window.location="http://www.bing.com"
</script>

The location method mimics the user behavior of typing a URL address in the address bar of the browser window. The browser then forwards to that web site, leaving the last web page in the previous entry of browsing history.

The second approach is to use the replace method of location object:

location.replace("http://www.microsoft.com");

This is trickier in that it’s not like what users would do. Instead of creating a new history entry, this method replaces the old history entry by the new one. Essentially, users cannot go back to the previous page with this approach, the previous web page is replaced by the new one: http://www.microsoft.com.