Easy And Tasty Garlic Pickle

Hi friends,

In this post I like to explain you how we can make a very tasty and easy garlic pickle please read my post fully.

INGREDIENTS

Garlic 900 gram

Ginger chopped – 50 gram

Gingelly oil [ nalana ] – 300 ml

Curry leaves – five leaves

Kashmiri Chilli – 5 tablespoon

Yellow powder – 1 teaspoon

Fenugreek powder – 1 teaspoon

Kayam powder [Asafoetida powder] – 1 teaspoon

Salt – As required

Procedure

Clean  the  garlic  by  removing  the  outer  cover. Cut  each  piece  of  Garlic  into pieces  by  its  middle. Please  take  around  hundred  gram  of  garlic  and  chop them. Then  keep  it  in  a  bowl. Now  clean  the  Ginger  also  chop  and  keep  it  in the  bowl. Then  Keep  a  pan  on  the  stove  and   put  the  gingelly  oil  [ nalana ] and  wait  till  it  boil. Then  put  the  chopped  Ginger  and  garlic  together  in  the pan. And  stir  until  the  garlic  and  Ginger  get  golden  brown  color. Then  we  can  put  the  chilly  powder  yellow  powder  along  with   Kayam   powder [Asafoetida  powder]  in  the  pan  and  mix  well. Now  we  can  put  the  garlic which  we  previously  kept  ready.  And   boil  until   2-3  minutes  without  adding any  water. After  that  switch  off  the  stove. After  sometime  we  can  add  2-3 tablespoon  Vinegar. And  also  add  the  salt  as  required.

Now  our  tasty  garlic  pickle  is  ready!

Garlic pickle

Yummmm!

Thank  you!  for  reading  our  article.

 

Various PHP SQL statement for reading database data from a table

php tutorial

Hi my dear friends,

In my last post I wrote about the how we can read and display multiple rows  of data from a mySQL database server. In that Post I used the following my SQL statement to read the data from the table.

$sql="SELECT * FROM material_transaction_register WHERE search1 LIKE '%$q%' ";

So now I will explain the structure of the statement. In the above SQL statement the SELECT , FROM, WHERE and LIKE are the keywords. The table name is the name of the table from where we want to fetch the Data.  search1 is one of the column name. Now I will explain how it will work . This statement is saying that,  select the table “table name” from the database which is mentioned in the connection parameter. And from that table verify the data from the column name “search1” . And also saying that  the data should be “LIKE” the variable mentioned in the single quote. The percentage symbol shows that, any word before the variable and ANY WORD after the variable is not considering, that means if a sentence in the Column name search1 having the any word same like the “q” variable then that row will be selected for fetch. All this type of selected row will be fetch and asigned to the variable “sql”.

2. 

$sql1 = "SELECT * FROM table_name WHERE search1 = '$item_code' ";

In the second SQL statement is also work same as the first one. But in this case it will select the rows from the table_name table wherever the column name “search1” have the value exactly same as “item_code” variable. Here in the single quote we are declare a variable, you can also directly place any string there. So this SQL statement will send all the rows to the sql1 variable from the table wherever the search one column have data exactly equal to the item_code variable.

3.

$sql="SELECT * FROM table_name ORDER BY id DESC LIMIT 25;";

Here is the third SQL statement. This one is one of the very important SQL statement, because it is generally used to read the entire data from a table.  In the previous SQL statement we are used WHERE keyword to select the rows but in this case we are using ORDER BY keyword which will select all the rows in the column name “id” and DSE keyword is used to store this rows in descending order. Instead of DSE we can use ASC for ascending order.  and the LIMIT keyword is used to limit the number of rows to 25 in this case. We can adjust this number as per the number of rows required. We can avoid to use the limit keyword along with it number, so that all the rows will be assigned to “sql” variable.




Here Also we can see that the keyword ORDER BY , DSC/ASC and LIMIT can also  use with the SQL statement 1 and 2 given above as shown below. In this type of case the rows will be selected from the column  name “search1” according to the condition. And it will be ordered by ascending or descending manner according to the  column name “id” .

