Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = 'localhost';
- $db = '';
- $user = '';
- $pass = '';
- $charset = 'utf8';
- $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
- $pdo = new PDO($dsn, $user, $pass);
- $stmt = $pdo->query("SELECT * FROM task WHERE id_t = ".$_GET['id']."");
- while ($row = $stmt->fetch()) {
- if ($row['process_t'] == $_POST['process_t']) {
- $pdo = new PDO($dsn, $user, $pass);
- $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']."'";
- }
- else {
- $stmt2 = $pdo->query("SELECT * FROM stages limit 1");
- while ($row2 = $stmt2->fetch()) {
- $pdo = new PDO($dsn, $user, $pass);
- $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']."'";
- }
- }
- }
- $pdo->exec($s1);
- header("Location: /taskedit/?done&id=".$_POST['id']."");
- ?>
Add Comment
Please, Sign In to add comment