Tour de Lorraine 2016
See more
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; } } ?>