Code: Select all
SELECT FORMAT(subtotal,2) FROM orders WHERE orders_id = %ID%
the TV and DV both is showing 30,000.00 (correct). But the database is inserted as 30 only.
Another example, TV dan DV is showing 643,500.00. But when I check the DB using phpmyadmin, it's only inserted as 643.
Here is another example :
- Showing 1,632,000.00 only inserted as 1 on DB
- Showing 1,120,000.00 only inserted as 1 on DB
- Showing 51,000,000.00 only inserted as 51 on DB
- Showing 5,499,999.00 only inserted as 5 on DB
so the behavior is the first number before comma only is inputed to database while the rest is missing. When I refresh the page, the first value is showing just like the value that inserted on DB example 30. And when it's triggered by the CALCULATED FIELD, it turn into 30,123 (the correct value is showing). But the inserted DB still 30 only.
When I use this kind of query :
Code: Select all
SELECT subtotal FROM orders WHERE orders_id = %ID%
I have tried a lot of way to solve this problem, but got no luck. Really wish someone can help me here. Thanks.
If someone need to investigate this error, please let me know, I'm willing to pay someone's service to fix this if needed. Thanks all.
NB :
- my appgini version is 5.94 revision 1132
- my DB version is :
Server: 127.0.0.1 via TCP/IP
Jenis server: MariaDB
Koneksi server: SSL sedang tidak digunakan Dokumentasi
Versi server: 10.4.11-MariaDB - mariadb.org binary distribution
Versi protokol: 10
Pengguna: root@localhost
Kumpulan karakter server: UTF-8 Unicode (utf8mb4)
-My Web Server is :
Apache/2.4.43 (Win64) OpenSSL/1.1.1f PHP/7.4.4
Versi klien basis data: libmysql - mysqlnd 7.4.4
Ekstensi PHP: mysqli Dokumentasi curl Dokumentasi mbstring Dokumentasi
Versi PHP: 7.4.4