Development Tools & DevOps

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