PHP Backend::insert方法代码示例

<?php

$url = "../index.php?mod=text&act=list";
require_once "../model/Backend.php";
$model = new Backend();
$id = (int) $_POST['id'];
$arrData['text'] = $text = trim($_POST['text']);
$table = "text";
if ($id > 0) {
    $arrData['id'] = $id;
    $model->update($table, $arrData);
} else {
    $model->insert($table, $arrData);
}
header('location:' . $url);

<?php

$url = "../index.php?mod=block&act=list";
require_once "../model/Backend.php";
$model = new Backend();
$id = (int) $_POST['id'];
$arrData['name_vi'] = $name_vi = $_POST['name_vi'];
$arrData['name_en'] = $name_en = $_POST['name_en'];
if ($id > 0) {
    $arrData['id'] = $id;
    $model->update('block', $arrData);
    mysql_query("DELETE FROM link WHERE block_id = {$id}");
}
if (!empty($_POST['text_vi'])) {
    foreach ($_POST['text_vi'] as $key => $text_vi) {
        if (isset($_POST['link_vi'][$key]) && $_POST['link_vi'][$key] != '' && isset($_POST['link_en'][$key]) && $_POST['link_en'][$key] != '' && isset($_POST['text_en'][$key]) && $_POST['text_en'][$key] != '') {
            $arrLink['text_vi'] = $_POST['text_vi'][$key];
            $arrLink['text_en'] = $_POST['text_en'][$key];
            $arrLink['link_url_vi'] = $_POST['link_vi'][$key];
            $arrLink['link_url_en'] = $_POST['link_en'][$key];
            $arrLink['block_id'] = $id;
            $arrLink['status'] = 1;
            $model->insert('link', $arrLink);
            $arrLink = array();
        }
    }
}
header('location:' . $url);

        $customerArr['phone'] = $model->processData($_POST['phone']);
        $customerArr['email'] = $model->processData($_POST['email']);
        $customerArr['birthday'] = $model->processData($_POST['birthday']);
        $customerArr['address'] = $model->processData($_POST['address']);
        $customerArr['cmnd'] = $model->processData($_POST['cmnd']);
        $customerArr['updated_at'] = time();
        $customerArr['user_id'] = $user_id;
        $customerArr['status'] = 1;
        $customerArr['is_main'] = 1;
        $customer_id = (int) $_POST['customer_id'];
        if ($customer_id > 0) {
            $customerArr['id'] = $customer_id;
            $model->update('customers', $customerArr);
        } else {
            $customerArr['created_at'] = time();
            $customer_id = $model->insert('customers', $customerArr);
        }
    }
} else {
    $customer_id = $customer_id_old;
}
if ($customer_id > 0) {
    $contractArr['object_id'] = (int) $_POST['object_id'];
    $contractArr['customer_id'] = $customer_id;
    $contractArr['object_type'] = (int) $_POST['object_type'];
    $contractArr['code'] = $model->processData($_POST['code']);
    $contractArr['user_id'] = $user_id;
    $contractArr['no_person'] = (int) $_POST['no_person'];
    $contractArr['start_date'] = date('Y-m-d', strtotime($_POST['start_date']));
    $contractArr['end_date'] = date('Y-m-d', strtotime($_POST['end_date']));
    $contractArr['contract_date'] = date('Y-m-d', strtotime($_POST['contract_date']));

<?php

session_start();
require_once "../model/Backend.php";
$model = new Backend();
$url = "../index.php?mod=state&act=list";
$arrParam['state_name'] = $model->processData($_POST['state_name']);
$arrParam['state_alias'] = $model->changeTitle($arrParam['state_name']);
$arrParam['city_id'] = $city_id = (int) $_POST['city_id'];
$state_id = (int) $_POST['state_id'];
$arrParam['display_order'] = $model->getOrderMaxState("state", $city_id);
$table = "state";
if ($state_id > 0) {
    $arrParam['id'] = $state_id;
    $model->update($table, $arrParam);
} else {
    $model->insert($table, $arrParam);
}
header('location:' . $url . "&city_id=" . $city_id);

    $meta_title = $cate_name;
}
if ($meta_description == '') {
    $meta_description = $cate_name;
}
if ($meta_keyword == '') {
    $meta_keyword = $cate_name;
}
$dataArr['meta_title'] = $meta_title;
$dataArr['meta_description'] = $meta_description;
$dataArr['meta_keyword'] = $meta_keyword;
$image_url_upload = $_FILES['image_url_upload'];
if ($image_url_upload['name'] != '') {
    $arrRe = $model->uploadImages($image_url_upload);
    $image_url = $arrRe['filename'];
} else {
    $image_url = str_replace('../', '', $_POST['image_url']);
}
$dataArr['image_url'] = $image_url;
$description = $model->processData($_POST['description']);
$dataArr['description'] = $description;
$seo_text = mysql_real_escape_string($_POST['seo_text']);
$dataArr['seo_text'] = $seo_text;
if ($id > 0) {
    $dataArr['id'] = $id;
    $model->update('article_cate', $dataArr);
    header('location:' . $url);
} else {
    $model->insert('article_cate', $dataArr);
    header('location:' . $url);
}

