IvRa

I arranged everything, and now everything is working properly! Thank you all. Thanks a lot.

Another typo! Sorry people!

Somehow I managed to correct all the mistakes and finally doing all right, but now i have a problem with the code that should search the database. It looks like this: <hr/> <?php include ("connect_to_mysql.php"); $k = $_GET['k']; $tearms=""; $terms = explode(" ", $k); $query = "SELECT * FROM knjige WHERE "; foreach ($tearms as $each){ $i++; if($i == 1) $query .= "nazivdela LIKE '%$each%' "; else $query .= "OR nazivdela LIKE '%$each%' "; } $query = mysql_query($query); $numrows = mysql_num_rows($query); if($numrows > 0){ while($row = mysql_fetch_assoc($query)){ $id = $row["id"]; $nazivdela = $row['nazivdela']; $prezimeautora = $row['prezimeautora']; $imeautora = $row['imeautora']; $ISBNbroj = $row["ISBNbroj"]; $izdavac = $row["izdavac"]; $oblast = $row["oblast"]; $podoblast = $row["podoblast"]; $prostorija = $row["prostorija"]; $pozicija = $row["pozicija"]; $godinaizdavanja = $row["godinaizdavanja"]; $mestoizdavanja = $row["mestoizdavanja"]; $kolona = $row["kolona"]; $red = $row["red"]; } } else{ echo "Nije pronadjena!";} mysql_close(); ?> </body> </html> Report error: Warning: Invalid argument supplied for foreach() in C:\xampp\htdocs\Rad\Pokusaj\pretrazivac.php on line 23 Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\Rad\Pokusaj\pretrazivac.php on line 35 Pls help!

