Управление сайтом

Компаний

Пользователи

Фиксированные новости

Отзывы о фирмах

Пользователи

Банкоматы

Торговые точки

Доска объявлений

Курсы валют

организации Орла

организации области

сайты Орел

Поиск запросы

Статистика

Показы каталога организаций

Статистика клиенты

Пользователи

Управление сайтом

Каталоги >

Новости >

Организации >

Секрет фирмы >

Сервисы >

Файловый менеджер

Имя файла	bk_sql.php
Содержимое	<?php /* This file has been created on Tue Apr 29 10:25:51 MSD 2008 */ $base_url="../"; require_once($base_url."../func.php"); $l = db_connect(); if ($_SERVER['REQUEST_METHOD'] == 'POST'){ //prepare POST $_POST['id'] = intval($_POST['id']); $_POST['id_bank'] = intval($_POST['id_bank']); $_POST['id_city'] = intval($_POST['id_city']); $_POST['name'] = mysql_real_escape_string($_POST['name']); $_POST['address'] = mysql_real_escape_string($_POST['address']); $_POST['id_home'] = intval($_POST['id_home']); $_POST['phone'] = mysql_real_escape_string($_POST['phone']); $_POST['work_days'] = intval($_POST['work_days']); $_POST['work_hours'] = mysql_real_escape_string($_POST['work_hours']); $_POST['break'] = mysql_real_escape_string($_POST['break']); $_POST['paid'] = intval($_POST['paid']); $_POST['mobile'] = intval($_POST['mobile']); $_POST['transfer'] = intval($_POST['transfer']); $_POST['status'] = intval($_POST['status']); if ($_POST['id'] == ''){ //addition actions //insert action $r_ins = sql("INSERT INTO `bk` VALUES (NULL, '".$_POST['id_city']."', '".$_POST['id_bank']."', '" . $_POST['name'] . "', '".$_POST['address']."', '".$_POST['id_home']."', '".$_POST['phone'] ."', '".$_POST['work_days']."', '".$_POST['work_hours']."', '".$_POST['break']."', '".$_POST['paid']."', '" . $_POST['mobile'] . "', '" . $_POST['transfer'] . "', '".$_POST['date']."', '".$_POST['status']."')"); if (!$r_ins){ error(); } $last_id = mysql_insert_id($l); if (is_array($_POST['cards'])) { $query = ''; foreach ($_POST['cards'] as $card) { $query .= '(' . $last_id . ',' . $card . '),'; } $query = substr($query, 0, strlen($query) - 1); $r_ins = sql("INSERT INTO `bkLink` VALUES " . $query); if (!$r_ins) { error(); } } }else if ($_POST['id'] != ''){ //addition actions //update action $r_upd = sql("UPDATE `bk` SET `idCity` = '" . $_POST['id_city'] . "', `idBank` = '" . $_POST['id_bank'] . "', `name` = '" . $_POST['name'] . "', `address` = '" . $_POST['address'] . "', `idHome` = '" . $_POST['id_home'] . "', `phone` = '" . $_POST['phone'] . "', `workDays` = '" . $_POST['work_days'] . "', `workHours` = '" . $_POST['work_hours'] . "', `break` = '" . $_POST['break'] . "', `paid` = '" . $_POST['paid'] . "', `mobile` = '" . $_POST['mobile'] . "', `transfer` = '" . $_POST['transfer'] . "', `date` = '" . $_POST['date'] . "', `status` = '" . $_POST['status'] . "' WHERE `id` = '" . $_POST['id'] . "' "); if (!$r_upd){ error(); } $r_card = sql("SELECT `idCard` FROM `bkLink` WHERE `idBk`='" . $_POST['id'] . "'"); if (!$r_card) { error(); } while ($rs_card = sqlget($r_card)) { $old_cards[] = $rs_card['idCard']; } $cards_ins = array_diff($_POST['cards'], $old_cards); $query = ''; if (is_array($cards_ins)) { foreach ($cards_ins as $card) { $query .= '(' . $_POST['id'] . ',' . $card . '),'; } $query = substr($query, 0, strlen($query) - 1); $r_ins = sql("INSERT INTO `bkLink` VALUES " . $query); if (!$r_ins) { error(); } } $cards_del = array_diff($old_cards, $_POST['cards']); $query = ''; foreach ($cards_del as $card) { $r_del = sql("DELETE FROM `bkLink` WHERE `idBk`='" . $_POST['id'] . "' AND `idCard`='" . $card . "'"); if (!$r_del) { error(); } } } } else if ($_SERVER['REQUEST_METHOD'] == 'GET') { //prepare GET $_GET['id'] = intval($_GET['id']); if ($_GET['id'] != '' && $_GET['delete'] == '1' && $_GET['is_js_confirmed'] == '1'){ //addition actions //delete action $r_del = sql("DELETE FROM `bk` WHERE `id` = '".$_GET['id']."'"); if (!$r_del){ error(); } $r_del = sql("DELETE FROM `bkLink` WHERE `idBk` = '".$_GET['id']."'"); if (!$r_del){ error(); } } } Header("Location: bk.php"); exit(0); ?>

/admin/bk/

Имя	Дата	Размер
..	2026-10-02
bank.php	2008-05-12	3 кб.
bk.php	2010-12-15	5 кб.
bk_modif.php	2010-05-14	9 кб.
bk_sql.php	2008-05-12	4 кб.
cards.php	2008-05-12	5 кб.
city.php	2010-05-14	4 кб.

/admin/bk