Forum PHP Romania - Discutii despre PHP, MySQL, Javascript, AJAX, etc

[edytzuu]

Am o problema! Am o locatzie a unui site in care vreau sa editez din baza de date! Vreau sa imi aifseze baza si dupa fiecare inregistrare sa am un buton de editare! Asta nu e greu deloc. S-a rezoilvat. Doar ca in momentul in care dau pe acel link de editare, in pagina cu editarea nu imi apare nimic. Postez codul.. poate am gresit pe undeva si nu stiu!


Asta imi afiseaza bd si cu linkul spre pagina de editare Cod:
<?php
$db = mysql_connect("localhost", "root", "");
mysql_select_db("unica",$db);
$result = mysql_query("SELECT * FROM caut_inchiriez_imobil",$db);
echo "<TABLE BORDER=0 align='center'>";
echo"<TR><TD><center><s2>Tip &nbsp&nbsp&nbsp&nbsp&nbsp</s2></center><hr>
<TD>
<center><s2>Strada &nbsp&nbsp&nbsp&nbsp&nbsp</s2></center><hr>
<TD>
<center><s2>Detalii 1</s2></center><hr>   
<TD>
<center><s2>Detalii 2</s2></center><hr>
<TD>
<center><s2>Detalii 3</s2></center><hr>
<TD>
<center><s2>Detalii 4</s2></center><hr>
<TD>
<center><s2>Pret &nbsp&nbsp&nbsp</s2></center><hr>
<TD>
<center><s2>Editare &nbsp&nbsp&nbsp&nbsp &nbsp&nbsp &nbsp&nbsp&nbsp&nbsp</s2></center><hr>

</TR>";
while ($myrow = mysql_fetch_array($result))
{
echo "<TR><TD><center><s5>
".$myrow["tip"]."
</center></s5><td><center><s5>
".$myrow["strada"]."
</s5></center><TD><center><s5>
".$myrow["dot1"]."
</s5></center><TD><center><s5>
".$myrow["dot2"]."
</s5></center><TD><center><s5>
".$myrow["dot3"]."
</s5></center><TD><center><s5>
".$myrow["dot4"]."
</s5></center><TD><center><s5>
".$myrow["pret"]."
</s5></center><TD>";
echo "<a href=\"modificare_caut_chirie_edit.php?id4=
".$myrow[id4]."
\"><center><s5>Click</s5></center></a>";
}
echo "</TABLE>";
?>

Aceasta este pagina de editare modificare_caut_chirie_edit.php

Cod:
<?php
if($update)
{
$db = mysql_connect("localhost", "root","");
mysql_select_db("unica",$db);
$sql = "UPDATE caut_inchiriez_imobil SET
tip='$tip',
strada='$strada',
dot1='$dot1',
dot2='$dot2',
dot3='$dot3',
dot4='$dot4'.
pret='$pret'
WHERE id4=$id4";
$result = mysql_query($sql);
echo "Informatie editata cu succes!";
}
else if($id)
{
$db = mysql_connect("localhost", "root", "");
mysql_select_db("unica",$db);
$result = mysql_query("SELECT * FROM caut_inchiriez_imobil WHERE id4=$id4",$db);
$myrow = mysql_fetch_array($result);
}
else
{
?>
<form method="post" action="<?php echo $PHP_SELF?>">
<input type="Submit" name="id4" value="<?php echo $myrow["id4"]?>"<br>
Tip:<input type="Text" name="tip" value="<?php echo $myrow["tip"]?>"><br>
Strada:<input type="Text" name="strada" value="<?php echo $myrow["strada"]?>"><br>
Detalii 1:<input type="Text" name="dot1" value="<?php echo $myrow["dot1"]?>"><br>
Detalii 2:<input type="Text" name="dot2" value="<?php echo $myrow["dot2"]?>"><br>
Detalii 3:<input type="Text" name="dot3" value="<?php echo $myrow["dot3"]?>"><br>
Detalii 4:<input type="Text" name="dot4" value="<?php echo $myrow["dot4"]?>"><br>
Pret:<input type="Text" name="pret" value="<?php echo $myrow["pret"]?>"><br>
<input type="Submit" name="update" value="Editeaza"></form>
<?
}
?>

[Birkoff]

baga si tu in ambele pagini prima linie de cod error_reporting(E_ALL) si vezi ce erori iti da.... cred ca o sa iti dai seama unde ai gresit doar citind erorile care le va afisa...

[edytzuu]

tot nu am rezolvat nimic

[Birkoff]

adica? nu iti da niste wariniguri ca nu ai initializat niste variabile?

[gabysolomon]

incearca sa vezi daca ai si display errors on in configuratia php

[PHPRomania Bot]