<?php include('../../../config/main_function.php'); $secure = "cAh3DrJACzw4RbU"; $connection = connectDB($secure); if ($connection) { $sql = "SELECT * FROM `tbl_member_payment` WHERE NOT invoice_number LIKE 'INV%'"; $res = mysqli_query($connection, $sql); while ($row = mysqli_fetch_assoc($res)) { $new_inv = 'INV'.$row['invoice_number']; $sql_update = "UPDATE tbl_member_payment SET invoice_number = '$new_inv' WHERE member_id = '{$row['member_id']}'"; $res_update = mysqli_query($connection, $sql_update) or die($connection->error); if ($res_update) { $arr['result'] = 1; } else { echo $sql_update; } } } else { $arr['result'] = 9; } mysqli_close($connection); echo json_encode($arr); ?>