PHP makeSpace 예제들

예제 #1

파일: category1_en.php 프로젝트: KrishnaAmbili/micandroid

<?php

// GET HTML //
$raw_in = file_get_contents("html/category1_en.html");
// SQL STATEMENTS //
$category1 = mysql_query("SELECT id,name_en,description_en FROM category1 WHERE name_en = '" . makeSpace($requestType[2]) . "'");
$result = mysql_fetch_assoc($category1);
$category1_id = $result['id'];
// Category 2 listing
$cat2String = "";
$subCat = mysql_query("SELECT name_en FROM category2 WHERE category1_id = '" . $category1_id . "'");
while ($category2RS = mysql_fetch_assoc($subCat)) {
    $link = LIVESITEURL . "/en/" . removeSpace($result['name_en']) . "/" . removeSpace($category2RS['name_en']);
    $cat2String .= "<li><a href='" . $link . "'>" . $category2RS['name_en'] . "</a></li>";
}
// GET PAGE DATA //
$sitename_en = "SoNingbo";
$siteURL = "soningbo.com";
$category1_en = $result['name_en'];
$category1_description = $result['description_en'];
$category1Listing = getCategory1ListingEn();
$topMenusItems = topMenusItems($lang, $request2, $staticPages);
// COMBINE PAGE DATA AND HTML //
$find = array("#sitename_en", "#siteURL", "#category1_en", "#category1_description_en", "<li>#all_category2_en</li>", "<li>#all_category1_en</li>", "#topMenusItems");
$replaceCatName = array($sitename_en, $siteURL, $category1_en, $category1_description, $cat2String, $category1Listing, $topMenusItems);
$result = str_replace($find, $replaceCatName, $raw_in);
// WRITE OUT HTML
echo $result;

예제 #2

파일: category2_en.php 프로젝트: KrishnaAmbili/micandroid

<?php

// GET HTML //
$raw_in = file_get_contents("html/category2_en.html");
// SQL STATEMENTS //
$cat2name = trim(urldecode(makeSpace($requestType[3])));
$cat1name = trim(urldecode(makeSpace($requestType[2])));
$category1 = mysql_query("SELECT id,name_en,description_en,category1_id FROM category2 WHERE name_en = '" . $cat2name . "'");
$result = mysql_fetch_assoc($category1);
$category2_id = $result['id'];
// Category 2 listing
$locationString = "";
$locations = mysql_query("SELECT l.* FROM locations_category AS lc LEFT JOIN locations AS l  ON l.id = lc.location_id WHERE lc.category2_id = '" . $category2_id . "'");
while ($locationRS = mysql_fetch_assoc($locations)) {
    $link = LIVESITEURL . "/en/" . removeSpace($cat1name) . "/" . removeSpace($cat2name) . "/" . removeSpace($locationRS['name_en']) . "/" . md5($locationRS['id']);
    $locationString .= "<li><a href='" . $link . "'>" . $locationRS['name_en'] . "</a></li>";
}
// GET PAGE DATA //
$sitename_en = "SoNingbo";
$siteURL = "soningbo.com";
$category1_en = $cat1name;
$category2_en = $result['name_en'];
$category2_description_en = $result['description_en'];
$category1Listing = getCategory1ListingEn();
$topMenusItems = topMenusItems($lang, $request2, $staticPages);
// COMBINE PAGE DATA AND HTML //
$find = array("#sitename_en", "#siteURL", "#category1_en", "#category2_en", "#category2_description_en", "<li>#all_locationname_en</li>", "<li>#all_category1_en</li>", "#topMenusItems");
$replaceCatName = array($sitename_en, $siteURL, $category1_en, $category2_en, $category2_description_en, $locationString, $category1Listing, $topMenusItems);
$result = str_replace($find, $replaceCatName, $raw_in);
// WRITE OUT HTML
echo $result;

예제 #3

파일: category1_cn.php 프로젝트: KrishnaAmbili/micandroid

<?php

// GET HTML //
$raw_in = file_get_contents("html/category1_cn.html");
// SQL STATEMENTS //
$name_py = trim(urldecode(makeSpace($requestType[2])));
$category1 = mysql_query("SELECT id,name_cn,name_py,description_cn FROM category1 WHERE name_py = '" . $name_py . "'");
$result = mysql_fetch_assoc($category1);
$category1_id = $result['id'];
$categoryNameUrl = $result['name_cn'];
// Category 2 kisting
$cat2String = "";
$subCat = mysql_query("SELECT name_cn,name_py FROM category2 WHERE category1_id = '" . $category1_id . "'");
while ($category2RS = mysql_fetch_assoc($subCat)) {
    $link = LIVESITEURL . "/cn/" . removeSpace($result['name_py']) . "/" . removeSpace($category2RS['name_py']);
    $cat2String .= "<li><a href='" . $link . "'>" . $category2RS['name_cn'] . "</a></li>";
}
// GET PAGE DATA //
$sitename_cn = "搜索宁波";
$siteURL = "soningbo.com";
$category1_cn = $result['name_cn'];
$category1_description = $result['description_cn'];
$category1Listing = getCategory1ListingCn();
$topMenusItems = topMenusItems($lang, $request2, $staticPages);
// COMBINE PAGE DATA AND HTML //
$find = array("#siteURL", "#sitename_cn", "#category1_cn", "#category1_description_cn", "<li>#all_category2_cn</li>", "<li>#all_category1_cn</li>", "#topMenusItems");
$replaceCatName = array($siteURL, $sitename_cn, $category1_cn, $category1_description, $cat2String, $category1Listing, $topMenusItems);
$result = str_replace($find, $replaceCatName, $raw_in);
// WRITE OUT HTML
echo $result;