1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
|
<?php
// echo '<pre>', print_r($_GET, true), print_r($_POST, true), '</pre>';
// exit;
include('tools/menu.php');
context_title("Modifier un pays");
$language = array("fr","nl","uk","th");
$id_group= ($_GET['id_group']);
//$id = $_POST['id_country'];
//$country = $_POST['name_country'];
$sql = 'SELECT * FROM country WHERE id_group="'.$id_group.'"';
$result = mysql_query($sql);
$count = mysql_num_rows($result);
echo '<form method="post">';
echo "\n";
while($row = mysql_fetch_array($result)){
echo '<input type="text" name="name_country" value="'.$row['name_country'].'">';
echo "\n";
echo '<input type="hidden" name="country" id="hiddenField" value="'.$row['name_country'].'"/>';
echo "\n";
echo '<input type="hidden" name="id" id="hiddenField" value="'.$row['id_country'].'"/>';
echo "\n";
}
echo '<input type="submit" name="Submit" value="Submit">';
echo "\n";
echo '</form>';
echo $sql;
if($_POST['id'] != ""){
foreach($language as $value){
$update = 'UPDATE country SET name_country="'.$country.'" WHERE id_group="'.$_GET['id_group'].'" AND lang="'.$value.'"';
$result_update = mysql_query($update);
}
if(!$result_update){
echo 'error<br>';
}else{
echo '<br>perfect<br>';
}
}
print_r($value)."<br>";
echo "<br>".$update ."<br>";
echo "le pays est: ".$country."<br>";
echo 'le nombre est: ' .$count."<br>";
?> |