Thursday, September 18, 2014

Express your amount/digits in word

<?php

function oneDigit($d1) {
    $firstdigits = array(
        'one' => 1,
        'two' => 2,
        'three' => 3,
        'four' => 4,
        'five' => 5,
        'six' => 6,
        'seven' => 7,
        'eight' => 8,
        'nine' => 9,
    );
    $key = array_search($d1, $firstdigits);

    return $key;
}

function twoDigit($d1, $d2) {
    $firstdigits = array(
        'ten' => 1,
        'twenty' => 2,
        'thirty' => 3,
        'fourty' => 4,
        'fifty' => 5,
        'sixty' => 6,
        'seventy' => 7,
        'eighty' => 8,
        'ninety' => 9,
    );

    $seconddigits = array(
        'eleven' => 1,
        'twelve' => 2,
        'thirteen' => 3,
        'fourteen' => 4,
        'fifteen' => 5,
        'sixteen' => 6,
        'seventeen' => 7,
        'eighteen' => 8,
        'nineteen' => 9,
    );
    if ($d1 == 1 && $d2 != 0) {
        $key = array_search($d2, $seconddigits);
        return $key;
    } else {
        if ($d2 == 0) {
            $key = array_search($d1, $firstdigits);
            return $key;
        } else {
            $key1 = array_search($d1, $firstdigits);
            $key2 = oneDigit($d2);
            return $key1 . " " . $key2;
        }
    }
}

function threeDigit($d1, $d2, $d3) {
    $key1 = oneDigit($d1);
    if ($d1 == 0)
        $numberPostFix = "";
    else
        $numberPostFix="hundred";
    $key2 = twoDigit($d2, $d3);

    return $key1 . " " . $numberPostFix . " " . $key2;
}

function fourDigit($d1, $d2, $d3, $d4) {
    if (strlen($d1) == 1) {
        $key1 = oneDigit($d1);
    } else {
        $seperated = str_split($d1);
        $key1 = twoDigit($seperated[0], $seperated[1]);
    }
    if ($d1 == 0)
        $numberPostFix = "";
    else
        $numberPostFix="thousand";
    $key2 = threeDigit($d2, $d3, $d4);

    return $key1 . " " . $numberPostFix . " " . $key2;
}

function sixDigit($d1, $d2, $d3, $d4, $d5, $d6) {
    if (strlen($d1) == 1) {
        $key1 = oneDigit($d1);
        $numberPostFix = "lakh";
    } else {
        $seperated = str_split($d1);
        $key1 = twoDigit($seperated[0], $seperated[1]);
        if ($seperated[0] == 0)
            $numberPostFix = "";
        else
            $numberPostFix="lakh";
    }

    $key2 = fourDigit($d2 . "" . $d3, $d4, $d5, $d6);

    return $key1 . " " . $numberPostFix . " " . $key2;
}

function eightDigit($d1, $d2, $d3, $d4, $d5, $d6, $d7, $d8) {
    if (strlen($d1) == 1) {
        $key1 = oneDigit($d1);
        $numberPostFix = "cror";
    } else if (strlen($d1) == 2) {
        $seperated = str_split($d1);
        $key1 = twoDigit($seperated[0], $seperated[1]);
        $numberPostFix = "cror";
    } else if (strlen($d1) == 3) {
        $seperated = str_split($d1);
        $key1 = threeDigit($seperated[0], $seperated[1], $seperated[2]);
        $numberPostFix = "cror";
    } else if (strlen($d1) == 4) {
        $seperated = str_split($d1);
        $key1 = fourDigit($seperated[0], $seperated[1], $seperated[2], $seperated[3]);
        $numberPostFix = "cror";
    } else if (strlen($d1) == 5) {
        $seperated = str_split($d1);
        $key1 = fourDigit($seperated[0].$seperated[1], $seperated[2], $seperated[3], $seperated[4]);
        $numberPostFix = "cror";
    } else if (strlen($d1) == 6) {
        $seperated = str_split($d1);
        $key1 = sixDigit($seperated[0], $seperated[1], $seperated[2], $seperated[3], $seperated[4], $seperated[5]);
        $numberPostFix = "cror";
    }else if (strlen($d1) == 7) {
        $seperated = str_split($d1);
        $key1 = sixDigit($seperated[0].$seperated[1], $seperated[2], $seperated[3], $seperated[4], $seperated[5], $seperated[6]);
        $numberPostFix = "cror";
    }else if (strlen($d1) == 8) {
        $seperated = str_split($d1);
        $key1 = sixDigit($seperated[0].$seperated[1].$seperated[2], $seperated[3], $seperated[4], $seperated[5], $seperated[6], $seperated[7]);
        $numberPostFix = "cror";
    }else{
        die("i am dying here. check me on index.php: 137");
    }

    $key2 = sixDigit($d2 . "" . $d3, $d4, $d5, $d6, $d7, $d8);

    return $key1 . " " . $numberPostFix . " " . $key2;
}

