function query($query)
{
$this->connect();
$result = MYSQLI_QUERY($this->conn, $query);
//or die("Query For Table Failed");
$this->disconnect();
return $result;
}
function ejecutarQuery($query)
{
abrirConexion();
return MYSQLI_QUERY($GLOBALS['Conexion'], $query);
}
echo $formtran26[$lang];
?>
">
<?php
} else {
$info_ueberbelegung = $_POST["info_ueberbelegung"];
if ($info_ueberbelegung == "") {
$info_ueberbelegung = 0;
}
//Teilnehmer hochz�hlen
if ($_SESSION['zaehler'] == "1") {
$teilnehmer = $datenterm['teilnehmer'] + 1;
#echo $teilnehmer;
$eintrag = "Update termine set teilnehmer = '{$teilnehmer}' where terminid ='" . $kurs . "'";
#echo $eintrag;
MYSQLI_QUERY($link, $eintrag);
$_SESSION['zaehler'] = 0;
}
$sql = "Insert into anmeldungen \n(kursid, kursname, sprache, datum_von, anrede, vorname, nachname, adresse, email, telefon, beruf, diplom, ueberweisung_selber, arbeitgeber, ansprechspartner, strasse, plz_ort, agb_akzeptiert, info_ueberbelegung, nachricht) \nvalues \n('{$kurs}', '{$kursname}', '{$lang}', '{$datum_von}', '{$anrede}', '{$vorname}', '{$nachname}', '{$adresse}', '{$email}','{$telefon}', '{$beruf}','{$diplom}', '{$ueberweisung_selber}', '{$arbeitgeber}', '{$ansprechspartner}','{$strasse}','{$plz_ort}','{$agb_akzeptiert}','{$info_ueberbelegung}','{$nachricht}')";
#echo $sql;
mysql_query($sql);
?>
<head>
<?php
include 'inc/favicon.inc.php';
?>
<title><?php
echo $daten['titel_' . $lang];
?>
</title>
<?php
$id = 1;
include 'sqli.inc.php';
$lang = $_GET["lang"];
if ($lang == "") {
$lang = "de";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<?php
mysqli_query($link, "SET names 'utf8'");
$abfrage = MYSQLI_QUERY($link, sprintf("Select * From `tl_translations` where tl_translationid = %s", quote_smart($id)));
$daten = mysqli_fetch_array($abfrage);
$abfrage2 = MYSQLI_QUERY($link, "Select seite,boxtext_" . $lang . " From `content` where contentid < 14 ");
?>
<head>
<?php
include 'inc/favicon.inc.php';
?>
<title><?php
echo $daten['titel_' . $lang];
?>
</title>
<link type="text/css" rel="stylesheet" href="http://fast.fonts.com/cssapi/af471b08-9f95-4c83-b5fd-e3a74c678ffe.css"/>
<link href="style.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" type="text/css" href="scripts/superfish/css/superfish.css" media="screen">
<script type="text/javascript" src="scripts/lightbox/js/jquery-1.7.2.min.js"></script>
<script type="text/javascript" src="scripts/superfish/js/hoverIntent.js"></script>
</div>
<?php
echo getTranslationValue($courseType['description'], $lang);
?>
<div class="course-registration-teaser">
<?php
while ($course = mysqli_fetch_array($courses)) {
?>
<?php
$q = MYSQLI_QUERY($link, "Select * From `location` where id=" . $course['locationID']);
$location = $q ? mysqli_fetch_array($q) : null;
$date = $course['datum_von'] != $course['datum_bis'] ? date_mysql2german($course['datum_von'], "%02d.%02d.") . ' - ' . date_mysql2german($course['datum_bis']) : date_mysql2german($course['datum_von']);
$q = MYSQLI_QUERY($link, "Select * From `teamer` where id=" . $course['teacherID']);
$teacher = $q ? mysqli_fetch_array($q) : null;
?>
<div class="course-teaser-block">
<b><?php
echo $date;
echo $location ? ' ' . getTranslationValue($location['name'], $lang) : '';
echo $teacher ? ', PT ' . $teacher['firstname'] . ' ' . $teacher['lastname'] : '';
?>
</b><br/>
<a class="blau" href="anmeldung.php?lang=<?php
echo $lang;
?>
&kurs=<?php
echo $course['terminid'];
?>
<?php
// this block requires $course and $selectedCourseType
// can be cinfigured with anmeldung
$q = MYSQLI_QUERY($link, "Select * From `location` where id=" . $course['locationID']);
$location = $q ? mysqli_fetch_array($q) : null;
$q = MYSQLI_QUERY($link, "Select * From `teamer` where id=" . $course['teacherID']);
$teacher = $q ? mysqli_fetch_array($q) : null;
$tage = mysqli_fetch_array(MYSQLI_QUERY($link, "Select * From `translations` where translationid=2"));
$referent_trans = mysqli_fetch_array(MYSQLI_QUERY($link, "Select * From `translations` where translationid=11"));
$teacher_trans = mysqli_fetch_array(MYSQLI_QUERY($link, "Select * From `translations` where translationid=3"));
?>
<div class="course" data-id="<?php
echo $course['terminid'];
?>
">
<div class="mb-s"><strong><?php
echo nl2br(getTranslationValue($selectedCourseType['title'], $lang));
?>
- <?php
echo array_key_exists('duration', $course) ? $course['duration'] : $selectedCourseType['duration'];
?>
<?php
echo getTranslationValue($tage, $lang);
?>
, <?php
echo AppBundle\Util\Money::parse($course['preis'])->toHtml();
?>
</strong></div>
<?php
$id = 106;
$id2 = 126;
include 'sqli.inc.php';
$lang = $_GET["lang"];
if ($lang == "") {
$lang = "de";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<?php
mysqli_query($link, "SET names 'utf8'");
$abfrage2 = MYSQLI_QUERY($link, "Select seite,boxtext_" . $lang . " From `content` where contentid < 14 order by aufbaukurs, contentid asc");
$abfrage = MYSQLI_QUERY($link, sprintf("Select * From `content` where contentid = %s", quote_smart($id)));
$abfrage3 = MYSQLI_QUERY($link, sprintf("Select * From `content` where contentid = %s", quote_smart($id2)));
$daten3 = mysqli_fetch_array($abfrage3);
$daten = mysqli_fetch_array($abfrage);
?>
<head>
<?php
include 'inc/favicon.inc.php';
?>
<meta name="google-site-verification" content="nKPCKeQ9ip9Tb9XGa9qDMiGJR90LCjeCmjL9lHfLhNI" />
<title>Florinda Czeija - CranioSacrale Therapie / Viszerale Osteopathie</title>
<link type="text/css" rel="stylesheet" href="http://fast.fonts.com/cssapi/af471b08-9f95-4c83-b5fd-e3a74c678ffe.css"/>
<link href="style.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" type="text/css" href="scripts/superfish/css/superfish.css" media="screen">
<link href="scripts/lightbox/css/lightbox.css" rel="stylesheet" />
function getOnlineCoursesByCategory($course_category)
{
global $link;
return MYSQLI_QUERY($link, "Select * From `course_type` where `category` = '" . $course_category . "' AND (`archived` IS FALSE OR `archived` IS NULL) order by sort asc");
}
<meta http-equiv="content-type" content="application/xhtml+xml; charset=utf-8" />
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ru" lang="ru"/>
<?php
mysqli_query($link, "SET names 'utf8'");
$abfrage = MYSQLI_QUERY($link, sprintf("Select * From `content` where contentid = %s", quote_smart($id)));
$daten = mysqli_fetch_array($abfrage);
$abfrage2 = MYSQLI_QUERY($link, "Select seite,boxtext_" . $lang . " From `content` where contentid < 14 order by aufbaukurs, contentid asc");
$abfrage3 = MYSQLI_QUERY($link, "Select * From `content` where contentid = 107");
$daten3 = mysqli_fetch_array($abfrage3);
$abfrage4 = MYSQLI_QUERY($link, "Select * From `content` where contentid = 108");
$daten4 = mysqli_fetch_array($abfrage4);
$abfrage5 = MYSQLI_QUERY($link, "Select * From `content` where contentid = 115");
$daten5 = mysqli_fetch_array($abfrage5);
$abfrage7 = MYSQLI_QUERY($link, "Select * From `content` where contentid = 122");
$daten7 = mysqli_fetch_array($abfrage7);
$abfrage6 = MYSQLI_QUERY($link, "Select {$lang} From `translations` where translationid = 8");
$daten6 = mysqli_fetch_array($abfrage6);
?>
<meta name="google-site-verification" content="nKPCKeQ9ip9Tb9XGa9qDMiGJR90LCjeCmjL9lHfLhNI" />
<title>Florinda Czeija - Viszerale Therapie</title>
<link href="style.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" type="text/css" href="scripts/superfish/css/superfish.css" media="screen">
<script type="text/javascript" src="bower_components/jquery/dist/jquery.min.js"></script>
<script type="text/javascript" src="bower_components/superfish/dist/js/hoverIntent.js"></script>
<script type="text/javascript" src="bower_components/superfish/dist/js/superfish.min.js"></script>
<script type="text/javascript">
// initialise plugins
jQuery(function(){
jQuery('ul.sf-menu').superfish();
});
$formtrans10 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =10"); $formtrans11 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =11"); $formtrans13 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =13"); $formtrans14 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =14"); $formtrans15 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =15"); $formtrans16 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =16"); $formtrans17 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =17"); $formtrans18 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =18"); $formtrans19 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =19"); $formtrans20 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =20"); $formtrans21 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =21"); $formtrans43 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =43"); $formtrans44 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =44"); $formtrans46 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =46"); $formtrans50 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =50"); $formtrans52 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =52"); $formtran0 = mysqli_fetch_assoc($formtrans0); $formtran1 = mysqli_fetch_assoc($formtrans1); $formtran2 = mysqli_fetch_assoc($formtrans2); $formtran3 = mysqli_fetch_assoc($formtrans3); $formtran4 = mysqli_fetch_assoc($formtrans4); $formtran5 = mysqli_fetch_assoc($formtrans5); $formtran6 = mysqli_fetch_assoc($formtrans6); $formtran7 = mysqli_fetch_assoc($formtrans7); $formtran8 = mysqli_fetch_assoc($formtrans8); $formtran9 = mysqli_fetch_assoc($formtrans9); $formtran10 = mysqli_fetch_assoc($formtrans10); $formtran11 = mysqli_fetch_assoc($formtrans11); $formtran13 = mysqli_fetch_assoc($formtrans13); $formtran14 = mysqli_fetch_assoc($formtrans14); $formtran15 = mysqli_fetch_assoc($formtrans15);
<?php
require_once 'inc/helpers.php';
$kategorie = getParameter('kategorie');
$l_courses = getOnlineCoursesByCategory('course');
$l_courses_advanced = getOnlineCoursesByCategory('course_advanced');
$l_exams = getOnlineCoursesByCategory('exam');
$boxtext2trans1 = MYSQLI_QUERY($link, "Select {$lang} From `translations` where translationid =6");
$boxtext2trans1x = mysqli_fetch_array($boxtext2trans1);
$boxtext2trans2 = MYSQLI_QUERY($link, "Select {$lang} From `translations` where translationid =7");
$boxtext2trans2x = mysqli_fetch_array($boxtext2trans2);
$boxtext2trans3 = MYSQLI_QUERY($link, "Select {$lang} From `translations` where translationid =10");
$boxtext2trans3x = mysqli_fetch_array($boxtext2trans3);
?>
<div id="reiter2"><?php
echo $boxtext2trans2x[0];
?>
</div>
<ul>
<?php
while ($daten2 = mysqli_fetch_array($l_courses)) {
?>
<li <?php
if ($daten2['id'] == $kategorie) {
echo "class='linkhover'";
}
?>
><a href="termine.php?lang=<?php
echo $lang;
?>
$formtrans7 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =7"); $formtrans8 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =8"); $formtrans9 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =9"); $formtrans10 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =10"); $formtrans11 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =11"); $formtrans12 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =12"); $formtrans13 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =13"); $formtrans14 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =14"); $formtrans15 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =15"); $formtrans16 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =16"); $formtrans17 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =17"); $formtrans18 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =18"); $formtrans19 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =19"); $formtrans20 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =20"); $formtrans21 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =21"); $formtrans30 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =30"); $formtran0 = mysqli_fetch_assoc($formtrans0); $formtran1 = mysqli_fetch_assoc($formtrans1); $formtran2 = mysqli_fetch_assoc($formtrans2); $formtran3 = mysqli_fetch_assoc($formtrans3); $formtran4 = mysqli_fetch_assoc($formtrans4); $formtran5 = mysqli_fetch_assoc($formtrans5); $formtran6 = mysqli_fetch_assoc($formtrans6); $formtran7 = mysqli_fetch_assoc($formtrans7); $formtran8 = mysqli_fetch_assoc($formtrans8); $formtran9 = mysqli_fetch_assoc($formtrans9); $formtran10 = mysqli_fetch_assoc($formtrans10); $formtran11 = mysqli_fetch_assoc($formtrans11); $formtran12 = mysqli_fetch_assoc($formtrans12); $formtran13 = mysqli_fetch_assoc($formtrans13); $formtran14 = mysqli_fetch_assoc($formtrans14);
<?php
require_once 'inc/helpers.php';
$nav_a_class = $lang == "ru" ? 'russnav' : '';
$l_courses = getOnlineCoursesByCategory('course');
$l_courses_advanced = getOnlineCoursesByCategory('course_advanced');
#Menü override!!!!
$abfrage2 = MYSQLI_QUERY($link, "Select seite,boxtext_" . $lang . " From `content` where sort <> 0 order by sort asc");
?>
<div id="menu" >
<ul class="sf-menu">
<li class="line">
<a class="<?php
echo $nav_a_class;
?>
" href="kursangebot.php?lang=<?php
echo $lang;
?>
"><?php
echo t('menu.main.course_descriptions');
?>
</a>
<ul>
<li class="noline"><a href="kursangebot.php?lang=<?php
echo $lang;
?>
" class="<?php
echo $nav_a_class;
?>
"><?php
echo t('menu.main.what_is_vt');
$abfragetrans6 = MYSQLI_QUERY($link, "Select * From `translations` where translationid=9");
$datentrans6 = mysqli_fetch_array($abfragetrans6);
$abfragetrans7 = MYSQLI_QUERY($link, "Select * From `translations` where translationid=11");
$datentrans7 = mysqli_fetch_array($abfragetrans7);
$formtrans31 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =31");
$formtran31 = mysqli_fetch_assoc($formtrans31);
$formtrans51 = MYSQLI_QUERY($link, "Select * From `translations_form` where sort =51");
$formtran51 = mysqli_fetch_assoc($formtrans51);
$courseTypes = MYSQLI_QUERY($link, "Select * From `course_type` order by title asc");
$courseTypeArray = array();
while ($courseType = mysqli_fetch_array($courseTypes)) {
$courseTypeArray[$courseType['id']] = $courseType;
}
$selectedCourseType = array_key_exists($kategorie, $courseTypeArray) ? $courseTypeArray[$kategorie] : null;
// we have a specific kategory, now we fetch the courses
$courses = MYSQLI_QUERY($link, "Select * From `termine` where deaktiviert = 0 and courseTypeID = {$kategorie} order by datum_von asc");
?>
<head>
<?php
include 'inc/favicon.inc.php';
?>
<title><?php
echo $datentrans[$lang];
?>
</title>
<link type="text/css" rel="stylesheet" href="http://fast.fonts.com/cssapi/af471b08-9f95-4c83-b5fd-e3a74c678ffe.css"/>
<link href="style.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" type="text/css" href="scripts/superfish/css/superfish.css" media="screen">
<script type="text/javascript" src="bower_components/jquery/dist/jquery.min.js"></script>
echo nl2br(trim(getTranslationValue($daten2['title'], $lang)));
?>
</a>
<?php
// getting all courses of a certain course type
$courses = MYSQLI_QUERY($link, "Select * From `termine` where deaktiviert = 0 and courseTypeID = {$course_tyoe_id} order by datum_von asc");
?>
<p class="list-text">
<?php
if (mysqli_num_rows($courses) > 0) {
?>
<?php
while ($course = mysqli_fetch_array($courses)) {
?>
<?php
$q = MYSQLI_QUERY($link, "Select * From `location` where id=" . $course['locationID']);
$location = $q ? mysqli_fetch_array($q) : null;
$date = $course['datum_von'] != $course['datum_bis'] ? date_mysql2german($course['datum_von'], "%02d.%02d.") . ' - ' . date_mysql2german($course['datum_bis']) : date_mysql2german($course['datum_von']);
?>
<?php
echo $date;
echo $location ? ', ' . getTranslationValue($location['name'], $lang) : '';
?>
<br/>
<?php
}
?>
<?php
} else {
?>
<?php
<?php
if ($lang != "ru") {
?>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<html xmlns="http://www.w3.org/1999/xhtml">
<?php
} else {
?>
<meta http-equiv="content-type" content="application/xhtml+xml; charset=utf-8" />
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ru" lang="ru"/>
<?php
mysqli_query($link, "SET names 'utf8'");
}
$abfrage = MYSQLI_QUERY($link, sprintf("Select * From `content` where contentid = %s", quote_smart($id)));
$daten = mysqli_fetch_array($abfrage);
$abfrage2 = MYSQLI_QUERY($link, sprintf("Select * From `tl_translations` where tl_translationid = %s", quote_smart($id2)));
$tranlat1 = mysqli_fetch_array($abfrage2);
?>
<head>
<?php
include 'inc/favicon.inc.php';
?>
<title><?php
echo $daten['titel_' . $lang];
?>
</title>
<link type="text/css" rel="stylesheet" href="http://fast.fonts.com/cssapi/af471b08-9f95-4c83-b5fd-e3a74c678ffe.css"/>
<link href="style.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" type="text/css" href="scripts/superfish/css/superfish.css" media="screen">
<?php
$id = 117;
include 'sqli.inc.php';
$lang = $_GET["lang"];
if ($lang == "") {
$lang = "de";
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<?php
mysqli_query($link, "SET names 'utf8'");
$abfrage = MYSQLI_QUERY($link, sprintf("Select * From `content` where contentid = %s", quote_smart($id)));
$daten = mysqli_fetch_array($abfrage);
$abfrage2 = MYSQLI_QUERY($link, "Select seite,boxtext_" . $lang . " From `content` where contentid < 14 order by aufbaukurs, contentid asc");
?>
<head>
<?php
include 'inc/favicon.inc.php';
?>
<title><?php
echo $daten['titel_' . $lang];
?>
</title>
<link type="text/css" rel="stylesheet" href="http://fast.fonts.com/cssapi/af471b08-9f95-4c83-b5fd-e3a74c678ffe.css"/>
<link href="style.css" rel="stylesheet" type="text/css" />
<link rel="stylesheet" type="text/css" href="scripts/superfish/css/superfish.css" media="screen">
<script type="text/javascript" src="scripts/lightbox/js/jquery-1.7.2.min.js"></script>
<script type="text/javascript" src="scripts/superfish/js/hoverIntent.js"></script>
<?php
require_once 'inc/helpers.php';
$kategorie = getParameter('kategorie');
$l_courses = getOnlineCoursesByCategory('course');
$l_courses_advanced = getOnlineCoursesByCategory('course_advanced');
$l_exams = getOnlineCoursesByCategory('exam');
$boxtext2trans1 = MYSQLI_QUERY($link, "Select {$lang} From `translations` where translationid =6");
$boxtext2trans1x = mysqli_fetch_array($boxtext2trans1);
$boxtext2trans2 = MYSQLI_QUERY($link, "Select {$lang} From `translations` where translationid =7");
$boxtext2trans2x = mysqli_fetch_array($boxtext2trans2);
$boxtext2trans3 = MYSQLI_QUERY($link, "Select {$lang} From `translations` where translationid =10");
$boxtext2trans3x = mysqli_fetch_array($boxtext2trans3);
$tage = mysqli_fetch_array(MYSQLI_QUERY($link, "Select * From `translations` where translationid=2"));
?>
<div id="reiter2"><?php
echo $boxtext2trans2x[0];
?>
</div>
<ul>
<?php
while ($daten2 = mysqli_fetch_array($l_courses)) {
?>
<li <?php
if ($daten2['id'] == $kategorie) {
echo "class='linkhover'";
}
?>
><a href="kurs_detail.php?lang=<?php
echo $lang;