ElaKiri Programmer's Club

Fox Mulder89

Well-known member
  • Dec 31, 2012
    2,460
    942
    113
    gampaha
    යාලුවනේ මට ලොකු ප්‍රශ්නයක් තියනවා. මම කොම්පනි එහෙකට ගියා trainee php developer කෙනෙක් විදිහට. දැන් මට java,c# , Android වගේ Languages ඉගන ගන්න වෙලා. මම වගේ ලොකුවටම දන්නේ නැහැ.මම දන්නේ නිස අනෙක් project වලට දායක වෙන්නත් බැහැ. මට ලොකු වැඩක් ලබුනෙත් නැහැ.

    මට එක කිවේ එ Languages ටික ඉගන ගන්න කියලා. මට දැන ගන ඔනේ මට මේ ලැබුන අවස්තව හොදයි ද නැත්නම් php dev කෙනෙක් විදිහට වැඩ කරන වෙන තැනකට යන්නද ?

    ඔය languages යම් තරම් දුරකට ඉගන ගන්න අඩුම ගානේ අවුරුද්දක්වත් යනවනේ.
    මටත් හිතා ගන්න බැහැ.

    Company staff is good :yes::yes: really friendly!!!

     

    Ayeshlive

    Well-known member
  • Jul 1, 2011
    10,570
    943
    113
    *̶͑̾̾​̅ͫ͏̙̤g͛͆̾ͫ̑͆&
    යාලුවනේ මට ලොකු ප්‍රශ්නයක් තියනවා. මම කොම්පනි එහෙකට ගියා trainee php developer කෙනෙක් විදිහට. දැන් මට java,c# , Android වගේ Languages ඉගන ගන්න වෙලා. මම වගේ ලොකුවටම දන්නේ නැහැ.මම දන්නේ නිස අනෙක් project වලට දායක වෙන්නත් බැහැ. මට ලොකු වැඩක් ලබුනෙත් නැහැ.

    මට එක කිවේ එ Languages ටික ඉගන ගන්න කියලා. මට දැන ගන ඔනේ මට මේ ලැබුන අවස්තව හොදයි ද නැත්නම් php dev කෙනෙක් විදිහට වැඩ කරන වෙන තැනකට යන්නද ?

    ඔය languages යම් තරම් දුරකට ඉගන ගන්න අඩුම ගානේ අවුරුද්දක්වත් යනවනේ.
    මටත් හිතා ගන්න බැහැ.

    Company staff is good :yes::yes: really friendly!!!

    More languages you know, the better.
     

    Hasistranger

    Well-known member
  • Oct 21, 2010
    13,426
    7,103
    113
    Western Province, SL
    my-journal-view.vercel.app
    මචන්ලා ,මට ආසාවක් තියෙනවා java වලින් port program එකක් හදන්න , ප්‍රශ්නයකට තියෙන්නේ මන් පාවිච්චි කරන්නේ laptop එකක් windows 8 , 64bit , එකේ තියෙන්නේ usb ports විතරයි .මන් ගත්ත usb - parallel cable එකක්.

    මට දන්නා කෙනෙක් කියනවද මේ තියෙන දේවල් වලින් java වලින් port program එකක් හදන්න හැටි.මන් RXTX library එකෙන් try කලා .එත් program එකෙන් කිසිමport එකක් පෙන්නන්නේ නැහැනේ
     

    Error365!

    Well-known member
  • Jun 27, 2012
    12,843
    9,225
    113
    එක තැනක නෑ
    machanlaa mata kiyanawada javascript walin kohomada kiyala mysql db ekak access karanne. mata one php nathuwa javascript file eka athule function ekakin db eka access karanna. help ekak deepalaaa. mama web paththata aluth :)
     

    DJvodka

    Well-known member
  • Mar 31, 2009
    3,375
    292
    83
    A land like no other
    machanlaa mata kiyanawada javascript walin kohomada kiyala mysql db ekak access karanne. mata one php nathuwa javascript file eka athule function ekakin db eka access karanna. help ekak deepalaaa. mama web paththata aluth :)

    Client server application ekak neweida hadanna yanne? DB eka mysql ma wenna onada? nosql hariyanne nedda?
     

    Error365!

    Well-known member
  • Jun 27, 2012
    12,843
    9,225
    113
    එක තැනක නෑ
    Client server application ekak neweida hadanna yanne? DB eka mysql ma wenna onada? nosql hariyanne nedda?

    client server ekak thamai machan. mama javascript walin podi chart tikak haduwa js walin. charts 16k vitahra. mata one ewa walata data parse karanna. mama web paththata aluth ban ekai. php html5 boostrap js walin hadanne ban. mata thama loku knowladge ekak naha web gana. self parak dagena karanna. expenses management system ekak hadanne ban. puluwan nam help ekak diyan machan :) thanks
     

    DJvodka

    Well-known member
  • Mar 31, 2009
    3,375
    292
    83
    A land like no other
    client server ekak thamai machan. mama javascript walin podi chart tikak haduwa js walin. charts 16k vitahra. mata one ewa walata data parse karanna. mama web paththata aluth ban ekai. php html5 boostrap js walin hadanne ban. mata thama loku knowladge ekak naha web gana. self parak dagena karanna. expenses management system ekak hadanne ban. puluwan nam help ekak diyan machan :) thanks

    Machan javascript kiyanne client side technology ekak. Ekata mysql driver ekak ne. Eka nisa js walin mysql direct access karanna be. Aniwa php hari java hari nettam wena server side technology ekak use karanna wenawa.

    Eg: php

    1. Php walin webservice ekak liyanawa xml walin mysql eke data ganna

    2. Ita passe ajax walin call karanawa e service eka

    3. Den javascript walata e xml data tika convert karala chart walata pass karagann puluwan.
     
    • Like
    Reactions: Error365!

    Error365!

    Well-known member
  • Jun 27, 2012
    12,843
    9,225
    113
    එක තැනක නෑ
    Machan javascript kiyanne client side technology ekak. Ekata mysql driver ekak ne. Eka nisa js walin mysql direct access karanna be. Aniwa php hari java hari nettam wena server side technology ekak use karanna wenawa.

    Eg: php

    1. Php walin webservice ekak liyanawa xml walin mysql eke data ganna

    2. Ita passe ajax walin call karanawa e service eka

    3. Den javascript walata e xml data tika convert karala chart walata pass karagann puluwan.

    thanks machan :)
    machan node.js walin puluwanda mysql direct access karanna?

    machan mata umba kiyapu eka theruna eth mata practically eka use karana eka gana hithaganna amarui. puluwan nam welawa thiyanwa nam podi sample ekak diyan machan :) Thanks
     

    DJvodka

    Well-known member
  • Mar 31, 2009
    3,375
    292
    83
    A land like no other
    thanks machan :)
    machan node.js walin puluwanda mysql direct access karanna?

    machan mata umba kiyapu eka theruna eth mata practically eka use karana eka gana hithaganna amarui. puluwan nam welawa thiyanwa nam podi sample ekak diyan machan :) Thanks

    node.js walin puluwan ekat php wage thamai.

    man kiwwe mekai. Den api hitamu ube eka chart ekak thiyenawa monthly user ekenk ge spendings tika. Eg : Transportation 25000, accommodation 30000 kiyala. Ethakota oya data tika thiyenne mysql wala. Den api hithamu uba hadana system eka web based ekak. Ekiyanne onama kenekta oke account ekak hada gena data enter karanna puluwan wenna. Ethakota user ge control panel eke thamai oya chart tika display karanna ona kiyala hithamu. Den me control panel page eke thamai ubage javascript tika liyala thiyenne. Mewata ethakota data ganna ona mysql walin. Ethakota php wage use karanawanam apita puluwan me awashya data tika mysql haraha script ekakin ganna. Ethakota me data enne xml file ekak widiyata. Ita passe me xml file eke data walin chart tika draw karaganna puluwan.
     

    Error365!

    Well-known member
  • Jun 27, 2012
    12,843
    9,225
    113
    එක තැනක නෑ
    node.js walin puluwan ekat php wage thamai.

    man kiwwe mekai. Den api hitamu ube eka chart ekak thiyenawa monthly user ekenk ge spendings tika. Eg : Transportation 25000, accommodation 30000 kiyala. Ethakota oya data tika thiyenne mysql wala. Den api hithamu uba hadana system eka web based ekak. Ekiyanne onama kenekta oke account ekak hada gena data enter karanna puluwan wenna. Ethakota user ge control panel eke thamai oya chart tika display karanna ona kiyala hithamu. Den me control panel page eke thamai ubage javascript tika liyala thiyenne. Mewata ethakota data ganna ona mysql walin. Ethakota php wage use karanawanam apita puluwan me awashya data tika mysql haraha script ekakin ganna. Ethakota me data enne xml file ekak widiyata. Ita passe me xml file eke data walin chart tika draw karaganna puluwan.

    hari machan mata theruna. ethakota machan php walin mama sql db ekaka data aragena e data eka variable ekakata aragena script ekata parse karana ekada? mama poddak umba kiyapu ekata sample ekak hoyala balannam.

    machan mama danata custom js file ekak liyala thiyanawa me eke chart eke codes. mama meka income kiyana array ekata thamai data ganna one. danata mama randomly values tikaka add karanawa mage function ekakin.

    Code:
        /* ---------- income with points ---------- */
        if ($("#incomeChart").length)
        {
            var income = [[1, randNum() - 10], [2, randNum() - 10], [3, randNum() - 10], [4, randNum()], [5, randNum()], [6, 4 + randNum()], [7, 5 + randNum()], [8, 6 + randNum()], [9, 6 + randNum()], [10, 8 + randNum()], [11, 9 + randNum()], [12, 10 + randNum()], [13, 11 + randNum()], [14, 12 + randNum()], [15, 13 + randNum()], [16, 14 + randNum()], [17, 15 + randNum()], [18, 15 + randNum()], [19, 16 + randNum()], [20, 17 + randNum()], [21, 18 + randNum()], [22, 19 + randNum()], [23, 20 + randNum()], [24, 21 + randNum()], [25, 14 + randNum()], [26, 24 + randNum()], [27, 25 + randNum()], [28, 26 + randNum()], [29, 27 + randNum()], [30, 31 + randNum()], [31, 31 + randNum()]];
    
            var plot = $.plot($("#incomeChart"),
                    [{data: income, label: "Income"}], {
                series: {
                    lines: {show: true,
                        lineWidth: 3,
                        fill: true, fillColor: {colors: [{opacity: 0.5}, {opacity: 0.2}]}
                    },
                    points: {show: true},
                    shadowSize: 2
                },
                grid: {hoverable: true,
                    clickable: true,
                    tickColor: "#eee",
                    borderWidth: 0,
                },
                colors: ["#b1d3d4"],
                xaxis: {ticks: 11, tickDecimals: 0},
                yaxis: {ticks: 11, tickDecimals: 0},
            });
    
            function showTooltip(x, y, contents) {
                $('<div id="tooltip">' + contents + '</div>').css({
                    position: 'absolute',
                    display: 'none',
                    top: y + 5,
                    left: x + 5,
                    border: '1px solid #fdd',
                    padding: '2px',
                    'background-color': '#dfeffc',
                    opacity: 0.80
                }).appendTo("body").fadeIn(200);
            }
    
            var previousPoint = null;
            $("#incomeChart").bind("plothover", function(event, pos, item) {
                $("#x").text(pos.x.toFixed(2));
                $("#y").text(pos.y.toFixed(2));
    
                if (item) {
                    if (previousPoint != item.dataIndex) {
                        previousPoint = item.dataIndex;
    
                        $("#tooltip").remove();
                        var x = item.datapoint[0].toFixed(0),
                                y = item.datapoint[1].toFixed(2);
    
                                 //--------------------
                        var d = new Date();
                        var month = new Array();
                        month[0] = "January";
                        month[1] = "February";
                        month[2] = "March";
                        month[3] = "April";
                        month[4] = "May";
                        month[5] = "June";
                        month[6] = "July";
                        month[7] = "August";
                        month[8] = "September";
                        month[9] = "October";
                        month[10] = "November";
                        month[11] = "December";
                        var n = month[d.getMonth()];
                        var dnm = "";
                        
                        if(x.toString() === "1"){
                            dnm = "st";
                        }else if(x.toString() === "2"){
                            dnm = "nd";
                        }else if(x.toString() === "3"){
                            dnm = "rd";
                        }else if(x.toString() === "21"){
                            dnm = "st";
                        }else if(x.toString() === "22"){
                            dnm = "nd";
                        }else if(x.toString() === "23"){
                            dnm = "rd";
                        }else if(x.toString() === "31"){
                            dnm = "st";
                        }else{
                            dnm = "th";
                        }
                        
                        showTooltip(item.pageX, item.pageY,
                                item.series.label + " of " + d.getFullYear() + " " + n + " " + x + dnm +" is Rs." + y);
                    }
                }
                else {
                    $("#tooltip").remove();
                    previousPoint = null;
                }
            });
    
    
    
            $("#sincos").bind("plotclick", function(event, pos, item) {
                if (item) {
                    $("#clickdata").text("You clicked point " + item.dataIndex + " in " + item.series.label + ".");
                    plot.highlight(item.series, item.datapoint);
                }
            });
        }


    passe me code eken thamai machan mama html page ekedi mage chart eka visible karanne

    HTML:
    <div class="span8 widget orange" onTablet="span7" onDesktop="span8">
                                <h2><span class="glyphicons charts"><i></i></span>Expenses chart</h2>
                                <hr>
                                <div id="expensesChart"  style="height:282px" ></div>
    
                            </div>

    umbata idea ekak awada mama akrana wade gana machan

    thank machan help karata. mama me gana study kara kara hadagena yanne ban. smahara than patalenawa
     

    DJvodka

    Well-known member
  • Mar 31, 2009
    3,375
    292
    83
    A land like no other
    hari machan mata theruna. ethakota machan php walin mama sql db ekaka data aragena e data eka variable ekakata aragena script ekata parse karana ekada? mama poddak umba kiyapu ekata sample ekak hoyala balannam.

    machan mama danata custom js file ekak liyala thiyanawa me eke chart eke codes. mama meka income kiyana array ekata thamai data ganna one. danata mama randomly values tikaka add karanawa mage function ekakin.

    Code:
        /* ---------- income with points ---------- */
        if ($("#incomeChart").length)
        {
            var income = [[1, randNum() - 10], [2, randNum() - 10], [3, randNum() - 10], [4, randNum()], [5, randNum()], [6, 4 + randNum()], [7, 5 + randNum()], [8, 6 + randNum()], [9, 6 + randNum()], [10, 8 + randNum()], [11, 9 + randNum()], [12, 10 + randNum()], [13, 11 + randNum()], [14, 12 + randNum()], [15, 13 + randNum()], [16, 14 + randNum()], [17, 15 + randNum()], [18, 15 + randNum()], [19, 16 + randNum()], [20, 17 + randNum()], [21, 18 + randNum()], [22, 19 + randNum()], [23, 20 + randNum()], [24, 21 + randNum()], [25, 14 + randNum()], [26, 24 + randNum()], [27, 25 + randNum()], [28, 26 + randNum()], [29, 27 + randNum()], [30, 31 + randNum()], [31, 31 + randNum()]];
    
            var plot = $.plot($("#incomeChart"),
                    [{data: income, label: "Income"}], {
                series: {
                    lines: {show: true,
                        lineWidth: 3,
                        fill: true, fillColor: {colors: [{opacity: 0.5}, {opacity: 0.2}]}
                    },
                    points: {show: true},
                    shadowSize: 2
                },
                grid: {hoverable: true,
                    clickable: true,
                    tickColor: "#eee",
                    borderWidth: 0,
                },
                colors: ["#b1d3d4"],
                xaxis: {ticks: 11, tickDecimals: 0},
                yaxis: {ticks: 11, tickDecimals: 0},
            });
    
            function showTooltip(x, y, contents) {
                $('<div id="tooltip">' + contents + '</div>').css({
                    position: 'absolute',
                    display: 'none',
                    top: y + 5,
                    left: x + 5,
                    border: '1px solid #fdd',
                    padding: '2px',
                    'background-color': '#dfeffc',
                    opacity: 0.80
                }).appendTo("body").fadeIn(200);
            }
    
            var previousPoint = null;
            $("#incomeChart").bind("plothover", function(event, pos, item) {
                $("#x").text(pos.x.toFixed(2));
                $("#y").text(pos.y.toFixed(2));
    
                if (item) {
                    if (previousPoint != item.dataIndex) {
                        previousPoint = item.dataIndex;
    
                        $("#tooltip").remove();
                        var x = item.datapoint[0].toFixed(0),
                                y = item.datapoint[1].toFixed(2);
    
                                 //--------------------
                        var d = new Date();
                        var month = new Array();
                        month[0] = "January";
                        month[1] = "February";
                        month[2] = "March";
                        month[3] = "April";
                        month[4] = "May";
                        month[5] = "June";
                        month[6] = "July";
                        month[7] = "August";
                        month[8] = "September";
                        month[9] = "October";
                        month[10] = "November";
                        month[11] = "December";
                        var n = month[d.getMonth()];
                        var dnm = "";
                        
                        if(x.toString() === "1"){
                            dnm = "st";
                        }else if(x.toString() === "2"){
                            dnm = "nd";
                        }else if(x.toString() === "3"){
                            dnm = "rd";
                        }else if(x.toString() === "21"){
                            dnm = "st";
                        }else if(x.toString() === "22"){
                            dnm = "nd";
                        }else if(x.toString() === "23"){
                            dnm = "rd";
                        }else if(x.toString() === "31"){
                            dnm = "st";
                        }else{
                            dnm = "th";
                        }
                        
                        showTooltip(item.pageX, item.pageY,
                                item.series.label + " of " + d.getFullYear() + " " + n + " " + x + dnm +" is Rs." + y);
                    }
                }
                else {
                    $("#tooltip").remove();
                    previousPoint = null;
                }
            });
    
    
    
            $("#sincos").bind("plotclick", function(event, pos, item) {
                if (item) {
                    $("#clickdata").text("You clicked point " + item.dataIndex + " in " + item.series.label + ".");
                    plot.highlight(item.series, item.datapoint);
                }
            });
        }


    passe me code eken thamai machan mama html page ekedi mage chart eka visible karanne

    HTML:
    <div class="span8 widget orange" onTablet="span7" onDesktop="span8">
                                <h2><span class="glyphicons charts"><i></i></span>Expenses chart</h2>
                                <hr>
                                <div id="expensesChart"  style="height:282px" ></div>
    
                            </div>

    umbata idea ekak awada mama akrana wade gana machan

    thank machan help karata. mama me gana study kara kara hadagena yanne ban. smahara than patalenawa

    Den uba random data gatte var income kiyana variable ekatane. menna me variable ekata data tika load karaganna ona mysql db eken. Meka karanna krama 2k thiyenawa.

    1. Page eka load wenna kalin php walin javascript variable ekata data liyana eka.

    2. Page eka load wunata passe Ajax walin data ganna eka.

    2 wani kramen karanawanam ubata php walin page ekak hada ganna wenawa data tika penannan Eg: localhost:8080/show-results.php?user=saman. Den me page ekata giyama data tika show karanna ona xml hari json hari format ekakin. Eg:

    [500,300,200]

    Ethakota ajax walin puluwan ara script eka call karala income variable eka load karaganna me widiyata.

    Code:
    $.getJSON( "/show-results.php?user=saman", function( data ) {
      var income = [];
      $.each( data, function( key, val ) {
        income.push( val );
      });
    });
     

    Error365!

    Well-known member
  • Jun 27, 2012
    12,843
    9,225
    113
    එක තැනක නෑ
    Den uba random data gatte var income kiyana variable ekatane. menna me variable ekata data tika load karaganna ona mysql db eken. Meka karanna krama 2k thiyenawa.

    1. Page eka load wenna kalin php walin javascript variable ekata data liyana eka.

    2. Page eka load wunata passe Ajax walin data ganna eka.

    2 wani kramen karanawanam ubata php walin page ekak hada ganna wenawa data tika penannan Eg: localhost:8080/show-results.php?user=saman. Den me page ekata giyama data tika show karanna ona xml hari json hari format ekakin. Eg:

    [500,300,200]

    Ethakota ajax walin puluwan ara script eka call karala income variable eka load karaganna me widiyata.

    Code:
    $.getJSON( "/show-results.php?user=saman", function( data ) {
      var income = [];
      $.each( data, function( key, val ) {
        income.push( val );
      });
    });

    thanks macho e wade karagaththa :D
    mata thawa problem ekaka awa.

    mage db eka thiyanne mehema kiyala hithamu machan

    table = tbl_tst

    clm_num clm_amnt

    1 - 25000
    2 - 31700
    5 - 52900
    8 - 45000

    mata one machan me data tika me widihata array ekakata ganna php ekedi

    Ex:
    Code:
    $temp = array([1,25000],[2,31700],[5,52900],[8,45000]);

    -

    passe mama js ekedi me widihata var ekak hadagannawa php eke thiyana array eka.

    Code:
    var jsArray = <? echo json_encode($temp); ?>;

    mama chart eke data vidihata denne jsArray kiyana var eka.

    mama kohomada machan mage table eke thiyana data tika php array ekata me vidihata ganne?

    Code:
    $temp = array([1,25000],[2,31700],[5,52900],[8,45000]);

    Thanks machan help walata :)
     
    Last edited:

    DJvodka

    Well-known member
  • Mar 31, 2009
    3,375
    292
    83
    A land like no other
    thanks macho e wade karagaththa :D
    mata thawa problem ekaka awa.

    mage db eka thiyanne mehema kiyala hithamu machan

    table = tbl_tst

    clm_num clm_amnt

    1 - 25000
    2 - 31700
    5 - 52900
    8 - 45000

    mata one machan me data tika me widihata array ekakata ganna php ekedi

    Ex:
    Code:
    $temp = array([1,25000],[2,31700],[5,52900],[8,45000]);

    -

    passe mama js ekedi me widihata var ekak hadagannawa php eke thiyana array eka.

    Code:
    var jsArray = <? echo json_encode($temp); ?>;

    mama chart eke data vidihata denne jsArray kiyana var eka.

    mama kohomada machan mage table eke thiyana data tika php array ekata me vidihata ganne?

    Code:
    $temp = array([1,25000],[2,31700],[5,52900],[8,45000]);

    Thanks machan help walata :)

    Dala washayen ubata idea ekak ganna me code eka balapan. Man test kare nam ne.


    Code:
    <?php
    // Make a MySQL Connection
    $query = "SELECT * FROM tbl_tst"; 
    	 
    $result = mysql_query($query) or die(mysql_error());
    $valueMap = array();
    while($row = mysql_fetch_array($result)){
            $valueMap[$row['clm_num']] = $row['clm_amnt'];
    }
    ?>
    
    var jsArray = <? echo json_encode($valueMap); ?>;