edit don't work
Posted: Thu Jun 23, 2011 2:19 pm
Hello everyone! I wrote code that does not work, and not know what went wrong!
If anyone knows what the problem, help is welcome! Its function should be a modification of the data entered into the database! Thanks in advance!
Code: Select all
<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');
$prostorija="";
$kolona="";
$red="";
include "connect_to_mysql.php";
if(!isset($_POST['submit'])){
$qlr = "SELECT * FROM knjige WHERE ID = $_GET[id]";
$rezultat = mysql_query($qlr);
$redovi = mysql_fetch_array($rezultat);
}
?>
<html>
<title>Promena podataka</title>
<body>
<div align="center" id="mainWrapper">
<?php include_once("../baner.php");?>
<div id="pageContent"><br />
<div align="right" style="margin-right:32px;"><a href="pokusaj.php#inventoryForm">+ Dodaj novu knjigu</a></div>
<div align="left" style="margin-left:24px;">
<h2>Lista knjiga</h2>
</div>
<hr />
<a name="inventoryForm" id="inventoryForm"></a>
<h3>
↓ Promena podataka o knjizi ↓
</h3>
<form action="pokusaj_edit.php" enctype="multipart/form-data" name="myForm" id="myform" method="post"> <p><strong>Unesite podatke knjige za unos u biblioteku:</strong></p>
<p><em><strong>Ime knjige:
<input name="nazivdela" type="text" value-"<?php echo $redovi['nazivdela'];?>"/>
</strong></em></p>
<p><em><strong>
Prezime autora:
<input name="prezimeautora" type="text" value-"<?php echo $redovi['prezimeautora'];?>" />
</strong></em></p>
<p><em><strong>Ime autora:
<input name="imeautora" type="text" value-"<?php echo $redovi['imeautora'];?>"/>
</strong></em></p>
<p><em><strong>Izdavac:
<input name="izdavac" type="text" value-"<?php echo $redovi['izdavac'];?>"/>
</strong></em></p>
<p>
<p><em><strong>Godina izdavanja:
<input name="godinaizdavanja" type="text"value-"<?php echo $redovi['godinaizdavanja'];?>" />
</strong></em></p>
<p>
<p><em><strong>ISBN broj:
<input name="ISBNbroj" type="text" value-"<?php echo $redovi['ISBNbroj'];?>"/>
</strong></em></p>
<p>
<p><em><strong>Mesto izdavanja:
<input name="mestoizdavanja" type="text" value-"<?php echo $redovi['mestoizdavanja'];?>"/>
</strong></em></p>
<p>
<p><em><strong>Oblst:
<input name="oblast" type="text" value-"<?php echo $redovi['oblast'];?>"/>
</strong></em></p>
<p><em><strong>Podoblast:
<input name="podoblast" type="text" value-"<?php echo $redovi['podoblast'];?>"/>
</strong></em></p>
<p>
<p><em><strong>Prostorija:<label>
<select name="prostorija"id="prostorija">
<option value="prostorija"><?php echo $prostorija; ?></option>
<option value="Prva prostorija">Prva prostorija</option>
<option value="Druga prostorija">Druga prostorija</option>
<option value="Treca prostorija">Treca prostorija</option>
<option value="Cetvrta prostorija">Cetvrta prostorija</option>
</select>
</label>
</strong></em></p>
<p><em><strong>Kolona:<label>
<select name="kolona"id="kolona">
<option value="kolona"><?php echo $kolona; ?></option>
<option value="Prva kolona">Prva kolona</option>
<option value="Druga kolona">Druga kolona</option>
<option value="Treca kolona">Treca kolona</option>
<option value="Cetvrta kolona">Cetvrta kolona</option>
</select>
</label>
</strong></em></p>
<p>
<p><em><strong>Red:<label>
<select name="red"id="red">
<option value="red"><?php echo $red; ?></option>
<option value="Prvi red">Prvi red</option>
<option value="Drugi red">Drugi red</option>
<option value="Treci red">Treci red</option>
<option value="Cetvrti red">Cetvrti red</option>
</select>
<option value="Treci red">Peti red</option></select>
<option value="Cetvrti red">Sesti red</option></select>
</label>
</strong></em></p>
<input type="hidden"name="id"value="<?php $_GET['id']; ?>"/>
<input type="submit" name="submit" type="promeni"/>
</form>
<?php
if(isset($_POST['submit'])){
$unos = "UPDATE knjige SET nazivdela='$_POST[nazivdela]',prezimeautora='$_POST[prezimeautora] , imeautora='$_POST[imeautora], izdavac='$_POST[izdavac], ISBNbroj='$_POST[ISBNbroj], godinaizdavanja='$_POST[godinaizdavanja], mestoizdavanja='$_POST[mestoizdavanja], oblast='$_POST[obalst], podoblast='$_POST[podoblast], pozicija='$_POST[pozicija], prostorija='$_POST[prostorija], kolona='$_POST[kolona], red='$_POST[red] WHERE ID = $_POST[id]";
mysql_query($unos) or die(mysql_error());
echo "Promenjeni su podaci knjige!";
header("Location: pokusaj.php");
}
?>
<br />
<br />
</div>
</div>
</body>
</html>