Because I found that record save inside the database have typo problem.
How to solve it? Normally I will use PHP str_replace to solve the issue. But now requires use SQL to print out all the record and replace the typo.
Because I found that record save inside the database have typo problem.
How to solve it? Normally I will use PHP str_replace to solve the issue. But now requires use SQL to print out all the record and replace the typo.
Mysql regexp or rlike function it same as PHP preg_match() function.
It save the time write code and filter the data.
Using Mysql function add asterisk (*) in front of the string.
Example Output:
********MyTestString
*******MyTestString2
**********TestString
Find the string position. I think most of the Software Engineer will use server side script to do it. I also is the one. For PHP, I will use strpos to get the position.
Generally, we stores various values of choices in 1 column of database. For example, we store user’s preferred categories in user table’s. value stored in this field will be like this 1,2,12,22,4
Except from apache you can let your .htaccess file tighten up your site’s security and give extra level of protection.
I am going listing out few example and show you how to use it or where to use it. You don’t have to use every single one, just whatever you feel would help you improve your site security.
I am going listing out few example and show you how to use it or where to use it. You don’t have to use every single one, just whatever you feel would help you improve your site security.
Following last post Javascript Date Range Picker it was using pure javascript without using any framework.
Now we built another with JQuery.
I think a lot of people looking how to use javascript built the date picker with start date and end date. Normally how we did is just create 2 field with START DATE and END DATE. but the END DATE still can choose early then START DATE.
And we only can using javascript code to solve it.