php - what a correct statement for this code?

759

I want print $str_agunan that returned from statement. i make statement that all values can be true, so i use operator .= but on webview its showing string from rows before. thanks advance, sorry if my english is bad.

$agunan = db_query("SELECT * FROM pengajuan_agunan where cif_nokode = '".$baris->no_kode."'");
        $cnt_agunan = db_result(db_query("SELECT COUNT(*) FROM pengajuan_agunan WHERE cif_nokode = '" . $baris->no_kode. "'"));

        if($cnt_agunan > 0) {
            while ($data_agunan = db_fetch_array($agunan)) {

                if ($data_agunan['jenis_agunan'] == 1 && !empty($data_agunan['kend_no_bpkb'])) {

                    $str_agunan .= "Jenis agunan kendaraan dengan no. BPKB " . $data_agunan['kend_no_bpkb'] . ", ";

                }

                if ($data_agunan['jenis_agunan'] == 2 && !empty($data_agunan['shm_no'])) {

                    $str_agunan .= "Jenis agunan sertifikat dengan no. SHM " . $data_agunan['shm_no'] . ", ";

                }

                if ($data_agunan['jenis_agunan'] == 3 && !empty($data_agunan['karyawan_nama'])) {

                    $str_agunan .= "Jenis agunan karyawan dengan nama karyawan " . $data_agunan['karyawan_nama'] . ", ";

                }

                if ($data_agunan['jenis_agunan'] == 4 && !empty($data_agunan['sph_no'])) {

                    $str_agunan .= "Jenis agunan SPH dengan no. SPH " . $data_agunan['sph_no'] . ", ";
                } 
            }
        }else{
            $str_agunan = 'Data agunan belum diisi.';
        }
print_r($str_agunan);

enter image description here

People are also looking for solutions to the problem: php - Missing argument 1 error in laravel5.1

Source

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

Similar questions

Find the answer in similar questions on our website.