CodeIgniter MySQL Stored Procedure and Function

MySQL has procedure and function feature. There is good article explaining both topics in http://bit.ly/dWDh9w. To call mysql function from codeigniter, we can simply use query() function from database class. For example Where storedFunction is the name of function we have created before. To call mysql stored procedure from codeigniter, we can use query() function […]

Connect MySQL with Powerdesigner

Kita bisa menggunakan powerdesigner untuk menghasilkan database secara otomatis dari physical diagram model. How? bekerja dengan odbc (open database connector) install mysql odbc di http://dev.mysql.com/downloads/connector/odbc/5.1.html buka command prompt, navigasi ke direktori odbc tambahkan driver dan datasource baru untuk connect dengan database menambahkan driver: myodbc-installer -d -a -n \”MySQL ODBC 5.1 Driver\” -t \”DRIVER=myodbc5.dll;SETUP=myodbc5S.dll\” menambahkan datasource: […]