PHP ile Düzenleme Sayfası Oluşturma

Semih Gül

Kilopat
Katılım
13 Kasım 2014
Mesajlar
242
Yer
Antalya
Daha fazla  
Cinsiyet
Erkek
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.
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">
&nbsp;<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>&nbsp;
            <font color="#FFFF00">899999996570&nbsp;</font>
         
            <font color="#FFFFFF">Euro</font></td>
            <td height="16" width="402" valign="top" bgcolor="#008000">
            <font face="Arial" color="#FFFFFF">&nbsp;&nbsp;
            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&nbsp; </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">&nbsp;</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">
&nbsp;<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>&nbsp; 
<font color="#FFFF00"></font> 
<td height="16" width="402" valign="top" bgcolor="0e12fb">
<font face="Arial" color="#FFFFFF">&nbsp;&nbsp;
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&nbsp; </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">&nbsp;</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">&nbsp;  <?php echo $oku['voname']; ?> </td>
<td height="23" width="214">&nbsp; <?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>
Nedir bu kodların sıkıntısı. Dediğim gibi tekrar tekrar kontrol ettim.
 
Uyarı! Bu konu 9 yıl önce açıldı.
Muhtemelen daha fazla tartışma gerekli değildir ki bu durumda yeni bir konu başlatmayı öneririz. Eğer yine de cevabınızın gerekli olduğunu düşünüyorsanız buna rağmen cevap verebilirsiniz.

Yeni konular

Yeni mesajlar

Geri
Yukarı