PHP Category::insert方法代码示例

 /**
  * Allows a user to add a workshop category
  *
  */
 public function addAction()
 {
     $messages = array();
     $category = new Category();
     $form = $category->form();
     if ($this->_request->isPost()) {
         if ($form->isValid($_POST)) {
             $data = array('name' => $form->getValue('name'), 'description' => $form->getValue('description'));
             $categoryId = $category->insert($data);
             $trigger = new Ot_Trigger();
             $data['accountId'] = Zend_Auth::getInstance()->getIdentity()->accountId;
             $trigger->setVariables($data);
             $trigger->dispatch('Category_Add');
             $this->_helper->flashMessenger->addMessage('msg-info-categoryAdded');
             $this->_helper->redirector->gotoUrl('/workshop/category/details/?categoryId=' . $categoryId);
         } else {
             $messages[] = "msg-error-formSubmitProblem";
         }
     }
     $this->view->messages = $messages;
     $this->view->form = $form;
     $this->view->headScript()->appendFile($this->view->baseUrl() . '/scripts/jquery.wysiwyg.js');
     $this->view->headLink()->appendStylesheet($this->view->baseUrl() . '/css/jquery.wysiwyg.css');
     $this->_helper->pageTitle('workshop-category-add:title');
 }

 /**
  * 添加、修改分类结果
  */
 public function actionModified()
 {
     $Category = new Category();
     $data = WaveCommon::getFilter($_POST);
     $cid = (int) $data['cid'];
     unset($data['cid']);
     if ($cid == 0) {
         $Category->insert($data);
     } else {
         $Category->update($data, array('cid' => $cid));
     }
     $this->jumpBox('成功！', Wave::app()->homeUrl . 'categories', 1);
 }

 /**
  * Create new Category
  */
 public function create()
 {
     if ($this->slim->request->isGet()) {
         $this->slim->render('category/create.html.twig', ['sessionUser' => $this->getSessionUser()]);
     } elseif ($this->slim->request->isPost()) {
         $name = $_POST['name'];
         $newCategory = new Category($this->slim->db);
         $newCategory->setName($name);
         $newCategory->insert();
         $this->slim->flash('success', 'Category created');
         $this->slim->redirect('/categories');
     }
 }

 function action()
 {
     // 子类
     $category = new Category();
     $kdgs = new Kdgs();
     $story_url = new StoryUrl();
     $current_time = date('Y-m-d H:i:s');
     $parent_category_list = $kdgs->get_parent_category($this->home_url);
     foreach ($parent_category_list as $k => $v) {
         $exists = $category->check_exists("`res_name`='kdgs' and `s_id`='{$v['s_id']}'");
         if ($exists) {
             continue;
         } else {
             $category_id = $category->insert(array('res_name' => 'kdgs', 'parent_id' => 0, 'title' => $v['title'], 's_id' => $v['s_id'], 's_p_id' => 0, 'from_url' => $this->home_url, 'link_url' => $v['link_url'], 's_cover' => $v['cover'], 'add_time' => date('Y-m-d H:i:s')));
             $story_url->insert(array('res_name' => 'category', 'res_id' => $category_id, 'field_name' => 'cover', 'source_url' => $v['cover'], 'source_file_name' => ltrim(strrchr($v['cover'], '/'), '/'), 'add_time' => date('Y-m-d H:i:s')));
             echo $category_id;
             echo "<br />";
         }
     }
     // 子类
     $category_list = $category->get_list("`res_name`='kdgs' and `s_p_id`=0");
     foreach ($category_list as $k => $v) {
         $children_category_list = $kdgs->get_children_category_list($v['link_url']);
         foreach ($children_category_list as $k2 => $v2) {
             $exists = $category->check_exists("`res_name`='kdgs' and `s_id`='0' and `s_p_id`='{$v2['s_p_id']}'");
             if ($exists) {
                 continue;
             } else {
                 $category_id = $category->insert(array('res_name' => 'kdgs', 'parent_id' => $v['id'], 'title' => $v2['title'], 's_id' => 0, 's_p_id' => $v2['s_p_id'], 'from_url' => $v['link_url'], 'link_url' => $v2['link_url'], 's_cover' => $v2['cover'], 'add_time' => date('Y-m-d H:i:s')));
                 $story_url->insert(array('res_name' => 'category', 'res_id' => $category_id, 'field_name' => 'cover', 'source_url' => $v2['cover'], 'source_file_name' => ltrim(strrchr($v2['cover'], '/'), '/'), 'add_time' => date('Y-m-d H:i:s')));
                 echo "children：" . $category_id;
                 echo "<br />";
             }
         }
     }
 }

 public function run()
 {
     $date = new DateTime();
     $category[] = array('name' => 'Laptops', 'created_at' => $date->modify('-10 day'), 'updated_at' => $date->modify('-3 day'), 'user_id' => 1, 'use_default_eula' => 0, 'require_acceptance' => 0, 'deleted_at' => NULL, 'eula_text' => NULL);
     $date = new DateTime();
     $category[] = array('name' => 'Desktops', 'created_at' => $date->modify('-10 day'), 'updated_at' => $date->modify('-3 day'), 'user_id' => 1, 'use_default_eula' => 0, 'require_acceptance' => 0, 'deleted_at' => NULL, 'eula_text' => NULL);
     $date = new DateTime();
     $category[] = array('name' => 'Tablets', 'created_at' => $date->modify('-10 day'), 'updated_at' => $date->modify('-3 day'), 'user_id' => 1, 'use_default_eula' => 0, 'require_acceptance' => 0, 'deleted_at' => NULL, 'eula_text' => NULL);
     $date = new DateTime();
     $category[] = array('name' => 'Phones', 'created_at' => $date->modify('-10 day'), 'updated_at' => $date->modify('-3 day'), 'user_id' => 1, 'use_default_eula' => 0, 'require_acceptance' => 0, 'deleted_at' => NULL, 'eula_text' => NULL);
     $date = new DateTime();
     $category[] = array('name' => 'Monitors', 'created_at' => $date->modify('-10 day'), 'updated_at' => $date->modify('-3 day'), 'user_id' => 1, 'use_default_eula' => 0, 'require_acceptance' => 0, 'deleted_at' => NULL, 'eula_text' => NULL);
     // Delete all the blog posts
     DB::table('categories')->truncate();
     // Insert the blog posts
     Category::insert($category);
 }

