khoand0000

• 1st way (I don't like it, it's long) but it suits for checking object has the field or not (2nd way is not applied)

var attr = $(this).attr('name');

// For some browsers, `attr` is undefined; for others, `attr` is false. Check for both.
if (typeof attr !== typeof undefined && attr !== false) {
  // Element has this attribute
}

khoand0000

$number = 1234.56;

// let's print the international format for the en_US locale
setlocale(LC_MONETARY, 'en_US');
echo money_format('%i', $number) . "\n";
// USD 1,234.56

// but if using vi_VN or vi_VN.UTF-8, not working
setlocale(LC_MONETARY, 'vi_VN');
echo money_format('%i', $number) . "\n";

khoand0000

PHP 7

• Scalar type declarations
• Return type declarations
• Null coalescing operator
• Spaceship operator
• Constant arrays using define()
• Anonymous classes
• Unicode codepoint escape syntax
• [Closure::call()](http://php.net/manual/en/closure.call

khoand0000

Install php7 with pear

$ brew tap homebrew/dupes
$ brew tap homebrew/versions
$ brew tap homebrew/homebrew-php
$ brew install php70 --with-pear

Enable php7 with apache2

khoand0000

I have not implemented any below solutions. But I think the first reference is good

References:

• https://blog.bitexpert.de/blog/think-about-it-phpexcel-performance-tweaks-part-1/
• http://stackoverflow.com/questions/4817651/phpexcel-runs-out-of-256-512-and-also-1024mb-of-ram
• PHPOffice/PHPExcel#420
• https://github.com/PHPOffice/PHPExcel/blob/develop/Documentation/markdown/Overview/04-Configuration-Settings.md

khoand0000

<?php

try {

    $conn = odbc_connect(
        "DRIVER={SQL Server};Server=tcp:ac1wr559wv.database.windows.net,1433;Database=1407_test",
        "project", "Plastic48");
    $cur = odbc_exec($conn, "select username, password, address from users");
    while (odbc_fetch_row($cur)) {
//collect results

khoand0000

• $ionicModal: show dialog (must provide UI) at center screen if large screen (ipad, pc); otherwise, showing fullscreen overlays current screen, allow close modal by clicking backdrop
• $ionicPopover: show dialog (must provide UI) at element occurs event (button), allow close modal by clicking backdrop
• $ionicPopup: show dialog (confirm, alert, prompt or custome) at center screen, doesn't allow close modal by clicking backdrop

khoand0000

usage

• return collection. *http code: 200

[
  {id:1},
  {id:2}
]

• return single object. http code: 200

khoand0000

reference:

• https://css-tricks.com/fluid-width-equal-height-columns/

khoand0000

Take note when using https://css-tricks.com/centering-css-complete-guide/

• Vertically
  • Is it inline or inline-* elements (like text or links)?
    • Is it a single line?
      • don't know height of element: padding-top == padding-bottom
      • know height of element: using line-height

          .center-text-trick {

height: 100px; /* apply inline-block element, inline element doesn't need it */