PHP

ravimanephpmysql Types of MVC: Conventional v/s Configurable Now a days all the applications are being created using the MVC architecture, as it a most powerful and successful way to develop the application. In this article we will see comparison of different types of MVC architecture we have, which are as below:     Convention Based MVC     Configuration Based MVC Types of MVC Architecture Convention Based MVC As the name suggest, in this type of MVC we need to follow some predefined conventions in order to have it in working mode. This conventions are different from frameworks to frameworks. There are numbers of frameworks out there which follows convention based approach. Some of those frameworks are as below:     CakePHP     Codeigniter     YUI     Kohana In this article we will see convention approach of the Codeigniter, we will see what types of convention are...

ravimanephpmysql Question :I have an Ubuntu Server 12 which isn't on all day. In the /etc/crontab, I see that cron.daily, cron.weekly and cron.monthly are scheduled at times the server is off, usually.What happens with those tasks? Will they just be skipped, or runned as soon as the server is on again. ANSWER: cron skips jobs if it isn't running at the time that they are scheduled. However, if you have anacron installed, then daily, weekly and monthly jobs are run "at the specified intervals as closely as machine uptime permits". In /etc/crontab, you should see references to anacron. This logic uses anacron for regular jobs, but only if anacron is installed. anacron is installed by default on Ubuntu Desktop, but not on Server, since servers are generally expected to be on 24/7. But you can install anacron on Ubuntu Server if you want the same behaviour there, and it should work as expected.

ravimanephpmysql This depends on which cron scheduler you use. The basic, vanilla cron daemon will not run tasks that were missed due to system downtime. However, there are other cron schedulers specifically designed for this situation which will do this for you. The two most common examples are anacron and fcron .

phpmysql Introduction When we want to execute a specific task at a scheduled time, MySQL provides special functionality called triggers. Triggers are basically named blocks of code that are executed, or fired, automatically when a specified type of SQL statement is executed. Triggers can be executed before after an INSERT, UPDATE or DELETE statement is executed on the table. Syntax CREATE TRIGGER trigger_Name {Before|After}{Insert|Update|Delete}ON table_name For  EACH  ROW sql_block For Example Using the following query, you can better understand what a trigger is and how to use a trigger to execute a specific task at a scheduled time. Query The following query creates a  trigger named "MysqlTrigger", this trigger is associated with the name emp table and is fired before an update. When you try to update a name with lower case, it will automatically convert it to UPPER case . "CREATE TRIGGER MysqlTrigge...