Çözüldü PHP ile Düzenleme Sayfası Oluşturma

Bu konu çözüldü olarak işaretlenmiştir. Çözülmediğini düşünüyorsanız konuyu rapor edebilirsiniz.
Durum
Mesaj gönderimine kapalı.
Semih Gül

Semih Gül

Kilopat
Katılım
13 Kasım 2014
Mesajlar
242
Yer
Antalya
Daha fazla  
Cinsiyet
Erkek
Arkadaşlar benim bir sayfa var içinde veriler var.

AraExcelİsimSoyisimÜlkeTelefon NoDüzenle
iconiconSemihGülTürkiye5350871111Düzenle
[TBODY] [/TBODY]

Şimdi yukarıda bulunan tablo bir alıntı gibi düşünülebilir. Bu tablonun içinde bulunan tüm veriler veritabanıma kayıtlı ve ben her kişini ayrı ayrı ID'sini alabiliyorum. Fakat Düzenleye bastığım zaman beni düzenleme sayfasına gönderiyor. Buraya kadar her şey normal. Beni istediğim şu Semih isimli kadın sağ tarafındaki Düzenle linkine tıkladığım zaman düzenleme sayfasına gidip oradaki textboxların içine verileri yazılmış halde açması. Bende gerekli düzenlemeyi yapıp kayıt edip veritabanımda güncellenmesi. Bunu nasıl yaparım. Lütfen ID ver sonra çağır gibi cümlelerle bitirmeyin kodlamama yardımcı olun.
 
Son düzenleyen: Moderatör:
"ID ver, id çağır" olur... Şaka bir yana ilk önce GET komutu ile sayfaya ID numarasını yollayacaksınız:
PHP: 
 $id = $_GET['id'];
Daha sonra ID ile databaseden veriyi alalım:
PHP: 
 $result = mysql_query("SELECT * FROM ..... WHERE ID=$id") 
or die(mysql_error());
Daha sonra buradan aldığımız veriyi kontrol ediyoruz:
PHP: 
 $row = mysql_fetch_array($result);
if($row)
{
// databaseden veriyi alıyoruz
$asd = $row['konu'];

renderForm($id, $asd,'');
}
else
{
echo "Veri Bulunamadı!";
}
Daha sonra HTML forumu içerisinde verilerinizi yazdırabilirsiniz.
 
Mesaja başlamanız beni korkuttu ama bir sorum var.
PHP: 
$id = $_GET['id'];
Bu kısım düzenleme sayfasına mı yazılacak yoksa düzenle linkini olduğu yere mi? Zaten Diğer kodlar düzenleme yapılan sayfalara yazılacak.
 
Düzenleme sayfasına yazılacak. Veriyi örneğin edit.php'ye yollayacaksınız: Edit.php?id=5 tarzı şekilde olacak.
 
Hata aldım.
Kod: 
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 '' at line 1
 
Yazdığınız kod sayfasını alabilir miyim?
 
Düzenlee yapılacak olan sayfa :
PHP: 
<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">

<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="aus.asp" 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="adminix.asp?aktion=MANUEL" 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="manuel.asp" 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="suchen.asp" 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="adminix.asp?aktion=STORNO" 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="adminix.asp?aktion=NE" 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="adminix.asp?aktion=TERMIN" 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="adminix.asp?aktion=OK" style="text-decoration: none">
                    <font color="#000000">OK Kunden</font></a></font></td>
                </tr>
                <tr>
                    <td height="10" width="206">
                    <a href="adminix.asp?aktion=BEZAHLT" 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>
            </td>
            <td height="129" width="795" valign="top" bgcolor="#FFFFFF" colspan="2">
    <?php
   
        $link = mysql_connect("127.0.0.1", "qyssemih_musteri", "Kf15021982") or die(mysql_error());
        $db = mysql_select_db("qyssemih_musteri", $link) or die (mysql_error());
          $id = $_GET['id'];
        $result = mysql_query("SELECT * FROM bilgiler WHERE no=$id") or die(mysql_error());
           
            $row = mysql_fetch_array($result);
                if($row)
                {
                // databaseden veriyi alıyoruz
                $voname = $row['voname'];

                renderForm($id, $voname);
                }
                else
                {
                echo "Veri Bulunamadı!";
                }       


