Interested to Buy Any Domain ? << Click Here >> for more details...
Suppose there are 3 combo box.
SELECT COUNTRY
SELECT STATE
SELECT CITY
if i select any country from country conutrylistbox
values in the state will get automatically inserted with
database values>>
THEN on selection of state city will be inserted in city
combo box
If you can help then please Help me...
- 2 Answers
- 13115 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / mustkeem
You try this ...script...
<?php
require_once("cities/dao/BaseDao.php");
class CitiesDao extends BaseDao {
public function getCountries() {
$query = "select * from tb_countries order by country asc";
return
$this->execute($this->connection->prepareQuery($query,
Array()));
}
public function getCountryById($idCountry) {
$query = "select * from tb_countries where id_country =
:id_country";
return
$this->getSingleRow($this->connection->prepareQuery($query,
Array("id_country" => $idCountry)));
}
public function getStatesByCountry($idCountry) {
$query = "select * from tb_states where id_country =
:id_country order by state asc";
return
$this->execute($this->connection->prepareQuery($query,
Array("id_country" => $idCountry)));
}
public function getStateById($idState) {
$query = "select * from tb_states where id_state = :id_state";
return
$this->getSingleRow($this->connection->prepareQuery($query,
Array("id_state" => $idState)));
}
public function getCitiesByCountryAndState($idCountry,
$idState) {
$query = "select * from tb_cities where id_country =
:id_country and id_state = :id_state order by city asc";
return
$this->execute($this->connection->prepareQuery($query,
Array("id_country" => $idCountry, "id_state" => $idState)));
}
public function getCityById($idCity) {
$query = "select * from tb_cities where id_city = :id_city";
return
$this->getSingleRow($this->connection->prepareQuery($query,
Array("id_city" => $idCity)));
}
}
?>
| Is This Answer Correct ? | 7 Yes | 9 No |
Post New Answer View All Answers
Whats new with the stop(), suspend() and resume() methods in jdk 1.2?
Where can I ask questions and make suggestions about seam?
To what value is a variable of the string type automatically initialized?
What are the different types of exception?
Explain about thread synchronization inside a monitor?
Brief description about local interfaces?
What is ripple effect?
How many times may an objects finalize() method be invoked by the garbage collector?
What is the difference between static and non-static with examples?
For which statements does it make sense to use a label?
difference between ejb,struts,hibernate,spring and jsp
What is jboss?
how do you Handle Front End Application data against DB with example?
Why a client should be multithreading? Explain.
How can I scroll through list of pages like the search results in google?
