PHP connectDB::executeQueryResult Exemples

Exemple #1

Fichier : commonFun.php Projet : dimahongkong/Searching-Exploring-with-Speech-Augmented-Map-Information-SESAMI

 public function getSubCategoryComboxList($comboxName, $category, $lang)
 {
     $DBconnect = new connectDB();
     $result = $DBconnect->executeQueryResult("SELECT subCategoryID, subCategoryName FROM subcategory WHERE subCategoryLang=\"" . $lang . "\" and categoryID=" . $category . " ORDER By subCategoryOrder");
     $subCategoryList = "<select name=\"" . $comboxName . "\" size=\"7\" class=\"dropdwnbox\" onChange=\"checkActiveNextButton(this.value,'nextBtn')\">";
     while ($subCategoryRecord = mysql_fetch_array($result, MYSQL_BOTH)) {
         $subCategoryList = $subCategoryList . "<option value='" . $subCategoryRecord["subCategoryID"] . "'>" . $subCategoryRecord["subCategoryName"] . "</option>";
     }
     $subCategoryList = $subCategoryList . "</select>";
     return $subCategoryList;
 }

Exemple #2

Fichier : makePackage.php Projet : dimahongkong/Searching-Exploring-with-Speech-Augmented-Map-Information-SESAMI

        if (is_file($source) === true) {
            $zip->addFromString(basename($source), file_get_contents($source));
        }
    }
    return $zip->close();
}
deleteDirectory("package/");
unlink("package.zip");
mkdir("package/", 0777);
$db = new MyDB();
$db->exec($sqlList->createIndoorMapCategories);
$db->exec($sqlList->createIndoorMapDistricts);
$db->exec($sqlList->createIndoorMapFloorPlanLabels);
$db->exec($sqlList->createIndoorMapFloorPlans);
$db->exec($sqlList->createIndoorMaps);
$queryAllCategoryResult = $DBConnect->executeQueryResult($sqlList->queryAllCategory);
while ($queryAllCategoryResultRecord = mysql_fetch_array($queryAllCategoryResult, MYSQL_BOTH)) {
    $insertIndoorMapcategoryies = str_replace("%CATEGORYID%", $queryAllCategoryResultRecord["id"], $sqlList->insertIndoorMapcategoryies);
    $insertIndoorMapcategoryies = str_replace("%NAME%", $queryAllCategoryResultRecord["name"], $insertIndoorMapcategoryies);
    $db->query($insertIndoorMapcategoryies);
}
$queryAllDistrictResult = $DBConnect->executeQueryResult($sqlList->queryAllDistrict);
while ($queryAllDistrictResultRecord = mysql_fetch_array($queryAllDistrictResult, MYSQL_BOTH)) {
    $insertIndoorMapDistricts = str_replace("%DISTRICTID%", $queryAllDistrictResultRecord["id"], $sqlList->insertIndoorMapDistricts);
    $insertIndoorMapDistricts = str_replace("%NAME%", $queryAllDistrictResultRecord["name"], $insertIndoorMapDistricts);
    $db->query($insertIndoorMapDistricts);
}
$queryAllFloorPlanLabelsResult = $DBConnect->executeQueryResult($sqlList->queryAllFloorPlanLabels);
while ($queryAllFloorPlanLabelsResultRecord = mysql_fetch_array($queryAllFloorPlanLabelsResult, MYSQL_BOTH)) {
    $insertIndoorAllFloorPlanLabels = str_replace("%FLOORPLANLABELID%", $queryAllFloorPlanLabelsResultRecord["id"], $sqlList->insertIndoorAllFloorPlanLabels);
    $insertIndoorAllFloorPlanLabels = str_replace("%NAME%", $queryAllFloorPlanLabelsResultRecord["name"], $insertIndoorAllFloorPlanLabels);