當前位置: 首頁>>代碼示例>>PHP>>正文

PHP MYSQLI_QUERY函數代碼示例

本文整理匯總了PHP中MYSQLI_QUERY函數的典型用法代碼示例。如果您正苦於以下問題：PHP MYSQLI_QUERY函數的具體用法？PHP MYSQLI_QUERY怎麽用？PHP MYSQLI_QUERY使用的例子？那麽, 這裏精選的函數代碼示例或許可以為您提供幫助。


在下文中一共展示了MYSQLI_QUERY函數的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。

示例1: query

 function query($query)
 {
     $this->connect();
     $result = MYSQLI_QUERY($this->conn, $query);
     //or die("Query For Table Failed");
     $this->disconnect();
     return $result;
 }
開發者ID:vIIPrezIIv，項目名稱:gameLibrary，代碼行數:8，代碼來源:sql_cls.php

示例2: ejecutarQuery

function ejecutarQuery($query)
{
    abrirConexion();
    return MYSQLI_QUERY($GLOBALS['Conexion'], $query);
}
開發者ID:kamilik26，項目名稱:HTML，代碼行數:5，代碼來源:funciones.php

示例3: MYSQLI_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>
開發者ID:Andreas-Schoenefeldt，項目名稱:viszerale-therapie.at，代碼行數:31，代碼來源:anmeldung2_captchasave.php

示例4: mysqli_query

<?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>
開發者ID:Andreas-Schoenefeldt，項目名稱:viszerale-therapie.at，代碼行數:31，代碼來源:datenschutzerklaerung.php

示例5: getTranslationValue

 
	</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;
    ?>
&amp;kurs=<?php 
    echo $course['terminid'];
    ?>
開發者ID:Andreas-Schoenefeldt，項目名稱:viszerale-therapie.at，代碼行數:30，代碼來源:kurs_detail.php

示例6: MYSQLI_QUERY

<?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:Andreas-Schoenefeldt，項目名稱:viszerale-therapie.at，代碼行數:31，代碼來源:courseBlock.php

示例7: mysqli_query

$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" />
開發者ID:Andreas-Schoenefeldt，項目名稱:viszerale-therapie.at，代碼行數:30，代碼來源:kursort_russia.php

示例8: getOnlineCoursesByCategory

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");
}
開發者ID:Andreas-Schoenefeldt，項目名稱:viszerale-therapie.at，代碼行數:5，代碼來源:sqli.inc.php

示例9: mysqli_query

<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();
	});
開發者ID:Andreas-Schoenefeldt，項目名稱:viszerale-therapie.at，代碼行數:31，代碼來源:index.php

示例10: MYSQLI_QUERY

$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);
開發者ID:Andreas-Schoenefeldt，項目名稱:viszerale-therapie.at，代碼行數:31，代碼來源:anmeldung.php

示例11: getParameter

<?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;
    ?>
開發者ID:Andreas-Schoenefeldt，項目名稱:viszerale-therapie.at，代碼行數:31，代碼來源:boxlinksanmeldung.php

示例12: MYSQLI_QUERY

$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);
開發者ID:Andreas-Schoenefeldt，項目名稱:viszerale-therapie.at，代碼行數:31，代碼來源:anmeldung_plain.php

示例13: getOnlineCoursesByCategory

<?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');
開發者ID:Andreas-Schoenefeldt，項目名稱:viszerale-therapie.at，代碼行數:31，代碼來源:menu_de.php

示例14: MYSQLI_QUERY

$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>
開發者ID:Andreas-Schoenefeldt，項目名稱:viszerale-therapie.at，代碼行數:31，代碼來源:termine.php

示例15: nl2br

    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
開發者ID:Andreas-Schoenefeldt，項目名稱:viszerale-therapie.at，代碼行數:31，代碼來源:coursetype_courses_box.php


注：本文中的MYSQLI_QUERY函數示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。