MODPATH/database/classes/Kohana/Database/MySQL.php [ 194 ]
189 {
190 // This benchmark is worthless
191 Profiler::delete($benchmark);
192 }
193
194 throw new Database_Exception(':error [ :query ]',
195 array(':error' => mysql_error($this->_connection), ':query' => $sql),
196 mysql_errno($this->_connection));
197 }
198
199 if (isset($benchmark))
-
MODPATH/database/classes/Kohana/Database/Query.php [ 251 ] » Kohana_Database_MySQL->query(arguments)
0
integer 1
1
string(548) "SELECT `cat_states`.state_short as short_state, `cat_states`.url_name as state_url, `cat_cities`.city_name as city, `cat_citi …"
2
bool FALSE
3
array(0)
246 return new Database_Result_Cached($result, $sql, $as_object, $object_params); 247 } 248 } 249 250 // Execute the query 251 $result = $db->query($this->_type, $sql, $as_object, $object_params); 252 253 if (isset($cache_key) AND $this->_lifetime > 0) 254 { 255 // Cache the result array 256 Kohana::cache($cache_key, $result->as_array(), $this->_lifetime);
-
APPPATH/classes/Model/Workdb.php [ 15 ] » Kohana_Database_Query->execute()
10 AND `cat_cities`.county_id = {$county_id} 11 AND `cat_cities`.state_id = `cat_states`.state_id 12 AND `ZipCode`.state = `cat_states`.state_short 13 AND `ZipCode`.city = `cat_cities`.city_name ORDER BY `cat_cities`.city_name;"; 14 $query = DB::query(Database::SELECT, $response) 15 ->execute() 16 ->as_array(); 17 if($query) 18 return $query; 19 else 20 return array();
-
APPPATH/classes/Controller/Welcome.php [ 555 ] » Model_Workdb->get_city_with_zip(arguments)
0
string(2) "10"
1
string(3) "265"
550 } 551 public function locations_tag() 552 { 553 if($this->typelocation == 'county') 554 { 555 $to_map = Model::factory('Workdb')->get_city_with_zip($this->location['state']['state_id'], $this->location['city']['county_id']); 556 return $this->replace['[locations-with-zip]'] = View::factory('widgets/location_with_zip')->bind('locations', $to_map)->__toString(); 557 } 558 } 559 560 public function get_customer()
-
APPPATH/classes/Controller/Welcome.php [ 485 ] » Controller_Welcome->locations_tag()
480 '[tel]' => (isset($this->customer['phone']))?$this->customer['phone']:'', 481 '[tel2]' => (!empty($this->customer['phone2']))?$this->customer['phone2']:'', 482 '[tel2_html]' => (!empty($this->customer['phone2']))?'<span class="number"><span class="free"><span>Local number:</span></span><a href="tel:' . $this->customer['phone2'] . '" class="phone1val">' . $this->customer['phone2'] . '</a></span>':'', 483 '[email]' => (isset($this->customer['email']))?$this->customer['email']:'', 484 '[adress]' => (isset($this->customer['address']))?$this->customer['address']:'', 485 '[locations-with-zip]' => $this->locations_tag(), 486 '[near-me-by]' => '', 487 '[under-main]' => '', 488 '[more-locations]'=> '', 489 '[url_lco]' => (isset($this->location['city']['county_name']))?strtolower(str_replace(' ', '_', $this->location['city']['county_name'] . " county")):'', 490 '[url_lci]' => (isset($this->location['city']['city_name']))?strtolower(str_replace(' ', '_', $this->location['city']['city_name'])):'',
-
APPPATH/classes/Controller/Welcome.php [ 653 ] » Controller_Welcome->replace_tag()
648 649 public function after() 650 { 651 parent::after(); 652 $this->get_customer(); 653 $this->replace_tag(); 654 // Передаем данные в шаблон 655 $this->template = View::factory($this->template); 656 $this->template->title = $this->title; 657 $this->template->keywords = $this->keywords; 658 $this->template->description = $this->description;
-
SYSPATH/classes/Kohana/Controller.php [ 87 ] » Controller_Welcome->after()
82 83 // Execute the action itself 84 $this->{$action}(); 85 86 // Execute the "after action" method 87 $this->after(); 88 89 // Return the response 90 return $this->response; 91 } 92
-
{PHP internal call} » Kohana_Controller->execute()
-
SYSPATH/classes/Kohana/Request/Client/Internal.php [ 97 ] » ReflectionMethod->invoke(arguments)
0
object Controller_Welcome(14)
{ public template => string(4) "main" public location => array(4) ( "permission" => NULL "state" => array(6) ( "state_id" => string(2) "10" "state_name" => string(7) "Florida" "url_name" => string(2) "fl" "state_short" => string(2) "FL" "published" => string(1) "1" "area_name" => string(6) "states" ) "city" => array(7) ( "county_id" => string(3) "265" "state_id" => string(2) "10" "county_name" => string(8) "Pinellas" "url_name" => string(8) "pinellas" "published" => string(1) "1" "area_name" => string(8) "counties" "customer_id" => string(1) "0" ) "type" => string(6) "county" ) protected typelocation => string(6) "county" public auto_render => bool FALSE private title => string(56) "Locksmith Near Me [lco], [sst] - Find a Local Locksmith " private keywords => string(137) "locksmith near me [klco] [ssst],locksmith near me [klco] [klst],local locksmith [klco], local locksmith [klco] [ssst],locksmith …" private description => string(84) "Locksmith Near Me [lco], [sst] - Local 24 hr Locksmith close to you in [lco], [lst]." private nav => string(2853) "<!-- [lco] [sst] --> <header> <div class="l1"> </div> <div class="l2"> <div id="homebanner"> …" private content => string(8220) "<div class="l4"> <div class="colum2 colum0"> </div> <div class="colum1"> < …" private footer => string(7492) " <footer id="footer"> [locations] [more-locations] <div class="l7"> <ul> …" private replace => array(7) ( "[categories]" => string(0) "" "[cat_cat]" => string(0) "" "[side-menu]" => string(1135) " <div class="items" style="background-color: #00adee; margin:5px; padding:10px;"><img src="/public/ic …" "[near-me-by]" => string(4) "City" "[under-main]" => string(27) "Provides Locksmith Services" "[locations]" => string(3762) " <div class="l6"> <div class="loclist"> <span class="lochead">Locksmith Near Me by [near-me-by]:</span> …" "[more-locations]" => string(1493) " <div class="row" class="select_some_loc"> <div class="col-lg-12 col-xs-12" onclick="toggle_sp('spoiler', 'arrow1')" class= …" ) private customer => array(8) ( "id" => string(1) "0" "company" => string(24) "COMPANY_NAME_IN_DATABASE" "logo" => string(8) "logo.svg" "address" => string(11) "St. Hard 12" "phone" => string(12) "786-358-5711" "phone2" => string(0) "" "email" => string(30) "locksmithfllocksmith@gmail.com" "sell_leads" => string(1) "0" ) public request => object Request(19)
{ protected _requested_with => NULL protected _method => string(3) "GET" protected _protocol => string(8) "HTTP/1.0" protected _secure => bool TRUE protected _referrer => NULL protected _route => object Route(5)
public response => object Response(5){ protected _filters => array(0) protected _uri => string(21) "<state>/<page>_<city>" protected _regex => array(2) ( "state" => string(152) "al|ak|az|ar|ca|co|ct|de|fl|ga|hi|id|il|in|ia|ks|ky|la|me|md|ma|mi|mn|ms|mo|mt|ne|nv|nh|nj|nm|ny|nc|nd|oh|ok|or|pa|ri|sc|sd|tn|tx …" "page" => string(307) "lockout-locksmith|car-locksmith|change-locks|24-hour-locksmith|services|lockout-locksmith|car-locksmith|change-locks|24-hour-loc …" ) protected _defaults => array(2) ( "controller" => string(7) "welcome" "action" => string(8) "generate" ) protected _route_regex => string(510) "#^(?P<state>al|ak|az|ar|ca|co|ct|de|fl|ga|hi|id|il|in|ia|ks|ky|la|me|md|ma|mi|mn|ms|mo|mt|ne|nv|nh|nj|nm|ny|nc|nd|oh|ok|or|pa|ri …" }
protected _routes => array(0) protected _header => object HTTP_Header(0){ }
protected _body => NULL protected _directory => string(0) "" protected _controller => string(7) "Welcome" protected _action => string(8) "generate" protected _uri => string(36) "fl/locksmith-near-me_pinellas_county" protected _external => bool FALSE protected _params => array(3) ( "state" => string(2) "fl" "page" => string(17) "locksmith-near-me" "city" => string(15) "pinellas_county" ) protected _get => array(0) protected _post => array(0) protected _cookies => array(0) protected _client => object Request_Client_Internal(9){ protected _previous_environment => NULL protected _cache => NULL protected _follow => bool FALSE protected _follow_headers => array(1) ( 0 => string(13) "Authorization" ) protected _strict_redirect => bool TRUE protected _header_callbacks => array(1) ( "Location" => string(34) "Request_Client::on_header_location" ) protected _max_callback_depth => integer 5 protected _callback_depth => integer 1 protected _callback_params => array(0) }
}{ protected _status => integer 200 protected _header => object HTTP_Header(0)
}{ }
protected _body => string(0) "" protected _cookies => array(0) protected _protocol => string(8) "HTTP/1.0" }92 93 // Create a new instance of the controller 94 $controller = $class->newInstance($request, $response); 95 96 // Run the controller's execute() method 97 $response = $class->getMethod('execute')->invoke($controller); 98 99 if ( ! $response instanceof Response) 100 { 101 // Controller failed to return a Response. 102 throw new Kohana_Exception('Controller failed to return a Response');
-
SYSPATH/classes/Kohana/Request/Client.php [ 114 ] » Kohana_Request_Client_Internal->execute_request(arguments)
0
object Request(19)
{ protected _requested_with => NULL protected _method => string(3) "GET" protected _protocol => string(8) "HTTP/1.0" protected _secure => bool TRUE protected _referrer => NULL protected _route => object Route(5)
{ protected _filters => array(0) protected _uri => string(21) "<state>/<page>_<city>" protected _regex => array(2) ( "state" => string(152) "al|ak|az|ar|ca|co|ct|de|fl|ga|hi|id|il|in|ia|ks|ky|la|me|md|ma|mi|mn|ms|mo|mt|ne|nv|nh|nj|nm|ny|nc|nd|oh|ok|or|pa|ri|sc|sd|tn|tx …" "page" => string(307) "lockout-locksmith|car-locksmith|change-locks|24-hour-locksmith|services|lockout-locksmith|car-locksmith|change-locks|24-hour-loc …" ) protected _defaults => array(2) ( "controller" => string(7) "welcome" "action" => string(8) "generate" ) protected _route_regex => string(510) "#^(?P<state>al|ak|az|ar|ca|co|ct|de|fl|ga|hi|id|il|in|ia|ks|ky|la|me|md|ma|mi|mn|ms|mo|mt|ne|nv|nh|nj|nm|ny|nc|nd|oh|ok|or|pa|ri …" }
protected _routes => array(0) protected _header => object HTTP_Header(0){ }
protected _body => NULL protected _directory => string(0) "" protected _controller => string(7) "Welcome" protected _action => string(8) "generate" protected _uri => string(36) "fl/locksmith-near-me_pinellas_county" protected _external => bool FALSE protected _params => array(3) ( "state" => string(2) "fl" "page" => string(17) "locksmith-near-me" "city" => string(15) "pinellas_county" ) protected _get => array(0) protected _post => array(0) protected _cookies => array(0) protected _client => object Request_Client_Internal(9){ protected _previous_environment => NULL protected _cache => NULL protected _follow => bool FALSE protected _follow_headers => array(1) ( 0 => string(13) "Authorization" ) protected _strict_redirect => bool TRUE protected _header_callbacks => array(1) ( "Location" => string(34) "Request_Client::on_header_location" ) protected _max_callback_depth => integer 5 protected _callback_depth => integer 1 protected _callback_params => array(0) }
}1
object Response(5)
{ protected _status => integer 200 protected _header => object HTTP_Header(0)
{ }
protected _body => string(0) "" protected _cookies => array(0) protected _protocol => string(8) "HTTP/1.0" }109 $orig_response = $response = Response::factory(array('_protocol' => $request->protocol())); 110 111 if (($cache = $this->cache()) instanceof HTTP_Cache) 112 return $cache->execute($this, $request, $response); 113 114 $response = $this->execute_request($request, $response); 115 116 // Execute response callbacks 117 foreach ($this->header_callbacks() as $header => $callback) 118 { 119 if ($response->headers($header))
-
SYSPATH/classes/Kohana/Request.php [ 986 ] » Kohana_Request_Client->execute(arguments)
0
object Request(19)
{ protected _requested_with => NULL protected _method => string(3) "GET" protected _protocol => string(8) "HTTP/1.0" protected _secure => bool TRUE protected _referrer => NULL protected _route => object Route(5)
{ protected _filters => array(0) protected _uri => string(21) "<state>/<page>_<city>" protected _regex => array(2) ( "state" => string(152) "al|ak|az|ar|ca|co|ct|de|fl|ga|hi|id|il|in|ia|ks|ky|la|me|md|ma|mi|mn|ms|mo|mt|ne|nv|nh|nj|nm|ny|nc|nd|oh|ok|or|pa|ri|sc|sd|tn|tx …" "page" => string(307) "lockout-locksmith|car-locksmith|change-locks|24-hour-locksmith|services|lockout-locksmith|car-locksmith|change-locks|24-hour-loc …" ) protected _defaults => array(2) ( "controller" => string(7) "welcome" "action" => string(8) "generate" ) protected _route_regex => string(510) "#^(?P<state>al|ak|az|ar|ca|co|ct|de|fl|ga|hi|id|il|in|ia|ks|ky|la|me|md|ma|mi|mn|ms|mo|mt|ne|nv|nh|nj|nm|ny|nc|nd|oh|ok|or|pa|ri …" }
protected _routes => array(0) protected _header => object HTTP_Header(0){ }
protected _body => NULL protected _directory => string(0) "" protected _controller => string(7) "Welcome" protected _action => string(8) "generate" protected _uri => string(36) "fl/locksmith-near-me_pinellas_county" protected _external => bool FALSE protected _params => array(3) ( "state" => string(2) "fl" "page" => string(17) "locksmith-near-me" "city" => string(15) "pinellas_county" ) protected _get => array(0) protected _post => array(0) protected _cookies => array(0) protected _client => object Request_Client_Internal(9){ protected _previous_environment => NULL protected _cache => NULL protected _follow => bool FALSE protected _follow_headers => array(1) ( 0 => string(13) "Authorization" ) protected _strict_redirect => bool TRUE protected _header_callbacks => array(1) ( "Location" => string(34) "Request_Client::on_header_location" ) protected _max_callback_depth => integer 5 protected _callback_depth => integer 1 protected _callback_params => array(0) }
}981 throw new Request_Exception('Unable to execute :uri without a Kohana_Request_Client', array( 982 ':uri' => $this->_uri, 983 )); 984 } 985 986 return $this->_client->execute($this); 987 } 988 989 /** 990 * Returns whether this request is the initial request Kohana received. 991 * Can be used to test for sub requests.
-
DOCROOT/index.php [ 344 ] » Kohana_Request->execute()
339 * If no source is specified, the URI will be automatically detected. 340 */ 341 342 // $request = Request::factory(TRUE, array('status'=>200), FALSE) 343 $request = Request::factory() 344 ->execute(); 345 echo $request->body(); 346 }