[ create a new paste ] login | about

Link: http://codepad.org/m5SAHEn8    [ raw code | output | fork ]

PHP, pasted on Aug 30:
<?php
if(isset($_POST['submit']) && !empty($_POST['submit'])) {
	if (isset($_POST['from_date'],$_POST['to_date']) && !empty($_POST['from_date']) && !empty($_POST['to_date'])) {
		$from_date = $_POST['from_date'];
		$to_date = $_POST['to_date'];

		$stmt = $db->prepare("SELECT jobID, sent_date_time,total_base,delivered,failed,invalid,pending 
			FROM sent_report
			WHERE sent_date between ? AND ?") or die($db->error);

		$stmt->bind_param('ss',$from_date,$to_date);
		$stmt->execute();

		//grab a result set
		$resultSet = $stmt->get_result();

		if($resultSet->num_rows) {				    
		    while($row = $resultSet->fetch_object()) {
		        $sent_records[] = $row;            
		    }	
		    $resultSet->free();
		}


		if (!count($sent_records)) {
			echo "No records";
		} else {
			echo "Total Records(SELECT BY DATE) = ".count($sent_records)."<br>";
			foreach ($sent_records as $sr) {
				echo "JOB ID = ".$sr->jobID."<br>";
				echo "SENT DATE TIME = ".$sr->sent_date_time."<br>";
				echo "TOTAL BASE = ".$sr->total_base."<br>";
				echo "DELIVERED = ".$sr->delivered."<br>";
				echo "FAILED = ".$sr->failed."<br>";
				echo "INVALID = ".$sr->invalid."<br>";
				echo "PENDING = ".$sr->pending."<br>";

				echo "<br>";
				echo "<br>";
				echo "<br>";
			}	
		}		
	}	
} else {
	$stmt = $db->query("SELECT jobID, sent_date_time,total_base,delivered,failed,invalid,pending 
		FROM sent_report") or die($db->error);

	if($stmt->num_rows) {
	    
	    while($row = $stmt->fetch_object()) {
	        $sent_records[] = $row;            
	    }
	    
	    $stmt->free();
	}

	if (!count($sent_records)) {
		echo "No Sent Items Found During All records";
	} else { 
		echo "Total Records = ".count($sent_records)."<br>";
		foreach ($sent_records as $sr) {
			echo "JOB ID = ".$sr->jobID."<br>";
			echo "SENT DATE TIME = ".$sr->sent_date_time."<br>";
			echo "TOTAL BASE = ".$sr->total_base."<br>";
			echo "DELIVERED = ".$sr->delivered."<br>";
			echo "FAILED = ".$sr->failed."<br>";
			echo "INVALID = ".$sr->invalid."<br>";
			echo "PENDING = ".$sr->pending."<br>";

			echo "<br>";
			echo "<br>";
			echo "<br>";
		}	

	}
}


?>


Output:
1
2

Fatal error: Call to a member function query() on a non-object on line 45


Create a new paste based on this one


Comments: