Date and Time validation using Regular Expression

This function is used for date validation on a string
Return of this function is boolean.
function is_date($str){
   $return = (bool) preg_match("(\b([1-9]([0-9]{3}))\-(1[0-2]|0[1-9])\-(3[01]|[12][0-9]|0[1-9])\b)",$str);
   if(strlen($str)==10){
      return $this->is_date_time($str);
   }
   if($return){
     $return = (bool) (strlen($str)==10);
   }
   return $return;
}

This function is used for time validation on a string
Return of this function is boolean.
function is_time($str){
   $return = (bool) preg_match("(\b(2[0-3]|[01][0-9])\:([0-5][0-9])\:([0-5][0-9])\b)",$str);
   if($return){
      $return = (bool) (strlen($str)==8);
   }
   return $return;
}


And This function is used for date_time validation on a string
Return of this function is boolean.
function is_date_time($str){
   $return = (bool) preg_match("(\b([1-9]([0-9]{3}))\-(1[0-2]|0[1-9])\-(3[01]|[12][0-9]|0[1-9]) (2[0-3]|[01][0-9])\:([0-5][0-9])\:([0-5][0-9])\b)",$str);
   if($return){
      $return = (bool) (strlen($str)==19);
   }
   return $return;
}

Reset Password on Mysql

1. we first used to turn off the server, the server did not mean a whole but only mysql service. hehehe …
of course, is how to turn them off from the root linux via the command:
# /etc/init.d/mysql stop

2. then create a sql script to change the password with the command
# vi /root/mysql.reset.sql
or with other commands you like such as pico or nano .
write or fill in the following script:
mysql.user UPDATE SET Password = PASSWORD ( 'my_password') WHERE User = 'root';
GRANT ALL ON *.* TO 'root';
FLUSH PRIVILEGES;
and then save it.

3. sql script is run with the command:
# mysqld_safe --init-file=/root/mysql.reset.sql &
do not forget the “&” in the script terserbut. ok?
then there will be output:
#nohup: ignoring input and redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe[20970]: started
or:
100116 11:00:28 mysqld_safe Logging to '/var/log/mysql/mysqld.log'.
100116 11:00:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100116 11:00:30 mysqld_safe mysqld from pid file /var/lib/mysql/linux-vb3s.site.pid ended
press enter.

4. restart mysql server
# /etc/init.d/mysql start

URI Validation Using Regular Expression

who know about regular expression?
i need to validate a uri.
so create a validation script using preg_match() on PHP.
but, i get something wrong with my script. can you help me?

this is my uri validation function:
function valid_uri($str){
$patern = "/^((ht|f)tp(s?)\:\/\/|)([a-z0-9]([-.]*[a-z0-9])*(:(0-9)*)*([\/][a-zA-Z0-9\-\.\?\,\/\\\+&%\$#_=]*))?+$/i";
return preg_match($patern,$str);
}

and I have been tested:
$tes=array( "http://www.amikom.ac.id", "amikom.ac.id", "amikom.ac.id.", "ihi amikom.ac.id aha", "https://email.amikom.ac.id","www..com", "http://e-learning.com/", "e-learning.com/index.php", "e-learning.com/index.php?x=1234&a=897", "bukan uri","anang.",".anang.",".com", "http://.com","saya.#@%\$#ini.com");
foreach($tes as $item){
echo "\n".(($this->validasi->valid_uri($item))?"yes":"no")." ".$item;
}

and this is the result:
yes http://www.amikom.ac.id
no amikom.ac.id
no amikom.ac.id.
no ihi amikom.ac.id aha
yes https://email.amikom.ac.id
no www..com
yes http://e-learning.com/
yes e-learning.com/index.php
yes e-learning.com/index.php?x=1234&a=897
no bukan uri
no anang.
no .anang.
no .com
yes http://.com
no saya.#@%$#ini.com

".com" is not valid url, but why "http://.com" is valid?
i just stuck here.
anyone can help me?

GO! DEVELOVER GO!

Let's go!
You can do it!
You can do it!
You can do it!
We can do it!
Go! Go! Go!