Forum

Php Sorunsalı
 
Bildirimler
Hepsini Temizle

Php Sorunsalı

2 Yazılar
2 Üyeler
0 Likes
794 Görüntüleme
(@yasinyildiz-2)
Gönderiler: 27
Trusted Member
Konu başlatıcı
 

Merhaba Arkadaşlar aşağıda verdiğim kodlarda forma girilen değerlerin boş geçilmemesini istiyorum istisnasız nasıl bir ekleme ile tüm forma kullanıcıların değer girmelerini sağlayabilirim.

<?php
//session_start();
require_once('adodb/adodb-pear.inc.php');
require_once('adodb/SqlCommand.php');
require_once('libs/lib-data.php');
require_once('libs/lib-form.inc.php');
require_once('libs/lib-mail.php');
require_once('db.php');
require_once('lib.inc.php');

/*********************************************** ****
** Sayfa Post Edildi. Veriler Kayıt edilecek
*********************************************** ****/

if($_POST['kaydet'])
{

//dump();exit();

$db->debug = true;

if(trim($OPSIYON) == "") $err = "Opsiyon bilgisini giriniz";
if(trim($EMAIL) == "") $err = "Email adresini giriniz";
if(trim($FAX1) == "") $err = "Firma Faks alanını giriniz";
if(trim($TELEFON1) == "") $err = "Firma Telefonu alanını giriniz";
if(trim($ULKE) == "") $err = "Ülkeyi seçiniz.";
if(trim($VERGIDAIRESI) == "") $err = "Vergi Dairesini giriniz";
if(trim($VERGINO) == "") $err = "Vergi Numarasını giriniz";
// if(trim($FATURAIL) == "") $err = "Fatura Adresi İl bilgisini giriniz";
// if(trim($FATURAILCE) == "") $err = "Fatura Adresi İlçe bilgisini giriniz";
if(trim($FATURAADRES) == "") $err = "Fatura Adresiniz giriniz";
if(trim($FIRMA_UNVAN) == "") $err = "Firma Ünvanını giriniz";

// hata yoksa
if($err != "")
{
echo "<script>alert('".$err."');</script>";
exit();

}
else
{

$rsx = $db->Execute("SELECT * FROM KMTIKK WHERE KISIKOD = '".$KISIKOD."'");
$AD = $rsx->fields[AD];
$SOYAD = $rsx->fields[SOYAD];
//$EMAIL = $rsx->fields[EMAIL1];

$sql = "SELECT SEHIRAD FROM SHRKRT WHERE SEHIRKOD = '".$FATURAIL."'";
$rs = $db->Execute($sql);
$FATURAIL_ACIKLAMA = $rs->fields[SEHIRAD];

$sql = "SELECT SEHIRAD FROM SHRKRT WHERE SEHIRKOD = '".$IRSALIYEIL."'";
$rs = $db->Execute($sql);
$IRSALIYEIL_ACIKLAMA = $rs->fields[SEHIRAD];

$mail_tablo = '

<TABLE cellSpacing=10 width="580" cellPadding=0 border=0 style="border:1px solid #808080">
<TBODY>
<TR>
<TD valign=top>

<TABLE cellSpacing=10 cellPadding=0 border=0 width="100%">
<TBODY>
<TR>
<TD colSpan=2 height=25>
<span style="background-color:#E0E0E0;width:100%;padding:2px;border:1px solid #C0C0C0">&nbsp;<B>Tedarikçi - Cari Hesap Açma Talep Formu</B></span>
</TD>
</TR>
<TR>
<TD vAlign=middle>Firma Ünvanı</TD>
<TD vAlign=middle>
: '.$FIRMA_UNVAN.'
</TD>
</TR>
<TR>
<TD vAlign=middle>Fatura Adresi</TD>
<TD vAlign=middle>
: '.$FATURAADRES.'
</TD>
</TR>
<TR>
<TD vAlign=middle>Fatura İlçesi</TD>
<TD vAlign=middle>
: '.$FATURAILCE.'
</TD>
</TR>
<TR>
<TD vAlign=middle>Fatura İli</TD>
<TD vAlign=middle>
: '.$FATURAIL_ACIKLAMA.'
</TD>
</TR>
<TR>
<TD vAlign=middle>Vergi Numarası</TD>
<TD vAlign=middle>
: '.$VERGINO.'
</TD>
</TR>
<TR>
<TD vAlign=middle>Vergi Dairesi</TD>
<TD vAlign=middle>
: '.$VERGIDAIRESI.'
</TD>
</TR>
<TR>
<TD vAlign=middle>Ülke</TD>
<TD vAlign=middle>
: '.cpm_referans_aciklama($tabload="CARKRT",$alanad= "ULKEKOD",$ULKE).'
</TD>
</TR>
<TR>
<TD vAlign=middle>Telefon</TD>
<TD vAlign=middle>
: '.$TELEFON1.'
</TD>
</TR>
<TR>
<TD vAlign=middle>Faks</TD>
<TD vAlign=middle>
: '.$FAX1.'
</TD>
</TR>
<TR>
<TD vAlign=middle>Email Adresi</TD>
<TD vAlign=middle>
: '.$EMAIL.'
</TD>
</TR>
<TR>
<TD vAlign=middle>Döviz Cinsi</TD>
<TD vAlign=middle>
: '.cpm_referans_aciklama($tabload="DVZHAR",$alanad= "DOVIZCINS",$DOVIZCINS).'
</TD>
</TR>
<TR>
<TD vAlign=middle>Ödeme Banka Adı</TD>
<TD vAlign=middle>
: '.$ODEMEBANKAADI.'
</TD>
</TR>
<TR>
<TD vAlign=middle>Ödeme IBAN Kodu</TD>
<TD vAlign=middle>
: '.$ODEMEIBANKODU.'
</TD>
</TR>
<TR>
<TD vAlign=middle>Opsiyon</TD>
<TD vAlign=middle>
: '.$OPSIYON.'
</TD>
</TR>

<TR>
<TD vAlign=middle>Talep Eden Kişi</TD>
<TD vAlign=middle>
: '.$AD.' '.$SOYAD.'
</TD>
</TR>

</table>

</TD>
</TR>
</table>
';

//echo $mail_tablo;
//exit;

// IK'ya email atalım.
$INCLUDE_DIR = "phpmailer/";
require_once($INCLUDE_DIR . "class.phpmailer.php");

//$email_address = "[email protected]";
//$email_name = "Tuğba Güder";

$email_to = Array(
Array("[email protected]","Muhasebe PU"),
Array("[email protected]","Fabrika Santral"),
);
//$email_cc = Array(Array("[email protected]","Deyz i Hiçsolmaz"),Array("[email protected]", "Etel Özsarfati"));

$email_Subject = "Tedarikçi - Cari Hesap Açma Talep Formu - ".$FIRMA_UNVAN;
$email_Body = $mail_tablo;
$email_Body .= "<BR><BR><b>Not :</b> Bu email bilgilendirme amaçlı gönderilmiştir. Lütfen bu emaili yanıtlamayınız.";

$mail_array = Array(
'EMAIL_TO' => $email_to,
'EMAIL_CC' => $email_cc,
'EMAIL_SUBJECT' => $email_Subject,
'EMAIL_BODY' => $email_Body,
'REPLY_ADMIN' => 0
);

//echo "<pre>";
//print_r($mail_array['EMAIL_TO']);
//echo "</pre>";
cpm_mail_gonder($mail_array);
//exit;

echo "
<script>
try {
alert(\"Muhasebe Departmanına bilgiler gönderildi.\");
parent.location = \"cari_hesap_acma_talep_formu_tedarikci.php\";
}catch(e){alert(e)}
</script>
";

}

exit();
} // end if($_POST['kaydet'])

/*********************************************** ****
** Post İşlemi Sonu
*********************************************** */

/******************************************** ****
** Form
*********************************************** ****/

?>
<html>
<head>
<title>TEDARİKÇİ - CARİ HESAP AÇMA TALEP FORMU</title>
<meta http-equiv="Content-Language" content="tr">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1254">
<link rel="stylesheet" href="<?echo $root_url."images/".$TextDirection."/interface.css";?>">
<script type="text/javascript" src="<?echo $root_url?>scripts/ajax.js"></script>
<script type="text/javascript" src="<?echo $root_url?>scripts/tutar_format.js"></script>
<?js_calendar();?>
<script>
function onayla(){
if(!confirm("Formdaki bilgileri lütfen iyice kontrol ediniz. Eğer hatalı ise düzeltiniz.\n\nFormu göndermek istiyor musunuz?")) return;
document.form1.submit();
}
</script>
<center>
<TABLE cellSpacing=0 cellPadding=0 width="580" border=0>
<TR>
<td width=100% align=center>
<FORM name=form1 method="post" target="ifrsave">
<TABLE cellSpacing=10 cellPadding=0 border=0 style="border:1px solid #808080">
<TBODY>
<TR>
<TD valign=top>

<TABLE cellSpacing=10 cellPadding=0 border=0>
<TBODY>
<TR>
<TD colSpan=4 height=25>
<span style="background-color:#E0E0E0;width:100%;padding:2px;border:1px solid #C0C0C0">&nbsp;<B>Tedarikçi - Cari Hesap Açma Talep Formu</B></span>
</TD>
</TR>
<TR>
<TD vAlign=middle>Firma Ünvanı</TD>
<TD vAlign=middle>
: <INPUT name="FIRMA_UNVAN" value="" class="flat" style="font-size:14px;width:280px;text-align:left;font-weight:bold; null!">
</TD>
</TR>
<TR>
<TD vAlign=middle>Fatura Adresi </TD>
<TD vAlign=middle>
:&nbsp;<TEXTAREA name="FATURAADRES" class="flat" style="font-size:14px;width:40px;text-align:left;font-weight:bold;width:95%;height:50px; null!"></TEXTAREA>
</TD>
</TR>
<TR>
<TD vAlign=middle>Fatura İlçesi</TD>
<TD vAlign=middle>
:
<INPUT name="FATURAILCE" value="" class="flat" style="font-size:14px;width:140px;text-align:left;font-weight:bold; null!">
</TD>
</TR>
<TR>
<TD vAlign=middle>Fatura İli</TD>
<TD vAlign=middle>
:
<?=combo_il($name="FATURAIL", $value="", $onchange="", $onfocus="", $style="font-size:14px;text-align:left;font-weight:bold; null!")?>
</TD>
</TR>
<TR>
<TD vAlign=middle>Vergi Numarası</TD>
<TD vAlign=middle>
: <INPUT name="VERGINO" value="" class="flat" style="font-size:14px;width:150px;text-align:left;font-weight:bold; null!">
</TD>
</TR>
<TR>
<TD vAlign=middle>Vergi Dairesi</TD>
<TD vAlign=middle>
: <INPUT name="VERGIDAIRESI" value="" class="flat" style="font-size:14px;width:150px;text-align:left;font-weight:bold; null!">
</TD>
</TR>

<TR>
<TD vAlign=middle>Ülke</TD>
<TD vAlign=middle>
:
<?=combo_CARKRT_ULKEKOD($name="ULKE", $value="052", $onchange="", $onfocus="", $style="font-size:14px;text-align:left;font-weight:bold;")?>
</TD>
</TR>

<TR>
<TD vAlign=middle>Telefon</TD>
<TD vAlign=middle>
: <INPUT name="TELEFON1" value="" class="flat" style="font-size:14px;width:150px;text-align:left;font-weight:bold; null!">
</TD>
</TR>
<TR>
<TD vAlign=middle>Faks</TD>
<TD vAlign=middle>
: <INPUT name="FAX1" value="" class="flat" style="font-size:14px;width:150px;text-align:left;font-weight:bold; null!">
</TD>
</TR>
<TR>
<TD vAlign=middle>Email</TD>
<TD vAlign=middle>
: <INPUT name="EMAIL" value="" class="flat" style="font-size:14px;width:280px;text-align:left;font-weight:bold; null!">
</TD>
</TR>

<TR>
<TD vAlign=middle>Döviz Cinsi</TD>
<TD vAlign=middle>
:
<?=combo_DVZHAR_DOVIZCINS($name="DOVIZCINS", $value="", $onchange="", $onfocus="", $style="font-size:14px;text-align:left;font-weight:bold;")?>
</TD>
</TR>

<TR>
<TD vAlign=middle>Ödeme Banka Adı</TD>
<TD vAlign=middle>
: <INPUT name="ODEMEBANKAADI" value="" class="flat" style="font-size:14px;width:280px;text-align:left;font-weight:bold; null!">
</TD>
</TR>
<TR>
<TD vAlign=middle>Ödeme IBAN Kodu</TD>
<TD vAlign=middle>
: <INPUT name="ODEMEIBANKODU" value="" class="flat" style="font-size:14px;width:280px;text-align:left;font-weight:bold; null!">
</TD>
</TR>

<TR>
<TD vAlign=middle>Ödeme Opsiyonu (Gün)</TD>
<TD vAlign=middle>
: <INPUT name="OPSIYON" value="" class="flat" style="font-size:14px;width:140px;text-align:left;font-weight:bold; null!">
</TD>
</TR>

<TR>
<TD vAlign=middle>Talep Eden Kişi</TD>
<TD vAlign=middle>
: <?
echo combo_kisi($name="KISIKOD", $value="", $onchange="", $onfocus="", $style="font-size:14px;")
?>
</TD>
</TR>

</table>

</TD>
</TR>
</table>

<BR>
&nbsp;&nbsp;
&nbsp;
<button onclick="onayla();" name=kaydet value="1">Tamam</button>
&nbsp;&nbsp;
<INPUT type=button value="Vazgeç" onclick=window.close()" name="vazgec">
<BR>
</form>
</td>
</tr>
</table>
</center>

<div style="display:none">
<IFRAME name="ifrsave" width="100%" src="" height=0></IFRAME>
</div>

 
Gönderildi : 16/11/2016 17:45

(@HalitSiMSEK)
Gönderiler: 94
Estimable Member
 

if(empty($uadi) || empty($kadi) || empty($ktarih) || empty($ksure)){
}
else {
$ekle = $db->query("insert into kurunler(uadi,kadi,ktarih,ksure) values ('$uadi','$kadi','$ktarih','$ksure')");
}

 

Kodu benim yaptığım bir çalışmadan çektim. Mantık olarak sql sorgunu yapmadan önce bir koşul ataması yapman gerekiyor kırmızıyla gösterdiğim kısımda koşulumuz. hepsi dolu ise sql kodu çalışır eğer dolu değilse çalışmaz.

 
Gönderildi : 17/11/2016 13:20

Paylaş: