Speak Alles uit de kennisbank van Semanta op een rijte
function text_isrt($invr_text)
{
error_reporting(0);
$func="text-isrt-func";
// echo "
".$func."Vraag:".$invr_text;
include ("config.php");
$invr=explode("@",$invr_text);
$taal=$invr[0];
if ($taal == null)
{
$taal="engels";
}
$text=$invr[1];
$tabl_rchs=$text;
// print_r($invr);
$sql="select * from text where `lnks` = '$text' and `taal` = '$taal' ";
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES utf8");
$tablresult = mysql_query($sql,$link);
$num_tabl= mysql_num_rows($tablresult);
// echo "
hebben we iets gevonden
".$num_tabl." ".$sql;
if ($num_tabl == 0)
{
$sqlland="select * from land where `lnks` = '$text' and `taal` = '$taal' ";
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES utf8");
$tablresult = mysql_query($sqlland,$link);
$num_land= mysql_num_rows($tablresult);
if ($num_land == 0)
{
}
if ($num_land > 0)
{
while ($row = mysql_fetch_assoc($tablresult))
{
$tabl_lnks= $row['lnks'];
$tabl_rchs= $row['rchs'];
$tabl_taal= $row['taal'];
// echo "
Dit is het antwoord:".$tabl_rchs;
}
}
}
if ($num_tabl > 0)
{
// echo "
hebben we iets gevonden
".$gn06_tabl." ".$gn06sql;
while ($row = mysql_fetch_assoc($tablresult))
{
$tabl_lnks= $row['lnks'];
$tabl_rchs= $row['rchs'];
$tabl_taal= $row['taal'];
}
}
// echo "
Dit is het antwoord:".$tabl_rchs;
return $tabl_rchs;
}
?>
function ipad_cntr($ipcd)
{
include ("config.php");
$smta_func="ipad-cntr-func=Bepaal de landnaam van de regio";
// echo "
IPAD CNTR IP Code=".$ipcd;
$sql = "SELECT * from land where `rchs`= '$ipcd' order by levl desc ";
mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES utf8");
$result1 = mysql_query($sql, $link);
$num_lang = mysql_num_rows($result1);
// echo "
IPAD CNTR Aantal landen ".$num_lang;
$cntr_array=array();
$l=0;
$sw=0;
while ($row = mysql_fetch_assoc($result1))
{
$lnks=$row['lnks'];
$rchs=$row['rchs'];
$levl=$row['levl'];
// echo "ipad-cntr-func Nederlandse landnaam".$lnks;
$cntr_array[$l]=$lnks;
$l=$l+1;
}
// echo "
IPAD CNTR
";
// print_r($cntr_array);
return $cntr_array;
}
?>