function expressInWord($input) {
    if (strlen($input) == 1) {
        return oneDigit($input);
    } else if (strlen($input) == 2) {
        $inputSplited = str_split($input);
        return twoDigit($inputSplited[0], $inputSplited[1]);
    } else if (strlen($input) == 3) {
        $inputSplited = str_split($input);
        return threeDigit($inputSplited[0], $inputSplited[1], $inputSplited[2]);
    } else if (strlen($input) == 4) {
        $inputSplited = str_split($input);
        return fourDigit($inputSplited[0], $inputSplited[1], $inputSplited[2], $inputSplited[3]);
    } else if (strlen($input) == 5) {
        $inputSplited = str_split($input);
        return fourDigit($inputSplited[0] . $inputSplited[1], $inputSplited[2], $inputSplited[3], $inputSplited[4]);
    } else if (strlen($input) == 6) {
        $inputSplited = str_split($input);
        return sixDigit($inputSplited[0], $inputSplited[1], $inputSplited[2], $inputSplited[3], $inputSplited[4], $inputSplited[5]);
    } else if (strlen($input) == 7) {
        $inputSplited = str_split($input);
        return sixDigit($inputSplited[0] . $inputSplited[1], $inputSplited[2], $inputSplited[3], $inputSplited[4], $inputSplited[5], $inputSplited[6]);
    } else if (strlen($input) == 8) {
        $inputSplited = str_split($input);
        return eightDigit($inputSplited[0], $inputSplited[1], $inputSplited[2], $inputSplited[3], $inputSplited[4], $inputSplited[5], $inputSplited[6], $inputSplited[7]);
    } else if (strlen($input) == 9) {
        $inputSplited = str_split($input);
        return eightDigit($inputSplited[0] . $inputSplited[1], $inputSplited[2], $inputSplited[3], $inputSplited[4], $inputSplited[5], $inputSplited[6], $inputSplited[7], $inputSplited[8]);
    } else if (strlen($input) == 10) {
        $inputSplited = str_split($input);
        return eightDigit($inputSplited[0] . $inputSplited[1] . $inputSplited[2], $inputSplited[3], $inputSplited[4], $inputSplited[5], $inputSplited[6], $inputSplited[7], $inputSplited[8], $inputSplited[9]);
    } else if (strlen($input) == 11) {
        $inputSplited = str_split($input);
        return eightDigit($inputSplited[0] . $inputSplited[1] . $inputSplited[2] . $inputSplited[3], $inputSplited[4], $inputSplited[5], $inputSplited[6], $inputSplited[7], $inputSplited[8], $inputSplited[9], $inputSplited[10]);
    } else if (strlen($input) == 12) {
        $inputSplited = str_split($input);
        return eightDigit($inputSplited[0] . $inputSplited[1] . $inputSplited[2] . $inputSplited[3] . $inputSplited[4], $inputSplited[5], $inputSplited[6], $inputSplited[7], $inputSplited[8], $inputSplited[9], $inputSplited[10], $inputSplited[11]);
    } else if (strlen($input) == 13) {
        $inputSplited = str_split($input);
        return eightDigit($inputSplited[0] . $inputSplited[1] . $inputSplited[2] . $inputSplited[3] . $inputSplited[4] . $inputSplited[5], $inputSplited[6], $inputSplited[7], $inputSplited[8], $inputSplited[9], $inputSplited[10], $inputSplited[11], $inputSplited[12]);
    }else if (strlen($input) == 14) {
        $inputSplited = str_split($input);
        return eightDigit($inputSplited[0] . $inputSplited[1] . $inputSplited[2] . $inputSplited[3] . $inputSplited[4] . $inputSplited[5].$inputSplited[6], $inputSplited[7], $inputSplited[8], $inputSplited[9], $inputSplited[10], $inputSplited[11], $inputSplited[12], $inputSplited[13]);
    }else if (strlen($input) == 15) {
        $inputSplited = str_split($input);
        return eightDigit($inputSplited[0] . $inputSplited[1] . $inputSplited[2] . $inputSplited[3] . $inputSplited[4] . $inputSplited[5].$inputSplited[6].$inputSplited[7], $inputSplited[8], $inputSplited[9], $inputSplited[10], $inputSplited[11], $inputSplited[12], $inputSplited[13], $inputSplited[14]);
    }else {
        return "Limit exceeds! Limit: 999999999999999 (15 digits)";
    }
}
?>
<form action="index.php" method="post">
    <table>
        <tr>
            <th colspan="3">Express your amount/digits in word<hr/></th>
        </tr>
        <tr>
            <th>Input (Digits)</th>
            <td><input type="text" name="inputDigit" style="width: 100%;" value="<?php if (isset($_POST['inputDigit'])) {
    echo $_POST['inputDigit'];
} ?>"/></td>
            <td><input type="submit" value="Express"/></td>
        </tr>
        <tr>
            <th>Output (In Word)</th>
            <td colspan="3">
                <?php
                if (isset($_POST['inputDigit'])) {
                    $input = $_POST['inputDigit'];
                    if ($input != "") {
                        ?>
                        <div style="float: left; width: 100%; border: 1px solid blueviolet; margin-bottom: 5px; padding: 4px;">
                        <?php echo expressInWord($input); ?>
                        </div>
                        <?php
                    }
                }
                ?>
            </td>
        </tr>
    </table>
