require("connect.inc.php"); ?>
Bagi Deviden
|
Entry Deviden Baru
|
Delete Deviden
|
Semester
$q_smt = "SELECT semester,tgl_awal,tgl_semester FROM deviden " ; $hasil_smt = mysql_db_query($db, $q_smt, $koneksi) or die("Kesalahan pada query!"); while (list($semester,$tgl_awal,$tgl_semester) = mysql_fetch_row($hasil_smt)) { ?>
>
Periode
>Semua periode $q_periode = "SELECT id,nama_periode FROM periode order by nama_periode " ; $hasil_periode = mysql_db_query($db, $q_periode, $koneksi) or die("Kesalahan pada query!"); while (list($id,$nama_periode) = mysql_fetch_row($hasil_periode)) { ?>
>
if (!$tambah) { } else { //$tgl_smt = substr(strstr($semester_form,"@"),1,10); //$tgl_awal = substr($semester_form,0,strpos($semester_form,"@")); $query1 = "select sum(per_rupiah) per_1 from deviden where tgl_semester >='".$semester_form."'"; //echo $query1; $hasil1 = mysql_db_query($db, $query1, $koneksi) or die("Kesalahan pada query!"); list($per_1) = mysql_fetch_row($hasil1); $query2 = "select nilai_deviden from shu_saham where laba_semester='".$periode."'"; $hasil2 = mysql_db_query($db, $query2, $koneksi) or die("Kesalahan pada query!"); list($nilai_deviden) = mysql_fetch_row($hasil2); $query = "Update shu_saham set nilai_deviden = nilai_deviden + (rupiah_saham*".$per_1.") where tgl_saham<='".$semester_form."' and laba_semester='".$periode."'"; $hasil = mysql_db_query($db,$query,$koneksi) or die('Kesalahan pada proses query!'); // echo "
Update Sukses
"; echo $query; //echo '
'; // $i++; //} } ?>