MYSQL Trigger

Mungkin saya adalah salah satu orang yang ketinggalan info soal MYSQL, terlebih lagi soal MYSQL TRIGGER…apa itu??

Memang sudah 3 tahun ini saya tidak bermain-main dengan fungsi MYSQL yang advance, biasanya pake query-query standar saja, jadi maklum jika MYSQL TRIGGER sampe sekarang belum ngerti :D

MYSQL TRIGGER, mungkin kalo di ORACLE disebut STORE PROCEDURE.
Perintah TRIGGER adalah suatu PROCEDURE di MYSQL yang berfungsi secara otomatis menjalankan query tertentu. Trigger akan berjalan ketika “pemicu” nya dipanggil.

Sebagai contoh, Server akan mengupdate secara otomatis pada tabel B jika  “row” di tabel A di hapus..

di sesi berikutnya akan saya sajikan bagaimana contoh Mysql Triggernya…

 

PHP Web Development Framework

I just looking for PHP MVC Framework to development some future Web Application.

Why i have to use PHP MVC Framework?

there were many reason :

  1. Stable, Solid & Simple Framework
  2. Rapid Development
  3. Easy to use

Web development frameworks are wonderful things. They can generally help to make web development much simpler, by providing easy-to-use tools for common tasks such as database access, templates and session management. Many of them also include features to generally speed up development, such as use of a Model-View-Controller (MVC) pattern, and more.

Because there are so many frameworks out there, many with similar uses, it can be difficult to choose which one to use in your web application. So here is a list of excellent frameworks that everyone should try out.

1. CodeIgniter

This is probably one of my favourite web development frameworks, and the first that I learned to use. CodeIgniter is an open source PHP framework developed by EllisLab. It is known for being a relatively light framework (under 4MB), while still providing tons of great features for quick and easy PHP development.

CodeIgniter uses an MVC pattern, which pretty much means that you have models that handle the site’s data (the database), views that take care of what the user sees, and I’d say that the controller is the part that actually does stuff.

2. Zend Framework

Zend Framework is another great PHP framework. It is open source, released under the New BSD License. Zend Framework is a use-at-will type of framework, meaning that its users aren’t forced to follow any specific paradigm, providing many individual components to be integrated into web applications.

3. CakePHP

CakePHP is yet another web application framework for, you guessed it, PHP. It is another framework that follows the popular MVC pattern. Like Ruby on Rails, CakePHP allows for easy database access through a system similar to the active record pattern. Overall, it is an excellent framework for rapid web application development.

 

To Be Continued….

How To Display Error on PHP

I wondered why my php script doesn’t show errors like it did before. It seems my server configuration has default config set not to show the errors. I use the error message and notification for development.

Here’s how to override it without change server httpd configuration

Write this script below on your script…

error_reporting(E_ALL);
ini_set('display_errors', '1');

And all error and notification would be show up after it

Happy coding!