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...
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
Are enterprise beans allowed to use thread.sleep()?
How would you create a button with rounded edges?
What is the difference between the string and stringbuffer classes?
Which are the different segments of memory?
difference between ejb,struts,hibernate,spring and jsp
how to use debug in my elipse to solve problems that exist in my project
Explain the advantages and disadvantages of detached objects.
What are the different methods of identifying an object?
How are the elements of a cardlayout organized?
What are the different class loaders used by jvm?
What do you need to set-up a cluster with jboss?
what are the advantages of JTA over JTS?
What is an abstract method?
What is the difference between a menuitem and a checkboxmenuitem?
What is difference between object state and behavior?