Kumpulan Link

 1. grid grow https://www.kindacode.com/snippet/tailwind-css-make-a-child-element-fill-the-remaining-space/ 2. headles ui  https://headlessui.com/ 3. filter nama  https://upmostly.com/tutorials/react-filter-filtering-arrays-in-react-with-examples 4. hapus ouline focus https://www.kindacode.com/snippet/tailwind-css-removing-text-input-outline-on-focus/ 5. static top  head table https://tailwindcomponents.com/component/sticky-table-header 6. border sparate https://stackoverflow.com/questions/57166162/table-headers-positionsticky-and-border-issue 7. fit table colum  https://simplernerd.com/tailwind-css-set-table-column-to-minimum-content-width/ 8. plugin tailwind form https://github.com/tailwindlabs/tailwindcss-forms 9. install tailwind https://tailwindcss.com/docs/installation/using-postcss

 1. hapus data duplicate lebih dari 1  SQL 2005 with CTE as ( SELECT BARA, KODE, RN = ROW_NUMBER()OVER(PARTITION BY BARA, KODE ORDER BY BARA) FROM tes ) DELETE FROM CTE WHERE RN > 1 2. Hapus data duplicate lebih dari 1 sql 2000 supplier tidak bisa update CREATE TABLE temp_tes (     bara varchar(255),     kode varchar(255), ); INSERT INTO temp_tes ( bara, kode  ) select max(bara), max(kode) from tsupp GROUP BY bara select * from temp_tes where bara = '6006304' select * from tsupp where bara = '6006304' INSERT INTO tsupp ( bara, kode ) select max(bara), max(kode) from temp_tes GROUP BY bara select * from tsupp TRUNCATE TABLE tsupp; TRUNCATE TABLE temp_tes;

 1. belajar next js  routing  https://mzaky.medium.com/tutorial-nextjs-1-menginstall-dan-mengenal-routing-di-nextjs-2da136370bd5 2. form chakra ui https://codesandbox.io/s/next-js-11-jwt-authentication-example-5lhh1?from-embed=&file=/helpers/api/jwt-middleware.js 3. Connect mysql next js  https://www.youtube.com/watch?v=nnyGB5wSh7Y 4. jsonwebtoken https://medium.com/swlh/jwt-json-web-tokens-user-authentication-in-next-js-web-application-51deab8f2e96 5. json web token  https://mfikri.com/artikel/login-jwt-express-react-mysql 6. cara push router  https://nextjs.org/docs/api-reference/next/router 7. menggunakan .env  https://github.com/dotenv-org/examples/blob/master/dotenv-esm/index.mjs 8. membuat cookies di next js  https://stackoverflow.com/questions/57559239/cant-set-a-cookie-using-nextjs-9s-api-route 9. membuat sidebar  https://www.youtube.com/watch?v=mN3P_rv8ad4' 10. install stayled next js https://medium.com/nerd-for-tech/using-next-j...

 1. membuat delay foreach https://stackoverflow.com/questions/45498873/add-a-delay-after-executing-each-iteration-with-foreach-loop 2. menambahkan object array  https://widiyanata.com/blog/program-javascript-untuk-menambahkan-objek-ke-array/ 3. remove object aray https://stackoverflow.com/questions/10024866/remove-object-from-array-using-javascript 4. find array https://appdividend.com/2022/06/04/javascript-array-find/#:~:text=Finding%20the%20object%20in%20the,it%2C%20it%20returns%20the%20object. 5. update object  array  https://www.delftstack.com/howto/javascript/javascript-update-object-in-array/ 6. format yyy-mm-dd https://stackoverflow.com/questions/23593052/format-javascript-date-as-yyyy-mm-dd

 1. belajar intent klik tombol lari ke halaman berikut nya  https://www.twoh.co/2018/05/13/belajar-memahami-konsep-activity-dan-intent-dengan-kotlin-di-android/ 2. btc tracker  kotlin https://medium.com/swlh/android-tutorial-part-1-using-java-websocket-with-kotlin-646a5f1f09de 3. insert sqlite  https://www.javatpoint.com/kotlin-android-sqlite-tutorial#

 1. font monolisa dan kawan kawan  https://github.com/cancng/fonts

 1. insert from another table  https://medium.com/@shadow.technos/copy-data-from-one-table-to-another-table-in-mysql-f1d563211028 2. update iner join table query   https://stackoverflow.com/questions/8057565/mysql-update-inner-join-tables-query 2. pembulana mysql  https://kursuswebprogramming.com/cara-menggunakan-fungsi-mysql-round/

 1. Connet php to odbc https://www.daniweb.com/programming/web-development/threads/498913/connection-function-using-odbc-with-pdo-oop 2. multiple upload php  https://makitweb.com/multiple-files-upload-at-once-with-php/ 3. mengatasi blank saat export dari php ke excel  this one worked for me. ob_end_clean(); $writer->save('php://output'); exit(); 4. tambahkan database  <?php include '../vendor/autoload.php'; use PhpOffice\PhpSpreadsheet\Spreadsheet; use PhpOffice\PhpSpreadsheet\Writer\Xlsx; // Koneksi ke database $host = "localhost"; $username = "root"; $password = ""; $dbname = "database_name"; $conn = new mysqli($host, $username, $password, $dbname); // Cek koneksi if ($conn->connect_error) {     die("Koneksi gagal: " . $conn->connect_error); } // Query untuk mengambil data dari tabel $query = "SELECT nama, alamat, telepon FROM tabel_name"; $result = $conn->query($query); // Membuat instance dar...