$res
";
$erg=mysql_query($res);
$r=mysql_fetch_row($erg);
return($r[0]);
}
if($_POST[id]){
$id=$_POST[id];
}else{
$id=$_GET[id];
}
$id=strip_tags($id);
$id=htmlentities($id);
$id=mysql_real_escape_string($id);
$meinexid=$id;
$sql = "Select * from mb_posts where id = '$id'";
$resu=send_sql($db,$sql);
$num2 = mysql_num_rows($resu);
//echo "
$num2
";
$zeile = mysql_fetch_array($resu);
$titel=$zeile[3];
$text=$zeile[4];
//echo"$text";
$datum=$zeile[14];
$tag=$zeile[5];
$name="$titel-$id";
$autor=$zeile[1];
$description=$zeile[9];
$autorname=mysql_ein_datenfeld("SELECT company from apbd_customers where id = $autor ");
$autorid=mysql_ein_datenfeld("SELECT id from apbd_listings where customer_id = $autor ");
$autorlink="autor.php=$autorid";
$teile = explode(" ", $datum);
$isodatum = $teile[0];
$teile = explode("-", $teile[0]);
$jahr=$teile[0];
$monat=$teile[1];
$day=$teile[2];
$datum = "$day.$monat.$jahr";
//echo"b$tags
";
$teile = explode(", ", $tag);
$result = count($teile)-1;
foreach($teile AS $name) {
$name=trim($name);
$taglink= urlencode("$name");
$navi=$name;
$tags.= "$name • ";
}
$teiler = explode("", $text);
$name="$titel-$id";
//echo "$name
";
$name = trim($name);
$name = strtolower($name);
$name = strip_tags($name);
$name = stripcslashes($name);
// Umlaute ersetzen
$umlaute = array("/ä/","/ö/","/ü/","/ß/","/Ä/","/Ö/","/Ü/");
$replace = array("ae","oe","ue","ss","Ae","Oe","Ue");
$name = preg_replace($umlaute, $replace, $name);
// sonstige Suchmuster ersetzen
$name = str_replace(" ", "_", $name);
$name = str_replace(",", "", $name);
$name = str_replace(".", "-", $name);
$name = str_replace("'", "", $name);
$name = str_replace("/", "-", $name);
$name = str_replace("?", "", $name);
$name = str_replace("!", "", $name);
$name = str_replace("\\", "", $name);
$name = str_replace(")", "", $name);
$name = str_replace("(", "", $name);
$name = str_replace("|", "", $name);
$name = str_replace("ü", "ue", $name);
$name = str_replace("Ü", "ue", $name);
$name = str_replace("ö", "oe", $name);
$name = str_replace("Ö", "oe", $name);
$name = str_replace("Ä", "ae", $name);
$name = str_replace("ä", "ae", $name);
$name = str_replace("ß", "ss", $name);
$name = str_replace(""", "", $name);
$branchenlink="$name.html";
$branchenbuchlinka="http://www.haundis-portal.de/tipps_".$branchenlink;
$amp="https://www.haundis-portal.de/tricks_".$branchenlink;
$keywords="Kleinunternehmen, Existenzgründer, Kleinunternehmer, Gründer, Firmengründer, Existenzgründung, Unternehmensgründung, Unternehmensgründer, kleine Unternehmen";
$title=$titel;
$cannonical=$branchenbuchlinka;
//$aut="simone";
//$aut="peter";
//
include("oben.php");
?>
echo "$titel
";
?>
Werbung
Geschrieben von
$autorname
am
Tags: $tags
$teiler[0]
";
?>
Werbung
$teiler[1]
";
?>
$autorname";
//echo "$autor";
?>
1 $sql";
$rec=send_sql($db,$sql);
$numc = mysql_num_rows($rec);
if($numc>=1){
echo "Kommentare
";
for ($k = 0; $k < $numc; $k++){
$zeile = mysql_fetch_array($rec);
$name=$zeile[2];
$kommentar=$zeile[3];
$datum=$zeile[4];
$datum = date("d.m.Y",$datum);
echo "$kommentar
geschrieben von $name am $datum
";
}
}
include("unten.php");
$tags=$roww[5];