?>
    <div align="right">
       
            <form action="duzen.php" 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>Vorname</td>
                    <td><input type="text" name="Vorname" value=  "<?php echo $voname ?>"/> </td>
                    <td>Gewinn Betrag</td>
                    <td><input type="text" name="gewinn_betrag" value=""></td>
                </tr>
                <tr>
                    <td>Nachname</td>
                    <td><input type="text" name="Nachname" Value=""></td>
                    <td>Gewinn von    </td>
                    <td><input type="text" name="Gewinn von" Value=""></td>
                </tr>
                <tr>
                    <td>Adresse </td>
                    <td><input type="text" name="Adresse " value=""></td>
                    <td>Password</td>
                    <td><input type="text" name="password" value=""></td>
                </tr>
                <tr>
                    <td></td>
                    <td></td>
                    <td><img src="img/bank.png">VIP Konto</td>
                    <td></td>
                </tr>
                <tr>
                    <td>Ort</td>
                    <td><input type="text" name="ort" value=""></td>
                    <td></td>
                    <td></td>
                </tr>
                <tr>
                    <td>Plz</td>
                    <td><input type="text" name="plz" value=""><br><input type="text" name="plz2" value=""></td>
                    <td></td>
                    <td></td>
                </tr>
                <tr>
                    <td>Telefon Anr.</td>
                    <td><img src="img/check.png"></td>
                    <td><img src="img/sms.png"></td>
                    <td>SMS SENDEN</td>
                </tr>
                <tr>
                    <td> Geb datum    </td>
                    <td><input type="text" name="geb" Value=""> </td>
                    <td></td>
                    <td></td>
                </tr>
                <tr>
                    <td> Bemerkung    </td>
                    <td><textarea cols="35" rows="5"></textarea></td>
                    <td></td>
                    <td><a href=""><img src="img/xlite.png">iea</a><a href=""><img src="img/3cxxx.png"></a></td>
                </tr>
                <tr bgcolor="yellow">
                    <td>     </td>
                    <td colspan="2" bgcolor="yellow"><font color="black"><u>Dieser kunde wurde am/uhr 26.05.2015 12:15:11 von Dialer angerufen !!!</u></font></td>
                   
                    <td></td>
                </tr>
                <tr>
                    <td>    </td>
                    <td>Adressen Karte Anzeigen</td>
                    <td>Status</td>
                    <td><select name="status">
                            <option Value="1democrat">1-DEMOCRAT</option>
                            <option Value="storno">Storno</option>
                            <option Value="ne">Ne</option>
                            <option Value="termin">Termin</option>
                            <option Value="ok">OK</option>
                            <option Value="bezahlt">Bezahlt</option>
                           
                        </select></td>
                </tr><tr>
                    <td>     </td>
                    <td>POST VON GEWINSPIEL SENDEN </td>
                    <td>Daten ID</td>
                    <td><select name="status">
                            <option Value="18122076">18122076</option>
                           
                           
                        </select></td>
                </tr><tr>
                    <td></td>
                    <td>POST VON BANK SENDEN </td>
                    <td>Letzte Änderungen am    26.05.2015 14:15:47</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" style="text-decoration:none; color:black;">Kunde Löschen </a></td>
                    <td></td>
                    <td></td>
                    <td><input type="submit" value="Bearbeiten und Speichern" name="B1" style="float: right; width:197; height:55"></td>
                </tr>
            </table>
       
    </form>    </div>
               
       
               
            </td>
        </tr>
    </tbody></table>

</div>



</body></html>
Verilerin gittiği sayfa:
PHP: 
<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">

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

            </td>
            <td height="129" width="795" valign="top" bgcolor="#FFFFFF" colspan="2">


           