<?php

///////////////////////////////////
require 'tables.php';
if (isset($_GET['categoryName'])) {
    $category_new = $_GET['categoryName'];
    $Categorys = new Category();
    $Categorys->categoryName = $category_new;
    $Categorys->insert();
}
$Categorys = new Category();
$data = $Categorys->select();
$response = json_encode($data);
echo $response;

session_start();
include 'cat.php';
$cat = new Category();
if (isset($_GET['method'])) {
    $method = $_GET['method'];
} else {
    $method = $_POST['method'];
}
if (isset($_GET['id'])) {
    $id = $_GET['id'];
}
switch ($method) {
    case 'insert':
        if (isset($_POST['add_cat']) && !empty($_POST['add_cat'])) {
            $cat->name = $_POST['add_cat'];
            $cat->insert();
            header("location:../controle.php");
        } else {
            $_SESSTION['error'] = "please enter a valid name";
            header("location:../controle.php");
        }
        # code...
        break;
    case 'edit':
        # code...
        break;
    case 'delete':
        $cat->delete($id);
        header("location:../controle.php");
        # code...
        break;

	private $id;
	private $name;
	private $content;
	private $cid;
	
	public function __set($name,　$value) {
		$this->name = $value;
	}
	
	public function __get($name) {
		return $this->$name;
	}
	
	public function insert($row) {
		$sql = "insert into think_category values(null, '$this->name'.'$this->content'.'$this->cid')";
		mysql_query ( $sql );
	}
	
	public function delete() {
		$sql = "delete from think_category where id='$this->id'";
		mysql_query ( $sql );
	}
}

$cate=new Category();
$cate->name='电话';
$cate->content = '很好';
$cate->cid = '1';
$cate->insert();

<?php

require_once "config.php";
if (isset($_POST['btn_submit'])) {
    $new_cat = new Category();
    $new_cat->name = $_POST['tb_new_cat'];
    $new_cat->insert();
    header("Location: " . SITE_ROOT . "personal");
}

