|
PHP - Is This Part Of Code...
is this part of code correct ?
Code: [Select] $query = mysql_query("select * from username WHERE username='$username'"); if(mysql_query($query) > 0) { die("Username already in use."); } else { Similar TutorialsHello, I have one line that I can't understand of PHP code used to encrypt strings: $temp = ord(substr($str,$i,1)) ^ 203; I understand everything but this " ^203 " Can you explain me what it does? Hello All,
Apologies if i am going about this the incorrect way, but after over 8 hours of coding and not being able to solve my problem i am forced to seek help on forums for the first time.
I have a wordpress website and have installed a third party plugin that allows me to enter item details and display them front end to users who can then filter by category.
You can see the working example here and a screenshot highlighting the different sections here.
The plugin works fine, displaying products based on the category and sub category they are assigned to, however the layout becomes distorted when the screen size is reduced. Images have been included below:
Larger screen size
Smaller screen size
I have been doing some reading and i think that rather than using multiple <div> tags (as the plugin creator has done), i have instead tried to use 3 separate tables. (one for the sidebar, one for the main section, and then a table with two columns to hold each)
My plan is shown here.
I have successfully managed to re-code the sidebar on the left into a table, however i am struggling to modify the main section.
Unfortunately i cannot explain much about the code as it was not written by me, i can tell you that three are 3 different layouts available: Thumb, List and Detail.
I am only using Detail.
I have attempted to modify the code multiple times, but i cannot get the main table and list table to work correctly.
I have included the modified code where i have only changed the sidebar. I have kept the rest as standard to show you all what i am working with to begin with.
Points of interest:
I have been applying the main table at line 431 and ending it at 437.
I have been applying the list table at line 423.
The list table items (rows) begin at 558
<?php
/* The function that creates the HTML on the front-end, based on the parameters
* supplied in the product-catalog shortcode */
function Insert_Product_Catalog($atts) {
// Include the required global variables, and create a few new ones
global $wpdb, $categories_table_name, $subcategories_table_name, $tags_table_name, $tagged_items_table_name, $catalogues_table_name, $catalogue_items_table_name, $items_table_name;
global $ReturnString, $ProdCats, $ProdSubCats, $ProdTags, $ProdCatString, $ProdSubCatString, $ProdTagString, $Catalogue_ID, $Catalogue_Layout_Format, $Catalogue_Sidebar, $Full_Version;
$ReturnString = "";
$Filter = get_option("UPCP_Filter_Type");
$Color = get_option("UPCP_Color_Scheme");
$Links = get_option("UPCP_Product_Links");
$Detail_Image = get_option("UPCP_Details_Image");
$Pretty_Links = get_option("UPCP_Pretty_Links");
$Mobile_Style = get_option("UPCP_Mobile_SS");
$Pagination_Location = get_option("UPCP_Pagination_Location");
$CaseInsensitiveSearch = get_option("UPCP_Case_Insensitive_Search");
$Maintain_Filtering = get_option("UPCP_Maintain_Filtering");
$Products_Per_Page = get_option("UPCP_Products_Per_Page");
$ProductSearch = get_option("UPCP_Product_Search");
$Products_Pagination_Label = get_option("UPCP_Products_Pagination_Label");
$Product_Name_Search_Label = get_option("UPCP_Product_Name_Search_Label");
$No_Results_Found_Label = get_option("UPCP_No_Results_Found_Label");
if ($Products_Pagination_Label != "") {$Products_Pagination_Text = $Products_Pagination_Label;}
else {$Products_Pagination_Text = __(' products', 'UPCP');}
if ($Product_Search_Text_Label != "") {$Product_Name_Text = $Product_Name_Search_Label;}
else {
if ($ProductSearch == "namedesc" or $ProductSearch == "namedesccust") {$Product_Name_Text = __("Search...", 'UPCP');}
else {$Product_Name_Text = __("Name...", 'UPCP');}
}
// Get the attributes passed by the shortcode, and store them in new variables for processing
extract( shortcode_atts( array(
"id" => "1",
"excluded_layouts" => "None",
"starting_layout" => "",
"products_per_page" => "",
"current_page" => 1,
"sidebar" => "Yes",
"only_inner" => "No",
"ajax_reload" => "No",
"ajax_url" => "",
"request_count" => 0,
"category" => "",
"subcategory" => "",
"tags" => "",
"prod_name" => ""),
$atts
)
);
// Select the catalogue information from the database
$Catalogue = $wpdb->get_row("SELECT * FROM $catalogues_table_name WHERE Catalogue_ID=" . $id);
$CatalogueItems = $wpdb->get_results("SELECT * FROM $catalogue_items_table_name WHERE Catalogue_ID=" . $id . " ORDER BY Position");
// Add any additional CSS in-line
if ($Catalogue->Catalogue_Custom_CSS != "") {
$HeaderBar .= "<style type='text/css'>";
$HeaderBar .= $Catalogue->Catalogue_Custom_CSS;
$HeaderBar .= "</style>";
}
if ($Detail_Image != "") {
$HeaderBar .= "<style type='text/css'>";
$HeaderBar .= ".upcp-thumb-details-link, .upcp-list-details-link, .upcp-detail-details-link {";
$HeaderBar .= "background: url('" . $Detail_Image . "');";
$HeaderBar .= "}";
$HeaderBar .= "</style>";
}
$Top_JS .= "<script language='JavaScript' type='text/javascript'>";
if ($Maintain_Filtering == "Yes") {$Top_JS .= "var maintain_filtering = 'Yes';";}
else {$Top_JS .= "var maintain_filtering = 'No';";}
$Top_JS .= "</script>";
$HeaderBar .= $Top_JS;
$HeaderBar .= "<form id='upcp-hidden-filtering-form' method='post'>";
$HeaderBar .= "<input type='hidden' id='upcp-selected-categories' name='categories' value='" . $_POST['categories'] . "' />";
$HeaderBar .= "<input type='hidden' id='upcp-selected-subcategories' name='subcategories' value='" . $_POST['subcategories'] . "' />";
$HeaderBar .= "<input type='hidden' id='upcp-selected-tags' name='tags' value='" . $_POST['tags'] . "' />";
$HeaderBar .= "<input type='hidden' id='upcp-selected-prod-name' name='prod_name' value='" . $_POST['prod_name'] . "' />";
$HeaderBar .= "</form>";
if (get_query_var('single_product') != "" or $_GET['SingleProduct'] != "") {
$ReturnString .= $HeaderBar;
$ReturnString .= SingleProductPage();
return $ReturnString;
}
$Catalogue_ID = $id;
$Catalogue_Sidebar = $sidebar;
$Starting_Layout = ucfirst($starting_layout);
if ($excluded_layouts != "None") {$Excluded_Layouts = explode(",", $excluded_layouts);}
else {$Excluded_Layouts = array();}
if (isset($_GET['categories'])) {$category = explode(",", $_GET['categories']);}
elseif (isset($_POST['categories']) and $_POST['categories'] != "") {$category = explode(",", $_POST['categories']);}
elseif ($category == "") {$category = array();}
else {$category = explode(",", $category);}
if (isset($_GET['sub-categories'])) {$subcategory = explode(",", $_GET['sub-categories']);}
elseif (isset($_POST['subcategories']) and $_POST['subcategories'] != "") {$subcategory = explode(",", $_POST['subcategories']);}
elseif ($subcategory == "") {$subcategory = array();}
else {$subcategory = explode(",", $subcategory);}
if (isset($_GET['tags'])) {$tags = explode(",", $_GET['tags']);}
elseif (isset($_POST['tags']) and $_POST['tags'] != "") {$tags = explode(",", $_POST['tags']);}
elseif ($tags == "") {$tags = array();}
else {$tags = explode(",", $tags);}
if (isset($_POST['prod_name']) and $_POST['prod_name'] != "") {$prod_name = $_POST['prod_name'];}
//Pagination early work
if ($products_per_page == "") {$products_per_page = $Products_Per_Page;}
if ($category != "" or $subcategory != "" or $tags != "" or $prod_name != "") {$Filtered = "Yes";}
else {$Filtered = "No";}
$ReturnString .= "<div class='upcp-Hide-Item' id='upcp-shortcode-atts'>";
$ReturnString .= "<div class='shortcode-attr' id='upcp-catalogue-id'>" . $id . "</div>";
$ReturnString .= "<div class='shortcode-attr' id='upcp-catalogue-sidebar'>" . $sidebar . "</div>";
$ReturnString .= "<div class='shortcode-attr' id='upcp-starting-layout'>" . $starting_layout . "</div>";
$ReturnString .= "<div class='shortcode-attr' id='upcp-current-layout'>" . $starting_layout . "</div>";
$ReturnString .= "<div class='shortcode-attr' id='upcp-exclude-layouts'>" . $excluded_layouts . "</div>";
$ReturnString .= "<div class='shortcode-attr' id='upcp-current-page'>" . $current_page . "</div>";
$ReturnString .= "<div class='shortcode-attr' id='upcp-default-search-text'>" . $Product_Name_Text . "</div>";
if ($ajax_reload == "Yes") {$ReturnString .= "<div class='shortcode-attr' id='upcp-base-url'>" . $ajax_url . "</div>";}
else {
$uri_parts = explode('?', $_SERVER['REQUEST_URI'], 2);
if ($uri_parts[0] != "/") {$ReturnString .= "<div class='shortcode-attr' id='upcp-base-url'>" . $uri_parts[0] . "</div>";}
else {$ReturnString .= "<div class='shortcode-attr' id='upcp-base-url'>/?" . $uri_parts[1] . "</div>";}
}
$ReturnString .= "</div>";
if (sizeOf($Excluded_Layouts)>0) {for ($i=0; $i<sizeOf($Excluded_Layouts); $i++) {$ExcludedLayouts[$i] = ucfirst(trim($Excluded_Layouts[$i]));}}
else {$ExcludedLayouts = array();}
if ($Starting_Layout == "") {
if (!in_array("Thumbnail", $Excluded_Layouts)) {$Starting_Layout = "Thumbnail";}
elseif (!in_array("List", $Excluded_Layouts)) {$Starting_Layout = "List";}
else {$Starting_Layout = "Detail";}
}
// Make sure that the layout is set
if ($layout_format != "Thumbnail" and $layout_format != "List") {
if ($Catalogue->Catalogue_Layout_Format != "") {$format = $Catalogue->Catalogue_Layout_Format;}
else {$format = "Thumbnail";}
}
else {$format = $layout_format;}
// Arrays to store what categories, sub-categories and tags are applied to the product in the catalogue
$ProdCats = array();
$ProdSubCats = array();
$ProdTags = array();
$ProdThumbString .= "<div id='prod-cat-" . $id . "' class='prod-cat thumb-display ";
if ($Starting_Layout != "Thumbnail") {$ProdThumbString .= "hidden-field";}
$ProdThumbString .= "'>\n";
$ProdThumbString .= "%upcp_pagination_placeholder_top%";
$ProdListString .= "<div id='prod-cat-" . $id . "' class='prod-cat list-display ";
if ($Starting_Layout != "List") {$ProdListString .= "hidden-field";}
$ProdListString .= "'>\n";
$ProdListString .= "%upcp_pagination_placeholder_top%";
$ProdDetailString .= "<div id='prod-cat-" . $id . "' class='prod-cat detail-display ";
if ($Starting_Layout != "Detail") {$ProdDetailString .= "hidden-field";}
$ProdDetailString .= "'>\n";
$ProdDetailString .= "%upcp_pagination_placeholder_top%";
$Product_Count = 0;
foreach ($CatalogueItems as $CatalogueItem) {
// If the item is a product, then simply call the AddProduct function to add it to the code
if ($CatalogueItem->Item_ID != "" and $CatalogueItem->Item_ID != 0) {
$Product = $wpdb->get_row("SELECT * FROM $items_table_name WHERE Item_ID=" . $CatalogueItem->Item_ID);
$ProdTagObj = $wpdb->get_results("SELECT Tag_ID FROM $tagged_items_table_name WHERE Item_ID=" . $CatalogueItem->Item_ID);
$ProdTag = ObjectToArray($ProdTagObj);
$NameSearchMatch = SearchProductName($Product->Item_ID, $Product->Item_Name, $Product->Item_Description, $prod_name, $CaseInsensitiveSearch, $ProductSearch);
if (sizeOf($tags) == 0) {$Tag_Check = "Yes";}
else {$Tag_Check = CheckTags($tags, $ProdTag, $Tag_Logic);}
if ($products_per_page < 1000000) {$Pagination_Check = CheckPagination($Product_Count, $products_per_page, $current_page, $Filtered);}
else {$Pagination_Check = "OK";}
if ($NameSearchMatch == "Yes") {
if ($Product->Item_Display_Status != "Hide") {
if (sizeOf($category) == 0 or in_array($Product->Category_ID, $category)) {
if (sizeOf($subcategory) == 0 or in_array($Product->SubCategory_ID, $subcategory)) {
if ($Tag_Check == "Yes") {
if ($Pagination_Check == "OK") {
$HeaderBar .= "<a id='hidden_FB_link-" . $CatalogueItem->Item_ID . "' class='fancybox' href='#prod-cat-addt-details-" . $CatalogueItem->Item_ID . "'></a>";
if (!in_array("Thumbnail", $ExcludedLayouts)) {$ProdThumbString .= AddProduct("Thumbnail", $CatalogueItem->Item_ID, $Product, $ProdTagObj, $ajax_reload, $ajax_url);}
if (!in_array("List", $ExcludedLayouts)) {$ProdListString .= AddProduct("List", $CatalogueItem->Item_ID, $Product, $ProdTagObj, $ajax_reload, $ajax_url);}
if (!in_array("Detail", $ExcludedLayouts)) {$ProdDetailString .= AddProduct("Detail", $CatalogueItem->Item_ID, $Product, $ProdTagObj, $ajax_reload, $ajax_url);}
}
$Product_Count++;
}}}}}
if ($ajax_reload == "No") {FilterCount($Product, $ProdTagObj);}
unset($NameSearchMatch);
}
// If the item is a category, then add the appropriate extra HTML and call the AddProduct function
// for each individual product in the category
if ($CatalogueItem->Category_ID != "" and $CatalogueItem->Category_ID != 0) {
if (sizeOf($category) == 0 or in_array($CatalogueItem->Category_ID, $category)) {
$CatProdCount = 0;
$Category = $wpdb->get_row("SELECT Category_Name FROM $categories_table_name WHERE Category_ID=" . $CatalogueItem->Category_ID);
$ProdThumbString .= "<div id='prod-cat-category-" . $CatalogueItem->Category_ID . "' class='prod-cat-category upcp-thumb-category'>\n";
$ProdListString .= "<div id='prod-cat-category-" . $CatalogueItem->Category_ID . "' class='prod-cat-category upcp-list-category'>\n";
$ProdDetailString .= "<div id='prod-cat-category-" . $CatalogueItem->Category_ID . "' class='prod-cat-category upcp-detail-category'>\n";
$ProdThumbString .= "%Category_Label%";
$ProdListString .= "%Category_Label%";
$ProdDetailString .= "%Category_Label%";
$CatThumbHead = "<div id='prod-cat-category-label-" . $CatalogueItem->Category_ID . "' class='prod-cat-category-label upcp-thumb-category-label'>" . $Category->Category_Name ."</div>\n";
$CatListHead = "<div id='prod-cat-category-label-" . $CatalogueItem->Category_ID . "' class='prod-cat-category-label upcp-list-category-label'>" . $Category->Category_Name ."</div>\n";
$CatDetailHead = "<div id='prod-cat-category-label-" . $CatalogueItem->Category_ID . "' class='prod-cat-category-label upcp-detail-category-label'>" . $Category->Category_Name ."</div>\n";
$Products = $wpdb->get_results("SELECT * FROM $items_table_name WHERE Category_ID=" . $CatalogueItem->Category_ID);
foreach ($Products as $Product) {
$ProdTagObj = $wpdb->get_results("SELECT Tag_ID FROM $tagged_items_table_name WHERE Item_ID=" . $Product->Item_ID);
$ProdTag = ObjectToArray($ProdTagObj);
$NameSearchMatch = SearchProductName($Product->Item_ID, $Product->Item_Name, $Product->Item_Description, $prod_name, $CaseInsensitiveSearch, $ProductSearch);
if (sizeOf($tags) == 0) {$Tag_Check = "Yes";}
else {$Tag_Check = CheckTags($tags, $ProdTag, $Tag_Logic);}
if ($products_per_page < 1000000) {$Pagination_Check = CheckPagination($Product_Count, $products_per_page, $current_page, $Filtered);}
else {$Pagination_Check = "OK";}
if ($NameSearchMatch == "Yes") {
if ($Product->Item_Display_Status != "Hide") {
if (sizeOf($subcategory) == 0 or in_array($Product->SubCategory_ID, $subcategory)) {
if ($Tag_Check == "Yes") {
if ($Pagination_Check == "OK") {
$HeaderBar .= "<a id='hidden_FB_link-" . $Product->Item_ID . "' class='fancybox' href='#prod-cat-addt-details-" . $Product->Item_ID . "'></a>";
if (!in_array("Thumbnail", $ExcludedLayouts)) {$ProdThumbString .= AddProduct("Thumbnail", $Product->Item_ID, $Product, $ProdTagObj, $ajax_reload, $ajax_url);}
if (!in_array("List", $ExcludedLayouts)) {$ProdListString .= AddProduct("List", $Product->Item_ID, $Product, $ProdTagObj, $ajax_reload, $ajax_url);}
if (!in_array("Detail", $ExcludedLayouts)) {$ProdDetailString .= AddProduct("Detail", $Product->Item_ID, $Product, $ProdTagObj, $ajax_reload, $ajax_url);}
$CatProdCount++;
}
$Product_Count++;
}}}}
if ($ajax_reload == "No") {FilterCount($Product, $ProdTagObj);}
unset($NameSearchMatch);
}
if ($CatProdCount > 0) {
$ProdThumbString = str_replace("%Category_Label%", $CatThumbHead, $ProdThumbString);
$ProdListString = str_replace("%Category_Label%", $CatListHead, $ProdListString);
$ProdDetailString = str_replace("%Category_Label%", $CatDetailHead, $ProdDetailString);
}
else {
$ProdThumbString = str_replace("%Category_Label%", "", $ProdThumbString);
$ProdListString = str_replace("%Category_Label%", "", $ProdListString);
$ProdDetailString = str_replace("%Category_Label%", "", $ProdDetailString);
}
$ProdThumbString .= "</div>";
$ProdListString .= "</div>";
$ProdDetailString .= "</div>";
}}
// If the item is a sub-category, then add the appropriate extra HTML and call the AddProduct function
// for each individual product in the sub-category
if ($CatalogueItem->SubCategory_ID != "" and $CatalogueItem->SubCategory_ID != 0) {
if (sizeOf($subcategory) == 0 or in_array($CatalogueItem->SubCategory_ID, $subcategory)) {
$Products = $wpdb->get_results("SELECT * FROM $items_table_name WHERE SubCategory_ID=" . $CatalogueItem->SubCategory_ID);
foreach ($Products as $Product) {
$ProdTagObj = $wpdb->get_results("SELECT Tag_ID FROM $tagged_items_table_name WHERE Item_ID=" . $Product->Item_ID);
$ProdTag = ObjectToArray($ProdTagObj);
$NameSearchMatch = SearchProductName($Product->Item_ID, $Product->Item_Name, $Product->Item_Description, $prod_name, $CaseInsensitiveSearch, $ProductSearch);
if (sizeOf($tags) == 0) {$Tag_Check = "Yes";}
else {$Tag_Check = CheckTags($tags, $ProdTag, $Tag_Logic);}
if ($products_per_page < 1000000) {$Pagination_Check = CheckPagination($Product_Count, $products_per_page, $current_page, $Filtered);}
else {$Pagination_Check = "OK";}
if ($NameSearchMatch == "Yes") {
if ($Product->Item_Display_Status != "Hide") {
if (sizeOf($category) == 0 or in_array($Product->Category_ID, $category)) {
if ($Tag_Check == "Yes") {
if ($Pagination_Check == "OK") {
$HeaderBar .= "<a id='hidden_FB_link-" . $Product->Item_ID . "' class='fancybox' href='#prod-cat-addt-details-" . $Product->Item_ID . "'></a>";
if (!in_array("Thumbnail", $ExcludedLayouts)) {$ProdThumbString .= AddProduct("Thumbnail", $Product->Item_ID, $Product, $ProdTagObj, $ajax_reload, $ajax_url);}
if (!in_array("List", $ExcludedLayouts)) {$ProdListString .= AddProduct("List", $Product->Item_ID, $Product, $ProdTagObj, $ajax_reload, $ajax_url);}
if (!in_array("Detail", $ExcludedLayouts)) {$ProdDetailString .= AddProduct("Detail", $Product->Item_ID, $Product, $ProdTagObj, $ajax_reload, $ajax_url);}
}
$Product_Count++;
}}}}
if ($ajax_reload == "No") {FilterCount($Product, $ProdTagObj);}
unset($NameSearchMatch);
}
}}
//if ($Pagination_Check == "Over") {break;}
}
if ($Product_Count == 0) {
$ProdThumbString .= $No_Results_Found_Label;
$ProdListString .= $No_Results_Found_Label;
$ProdDetailString .= $No_Results_Found_Label;
}
$ProdThumbString .= "<div class='upcp-clear'></div>\n";
$ProdListString .= "<div class='upcp-clear'></div>\n";
$ProdDetailString .= "<div class='upcp-clear'></div>\n";
if ($Pagination_Location == "Bottom" or $Pagination_Location == "Both") {
$ProdThumbString .= "%upcp_pagination_placeholder_bottom%";
$ProdListString .= "%upcp_pagination_placeholder_bottom%";
$ProdDetailString .= "%upcp_pagination_placeholder_bottom%";
/*$ProdThumbString .= "<div class='upcp-clear'></div>\n";
$ProdListString .= "<div class='upcp-clear'></div>\n";
$ProdDetailString .= "<div class='upcp-clear'></div>\n";*/
}
$ProdThumbString .= "</div>\n";
$ProdListString .= "</div>\n";
$ProdDetailString .= "</div>\n";
if (in_array("Thumbnail", $ExcludedLayouts)) {unset($ProdThumbString);}
if (in_array("List", $ExcludedLayouts)) {unset($ProdListString);}
if (in_array("Detail", $ExcludedLayouts)) {unset($ProdDetailString);}
//Deal with creating the page counter, if pagination is neccessary
if ($Filtered == "Yes") {$Total_Products = $Product_Count;}
else {$Total_Products = $Catalogue->Catalogue_Item_Count;}
if ($Total_Products > $products_per_page) {
$Num_Pages = ceil($Total_Products / $products_per_page);
$PrevPage = max($current_page - 1, 1);
$NextPage = min($current_page + 1, $Num_Pages);
$PaginationString .= "<div class='catalogue-nav'>";
$PaginationString .= "<span class='displaying-num'>" . $Total_Products . $Products_Pagination_Text . "</span>";
$PaginationString .= "<span class='pagination-links'>";
$PaginationString .= "<a class='first-page' title='Go to the first page' href='#' onclick='UPCP_DisplayPage(\"1\")'>«</a>";
$PaginationString .= "<a class='prev-page' title='Go to the previous page' href='#' onclick='UPCP_DisplayPage(\"" . $PrevPage . "\")'>‹</a>";
$PaginationString .= "<span class='paging-input'>" . $current_page . __(' of ', 'UPCP') . "<span class='total-pages'>" . $Num_Pages . "</span></span>";
$PaginationString .= "<a class='next-page' title='Go to the next page' href='#' onclick='UPCP_DisplayPage(\"" . $NextPage . "\")'>›</a>";
$PaginationString .= "<a class='last-page' title='Go to the last page' href='#' onclick='UPCP_DisplayPage(\"" . $Num_Pages . "\")'>»</a>";
$PaginationString .= "</span>";
$PaginationString .= "</div>";
if ($current_page == 1) {$PaginationString = str_replace("first-page", "first-page disabled", $PaginationString);}
if ($current_page == 1) {$PaginationString = str_replace("prev-page", "prev-page disabled", $PaginationString);}
if ($current_page == $Num_Pages) {$PaginationString = str_replace("next-page", "next-page disabled", $PaginationString);}
if ($current_page == $Num_Pages) {$PaginationString = str_replace("last-page", "last-page disabled", $PaginationString);}
/*if ($current_page != 1) {$PaginationString .= "<a href='#' onclick='UPCP_DisplayPage(\"1\")>" . __('First', 'UPCP') . "</a>";}
if ($current_page != 1) {$PaginationString .= "<a href='#' onclick='UPCP_DisplayPage(\"" . $current_page - 1 . "\")>" . __('Previous', 'UPCP') . "</a>";}
$PaginationString .= "<span class='paging-input'>" . $current_page . __(' of ', 'UPCP') . "<span class='total-pages'>" . $Num_Pages . "</span></span>";
if ($current_page != $Num_Pages) {$PaginationString .= "<a href='#' onclick='UPCP_DisplayPage(\"" . $current_page + 1 . "\")>" . __('Next', 'UPCP') . "</a>";}
if ($current_page != $Num_Pages) {$PaginationString .= "<a href='#' onclick='UPCP_DisplayPage(\"" . $Num_Pages . "\")>" . __('Last', 'UPCP') . "</a>";}*/
}
if ($Pagination_Location == "Bottom") {
$ProdThumbString = str_replace("%upcp_pagination_placeholder_top%", "", $ProdThumbString);
$ProdListString = str_replace("%upcp_pagination_placeholder_top%", "", $ProdListString);
$ProdDetailString = str_replace("%upcp_pagination_placeholder_top%", "", $ProdDetailString);
}
if ($Pagination_Location == "Top") {
$ProdThumbString = str_replace("%upcp_pagination_placeholder_bottom%", "", $ProdThumbString);
$ProdListString = str_replace("%upcp_pagination_placeholder_bottom%", "", $ProdListString);
$ProdDetailString = str_replace("%upcp_pagination_placeholder_bottom%", "", $ProdDetailString);
}
$ProdThumbString = str_replace("%upcp_pagination_placeholder_top%", $PaginationString, $ProdThumbString);
$ProdListString = str_replace("%upcp_pagination_placeholder_top%", $PaginationString, $ProdListString);
$ProdDetailString = str_replace("%upcp_pagination_placeholder_top%", $PaginationString, $ProdDetailString);
$ProdThumbString = str_replace("%upcp_pagination_placeholder_bottom%", $PaginationString, $ProdThumbString);
$ProdListString = str_replace("%upcp_pagination_placeholder_bottom%", $PaginationString, $ProdListString);
$ProdDetailString = str_replace("%upcp_pagination_placeholder_bottom%", $PaginationString, $ProdDetailString);
// Create string from the arrays, should use the implode function instead
foreach ($ProdCats as $key=>$value) {$ProdCatString .= $key . ",";}
$ProdCatString = trim($ProdCatString, " ,");
foreach ($ProdSubCats as $key=>$value) {$ProdSubCatString .= $key . ",";}
$ProdSubCatString = trim($ProdSubCatString, " ,");
foreach ($ProdTags as $key=>$value) {$ProdTagString .= $key . ",";}
$ProdTagString = trim($ProdTagString, " ,");
// If the sidebar is requested, add it
if (($sidebar == "Yes" or $sidebar == "yes" or $sidebar == "YES") and $only_inner != "Yes") {
$SidebarString = BuildSidebar($category, $subcategory, $tags, $prod_name);
}
if ($Mobile_Style == "Yes") {
$MobileMenuString .= "<div id='prod-cat-mobile-menu' class='upcp-mobile-menu'>\n";
$MobileMenuString .= "<div id='prod-cat-mobile-search'>\n";
if ($Tag_Logic == "OR") {$MobileMenuString .= "<input type='text' id='upcp-mobile-search' class='jquery-prod-name-text mobile-search' name='Mobile_Search' value='" . __('Product Name', 'UPCP') . "...' onfocus='FieldFocus(this);' onblur='FieldBlur(this);' onkeyup='UPCP_Filer_Results_OR();'>\n";}
else {$MobileMenuString .= "<input type='text' id='upcp-mobile-search' class='jquery-prod-name-text mobile-search' name='Mobile_Search' value='" . __('Product Name', 'UPCP') . "...' onfocus='FieldFocus(this);' onblur='FieldBlur(this);' onkeyup='UPCP_Filer_Results();'>\n";}
$MobileMenuString .= "</div>";
$MobileMenuString .= "</div>";
}
$HeaderBar .= "<div class='prod-cat-header-div " . $Color . "-prod-cat-header-div'>";
$HeaderBar .= "<div class='prod-cat-header-padding'></div>";
$HeaderBar .= "<div id='starting-layout' class='hidden-field'>" . $Starting_Layout . "</div>";
if (!in_array("Thumbnail", $ExcludedLayouts)) {
$HeaderBar .= "<a href='#' onclick='ToggleView(\"Thumbnail\");return false;' title='Thumbnail'><div class='upcp-thumb-toggle-icon " . $Color . "-thumb-icon'></div></a>";
}
if (!in_array("List", $ExcludedLayouts)) {
$HeaderBar .= "<a href='#' onclick='ToggleView(\"List\"); return false;' title='List'><div class='upcp-list-toggle-icon " . $Color . "-list-icon'></div></a>";
}
if (!in_array("Detail", $ExcludedLayouts)) {
$HeaderBar .= "<a href='#' onclick='ToggleView(\"Detail\"); return false;' title='Detail'><div class='upcp-details-toggle-icon " . $Color . "-details-icon'></div></a>";
}
$HeaderBar .= "<div class='upcp-clear'></div>";
$HeaderBar .= "</div>";
$Bottom_JS .= "<script language='JavaScript' type='text/javascript'>";
if (isset($_GET['Product_ID'])) {$Bottom_JS .= "jQuery(window).load(OpenProduct('" . $_GET['Product_ID'] . "'));";}
$Bottom_JS .= "</script>";
$InnerString .= "<div class='prod-cat-inner'>" . $ProdThumbString . "<div class='upcp-clear'></div>" . $ProdListString . "<div class='upcp-clear'></div>" . $ProdDetailString . "<div class='upcp-clear'></div></div>";
if ($only_inner == "Yes") {
$ReturnArray['request_count'] = $request_count;
$ReturnArray['message'] = $InnerString;
return json_encode($ReturnArray);
}
$ReturnString .= "<div class='prod-cat-container'>";
$ReturnString .= $HeaderBar;
$ReturnString .= $MobileMenuString;
$ReturnString .= $InnerString;
$ReturnString .= $SidebarString;
$ReturnString .= $Bottom_JS;
$ReturnString .= "<div class='upcp-clear'></div></div>";
return $ReturnString;
}
/* Function to add the HTML for an individual product to the catalog */
function AddProduct($format, $Item_ID, $Product, $Tags, $AjaxReload = "No", $AjaxURL = "") {
// Add the required global variables
global $wpdb, $categories_table_name, $subcategories_table_name, $tags_table_name, $tagged_items_table_name, $catalogues_table_name, $catalogue_items_table_name, $items_table_name, $item_images_table_name;
global $ProdCats, $ProdSubCats, $ProdTags, $ReturnString;
$ReadMore = get_option("UPCP_Read_More");
$Links = get_option("UPCP_Product_Links");
$Pretty_Links = get_option("UPCP_Pretty_Links");
$Detail_Desc_Chars = get_option("UPCP_Desc_Chars");
$CF_Conversion = get_option("UPCP_CF_Conversion");
$Details_Label = get_option("UPCP_Details_Label");
if ($Details_Label != "") {$Details_Text = $Details_Label;}
else {$Details_Text = __("Details", 'UPCP');}
if ($Links == "New") {$NewWindow = true;}
else {$NewWindow = false;}
if ($CF_Conversion != "No") {$Description = ConvertCustomFields($Product->Item_Description);}
else {$Description = $Product->Item_Description;}
$Description = str_replace("[upcp-price]", $Product->Item_Price, $Description);
//Select the product info, tags and images for the product
$Item_Images = $wpdb->get_results("SELECT Item_Image_URL, Item_Image_ID FROM $item_images_table_name WHERE Item_ID=" . $Item_ID);
$TagsString = "";
if ($Product->Item_Photo_URL != "" and strlen($Product->Item_Photo_URL) > 7 and substr($Product->Item_Photo_URL, 0, 7) != "http://") {
$PhotoCode = $Product->Item_Photo_URL;
$PhotoCode = do_shortcode($PhotoCode);
}
elseif ($Product->Item_Photo_URL != "" and strlen($Product->Item_Photo_URL) > 7) {
$PhotoURL = htmlspecialchars($Product->Item_Photo_URL, ENT_QUOTES);
$PhotoCode = "<img src='" . $PhotoURL . "' alt='" . $Product->Item_Name . " Image' id='prod-cat-thumb-" . $Product->Item_ID . "' class='prod-cat-thumb-image upcp-thumb-image'>";
}
else {
$PhotoURL = plugins_url('ultimate-product-catalogue/images/No-Photo-Available.jpg');
$PhotoCode = "<img src='" . $PhotoURL . "' alt='" . $Product->Item_Name . " Image' id='prod-cat-thumb-" . $Product->Item_ID . "' class='prod-cat-thumb-image upcp-thumb-image'>";
}
//Create the tag string for filtering
foreach ($Tags as $Tag) {$TagsString .= $Tag->Tag_ID . ", ";}
$TagsString = trim($TagsString, " ,");
// Check whether the FancyBox for WordPress plugin is activated
$plugin = "fancybox-for-wordpress/fancybox.php";
include_once( ABSPATH . 'wp-admin/includes/plugin.php' );
$FancyBox_Installed = is_plugin_active($plugin);
$uri_parts = explode('?', $_SERVER['REQUEST_URI'], 2);
$FB_Perm_URL = $uri_parts[0] . "?" . $uri_parts[1];
if ($uri_parts[1] == "") {$FB_Perm_URL .= "Product_ID=" . $Product->Item_ID;}
else {$FB_Perm_URL .= "&Product_ID=" . $Product->Item_ID;}
if ($AjaxReload == "Yes") {$Base = $AjaxURL;}
else {$Base = $uri_parts[0];}
if ($Product->Item_Link != "") {$ItemLink = $Product->Item_Link;}
elseif ($FancyBox_Installed) {$ItemLink = "#prod-cat-addt-details-" . $Product->Item_ID; $FancyBoxClass = true;}
elseif ($Pretty_Links == "Yes") {$ItemLink = $Base . "product/" . $Product->Item_Slug . "/?" . $uri_parts[1];}
else {$ItemLink = $Base . "?" . $uri_parts[1] . "&SingleProduct=" . $Product->Item_ID;}
//Create the listing for the thumbnail layout display
if ($format == "Thumbnail") {
$ProductString .= "<div id='prod-cat-item-" . $Product->Item_ID . "' class='prod-cat-item upcp-thumb-item'>\n";
$ProductString .= "<div id='prod-cat-thumb-div-" . $Product->Item_ID . "' class='prod-cat-thumb-image-div upcp-thumb-image-div'>";
$ProductString .= "<a class='upcp-catalogue-link ";
if ($FancyBoxClass and !$NewWindow) {$ProductString .= "fancybox";}
$ProductString .= "' ";
if ($NewWindow) {$ProductString .= "target='_blank'";}
$ProductString .= " href='" . $ItemLink . "' onclick='RecordView(" . $Product->Item_ID . ");'>";
$ProductString .= $PhotoCode;
$ProductString .= "</a>";
$ProductString .= "</div>\n";
$ProductString .= "<div id='prod-cat-title-" . $Product->Item_ID . "' class='prod-cat-title upcp-thumb-title'>";
$ProductString .= "<a class='upcp-catalogue-link ";
if ($FancyBoxClass and !$NewWindow) {$ProductString .= "fancybox";}
$ProductString .= " no-underline'";
if ($NewWindow) {$ProductString .= "target='_blank'";}
$ProductString .= " href='" . $ItemLink . "' onclick='RecordView(" . $Product->Item_ID . ");'>" . $Product->Item_Name . "</a>";
$ProductString .= AddCustomFields($Product->Item_ID, "thumbs");
$ProductString .= "</div>\n";
$ProductString .= "<div id='prod-cat-price-" . $Product->Item_ID . "' class='prod-cat-price upcp-thumb-price'>" . $Product->Item_Price . "</div>\n";
$ProductString .= "<a class='upcp-catalogue-link ";
if ($FancyBoxClass and !$NewWindow) {$ProductString .= "fancybox";}
$ProductString .= "' ";
if ($NewWindow) {$ProductString .= "target='_blank'";}
$ProductString .= " href='" . $ItemLink . "' onclick='RecordView(" . $Product->Item_ID . ");'>";
$ProductString .= "<div id='prod-cat-details-link-" . $Product->Item_ID . "' class='prod-cat-details-link upcp-thumb-details-link'>" . $Details_Text . "</div>\n";
$ProductString .= "</a>";
}
//Create the listing for the list layout display
if ($format == "List") {
$ProductString .= "<div id='prod-cat-item-" . $Product->Item_ID . "' class='prod-cat-item upcp-list-item'>\n";
$ProductString .= "<div id='prod-cat-title-" . $Product->Item_ID . "' class='prod-cat-title upcp-list-title' onclick='ToggleItem(" . $Product->Item_ID . ");'>" . $Product->Item_Name . "</div>\n";
$ProductString .= "<div id='prod-cat-price-" . $Product->Item_ID . "' class='prod-cat-price upcp-list-price' onclick='ToggleItem(" . $Product->Item_ID . ");'>" . $Product->Item_Price . "</div>\n";
$ProductString .= "<div id='prod-cat-details-" . $Product->Item_ID . "' class='prod-cat-details upcp-list-details hidden-field'>\n";
$ProductString .= "<div id='prod-cat-thumb-div-" . $Product->Item_ID . "' class='prod-cat-thumb-image-div upcp-list-image-div'>";
$ProductString .= "<a class='upcp-catalogue-link ";
if ($FancyBoxClass and !$NewWindow) {$ProductString .= "fancybox";}
$ProductString .= "' ";
if ($NewWindow) {$ProductString .= "target='_blank'";}
$ProductString .= " href='" . $ItemLink . "' onclick='RecordView(" . $Product->Item_ID . ");'>";
$ProductString .= $PhotoCode;
$ProductString .= "</a>";
$ProductString .= "</div>\n";
$ProductString .= "<div id='prod-cat-desc-" . $Product->Item_ID . "' class='prod-cat-desc upcp-list-desc'>" . $Description . "</div>\n";
$ProductString .= "<a class='upcp-catalogue-link ";
if ($FancyBoxClass and !$NewWindow) {$ProductString .= "fancybox";}
$ProductString .= "' ";
if ($NewWindow) {$ProductString .= "target='_blank'";}
$ProductString .= " href='" . $ItemLink . "' onclick='RecordView(" . $Product->Item_ID . ");'>";
$ProductString .= "<div id='prod-cat-details-link-" . $Product->Item_ID . "' class='prod-cat-details-link upcp-list-details-link'>" . __("Images", 'UPCP') . "</div>\n";
$ProductString .= "</a>";
$ProductString .= "</div>";
}
//Create the listing for the detail layout display
if ($format == "Detail") {
$ProductString .= "<div id='prod-cat-item-" . $Product->Item_ID . "' class='prod-cat-item upcp-detail-item'>\n";
$ProductString .= "<div id='prod-cat-detail-div-" . $Product->Item_ID . "' class='prod-cat-detail-image-div upcp-detail-image-div'>";
$ProductString .= "<a class='upcp-catalogue-link ";
if ($FancyBoxClass and !$NewWindow) {$ProductString .= "fancybox";}
$ProductString .= "' ";
if ($NewWindow) {$ProductString .= "target='_blank'";}
$ProductString .= " href='" . $ItemLink . "' onclick='RecordView(" . $Product->Item_ID . ");'>";
$ProductString .= $PhotoCode;
$ProductString .= "</a>";
$ProductString .= "</div>\n";
$ProductString .= "<div id='prod-cat-mid-div-" . $Product->Item_ID . "' class='prod-cat-mid-detail-div upcp-mid-detail-div'>";
$ProductString .= "<div id='prod-cat-title-" . $Product->Item_ID . "' class='prod-cat-title upcp-detail-title'>" . $Product->Item_Name . "</div>\n";
if ($ReadMore == "Yes") {$ProductString .= "<div id='prod-cat-desc-" . $Product->Item_ID . "' class='prod-cat-desc upcp-detail-desc'>" . strip_tags(substr($Description, 0, $Detail_Desc_Chars));}
else {$ProductString .= "<div id='prod-cat-desc-" . $Product->Item_ID . "' class='prod-cat-desc upcp-detail-desc'>" . strip_tags($Description);}
if ($ReadMore == "Yes") {
if (strlen($Description) > $Detail_Desc_Chars) {
$ProductString .= "... <a class='upcp-catalogue-link ";
if ($FancyBoxClass and !$NewWindow) {$ProductString .= "fancybox";}
$ProductString .= "' ";
if ($NewWindow) {$ProductString .= "target='_blank'";}
$ProductString .= " href='" . $ItemLink . "' onclick='RecordView(" . $Product->Item_ID . ");'>" . __("Read More", 'UPCP') . "</a>";
}
}
$ProductString .= AddCustomFields($Product->Item_ID, "details");
$ProductString .= "</div>\n";
$ProductString .= "</div>";
$ProductString .= "<div id='prod-cat-end-div-" . $Product->Item_ID . "' class='prod-cat-end-detail-div upcp-end-detail-div'>";
$ProductString .= "<div id='prod-cat-price-" . $Product->Item_ID . "' class='prod-cat-price upcp-detail-price'>" . $Product->Item_Price . "</div>\n";
$ProductString .= "<a class='upcp-catalogue-link ";
if ($FancyBoxClass and !$NewWindow) {$ProductString .= "fancybox";}
$ProductString .= "' ";
if ($NewWindow) {$ProductString .= "target='_blank'";}
$ProductString .= " href='" . $ItemLink . "' onclick='RecordView(" . $Product->Item_ID . ");'>";
$ProductString .= "<div id='prod-cat-details-link-" . $Product->Item_ID . "' class='prod-cat-details-link upcp-detail-details-link'>" . $Details_Text . "</div>\n";
$ProductString .= "</a>";
$ProductString .= "</div>";
}
if ($FancyBox_Installed) {
$ProductString .= "<div style='display:none;' id='upcp-fb-" . $Product->Item_ID . "'>";
$ProductString .= "<div id='prod-cat-addt-details-" . $Product->Item_ID . "' class='prod-cat-addt-details'>";
$ProductString .= "<div id='prod-cat-addt-details-thumbs-div-" . $Product->Item_ID . "' class='prod-cat-addt-details-thumbs-div'>";
$ProductString .= "<img src='" . $PhotoURL . "' id='prod-cat-addt-details-thumb-P". $Product->Item_ID . "' class='prod-cat-addt-details-thumb' onclick='ZoomImage(\"" . $Product->Item_ID . "\", \"0\");'>";
foreach ($Item_Images as $Image) {$ProductString .= "<img src='" . htmlspecialchars($Image->Item_Image_URL, ENT_QUOTES) . "' id='prod-cat-addt-details-thumb-". $Image->Item_Image_ID . "' class='prod-cat-addt-details-thumb' onclick='ZoomImage(\"" . $Product->Item_ID . "\", \"" . $Image->Item_Image_ID . "\");'>";}
$ProductString .= "</div>";
$ProductString .= "<div id='prod-cat-addt-details-right-div-" . $Product->Item_ID . "' class='prod-cat-addt-details-right-div'>";
$ProductString .= "<h2 class='prod-cat-addt-details-title'><a class='no-underline' href='http://" . $_SERVER['HTTP_HOST'] . $FB_Perm_URL . "'>" . $Product->Item_Name . "<img class='upcp-product-url-icon' src='" . get_bloginfo('wpurl') . "/wp-content/plugins/ultimate-product-catalogue/images/insert_link.png' /></a></h2>";
$ProductString .= "<div id='prod-cat-addt-details-main-div-" . $Product->Item_ID . "' class='prod-cat-addt-details-main-div'>";
$ProductString .= "<a class='upcp-no-pointer' onclick='return false'>";
$ProductString .= "<img src='" . $PhotoURL . "' alt='" . $Product->Item_Name . " Image' id='prod-cat-addt-details-main-" . $Product->Item_ID . "' class='prod-cat-addt-details-main'>";
$ProductString .= "</a>";
$ProductString .= "</div>";
$ProductString .= "<div class='upcp-clear'></div>";
$ProductString .= "<div id='prod-cat-addt-details-desc-div-" . $Product->Item_ID . "' class='prod-cat-addt-details-desc-div'>";
$ProductString .= $Description;
$ProductString .= AddCustomFields($Product->Item_ID, "details");
$ProductString .= "</div>";
$ProductString .= "</div></div></div>";
//$ProductString .= "</div>";
}
// Add hidden fields with the category, sub-category and tag ID's for each product
$ProductString .= "<div id='prod-cat-category-jquery-" . $Product->Item_ID . "' class='prod-cat-category-jquery jquery-hidden'> " . $Product->Category_ID . ",</div>\n";
$ProductString .= "<div id='prod-cat-subcategory-jquery-" . $Product->Item_ID . "' class='prod-cat-subcategory-jquery jquery-hidden'> " . $Product->SubCategory_ID . ",</div>\n";
$ProductString .= "<div id='prod-cat-tag-jquery-" . $Product->Item_ID . "' class='prod-cat-tag-jquery jquery-hidden'> " . $TagsString . ",</div>\n";
$ProductString .= "<div id='prod-cat-title-jquery-" . $Product->Item_ID . "' class='prod-cat-title-jquery jquery-hidden'> " . $Product->Item_Name . ",</div>\n";
$ProductString .= "<div class='upcp-clear'></div>\n";
$ProductString .= "</div>\n";
return $ProductString;
}
function SingleProductPage() {
global $wpdb, $items_table_name, $item_images_table_name, $fields_table_name, $fields_meta_table_name, $tagged_items_table_name, $tags_table_name;
$Pretty_Links = get_option("UPCP_Pretty_Links");
$Filter_Title = get_option("UPCP_Filter_Title");
$Single_Page_Price = get_option("UPCP_Single_Page_Price");
$Custom_Product_Page = get_option("UPCP_Custom_Product_Page");
$Product_Page_Serialized = get_option("UPCP_Product_Page_Serialized");
$Mobile_Product_Page_Serialized = get_option("UPCP_Product_Page_Serialized_Mobile");
$PP_Grid_Width = get_option("UPCP_PP_Grid_Width");
$PP_Grid_Height = get_option("UPCP_PP_Grid_Height");
$Top_Bottom_Padding = get_option("UPCP_Top_Bottom_Padding");
$Left_Right_Padding = get_option("UPCP_Left_Right_Padding");
$CF_Conversion = get_option("UPCP_CF_Conversion");
$Back_To_Catalogue_Label = get_option("UPCP_Back_To_Catalogue_Label");
if ($Back_To_Catalogue_Label != "") {$Back_To_Catalogue_Text = $Back_To_Catalogue_Label;}
else {$Back_To_Catalogue_Text = __("Back to Catalogue", 'UPCP');}
if ($Pretty_Links == "Yes") {$Product = $wpdb->get_row("SELECT * FROM $items_table_name WHERE Item_Slug='" . trim(get_query_var('single_product'), "/? ") . "'");}
else {$Product = $wpdb->get_row("SELECT * FROM $items_table_name WHERE Item_ID='" . $_GET['SingleProduct'] . "'");}
$Item_Images = $wpdb->get_results("SELECT Item_Image_URL, Item_Image_ID FROM $item_images_table_name WHERE Item_ID=" . $Product->Item_ID);
$Links = get_option("UPCP_Product_Links");
if ($CF_Conversion != "No") {$Description = ConvertCustomFields($Product->Item_Description);}
else {$Description = $Product->Item_Description;}
$Description = str_replace("[upcp-price]", $Product->Item_Price, $Description);
$Description = do_shortcode($Description);
//Edit the title if that option has been selected
if ($Filter_Title == "Yes") {
add_action( 'init', 'UPCP_Filter_Title', 20, $Product->Item_Name);
}
//Create the tag string for filtering
$Tags = $wpdb->get_results("SELECT Tag_ID FROM $tagged_items_table_name WHERE Item_ID=" . $Product->Item_ID);
if (is_array($Tags)) {
foreach ($Tags as $Tag) {
$TagInfo = $wpdb->get_row("SELECT Tag_Name FROM $tags_table_name WHERE Tag_ID=" . $Tag->Tag_ID);
$TagsString .= $TagInfo->Tag_Name . ", ";
}
}
$TagsString = trim($TagsString, " ,");
if ($Product->Item_Photo_URL != "" and strlen($Product->Item_Photo_URL) > 7 and substr($Product->Item_Photo_URL, 0, 7) != "http://") {
$PhotoCode = $Product->Item_Photo_URL;
$PhotoCode = do_shortcode($PhotoCode);
}
elseif ($Product->Item_Photo_URL != "" and strlen($Product->Item_Photo_URL) > 7) {
$PhotoURL = htmlspecialchars($Product->Item_Photo_URL, ENT_QUOTES);
$PhotoCode .= "<img src='" . $PhotoURL . "' alt='" . $Product->Item_Name . " Image' id='prod-cat-addt-details-main-" . $Product->Item_ID . "' class='prod-cat-addt-details-main'>";
$PhotoCodeMobile .= "<img src='" . $PhotoURL . "' alt='" . $Product->Item_Name . " Image' id='prod-cat-addt-details-main-mobile-" . $Product->Item_ID . "' class='prod-cat-addt-details-main'>";
}
else {
$PhotoURL = plugins_url('ultimate-product-catalogue/images/No-Photo-Available.jpg');
$PhotoCode .= "<img src='" . $PhotoURL . "' alt='" . $Product->Item_Name . " Image' id='prod-cat-addt-details-main-" . $Product->Item_ID . "' class='prod-cat-addt-details-main'>";
$PhotoCodeMobile .= "<img src='" . $PhotoURL . "' alt='" . $Product->Item_Name . " Image' id='prod-cat-addt-details-main-mobile-" . $Product->Item_ID . "' class='prod-cat-addt-details-main'>";
}
$uri_parts = explode('?', $_SERVER['REQUEST_URI'], 2);
$SP_Perm_URL = $uri_parts[0] . "?" . $uri_parts[1];
$Return_URL = $uri_parts[0];
if ($Pretty_Links == "Yes") {$Return_URL = substr($uri_parts[0], 0, strrpos($uri_parts[0], "/", -2)-8) . "/?" . $uri_parts[1];}
elseif ($uri_parts[0] == "/") {$Return_URL .= "?" . substr($uri_parts[1], 0, strpos($uri_parts[1], "&"));}
if ($uri_parts[1] == "") {$SP_Perm_URL .= "Product_ID=" . $Product->Item_ID;}
else {$SP_Perm_URL .= "&Product_ID=" . $Product->Item_ID;}
if ($Custom_Product_Page == "No") {
$ProductString .= "<div class='upcp-standard-product-page'>";
$ProductString .= "<div class='prod-cat-back-link'>";
$ProductString .= "<a class='upcp-catalogue-link' href='" . $Return_URL . "'>« " . $Back_To_Catalogue_Text . "</a>";
$ProductString .= "</div>";
$ProductString .= "<div id='prod-cat-addt-details-" . $Product->Item_ID . "' class='prod-cat-addt-details'>";
$ProductString .= "<div id='prod-cat-addt-details-thumbs-div-" . $Product->Item_ID . "' class='prod-cat-addt-details-thumbs-div'>";
if (isset($PhotoURL)) {$ProductString .= "<img src='" . $PhotoURL . "' id='prod-cat-addt-details-thumb-P". $Product->Item_ID . "' class='prod-cat-addt-details-thumb' onclick='ZoomImage(\"" . $Product->Item_ID . "\", \"0\");'>";}
foreach ($Item_Images as $Image) {$ProductString .= "<img src='" . htmlspecialchars($Image->Item_Image_URL, ENT_QUOTES) . "' id='prod-cat-addt-details-thumb-". $Image->Item_Image_ID . "' class='prod-cat-addt-details-thumb' onclick='ZoomImage(\"" . $Product->Item_ID . "\", \"" . $Image->Item_Image_ID . "\");'>";}
$ProductString .= "</div>";
$ProductString .= "<div id='prod-cat-addt-details-right-div-" . $Product->Item_ID . "' class='prod-cat-addt-details-right-div'>";
$ProductString .= "<h2 class='prod-cat-addt-details-title'><a class='no-underline' href='http://" . $_SERVER['HTTP_HOST'] . $SP_Perm_URL . "'>" . $Product->Item_Name . "<img class='upcp-product-url-icon' src='" . get_bloginfo('wpurl') . "/wp-content/plugins/ultimate-product-catalogue/images/insert_link.png' /></a></h2>";
if ($Single_Page_Price == "Yes") {$ProductString .= "<h3 class='prod-cat-addt-details-price'>" . $Product->Item_Price . "</h3>";}
$ProductString .= "<div id='prod-cat-addt-details-main-div-" . $Product->Item_ID . "' class='prod-cat-addt-details-main-div'>";
$ProductString .= $PhotoCode;
$ProductString .= "</div>";
$ProductString .= "<div class='upcp-clear'></div>";
$ProductString .= "<div id='prod-cat-addt-details-desc-div-" . $Product->Item_ID . "' class='prod-cat-addt-details-desc-div'>";
$ProductString .= $Description . "</div>";
$ProductString .= "<div class='upcp-clear'></div>\n";
$ProductString .= "</div>\n";
$ProductString .= "</div>\n";
$ProductString .= "</div>\n";
$ProductString .= "<div class='upcp-standard-product-page-mobile'>";
$ProductString .= "<div class='prod-cat-back-link'>";
$ProductString .= "<a class='upcp-catalogue-link' href='" . $Return_URL . "'>« " . $Back_To_Catalogue_Text . "</a>";
$ProductString .= "</div>";
$ProductString .= "<h2 class='prod-cat-addt-details-title'><a class='no-underline' href='http://" . $_SERVER['HTTP_HOST'] . $SP_Perm_URL . "'>" . $Product->Item_Name . "<img class='upcp-product-url-icon' src='" . get_bloginfo('wpurl') . "/wp-content/plugins/ultimate-product-catalogue/images/insert_link.png' /></a></h2>";
if ($Single_Page_Price == "Yes") {$ProductString .= "<h3 class='prod-cat-addt-details-price'>" . $Product->Item_Price . "</h3>";}
$ProductString .= $PhotoCodeMobile;
$ProductString .= "<div class='upcp-clear'></div>";
$ProductString .= "<div id='prod-cat-addt-details-" . $Product->Item_ID . "' class='prod-cat-addt-details'>";
$ProductString .= "<div id='prod-cat-addt-details-thumbs-div-" . $Product->Item_ID . "' class='prod-cat-addt-details-thumbs-div'>";
if (isset($PhotoURL)) {$ProductString .= "<img src='" . $PhotoURL . "' id='prod-cat-addt-details-thumb-P". $Product->Item_ID . "' class='prod-cat-addt-details-thumb' onclick='ZoomImage(\"" . $Product->Item_ID . "\", \"0\");'>";}
foreach ($Item_Images as $Image) {$ProductString .= "<img src='" . htmlspecialchars($Image->Item_Image_URL, ENT_QUOTES) . "' id='prod-cat-addt-details-thumb-". $Image->Item_Image_ID . "' class='prod-cat-addt-details-thumb' onclick='ZoomImage(\"" . $Product->Item_ID . "\", \"" . $Image->Item_Image_ID . "\");'>";}
$ProductString .= "<div class='upcp-clear'></div>";
$ProductString .= "</div>";
$ProductString .= "<div id='prod-cat-addt-details-desc-div-" . $Product->Item_ID . "' class='prod-cat-addt-details-desc-div'>";
$ProductString .= $Description . "</div>";
$ProductString .= "<div class='upcp-clear'></div>\n";
$ProductString .= "</div>\n";
$ProductString .= "</div>\n";
}
else {
if ($Custom_Product_Page == "Large" or $Mobile_Product_Page_Serialized != "") {$ProductString .= "<div class='upcp-custom-large-product-page'>";}
echo "<script language='JavaScript' type='text/javascript'>";
echo "var pp_grid_width = " . $PP_Grid_Width . ";";
echo "var pp_grid_height = " . $PP_Grid_Height . ";";
echo "var pp_top_bottom_padding = " . $Top_Bottom_Padding . ";";
echo "var pp_left_right_padding = " . $Left_Right_Padding . ";";
echo "</script>";
$Gridster = json_decode(stripslashes($Product_Page_Serialized));
$ProductString .= "<div class='gridster'>";
$ProductString .= "<ul>";
$ProductString .= BuildGridster($Gridster, $Product, $Item_Images, $Description, $PhotoURL, $SP_Perm_URL, $Return_URL, $TagsString);
$ProductString .= "</ul>";
$ProductString .= "</div>";
if ($Custom_Product_Page == "Large") {
$ProductString .= "</div>";
$ProductString .= "<div class='upcp-standard-product-page-mobile'>";
$ProductString .= "<div class='prod-cat-back-link'>";
$ProductString .= "<a class='upcp-catalogue-link' href='" . $Return_URL . "'>« " . $Back_To_Catalogue_Text . "</a>";
$ProductString .= "</div>";
$ProductString .= "<h2 class='prod-cat-addt-details-title'><a class='no-underline' href='http://" . $_SERVER['HTTP_HOST'] . $SP_Perm_URL . "'>" . $Product->Item_Name . "<img class='upcp-product-url-icon' src='" . get_bloginfo('wpurl') . "/wp-content/plugins/ultimate-product-catalogue/images/insert_link.png' /></a></h2>";
if ($Single_Page_Price == "Yes") {$ProductString .= "<h3 class='prod-cat-addt-details-price'>" . $Product->Item_Price . "</h3>";}
$ProductString .= $PhotoCodeMobile;
$ProductString .= "<div class='upcp-clear'></div>";
$ProductString .= "<div id='prod-cat-addt-details-" . $Product->Item_ID . "' class='prod-cat-addt-details'>";
$ProductString .= "<div id='prod-cat-addt-details-thumbs-div-" . $Product->Item_ID . "' class='prod-cat-addt-details-thumbs-div'>";
if (isset($PhotoURL)) {$ProductString .= "<img src='" . $PhotoURL . "' id='prod-cat-addt-details-thumb-P1-". $Product->Item_ID . "' class='prod-cat-addt-details-thumb' onclick='ZoomImage(\"" . $Product->Item_ID . "\", \"0\");'>";}
foreach ($Item_Images as $Image) {$ProductString .= "<img src='" . htmlspecialchars($Image->Item_Image_URL, ENT_QUOTES) . "' id='prod-cat-addt-details-thumb-". $Image->Item_Image_ID . "' class='prod-cat-addt-details-thumb' onclick='ZoomImage(\"" . $Product->Item_ID . "\", \"" . $Image->Item_Image_ID . "\");'>";}
$ProductString .= "<div class='upcp-clear'></div>";
$ProductString .= "</div>";
$ProductString .= "<div id='prod-cat-addt-details-desc-div-" . $Product->Item_ID . "' class='prod-cat-addt-details-desc-div'>";
$ProductString .= $Description . "</div>";
$ProductString .= "<div class='upcp-clear'></div>\n";
$ProductString .= "</div>\n";
$ProductString .= "</div>\n";
}
elseif ($Mobile_Product_Page_Serialized != "") {
$ProductString .= "</div>";
$ProductString .= "<div class='upcp-standard-product-page-mobile'>";
$Gridster = json_decode(stripslashes($Mobile_Product_Page_Serialized));
$ProductString .= "<div class='gridster-mobile'>";
$ProductString .= "<ul>";
$ProductString .= BuildGridster($Gridster, $Product, $Item_Images, $Description, $PhotoURL, $SP_Perm_URL, $Return_URL, $TagsString);
$ProductString .= "</ul>";
$ProductString .= "</div>";
$ProductString .= "</div>\n";
}
}
return $ProductString;
}
function BuildSidebar($category, $subcategory, $tags, $prod_name) {
global $wpdb, $Full_Version, $ProdCats, $ProdSubCats, $ProdTags, $ProdCatString, $ProdSubCatString, $ProdTagString;
global $categories_table_name, $subcategories_table_name, $tags_table_name;
$Color = get_option("UPCP_Color_Scheme");
$Tag_Logic = get_option("UPCP_Tag_Logic");
$ProductSearch = get_option("UPCP_Product_Search");
$Product_Sort = get_option("UPCP_Product_Sort");
$Sidebar_Order = get_option("UPCP_Sidebar_Order");
$Categories_Label = get_option("UPCP_Categories_Label");
$SubCategories_Label = get_option("UPCP_SubCategories_Label");
$Tags_Label = get_option("UPCP_Tags_Label");
$Sort_By_Label = get_option("UPCP_Sort_By_Label");
$Product_Name_Search_Label = get_option("UPCP_Product_Name_Search_Label");
$Product_Search_Text_Label = get_option("UPCP_Product_Name_Text_Label");
if ($Categories_Label != "") {$Categories_Text = $Categories_Label;}
else {$Categories_Text = __("Categories:", 'UPCP');}
if ($SubCategories_Label != "") {$SubCategories_Text = $SubCategories_Label;}
else {$SubCategories_Text = __("Sub-Categories:", 'UPCP');}
if ($Tags_Label != "") {$Tags_Text = $Tags_Label;}
else {$Tags_Text = __("Tags:", 'UPCP');}
if ($Sort_By_Label != "") {$Sort_Text = $Sort_By_Label;}
else {$Sort_Text = __('Sort By:', 'UPCP');}
if ($Product_Name_Search_Label != "") {$SearchLabel = $Product_Name_Search_Label;}
else {
if ($ProductSearch == "namedesc" or $ProductSearch == "namedesccust") {$SearchLabel = __("Product Search:", 'UPCP');}
else {$SearchLabel = __("Product Name:", 'UPCP');}
}
if ($prod_name != "") {$Product_Name_Text = $prod_name;}
elseif ($Product_Search_Text_Label != "") {$Product_Name_Text = $Product_Search_Text_Label;
}
else {
if ($ProductSearch == "namedesc" or $ProductSearch == "namedesccust") {$Product_Name_Text = __("Search...", 'UPCP');}
else {$Product_Name_Text = __("Name...", 'UPCP');}
}
// Get the categories, sub-categories and tags that apply to the products in the catalog
if ($ProdCatString != "") {$Categories = $wpdb->get_results("SELECT Category_ID, Category_Name FROM $categories_table_name WHERE Category_ID in (" . $ProdCatString . ") ORDER BY Category_Name");}
if ($ProdSubCatString != "") {$SubCategories = $wpdb->get_results("SELECT SubCategory_ID, SubCategory_Name, Category_ID FROM $subcategories_table_name WHERE SubCategory_ID in (" . $ProdSubCatString . ") ORDER BY SubCategory_Name");}
if ($ProdTagString != "") {$Tags = $wpdb->get_results("SELECT Tag_ID, Tag_Name FROM $tags_table_name WHERE Tag_ID in (" . $ProdTagString . ") ORDER BY Tag_Date_Created");}
else {$Tags = array();}
// My code
$SidebarString .= "<table><tbody>";
$SidebarString .= "<form onsubmit='return false;' name='Product_Catalog_Sidebar_Form'>\n";
$SidebarString .= "<tr><td>" . $SearchLabel . "</td></tr>";
$SidebarString .= "<tr><td>";
if ($Filter == "Javascript" and $Tag_Logic == "OR") {
$SidebarString .= "<input type='text' id='upcp-name-search' class='jquery-prod-name-text' name='Text_Search' value='" . $Product_Name_Text . "' onfocus='FieldFocus(this);' onblur='FieldBlur(this);' onkeyup='UPCP_Filer_Results_OR();'>\n";
}
elseif ($Filter == "Javascript") {
$SidebarString .= "<input type='text' id='upcp-name-search' class='jquery-prod-name-text' name='Text_Search' value='" . $Product_Name_Text . "' onfocus='FieldFocus(this);' onblur='FieldBlur(this);' onkeyup='UPCP_Filer_Results();'>\n";
}
else {
$SidebarString .= "<input type='text' id='upcp-name-search' class='jquery-prod-name-text' name='Text_Search' value='" . $Product_Name_Text . "' onfocus='FieldFocus(this);' onblur='FieldBlur(this);' onkeyup='UPCP_DisplayPage(\"1\");'>\n";
}
$SidebarString .= "</td></tr>";
if (sizeof($Categories) > 0) {
foreach ($Categories as $key => $row) {
$ID[$key] = $row->Category_ID;
$Name[$key] = $row->Category_Name;
}
array_multisort($Name, SORT_ASC, $ID, SORT_DESC, $Categories);
unset($ID);
unset($Name);
$SidebarString .= "<tr><td>" . $Categories_Text . "</td></tr>\n";
foreach ($Categories as $Category) {
$SidebarString .= "<tr><td ";
if (in_array($Category->Category_ID, $category)) {$SidebarString .= " highlightBlue";}
$SidebarString .= "'>\n";
if ($Filter == "Javascript" and $Tag_Logic == "OR") {
$SidebarString .= "<input type='checkbox' class='jquery-prod-cat-value' name='Category" . $Category->Category_ID . "' value='" . $Category->Category_ID . "' onclick='UPCP_Filer_Results_OR(); UPCPHighlight(this, \"" . $Color . "\");'>" . $Category->Category_Name . " (" . $ProdCats[$Category->Category_ID] . ")\n";
}
elseif ($Filter == "Javascript") {
$SidebarString .= "<input type='checkbox' class='jquery-prod-cat-value' name='Category" . $Category->Category_ID . "' value='" . $Category->Category_ID . "' onclick='UPCP_Filer_Results(); UPCPHighlight(this, \"" . $Color . "\");'>" . $Category->Category_Name . " (" . $ProdCats[$Category->Category_ID] . ")\n";
}
else {
$SidebarString .= "<input type='checkbox' name='Category" . $Category->Category_ID . "' value='" . $Category->Category_ID . "' onclick='UPCP_DisplayPage(\"1\"); UPCPHighlight(this, \"" . $Color . "\");' class='jquery-prod-cat-value'";
if (in_array($Category->Category_ID, $category)) {
$SidebarString .= "checked=checked";
}
$SidebarString .= "> " . $Category->Category_Name . " (" . $ProdCats[$Category->Category_ID] . ")\n";
}
$SidebarString .= "</td></tr>";
if ($Sidebar_Order == "Hierarchical") {
foreach ($SubCategories as $SubCategory) {
if ($SubCategory->Category_ID == $Category->Category_ID) {
$SidebarString .= "<tr><td ";
if (in_array($SubCategory->SubCategory_ID, $subcategory)) {
$SidebarString .= " highlightBlue";
}
$SidebarString .= "'>\n";
if ($Filter == "Javascript" and $Tag_Logic == "OR") {
$SidebarString .= "<input type='checkbox' class='jquery-prod-sub-cat-value' name='SubCategory[]' value='" . $SubCategory->SubCategory_ID . "' onclick='UPCP_Filer_Results_OR(); UPCPHighlight(this, \"" . $Color . "\");'> " . $SubCategory->SubCategory_Name . " (" . $ProdSubCats[$SubCategory->SubCategory_ID] . ")\n";
}
elseif ($Filter == "Javascript") {
$SidebarString .= "<input type='checkbox' class='jquery-prod-sub-cat-value' name='SubCategory[]' value='" . $SubCategory->SubCategory_ID . "' onclick='UPCP_Filer_Results(); UPCPHighlight(this, \"" . $Color . "\");'> " . $SubCategory->SubCategory_Name . " (" . $ProdSubCats[$SubCategory->SubCategory_ID] . ")\n";
}
else {
$SidebarString .= "<input type='checkbox' name='SubCategory[]' value='" . $SubCategory->SubCategory_ID . "' onclick='UPCP_DisplayPage(\"1\"); UPCPHighlight(this, \"" . $Color . "\");' class='jquery-prod-sub-cat-value'";
if (in_array($SubCategory->SubCategory_ID, $subcategory)) {$SidebarString .= "checked=checked";}
$SidebarString .= "> " . $SubCategory->SubCategory_Name . " (" . $ProdSubCats[$SubCategory->SubCategory_ID] . ")\n";
}
$SidebarString .= "</td></tr>";
}
}
}
}
}
if (sizeof($Tags) > 0) {
foreach ($Tags as $key => $row) {
$ID[$key] = $row->Tag_ID;
$Name[$key] = $row->Tag_Name;
}
array_multisort($Name, SORT_ASC, $ID, SORT_DESC, $Tags);
unset($ID);
unset($Name);
$SidebarString .= "<tr><td>" . $Tags_Text . "</td></tr>";
foreach ($Tags as $Tag) {
$SidebarString .= "<tr><td ";
if (in_array($Tag->Tag_ID, $tags)) {
$SidebarString .= " highlightBlue";
}
$SidebarString .= "'>";
if ($Filter == "Javascript" and $Tag_Logic == "OR") {
$SidebarString .= "<input type='checkbox' class='jquery-prod-tag-value' name='Tag[]' value='" . $Tag->Tag_ID . "' onclick='UPCP_Filer_Results_OR(); UPCPHighlight(this, \"" . $Color . "\");'>" . $Tag->Tag_Name . "\n";
}
elseif ($Filter == "Javascript") {
$SidebarString .= "<input type='checkbox' class='jquery-prod-tag-value' name='Tag[]' value='" . $Tag->Tag_ID . "' onclick='UPCP_Filer_Results(); UPCPHighlight(this, \"" . $Color . "\");'> " . $Tag->Tag_Name . "\n";
}
else {
$SidebarString .= "<input type='checkbox' name='Tag[]' value='" . $Tag->Tag_ID . "' onclick='UPCP_DisplayPage(\"1\"); UPCPHighlight(this, \"" . $Color . "\");' class='jquery-prod-tag-value'";
if (in_array($Tag->Tag_ID, $tags)) {
$SidebarString .= "checked=checked";
}
$SidebarString .= ">" . $Tag->Tag_Name . "\n";
}
$SidebarString .= "</td></tr>";
}
}
$SidebarString .= "</form></tbody></table>\n";
return $SidebarString;
}
/*$SidebarString .= "<div id='prod-cat-sidebar-" . $id . "' class='prod-cat-sidebar'>\n";
//$SidebarString .= "<form action='#' name='Product_Catalog_Sidebar_Form'>\n";
$SidebarString .= "<form onsubmit='return false;' name='Product_Catalog_Sidebar_Form'>\n";
//Create the 'Sort By' select box
if ($Full_Version == "Yes" and $Product_Sort != "None") {
$SidebarString .= "<div id='prod-cat-sort-by' class='prod-cat-sort-by'>";
$SidebarString .= $Sort_Text . "<br>";
$SidebarString .= "<div class='styled-select styled-input'>";
$SidebarString .= "<select name='upcp-sort-by' id='upcp-sort-by' onchange='UPCP_Sort_By();'>";
$SidebarString .= "<option value=''></option>";
if ($Product_Sort == "Price" or $Product_Sort == "Price_Name") {
$SidebarString .= "<option value='price_asc'>" . __('Price (Ascending)', 'UPCP') . "</option>";
$SidebarString .= "<option value='price_desc'>" . __('Price (Descending)', 'UPCP') . "</option>";
}
if ($Product_Sort == "Name" or $Product_Sort == "Price_Name") {
$SidebarString .= "<optioMy query gets the results and orders by one of the fields. Once I get the MySQL results I would like to find the first entry that has a letter as the first character of the same field that the list was ordered by, then split the results in to two parts and swap them. So that the results that have a letter at the start of the same sorted field are as the begining and the results that have the numbers as the start at the end of the array. But also so that the array works the same way as the original results string, so i can use say $results['mysqlfield'] Code: [Select] <? $out = preg_replace('/^(.{701}[^.]*).*/i','$1.',$detrsltnewsrow[news_desc]); echo $out; ?> </td></tr><tr><td colspan="2" class="para" style="padding-left:10px;"> <?= substr(stripslashes(trim($detrsltnewsrow[news_desc])),701) ?> </td></tr> I have the above snippet.. The first php statement, basically grasp the first 701 characters with the closet next stop "." character and out puts it. then out puts the HTML tags I have a problem with the second statement. I want to output anything after what has been outputted by: Code: [Select] <? $out = preg_replace('/^(.{701}[^.]*).*/i','$1.',$detrsltnewsrow[news_desc]); echo $out; ?> So need the correct syntax for Code: [Select] <?= substr(stripslashes(trim($detrsltnewsrow[news_desc])),701) ?> Currently it breaks at exactly the 701 character, want it to continue from the sentence the first code ended in. I have a form that users input user name, password, and email... all writes to csv fine. My problem is I need to concatenate a a string with a variable and some html code will preserving the html when written to the csv.. I need the csv to be this username,password,email,user,category,text with http://sub.domain..com/splash/,something,something here's what i have Code: [Select] <?php if($_POST['formSubmit'] == "Submit") $varUserName = $_POST['username']; $varPW = $_POST['PW']; $varEmail = $_POST['email']; { $fs = fopen("testcsv.csv","a"); fputcsv($fs, array($varUserName,$varPW,$varEmail,"user","title",",category","some text '<a href="http://$varUserName.url.com/splash/>site.com</a>',)); fclose($fs); exit; } ?> and of course I'm getting Parse error: syntax error, unexpected T_STRING, expecting ')' on line 9 I am having problems making it so that if I typed site.php?url=http://example.com it would auto get rid of the http://. Here's my code. $url="{$_GET['url']}"; str_replace('http://', '', $url); echo "<a href=\"http://$url\">$url</a>"; I opened a thread yesterday about an XSS vulnerability when the user is logged in. I'll summarize is in a short quote: Quote http://host/editText.php?fieldname=slogan&content=slogan<img src=x onerror=alert("XSS")> This vulnerability only works if the user is logged in. I want to secure it anyway to give the security companies contacting me about this a break. xyph solved my problem with this: Code: [Select] foreach( $_REQUEST as $key => $val ) $_REQUEST[$key] = htmlentities($val); He warned me it was a risky but I didn't take him that seriously. Well guess he was right. The foreach loop he gave me does protect me from the XSS attack, but it also disables the users to use any kind of code in the pages. Next time xyph warns me its risky, I'll know he means it. Now to my problem, how do I use this foreach loop without disabling the user of using simple html tags? Here's the file (editText.php) where the foreach loop was used: Code: [Select] <?php session_start(); // THE LOOP WAS USED HERE BUT I REMOVED IT DUE TO THE USERS PROBLEM. function getSlug( $page ) { $page = strip_tags( $page ); preg_match_all( "/([a-z0-9A-Z-_]+)/", $page, $matches ); $matches = array_map( "ucfirst", $matches[0] ); $slug = implode( "-", $matches ); return $slug; } $fieldname = $_REQUEST['fieldname']; $encrypt_pass = @file_get_contents("files/password"); if ($_COOKIE['wondercms']!=$encrypt_pass) { echo "You must login before using this function!"; exit; } $content = rtrim(stripslashes($_REQUEST['content'])); // if to only allow specified tags if($fieldname=="title") $content = strip_tags($content); else $content = strip_tags($content,"<audio><source><embed><iframe><p><h1><h2><h3><h4><h5><h6><a><img><u><i><em><strong><b><strike><center><pre>"); $content = trim($content); $content = nl2br($content); if(!$content) $content = "Please be sure to enter some content before saving. Just type anything in here."; $content = preg_replace ("/%u(....)/e", "conv('\\1')", $content); if($fieldname>0 && $fieldname<4) $fname = "attachment$fieldname"; else $fname = $fieldname; $file = @fopen("files/$fname.txt", "w"); if(!$file) { echo "<h2 style='color:red'>*** ERROR *** unable to open content_$fieldname</h2><h3>But don't panic!</h3>". "Please set the correct read/write permissions to the files folder.<br/> Find the /files/ folder and CHMOD it to 751.<br /><br /> If this still gives you problems, open up the /files/ folder, select all files and CHMOD them to 640.<br /><br /> If this doesn't work, contact me <a href='http://krneky.com/en/contact'>right here</a>."; exit; } fwrite($file, $content); fclose($file); echo $content; // convert udf-8 hexadecimal to decimal function conv($hex) { $dec = hexdec($hex); return "&#$dec;"; } ?> Hi all, I have the following : Code: [Select] print_r($fqlResult); Which gives the following result : Code: [Select] Array ( [0] => Array ( [src_big] => http://a5.sphotos.ak.fbcdn.net/hphotos-ak-ash4/299117_2121699756933_1079004376_2442101_3103384_n.jpg ) ) I want to grab just the image url from it and store it in a seperate variable. Any ideas how I can do this plzzz ? Thanks in advance, Scott. I'm using PHP to get a list of names from a mysql database, which then produces a drop down list for the user to select an option and then progress to the next page where the selection is displayed with other stuff. My problem is that my drop down list works fine, but when the user goes to the next page only the first part of the string is displayed, ie if the string is Fred Bloggs, only Fred is shown. I can get it to work by adding ' ' around the string name in the option section, but this shows 'Fred Bloggs' in the drop down list which isn't very pretty. I haven't got the actual code to hand at the moment, but any ideas on where I'm going wrong? Cheers I am trying to build a news feed which shows the first 100 characters of news copy. I have it working to paste in the full text but am not sure how to insert only the first 100 characters. Code: [Select] <?php while($news_row=mysql_fetch_array($news)) { echo " <div class=\"news_box\"> <h3><a href=\"html/news.html\" rel=\"shadowbox; width=800; height=400;\">".$news_row['news_title']."</a> </h3> ".$news_row['news_copy']." </div>"; } ?>
Hello, I am new to the php community Hello.
How would I print the following:
http://site.com/break?return=site2.com
So that I can set a button containing site2.com.
Example: <a href="site2.com"></a>
And so forth:
http://site.com/break?return=site3.com
Would print: <a href="site3.com"></a>
Hi People. Thanks to everyone that helped me yesterday with my file that finally connected to the database. However, I have added a new field to my DB and now get further problems. Here is the error message I am getting after I added the "ppr" stuff to both files. Please could someone look at my code and tell me where I'm going wrong. Code: [Select] <!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"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Untitled Document</title> </head> <body> <?php include "config01.php"?> <form name = 'form1' method = 'post' action='config01.php'> <table width="700" border="1" cellspacing="5" cellpadding="5"> <caption> Submit Your Airfield Details </caption> <tr> <td width="100"> </td> <td width="200">Your Name</td> <td width="200"><input type='text' name='username' maxlength='30'></td> <td width="100"> </td> </tr> <tr> <td> </td> <td>Height Above MSL</td> <td><input type='text' name='height_above'maxlength= '30'></td> <td> </td> </tr> <tr> <td> </td> <td>Mb Difference</td> <td><input type='text' name='mb_diff'maxlength='40'></td> <td> </td> </tr> <tr> <td> </td> <td>Alternative Airfield</td> <td><input type='text' name='alternative' maxlength='30'></td> <td> </td> </tr> <tr> <td> </td> <td>PPR</td> <td><input type='radio' name='ppr' value="Y"/> Yes <input type='radio' name='ppr' value="N" /> No</td> <td> </td> </tr> <tr> <td><input type='submit' name='submit' value='post' /></td> <td> </td> <td> </td> <td> </td> </tr> </table> </form> </body> </html> Then the code from config01.php Code: [Select] <?php $host = 'localhost'; $usr = "VinnyG"; $password = 'thepassword'; $db_name = 'sitename'; $username = $_POST["username"]; $height_above = $_POST["height_above"]; $mb_diff = $_POST["mb_diff"]; $alternative = $_POST["alternative"]; $ppr = $_POST["ppr"]; //connect to database mysql_connect ("$host","$usr","$password") or die ('Error During Connect:<br>'.mysql_error()); mysql_select_db ("$db_name") or die ('Error Selecting DB:<br>'.mysql_error()); /* $sql01 = "INSERT INTO users SET username = '$username',height_above = '$height_above', mb_diff = $mb_diff, alternative = $alternative"; $result=mysql_query($sql01); */ //mysql_query("INSERT INTO users VALUES ('$username','$height_above','$mb_diff','$alternative')"); //mysql_query("INSERT INTO users (username, height_above, mb_diff, alternative) VALUES ('$username', '$height_above', '$mb_diff', '$alternative'"); //$insert_query = "INSERT INTO users (username, height_above, mb_diff, alternative) VALUES ('$username', '$height_above', '$mb_diff', '$alternative')"; //$insert_action = mysql_query($insert_query) or die ('Error Dring Insert :<br>'.mysql_error().'<br><br>Error occured running the following code :<br>'.$insert_query); //mysql_query("INSERT INTO users VALUES ('$username','$height_above','$mb_diff','$alternative')"); CHANGES FOLLOW THIS LINE . . $query = "INSERT INTO users (username, height_above, mb_diff, alternative, ppr) VALUES ('$username', '$height_above', '$mb_diff', '$alternative', '$ppr'"; if( !$result = mysql_query($query) ) { echo "<br>Query: $query<br>Produced error: " . mysql_error() .'<br>'; } else { echo "Query ran and inserted " . mysql_affected_rows() . "row(s)."; } ?> I only added the one thing and I've gone and broken it already. It was working last night too.. :-( Hi, I have spend a few day's trying to get my head around how to make this code work as I'm still quite new to PHP The code below so far matches all text from a webpage within the <h3></h3> tags as within them is a url I need. Then that URL within all those h3 tags I only need the text after the last slash of the link so I can put into a flash object and load the requested value. As shown below heres what I have: <html> <head> <title>Find SC Links</title> </head> <body> <?php /* Have a look at the url below within the tags I only need the last part of the url after the / from all the text string <h3><a href="/anyfolder/recording-1-week">link1</a></h3> so just need recording-1-week <h3><a href="/anyfolder/recording-2-week">link2</a></h3> so just need recording-2-week <h3><a href="/anyfolder/recording-3-week">link3</a></h3> so just need recording-3-week then echo them out within this below echo '<div class="bbvideo"><object height="81" width="550"><param name="movie" value="'.$text_string_after_last_slash.'"></param><param name="allowscriptaccess" value="always"></param><embed allowscriptaccess="always" height="81" src="http://player.soundcloud.com/player.swf?url='.$text_string_after_last_slash.'" type="application/x-shockwave-flash" width="550"></embed></object></div><p>'; */ $data = file_get_contents('http://soundcloud.com/dj-handsfree/'); preg_match_all ("/<h3>([^`]*?)<\/h3>/", $data, $matches); $content = $matches[1]; //echo $content; $total = count($content); for($i=0; $i<$total; $i++) { echo $content[$i]."<br />"; } ?> </body> </html> Any help on pointing me in the right direction on this one be much help spend to much of my little time on this one.. Hello guys, I want to remove part of a string and convert it to a var instead of echoing it out.. How would I do it.. $string = "temp_photo/testing.jpg"; I want to remove temp_photo so the out put should be $filename2 = testing.jpg Please advise.. Thanks, Dan So, I am making a system that shows if there are new posts or not. How I have it done is a singular array called "Read" will have all of the IDs of the read posts. It is entered in the database like so: $ID2= $_SESSION['UserID']; $ID2 = mysql_real_escape_string($ID2); $Readornot=mysql_query("SELECT * FROM forum_read WHERE Reader_ID='$ID2'"); $Readornot2=mysql_fetch_array($Readornot); if($ID2==0) { } else { if(empty($Readornot2)) { $Read1= array("Read" => $Get_TopicID); $Read2 = implode('-',$Read1); mysql_query("INSERT INTO forum_read (Reader_ID,`Read`) values ('$ID2','$Read2')") or die(mysql_error()); } else { $cr_topicid=$Readornot2['Read']; if(strpos($cr_topicid,'-')) { $cr_topicid=explode('-',$cr_topicid); if(!in_array($Get_TopicID,$cr_topicid,true)) { $Read0=implode('-',$cr_topicid); $Read1= array("Read" => $Read0, $Get_TopicID); $Read2= implode('-',$Read1); mysql_query("UPDATE forum_read SET`Read`='$Read2' WHERE Reader_ID='$ID2'") or die(mysql_error()); } } else { if($cr_topicid==$Get_TopicID) { } else { $Read1= array("Read" => $cr_topicid, $Get_TopicID); $Read2= implode('-',$Read1); mysql_query("UPDATE forum_read SET`Read`='$Read2' WHERE Reader_ID='$ID2'") or die(mysql_error()); } } } } It all works fine and dandy to the point where if it's in the database an icon will be black and white, and if its not it wont, signifying read or unread. What I need to do, however, is make it so when there is a new post, it takes all of the entries in the database with the topic ID out of the database, and strips the one part. What I thought of at first was to use str_replace to replace "-" . $TopicID . "-" with "-" But of course, that won't work, because the very first entry could be the topic ID, so it would just be $TopicID- and not -$TopicID- in the database. So, how would I go about doing this? Hi I have a script below which I have put together from a couple of other scripts which simply adds an email address to a database for a newsletter and sends an email to the owner and to the user it then shows a success page. The script checks that the email is valid and there is also a captcha. The script works in that it only send out the emails if the captcha etc is entered correctly but the email is being added to the database regardless of whether the capture is correct or not. I was proud of myself for getting this far but would love some instruction on what I have missed and how to stop the email adding to the database unless it has passed the captcha. Below you will see the script. The commented out sections are parts of the old script I don't use. <?php require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_TESTING); $error = false; if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'send')) { //$name = tep_db_prepare_input($HTTP_POST_VARS['name']); $email_address = tep_db_prepare_input($HTTP_POST_VARS['email']); //$enquiry = tep_db_prepare_input($HTTP_POST_VARS['enquiry']); if (tep_validate_email($email_address) == false) { $error = true; $messageStack->add('testing', ENTRY_EMAIL_ADDRESS_CHECK_ERROR); } //CAPTHCA CODE start require(DIR_WS_FUNCTIONS . 'capcha_code.php'); $code_query = tep_db_query("select code from capcha_code where oscsid = '" . tep_session_id($HTTP_GET_VARS[tep_session_name()]) . "'"); $code_array = tep_db_fetch_array($code_query); $code = $code_array['code']; tep_db_query("DELETE FROM " . TABLE_CAPCTHA_CODE . " WHERE oscsid='" . $vvcode_oscsid . "'"); //remove the visual verify code associated with this session to clean database and ensure new results $user_entered_code = $HTTP_POST_VARS['capcha_code']; if (!(strcasecmp($user_entered_code, $code) == 0)) { //make the check case insensitive $error = true; $messageStack->add('testing', CAPCTHA_CODE_ENTRY_ERROR); } //CAPTHCA CODE stop /* testing sign up start */ if (isset($HTTP_POST_VARS['testing_sign_up'])) { $testing_query = tep_db_query("select testing_id_number from " . TABLE_TESTING_SIGN_UP . " where testing_email_address = '" . tep_db_input($email_address) . "'"); if(tep_db_num_rows($testing_query) == 0) { $sql_data_array = array('testing_email_address' => $email_address, 'testing_firstname' => "", 'testing_lastname' => ""); tep_db_perform(TABLE_TESTING_SIGN_UP, $sql_data_array); } } /* testing sign up end */ if ($error == false) { tep_mail(STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS, EMAIL_SUBJECT, $email_address,STORE_OWNER_EMAIL_ADDRESS); tep_mail(MESSAGE_TEXT, $email_address, CUSTOMER_SUBJECT, NUMBER_ONE, STORE_OWNER_EMAIL_ADDRESS); tep_redirect(tep_href_link(FILENAME_TESTING, 'action=success')); } } $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_TESTING)); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" cellspacing="3" cellpadding="3"> <tr> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td><!-- body_text //--> <td width="100%" valign="top"><?php echo tep_draw_form('testing', tep_href_link(FILENAME_TESTING, 'action=send')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td><td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_contact_us.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td></tr> </table> </td></tr><td class="main"><?php echo INFORMATION_TEXT; ?></td> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td></tr> <?php if ($messageStack->size('testing') > 0) { ?> <tr> <td><?php echo $messageStack->output('testing'); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <?php } if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'success')) { ?> <tr> <td class="main" align="left"><?php echo tep_image(DIR_WS_IMAGES . 'clever.gif', HEADING_TITLE, '0', '0', 'align="left"') . TEXT_COMPLETE; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <?php } else { ?> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2" > <!--<tr> <td class="main"><?php echo ENTRY_NAME; ?></td> </tr> <tr> <td class="main"><?php echo tep_draw_input_field('name'); ?></td> </tr>//--> <tr><td class="main"><?php echo INSTRUCTIONS_TEXT; ?></td></tr> <tr> <td class="main"><?php echo ENTRY_EMAIL; ?> <?php echo tep_draw_input_field('email'); ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <!--<tr> <td class="main"><?php echo ENTRY_ENQUIRY; ?></td> </tr> <tr> <td><?php echo tep_draw_textarea_field('enquiry', 'soft', 50, 15, $infotext); ?></td> </tr>//--> <!-- CAPTHCA CODE-- START--> <tr> <td class="main"><?php echo CAPCTHA_CODE_CATEGORY; ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" cellspacing="2" cellpadding="2"> <tr> <td class="main"><?php echo CAPCTHA_CODE_TEXT_INSTRUCTIONS; ?></td> <td class="main"> <?php // ----- begin garbage collection -------- tep_db_query("DELETE FROM " . TABLE_CAPCTHA_CODE . " WHERE dt < DATE_SUB(NOW(), INTERVAL 5 HOUR)"); // ----- end garbage collection -------- //can replace the following loop with $capcha_code = substr(str_shuffle (CAPCTHA_CODE_CHARACTER_POOL), 0, rand(3,4)); if you have PHP 4.3 $capcha_code = ""; for ($i = 1; $i <= rand(3,4); $i++){ $capcha_code = $capcha_code . substr(CAPCTHA_CODE_CHARACTER_POOL, rand(0, strlen(CAPCTHA_CODE_CHARACTER_POOL)-1), 1); } $vvcode_oscsid = tep_session_id($HTTP_GET_VARS[tep_session_name()]); tep_db_query("DELETE FROM " . TABLE_CAPCTHA_CODE . " WHERE oscsid='" . $vvcode_oscsid . "'"); $sql_data_array = array('oscsid' => $vvcode_oscsid, 'code' => $capcha_code); tep_db_perform(TABLE_CAPCTHA_CODE, $sql_data_array); $capcha_code = ""; echo('<img src="' . FILENAME_CAPCTHA_CODE_DISPLAY . '?vvc=' . $vvcode_oscsid . '"'); ?> </td> <td class="main"><?php echo CAPCTHA_CODE_BOX_IDENTIFIER; ?></td> <td class="main"><?php echo tep_draw_input_field('capcha_code'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <!-- testing sign up start//--> <TD WIDTH="100%"> <tr> <td class="main" align="right"><?php echo ENTRY_TESTING_SIGN_UP; ?> <?php echo tep_draw_checkbox_field('testing_sign_up', '1', true); ?> </td></tr> <!--testing sign up end //--> <!-- CAPTHCA CODE-- STOP --> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> <td align="right"><?php echo tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></td> <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td> </tr> </table></td> </tr> </table></td> </tr> <?php } ?> </table></form></td> <!-- body_text_eof //--> <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> <br> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> I need some help with the category part on a old project . The problem what I have at this moment that, when I click on the category all categories are showing up on the category.php page itself. What whI wanne have when I click Uncategorised that in the category.php page only post are showing that have been made in Uncategorised category
function get_posts() {
$sql = "SELECT
`blog`.`post_id` AS `id`,
`blog`.`post_title` AS `title`,
LEFT(`blog`.`post_body`, 512) AS `preview`,
`blog`.`post_user` AS `user`,
`blog_categories`.`id` AS `category_id`,
`blog_categories`.`name` AS `category_name`,
DATE_FORMAT(`blog`.`post_date`, '%d-%m-%Y %H:%i') AS `date`,
`blog_comments`.`total_comments`,
DATE_FORMAT(`blog_comments`.`last_comment`, '%d-%m-%Y %H:%i') AS `last_comment`
FROM `blog`
INNER JOIN `blog_categories` ON `blog_categories`.`id` = `blog`.`cat_id`
LEFT JOIN (
SELECT
`post_id`,
COUNT(`comment_id`) AS `total_comments`,
MAX(`comment_date`) AS `last_comment`
FROM `blog_comments`
GROUP BY `post_id`
) AS `blog_comments`
ON `blog`.`post_id` = `blog_comments`.`post_id`
ORDER BY `blog`.`post_date` DESC";
$posts = mysql_query($sql);
$rows = array();
while (($row = mysql_fetch_assoc($posts)) !== false) {
$rows[]= array(
'id' => $row['id'],
'title' => $row['title'],
'preview' => $row['preview'],
'user' => $row['user'],
'date' => $row['date'],
'category_id' => $row['category_id'],
'category_name' => $row['category_name'],
'total_comments' => ($row['total_comments'] === null) ? 0 : $row['total_comments'],
'last_comments' => ($row['last_comment'] === null) ? 'never' : $row['last_comment']
);
}
return $rows;
}
function get_post($pid) {
$pid = (int)$pid;
$sql = "SELECT
`post_title` AS `title`,
`post_body` AS `body`,
`post_user` AS `user`,
`blog_categories`.`id` AS `category_id`,
`blog_categories`.`name` AS `category_name`,
DATE_FORMAT(`post_date`, '%d-%m-%Y %H:%i') AS `date`
FROM `blog`
INNER JOIN `blog_categories` ON `blog_categories`.`id` = `blog`.`cat_id`
WHERE `post_id` = '$pid'";
$post = mysql_query($sql);
$post = mysql_fetch_assoc($post);
$post['blog_comments'] = get_comments($pid);
return $post;
}
The old way was like this
if ( isset($cat_id)) {
$cat_id = (int) $cat_id;
$query .= " WHERE `blog_categories`.`id` = $cat_id";
}
Database blog_categories id | name | ----------- 4 Uncategorised 1 Youtube blog post_id | cat_id | post_title | post_body | post_user | post_date ----------------------------------------------------------------------------------- 4 | 1 | Youtube | Youtube link | Admin | 2020-09-13 16:10:53 Web server Apache/2.2.21 (Win64) PHP/5.3.10 MySQL-client versie: mysqlnd 5.0.8-dev - 20102224 - $Revision: 321634 $ PHP uitbreiding: mysqli Documentatie phpMyAdmin Versie informatie: 3.4.10.1, meest recente versie: 5.0.2 I hope someone can help me with this problem The program is working for part of the data . It can display in the CSS and HTML code, however, the other data can not display . I do not why . They are same structure . Please tell me the reason. Thank you very much. |
|||||||