<?php
        $link = mysql_connect("127.0.0.1", "qyssemih_musteri", "Kf15021982") or die(mysql_error());
        $db = mysql_select_db("qyssemih_musteri", $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 bilgiler order by no") or die("Hata Olustu!");
                while($oku=mysql_fetch_array($calistir)){
                    extract($oku);
                   
                    $id=$oku['telefon_nr'];
                    $voname=$oku['voname'];
                   
               
?>
<div align="right"><form action="edit.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 $oku['telefon_nr']; 

?>
                </font></td><td><a href="edit.php?id=20"><img src="img/edit_find.png"></a> </td>
                </tr>
                </table><?php } ?>
            </form></div>
               
           
                    </table>
                </div>
               
            </td>
        </tr>
    </tbody></table>

</div>



</body></html>
 
PHP: 
<?php
function renderForm($id, $voveri, $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="aus.asp" 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="adminix.asp?aktion=MANUEL" 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="manuel.asp" 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="suchen.asp" 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="adminix.asp?aktion=STORNO" 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="adminix.asp?aktion=NE" 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="adminix.asp?aktion=TERMIN" 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="adminix.asp?aktion=OK" style="text-decoration: none">
                    <font color="#000000">OK Kunden</font></a></font></td>
                </tr>
                <tr>
                    <td height="10" width="206">
                    <a href="adminix.asp?aktion=BEZAHLT" 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>
            </td>
            <td height="129" width="795" valign="top" bgcolor="#FFFFFF" colspan="2">

    <div align="right">
      
            <form action="duzen.php" 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>Vorname</td>
                    <td><input type="text" name="Vorname" value=  "<?php echo $voname ?>"/> </td>
                    <td>Gewinn Betrag</td>
                    <td><input type="text" name="gewinn_betrag" value=""></td>
                </tr>
                <tr>
                    <td>Nachname</td>
                    <td><input type="text" name="Nachname" Value=""></td>
                    <td>Gewinn von    </td>
                    <td><input type="text" name="Gewinn von" Value=""></td>
                </tr>
                <tr>
                    <td>Adresse </td>
                    <td><input type="text" name="Adresse " value=""></td>
                    <td>Password</td>
                    <td><input type="text" name="password" value=""></td>
                </tr>
                <tr>
                    <td></td>
                    <td></td>
                    <td><img src="img/bank.png">VIP Konto</td>
                    <td></td>
                </tr>
                <tr>
                    <td>Ort</td>
                    <td><input type="text" name="ort" value=""></td>
                    <td></td>
                    <td></td>
                </tr>
                <tr>
                    <td>Plz</td>
                    <td><input type="text" name="plz" value=""><br><input type="text" name="plz2" value=""></td>
                    <td></td>
                    <td></td>
                </tr>
                <tr>
                    <td>Telefon Anr.</td>
                    <td><img src="img/check.png"></td>
                    <td><img src="img/sms.png"></td>
                    <td>SMS SENDEN</td>
                </tr>
                <tr>
                    <td> Geb datum    </td>
                    <td><input type="text" name="geb" Value=""> </td>
                    <td></td>
                    <td></td>
                </tr>
                <tr>
                    <td> Bemerkung    </td>
                    <td><textarea cols="35" rows="5"></textarea></td>
                    <td></td>
                    <td><a href=""><img src="img/xlite.png">iea</a><a href=""><img src="img/3cxxx.png"></a></td>
                </tr>
                <tr bgcolor="yellow">
                    <td>     </td>
                    <td colspan="2" bgcolor="yellow"><font color="black"><u>Dieser kunde wurde am/uhr 26.05.2015 12:15:11 von Dialer angerufen !!!</u></font></td>
                  
                    <td></td>
                </tr>
                <tr>
                    <td>    </td>
                    <td>Adressen Karte Anzeigen</td>
                    <td>Status</td>
                    <td><select name="status">
                            <option Value="1democrat">1-DEMOCRAT</option>
                            <option Value="storno">Storno</option>
                            <option Value="ne">Ne</option>
                            <option Value="termin">Termin</option>
                            <option Value="ok">OK</option>
                            <option Value="bezahlt">Bezahlt</option>
                          
                        </select></td>
                </tr><tr>
                    <td>     </td>
                    <td>POST VON GEWINSPIEL SENDEN </td>
                    <td>Daten ID</td>
                    <td><select name="status">
                            <option Value="18122076">18122076</option>
                          
                          
                        </select></td>
                </tr><tr>
                    <td></td>
                    <td>POST VON BANK SENDEN </td>
                    <td>Letzte Änderungen am    26.05.2015 14:15:47</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" style="text-decoration:none; color:black;">Kunde Löschen </a></td>
                    <td></td>
                    <td></td>
                    <td><input type="submit" value="Bearbeiten und Speichern" name="B1" 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", "qyssemih_musteri", "Kf15021982") or die(mysql_error());
        $db = mysql_select_db("qyssemih_musteri", $link) or die (mysql_error());
        
          $id = $_GET['id'];
        $result = mysql_query("SELECT * FROM players 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['voname'];
           renderForm($id, $voveri,'');
}
else
{
echo "Sonuç Bulunamadı!";
}

?>
 
Sizin verdiğiniz düzenleme sayfası kodlarını değiştirdiğim zaman kontrol aşamasında düzenleme iconuna tıkladığım zaman sayfada aldığım hata :
Kod: 
Table 'qyssemih_musteri.players' doesn't exist
Ne yapmam gerek.
 
PHP: 
        $result = mysql_query("SELECT * FROM players WHERE id=$id") or die(mysql_error());
Burayı ayarlayın.
 
Durum
Mesaj gönderimine kapalı.

Benzer konular

Semih Gül
PHP ile Düzenleme Sayfası Oluşturma
Mesaj
0
Görüntüleme
883
Semih Gül
Semih Gül
M
PHP ile galeri sayfası
Mesaj
6
Görüntüleme
1B
ismailperim
ismailperim
K
PHP ile akış oluşturma
Mesaj
3
Görüntüleme
374
codelab
codelab
akiftsc41
PHP ile database update
Mesaj
2
Görüntüleme
432
Furkan17TR
Furkan17TR
Undisputed.
  • Soru
PHP for döngüsü ile tablo oluşturma
Mesaj
1
Görüntüleme
2B
Berkay Davas
Berkay Davas

Yeni konular

Yeni mesajlar

Geri
Yukarı