if ($action == "save") {
    $insert = TRUE;
    $errMsg = NULL;
    if ($name == "") {
        $errMsg = Text::getText("MissingName");
        $insert = FALSE;
    }
    if ($insert) {
        $existing = Category::getByName($name);
        if ($existing != NULL) {
            $errMsg = Text::getText("AlreadyExists");
            $insert = FALSE;
        }
    }
    if ($insert) {
        $c->insert();
        header("Location: categoryList.php");
        exit;
    } else {
        $buttonCaption = Text::getText("Add");
        include("header.php");
        print "<h2>".Text::getText("AddCategory")."</h2>";
        include("categoryForm.php");
        include("footer.php");
    }
} else {
    $title = Text::getText("AddCategory");
    $buttonCaption = Text::getText("Add");
    include("header.php");
    print "<h2>".Text::getText("AddCategory")."</h2>";
    include("categoryForm.php");

function newCategory()
{
    $results = array();
    $results['pageTitle'] = "New Article Category";
    $results['formAction'] = "newCategory";
    if (isset($_POST['saveChanges'])) {
        $category = new Category();
        $category->storeFormValues($_POST);
        $category->insert();
        header("Location: admin.php?action=listCategories&status=changesSaved");
    } elseif (isset($_POST['cancel'])) {
        header("Location: admin.php?action=listCategories");
    } else {
        $results['category'] = new Category();
        require TEMPLATE_PATH . "/admin/editCategory.php";
    }
}

include_once APP_INC_PATH . "class.auth.php";
include_once APP_INC_PATH . "class.user.php";
include_once APP_INC_PATH . "class.project.php";
include_once APP_INC_PATH . "class.category.php";
include_once APP_INC_PATH . "db_access.php";
$tpl = new Template_API();
$tpl->setTemplate("manage/index.tpl.html");
Auth::checkAuthentication(APP_COOKIE);
$tpl->assign("type", "categories");
$role_id = Auth::getCurrentRole();
if ($role_id == User::getRoleID('administrator') || $role_id == User::getRoleID('manager')) {
    if ($role_id == User::getRoleID('administrator')) {
        $tpl->assign("show_setup_links", true);
    }
    @($prj_id = $HTTP_POST_VARS["prj_id"] ? $HTTP_POST_VARS["prj_id"] : $HTTP_GET_VARS["prj_id"]);
    $tpl->assign("project", Project::getDetails($prj_id));
    if (@$HTTP_POST_VARS["cat"] == "new") {
        $tpl->assign("result", Category::insert());
    } elseif (@$HTTP_POST_VARS["cat"] == "update") {
        $tpl->assign("result", Category::update());
    } elseif (@$HTTP_POST_VARS["cat"] == "delete") {
        Category::remove();
    }
    if (@$HTTP_GET_VARS["cat"] == "edit") {
        $tpl->assign("info", Category::getDetails($HTTP_GET_VARS["id"]));
    }
    $tpl->assign("list", Category::getList($prj_id));
} else {
    $tpl->assign("show_not_allowed_msg", true);
}
$tpl->displayTemplate();

                    unlink($dir . "/" . $object);
                }
            }
        }
        reset($objects);
        rmdir($dir);
    } else {
        unlink($dir);
    }
}
//------------------------------------------------------ insert new category ----------------------------------------------
if (isset($_GET['categoryName'])) {
    if (!empty($_GET['categoryName'])) {
        $category = new Category();
        $category->cName = $_GET['categoryName'];
        $responce = $category->insert();
        if ($responce == 0) {
            $responce = 'this category name already exist';
        } else {
            mkdir('../../images/products/' . $responce, 0777);
            chmod('../../images/products/' . $responce, 0777);
        }
    } else {
        $responce = 'please enter a value';
    }
}
//------------------------------------------------------ delete category ----------------------------------------------
if (isset($_GET['cID'])) {
    if (!empty($_GET['cID'])) {
        $category = new Category();
        $category->delete($_GET['cID']);

    $idCategory = POST('id');
    ossim_valid($idCategory, OSS_ALPHA, 'illegal:' . _("Category"));
    //
    $nameSubCategory = POST('nameSubCategory');
    ossim_valid($nameSubCategory, OSS_SCORE, OSS_ALPHA, OSS_NULLABLE, 'illegal:' . _("Name Subcategory"));
    if (Subcategory::insert($conn, $idCategory, $nameSubCategory)) {
        // insert ok
        $msg = 'Ok! Add Subcategory';
    } else {
        // fail insert
        $msg = 'Error no add Subcategory';
    }
} elseif ($action == 'addCategory') {
    $nameCategory = POST('nameCategory');
    ossim_valid($nameCategory, OSS_SCORE, OSS_ALPHA, OSS_NULLABLE, 'illegal:' . _("Name Subcategory"));
    if (Category::insert($conn, $nameCategory)) {
        // insert ok
        $msg = 'Ok! Add Category';
    } else {
        // fail insert
        $msg = 'Error no add Category';
    }
} elseif ($action == 'deleteCategory') {
    $idCategory = GET('id');
    ossim_valid($idCategory, OSS_ALPHA, 'illegal:' . _("Category"));
    if (Category::delete($conn, $idCategory)) {
        // insert ok
        $msg = 'Ok! Delete Category';
    } else {
        // fail insert
        $msg = 'Error no delete Category';

                 $data['data'] = _('Subcategory added successfully');
             }
         } else {
             $data['data'] = _('Error! This subcategory already exists');
         }
     } else {
         $data['data'] = ossim_get_error_clean();
     }
 } elseif ($action == 'add_category') {
     $c_name = POST('c_name') != '' ? str_replace(' ', '_', POST('c_name')) : POST('c_name');
     ossim_valid($c_name, OSS_SCORE, OSS_ALPHA, 'illegal:' . _('Category Name'));
     $data['status'] = 'error';
     $data['data'] = _('Error! Category not added');
     if (!ossim_error()) {
         if (!Category::exist($conn, $c_name)) {
             if (Category::insert($conn, $c_name)) {
                 $data['status'] = 'OK';
                 $data['data'] = _('Category added successfully');
             }
         } else {
             $data['data'] = _('Error! This category already exists');
         }
     } else {
         $data['data'] = ossim_get_error_clean();
     }
 } elseif ($action == 'delete_category') {
     $cat_id = GET('cat_id');
     ossim_valid($cat_id, OSS_DIGIT, 'illegal:' . _('Category'));
     $data['status'] = 'error';
     $data['data'] = _('Error! Category not deleted');
     if (!ossim_error()) {