[ igorkr @ 02.03.2015. 10:15 ] @
Zdravo, Update query neče da se izvrši. Problem je sa $id. U 10 liniju je echo $id; ok - ispiše pravu vrednost, ali u update query je $id prazan. Koda je: <?php session_start(); include_once 'conn.php'; if (!isset($_SESSION['user'])) header("Location: login.php"); if(isset($_SESSION['user'])) { $user = $_SESSION['user']; $pass = $_SESSION['pass']; $id = $_GET['id']; echo $id; if(isset($_POST['submit'])) { $var1 = mysql_escape_string($_POST['var1']); mysql_query("UPDATE table1 SET var1 = '$var1' WHERE id = '$id' LIMIT 1") or die(mysql_error()); header("Location: edit.php"); exit(); } include_once 'header.php'; $q = mysql_query("SELECT * FROM table1 WHERE id = '$id'") or die(mysql_error()); $r = mysql_fetch_object($q); ?> <form class="reg" method="post" action="edit.php?id=$id" enctype="multipart/form-data"> <input type="text" value= "<?php if (isset($_POST['var1'])) echo $_POST['var1']; else echo "$r->var1";?>" name="var1" class="sign-up" placeholder="Number 1"> <input type="submit" name="submit" value="Update" class="reg-button"> </form> <?php } include 'footer.php'; ?> </body> </html> Hvala, Igor |