Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $result1 = $mysqli1->query("SELECT * FROM country where country ='$country' ") or die
- ($mysqli1 -> error);
- $result2 = $mysqli1->query("SELECT * FROM city where country ='$country' AND city
- ='$city' ") or die ($mysqli1 -> error);
- while($row1=$result1 -> fetch_assoc())
- {
- while($row2=$result2 -> fetch_assoc())
- {
- if (mysqli_num_rows($result1) > 0) {
- if (mysqli_num_rows($result2) > 0) {
- echo '<p>Ця країна та місто вже існують! Продовжимо у ';
- echo $row1['country'];
- echo ' ';
- echo $row2['city'];
- echo '</p>';
- }
- else {
- echo '<p>Ця країна вже існує! Ми додали це місто в цю країну!</p>';
- $insert_row1 = $mysqli1->query("INSERT INTO city (country, city) VALUES('$country',
- '$city' )") or die ($mysqli1 -> error);
- }
- }
- else {
- $insert_row = $mysqli1->query("INSERT INTO country (country) VALUES('$country' )")
- or die ($mysqli1 -> error);
- $insert_row1 = $mysqli1->query("INSERT INTO city (country, city) VALUES('$country',
- '$city' )") or die ($mysqli1 -> error);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement