I am not able to find where to write the stored procedure in phpMyAdmin and how to call it using MVC architecture.
STORED PROCEDURES are written using normal SQL language in the SQL box available in phpmyadmin->database->table->execute sql
phpmyadmin->database->table->execute sql
Refer this: - http://dev.mysql.com/doc/refman/5.0/en/stored-routines.html