Actually i my website meta tags are comming from database & client not given the database access.
My index page has following code-:
Code: Select all
<?php
require_once('config.php');
include_once(APP_DIR.'include/connect.php');
include_once(APP_DIR.'include/functions.php');
include_once(APP_DIR.'smarty.php');
include_once(APP_DIR.'globals.php');
$smarty->display("page_home.php");
?>
[color=#BF0000[b]]& globals.php [/b]
{
<?php
/////////////////////////////////////////////
//get page vars from DB
$query_page = "SELECT `name`, `value` FROM `vars` WHERE `name` LIKE '%$page%' ORDER BY `name` ASC";
$result_page = mysql_query($query_page);
$fields_page = fieldsNumDB($result_page);
$smarty -> assign("fields_page", $fields_page);
/////////////////////////////////////////////
//categories list
$query_cats = "SELECT * FROM `categories` WHERE `type` = '1'";
$result_cats = mysql_query($query_cats);
$cats = fieldsNumDB($result_cats);
$smarty -> assign("cats", $cats);
/////////////////////////////////////////////
//get current category items
if($category_id) {
$query_items = sprintf("SELECT
`categories`.`id` AS `cat_id`,
`categories`.`name` AS `cat_name`,
`products`.`id`,
`products`.`name`
FROM
`categories`
INNER JOIN `products` ON (`categories`.`id` = `products`.`manufacturer_id`)
WHERE
(`categories`.`id` = %s) AND
(`products`.`display` = 'Y')
ORDER BY `products`.`color_type`,
`product_order` DESC", $category_id);
$result_items = mysql_query($query_items);
$fields_items = fieldsNumDB($result_items);
$smarty -> assign("fields_items", $fields_items);
}
/////////////////////////////////////////////
//get specials for index.php and services.php
if($page == "index" || $page == "specials") {
//get item details
$query_special = "SELECT
`categories`.`name` AS `cat_name`,
`products`.`id`,
`products`.`name` AS `item_name`,
`products`.`short_desc`,
`products`.`full_desc`,
`products`.`points_specification`,
`products`.`price_from`,
`products`.`color_type`,
`images`.`obrazok`,
`products`.`meta_keywords`,
`products`.`meta_description`
FROM
`products`
LEFT JOIN `images` ON (`products`.`id` = `images`.`item_id`)
INNER JOIN `categories` ON (`products`.`manufacturer_id` = `categories`.`id`)
WHERE
(`products`.`special` = 'Y') AND
(`products`.`display` = 'Y')
ORDER BY `cat_name`, `product_order` ASC";
$result_special = mysql_query($query_special);
$fields_special = fieldsNumDB($result_special);
$smarty -> assign("fields_special", $fields_special);
}
/////////////////////////////////////////////
//get specials all pages
// For Work Groups
$query_workgroups = "SELECT
`products`.`id`,
`categories`.`id` AS `cat_id`,
`categories`.`name` AS `cat_name`,
`products`.`name` AS `item_name`,
`products`.`short_desc`,
`products`.`price_from`,
`images`.`obrazok`
FROM
`products`
LEFT JOIN `images` ON (`products`.`id` = `images`.`item_id`)
INNER JOIN `categories` ON (`products`.`manufacturer_id` = `categories`.`id`)
WHERE
(`products`.`special` = 'Y') AND
(`products`.`display` = 'Y')
AND
(`products`.`bw_speed` > 0 AND `products`.`bw_speed` < 31)
ORDER BY `product_order` DESC";
$result_workgroups = mysql_query($query_workgroups);
$specials_workgroups = fieldsNumDB($result_workgroups);
$smarty -> assign("specials_workgroups", $specials_workgroups);
// For Departments
$query_departments = "SELECT
`products`.`id`,
`categories`.`id` AS `cat_id`,
`categories`.`name` AS `cat_name`,
`products`.`name` AS `item_name`,
`products`.`short_desc`,
`products`.`price_from`,
`images`.`obrazok`
FROM
`products`
LEFT JOIN `images` ON (`products`.`id` = `images`.`item_id`)
INNER JOIN `categories` ON (`products`.`manufacturer_id` = `categories`.`id`)
WHERE
(`products`.`special` = 'Y') AND
(`products`.`display` = 'Y')
AND
(`products`.`bw_speed` > 29 AND `products`.`bw_speed` < 51)
ORDER BY `product_order` DESC";
$result_departments = mysql_query($query_departments);
$specials_departments = fieldsNumDB($result_departments);
$smarty -> assign("specials_departments", $specials_departments);
// For Production
$query_production = "SELECT
`products`.`id`,
`categories`.`id` AS `cat_id`,
`categories`.`name` AS `cat_name`,
`products`.`name` AS `item_name`,
`products`.`short_desc`,
`products`.`price_from`,
`images`.`obrazok`
FROM
`products`
LEFT JOIN `images` ON (`products`.`id` = `images`.`item_id`)
INNER JOIN `categories` ON (`products`.`manufacturer_id` = `categories`.`id`)
WHERE
(`products`.`special` = 'Y') AND
(`products`.`display` = 'Y')
AND
(`products`.`bw_speed` > 50)
ORDER BY `product_order` DESC";
$result_production = mysql_query($query_production);
$specials_production = fieldsNumDB($result_production);
$smarty -> assign("specials_production", $specials_production);
// For Color
$query_color = "SELECT
`products`.`id`,
`categories`.`id` AS `cat_id`,
`categories`.`name` AS `cat_name`,
`products`.`name` AS `item_name`,
`products`.`short_desc`,
`products`.`price_from`,
`images`.`obrazok`
FROM
`products`
LEFT JOIN `images` ON (`products`.`id` = `images`.`item_id`)
INNER JOIN `categories` ON (`products`.`manufacturer_id` = `categories`.`id`)
WHERE
(`products`.`color_type` = 'C') AND
(`products`.`special` = 'Y') AND
(`products`.`display` = 'Y')
ORDER BY `product_order` DESC";
$result_color = mysql_query($query_color);
$specials_color = fieldsNumDB($result_color);
$smarty -> assign("specials_color", $specials_color);
/////////////////////////////////////////////
//get random text for 'speak' box
$query = "SELECT * FROM `rnd_text` WHERE `position` = 'speak'";
$result = mysql_query($query);
$rnd_text = fieldsNumDB($result);
$rnd_key = array_rand($rnd_text);
// Check string lenght
if(strlen($rnd_text[$rnd_key]['text']) > 190){
$text_link = sprintf("\n<br /><a href=\"digital_copier_advices.php?text_id=%s\">Read More »</a>\n", $rnd_text[$rnd_key]['text_id']);
}
else{
$text_link = '';
}
$smarty -> assign("speak_title", $rnd_text[$rnd_key]['title']);
$smarty -> assign("speak_text", $rnd_text[$rnd_key]['text']);
$smarty -> assign("speak_link", $text_link);
?>
}