Masino Sinaga

Web Development and PHPMaker

Anda di sini: Beranda / Web Development / Who Wants This Customization Version of PDO CRUD?
Bukti Lain Aplikasi Web yang Dibuat oleh PHPMaker Bisa Diupdate dengan Cepat

Who Wants This Customization Version of PDO CRUD?

Kam, 6 Agustus 2020 oleh Masino Sinaga 2 Komentar

Does anybody use PDO CRUD from CodeCanyon? Well, I do.

Unfortunately, there are some limitation you can see from this demo. What was that? Well, here they are:

  1. There are no “Port” setting in config file, so that if you are using MySQL with port other than 3306, you cannot adjust it from config file.
  2. When a single record deleted in the last page until all of the records in that page are deleted, or even all the selected records in that last page are deleted, then the UI will be broken. There are error messages as follow:

    - Notice: Undefined offset: 0 in xxx\script\classes\PDOCrud.php on line 2987
    - Warning: array_keys() expects parameter 1 to be array, null given in xxx\script\classes\PDOCrud.php on line 2987
    
  3. When you click a column header for the very first time, then data in that column will be sorted Ascending, but the icon in column header display as Descending sort. This is very very bad user experiences!
  4. Sort icon in header column does not retain after browsing the records to another page via pagination. End-users will not know what is the last column that being sorted, and this is a bad user experiences.
  5. The selected record per page does not retain after browsing the records to another page via pagination. End users will not know what is last record per page that selected, and this is a bad user experiences.
  6. The selected column in Search panel does not retain after browsing the records to another page via pagination. End users will not know what is last selected column that used for searching, and this is a bad user experiences.
  7. The search term does not retain after browsing the records to another page via pagination. End users will not know what is last search terms that used for searching, and this is a bad user experiences.
  8. There are no Reset Search button to remove the search criteria including to remove the field sort setting. Users will have to select All for Search Column and remove the Search Terms, after that click on Go button. This is of course a bad user experiences, too.

So I made some customization/modification to the original scripts. You can see The Customization Demo from this link.

As you can see, from my Customization Demo above, and after comparing the Original Demo with my demo above, here are the changes I made:

  1. Added “Port” setting in config file. This is very useful if you use port other than 3306 for your MySQL Server.
  2. Added another options in Records per Page select control in Pagination section. By default the options are 10, 25, 50, 100, ALL. Now it becomes: 1, 3, 5, 10, 25, 50, 100, ALL. This is very useful if you want to display the records fewer than 10 in a current page.
  3. Added the ability to auto select Records per Page that chosen by users for the very last time. This is very useful if you browse the records to another page, then you will be easy to know how many records displayed in per page.
  4. Fixed error if a record is deleted or some selected records are deleted in the last page until there are no records anymore in that last page. This fixes is very useful to remove the error that found above, and of course this error should not be displayed in the page.
  5. Added the ability to remember the last field that sort (order by) whether ASC or DESC. This is very useful if you browse the records to another page, then you will know which field in the table that is being currently sorted.
  6. Improved the sort icon, now will be sorted according to the current sort. Icon Asc for Ascending sort; icon Desc for Descending sort.
  7. Improved toggle sort that will be applied to another column. For example, when you click on the very first time in Customer_Name column it will sort Asc, and then when you click on Customer_Address column it will sort Desc in the Customer_Address column, and so forth.
  8. Added the ability to remember the selected Column in Search Panel. This is very useful if you browse the records to another page, then you will know which column is used as one of Field param in Search Panel.
  9. Added the ability to remember the search terms in Search Panel. This is very useful if you browse the records to another page, then you will know the search terms that already entered before.
  10. Added Reset Search button to reset the search criteria (remove the selected search column and search terms) from Search Panel. This also will remove the last sort status in a column. This is very useful if you want to display all the records in the table as initialized when a page is being loaded.
  11. Changed the icon for Delete Selected Records from Cross to Trash. This change will more make sense to see the Trash icon for deleting record instead of Cross icon. Cross icon should be used to reset the table to the initial state. This is very useful to distinguish the two different functionalities.
  12. Added Indonesian translation file. Of course you may also add your own language based on the existing language files available. This is very useful to know how you should be able to implement multi-language for your PDO CRUD web applications.

