Применение языка PHP, СУБД MySQL и фреймворка CodeIgniter для разработки динамических веб-сайтов
Курсовой проект - Компьютеры, программирование
Другие курсовые по предмету Компьютеры, программирование
discount] = $this->catalogmodel->GetDiscount ();
$pageData [image] = $this->catalogmodel->GetImage ();($pageData [categories] == false)
{
$pageData [errDescription] = "Категорий не найдено. ";
}($pageData [discount] == false)
{
$pageData [errDescription] = "Скидок нет. ";
}
$this->load->view ("header",$pageData);
$this->load->view ("images",$pageData);
$this->load->view (footer);
}categorydetails ($id_category) {
$pageData [title] ="Мебель";
$this->load->model (catalogmodel);
$pageData [categorydetails] = $this->catalogmodel->GetCategoryDetails ($id_category);($pageData [categorydetails] == false)
{
$pageData [errDescription] = "Товаров в выбранной категории нет. ";
}
$pageData [categories] = $this->catalogmodel->GetAllCategories ();
$pageData [image] = $this->catalogmodel->GetImage ();
$this->load->view ("header",$pageData);
$this->load->view ("categorydetails");
$this->load->view (footer);
}search ()
{
$this->load->model (catalogmodel);
$pageData [categories] = $this->catalogmodel->GetAllCategories ();
$pageData [image] = $this->catalogmodel->GetImage ();(isset ($_POST ["mytext"])) {
$text = $_POST ["mytext"];
$pageData [search] = $this->catalogmodel->GetSearch ($text);($pageData [search] == false)
{
$pageData [errDescription] = "Такого товара не обнаружено. ";
}
}
else { $pageData [search] = "Не введена фраза для поиска"; }
$this->load->view ("header",$pageData);
$this->load->view ("search",$pageData);
$this->load->view (footer);
}
}
? >
10.5 Catalogmodel. php
<? phpCatalogmodel extends Model
{Catalogmodel ()
{:: Model ();
}GetAllCategories ()
{
$qCatalog = "SELECT * FROM categories";
$result = $this->db->query ($qCatalog);
$category = $result->result_array ();(count ($category) == 0)
{false;
}$category;
}GetImage ()
{
$qImage = "SELECT * FROM image,productsproducts. id_product=image. id_productimage. display=0BY RAND () LIMIT 5";
$result = $this->db->query ($qImage);
$image = $result->result_array ();$image;
}GetCategoryDetails ($id_category)
{
$val=$id_category;
$qGetCategory = "SELECT * FROM product_category, products, imageproduct_category. id_category=$valproduct_category. id_product=products. id_productproducts. id_product=image. id_product";
$result = $this->db->query ($qGetCategory);
$productid = $result->result_array ();(count ($productid) == 0)
{false;
}$productid;
}GetSearch ($text)
{
$qGetName = "SELECT * FROM products, image WHERE name_product LIKE %$text% AND products. id_product=image. id_product";
$result = $this->db->query ($qGetName);
$search = $result->result_array ();(count ($search) == 0)
{false;
}$search;
}GetNewProduct ()
{
$qnewproduct = "SELECT * FROM products, imageproducts. id_product=image. id_productby date desc0,3";
$result = $this->db->query ($qnewproduct);
$newproduct = $result->result_array ();$newproduct;
}GetDiscount ()
{
$qdiscount = "SELECT * FROM discount,products, imagediscount. discount>0discount. id_product=products. id_productproducts. id_product=image. id_product0,3";
$result = $this->db->query ($qdiscount);
$discount = $result->result_array ();(count ($discount) == 0)
{false;
}$discount;
}
}
? >
10.6 Categorydetails. php
<? php(isset ($errDescription))
{"";
}($categorydetails as $product)
{"
";
// echo "";
}
? >
10.7 Search. Php
<? php(isset ($errDescription))
{"";
}(is_array ($search)) {($search as $item)
{"
";
// echo "";
}
}echo $search;
? >
10.8 Images. Php
";($newproduct as $item)
{"
;
// echo ;
// echo item (base_url). images/foto