1 Reply Latest reply: Nov 11, 2012 6:58 PM by cj RSS

    country state drop down list oracle & php

    973661
      Hi all.

      I'm new in this forum.


      I have created two tables :

      create table countries
      (
      country_id int not null,
      country_name varchar2(50),
      constraint countries_country_id_pk primary key (country_id)
      );

      create table states
      (
      state_id int not null,
      state_name varchar2(50),
      country_id int,
      constraint states_state_id_pk primary key (state_id),
      constraint states_country_id_fk foreign key (country_id) references countries (country_id)on delete cascade
      );

      and insert data.


      I have connect to oracle database by this php file.

      <?php
      $conn = oci_connect('hr', 'hekal', 'or');
      if (!$conn)
      {
      $e = oci_error();
      trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
      }
      ?>

      then I make combobox dropdown list like that


      <?php
      include ('../connect_db.php');
      $sql = 'select * from countries order by country_name';
      $stid = oci_parse($conn, $sql);
      oci_define_by_name($stid, 'country_id', $country_id);
      oci_define_by_name($stid, 'country_name',$country_name);
      oci_execute($stid);
      ?>
      <select name="country">
      <?php
      while (oci_fetch($stid)) {
      ?>
      <option value="$country_id" id="country_id"> <?php echo"$country_name" ; ?></option>
      <?php } ?>




      This code get values into drop down list


      and make another to the states.


      But I need to connect the two each other.


      I need when I choose USA. the other list show only states of USA



      thank you