edit don't work

IvRa · June 23, 2011

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>

Maq · June 23, 2011

What happens? Are you getting errors?

One thing I noticed right away is that you're missing terminating single quotes around your SQL values.

IvRa · June 23, 2011

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

jnvnsn · June 23, 2011

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

I'm not sure if it's a typo error or this is really what you wrote in your code.

For sure there will be no value to be passed because instead of:

value="<?php echo $redovi['podoblast'];?>"

you typed

value-"<?php echo $redovi['podoblast'];?>"

.

Change - to =.

IvRa · June 23, 2011

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>

IvRa · June 24, 2011

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!

IvRa · June 24, 2011

Another typo! Sorry people! :shy:

EdwinPaul · June 24, 2011

For better readability, change:

$query = mysql_query($query);

to:

$result = mysql_query($query);

and work with $result in subsequent statements.

AND CHECK EVERY DATABASE-ACTION !

IvRa · June 25, 2011

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

Sign In

edit don't work

Recommended Posts

IvRa

Link to comment

Share on other sites

Maq

Link to comment

Share on other sites

IvRa

Link to comment

Share on other sites

jnvnsn

Link to comment

Share on other sites

IvRa

Link to comment

Share on other sites

IvRa

Link to comment

Share on other sites

IvRa

Link to comment

Share on other sites

EdwinPaul

Link to comment

Share on other sites

IvRa

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information