/**
* @return Response
*/
public function getResponse()
{
if (!$this->blLoaded) {
$this->dataProvider->loadResponse($this->id);
$this->blLoaded = true;
}
return $this->connectionData->getResponse();
}
/**
* @return Response
*/
public function getResponse()
{
$this->dataProvider->loadResponse($this->id);
return $this->connectionData->getResponse();
}
function getDataByOwnersName()
{
$conn = new ConnectionData();
$username = $conn->username;
$password = $conn->password;
$host_dbname = $conn->Connection();
try {
$dbh = new PDO("{$host_dbname}", $username, $password);
$sql = "SELECT data_info_temp.id_data,data_info_temp.id_data_info,data_info_temp.cat,data_info_temp.company_name,data_info_temp.email,data_info_temp.address,\ndata_info_temp.city,data_info_temp.state,data_info_temp.zipcode,data_info_temp.phone,\ndata_info_temp.fax,data_info_temp.sic_code,data_info_temp.sic_description,data_info_temp.web_address\nFROM data,data_info_temp WHERE data.id_data = data_info_temp.id_data AND data.id_state = data_info_temp.id_state AND data.id_state='{$this->id_state}' AND data.owner='Jorge'";
/*** fetch into an PDOStatement object ***/
$stmt = $dbh->query($sql);
/*** echo number of columns ***/
//$stmt->fetch(PDO::FETCH_OBJ);
return $stmt;
$dbh = null;
} catch (PDOException $e) {
echo $e->getMessage();
}
}