예제 #1
0
<?php

require_once "../initialise_file_location.php";
if (!isset($_GET['a']) || empty($_GET['a']) || !isset($_GET['v']) || empty($_GET['v'])) {
    echo '|||stateprovince_auto|:|' . '<input name="txtstateprovince" type="text" size="30" maxlength="100" />&nbsp;&nbsp;' . '|||county_auto|:|' . '<input name="txtcounty" type="text" size="30" maxlength="100" />&nbsp;&nbsp;' . '|||city_auto|:|' . '<input name="txtcity" type="text" size="30" maxlength="100" />&nbsp;&nbsp;';
    //. '|||txtzip|:|' . '<input name="txtzip" type="text" size="30" maxlength="100" />';
    $db->close_connection();
    exit;
}
switch (trim($_GET['a'])) {
    case 'country':
        echo '|||stateprovince_auto|:|' . stateOptions() . '|||county_auto|:|' . '<input name="txtcounty" type="text" size="30" maxlength="100" />&nbsp;&nbsp;' . '|||city_auto|:|' . '<input name="txtcity" type="text" size="30" maxlength="100" />&nbsp;&nbsp;';
        //. '|||txtzip|:|' . '<input name="txtzip" type="text" size="30" maxlength="100" />';
        break;
    case 'state':
        echo '|||' . 'county_auto|:|' . countyOptions() . '|||city_auto|:|' . '<input name="txtcity" type="text" size="30" maxlength="100" />&nbsp;&nbsp;';
        //. '|||txtzip|:|' . '<input name="txtzip" type="text" size="30" maxlength="100" />';
        break;
    case 'county':
        echo '|||' . 'city_auto|:|' . cityOptions();
        //. '|||txtzip|:|' . '<input name="txtzip" type="text" size="30" maxlength="100" />';
        break;
        /*
        	case 'city':
        		echo '|||'.
        			 'txtzip|:|' . zipOptions();
        		break;
        */
    /*
    	case 'city':
    		echo '|||'.
예제 #2
0
 protected function show($id)
 {
     $this->params['note'] = NoteQuery::create()->filterByUser($this->params['user'])->leftJoinWith('Note.Category')->leftJoinWith('Note.Comment')->leftJoinWith('Comment.User')->addAscendingOrderByColumn("comment.created_at")->findPK($id);
     $this->params['states'] = stateOptions($this->params['note']->getState());
 }