bnmbertsurhetertertertertertertertpdf'tdfg

hjkhghopjkertteerterterterertertrtoirh bnmbertsurhetertertertertertertertpdf'tdfg

<?php

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$dbname = 'pokok';
$mysqli = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

//$kod_lama='KUALE';
$lokascode='TMJF2';

//echo $update_kod = "UPDATE LAN_INVENTORI SET INV_LOKASLAND='".$lokascode."' WHERE INV_LOKASLAND='".$kod_lama."'" ;
 //$query3 = mysql_query($update_kod);

echo $sql = "SELECT
				*
			FROM
				LAN_INVENTORI
			WHERE
            INV_LOKASLAND='".$lokascode."'";

$result = $mysqli -> query($sql);
//$row = $result -> fetch_assoc();

while ($row = mysqli_fetch_array($result)) {

//$query = mysql_query($sql);
//while ($row = mysql_fetch_assoc($query)) {

$sql2 = "
			SELECT
				CONCAT(
					'".$lokascode."/',
					DATE_FORMAT(NOW(), '%y'),
					'/',
					LPAD(
						IFNULL(
							MAX(RIGHT(INV_INVENTORI, 4)) + 1,
							1
						),
						4,
						0
					)
				) AS kod
			FROM
				LAN_INVENTORI
			WHERE
				LEFT (INV_INVENTORI, 5) = '".$lokascode."'
			AND SUBSTRING(INV_INVENTORI, 7, 2) = DATE_FORMAT(NOW(), '%y')
		";
    //$query2 = mysql_query($sql2);
    //$row2 = mysql_fetch_assoc($query2);
    $result2 = $mysqli -> query($sql2);
	$row2 = $result2 -> fetch_assoc();
	$kod = $row2['kod'];

//echo $row["INV_NOMBORIDS"];
    //echo $row["INV_LOKASLAND"];
    //echo $row["INV_INVENTORI"];
    echo "<br>";

echo $update = "UPDATE LAN_INVENTORI SET INV_INVENTORI='".$kod."' WHERE INV_NOMBORIDS='".$row["INV_NOMBORIDS"]."'" ;
    mysqli_query($mysqli, $update);
    echo "<br>";
}
?>