PHP scripts and programs for Beginner to Master

Hi,

 Select the Site to Navigate

 Google

 PHP Programming Blog

 Chaprak

 Select the Site to Navigate
 Google
 PHP Programming Blog
 Chaprak

How can we know the number of days between two given dates using MySQL ? or find the difference between dates using MySQL ?

Do you ever faced this question in technical interview or technical test?

I know many of you have faced this....... :)

Here is a simple function which can be used to find the number of days between two given dates in MySQL.

Syntax - DATEDIFF(firstdate,seconddate)

so internally it will calculate the difference in MySQL by doing "firstdate minus seconddate", so if firstdate is greater than sencoddate then output will be positive and if firstdate is less than seconddate then output will be negative.

eg. if you use this function as

SELECT DATEDIFF('2009-11-19', '2009-10-15');

in MySQL
then you will get output as 35.

And if you pass parameters as

SELECT DATEDIFF('2009-10-15','2009-11-19')

then you will get output as -35.


If you know any other way to find the difference between dates then comments are always welcome.
Dont forget to tell your friends about http://programming-in-php.blogspot.com

Many times when you go for an interview or technical test you may find this question 

Whenever it is required to get some input url from user then the first things comes is check whether that url is working and valid or it is not working.

Here is a simple function which can be used to verify the liveness of the url.
Just pass the url to this function and it will tell you whether the url is working and valid or invalid.

In the function "check_url" we are going to open the given url with "fopen".
If its opened then return true else return false.

<br /><?php<br />//php function to check whether the url exists or not and validate it<br />function check_url($url)<br />{<br />$check = @fopen($url,"r"); // we are opening url with fopen<br />if($check)<br /> $status = true;<br />else<br /> $status = false;<br /> <br />return $status;<br />}<br />?><br />

Now we are going to use this function.
you can pass the url from the GET or POST method to the function.
Here we are going to specify it directly in the code.
So we are asking our code to open the url http://www.chaprak.com with our function.

<br /><?php<br />//$url = $_GET["url"]; // you can get the parameter from GET<br />$url = "http://www.chaprak.com";<br />if(check_url($url))<br />{<br /> echo "<div><a href=$url>$url</a> is a <b>valid</b> URL</div>";<br />}<br />else<br />{<br /> echo "<div><a href=$url>$url</a> is a <b>invalid</b> URL</div>";<br />}<br />?><br />

so after execution it will show the message as

http://www.chaprak.com is a valid URL.

See its very simple to check the validity of the url in php.

Full source code to try is here -

<br /><br /><?php<br />//a function to check whether the url exists or not and validate it<br />function check_url($url)<br />{<br />$check = @fopen($url,"r"); // we are opening url with fopen<br />if($check)<br /> $status = true;<br />else<br /> $status = false;<br /> <br />return $status;<br />}<br /><br />//$url = $_GET["url"]; // you can get the parameter from GET<br />$url = "http://www.chaprak.com";<br />if(check_url($url))<br />{<br /> echo "<div><a href=$url>$url</a> is a <b>valid</b> URL</div>";<br />}<br />else<br />{<br /> echo "<div><a href=$url>$url</a> is a <b>invalid</b> URL</div>";<br />}<br />?><br /><br />


If you have any ideas and suggestions to improve this function then comments are always welcome.
Dont forget to tell your friends about http://programming-in-php.blogspot.com

Here is a simple function which can be used to count the total number of words present in a string in php.

For this function we are going to use inbuilt functions in php like count, explode, trim.

Function is very simple, it accepts the text.
Then we are checking if there are any extra spaces before and after the string, if it is there then removing that with trim function.

Then we are using count and explode function.

Explode will divide the text into array. (for more information on how explode works visit our post Split string with php explode function and print array)

Then we are counting the total number of array elements by using count function.

<br /><br /><?php<br />//This function can be used to count the number of words present in a string in php<br />function countwords($text)<br />{ <br /> $text = trim($text);<br /> $count = count(explode(" ", $text));<br /> return $count;<br />}<br />?><br /><br />

Now we are actually going to use this function.

<br /><?php<br />$mytext = "Here you can get value from textarea";<br />echo "String Contains ".countwords($mytext)." Words.";<br />?><br />

Here is a full source code to try it out.

<br /><?php<br />//This function can be used to count the number of words present in a string in php<br />function countwords($text)<br />{ <br /> $text = trim($text);<br /> $count = count(explode(" ", $text));<br /> return $count;<br />}<br /><br />$mytext = "Here you can get value from textarea";<br />echo "String Contains ".countwords($mytext)." Words.";<br />?><br />

If you have any ideas and suggestions to improve this function then comments are always welcome.