function get1fromtable($t,$w){
global $sqli;
$sql="SELECT * FROM $t WHERE $w LIMIT 1";
$result=mysqli_query($sqli,$sql);
if (mysqli_num_rows($result)!=0){
$res= mysqli_fetch_assoc($result);
return($res);
} else {
return false;
}
}
function getfromtable($t,$w){
global $sqli;
$res=array();
$sql="SELECT * FROM $t WHERE $w";
$result=mysqli_query($sqli,$sql);
//echo $sql;
if (mysqli_num_rows($result)!=0){
while ($r= mysqli_fetch_assoc($result)){
$res[]=$r;
}
return($res);
} else {
return false;
}
}
function getfromselect($s){
global $sqli;
$res=array();
$sql=$s;
$result=mysqli_query($sqli,$sql);
//echo $sql;
if (mysqli_num_rows($result)!=0){
while ($r= mysqli_fetch_assoc($result)){
$res[]=$r;
}
return($res);
} else {
return false;
}
}
function getfromtablebyid($t,$w){
global $sqli;
$res=array();
$sql="SELECT * FROM $t WHERE $w";
$result=mysqli_query($sqli,$sql);
if (mysqli_num_rows($result)!=0){
while ($r= mysqli_fetch_assoc($result)){
$res[$r['id']]=$r;
}
return($res);
} else {
return false;
}
}
?>
kino in der reitschule
Cine Migration: Encampment
Dokumentarfilm von Anne-Claire Adet & Yasmine Abd El Aziz
, Schweiz, 2016, OV E/f, 14 Minuten
Bunkers
The short documentary movie is a sensorial immersion in the suffocating life of an underground shelter asylum-seekers are crammed into upon their arrival in Geneva. Anne-Claire Adet uses refugees' own footage and interviews one Sudan journalist who has been housed in a bunker.
In a 2013 report the National Commission on the Prevention of Torture, “considers that these military installations are adapted solely for short-term stays, of a maximum 3 weeks.” Considered from the start as a temporary solution, the settling of migrants in PC shelters has been normalised. In February 2016, 10 bunkers housed over 600 people.