$sql="SELECT * FROM table_name   WHERE search1 LIKE '%$q%' ORDER BY id DESC LIMIT 100 ";

$sql1 = "SELECT * FROM table_name WHERE search1 = '$item_code' ORDER BY id DESC LIMIT 100 ";

4.

$sql1 = "SELECT * FROM input_vat_register WHERE id = 10 AND time_stamp = 1529359200 ";

Here the fourth SQL statement is the one of the greatest SQL statement. Because it is playing with multiple columns, here input_vat_ register is nothing but the name of the table. By using the WHERE keyword we are checking to column name  “id” and “time_stamp”.  Both conditions are connected with and operator, so whenever both condition will be satisfy the row will be selected for fetching. Instead of and we can use OR also, in that case if any one of the condition satisfied then particular row  will be selected for fetching. Here  the conditions are equal to operator but we can use less than or greater than or combination of both. We can also use this one to select a rose from the single column . For example if you have a column name “date” then we can check the condition of rows lying between two particular dates, by using the less than or greater than operator. Here we can connect more than two conditions also with operators but that one I am not tested. I hope by the use of these combination of  things you can make various type of data reading operation from mySQL database table. If you have any doubt regarding this topics please give me a comment. So that I can help you. Thank you for reading this post.

Nadan Chembu Curry Recipe [Colocasia]

Hi Friends,

Welcome Back , Today I Am Going To Share you a Recipe of a tasty Nadan Chembu Curry [Colocasia]

Also See The Ingredients Below

INGREDIENTS

Colocasia – 7 Psc

Chilly Powder – 1 Teaspoon

Yellow Powder – Half Teaspoon

Curry Leaves – 5 leaves

Red chilly – 3 pcs

Water – As Required

Scraped Coconut

Tumin [ Geragum]

Small Onion

Yogurt (curd)- 1 Cup

Mustard

colocasia ,chilly powder,
coconut and onion

PROCEDURE

Clean, cut and Wash  colocasia and put it in a bowl, along with  chilly powder, yellow powder , some curry leaves and  enough water. Place  it over  a stove and allowed  it to boil  by keep it lid closed.  And grind scraped coconut, tumin [geragum]  and small onion. Mix till this becomes smooth paste. After cook the colocasia  put this paste into the bowl and allow it to boil. Then add  yogurt (curd) and mix it . Don’t boil this time just make the curry hot. Now, take another pan  put some oil and keep it on a stove and wait the oil get hot. then put mustard and wait until the mustard flutter and add some curry leaves and  read chilly . You can put red chilly or green chilly. Also fry these things till it gives a pleasant smell. Then put these things into the curry . This will also give good smell and decoration to the curry.

chilly and onion

Chembu curry [ colocasia ]
Hurry! Your Yummy Nadan Chembu Curry Recipe Is Ready

Nadan Fish Curry Recipe

Fish curry kerala style

Hi Friends,

I am back Again ! with a nice recipe to share with you. It is a yummy! Fish Curry [ Kerala Style ].

please see! the Ingredients below

INGREDIENTS

Fish  – 750 Gram

Mustard

Garlic

Curry Leaves

Ginger – 1 Peice

Chilli Powder – 2 Table Spoon

Fenugreek Powder [ Uluva Powder ]

Yellow Powder – Half Teaspoon

Tamarind (valen-puley) -5 Pcs in half glass water.

Water – 1 Glass

Coconut Oil

ginger and garlic
Chilly powder

PROCEDURE

Wash and keep the fish aside. Then put some oil in a muddy bowl [chatti].              When the oil is hot put mustard, then put garlic, curry leaves and ginger.                After half fry , add chilly powder and yellow powder. Mix all this ingredients together and heat well until mild smell and little smoke. Now we can add the soaked tamarind along with it’s water. Add 1 glass water more and wait until boiled well . Now add the washed fish into the muddy bowl. Shake the muddy bowl in order to spread the gravi all over the fish and add fenugreek powder . Close the muddy bowl with a lid and leave in a low flame upto 30 min. Switch of the flame and spread 1 tablespoon coconut oil and curry leaves over the curry. This will add more test and wil give decoration also to the dish. This is basically naden kerala style fish curry. This is also non as kottayam style fish curry.

