📄 zipservice.xoadobject.php
字号:
<?php// -- Constants// START: constantsdefine('DB_HOST', 'localhost');define('DB_USER', 'crmuser');define('DB_PASS', 'crmpasswd');define('DB_NAME', 'crm');// END: constants// -- Functionsclass ZipService {// START: get_city_state static function get_city_state($zip) { if (!mysql_connect(DB_HOST, DB_USER, DB_PASS)) { bail("Could not connect to MySQL"); } if (!mysql_select_db(DB_NAME)) { bail("Could not use the " . DB_NAME . " database in MySQL"); } $q = sprintf("SELECT city,state FROM zips WHERE zip = '%s'", mysql_real_escape_string($zip)); $r = mysql_query($q); $row = mysql_fetch_assoc($r); // START: return_object if ($row['city'] && $row['state']) { $return_object = new ZipCityState($zip, $row['city'], $row['state']); } else { $return_object = NULL; } // END: return_object mysql_free_result($r); return $return_object; }// END: get_city_state// START: bail static function bail($message) { header('Content-Type: text/html; charset=utf-8'); echo "<html><head><title>Zip Error</title></head><body><h2>$message</h2>" . mysql_error() . "</body></html>"; die(); }// END: bail// START: xoadGetMeta function xoadGetMeta() { XOAD_Client::mapMethods($this, array('get_city_state')); XOAD_Client::publicMethods($this, array('get_city_state')); }// END: xoadGetMeta}// START: ZipCityStateclass ZipCityState { var $zip; var $city; var $state; function ZipCityState($theZip, $theCity, $theState) { $this->zip = $theZip; $this->city = $theCity; $this->state = $theState; }}// END: ZipCityState?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -