Guest User

Untitled

a guest
Nov 24th, 2018
321
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. <?php
  2. $host = 'localhost';
  3. $db = '';
  4. $user = '';
  5. $pass = '';
  6. $charset = 'utf8';
  7. $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
  8. $pdo = new PDO($dsn, $user, $pass);
  9. $stmt = $pdo->query("SELECT * FROM task WHERE id_t = ".$_GET['id']."");
  10. while ($row = $stmt->fetch()) {
  11. if ($row['process_t'] == $_POST['process_t']) {
  12. $pdo = new PDO($dsn, $user, $pass);
  13. $s1="UPDATE task SET name_t='".$_POST['name_t']."', desc_t='".$_POST['desc_t']."', process_t='".$_POST['process_t']."', status_t='".$_POST['status_t']."', client_t='".$_POST['user_id']."' WHERE id_t='".$_POST['id']."'";
  14. }
  15. else {
  16. $stmt2 = $pdo->query("SELECT * FROM stages limit 1");
  17. while ($row2 = $stmt2->fetch()) {
  18. $pdo = new PDO($dsn, $user, $pass);
  19. $s1="UPDATE task SET name_t='".$_POST['name_t']."', desc_t='".$_POST['desc_t']."', process_t='".$_POST['process_t']."', status_t='".$row2['status_t']."', client_t='".$_POST['user_id']."' WHERE id_t='".$_POST['id']."'";
  20. }
  21. }
  22. }
  23. $pdo->exec($s1);
  24. header("Location: /taskedit/?done&id=".$_POST['id']."");
  25. ?>
Add Comment
Please, Sign In to add comment