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); }
<?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); }
<?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); }