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>