MySQL is a relational database management system (RDMS), and one of the most powerful DBMS. Most of the websites including this blog using MySQL technology behind it. Since it free and it always bundled with the PHP and Linux, often it is called LAMP (Linux, Apache, MySQL, and PHP). If you know a little about programming in PHP, MySQL skill is a must to you to learn.Okay i am not explaining what it MySQL, or what is SQL syntax. Now i just want to share with you a script to backup all the … Read more...
[HowTo] Extract Database Information From Information_schema Table in Mysql
INFORMATION_SCHEMA provides access to database metadata. Metadata is data about the data, such as the name of a database or table, the data type of a column, or access privileges. Other terms that sometimes are used for this information are data dictionary and system catalog. INFORMATION_SCHEMA is the information database, the place that stores information about all the other databases that the MySQL server maintains. Inside INFORMATION_SCHEMA there are several read-only tables. They are … Read more...
Zen Cart v1.3.9c Released
Zen Cart is a free online store management system under the GNU General Public License. It is PHP-based, using a MySQL database and HTML components. Also Support is provided for several languages and currencies. Zen Cart is derived from osCommerce as a separate project. The major differences between the two systems come from Zen Cart's architectural changes (e.g. a template system) and additional included features in the core.Zen Cart latest stable release is version 1.3.9c has been released … Read more...
HTML5 – CSS 2.1 – CSS 3 Cheat Sheet (PDF)
As today HTML5 and CSS3 is the newest standard for the web design, all web designers and developer are busy preparing and learning this new standard, including myself. I want to share with you with this Cheat Sheet that i got from smashingmagazine.com.You can download it here: HTML5 Cheat Sheet (PDF) CSS 2.1 Cheet Sheet (PDF) CSS 3 Cheat Sheet (PDF)Source From: SmashingMagazine.comAll copyright of these Cheet Sheet is copyrighted to the respective owners. … Read more...
[HowTo] Replace String In Mysql With One Query
Yesterday i was helping my friend's blog. She want to change her domain and move her hosting server for some reasons. She is using wordpress as her blog engine and of course using mysql as database server. To move wordpress blog to another domain you need to change some configuration on the database file. Especially if the data have the absolute path in url (ex: http://www.willbechange.com/bla/bla/post.html).After examine her database file i found that many of data in wp-options using … Read more...
[HowTo] Make Apache User Directory on Ubuntu
On system (in my case is Ubuntu server) with have multiple user and each user permit to have their own home directory, then you need to install mod_userdir on your apache. So you can have the address like this: www.anyurl.com/~username/. Each user will have their own subdirectory specified by UserDir driective in the configuration.To install userdir module in apache on ubuntu server is not hard. Only need a couple steps and change directory permission.Follow these steps below:Open … Read more...
[HowTo] Install ImageMagick/Imagick For PHP On Ubuntu
Installing ImageMagick on Ubuntu with PECL is really simple. But i want to share with you how to install it beside to remind myself someday, if i forget how to install it. ImageMagick is a php library for image processing. But they are not developed just for PHP library only, now they have library for Ruby, Perl, Phyton, etc. You can visit their official website here.Let's continue to how to install ImageMagick/Imagick on Ubuntu:Open your terminal Install php-pear if you don't install … Read more...
5 Best Website To Become Professional Web Designer
In this post i would like to share the 5 best website to become a web designer from novice to professional. Become a web designer especially a template designer for CMS (Content Management System) like Wordpress, Joomla, Mamboo, or many else, need practice and and knowledge to support you to make a creative web design. And now i would like to share with you the best 5 website to start with and have fun...1. TutsPlus (recommended)If you want to be the best, you have to learn from the … Read more...
[TUTORIAL] Password Protected Directory In Apache Web Server
Sometimes you want to make an online application but only for private use or use by some people only. Or you just made an online application but still in testing phase in development, and don't want to make the site go live yet. Or you want a web site or a directory to be protected for security reasons. Or other reasons that you can mention. But the point is you want a whole website or a directory to be password protected.You can make a whole website or a directory password protected with … Read more...