|
In AD.2013
|
|
As i am free 18 DEC 2013 i use my calendar try adding the SQL printout and was able to print out all date from table easily but difficulty came from comparing the dates some how only few functions was available. |
And i try out all valueof.... finally the easy was to comapre string and it work the event print out was same date what i put in SQL table. Thus completing my sql table.After a few days then i notice it turn out to be my daily diary book in SQL format. |
I made a text box to Type your EVENT
And Click the date to sumbit
|
This box is added with regular expression to minus . ' etc so that my sql will not get 'xxx''xx'xxx and hang my php script
|
|
After some time i found that lot of special characters
like %,^,#,!,@,&,*,(,),_,+ can't add into php sql will
cause error so i decided to look online |
found a script that remove all special characters
!@#$^&%*()+=-[]\/{}|:<>?,. it seems that that guy just
type all symbols in to variabl then |
new RegExp("\\" + specialChars[i], 'gi'); create a new
Regular expression and insert all those characters and
do character replace or string.replace() with that
REGexp but. |
He did it in old fashion way for loop until
string.length and each char[] array it do replace. well
that does help any charcater user input will back fire
to remove. in my text box. |
|
But this guy didn't remove ' ; ` ~ \ " all these so i
think he meet some problem with the script as i know for
special ascii character inorder for javascript or php to
work you need to |
do \', \~ \" \; and i add in to this REG and it
remove all signs on keyboard that does finish my
keyboard js cript for calendar |
As i got some time i again when adding the clock ticking
intos calendar looks nice. |
|
|
In AD.2016
|
|
Suddenly i remember i need to add holiday inside my sql table. |
Hence i search for holiday to add in. |
16NOV 2019 As i was attack by soul hall section and in search for answer i found their timing related to anicent china time. so i created below and add chinese in |
Chinese Time Clock |