Tanya validasi update PHP ?
Kamis, 05 Januari 2012 by ewepaksa
Selamat membaca . Software Akuntansi Laporan Keuangan Terbaik Selamat siang Gan, Ane rada bingung sama validasi update information cardinal nih. contohnya kaya gini 08-Jan-2012 07:05 s/d 10:00 08-Jan-2012 13:00 s/d 15:00 kalau accumulation yang 07:05 s/d 10:00 saya rubah menjadi 07:05 s/d 20:00 akan terupdate, seharusnya tidak bisa karena sudah ada wad 15:00. Ini codenya gan PHP Code: <?php $date=$_GET['tanggal']; $barang=$_GET['barang']; $place=$_GET['place']; $time1=$_GET["time1"]; $time2=$_GET["time2"]; $sqlcek=mysql_query("SELECT * FROM datalcdharian WHERE date='$date' AND id_lcdbarang='$barang' AND id_place='$place' AND time1='$time1' AND time2='$time2'"); $sqlcek2=mysql_query("SELECT * FROM datalcdharian WHERE date='$date' AND id_lcdbarang='$barang' AND ((Time('$time1') BETWEEN time1 AND time2) OR (Time('$time2') BETWEEN time1 AND time2)) AND id_datalcdpem! injaman<>'$id'"); //$sqlcek2=mysql_query("SELECT * FROM datalcdharian WHERE date='$date' AND id_lcdbarang='$barang' AND (time1 between '$time1' AND '$time2') OR (time2 between '$time1' AND '$time2')"); $sqlcek3=mysql_query("SELECT * FROM datalcdharian WHERE date='$date' AND id_place='$place' AND ((Time('$time1') BETWEEN time1 AND time2) OR (Time('$time2') BETWEEN time1 AND time2)) AND id_datalcdpeminjaman<>'$id'"); // Ini ifnya if(mysql_fetch_assoc($sqlcek2)>=1) { ?><script language="javascript">alert("Sory1, LCD or Meeting Room have bee! n boooked. Please booked again.");document! .locatio n="managelcdharian.php";</script><?php } elseif(mysql_fetch_assoc($sqlcek3)>=1) { ?><script language="javascript">alert("Sory2, LCD or Meeting Room have been boooked. Please booked again.");document.location="managelcdharian.php";</script><?php } else { include("updateemail.php"); } Saya sudah coba ganti dengan pakai PHP Code: AND ((Time('$time1') BETWEEN time1 AND time2) OR (Time('$time2') BETWEEN time1 AND time2) [b]OR (Time('$time2') > time2)[/b]) Tetapi accumulation yang kedua malah tidak bisa dirubah selalu akan masuk ke warning validasi. Tolong ya Mastah ?? Terima kasih. :Yb:Yb:Yb:)b:)b:)b:iloveindonesias:iloveindonesias :iloveindonesiasJual Mobil Murah . Ultrabook Notebook Tipis Harga Murah Terbaik . Harga Notebook .
Angga Sanusi
Angga Sanusi
Posting Komentar