MasterWoo Posted August 22, 2012 Share Posted August 22, 2012 Merhabalar arkadaşlar phpde bir projem var ama iletişim bölümündeki verileri mysql'e yollayamadım.Okadar uğraşmama rağmen sinir etti ve hatamı bir türlü bulamadım sizce nerde hata yapmaktayım [spoiler] [code] ? session_start(); include "data/data.php"; $admingirdi = $_SESSION['admin'] ; if (empty($admingirdi)){ header("Location:giris"); } ?> <!DOCTYPE HTML> <html> <head> <meta charset="iso-8859-9"> <title>Teknik Destek Anasayfa</title> <link href="css/css.css" rel="stylesheet" type="text/css"> <SCRIPT LANGUAGE="Javascript"> function checkEmail(myForm) { if (/^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*(\.\w{2,3})+$/.test(myForm.emaile.value)){ return (true) } alert("E-Mail adresinizi kotrol ediniz") return (false) } // End --> </script> <style type="text/css"> #apDiv1 { position:absolute; left:72px; top:1084px; width:872px; height:358px; z-index:1; background-color: #CCCCCC; } </style> </head> <body> <? function index() { ?> <div id="sutun"> <table width="100%" border="0" style="margin-top:10px" > <tr> <th width="14%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index">Anasayfa</a> </th> <th width="17%" height="21" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index?Act=Gorev">Kayıtlı Görevler</a></th> <th width="17%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index?Act=Rapor">Kayıtlı Raporlar</a></th> <th width="12%" align="center" valign="middle" bgcolor="#999999" scope="col">Görev Ekle</th> <th width="15%" align="center" valign="middle" bgcolor="#999999" scope="col">Rapor Ekle</th> <th width="11%" align="center" valign="middle" bgcolor="#999999" scope="col">Telefon Defteri</th> <th width="7%" align="center" valign="middle" bgcolor="#999999" scope="col">Panel</th> <th width="7%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index?Act=iletisim">İletişim</a></th> <th width="7%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="cikis">Çıkış</a></th> </tr> </table> </div> <br> <? } function Gorev () { ?> <div id="sutun"> <table width="100%" border="0" style="margin-top:10px" > <tr> <th width="14%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index">Anasayfa</a> </th> <th width="17%" height="21" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index?Act=Gorev">Kayıtlı Görevler</a></th> <th width="17%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index?Act=Rapor">Kayıtlı Raporlar</a></th> <th width="12%" align="center" valign="middle" bgcolor="#999999" scope="col">Görev Ekle</th> <th width="15%" align="center" valign="middle" bgcolor="#999999" scope="col">Rapor Ekle</th> <th width="11%" align="center" valign="middle" bgcolor="#999999" scope="col">Telefon Defteri</th> <th width="7%" align="center" valign="middle" bgcolor="#999999" scope="col">Panel</th> <th width="7%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index?Act=iletisim">İletişim</a></th> <th width="7%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="cikis">Çıkış</a></th> </tr> </table> </div><br> <div id="gorev"> <table width="100%" border="0" style="margin-top:25px;"> <tr> <th width="1%" align="center" valign="baseline" bgcolor="#D6D6D6" scope="col">Sıra NO</th> <th width="18%" align="center" valign="baseline" bgcolor="#D6D6D6" scope="col">Görev Yeri</th> <th width="19%" align="center" valign="baseline" bgcolor="#D6D6D6" scope="col">Göreve Geden Kişiler</th> <th width="15%" align="center" valign="baseline" bgcolor="#D6D6D6" scope="col">Görev Tarih</th> <th width="12%" align="center" valign="baseline" bgcolor="#D6D6D6" scope="col">Görev Bitiş Tarihi</th> <th width="12%" align="center" valign="baseline" bgcolor="#D6D6D6" scope="col">Fazla Mesai Saat'i</th> <th width="9%" align="center" valign="baseline" bgcolor="#D6D6D6" scope="col">Not</th> <th colspan="2" align="center" valign="baseline" bgcolor="#D6D6D6" scope="col">İşlem</th> </tr> <? $ql = "Select * from gorev order by id DESC "; $query = mysql_query($ql); while ($read = mysql_fetch_assoc($query)){ $id =$read['id']; $gorev_yeri =$read['gorev_yeri']; $gorev_gidenler =$read['gorev_gidenler']; $gorev_tarih =$read['gorev_tarih']; $gorev_tarih_b =$read['gorev_tarih_b']; $f_mesai =$read['f_mesai']; $not =$read['not']; ?> <tr> <th align="center" valign="baseline" bgcolor="#FF6600"><? print "$id"; ?></th> <th align="left" valign="baseline" bgcolor="#FF6600"><? print "$gorev_yeri"; ?></th> <th align="left" valign="baseline" bgcolor="#FF6600"><? print "$gorev_gidenler"; ?></th> <th align="center" valign="baseline" bgcolor="#FF6600"><? print "$gorev_tarih"; ?></th> <th align="center" valign="baseline" bgcolor="#FF6600"><? print "$gorev_tarih_b"; ?></th> <th align="center" valign="baseline" bgcolor="#FF6600"><? print "$f_mesai"; ?></th> <th align="left" valign="baseline" bgcolor="#FF6600"><? print "$not"; ?></th> <th width="10%" align="center" valign="baseline" bgcolor="#999999">Rapor Oku</th> <th width="4%" align="center" valign="baseline" bgcolor="#999999">Sil</th> </tr><? } ?> </table><br> </div> <? } function Rapor (){?> <div id="sutun"> <table width="100%" border="0" style="margin-top:10px" > <tr> <th width="14%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index">Anasayfa</a> </th> <th width="17%" height="21" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index?Act=Gorev">Kayıtlı Görevler</a></th> <th width="17%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index?Act=Rapor">Kayıtlı Raporlar</a></th> <th width="12%" align="center" valign="middle" bgcolor="#999999" scope="col">Görev Ekle</th> <th width="15%" align="center" valign="middle" bgcolor="#999999" scope="col">Rapor Ekle</th> <th width="11%" align="center" valign="middle" bgcolor="#999999" scope="col">Telefon Defteri</th> <th width="7%" align="center" valign="middle" bgcolor="#999999" scope="col">Panel</th> <th width="7%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index?Act=iletisim">İletişim</a></th> <th width="7%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="cikis">Çıkış</a></th> </tr> </table> </div> <br> <div id="rapor"> <table width="100%" border="0" style="margin-top:25px;"> <tr> <th width="4%" align="center" valign="baseline" bgcolor="#D6D6D6" scope="col">Sıra NO</th> <th width="52%" align="center" valign="baseline" bgcolor="#D6D6D6" scope="col">Rapor Adı</th> <th width="26%" align="center" valign="baseline" bgcolor="#D6D6D6" scope="col">Rapor Yazılma Tarih'i</th> <th width="18%" align="center" valign="baseline" bgcolor="#D6D6D6" scope="col">İşlem</th> </tr> <? $ql = "Select * from gorev order by id DESC "; $query = mysql_query($ql); while ($read = mysql_fetch_assoc($query)){ $id =$read['id']; $gorev_yeri =$read['gorev_yeri']; $gorev_gidenler =$read['gorev_gidenler']; $gorev_tarih =$read['gorev_tarih']; $gorev_tarih_b =$read['gorev_tarih_b']; $f_mesai =$read['f_mesai']; $not =$read['not']; ?> <tr> <th align="center" valign="baseline" bgcolor="#FF6666"><? print "$id"; ?></th> <th align="center" valign="baseline" bgcolor="#FF6666"><? print "$gorev_yeri"; ?></th> <th align="center" valign="baseline" bgcolor="#FF6666"><? print "$gorev_gidenler"; ?></th> <th align="center" valign="baseline" bgcolor="#999999">Sil</th> </tr><? } ?> </table><br> </div> <? } function iletisim() { $ip = $_POST['ip']; $date = $_POST['date']; $adi = $_POST['adi']; $soyadi = $_POST['soyadi']; $birim = $_POST['birim']; $yer = $_POST['yer']; $telefon = $_POST['telefon']; $iptel = $_POST['iptel']; $eposta = $_POST['eposta']; $mesaj = $_POST['mesaj']; $veri_kaydi="INSERT INTO mesaj(ip,gun,adi,soyadi,birim,bolge,telefon,iptel,eposta,mesaj) values ('$ip','$date','$adi','$soyadi','$birim','$yer','$telefon','$iptel','$eposta','$mesaj')"; $vsorgu=mysql_query($veri_kaydi); if(isset($vsorgu) ) { echo "<b>Resim Eklendi</b>;"; } else{ echo "hata oldu"; } ?> <div id="sutun"> <table width="100%" border="0" style="margin-top:10px" > <tr> <th width="14%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index">Anasayfa</a> </th> <th width="17%" height="21" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index?Act=Gorev">Kayıtlı Görevler</a></th> <th width="17%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index?Act=Rapor">Kayıtlı Raporlar</a></th> <th width="12%" align="center" valign="middle" bgcolor="#999999" scope="col">Görev Ekle</th> <th width="15%" align="center" valign="middle" bgcolor="#999999" scope="col">Rapor Ekle</th> <th width="11%" align="center" valign="middle" bgcolor="#999999" scope="col">Telefon Defteri</th> <th width="7%" align="center" valign="middle" bgcolor="#999999" scope="col">Panel</th> <th width="7%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index?Act=iletisim">İletişim</a></th> <th width="7%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="cikis">Çıkış</a></th> </tr> </table> </div> <br> <div id="iletisim"> <br> <form action="?Act=iletisim" method="post"> <table width="66%" border="0" cellspacing="1" align="center" cellpadding="0" bordercolor="#CCCCCC"> <tr> <td colspan="3" align="center" valign="top">Düşüncelerinizi Paylaşın</td> </tr> <tr> <td align="left" valign="top">İp Adresiniz</td> <td align="left" valign="top">:</td> <td><label for="ip"></label> <input name="ip" type="text" disabled id="ip" readonly value="<?php $ip = $_SERVER['REMOTE_ADDR']; echo " $ip"; ?>"> <input name="date" type="text" disabled id="date" readonly value="<?php $gun = date ('d'.".".'m'.".".'Y') ; echo " $gun"; ?>"></td> </tr> <tr> <td width="29%" align="left" valign="top">Adı </td> <td width="6%" align="left" valign="top">:</td> <td width="65%"> <input name="adi" type="text" id="adi" size="43" maxlength="30"></td> </tr> <tr> <td align="left" valign="top">Soyadı</td> <td align="left" valign="top">:</td> <td> <input name="soyadi" type="text" id="soyadi" size="43" maxlength="30"></td> </tr> <tr> <td align="left" valign="top">Birimi</td> <td align="left" valign="top">:</td> <td> <input name="birim" type="text" id="birim" size="43" maxlength="30"></td> </tr> <tr> <td align="left" valign="top">Bulunduğu Bölge</td> <td align="left" valign="top">:</td> <td> <input name="yer" type="text" id="bolge" size="43" maxlength="30"></td> </tr> <tr> <td align="left" valign="top"> Telefonu: </td> <td align="left" valign="top">:</td> <td> <input name="telefon" type="text" id="telefon" size="43" maxlength="30"> </td> </tr> <tr> <td align="left" valign="top"> İP Telefonu:</td> <td align="left" valign="top">:</td> <td> <input name="iptel" type="text" id="iptel" size="43" maxlength="30"></td> </tr> <tr> <td align="left" valign="top">Eposta</td> <td align="left" valign="top">:</td> <td> <input name="eposta" type="text" id="eposta" size="43" maxlength="30"></td> </tr> <tr> <td align="left" valign="top">Mesaj'ınız</td> <td align="left" valign="top">:</td> <td> <textarea name="mesaj" cols="40" rows="5" id="mesaj"></textarea></td> </tr> <tr> <td colspan="2" align="left" valign="top"> </td> <td><input type="submit" name="gönder" id="Gönder" value="Gönder"></td> </tr> </table> </form> </div> <? } ?> <? $Act = $_GET['Act']; Switch($Act){ default: index(); break; case "Gorev": Gorev (); break; case "Rapor": Rapor (); break; case "iletisim": iletisim (); break; } ?> </body> </html> [/code][/spoiler] Sayfa örneği yukarıda [spoiler] [code][color=#282828][size=2][background=rgb(248, 248, 248)]<? } [/background][/size][/color] function iletisim() { $ip = $_POST['ip']; $date = $_POST['date']; $adi = $_POST['adi']; $soyadi = $_POST['soyadi']; $birim = $_POST['birim']; $yer = $_POST['yer']; $telefon = $_POST['telefon']; $iptel = $_POST['iptel']; $eposta = $_POST['eposta']; $mesaj = $_POST['mesaj']; $veri_kaydi="INSERT INTO mesaj(ip,gun,adi,soyadi,birim,bolge,telefon,iptel,eposta,mesaj) values ('$ip','$date','$adi','$soyadi','$birim','$yer','$telefon','$iptel','$eposta','$mesaj')"; $vsorgu=mysql_query($veri_kaydi); if(isset($vsorgu) ) { echo "<b>Resim Eklendi</b>;"; } else{ echo "hata oldu"; } ?> <div id="sutun"> <table width="100%" border="0" style="margin-top:10px" > <tr> <th width="14%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index">Anasayfa</a> </th> <th width="17%" height="21" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index?Act=Gorev">Kayıtlı Görevler</a></th> <th width="17%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index?Act=Rapor">Kayıtlı Raporlar</a></th> <th width="12%" align="center" valign="middle" bgcolor="#999999" scope="col">Görev Ekle</th> <th width="15%" align="center" valign="middle" bgcolor="#999999" scope="col">Rapor Ekle</th> <th width="11%" align="center" valign="middle" bgcolor="#999999" scope="col">Telefon Defteri</th> <th width="7%" align="center" valign="middle" bgcolor="#999999" scope="col">Panel</th> <th width="7%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="index?Act=iletisim">İletişim</a></th> <th width="7%" align="center" valign="middle" bgcolor="#999999" scope="col"><a href="cikis">Çıkış</a></th> </tr> </table> </div> <br> <div id="iletisim"> <br> <form action="?Act=iletisim" method="post"> <table width="66%" border="0" cellspacing="1" align="center" cellpadding="0" bordercolor="#CCCCCC"> <tr> <td colspan="3" align="center" valign="top">Düşüncelerinizi Paylaşın</td> </tr> <tr> <td align="left" valign="top">İp Adresiniz</td> <td align="left" valign="top">:</td> <td><label for="ip"></label> <input name="ip" type="text" disabled id="ip" readonly value="<?php $ip = $_SERVER['REMOTE_ADDR']; echo " $ip"; ?>"> <input name="date" type="text" disabled id="date" readonly value="<?php $gun = date ('d'.".".'m'.".".'Y') ; echo " $gun"; ?>"></td> </tr> <tr> <td width="29%" align="left" valign="top">Adı </td> <td width="6%" align="left" valign="top">:</td> <td width="65%"> <input name="adi" type="text" id="adi" size="43" maxlength="30"></td> </tr> <tr> <td align="left" valign="top">Soyadı</td> <td align="left" valign="top">:</td> <td> <input name="soyadi" type="text" id="soyadi" size="43" maxlength="30"></td> </tr> <tr> <td align="left" valign="top">Birimi</td> <td align="left" valign="top">:</td> <td> <input name="birim" type="text" id="birim" size="43" maxlength="30"></td> </tr> <tr> <td align="left" valign="top">Bulunduğu Bölge</td> <td align="left" valign="top">:</td> <td> <input name="yer" type="text" id="bolge" size="43" maxlength="30"></td> </tr> <tr> <td align="left" valign="top"> Telefonu: </td> <td align="left" valign="top">:</td> <td> <input name="telefon" type="text" id="telefon" size="43" maxlength="30"> </td> </tr> <tr> <td align="left" valign="top"> İP Telefonu:</td> <td align="left" valign="top">:</td> <td> <input name="iptel" type="text" id="iptel" size="43" maxlength="30"></td> </tr> <tr> <td align="left" valign="top">Eposta</td> <td align="left" valign="top">:</td> <td> <input name="eposta" type="text" id="eposta" size="43" maxlength="30"></td> </tr> <tr> <td align="left" valign="top">Mesaj'ınız</td> <td align="left" valign="top">:</td> <td> <textarea name="mesaj" cols="40" rows="5" id="mesaj"></textarea></td> </tr> <tr> <td colspan="2" align="left" valign="top"> </td> <td><input type="submit" name="gönder" id="Gönder" value="Gönder"></td> </tr> </table> </form> [/code][/spoiler] Yukarıdakide sinir olduğum ve hatağımı göremediğim kod Quote Link to comment Share on other sites More sharing options...
carysma1 Posted August 22, 2012 Share Posted August 22, 2012 Sorgu hatası falan vermiyormu mysql_error() fonksiyonunu kullan eğer hata varsa buraya yaz inceleyelim Quote Link to comment Share on other sites More sharing options...
MasterWoo Posted August 23, 2012 Author Share Posted August 23, 2012 Yok sadce mysql'e veri eklemiyor o sorun Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.