error_reporting(E_ALL); header('Content-Type: text/html; charset=utf-8'); $document_root = '/home/home365/public_html'; require_once $document_root . '/dbconnect/dbconnect.php'; require_once $document_root . '/utilities/utilities.php'; require_once 'excel_reader.php'; if (mysql_select_db("home365_ios", $useradmin)) { } else { echo "Error selecting database, exited."; exit; } function null_2_default($string, $default) { return isset($string) && $string != '' ? $string : $default; } $current_timestamp = get_GMT(microtime(true)); $current_time = date("Y-m-d H:i:s", $current_timestamp); $data = new Spreadsheet_Excel_Reader("mls.xls"); $sheet_count = $data->sheetcount(); for ($sheet_index = 0; $sheet_index < $sheet_count; $sheet_index++) { $row_count = $data->rowcount($sheet_index); $col_count = $data->colcount($sheet_index); echo "Sheet:{$sheet_index}<br/>"; echo "Row Count:" . $row_count . "<br/>"; echo "Column Count:" . $col_count . "<br/>"; for ($row_index = 1; $row_index <= $row_count; $row_index++) { for ($col_index = 1; $col_index <= $col_count; $col_index++) { if ($row_index > 1 && $col_index <= 3) { if ($col_index == 1) { $month = $data->val($row_index, $col_index, $sheet_index) === '' ? $month : $data->val($row_index, $col_index, $sheet_index); }
require_once 'dbconnect/dbconnect.php'; require_once 'utilities/utilities.php'; require_once 'RETS.php'; if (mysql_select_db("home365_ios", $useradmin)) { } else { echo "Error selecting database, exited."; exit; } $rets = new RETS(); $rets->url = 'http://brc.retsca.interealty.com/Login.asmx/Login'; $rets->user = '******'; $rets->password = '******'; $rets->useragent = 'RETSAllisonJiang/1.0'; $rets->useragent_password = '******'; $current_GMT_time = get_GMT(time()); $current_GMT_time_string = date("Y-m-d H:i:s", $current_GMT_time); $current_YVR_time = getTimeByCity($current_GMT_time, 'YVR'); $current_YVR_time_string = date("Y-m-d H:i:s", $current_YVR_time); //The following code is to test if the cron job is executed. $file = "file.txt"; $current = file_get_contents($file); $current .= "{$current_YVR_time_string}\n"; file_put_contents($file, $current); //login and receive server response. $response = $rets->Login(); var_dump($response); //$response=$rets->GetCount('Property','11','(363=|A)'); //print $response.'<br/>'; $sysid_array = $rets->GetDataArray('Property', '11', '(363=|A)', 'sysid', null); //echo count($sysid_array).'<br/>';