Wednesday, October 26, 2016

Create Procedure in MySQL using PHPMyAdmin

In MyPHPAdmin 4.x, there is "Add Routine" link under "Routines" tab at the top row. This link opens a popup dialog where you can write your Stored procedure without worrying about delimiter or template.
enter image description here
Add Routine
enter image description here
Note that for simple test stored procedure, you may want to drop the default parameter which is already given or you can simply set it with a value.
On PHP, you can use the following code to call the procedure.
include_once("dbconfig.php");
    $stmt = "CALL insertEmp(0;";
    $rs = $db_con -> prepare($stmt);
    $row = $rs -> execute();
?>
Wednesday, May 4, 2016

My New Project is underway - Permaculture

After much deliberation and head banging past 1 year, I have finally made up my mind. Leaving the business of Decor house(Worst decision of my life) and Web programming(I do hope that I will be able to continue doing this though), I am going to use a small space of land in Dibyanagar, Chitwan for Permaculture. Before you say anything, Permaculture is a big word to myself and I came to know about this last week only. I had some idea on what I wanted to do but there was a word for this, that I didn't know.

So what exactly is Permaculture ? Wiki states it as "Permaculture is a system of agricultural and social design principles centered around simulating or directly utilizing the patterns and features observed in natural ecosystems."
Permaculture - Wikipedia, the free encyclopedia

I had this vision of starting a small farm house in a small area of land where I can pass my time and be doing something that would be creative as well as be a source of inspiration to the locals. After looking around, I found a small piece of land in Dibyanagar, Sisar to be exact. So, past couple of weeks has been busy for me to design on a layout which I would be happy to work on. I have roughly figured it out how I would like. I have the layout but I will reveal it later.

As the condition of Nepal is worsening day-by-day due to the Madhes andolan and fuel crisis hitting the roof, it might not be a good time to start a farm. Everything is in shortage and the prices are sky-rocketing. I would love to start sooner rather than later and write more about it. Til then please bear with me.

BTW, I am starting a self-sustainable farm house with Horticulture, Vegetable Farming, Goat Farming and Timber Farming as well. Just in case if you have any suggestions, please do let me know. I would love to have inputs.

Burger Shack...A paradise for Burger Lovers

Wandering around New Road, my brother and I were looking for a good place to have 'khaja'. I had in particular, Trishara in mind but then suddenly out of nowhere I said 'Burger Shack'. I have heard of this place and in particular praises only. So, after searching the Internet, the address mentioned was Jawalakhel and contact number. Armed with that particular information, off we went in search of the place. We started looking up the place from Pulchock itself. To my surprise, the place as mentioned was in the chock itself besides NTC on the way to Kumaripati.

Parking can be done in the sideways and shouldn't be a big problem as there were ample space.
The place was little smaller than what I thought it would be and seemed to be a rather like an American diner. I asked for the rest room and was promptly shown the way. The place was clean and the ambiance was rather pleasant. There were very few people, may be due to the fact that we were way past the "lunch hour".

Going through the menu, we ordered BBQ Sauce Burger and Double Chicken. When asked for the refreshment, I think he was the owner, he recommended the Lemon Mint Refresher. It was absolutely refreshing and we loved it. The refreshment was provided very fast. I love the fast services. The burgers followed. We didn't know what to expect. But the very first bite, and both of us were smiling. We knew that it was delicious and we both loved it. So much so that I even forgot to take pictures of those delicious burgers. The burger was filling in portion but we ordered our self another round for the road.

We are definitely going there in the future and hopefully, try all the varieties.
The place is clean and hygienic. I also noticed the notice board where they claim that all the vegetables are cleaned with Iodized water. NO SMOKING always makes me happy. :)
A big thumbs up.