</form>

Tuesday, June 24, 2014

Change the color of the menu item which is selected currently

<div id="menuDiv">
        <ul>
               <li><a href="/site/index">Home</a></li>
               <li><a href="/site/gallery">Gallery</a></li>
        </ul>
</div>

<style>
       
#menuDiv ul li a.active{
              color: yellow;
        }

</style>


<script type="text/javascript">
  $(fu
nction (){
      var phpPath="<?php echo $_SERVER['REQUEST_URI'] ?>";
      $('#menuDiv ul li a').each(function(){
          var url = $(this).attr('href');
          if(url == phpPath){
              $(this).addClass('active');
          };
       });
  });

</script>

Make a multi level (No fixed level as 3 level OR 4 level, NO HARD CODE) dynamic Drop-Down Menu

People often make a menu (for website OR for sofware) , and often they (not everyone) make it static, as like (main menu item, sub menu, sub - sub menu)

maximum three level menu.

and they write down the code as a HARD code.


SO, i am here to teach you how can you make your menu multi leveled, as i said,

you can make your menu as "main menu item -> sub- menu item -> sub-sub menu item -> sub-sub-sub menu item....... and

unlimited sub items.... no bound."


first of all,

you have to make a table, with rows ->

id (int PK), menu_item_name (varchar), root (int)

thats it,

now, give the root column a default value (0),

the purpose is -- ( if you give no root to an entry, it will take 0 as default )

and we take that item as our MAIN MENU ITEM,

now, insert some data like below,




id menu_item_name root
1 Home 0
2 About Us 0
3 Contact Us 0
4 Portfolio 0
5 Security Product 4
6 Safety Product 4
7 Comfort Product 4
8 Security Product 1 5
9 Security Product 2 5
10 Safety Product 1 6
11 Safety Product 2 6
12 Comfort Product1 7
13 Comfort Product2 7
14 Security Product1's Sub Product1 8
15 Security Product1's Sub Product2 8
etc........................


And now, we have to run the query to fetch items from the table,


1. first of all, fetch all items who has the root = 0  (main items)



2. then, you have to pass these above item's ids to a recursive function,


query_for_main_items: >>

        $data=fetch_items_with_id_where_root=0

        echo "<ul>";
        foreach($data as $d):
              echo "<li>".$d->menu_item_name."</li>";
              fetchAllItemsOfThisRoot($d->id); // recursive function calling.. for first time.
        endforeach;
        echo "</ul>";


query_for_sub_menu_items: >> 

        fetchAllItemsOfThisRoot($root_id){

              $data=fetch_items_with_id_where_root=$root_id
              echo "<ul>";
              foreach($data as $d):
                     echo "<li>".$d->menu_item_name."</li>";
                     fetchAllItemsOfThisRoot($d->id); // recursive function calling..
              endforeach;
             echo "</ul>";
        }


thats it,

if i get the feedback, i will proceed to the next level, where you will give the address
link to each of the items generated above, dynamically


Thanks in advance...
   

Sunday, January 8, 2012

JQuery Bangla Calender

Here is my JQuery BanglaCalender For Developers who wand to add date-time into Database with Bangla calender with This Format ০৮ তারিখ রবিবার, জানুয়ারি, ২০১২ , সময়: ১০:৫৫:০২ সকাল

So, Here is my link: BanglaCalender

Friday, November 25, 2011

♫ DOWNLOAD FILE FROM DB

we need two php file (a) file_download.php and (b) file_download2.php (make sure you have 'upload' directory from where the files would be downloaded)

♫ UPLOAD FILE IN DB:

first of all create a new directory named "upload"
then, create a database and table with this code (here db creation code is not present as i created db manualy with db creation code):

♫ SHOW BANGLA INFO. FROM DB:

just write the following code and save it as showbangla.php:

♫ ADD BANGLA INFO. IN DB:

when creating database , select the charset to utf8 and collation to utf8_general_ci
now write the following code and save it as banglainsert.php:

SignIn and SignUp page

Here you can download the whole files for this topic. Click Here

♫ INSERT & DELETE DATA IN DB:

write php code and save it as dbinsert.php

♫ CONNECT DB WITH PHP:

simply write the php code in the first line

♫ SHOW DB CONTENTS:

To show the database contents:

♫ HOW TO CREATE DATABASE & TABLE WITH PHP:

Create db with this: