Jump to content

Nerde Hata Yapıyorum.

MasterWoo
 Share

Recommended Posts

MasterWoo Newbie

MasterWoo

Posted
Posted
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&ouml;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">&Ccedil;ı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&ouml;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">&Ccedil;ı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&ouml;rev Yeri</th>
<th width="19%" align="center" valign="baseline" bgcolor="#D6D6D6" scope="col">G&ouml;reve Geden Kişiler</th>
<th width="15%" align="center" valign="baseline" bgcolor="#D6D6D6" scope="col">G&ouml;rev Tarih</th>
<th width="12%" align="center" valign="baseline" bgcolor="#D6D6D6" scope="col">G&ouml;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&ouml;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">&Ccedil;ı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&ouml;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">&Ccedil;ı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&uuml;ş&uuml;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&ouml;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">&nbsp;</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&ouml;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">&Ccedil;ı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&uuml;ş&uuml;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&ouml;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">&nbsp;</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
Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...