Re: [flexcoders] Flex PHP Service with Date Parameters Help

[claudiu ursica]

I am not sure where your problem is in the php code. However if you think the 
date is the issue use timestamps which are basically numbers. I did that 
successfully in the past. On the flex side you can write an utility for 
translating that into a date for display purposes. 

Which line is 61 in your code anyway ?

C




________________________________
From: Stephen <sd_br...@ntlworld.com>
To: flexcoders@yahoogroups.com
Sent: Fri, August 27, 2010 12:27:57 AM
Subject: [flexcoders] Flex PHP Service with Date Parameters Help

   
I'm having some trouble using the Date as a Parameter does anybody know where 
I'm going wrong as I am currently getting the error: 

Reason: 
Fatal error: Call to a member function toString() on a non-object in 
C:\wamp\www\testing-debug\services\TestingService.php on line 61
mysqli_stmt_bind_param($stmt, 'ss', $from->toString('YYYY-MM-dd'), 
$to->toString('YYYY-MM-dd'));

public function getAllTestingByRange($from, $to) {

$stmt = mysqli_prepare($this->connection, "SELECT name_no, SUM(amount) AS total 
FROM $this->tablename WHERE datefield BETWEEN ? AND ? GROUP BY name_no"); 

$this->throwExceptionOnError();

mysqli_stmt_bind_param($stmt, 'ss', $from->toString('YYYY-MM-dd'), 
$to->toString('YYYY-MM-dd')); 

$this->throwExceptionOnError();

mysqli_stmt_execute($stmt);
$this->throwExceptionOnError();

$rows = array();

mysqli_stmt_bind_result($stmt, $row->name_no, $row->total);

while (mysqli_stmt_fetch($stmt)) {
$rows[] = $row;
$row = new stdClass();
mysqli_stmt_bind_result($stmt, $row->name_no, $row->total);
}

mysqli_stmt_free_result($stmt);
mysqli_close($this->connection);

return $rows;
}