<?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" /> ' . '|||county_auto|:|' . '<input name="txtcounty" type="text" size="30" maxlength="100" /> ' . '|||city_auto|:|' . '<input name="txtcity" type="text" size="30" maxlength="100" /> '; //. '|||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" /> ' . '|||city_auto|:|' . '<input name="txtcity" type="text" size="30" maxlength="100" /> '; //. '|||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" /> '; //. '|||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 '|||'.
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()); }