📄 zipservice.sajax.php
字号:
<?php// -- Constants// START: constantsdefine('DB_HOST', 'localhost');define('DB_USER', 'crmuser');define('DB_PASS', 'crmpasswd');define('DB_NAME', 'crm');// END: constants// -- Functions// START: get_city_statefunction 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); if ($row['city'] && $row['state']) { $return_string = $row['city'] . "," . $row['state']; } else { $return_string = "Could not find a city or state for this zip code"; } mysql_free_result($r); return $return_string;}// END: get_city_state// START: bailfunction 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?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -