thinking nothing...............!!
Fetch DEFAULT value from MySQL table or MySQL get DEFAULT value for Column or How to SELECT DEFAULT value of a field or How Can I get back DEFAULT values for Column names in a MySQL Table.
We can fetch the column names in a MySQL Table fairly easily by the simple command:
[bash]
DESC tbl_admin_modules;
[/bash]
If you have already created your MySQL database and table and suddenly realize that one or more table columns need to be modified, you can either drop / delete / remove the respective column and create new or you can alter the table. Altering of the table can be done using any MySQL GUI Tool / Editor like MySQL Query Browser (for Windows) or Sequel Pro (for Mac OSX) or using a MySQL ALTER TABLE Query. [Read more…]
LAMP is the abbreviation of Linux, Apache, MySQL, PHP. In this article I’ll try to explain how you can install an Apache2 webserver on a CentOS 6.3 server with PHP5 support (mod_php) and MySQL support. This approach should work if you start from scratch, i.e., the server has only CentOS 6.3 installed and nobody ever tried to install or configure LAMP!
Caution! This article is meant for those who rarely have to work on such projects when no expert advice / support available! By no means this should be used by any Linux Pro.
Introduction
While deploying Centos 6.3 onto the server please put hostname as localhost, and don’t bind the server to any particular IP address.
In my last post I asked whether “PHP is easy, is it a boon or bane?” because it is easy, most of the developers just develop systems but never pay attention to the architecture of the system on which they are developing. They never ask questions like “is the system stable?” or “will it be able to handle a lot of concurrent users?” or “is my code optimized enough for as the system required?” or “is the system that is holding my application and data designed well to ensure a better user experience?” or “is the system righteously architected / designed?”. Honestly I never asked myself a lot of these questions until I started working in Cloud Computing Environments, all that bothered me is the efficiency of my code, efficiency of my SQL queries, normalization status of my database, whether I need to de-normalize, finding solutions writing less numbers of lines of codes or single complex SQL JOIN queries, browser compatibility, etc, etc.
Encountering Cloud came as a shocker! I thought I knew fairly well about developing applications using LAMP stack, well I did know but what didn’t know was using LAMP stack on Cloud and what the architecture my cloud environment should have in order to sustain large volume of concurrent traffic. Also how should I write my SQL queries, how should I break a complex SQL query into multiple simple SQL queries and how should I complement complex database routines by PHP code. [Read more…]
The LAMP Stack
As per Wikipedia definition: LAMP is a solution stack of free, open source software. The acronym LAMP refers to the first letters of Linux (Operating System), Apache HTTP Server, MySQL (Database software), and PHP, Perl or Python, principal components to build a viable general purpose web server.
It is evident from the definition that Database is a fundamental component of most web applications. Even for developing static websites CMS software like WordPress, Joomla, Drupal are used all of which have a Database in the back end to store static content. If you are using PHP, Perl or Python then MySQL is an integral part of the development.
PHP is easy, is it a boon or bane?
PHP’s greatest strength has been its ease of use, any entry level programmer who has little bit knowledge of C Language and understands HTML / CSS / JavaScript to some extent can get a head start with PHP programming. But getting a head start does not ensure efficient completion of an expedition; it requires stability, fail safeness, sustainability & reliability. In order to write stable & reliable code along with building a solid, dependable, robust Database takes expertise and expertise comes from practice, experience & learning from mistakes. Here are 10 nasty mistakes I have seen PHP developers making quite often. [Read more…]