RSS

  • YouTube
  • LinkedIn
  • Google

Using jQueryMask Plugin to format dates in different patterns

Compartilhe em suas mídias sociais
  • 1
  •  
  •  
  •  
  •  
  •  
  •  

jQuery Mask Plugin is a great Javascript library to format fields for presentation and/or to force a properly input by users.

Here, I show how to deal with input or another HTML element to display dates when the source date has a different format from target element.

Example:

  • We have a datetime with Year-Month-Day Hour:Minute:Seconds and need to show only the Year/Month/Day part.
  • We have da date in Year-Month-Day and need to format to Day/Month/Year.

jQueryMask is very simple to use. It do not need to much to mask whatever you need. Take a look at examples on his website.

If you need to format a simple date field (even in a non-input element), just use the code below.

The code above can mask and pre-validate dates in YEAR/MONTH/DAY format.

With an input like

would be changed his value to 2018/06/11.

If you try to type another date (after clear, of course) you cannot begin with a number different from 1 or 2. This reason is that our mask have a translation to be done when allowing chars. If the pattern does not match, the char is erased.

The meaning of “TC99/M9/D9” mask is:

  • Must begin with 1 or 2 (Translation T: /[12]/ – Custom format)
  • Must have number 0 or 9 (Translation C: /[09]/ – Custom format)
  • Must have a number (any) (Translation 9 – MaskPlugin Core format)
  • Must have a number (any) (Translation 9 – MaskPlugin Core format)
  • A slash will be added automatic ( / )
  • Must have number 0 or 1 (Translation M: /[01]/ – Custom format)
  • Must have a number (any) (Translation 9: MaskPlugin Core format)
  • A slash will be added automatic ( / )
  • Must have number 0, 1, 2 or 3 (Translation D: /[0-3]/ – Custom format)
  • Must have a number (any) (Translation 9: MaskPlugin Core format)

Of course, there is no real validation. You can type “2999/19/39” and this is not a valid date, but is almost done.

So, to format in another way, just change mask parameter order.

But, if the source date is in a different pattern, like MONTH/DAY/YEAR, the mask do not work. The date output for “06/11/2018 15:40” will be weird “1018/15/0“.

To handle different date formats will be needed more than simple mask. We will need a function.

Look the code below

Now we have two more Translation Pattern (h and m). h means that the n-index position must have numbers 0, 1 or 2 and m numbers between 0 and 5. Keep in mind that CASE matters.

With the above code, we can format and show date in several ways. just change .test() and .replace() pattern to fill your desired pattern.

This is the code that I am using to format Database datetime fields with YEAR-MONTH-DAY HOUR:MINUTE:SECOND in html elements with DAY/YEAR/MONTH HOUR:MINUTE

With an input like

Output will be 11/06/2018 15:40

Hope this help you!


Compartilhe em suas mídias sociais
  • 1
  •  
  •  
  •  
  •  
  •  
  •  

Binding several values in PDO SQL Statement (PDOStatement)

Compartilhe em suas mídias sociais
  • 2
  •  
  •  
  •  
  •  
  •  
  •  

Sometimes we need to search a single value through several columns when building SQL instructions.

Suppose the table below

  • [ENTITY_ONE]
    • ID
    • COLUMN_A
    • COLUMN_B
    • COLUMN_C
    • COLUMN_D
    • COLUMN_E

If we need search a single value on columns B,D and E we will need use the following instruction

In PHP code we can do

Well, this can work but we know that isn’t the best approach. We need use Binding Values to avoid SQL injection and other malicious treats.

So, the code can be modified to

Much better, but, when building complex SQL instruction, things can be confusing with lots of arguments and don’t forget: ORDER MATTERS.

Happily PDO can bind values in different order when using named bindings.

Hmm, seems that this isn’t good enough. We only change the use of 1-indexed placeholder to a :named placeholder. There’s no gain beyond of code readable and the possibility to bind in any order.

Yes, but now we can do the best approach when using one unique search term in several columns. We can use only one bind to one or more :named placeholders ’cause PDO is smart and clever. Look our final code here.