I customized this PDO SCRUD script for version 4.6.1. The author of this script is Pritesh Gupta. So, make sure you have already bought this script from CodeCanyon (see the link in the first paragraph above).

So, my question is: Who Wants This Customization Version of PDO CRUD?. Are you interested in this customized version? Yeah, you will see this change after buying this customized version from me.

For your information, I did not sell this script. I just offered you the service for the customization for PDO CRUD. So, again, make sure you have already purchased/bought this script from CodeCanyon website above. After that, if you are obviously interested with this customized version, then you may buy this customized version from me.

Just drop me an email to masino[dot]sinaga[at]gmail[dot]com okay? 😉

Ditempatkan di bawah: Web Development Ditag dengan:CRUD, PDO, PDO CRUD, Web Applications

Masino Sinaga

Web Developer pengguna PHPMaker untuk membangun Aplikasi Web sejak tahun 2004. Sampai sekarang masih aktif dan rajin membagikan pengalamannya menggunakan PHPMaker melalui situs masinosinaga.com dan ilovephpmaker.com.

Bukti Lain Aplikasi Web yang Dibuat oleh PHPMaker Bisa Diupdate dengan Cepat

Komentar

  1. Dayan mengatakan

    Kam, 6 Agustus 2020 pada 9:03 pm

    Wau, dasarnya emang udah fleksibel, di revisi lagi, bisikin dong gimana cara dapetin yang udah di modif?

    Balas
    • Masino Sinaga mengatakan

      Jum, 7 Agustus 2020 pada 6:39 am

      Hehe, sudah ta bisikin barusan lewat email ya. 😉

      Balas

Tinggalkan Balasan Batalkan balasan

Alamat email Anda tidak akan dipublikasikan. Ruas yang wajib ditandai *

Situs ini menggunakan Akismet untuk mengurangi spam. Pelajari bagaimana data komentar Anda diproses.

Pos-pos Terbaru

  • Item Menu Tetap Aktif Meskipun Sedang Menampilkan Halaman Tambah, Ubah, Tampilkan, Cari di PHPMaker 2022
  • Hati-Hati Memilih Versi PHP Sebelum Generate Code di PHPMaker 2022
  • Alasan AlwaysUseEnglishUSLocale Sebaiknya Aktif di Masino Extensions untuk PHPMaker 2022
  • MasinoInputMask18 Extension, Autoformat Angka dengan Fitur Lebih Kaya di PHPMaker 2022
  • MasinoSignature18 Extension, Mudahnya Mengelola Tanda Tangan di PHPMaker 2022

Menu

  • Siapa Saya?
  • Web Development
  • PHPMaker
  • Umum
  • Syarat dan Ketentuan
  • Sitemap (Peta Situs)
  • Komentar

Komentar Terbaru

  • Masino Sinaga pada Ini Dia Fitur-Fitur yang Terdapat di Masino Extensions untuk PHPMaker 2022
  • muslih pada Ini Dia Fitur-Fitur yang Terdapat di Masino Extensions untuk PHPMaker 2022
  • Masino Sinaga pada PHPMaker 2021 Menggunakan DBAL Menggantikan ADOdb
  • Bayu pada PHPMaker 2021 Menggunakan DBAL Menggantikan ADOdb
  • Masino Sinaga pada PHPMaker 2021 Menggunakan DBAL Menggantikan ADOdb

Situs Terkait

  1. I Love PHPMaker
  2. Situs Resmi PHPMaker
  3. Forum Diskusi PHPMaker
  4. PHPMaker di IlmuKomputer.com
  5. PHPMaker Learning

Baru di PHPMaker?

Baca ini terlebih dulu ...

  1. Ayo Menjadi Web Developer yang Cerdas!
  2. PHPMaker: PHP Code Generator + PHP Framework
  3. Pertanyaan-Pertanyaan yang Paling Sering Diajukan Seputar PHPMaker
  4. Tips buat Anda Pemula yang Baru Mengenal dan Menggunakan PHPMaker
  5. Bacalah Help, Bacalah Help, dan Bacalah Help di PHPMaker!

(c) Masino Sinaga 2009 - 2021 | WordPress | Catat masuk | Kembali ke atas