<?php

require_once "backend/model/Backend.php";
$model = new Backend();
for ($i = 0; $i < 10; $i++) {
    $sql = "SELECT * FROM product";
    $rs = mysql_query($sql);
    while ($row = mysql_fetch_assoc($rs)) {
        $id = $row['id'];
        $rs1 = mysql_query("SELECT * FROM product_cate WHERE product_id = {$id}");
        while ($row1 = mysql_fetch_assoc($rs1)) {
            $arrCateId[$row1['cate_id']] = $row1['cate_id'];
            $arrParentId[$row1['cate_id']] = $row1['parent_id'];
        }
        unset($row['id']);
        $arrData = $row;
        $table = "product";
        $product_id = $model->insert($table, $arrData);
    }
}

    $model->insertProductCate($arrCate, $id);
    $arrTmp = array();
    if ($str_image) {
        $arrTmp = explode(';', $str_image);
    }
    if (!empty($arrTmp)) {
        foreach ($arrTmp as $url1) {
            if ($url1) {
                $url_1 = str_replace('.', '_2.', $url1);
                mysql_query("INSERT INTO images VALUES(null,'{$url1}','{$url_1}',{$id},1,1)") or die(mysql_error() . $sql);
            }
        }
    }
    header('location:' . $url);
} else {
    $id = $model->insert($table, $arr);
    $model->insertProductCate($arrCate, $id);
    $arrTmp = array();
    if ($str_image) {
        $arrTmp = explode(';', $str_image);
    }
    if (!empty($arrTmp)) {
        foreach ($arrTmp as $url) {
            if ($url) {
                $url_1 = str_replace('.', '_2.', $url);
                mysql_query("INSERT INTO images VALUES(null,'{$url}','{$url_1}',{$id},1,1)") or die(mysql_error());
            }
        }
    }
}
header('location:' . $url);