Can save a lot of typing when writing many SQL instruction using same argument.


Compartilhe em suas mídias sociais
  • 2
  •  
  •  
  •  
  •  
  •  
  •  

Correcting modules not loaded error on Centos 6. x

Share in your social media
  • 1
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;

A common problem after upgrading a kernel via yum on Centos is not creating the new kernel modules.
An example of this error happens when you try to use grep as in the print below.

This indicates that the directory 2.6.32-042stab 123.9 and therefore any module in your content can be loaded.

To correct this problem, the simplest way is this recipe:

This will create the directory and dependencies to modules for the kernel currently in use (uname -r).

If the problem is not resolved with the above commands. Try to reinstall the kernel via yum with the commands below.

And then try the commands listed earlier.

I hope you find it useful both when it was for me.


Share in your social media
  • 1
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;

Samsung USB Drivers for Mobile Phones

Share in your social media
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;

I advise you read the whole page before download.

This page is actually a kind of backup of the files that I need. To avoid becoming a searching and seeing hundreds of pages full of advertising available here for my own use and thus is available for you also.

The Samsung drivers that allow

Continue Reading >>


Share in your social media
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;

How to retrieve a cell phone Samsung Galaxy using the hardware-download mode

Share in your social media
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;

I play enough with cell phones. Currently I'm investing in equipment to do more than open an iPhone to replace battery or set Touch + Screen.

Had it in my hands not long ago a cell phone Samsung Galaxy Ace model GT-S5830C. I played a lot with him flashing ROMs and I taught my teenage son to do the basics and the phone ended up with him.

One day he came to tell me that there was flashed a wrong in the device ROM

Continue Reading >>


Share in your social media
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;

Using Notepad++ to remove accents

Compartilhe em suas mídias sociais
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Today I share a tip to facilitate the replacement of accented characters using only Notepad++ and your HTML Tag Plugin.

Let’s do it!

First of all, we must have HTML Tag Plugin installed. If you already have it, jump to step 4.

  1. Open Notepad++ and look for Plugins in Main Menu.
    Notepad Plugins Menu Item
  1. If HTML Tag is absent, open Plugin Manager->Show Plugin Manager and find HTML Tag Plugin on the list.
    HTML Tag Plugin on Notepad++ Plugin Manager
  2. Select the desired Plugins and hit Install button. Notepadd++ will restart to complete the install.
    Now we can translate special characters to yours HTML entities. We need to do it first to remove accents from our text.
  3. Put your text on the window and make Select All with Ctrl + A or Edit -> Select All in Main Menu.
  4. Open Plugins->HTML Tag->Encode Entities in Main Menu or CTRL + E.
    Now, all special characters will be in html entities.
    Notepad++ With Special Characters Encoded in HTML
  5. Open the Replace Form (CTRL + H or Search->Replace) and fill the Find What field with
    &([a-zA-Z])(:?grave|acute|circ|uml|aring|cedil|slash|tilde); and Replace with field with $1
    Select Regular Expression in Search Mode and hit Replace All button.
    Notepad++ Replace Form
    The text will be replaced with no accents characters, but all other special chars will be in HTML entity.
    Notepad++ HTML replaced text
  6. Now we can return all other chars to your originals but is better to use your text in UTF-8 encoding. Go to Encoding Menu and change text encoding if is not Utf-8. You can return to another encoding after this step.
    To decode HTML use CTRL + Shift + E or Plugins->HTML Tag->Decode Entities.
    Notepad++ Final Text convertion

I Hope that help someone.

 


Compartilhe em suas mídias sociais
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Relembrando o passado…;

Share in your social media
  • 6
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;

Stirring in my personal files I found this message I wrote shortly after the end of presidential elections of 2014. I don't know why it was not published on my personal blog, but remember posted on Facebook. As I am no longer using Facebook will [Re]publish the text in full.

Principais Candidatos Eleições 2014

Main Election Candidates 2014

 ;