I became totally blind! I corrected what you said to me, but when I try to enter an element throws an errors: Notice: Undefined index: pozicija in C:\xampp\htdocs\Rad\Pokusaj\pokusaj_edit.php on line 105 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Robert, izdavac='Laguna, ISBNbroj=', godinaizdavanja=', mestoizdavanja=', oblast' at line 1. And the following error in each input field: Notice: Uninitialized string offset: 0 in C:\xampp\htdocs\Rad\Pokusaj\pokusaj_edit.php on line 34 Notice: Uninitialized string offset: 0 in C:\xampp\htdocs\Rad\Pokusaj\pokusaj_edit.php on line 38 ... I tried to do data entry and the following, but here I have a problem ... My head will explode! : D <?php include ("connect_to_mysql.php"); // Script Error Reporting $listaknjiga=""; $nazivdela = ""; $prezimeautora = ""; $imeautora = ""; $ISBNbroj = ""; $oblast = ""; $podoblast = ""; $prostorija = ""; $pozicija = ""; $godinaizdavanja = ""; $mestoizdavanja = ""; $kolona = ""; $red = ""; $izdavac=""; $godinaizdavanja=""; error_reporting(E_ALL); ini_set('display_errors', '1'); ?> <?php // Parse the form data and add inventory item to the system if (isset($_POST['nazivknjige'])) { $id = mysql_real_escape_string($_POST['thisID']); $nazivdela= mysql_real_escape_string($_POST['nazivdela']); $prezimeautora = mysql_real_escape_string($_POST['prezimeautora']); $imeautora= mysql_real_escape_string($_POST['imeautora']); $ISBNbroj = mysql_real_escape_string($_POST['ISBNbroj']); $izdavac = mysql_real_escape_string($_POST['izdavac']); $oblast = mysql_real_escape_string($_POST['oblast']); $podoblast = mysql_real_escape_string($_POST['podoblast']); $prostorija = mysql_real_escape_string($_POST['prostorija']); $pozicija = mysql_real_escape_string($_POST['pozicija']); $godinaizdavanja = mysql_real_escape_string($_POST['godinaizdavanja']); $red = mysql_real_escape_string($_POST['red']); $kolona = mysql_real_escape_string($_POST['kolona']); $mestoizdavanja = mysql_real_escape_string($_POST['mestoizdavanja']); $pozicija="$kolona, $red"; // See if that product name is an identical match to another product in the system $sql = mysql_query("UPDATE products SET nazivdela='$nazivdela', prezimeautora='$prezimeautora', imeautora='$imeautora', ISBNbroj='$ISBNbroj', izdavac='$izdavac', godinaizdavanja='$godinaizdavanja', mestoizdavanja='$mestoizdavanja', oblast='$oblast',podoblast='$podoblast', prostorija='$prostorija',red='$red', kolona='$kolona', pozicija='$pozicija' WHERE id='$id'"); if ($_FILES['fileField']['tmp_name'] != "") { // Place image in the folder $newname = "$pid.jpg"; move_uploaded_file($_FILES['fileField']['tmp_name'], "../inventory_images/$newname"); } header("location: pokusaj.php"); exit(); } ?> <?php // Gather this product's full information for inserting automatically into the edit form below on page if (isset($_GET['pid'])) { $targetID = $_GET['pid']; $sql = mysql_query("SELECT * FROM knjige WHERE id='$targetID' LIMIT 1"); $productCount = mysql_num_rows($sql); // count the output amount if ($productCount > 0) { while($row = mysql_fetch_array($sql)){ $nazivdela = $row['nazivdela']; $prezimeautora = $row['prezimeautora']; $imeautora = $row['imeautora']; $ISBNbroj = $row["ISBNbroj"]; $oblast = $row["oblast"]; $izdavac = $row["izdavac"]; $podoblast = $row["podoblast"]; $prostorija = $row["prostorija"]; $pozicija = $row["pozicija"]; $godinaizdavanja = $row["godinaizdavanja"]; $mestoizdavanja = $row["mestoizdavanja"]; $kolona = $row["kolona"]; $red = $row["red"]; } } else { echo "Ne postoji knjiga sa ovim nazivom."; exit();} } ?> <html> <head> <title>Lista knjiga</title> <link rel="stylesheet" href="../style/style.css" type="text/css" media="screen" /> </head> <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> <?php echo $listaknjiga; ?> </div> <hr /> <a name="inventoryForm" id="inventoryForm"></a> <h3> ↓ Promena podataka: ↓ </h3> <form action="pokusaj_edit.php" enctype="multipart/form-data" name="myForm" id="myform" method="post"> <table width="90%" border="0" cellspacing="0" cellpadding="6"> <tr> <td width="20%" align="right">Naziv dela:</td> <td width="80%"><label> <input name="nazivdela" type="text" id="nazivdela" size="64" value="<?php echo $nazivdela; ?>" /> </label></td> </tr> <tr> <td width="20%" align="right">Prezime autora:</td> <td width="80%"><label> <input name="prezimeautora" type="text" id="prezimeautora" size="64" value="<?php echo $prezimeautora; ?>" /> </label></td> </tr> <tr> <td width="20%" align="right">Ime autora:</td> <td width="80%"><label> <input name="imeautora" type="text" id="imeautora" size="64" value="<?php echo $imeautora; ?>" /> </label></td> </tr> <tr> <td width="20%" align="right">Izdavac:</td> <td width="80%"><label> <input name="izdavac" type="text" id="izdavac" size="64" value="<?php echo $izdavac; ?>" /> </label></td> </tr> <tr> <td width="20%" align="right">ISBN broj:</td> <td width="80%"><label> <input name="ISBNbroj" type="text" id="ISBNbroj" size="64" value="<?php echo $ISBNbroj; ?>" /> </label></td> </tr> <tr> <td width="20%" align="right">Oblast</td> <td width="80%"><label> <input name="oblast" type="text" id="oblast" size="64" value="<?php echo $oblast; ?>" /> </label></td> </tr> <tr> <td width="20%" align="right">Podoblast:</td> <td width="80%"><label> <input name="podoblast" type="text" id="podoblast" size="64" value="<?php echo $podoblast; ?>" /> </label></td> </tr> <tr> <td width="20%" align="right">Godina izdavanja</td> <td width="80%"><label> <input name="godinaizdavanja" type="text" id="godinaizdavanja" size="64" value="<?php echo $godinaizdavanja; ?>" /> </label></td> </tr> <tr> <td width="20%" align="right">Mesto izdavanja:</td> <td width="80%"><label> <input name="mestoizdavanja" type="text" id="mestoizdavanja" size="64" value="<?php echo $mestoizdavanja; ?>" /> </label></td> </tr> <tr> <td align="right">Prostorija:</td> <td><select name="prostorija" id="prostorija"> <option value="<?php echo $prostorija; ?>"><?php echo $prostorija; ?></option> <option value="Prva soba">Prva soba</option> <option value="Druga soba">Druga soba</option> <option value="Treca soba">Treca soba</option> </select></td> </tr> <tr> <td align="right">Kolona:</td> <td><select name="kolona" id="kolona"> <option value="<?php echo $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></td> </tr> <tr> <td align="right">Red:</td> <td><select name="red" id="red"> <option value="<?php echo $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></td> </tr> <tr> <td> </td> <td><label> <input name="thisID" type="hidden" value="<?php echo $targetID; ?>" /> <input type="submit" name="button" id="button" value="Izvrsi promene" /> </label></td> </tr> </table> </form> <br /> <br /> </body> </html>

I changed it, but still reported the following error: Notice: Undefined index: id in C:\xampp\htdocs\Rad\Pokusaj\pokusaj_edit.php on line 9 Warning: mysql_fetch_array() expects parameter 1 to be resource, string given in C:\xampp\htdocs\Rad\Pokusaj\pokusaj_edit.php on line 11

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! <?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>