InnoDB and MyISAM both are very important engine type in MYSQL.InnoDB and MyISAM both have their unique advantages in their favor and disadvantages against each other.Each of them is more suitable in some scenarios than the other.
Continue reading …
The Index is very important machanism to improve mysql performance but some cases index size could be increase than available memory for the application.So first question in mind how to check how much RAM available for index and how much consume memory your database index.In this tutorial i will described for two type engine InnoDB and MyISAM.
Continue reading …
THe Mysql has great flexibility in database.It has triggers,stored procedure and much more.When you want run a SQL based on change of table data(like event occurred on data), then you need to create Trigger.
But MySQL also has magic EVENT Scheduler functionality, its like cron job which will RUN on specific time.EX:
You need to delete all data of table on specific time,In script level you can create cron job which will RUN on schedule time.
BUT in database level you can create EVENT on database which will RUN on schedule time.
Continue reading …
Exception handling is very important for developer as well as for programming,in this tutorial we will described how to set custom header and messages.
When we work on web application then each request have HTTP response.The HTTP response denotes the request was successful or have error,If response header contains error,Then you can know about what type error occurred with help of HTTP status code and message.
Continue reading …
Faceboook is launching new threaded comment functionality. It’s very awesome user experience, with help of this anyone can reply directly to comments left on your Page content and start conversation as new threads.
Continue reading …
View is very important factor of Database based on performance. View is virtual table that’s contains result set of your SQL statement. In SQL statement yo can use SQL functions, WHERE, and JOIN statements to get result set.
The View table can contain rows and column like your original table the column name may be different and unique in VIEW table. By default, the names of the columns retrieved by the SELECT statement are used for the view column names. The Columns name in view may be one or more real tables in the database.
Continue reading …
Now we will discuss next phase of flexi gird, how to pass parameters and relode flexi grid.
In this totorail i will described how to add search/sorting fucntionalty.The flexi grid laready have sorting but if you want custom sort ,Eg.: If we want only those record display in flexi grid which has status completed.
Continue reading …
PHP has great support with Mathematical processing.PHP has very rich functions, There are two ceil and floor for doing rounding off number.
Below are simple steps for how to use these functions.
The floor() function rounds off the value down to the nearest integer.
1
echo floor(0.65);
The output of the above code will be 0.
Continue reading …
In programming languages header information of request and response is very important. The header of request tells the behavior of request and header response tells the request is success or failed, In case failed you can also know the which type error was accrued with help of HTTP response code.
PHP provide is getallheaders() to for get all header information.This function is used for fetches all HTTP headers from the current request. getallheaders() is an alias for apache_request_headers().
Continue reading …
$_SERVER is a predefined ‘super global’ variable. $_SERVER contains information such as headers, paths, and script locations. The entries in this array are created by the web server. There is no guarantee that every web server will provide any of these; servers may omit some, or provide others not listed here.
Continue reading …