API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 11th, 2018
530
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.14 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. try {
  3.  
  4.  
  5. $tabela = isset($_GET['tabela']) ? $_GET['tabela'] : '';
  6. $id = isset($_GET['id']) ? $_GET['id'] : '';
  7.  
  8. if(empty($tabela) OR empty($id)){
  9. header("location: index.php");
  10. exit;
  11.  
  12.  
  13. }else{
  14.  
  15.  
  16. session_start();
  17.  
  18. require 'config.php';
  19.  
  20.  
  21. if(isset($_SERVER['REQUEST_METHOD']) && ($_SERVER['REQUEST_METHOD']) == 'POST' && !empty($tabela)){
  22.  
  23. if($_SESSION['logado'] != 'opadmin@gmail.com'){
  24.  
  25. //pega o user da sessao pra nmao ter probela
  26. $op = explode('@',$_SESSION['logado']);
  27. $op=$op[0];
  28. //var_dump($_SESSION['logado'],$op[0], $tabela, $_POST['item'], $_POST[$op], $op);die;
  29. //ta aqui o problema alias vc tem a virgula depois do id, e aqui nao ta indo o item
  30. $stmt = $pdo->prepare("update {$tabela} SET item =:item, {$op} = :op WHERE id = :id");
  31. $stmt->bindValue(":op", $_POST[$op]);
  32. $stmt->bindValue(":item", $_POST['item']);
  33.  
  34.  
  35. }else{
  36. $stmt = $pdo->prepare("update {$tabela} SET item = :item, op1= :op1, op2= :op2, op3= :op3, op4= :op4, op5= :op5, op6= :op6, op7= :op7, op8= :op8, op9= :op9, op10= :op10, op11= :op11, op12= :op12 WHERE id = :id ");
  37. $stmt->bindValue(":item", $_POST['item']);
  38. $stmt->bindValue(":op1", $_POST['op1']);
  39. $stmt->bindValue(":op2", $_POST['op2']);
  40. $stmt->bindValue(":op3", $_POST['op3']);
  41. $stmt->bindValue(":op4", $_POST['op4']);
  42. $stmt->bindValue(":op5", $_POST['op5']);
  43. $stmt->bindValue(":op6", $_POST['op6']);
  44. $stmt->bindValue(":op7", $_POST['op7']);
  45. $stmt->bindValue(":op8", $_POST['op8']);
  46. $stmt->bindValue(":op9", $_POST['op9']);
  47. $stmt->bindValue(":op10", $_POST['op10']);
  48. $stmt->bindValue(":op11", $_POST['op11']);
  49. $stmt->bindValue(":op12", $_POST['op12']);
  50. }
  51.  
  52.  
  53. $stmt->bindValue(":id", $id);
  54.  
  55.  
  56.  
  57. if($stmt->execute()){
  58. $_SESSION['success'] = "Dados atualizados com sucesso!";
  59. header("location: index.php");
  60. exit();
  61. }else{
  62. $_SESSION['error'] = "ERRO! Os dados no foram atualizados";
  63. header("location: index.php");
  64. exit();
  65. }
  66.  
  67. }
  68.  
  69.  
  70. $sql = "SELECT * FROM {$tabela} WHERE id ='$id'";
  71.  
  72.  
  73.  
  74. $sql =$pdo->query($sql);
  75. if($sql->rowCount() >0) {
  76. $dado = $sql->fetch();
  77.  
  78. }else{
  79. header ("Location: index.php");
  80. }
  81. $usuario = $_SESSION['logado'];
  82.  
  83.  
  84.  
  85.  
  86.  
  87. ?>
  88. <div class="container">
  89. <form method="POST" style="margin-top:100px;margin-left:200px">
  90.  
  91. <?php
  92.  
  93. switch($usuario){
  94.  
  95. case $usuario == 'op1@gmail.com':
  96.  
  97.  
  98. ?>
  99.  
  100. <label>Qnt</label>
  101. <input name="op1" type="text" value="<?php echo $dado['op1'] ? $dado['op1'] : ''; ?>"/>
  102. <label>Item</label>
  103. <input name="item" type="text" id="teste" readonly style="background-color: #FF0000;" value="<?php echo $dado['item'] ? $dado['item'] : ''; ?>"/>
  104.  
  105. <?php
  106. break;
  107.  
  108.  
  109.  
  110.  
  111.  
  112.  
  113. ?>
  114.  
  115. <?php case $usuario == 'op2@gmail.com': ?>
  116. <label>op2</label>
  117. <input name="op2" type="text" value="<?php echo $dado['op2'] ? $dado['op2'] : ''; ?>"/>
  118. <label>Item</label>
  119. <input name="item" type="text" value="<?php echo $dado['item'] ? $dado['item'] : ''; ?>"/>
  120. <?php
  121. break;
  122.  
  123.  
  124.  
  125.  
  126. case $usuario == 'op3@gmail.com':
  127. ?>
  128. <label>op1</label>
  129. <input name="op3" type="text" value="<?php echo $dado['op3'] ? $dado['op3'] : ''; ?>"/>
  130. <label>Item</label>
  131. <input name="item" type="text" value="<?php echo $dado['item'] ? $dado['item'] : ''; ?>"/>
  132. <?php
  133. break;
  134.  
  135. case $usuario == 'op4@gmail.com':
  136. ?>
  137. <label>op4</label>
  138. <input name="op4" type="text" value="<?php echo $dado['op4'] ? $dado['op4'] : ''; ?>"/>
  139. <label>Item</label>
  140. <input name="item" type="text" value="<?php echo $dado['item'] ? $dado['item'] : ''; ?>"/>
  141. <?php
  142. break;
  143.  
  144. case $usuario == 'op5@gmail.com':
  145. ?>
  146. <label>op5</label>
  147. <input name="op5" type="text" value="<?php echo $dado['op5'] ? $dado['op5'] : ''; ?>"/>
  148. <label>Item</label>
  149. <input name="item" type="text" value="<?php echo $dado['item'] ? $dado['item'] : ''; ?>"/>
  150.  
  151. <?php
  152. break;
  153.  
  154. case $usuario == 'op6@gmail.com':
  155. ?>
  156. <label>op6</label>
  157. <input name="op6" type="text" value="<?php echo $dado['op6'] ? $dado['op6'] : ''; ?>"/>
  158. <label>Item</label>
  159. <input name="item" type="text" value="<?php echo $dado['item'] ? $dado['item'] : ''; ?>"/>
  160. <?php
  161. break;
  162.  
  163. case $usuario == 'op7@gmail.com':
  164. ?>
  165. <label>op7</label>
  166. <input name="op7" type="text" value="<?php echo $dado['op7'] ? $dado['op7'] : ''; ?>"/>
  167. <label>Item</label>
  168. <input name="item" type="text" value="<?php echo $dado['item'] ? $dado['item'] : ''; ?>"/>
  169. <?php
  170. break;
  171.  
  172. case $usuario == 'op8@gmail.com':
  173. ?>
  174. <label>op8</label>
  175. <input name="op8" type="text" value="<?php echo $dado['op8'] ? $dado['op8'] : ''; ?>"/>
  176. <label>Item</label>
  177. <input name="item" type="text" value="<?php echo $dado['item'] ? $dado['item'] : ''; ?>"/>
  178. <?php
  179. break;
  180.  
  181. case $usuario == 'op9@gmail.com':
  182. ?>
  183. <label>op9</label>
  184. <input name="op9" type="text" value="<?php echo $dado['op9'] ? $dado['op9'] : ''; ?>"/>
  185. <label>Item</label>
  186. <input name="item" type="text" value="<?php echo $dado['item'] ? $dado['item'] : ''; ?>"/>
  187. <?php
  188. break;
  189.  
  190. case $usuario == 'op10@gmail.com':
  191. ?>
  192. <label>op1</label>
  193. <input name="op10" type="text" value="<?php echo $dado['op10'] ? $dado['op10'] : ''; ?>"/>
  194. <label>Item</label>
  195. <input name="item" type="text" value="<?php echo $dado['item'] ? $dado['item'] : ''; ?>"/>
  196. <?php
  197. break;
  198.  
  199. case $usuario == 'op11@gmail.com':
  200. ?>
  201. <label>op1</label>
  202. <input name="op11" type="text" value="<?php echo $dado['op11'] ? $dado['op11'] : ''; ?>"/>
  203. <label>Item</label>
  204. <input name="item" type="text" value="<?php echo $dado['item'] ? $dado['item'] : ''; ?>"/>
  205. <?php
  206. break;
  207.  
  208.  
  209. case $usuario == 'op12@gmail.com':
  210. ?>
  211. <label>op12</label>
  212. <input name="op12" type="text" value="<?php echo $dado['op12'] ? $dado['op12'] : ''; ?>"/>
  213. <label>Item</label>
  214. <input name="item" type="text" value="<?php echo $dado['item'] ? $dado['item'] : ''; ?>"/>
  215. <?php
  216. break;
  217.  
  218.  
  219.  
  220.  
  221.  
  222.  
  223. case $usuario == 'opadmin@gmail.com':
  224. ?>
  225. <label>op1</label>
  226. <input name="op1" type="text" value="<?php echo $dado['op1'] ? $dado['op1'] : ''; ?>"/>
  227. <label>item</label>
  228. <input name="item" type="text" value="<?php echo $dado['item'] ? $dado['item'] : ''; ?>"/>
  229. <label>op2</label>
  230. <input name="op2" type="text" value="<?php echo $dado['op2'] ? $dado['op2'] : ''; ?>"/>
  231. <label>op3</label>
  232. <input name="op3" type="text" value="<?php echo $dado['op3'] ? $dado['op3'] : ''; ?>"/>
  233. <label>op1</label>
  234. <input name="op4" type="text" value="<?php echo $dado['op4'] ? $dado['op4'] : ''; ?>"/>
  235. <label>op1</label>
  236. <input name="op5" type="text" value="<?php echo $dado['op5'] ? $dado['op5'] : ''; ?>"/>
  237. <label>op1</label>
  238. <input name="op6" type="text" value="<?php echo $dado['op6'] ? $dado['op6'] : ''; ?>"/>
  239. <label>op1</label>
  240. <input name="op7" type="text" value="<?php echo $dado['op7'] ? $dado['op7'] : ''; ?>"/>
  241. <label>op8</label>
  242. <input name="op8" type="text" value="<?php echo $dado['op8'] ? $dado['op8'] : ''; ?>"/>
  243. <label>op9</label>
  244. <input name="op9" type="text" value="<?php echo $dado['op9'] ? $dado['op9'] : ''; ?>"/>
  245. <label>op1</label>
  246. <input name="op10" type="text" value="<?php echo $dado['op10'] ? $dado['op10'] : ''; ?>"/>
  247. <label>op11</label>
  248. <input name="op11" type="text" value="<?php echo $dado['op11'] ? $dado['op11'] : ''; ?>"/>
  249. <label>op12</label>
  250. <input name="op12" type="text" value="<?php echo $dado['op12'] ? $dado['op12'] : ''; ?>"/>
  251.  
  252. <?php
  253. break;
  254.  
  255. }
  256.  
  257. } catch (PDOException $e) {
  258. header ("Location: index.php");
  259. }
  260. ?>
  261.  
  262. <input class="btn btn-primary btn-xs" type="submit" value="Atualizar"/>
  263.  
  264.  
  265. </form>
  266. <link rel="stylesheet" href="bootstrap.min.css">
  267. <script src="bootstrap.min.js"></script>
  268. <script src="jquery.min.js"></script>
  269. <div class="form-group">
  270. <link rel="stylesheet" href="../style.css">
  271. <button style="margin-left:230px; margin-right:-120px;" class="btn btn-primary btn-xs" id="teste1" onclick="function()">Habilitar Edição Item</button>
  272. <button style="margin-left:200px" class="btn btn-primary btn-xs" id="teste2" onclick="function()">Desabilitar Edição Item</button>
  273. <a href="index.php"><button style="margin-left:5px" class="btn btn-primary btn-xs" id="teste2" onclick="function()">Voltar</button></a>
  274. </div>
  275. </div>
  276. <script>
  277.  
  278. $(document).ready(function() {
  279. $("#teste1").click(function (){
  280. // habilita o campo
  281. $("#teste").prop("readonly", false);
  282. $('#teste').css("background-color", "#00FF7F");
  283.  
  284. });
  285.  
  286. $("#teste2").click(function (){
  287. // desabilita o campo
  288. $("#teste").prop("readonly", true);
  289. $('#teste').css("background-color", "#FF0000");
  290. $('#teste').focus();
  291. return false;
  292.  
  293. });
  294. });
  295.  
  296. </script>
  297.  
  298.  
  299. <?php
  300.  
  301. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!