I think it's funny that some people use Facebook to try to convince me of something subjective like she's a lot smarter than the other (and that I, já que isso aqui “;lemos”; alone and not in Group) and do not accept dissent. Some, After 2 or 3 comentários contrários apelam para “;THIS is my FB ACCOUNT, POSTO O QUE EU QUISER”;.
Será que nunca entenderam o que quer dizer “;GLASS HALF FULL OR HALF EMPTY?;
Everything is subjective usually don't have right or wrong choice. If a thing or situation has evidentiary facts, is no longer subjective, is concrete and in this case it's a matter of accepting or not, as a resignation that you didn't realize or your team that is well, losing the flashlight. What is subjective is reached the conclusion through personal experience and State of mind.
Talvez porque eu “;quase”; never try to convince anyone that I'm right and open up the discussion to to argue your point of view, I am outraged when I see intolerant, unbiased, arrogant and inflexible spreading their superior intelligence.
Before attempting to convince someone with arguments drawn from magazine covers, titles of articles or videos from facebook users to which the account is never confirmed, give yourself at least work to read such content under a critical Prism. The people you're going to drive can be those who read 20 books by year, several national and international newspapers in Portuguese or other[s] language[s] and can bring down your arguments in a few seconds if you are not grounded in something concrete.
I'm writing this thinking about the messages about the country's Division disseminated primarily by paulistas. When they see the Rio Grande do Sul fans sing the anthem of the RS on the national anthem at any event think absurd. Preach unity, and repudiate the separatist attitudes, but when a large part of the country doesn't follow its political ideology and the first thing that starts the defender is something that repudiates the other.

Mr post reproduction elected Colonel Tiled (PSDB) that generated controversy

Mr post reproduction elected Colonel Tiled (PSDB) that generated controversy

This selective indignation paulista is disgusting, late and evil.
I advise you that bothered to read this far and got angry with my words to read Vidas Secas, Grande Sertão Veredas and hear stories of Suassuna. Will become a much better person.


Share in your social media
  • 6
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;
  •  ;

How to clear deferred messages from Postfix Queue

Compartilhe em suas mídias sociais
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Today I was watching the log file from Postfix (in CentOS 6.X default is /var/log/maillog) and saw a lot of messages being deferred.

and these messages did repeat from time to time.

Continue Reading >>


Compartilhe em suas mídias sociais
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Naming files using list from 0 to Z

Compartilhe em suas mídias sociais
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Today I was coding some scripts and found a little trouble to use a defined pattern.

The pattern is to create files where the sequence starts in 0 (zero) and cannot be repeated until Z.

Example:

myfile0.ext, myfile1.ext, myfile2.ext, (...), myfile9.ext, myfileA.ext, myfileB.txt, (...), myfileZ.txt

Well, this is not a big trouble so I did use this code.

But $seq did not gave the expected value of 0 (zero) on first run. Instead, it was blank.

Debugging the variables, I saw that the while never evaluates to true. Attempting to reproduce on command line I saw that in_array($seq, $seqs); always return true. I tryed to use “”, “R” and no matter what value I used, still returning true.

So I change to use STRICT argument for in_array to true and works for ‘A’ through ‘Z’, but not for ‘0’ through ‘9’.

Damn… PHP is right, “0” is not strictly equals to 0. The Chr function return string and range('0', '9') creates an array with integer values.

So, I changed the approach to evaluate all values with STRICT, because I would like to create a nice and clean code without no other functions to be used.

This is the final code that I’m using:

How you can see, I changed the $seqs initial values from ‘0’ to your ASCII code and get back to your value that gave me an array with all values in string type.

See you!


Compartilhe em suas mídias sociais
  •  
  •  
  •  
  •  
  •  
  •  
  •  

PHP Comparison Error

Compartilhe em suas mídias sociais
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Today, I was writing a script in PHP to be used in the command line when I came across unexpected behavior (at least on my part).
The script should receive three arguments, the last of them a list containing one or more numeric codes.
Trying to validate this last argument was getting a different result than imagined.
See the code snippet that I was using:

Continue Reading >>


Compartilhe em suas mídias sociais
  •  
  •  
  •  
  •  
  •  
  •  
  •