Tamarind
Fish curry




Feature plans

In Order to get our more recipes please visit our cooking category . We are also requesting you to please send your suggestion and comments on below comment section. so that we can improve our posts. Our future   plan is  to make more see food dishes like prons and karimeen. And also planning to start a cooking forum for our community in this site. currently we have a technology forum in this site. Please remember to give your comment regarding to star the cooking forum.

Thank you very much for reading this post.

How can read and show multiple row of data from mysql database table using PHP

php tutorial

Hi Friends,

In this post I like to explain how we can  read and display the datas from a mysql database table using php.

Step-1

First we have to make the database connection with following php code

<?php 
$servername = "localhost";
$username = "user_name";
$password = "password";
$dbname = "database_name";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

?>

 

Here the variable $con holding the connection details. such as server address, user name, password and database name.

Now we can use the following codes to read the data from the
“table_name” table of the database “your_database_name”.

$sql="SELECT * FROM table_name WHERE search1 LIKE '%$q%'";
$result = $conn->query($sql);

$num=$result->num_rows;

$i=0;
while ($i < $num) {
$row = $result->fetch_assoc();
$id=$row['id'];
$customername =$row['customername'];
$address =$row['address'];
$contactname=$row['contactname'];
$contactnumber=$row['contactnumber'];
$fax_no=$row['fax'];
$tr_no=$row['trn'];

?>
<div id="menu" style="background-color:#ccff99;width:5%;
float:left;">
<?php echo"$id " ?> </a>
</div>

<div id="menu" style="background-color:#ccff99;width:20%;
float:left;">
<?php
echo"$customername";
?>
</div>

<div id="menu" style="background-color:#ccff99;width:20%;
float:left;">
<?php
echo"$address";
?>
</div>

<div id="menu" style="background-color:#ccff99;width:20%;
float:left;">
<?php
echo"$contactname";
?>
</div>

<div id="menu" style="background-color:#ccff99;width:10%;
float:left;">
<?php
echo"
$contactnumber";
?>
</div>

<div id="menu" style="background-color:#ccff99;width:10%;
float:left;">
<?php
echo"
$fax_no";
?>
</div>

<div id="menu" style="background-color:#ccff99;width:15%;
float:left;">
<?php
echo"
$tr_no";
?>
</div>

<div id="menu" style="background-color:#ccff99;width:100%;
float:left;">
<hr>
</div>

<?php

$i++;
}

?>
<?php
mysqli_close($conn);
?>

Here in the first line of code the variable $sql will hold the  sql statement. The structure and different type of sql data reading statement will explain in another post.  Second line of code will connect to the database with the $con variable and request for the data as per the  $sql variable and store the result in the result variable.

$num=$result->num_rows; 

this line of code will store the total number of rows which is stored in the result variable.

At this point we will start a while loop with a variable i with initial value 0. and the loop condition is the loop will execute until the loop variable i grater than or equel to the number of row in the num variable.

$row = $result->fetch_assoc(); this is the first statement in the loop. When it execute the first row of data which is stored in the result will asigin to the variable row. $id=$row[‘id’]; Now during the execution of this statement, the value of the column name id will store in the variable $id.  Like this, as shown in the code we can get values of any column name in that particular row currently stored in the result variable. The following code is used to write out  the variable values in a table manner. In the fiel step the loop variable will increase and the loop will continue. In the second loop fetch_assoc(); function will store the second row values from the result variable to the row the variable. And this process will continue until all the fetched row is write out in a table manner.

mysqli_close($conn); This statement is used to close the database connection.

Hope this post is help full for you. And thank you for your commend.