Uncategorized

Papa Kehte Hain

1 Comment
This entry is part 7 of 41 in the series Guitar

This is the famous hindi song, It has a standard and a wonderful strumming pattern that one must know.

Key Signature: C Major Scale
Time Signature: 4/4

| C | Am | F | G | x2
| C | % | Am | % | F | % | G | % |

The “x2” play the whole line twice
The “%” symbol means that play the chord twice.

Rhythm (Strumming Pattern)

1&  2&  3&  4&
?   ?V rest V?V

So it goes like
Down, Down-Up, Rest, Up-Down-Up…Down, Down-Up, Rest, Up-Down-Up…and on…

guitar

Happy Birthday

Leave a comment
This entry is part 6 of 41 in the series Guitar

The first song that you’ll ever learn in your life is Happy Birthday. So we too will start with it.

Key Signature: C Major Scale
Time Signature: 3/4
Count: 3 counts in a bar | 1& 2& 3& |

Melody (Tabs)

E||-----------------|-----------------|-----------------|
B||-----------------|-------1----0----|-----------------|
G||--0----0----2----|--0--------------|--0----0----2----|
D||-----------------|-----------------|-----------------|
A||-----------------|-----------------|-----------------|
E||-----------------|-----------------|-----------------|

-----------------|------------3----|--0--------------|
-------3----1----|-----------------|-------1----0----|
--0--------------|--0----0---------|-----------------|
-----------------|-----------------|-----------------|
-----------------|-----------------|-----------------|
-----------------|-----------------|-----------------|

-------1----1----|--0--------------|-------||
-----------------|-------1----3----|--1----||
--2--------------|-----------------|-------||
-----------------|-----------------|-------||
-----------------|-----------------|-------||
-----------------|-----------------|-------||

Play all the strokes downwards, when you are doing it for the first time, Get the feel of the song. Once you are OK with it you can do that with alternate strokes.

Chords

| C  | G7 |
| G7 | C  |
| C  | F  |
| C C G7 | C |

Rhythm

1& 2& 3&
?  ?v ?

The “?” indicates a downstroke (strum) and the “V” indicates an upward strum.
So it goes Down, Down-Up, Down…Down, Down-Up, Down… and so on…
The last sequence is
Down(C chord), Down(C) – Up(G7), Down(C)

Uncategorized

Songs

Leave a comment
This entry is part 4 of 41 in the series Guitar

Over here I’ll be putting all the songs that I learned during my course.
The songs range from easy to difficult level (at least for me)

  • Happy Birthday
  • Wonderful Tonight
  • Nothing Else Matters
  • and more…


The songs are also the part of the diary, I’ll be hyperlinking all the course, to the particular song that I learnt after a particular lesson

MySQL

Updating statistics table

Leave a comment

We have our array of keywords, with its hit count.
Now is the time to update our Statistics table, keyword_search_stats and search_engine_stats

<?php
echo '<pre>';
//print_r($query_term);
//print_r($query_term_cnt);
//print_r($final);

Run a loop, searching through keyword_search_stats, if the keyword is present.
If it is present, update the hit counter by 1.
If no record is found, then insert the new keyword

for ($i=0; $i<count($final); $i++)
{
    $sql_chk = "select * from keyword_search_stats where keyword = '{$final[$i][0]}'";
    $res_chk = mysql_query($sql_chk);
    if (mysql_num_rows($res_chk) > 0) {
        // row found .... update stats...
        $row_chk = mysql_fetch_object($res_chk);
        $new_count = $row_chk->keyword_count + 1;

        $sql_update = "update keyword_search_stats set keyword_count = $new_count, `update` = '".date("Y-m-d H:i:s")."' where keyword = '{$row_chk->keyword}'";
        mysql_query($sql_update);
    } else {
        // no row found... insert...
        echo ($final[$i][0] .' - ' . $final[$i][1]);
        $sql_ins = "insert into keyword_search_stats(keyword, keyword_count, `update`) values ('{$final[$i][0]}', {$final[$i][1]}, '".date("Y-m-d H:i:s")."')";
        mysql_query($sql_ins);
        echo ('<br/>');
    }
}

print_r($se_cnt);

Update the Search Engine’s statistics

foreach ($se_cnt as $key => $value) {
    $sql_chk = "select * from search_engine_stats where search_engine = '$key'";
    $res_chk = mysql_query($sql_chk);
    if (mysql_num_rows($res_chk) > 0) {
        // row found .... update stats...
        $row_chk = mysql_fetch_object($res_chk);
        $new_count = $row_chk->search_engine_count + 1;

        $sql_update = "update search_engine_stats set search_engine_count = $new_count, `update` = '".date("Y-m-d H:i:s")."' where search_engine = '$key'";
        mysql_query($sql_update);
    } else {
        // no row found... insert...
        echo ($key .' - ' . $value);
        $sql_ins = "insert into search_engine_stats(search_engine, search_engine_count, `update`) values ('{$key}', {$value}, '".date("Y-m-d H:i:s")."')";
        mysql_query($sql_ins);
    }
}

Since’ we’ve updated all the tables, so lets truncate the table.

echo '</pre>';
echo ('<br/> Truncating table view_log <br/>');
mysql_query("truncate table view_log");
?>

ऋतुराज का Home Page