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
- 12344 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
What is a class loader? What are the different class loaders used by jvm?
Where can I find seam examples and documentation?
Is the session factory thread safe?
What is the difference between java class and bean?
What is the relation between the infobus and rmi?
How messaging services are done, before release of JMS?
Name the class that is used to bind the server object with RMI Registry?
What is a sessionfactory? Is it a thread-safe object?
Explain phantom read?
What is the difference between the string and stringbuffer classes?
what is a portable component?
What’s jboss jbpm?
How would you detect a keypress in a jcombobox?
What is a class loader?
What is metaspace?
