Esempio n. 1
0
 function edit_sub_category($name, $id, $markbold, $category_id)
 {
     require_once $_SERVER['DOCUMENT_ROOT'] . "/common/class/seo.class.php";
     $seo_class = new seo();
     $sql = "update `" . $this->table . "` set name='" . $this->mysql->magicquotes($name) . "',markbold='" . $this->mysql->magicquotes($markbold) . "',category_id='" . $this->mysql->magicquotes($category_id) . "',seo_url='" . $this->mysql->magicquotes($seo_class->get_seo_url($name)) . "' where id='" . $id . "'";
     $result = $this->mysql->query($sql);
 }
Esempio n. 2
0
<?php

require_once $_SERVER['DOCUMENT_ROOT'] . "/common/class/mysql.class.php";
require_once $_SERVER['DOCUMENT_ROOT'] . "/common/class/seo.class.php";
$mysql = new mysql();
$seo = new seo();
$sql = "select * from category";
$data = $mysql->getdata($sql);
foreach ($data as $row) {
    $sql = "update category set seo_url='" . $seo->get_seo_url($row['sub_cat']) . "' where id='" . $row['id'] . "'";
    echo $row['id'] . "<br>";
    $mysql->query($sql);
}
Esempio n. 3
0
<?php

include "mysql.class.php";
include "seo.class.php";
$seo = new seo();
$mysql = new mysql();
$sql = "select * from rentorhire_category ";
$data = $mysql->getdata($sql);
foreach ($data as $value) {
    $sql_update = "update rentorhire_category  set seo_url='" . $seo->get_seo_url($value['name']) . "' where id='" . $value['id'] . "'";
    echo $sql_update . "<br />";
    $mysql->query($sql_update);
}