PHP

Simple PHP Program that checks data between two dates using jquery and returns result

Below is the PHP script for returning the result using from and two dates with jquery, using mysql as db.

It pulls all the data present in between teh mentioned from and to dates.

The jquery UI user datepicker it has functionalities like default date and onload show current date. 


	
		
		
		

		
	
		
	
					
		   			

			
			
			
			
			
			
			 
			
			


	 $from = $_POST["from"];
	 $to = $_POST["to"];
	 $timestampfrom = strtotime($from);
	 $timestampto = strtotime($to);

	$con = mysql_connect("localhost","root","");
		if (!$con){
		die('Could not connect: ' . mysql_error());
		}

	$dbconn = mysql_select_db("thisdb", $con);
		if (!$dbconn)
		{
		die('Could not connect: ' . mysql_error());
		}

	$result = mysql_query("select * from tutorialsbag");
//echo $result;
	if(isset($from))
	{
		echo "






";
while($row = mysql_fetch_array($result))
{
$id = $row['Id'] ;
$Course = $row['Course'] ;
$Contact = strtotime($row['Contact']);


if($sd >= $timestampfrom && $ed <= $timestampto){

echo "";
echo "";
echo "";
echo "";

//echo "";
echo "";

}
}
echo "
Id Course Contact
" . $id. "" . $Contact. "" . $Course. " " . date("M d Y h:i:s ",$sd). "
";
}
mysql_close($con);
?>


Related Articles
Mysql PHP Sample PHP Mysql search program Sample Programs

Search and Retrieve Data from MySQL DB Using PHP

viveik

Below is the Simple PHP and MYSQL Search Program. Use below database queries: CREATE TABLE IF NOT EXISTS user (id int(10) NOT NULL AUTO_INCREMENT,Name varchar(20) NOT NULL,PRIMARY KEY (id)); INSERT INTO user (id, Name) VALUES (‘1’, ‘vicky’), (‘2’, ‘vivek’); Below is the sample program:

techfolks php tutorials logo
email filters in php PHP Tips&Tricks

How to Validate Emails Using Filters in PHP

viveik

Using PHP Filters we can fully validate an email id and this filter option requires PHP 5 version. Below is the code for validating emails in PHP using filters, along with using explode and foreach loop and then inserting the correct emails in the mysql database. Multiple emails validation. Validate Emails Using Filters in PHP
PHP

How to ini_set in PHP

viveik

You can initilize local settings in a php file.You can set values like max_execution_time, default_socket_timeout, memory_limit, mysql.connect_timeout, user_ini.cache_ttl, display_errors and log_errorsit always nice to check the errors in PHP files with error_reporting. Below is the sample script to set ini_set values. If you dont want to set every time in PHP script simply set the […]