In cakephp I found lack of multi query and stored procedure calling. I have searched on google for any class available. Everyone is talking about to use $this->query(“call yourpeocedure()”); and they are getting result. It is fine and you can get result. But in case where stored procedure will have multiple select query. In this case $this->qyuery() will give error. Here I have created a very small class for cakephp by which you can integrate your mysql stored procedure with cakephp. For now class is very abstract and and if you need then you can modify the class. This class is handling the stored procedure in two form, first if your mysql stored procedure have any select query just like Select * from yourtable then it will simple return result after calling the function like $this->Model->procedure(“YourProcuedure” , $input_parameter). If your stored procedure is dealing with output procedure then it will just return by calling another function name
$this->Model->getOutData(). In my post Cakephp Call Mysql Stored Procedure I will explain all process. Continue reading “Cakephp Call Mysql Stored Procedure”
Category: Cakephp
Best Practices Cakephp Coding
For last 5 year I am playing with code of php, I have used several frameworks and opensource solution. In these I like cakephp a lot because it is very simple for coding. It is very flexible and easy to understand. Any php developer can start coding in cakephp after learning this for few hour. You can enjoy cakephp in any fashion. Cakephp has good speed also because it is very small library which nun behind your code. If you are creating any small application using cakephp then you can play and get fun in all the way with cakephp. But if you are developing some large application then you have to take some extra care for your code and logic to make your code maintainable and to achieve reasonable speed of your application. Here in my post “Best Practices cakephp coding” I am going to share my personal experience of cakephp. I have made lots of mistake in some of project in my earlier days and learn these things. These are not a rule of cakephp. these are best practices for your cakephp coding by which you can manage your project. Let us review the things by categorizing your code in three part 1) Controller , 2) Model and 3) View Continue reading “Best Practices Cakephp Coding”
Cakephp cPanel Subdomain Issue
Recently I was suffering with directory issue of cpanel hosting while installing cakephp for subdomain.If your main domain is running cakephp application and you will create sub-domain and when you will access the sub-domain through your browser then it will show web server error.
Let me clarify the situation.
Suppose your domain http://www.website.com is running cakephp and now you have created any sub-domain with name subdomain and then if you will go to access http://subdomain.website.com then it will show apache error and of course your subdomain website will stop working. Continue reading “Cakephp cPanel Subdomain Issue”