function formUserData($userArr)
{
foreach ($userArr as $ustreamUID) {
$tempArr = selectAll($ustreamUID);
$channel = getChannel($ustreamUID);
$tempArr[0]['channel'] = $channel;
$userData[] = $tempArr[0];
}
return $userData;
}
function selectAll($dbtree, $id_category = null, $str = array())
{
$subcats = $dbtree->GetSubCats($id_category, array('id_category', 'category_level', 'category_img', 'name', 'translit', 'art', 'pid', 'visible'));
if ($id_category != 0) {
$str[] = $id_category;
}
if (!empty($subcats)) {
foreach ($subcats as $val) {
$str = selectAll($dbtree, $val["id_category"], $str);
}
}
return $str;
}
function selectFromUser($predicate)
{
global $db;
$mysqli = new mysqli($db['host'], $db['user'], $db['pass'], $db['dbname']);
//$mysqli = new mysqli($db['host'], $db['user'], $db['pass'], $db['dbname'], $db['port'], $db['sock']);
$result;
if ($predicate == "") {
$result = selectAll($mysqli);
} else {
$result = selectUserWhereName($mysqli, $predicate);
}
$mysqli->close();
return $result;
}
function db()
{
if ($_GET['action'] == 'clear') {
mysql_query('Truncate Table member');
header('location:index.php?method=db');
exit;
}
if (!$_POST) {
$error = trim($_GET['error']);
$datas = selectAll();
include 'db_exam.html';
} else {
$post = $_POST;
$info['name'] = trim($post['name']);
$info['sex'] = trim($post['sex']);
if (!$info['name'] || !$info['name']) {
header('location:index.php?method=db&error=' . '请输入姓名 和 性别!');
exit;
}
$sql = "INSERT INTO `member` (`id`, `name`, `sex`) VALUES (NULL, '{$info[name]}', '{$info[sex]}');";
$query = mysql_query($sql);
header('location:index.php?method=db');
}
}
<?php include "model.php"; $resultats = selectAll(); // on peut ecrire tout code traitement des données. //appel de la vue include "vue.php"; ?>
<?
include 'models/selects.php';
include 'models/deletes.php';
if(isset($_REQUEST['id'])){
if($_REQUEST['id'] == 'delete'){
$table = 'blog_form';
$where = 'id="'.$_REQUEST['id2'].'"';
$deleteData = deleteRow($table,$where,$db_location, $db_user,$db_pass,$db_db);
}
}
if(selectAll('blog_form',$db_location, $db_user,$db_pass,$db_db)){
$theData = selectAll('blog_form',$db_location, $db_user,$db_pass,$db_db);
foreach($theData as $value){
$ids[] = $value['id'];
$title[] = $value['title'];
}
}else{
$data['id'] = 'error';
}
?>
<div id="contact_container">
Admin Blog Page
<? if(isset($deleteData)){?>
<h2><?php
echo $deleteData;
?>
</h2>
<? }?>
<hr /><br />
<div class="col-lg-12">
<p>Товаров в корзине:</a><?php
echo ' ' . $count;
?>
</p> <!-- (сылка на файл с корзиной что-бы можно было туда зайти) переменная создана в db.inc.php для хранения товара в корзине -->
<table class="table-bordered" width="100%" border="1" cellpadding="5" cellspacing="0">
<tr>
<th><p align="center">Автор</p></th>
<th><p align="center">Название</p></th>
<th><p align="center">Год выпуска</p></th>
<th><p align="center">Цена, грн.</p></th>
<th><p align="center">В корзину</p></th>
</tr>
<?php
//создаем переменную содержащюю все наименование товара
$goods = selectAll();
// вызываем функцию которая выбрала у нас все из таблици с товаром в файле libs.inc.php
//теперь $goods многомерный массив
foreach ($goods as $item) {
?>
<tr>
<td><?php
echo $item["author"];
?>
</td>
<td><?php
echo $item["title"];
?>
</td>
<td><?php
echo $item["pubyear"];
<?php
//---------------------------
// programmer: Mahdipour
// create Date: 90.09
//---------------------------
require_once '../../../header.inc.php';
require_once '../class/tax_tables.class.php';
require_once inc_response;
require_once inc_dataReader;
$task = isset($_POST["task"]) ? $_POST["task"] : (isset($_GET["task"]) ? $_GET["task"] : "");
switch ($task) {
case "selectAll":
selectAll();
case "saveTax":
saveTax();
case "deleteTax":
deleteTax();
}
function selectAll()
{
$where = " where (1=1)";
if ($_GET["tax_table_type_id"] != "") {
$where .= " AND tax_table_type_id=:ttid ";
$whereParam[":ttid"] = $_GET["tax_table_type_id"];
}
$where .= dataReader::makeOrder();
$temp = manage_Tax_Table::GetAll($_GET["tax_table_type_id"], $where, $whereParam);
$no = count($temp);
$temp = array_slice($temp, $_GET["start"], $_GET["limit"]);
echo dataReader::getJsonData($temp, $no, $_GET["callback"]);
function selectAllFrom($table)
{
$query = selectAll() . from($table);
return $query;
}
if (in_array($action, $requiredMessageActions) && strlen($messagesIds) == 0) {
header("Location: {$url}?page={$current_page}&error_message=0");
die;
}
switch ($action) {
case 'read':
readMessages($messagesIds);
break;
case 'unread':
unreadMessages($messagesIds);
break;
case 'delete':
deleteMessages($messagesIds);
break;
case 'selectall':
$select_all = selectAll($_POST['page']);
header("Location: {$url}?page={$current_page}&select_all={$select_all}");
die;
break;
case 'nothing':
header("Location: {$url}?page={$current_page}&error_message=1");
die;
break;
default:
break;
}
header("Location: {$url}?page={$current_page}");
function readMessages($messages)
{
$mbox = getMbox();
$messages = uidToSecuence($mbox, $messages);
function inquiry($sale_code, $end_date)
{
global $menu2, $thead, $menu, $extColor, $tabColor, $thColor;
$objResponse = new xajaxResponse();
$style[1000] = ' style="width:4%;background-color:' . $extColor . ';"';
$selTab[11001] = ' style="width:24%;"';
$selTab[11002] = ' style="width:24%;"';
$selTab[1001] = ' style="width:24%;"';
$selTab[1002] = ' style="width:24%;"';
// $selTab[$exps_code]=' style="font-weight: bolder;background-color:'.$tabColor.';width:24%;"';
$selClass[$sale_code] = ' class="tabS"';
$sCol[11001] = 'color:#FFFFFF;';
$sCol[11002] = 'color:#FFFFFF;';
$sCol[1001] = 'color:#FFFFFF;';
$sCol[1002] = 'color:#FFFFFF;';
$sCol[$sale_code] = 'color:' . $thColor . ';';
$setTime = $end_date;
if (session_is_registered('reg_date')) {
$date_input = str_replace("-", "", $end_date);
// '-' 제거
$_SESSION['session_reg_date'] = $date_input;
}
$menuDiv = '<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" align="center"' . $style[1000] . '></td>
<td width="150" height="30" align="center" ' . $selTab[11001] . '><div ' . $selClass[11001] . '><a href="report.php"><span style="' . $sCol[11001] . '">일매출전체(피부과)</span></a></div></td>
<td width="150" height="30" align="center" ' . $selTab[1001] . '><div ' . $selClass[1001] . '><a href="#" onclick="xajax_inquiry(1001,\'' . $end_date . '\')"><span style="' . $sCol[1001] . '">일매출병원(피부과)</span></a></div></td>
<td width="150" height="30" align="center" ' . $selTab[11002] . '><div ' . $selClass[11002] . '><a href="#" onclick="xajax_inquiry(11002,\'' . $end_date . '\')"><span style="' . $sCol[11002] . '">일매출병원(코스메틱)</span></a></div></td>
<td width="150" height="30" align="center" ' . $selTab[1002] . '><div ' . $selClass[1002] . '><a href="#" onclick="xajax_inquiry(1002,\'' . $end_date . '\')"><span style="' . $sCol[1002] . '">일매출전체(코스메틱)</span></a></div></td>
<td width="100" height="30" align="center" class="box_Bottomline"> </td>
</tr>
</table>';
$m = substr($end_date, 5, 2);
$start_date = date("Y-m-d", mktime(0, 0, 0, $m, 1, substr($end_date, 0, 4)));
$query = "inquiry" . $start_date . $end_date . ' ' . $m;
$objResponse->assign('date_start', 'value', $start_date);
$objResponse->assign('date_end', 'value', $end_date);
$objResponse->assign('sale_code', 'value', $sale_code);
$start_date = str_replace("-", "", $start_date);
// '-' 제거
$end_date = str_replace("-", "", $end_date);
// '-' 제거
if ($sale_code > 10000) {
$updated = $thead[$sale_code] . '<tbody>';
$sale_code = $sale_code - 10000;
$updated = $updated . selectAll($sale_code, $start_date, $end_date) . '</table>';
} else {
$updated = selectSale($sale_code, $start_date, $end_date) . '</table>';
}
// $objResponse->assign('div2', 'innerHTML', $date_input);
$objResponse->assign('content', 'innerHTML', $updated);
$objResponse->call('bottom');
//div scolling
$objResponse->assign('menu', 'innerHTML', $menu);
$msg = $_SESSION['sunap'] . "님은 " . $setTime . "일자 자료입력 중입니다.";
$objResponse->assign('msgDiv', 'innerHTML', $msg);
$objResponse->assign('tabs2', 'innerHTML', $menuDiv);
return $objResponse;
}
<?
include 'models/selects.php';
if(selectAll($page,$db_location, $db_user,$db_pass,$db_db)){
$theData = selectAll($page,$db_location, $db_user,$db_pass,$db_db);
foreach($theData as $value){
$ids[] = $value['id'];
$zone_title[] = $value['zone_title'];
}
}else{
$data['id'] = 'error';
}
?>
<div id="contact_container">
Admin Home
<hr /><br />
<ul>
<strong>Please Select an area to edit</strong>
<? foreach($ids as $k=>$v):?>
<li>
<a href="<?php
echo $base_url;
?>
blogEdit/<?php
echo $v;
?>
"><?php
echo $zone_title[$k];
?>
</a>
</li>
function getKeys($nick, $conn = null, $client = null)
{
if ($conn) {
$sql = "select key_id as id, `key` from publickeys where login = '******' ;";
$keys = selectAll($sql, $conn);
} else {
if ($client) {
$keys = $client->api('user')->keys($nick);
}
}
return $keys;
}
echo $stmt->affected_rows;
$stmt->free_result();
$stmt->close();
}
try {
$host = 'localhost';
$dbname = 'testrest';
$user = '******';
$password = '******';
$db = new mysqli($host, $user, $password, $dbname);
switch ($_SERVER['REQUEST_METHOD']) {
case 'GET':
if (isset($_GET['id'])) {
selectById($db, $_GET['id']);
} else {
selectAll($db);
}
break;
case 'POST':
$data = json_decode(file_get_contents("php://input"));
insert($db, $data);
break;
case 'PUT':
if (isset($_GET['id'])) {
$data = json_decode(file_get_contents("php://input"));
update($db, $_GET['id'], $data);
}
break;
case 'DELETE':
if (isset($_GET['id'])) {
delete($db, $_GET['id']);
<?
include('settings.php');
include('dbconnector.php');
$sql_type = $_REQUEST['type'];
include '../models/inserts.php';
include '../models/selects.php';
include '../models/updates.php';
if(isset($sql_type)){
if($sql_type == 'selectall'){
$page = $_REQUEST['page'];
echo $page;
if(selectAll($page,$db_location, $db_user,$db_pass,$db_db)){
$data['id'] = selectAll($page,$db_location, $db_user,$db_pass,$db_db);
}else{
echo $data['id'] = 'error';
}
}
}
?>
<?
include 'models/selects.php';
$data = selectAll('home',$db_location, $db_user,$db_pass,$db_db);
foreach($data as $value){
$zone[] = $value['zone'];
$zone_title[] = $value['zone_title'];
$text[] = $value['data'];
}
?>
<div id="home_container">
<h1>HOME</h1>
<hr />
<h3><?php
echo $zone_title[0];
?>
</h3>
<p><?php
echo $text[0];
?>
</p>
<h3><?php
echo $zone_title[1];
?>
</h3>
<p><?php
echo $text[1];
?>
</p>
<?
include 'models/selects.php';
$data = selectAll('about',$db_location, $db_user,$db_pass,$db_db);
foreach($data as $value){
$zone[] = $value['zone'];
$zone_title[] = $value['zone_title'];
$text[] = $value['data'];
}
?>
<div id="about_container">
<h1>ABOUT</h1>
<hr />
<h3><?php
echo $zone_title[0];
?>
</h3>
<p><?php
echo $text[0];
?>
</p>
<h3><?php
echo $zone_title[1];
?>
</h3>
<p><?php
echo $text[1];
?>
</p>
<hr />
<?
include 'models/selects.php';
$data = selectAll('blog',$db_location, $db_user,$db_pass,$db_db);
foreach($data as $value){
$zone[] = $value['zone'];
$zone_title[] = $value['zone_title'];
$text[] = $value['data'];
}
?>
<div id="blog_container">
<h1>BLOG</h1>
<hr />
<h3><?php
echo $zone_title[0];
?>
</h3>
<p><?php
echo $text[0];
?>
</p>
<h3><?php
echo $zone_title[1];
?>
</h3>
<p><?php
echo $text[1];
?>
</p>
<hr />
* @package Example-application
*/
require './settings.php';
if (!empty($_POST)) {
$id = isset($_POST['id']) ? $_POST['id'] : '';
$currads = selectAll();
if (isset($_GET['action']) && $_GET['action'] == 'update' && isset($currads[$id])) {
$data = prepareData($_POST);
updateInDb($id, $data);
} else {
$data = prepareData($_POST);
insertToDb($data);
}
} elseif (isset($_GET['del'])) {
deleteFromDb((int) $_GET['del']);
} elseif (isset($_GET['edit']) && !isset($_GET['action'])) {
$data = selectById($_GET['edit']);
$formParam = prepareData($data);
}
if (!isset($formParam)) {
$formParam = prepareData();
}
$cities = get_cities();
$categories = get_categories();
$ads = selectAll();
$smarty->assign("cities", $cities);
$smarty->assign("categories", $categories);
// assoc array group => array
$smarty->assign("formParam", $formParam);
$smarty->assign("allads", $ads);
$smarty->display('index.tpl');
<?
include 'models/selects.php';
include 'models/inserts.php';
$data = selectAll('contact',$db_location, $db_user,$db_pass,$db_db);
foreach($data as $value){
$zone[] = $value['zone'];
$zone_title[] = $value['zone_title'];
$text[] = $value['data'];
}
?>
<div id="contact_container">
<h1>CONTACT<h1>
<hr />
<h3><?php
echo $zone_title[0];
?>
</h3>
<p><?php
echo $text[0];
?>
</p>
<h3><?php
echo $zone_title[1];
?>
</h3>
<p><?php
echo $text[1];
?>
</p>
