include("../inc/layout.inc.php"); include("master.inc"); layout_top("Master", "", "Master"); $err = array(); $html_stream = ''; // SQL $host = 'localhost'; $user = 'k20996u1_user1'; $password = '1a#{hG0qzG2#'; $connect = mysql_connect($host, $user, $password) or die(mysql_error()); $db = mysql_select_db("k20996u1_db2",$connect); $sql = " SELECT * from wEmployeemanagement_Employees where position like '%master%' order by zipcode_business "; $queryResult_query = mysql_query($sql) or die("Anfrage nicht erfolgreich"); $i = 0; while ($result = mysql_fetch_assoc($queryResult_query)) { //if($result['zipcode_business'] < 10000) //{ // $result['zipcode_business'] = '0'.$result['zipcode_business']; // } $temp = $template; $temp = str_replace("%%VORNAME%%", $result['firstname'], $temp); $temp = str_replace("%%NACHNAME%%", $result['surname'], $temp); $temp = str_replace("%%TEL%%", $result['phone_business'], $temp); $temp = str_replace("%%FAX%%", $result['fax_business'], $temp); $temp = str_replace("%%TITEL%%", 'TB Master Partner', $temp); $temp = str_replace("%%MOBIL%%", $result['mobile_business'], $temp); $temp = str_replace("%%EMAIL1%%", $result['email_business'], $temp); $result['email_business'] = str_replace("@", "@ ", $result['email_business']); $temp = str_replace("%%EMAIL2%%", $result['email_business'], $temp); $temp = str_replace("%%PLZ%%", $result['zipcode_business'], $temp); $temp = str_replace("%%ORT%%", $result['city_business'], $temp); $filename = '/var/www/vhosts/tiroler.com/subdomains/portal/wIntranet/mitarbeiterverwaltung/img/'.$result['employee_id'].'.jpg'; $filename2 = 'http://portal.dertiroler.com/wIntranet/mitarbeiterverwaltung/img/'.$result['employee_id'].'.jpg'; //if (file_exists($filename)) { // $img_name = $result['employee_id'].'.jpg'; //} else { // $img_name = 'platzhalter.gif'; //} if (file_get_contents($filename2)) { $img_name = $result['employee_id'].'.jpg'; } else { $img_name = 'platzhalter.gif'; } $img_name = 'http://portal.dertiroler.com/wIntranet/mitarbeiterverwaltung/img/'.$img_name ; $temp = str_replace("%%IMG%%", $img_name, $temp); $link = 'details.php?id='.$result['employee_id']; $temp = str_replace("%%LINK%%", $link, $temp); $i = $i + 1; if($i == 1){ $html_stream = $html_stream.'
Zentrale ÖsterreichTiroler Bauernstandl GmbH |
Zentrale DeutschlandTiroler Bauernstandl GmbH |
||
Wolfgang Obermüller Gründer und Geschäftsführer Geschäftsführung Tel +43 664 2037120 |
Karin Schützler Prokuristin Vorstandsassistenz Büro: Moers Tel +49 2841 881160 |
||
Franchise Master-Partner |
layout_bottom(); mysql_close($connect); ?>