$arrDoanhThu['month'] = $month = (int) $_POST['month'];
$arrDoanhThu['year'] = $year = (int) $_POST['year'];
$arrDoanhThu['tien_phai_thu'] = $tien_phai_thu = str_replace(',', '', $_POST['tien_phai_thu']);
$arrDoanhThu['tien_nhan'] = $tien_nhan = str_replace(',', '', $_POST['tien_nhan']);
$arrDoanhThu['cong_no'] = $cong_no = str_replace(',', '', $_POST['cong_no']);
$arrDoanhThu['user_id'] = $user_id;
$arrDoanhThu['created_at'] = time();
$arrDoanhThu['updated_at'] = time();
//process doanh thu
if (isset($_POST['doanhthu_id']) && $_POST['doanhthu_id'] > 0) {
    $doanhthu_id = $_POST['doanhthu_id'];
    $arrDoanhThu['id'] = $doanhthu_id;
    $model->update('doanh_thu', $arrDoanhThu);
    mysql_query("DELETE FROM contract_service_month WHERE doanhthu_id = {$doanhthu_id}");
} else {
    $doanhthu_id = $model->insert('doanh_thu', $arrDoanhThu);
}
//process tien thue phong
$arrContractServiceMonth = array();
$arrContractServiceMonth['doanhthu_id'] = $doanhthu_id;
$arrContractServiceMonth['service_id'] = 9999;
$arrContractServiceMonth['chi_so_cu'] = 0;
$arrContractServiceMonth['chi_so_moi'] = 0;
$arrContractServiceMonth['type'] = 1;
$arrContractServiceMonth['price'] = $price_thue_phong;
$arrContractServiceMonth['total_price'] = $price_thue_phong;
$arrContractServiceMonth['amount'] = 1;
$model->insert('contract_service_month', $arrContractServiceMonth);
// process service chi so
$arrCu = $_POST['chi_so_cu'];
$arrMoi = $_POST['chi_so_moi'];

    $numCol = $data->colcount();
    $rowCol = $data->rowcount();
    for ($j = 1; $j <= $numCol; $j++) {
        for ($i = 2; $i < $rowCol; $i++) {
            $dataArr[$arrColumn[$j - 1]][] = $data->val($i, $j);
        }
    }
}
if (!empty($dataArr)) {
    $count = count($dataArr['product_code']);
    for ($k = 0; $k <= $count; $k++) {
        foreach ($arrColumn as $value) {
            $dataInsert[$value] = $dataArr[$value][$k];
            $dataInsert['name_en'] = $model->stripUnicode($dataArr['product_name'][$k]);
            $dataInsert['product_alias'] = $model->changeTitle($dataArr['product_name'][$k]);
            $id = $model->getProductIdByCode($dataArr['product_code'][$k]);
            if ($id > 0) {
                $dataInsert['id'] = $id;
            }
        }
        if ($dataInsert['product_code'] != '' && $dataInsert['product_name'] != '' && $dataInsert['cate_type_id'] != '' && $dataInsert['cate_id'] != '') {
            if ($dataInsert['id'] > 0) {
                $model->update('product', $dataInsert);
                echo "Cập nhật thành công sản phẩm '" . $dataInsert['product_name'] . "'" . "<br />";
            } else {
                $model->insert('product', $dataInsert);
                echo "Thêm mới thành công sản phẩm '" . $dataInsert['product_name'] . "'" . "<br />";
            }
        }
    }
}

} else {
    $image_url = str_replace('../', '', $_POST['image_url']);
}
$dataArr['image_url'] = $image_url;
$meta_title = $model->processData($_POST['meta_title']);
$seo_title = $model->processData($_POST['seo_title']);
$dataArr['seo_title'] = $seo_title;
$meta_keyword = $model->processData($_POST['meta_keyword']);
$meta_description = $model->processData($_POST['meta_description']);
if ($meta_title == '') {
    $meta_title = $page_name;
}
if ($meta_keyword == '') {
    $meta_keyword = $page_name;
}
if ($meta_description == '') {
    $meta_description = $page_name;
}
$dataArr['meta_title'] = $meta_title;
$dataArr['meta_keyword'] = $meta_keyword;
$dataArr['meta_description'] = $meta_description;
$dataArr['updated_at'] = time();
if ($id > 0) {
    $dataArr['id'] = $id;
    $model->update('articles', $dataArr);
    header('location:' . $url . "&cate_id=" . $cate_id);
} else {
    $dataArr['created_at'] = time();
    $model->insert('articles', $dataArr);
    header('location:' . $url . "&cate_id=" . $cate_id);
}

    $meta_keyword_en = $name_en;
}
$arrData['meta_title_vi'] = $meta_title_vi;
$arrData['meta_title_en'] = $meta_title_en;
$arrData['meta_description_vi'] = $meta_description_vi;
$arrData['meta_description_en'] = $meta_description_en;
$arrData['meta_keyword_vi'] = $meta_keyword_vi;
$arrData['meta_keyword_en'] = $meta_keyword_en;
$table = "product";
if ($id > 0) {
    $arrData['id'] = $id;
    $arrData['updated_at'] = time();
    $model->update($table, $arrData);
} else {
    $arrData['created_at'] = time();
    $arrData['updated_at'] = time();
    $id = $model->insert($table, $arrData);
}
mysql_query("DELETE FROM product_cate WHERE product_id = {$id}");
if (!empty($cateIdArr)) {
    foreach ($cateIdArr as $cate_id_str) {
        $tmp = explode("-", $cate_id_str);
        $parent_id_a = $tmp[0];
        $cate_id = $tmp[1];
        $arrDataCate['cate_id'] = $cate_id;
        $arrDataCate['product_id'] = $id;
        $arrDataCate['parent_id'] = $parent_id_a;
        $model->insert('product_cate', $arrDataCate);
    }
}
header('location:' . $list_url . "&cate_type_id=" . $cate_type_id);

    $arrRe = $model->uploadImages($icon_url_upload);
    $icon_url = $arrRe['filename'];
} else {
    $icon_url = str_replace('../', '', $_POST['icon_url']);
}
$arrData['icon_url'] = $icon_url;
if ($id > 0) {
    $arrData['id'] = $id;
    $model->update('cate', $arrData);
    $url_id = $model->getUrlId($id, 1);
    // 1 : cate
    if ($url_id > 0) {
        $model->updateAlias($url_id, $cate_alias);
    } else {
        $model->insertAlias($cate_alias, $id, 1);
    }
    $model->updateCate($id, $cate_name, $cate_alias, $parent_id, $cate_type_id, $image_url, $icon_url, $content, $is_hot, $display_order, $meta_title, $meta_description, $meta_keyword, $hidden, $seo_text, $seo_title);
    if ($parent_id > 0) {
        header('location:../index.php?mod=cate&act=list-child&parent_id=' . $parent_id);
    } else {
        header('location:' . $url . '&cate_type_id=' . $cate_type_id);
    }
} else {
    $id = $model->insert('cate', $arrData);
    $model->insertAlias($cate_alias, $id, 1);
    if ($parent_id > 0) {
        header('location:../index.php?mod=cate&act=list-child&parent_id=' . $parent_id);
    } else {
        header('location:' . $url . '&cate_type_id=' . $cate_type_id);
    }
}