Arkadaşlar önceden aynı sıkıntı ile karşılaştım ve düzeltmiştik. Fakat şuan aynı sıkıntıdan var ve ben bulamadım 10 defa kontrol ettim ama yinede bulamadım. Veriler bir sayfada gösterimde edit butonuna tıklandığı zaman başka sayfada o id'ye ait kişinin bilgileri listelenecek.
Nedir bu kodların sıkıntısı. Dediğim gibi tekrar tekrar kontrol ettim.
PHP:
// Edit Sayfası
<?php
function renderForm($id, $voveri, $voveri2,$voveri3,$voveri4,$voveri5,$voveri6,$voveri7,$voveri8,$voveri9,$voveri10,$voveri11,$voveri12,$voveri13,$voveri14,$voveri15,$voveri16,$voveri17,$voveri18,$voveri19,$voveri20,$voveri21,$voveri22,$voveri23, $error)
{
?>
<html><head><link href="chrome-extension://fepmcbinlbgdkegnjjnpcclhcpbjcgoa/content.css" type="text/css" rel="stylesheet"><meta http-equiv="refresh" content="60">
<meta http-equiv="Content-Language" content="tr">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1254">
<title>Unicat BANK ADMIN</title>
<style></style></head>
<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" marginwidth="0" marginheight="0" bgcolor="#E0E0E0">
<?php
if ($error != '')
{
echo '<div style="padding:4px; border:1px solid red; color:red;">'.$error.'</div>';
}
?>
<div align="center">
<table border="0" width="1016" height="148" cellspacing="0" cellpadding="0">
<tbody><tr>
<td height="16" width="221" valign="top" bgcolor="#008000">
<font color="#FFFFFF">SMS GUTHABEN</font>
<font color="#FFFF00">899999996570 </font>
<font color="#FFFFFF">Euro</font></td>
<td height="16" width="402" valign="top" bgcolor="#008000">
<font face="Arial" color="#FFFFFF">
Total Kunde 41 Bei 1-DEMOCRAT Status</font></td>
<td height="16" width="393" valign="top" bgcolor="#008000">
<p align="right"><font face="Arial" color="#FFFFFF">Unicat BANK Admin
Panel </font></p></td>
</tr>
<tr>
<td height="129" width="221" valign="top" bgcolor="#FFFFFF">
<table width="221" height="120" cellspacing="0" cellpadding="0" style="border-left: 1px solid #008000; border-right-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
<tbody><tr>
<td height="120" width="4" rowspan="14"> </td>
<td height="120" width="0" rowspan="14"></td>
<td height="8" width="206"><font face="Arial">
<a href="../index.php" style="text-decoration: none; font-weight: 700">
Ausgang</a></font></td>
</tr>
<tr>
<td height="6" width="206"></td>
</tr>
<tr>
<td height="8" width="206">
<a href="all_data.php" style="text-decoration: none">
<font color="#000000" face="Arial">Kunden im System</font></a></td>
</tr>
<tr>
<td height="9" width="206"><font face="Arial">
<a href="page/kunden_von_manuel_eingabe.php" style="text-decoration: none">
<font color="#000000">Kunden von
Manuel eingabe</font></a></font></td>
</tr>
<tr>
<td height="6" width="206"><font face="Arial">
<a href="page/manuel_insert.php" style="text-decoration: none">
<font color="#000000">Kunde Manuel
registieren</font></a></font></td>
</tr>
<tr>
<td height="9" width="206"><font face="Arial">
<a href="page/suchen.php" style="text-decoration: none">
<font color="#000000">Kunde Suchen</font></a></font></td>
</tr>
<tr>
<td height="15" width="206"><font face="Arial">
<a href="page/storno_kunden.php" style="text-decoration: none">
<font color="#000000">Storno Kunden</font></a></font></td>
</tr>
<tr>
<td height="6" width="206"><font face="Arial">
<a href="page/ne.php" style="text-decoration: none">
<font color="#000000">Nicht Err.
Kunden</font></a></font></td>
</tr>
<tr>
<td height="8" width="206"><font face="Arial">
<a href="page/termin.php" style="text-decoration: none">
<font color="#000000">Termin Kunden</font></a></font></td>
</tr>
<tr>
<td height="12" width="206"><font face="Arial">
<a href="page/ok.php" style="text-decoration: none">
<font color="#000000">OK Kunden</font></a></font></td>
</tr>
<tr>
<td height="10" width="206">
<a href="page/bezahlt.php" style="text-decoration: none; font-weight: 700">
<font color="#008000">KUNDE HAT BEZAHLT</font></a></td>
</tr>
<tr>
<td height="11" width="206"><b><font color="#006600">
<a href="adminix.asp?aktion=SMS_GESENDET" style="text-decoration: none">
<font color="#006600">SMS GESENDET</font></a></font></b></td>
</tr>
<tr>
<td height="17" width="206"><font face="Arial">
<a href="adminix.asp?aktion=KUNDE_SMS" style="text-decoration: none">
KUNDE ONLINE SMS</a></font></td>
</tr>
<tr>
<td height="9" width="206"></td>
</tr>
</tbody></table>
<table>
<tr>
<td><a title="AUF EXCEL DOWNLOAD" href="exell.php">
<img border="0" src="../img/exxx.jpg" width="50" height="50"></a></td>
</tr>
</table>
</td>
<td height="129" width="795" valign="top" bgcolor="#FFFFFF" colspan="2">
<div align="right">
<form action="" method="POST">
<table border="0" width="781" height="27" cellspacing="0" cellpadding="0" style="border-left: 2px solid #008000; border-right: 2px solid #008000; border-top-width: 1px; border-bottom: 2px solid #008000">
<tr>
<td>benotigte</td>
<td><input type="text" name="benotigte" value="<?php echo $voveri ?>"> </td>
<td>gewunschte</td>
<td><input type="text" name="gewunschte" value="<?php echo $voveri2 ?>"></td>
</tr>
<tr>
<td>ID'si'</td>
<td><input type="text" name="id" value="<?php echo $voveri14 ?>" readonly > </td>
<td>anr</td>
<td><input type="text" name="anr" value="<?php echo $voveri3 ?>"></td>
</tr>
<tr>
<td>voname</td>
<td><input type="text" name="voname" value="<?php echo $voveri4 ?>"></td>
<td>nachname </td>
<td><input type="text" name="nachname" value="<?php echo $voveri5 ?>"></td>
</tr>
<tr>
<td>strasse </td>
<td><input type="text" name="strasse " value="<?php echo $voveri6 ?>"></td>
<td>hausnummer</td>
<td><input type="text" name="hausnummer" value="<?php echo $voveri7 ?>"></td>
</tr>
<tr>
<td>plz</td>
<td><input type="text" name="plz" value="<?php echo $voveri8 ?>"></td>
<td>ort</td>
<td><input type="text" name="ort" value="<?php echo $voveri9 ?>"></td>
</tr>
<tr>
<td>country</td>
<td><input type="text" name="country" value="<?php echo $voveri10 ?>"></td>
<td>Dtarih</td>
<td><input type="text" name="date_of_birth_d" value="<?php echo $voveri11 ?>"><input type="text" name="date_of_birth_m" value="<?php echo $voveri12 ?>"><input type="text" name="date_of_birth_y" value="<?php echo $voveri13 ?>"></td>
</tr>
<tr>
<td>hady</td>
<td><input type="text" name="hady" value="<?php echo $voveri15 ?>"><br></td>
<td></td>
<td></td>
</tr>
<tr>
<td>e_mail</td>
<td><input type="text" name="e_mail" value="<?php echo $voveri16 ?>"></td>
<td>e_mail_wiederholung</td>
<td><input type="text" name="e_mail" value="<?php echo $voveri17 ?>"></td>
</tr>
<tr>
<td> staatsangehorigkeit </td>
<td><input type="text" name="staatsangehorigkeit" value="<?php echo $voveri18 ?>"> </td>
<td>family_status</td>
<td><input type="text" name="family_status" value="<?php echo $voveri19 ?>"></td>
</tr>
<tr>
<td> employment </td>
<td><input type="text" name="employment" value="<?php echo $voveri20 ?>"></td>
<td>nettoeinkommen</td>
<td><input type="text" name="nettoeinkommen" value="<?php echo $voveri21 ?>"></td>
</tr>
<tr>
<td> estate </td>
<td><input type="text" name="estate" value="<?php echo $voveri22 ?>"></td>
<td>terms</td>
<td><input type="text" name="terms" value="<?php echo $voveri23 ?>"></td>
</tr>
<tr>
<td> </td>
<td>POST VON GEWINSPIEL SENDEN </td>
<td></td>
<td></td>
</tr><tr>
<td></td>
<td>POST VON BANK SENDEN </td>
<td></td>
<td></td>
</tr><tr>
<td></td>
<td><a href="exell.php"> <img src="img/exxx.jpg">Auf Excell Download</a> </td>
<td></td>
<td></td>
</tr><tr>
<td> </td>
<td> EcoCard Register </td>
<td></td>
<td></td>
</tr><tr>
<td> </td>
<td>Neteller Register</td>
<td></td>
<td></td>
</tr>
<tr>
<td> </td>
<td>Comdirect Register </td>
<td></td>
<td></td>
</tr><tr>
<td bgcolor="#FF0000" valing="top"><a href="delete.php?id=" style="text-decoration:none; color:black;">Kunde Löschen </a></td>
<td></td>
<td></td>
<td><input type="submit" value="Bearbeiten und Speichern" style="float: right; width:197; height:55"></td>
</tr>
</table>
</form> </div>
</td>
</tr>
</tbody></table>
</div>
</body></html>
<?php
}
$link = mysql_connect("127.0.0.1", "pmrvipon_kredit", "Kf15021982") or die(mysql_error());
$db = mysql_select_db("pmrvipon_kredit", $link) or die (mysql_error());
mysql_query("SET NAMES 'latin5'");
mysql_query("SET CHARACTER SET 'latin5'");
mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'");
$id = $_GET['id'];
$result = mysql_query("SELECT * FROM kredi WHERE id=$id") or die(mysql_error());
$row = mysql_fetch_array($result);
// check that the 'id' matches up with a row in the databse
if($row)
{
$voveri = $row['benotigte'];
$voveri2 = $row['gewunschte'];
$voveri3 = $row['anr'];
$voveri4 = $row['voname'];
$voveri5 = $row['nachname'];
$voveri6 = $row['strasse'];
$voveri7 = $row['hausnummer'];
$voveri8 = $row['plz'];
$voveri9 = $row['ort'];
$voveri10 = $row['country'];
$voveri11= $row['date_of_birth_d'];
$voveri12 = $row['date_of_birth_m'];
$voveri13 $row['date_of_birth_y'];
$voveri14=$row['id'];
$voveri15 = $row['hady'];
$voveri16 = $row['e_mail'];
$voveri17 = $row['e_mail_wiederholung'];
$voveri18 = $row['staatsangehorigkeit'];
$voveri19 = $row['family_status'];
$voveri20 = $row['employment'];
$voveri21 = $row['nettoeinkommen'];
$voveri22 = $row['estate'];
$voveri23 = $row['terms'];
renderForm($id, $voveri,$voveri2,$voveri3,$voveri4,$voveri5,$voveri6,$voveri7,$voveri8,$voveri9,$voveri10,$voveri11,$voveri12,$voveri13,$voveri14,$voveri15,$voveri16,$voveri17,$voveri18,$voveri19,$voveri20,$voveri21,$voveri22,$voveri23, '');
}
else
{
echo "Sonuç Bulunamadı!";
}
?>
PHP:
//Verilerin geldği sayfa
<html><head><link href="chrome-extension://fepmcbinlbgdkegnjjnpcclhcpbjcgoa/content.css" type="text/css" rel="stylesheet"><meta http-equiv="refresh" content="60">
<meta http-equiv="Content-Language" content="tr">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1254">
<title>VIP BANK ADMIN</title>
<style></style></head>
<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0" marginwidth="0" marginheight="0" bgcolor="#E0E0E0">
<div align="center">
<table border="0" width="1016" height="148" cellspacing="0" cellpadding="0">
<tbody><tr>
<td height="16" width="221" valign="top" bgcolor="0e12fb">
<font color="#FFFFFF">CCM VIP MASKE</font>
<font color="#FFFF00"></font>
<td height="16" width="402" valign="top" bgcolor="0e12fb">
<font face="Arial" color="#FFFFFF">
Total Kunde </font></td>
<td height="16" width="393" valign="top" bgcolor="0e12fb">
<p align="right"><font face="Arial" color="#FFFFFF">VIP BANK Admin
Panel </font></p></td>
</tr>
<tr>
<td height="129" width="221" valign="top" bgcolor="#FFFFFF">
<table width="221" height="120" cellspacing="0" cellpadding="0" style="border-left: 1px solid #008000; border-right-width: 1px; border-bottom-style: solid; border-bottom-width: 1px">
<tbody><tr>
<td height="120" width="4" rowspan="14"> </td>
<td height="120" width="0" rowspan="14"></td>
<td height="8" width="206"><font face="Arial">
<a href="../index.php" style="text-decoration: none; font-weight: 700">
Ausgang</a></font></td>
</tr>
<tr>
<td height="6" width="206"></td>
</tr>
<tr>
<td height="8" width="206">
<a href="all_data.php" style="text-decoration: none">
<font color="#000000" face="Arial">Kunden im Maske</font></a></td>
</tr>
<tr>
<td height="9" width="206"><font face="Arial">
<a href="page/kunden_von_manuel_eingabe.php" style="text-decoration: none">
<font color="#000000">Kunden v.Kredit Antrag</font></a></font></td>
</tr>
<tr>
<td height="6" width="206"><font face="Arial">
<a href="page/manuel_insert.php" style="text-decoration: none">
<font color="#000000">Kunde Manuel
registieren</font></a></font></td>
</tr>
<tr>
<td height="9" width="206"><font face="Arial">
<a href="page/suchen.php" style="text-decoration: none">
<font color="#000000">Suchen</font></a></font></td>
</tr>
<tr>
<td height="15" width="206"><font face="Arial">
<a href="page/storno_kunden.php" style="text-decoration: none">
<font color="#000000">Storno</font></a></font></td>
</tr>
<tr>
<td height="6" width="206"><font face="Arial">
<a href="page/ne.php" style="text-decoration: none">
<font color="#000000">Nicht Erreicht</font></a></font></td>
</tr>
<tr>
<td height="8" width="206"><font face="Arial">
<a href="page/termin.php" style="text-decoration: none">
<font color="#000000">Termin</font></a></font></td>
</tr>
<tr>
<td height="12" width="206"><font face="Arial">
<a href="page/ok.php" style="text-decoration: none">
<font color="#000000">QC OK</font></a></font></td>
</tr>
<tr>
<td height="10" width="206">
<a href="page/bezahlt.php" style="text-decoration: none; font-weight: 700">
<font color="#008000">OK Bezahlt</font></a></td>
</tr>
<tr>
<td height="11" width="206"><b><font color="#006600">
<a href="adminix.asp?aktion=SMS_GESENDET" style="text-decoration: none">
<font color="#006600">SMS GESENDET</font></a></font></b></td>
</tr>
<tr>
<td height="17" width="206"><font face="Arial">
<a href="adminix.asp?aktion=KUNDE_SMS" style="text-decoration: none">
KUNDE ONLINE SMS</a></font></td>
</tr>
<tr>
<td height="9" width="206"></td>
</tr>
</tbody></table>
</td>
<td height="129" width="795" valign="top" bgcolor="#FFFFFF" colspan="2">
<?php
$link = mysql_connect("127.0.0.1", "pmrvipon_kredit", "Kf15021982") or die(mysql_error());
$db = mysql_select_db("pmrvipon_kredit", $link) or die (mysql_error());
mysql_query("SET NAMES 'latin5'");
mysql_query("SET CHARACTER SET 'latin5'");
mysql_query("SET COLLATION_CONNECTION = 'latin5_turkish_ci'");
$calistir = mysql_query("SELECT * FROM kredi order by id") or die("Hata Olustu!");
while($oku=mysql_fetch_array($calistir)){
extract($oku);
$id=$oku['id'];
//$voname=$oku['voname'];
?>
<div align="right"><form action="edit1.php" method="get">
<table border="0" width="781" height="27" cellspacing="0" cellpadding="0" style="border-left: 2px solid #008000; border-right: 2px solid #008000; border-top-width: 1px; border-bottom: 2px solid #008000">
<tbody><tr onmouseout="this.bgColor='';" onmouseover="this.bgColor='#00FF00';" bgcolor="">
<td height="23" width="7"><a title="ANRUFEN VON XLITE" href="sip:00491711782638">
<img border="0" src="../img/jRcGadpTL.png" width="20" height="20"></a>
</td>
<td height="23" width="13">
<a title="AUF EXCEL DOWNLOAD" href="exell.php">
<img border="0" src="../img/exxx.jpg" width="27" height="22"></a></td>
<td height="23" width="127"> <?php echo $oku['voname']; ?> </td>
<td height="23" width="214"> <?php echo $oku['nachname']; ?></td>
<td height="23" width="55">
<img border="0" src="../img/Germany-Flag-icon.png" width="16" height="16">
</td><td height="23" width="112">
<font size="2" color="#008000"><font face="Arial">
<?php
echo $id;
?>
</font></td><td><a href="edit1.php?id=<?php echo $id ?>"><img src="../img/edit_find.png"></a> </td>
</tr>
</table><?php } ?>
</form></div>
</table>
</div>
</td>
</tr>
</tbody></table>
</div>
</body></html>