shinnosuke 0 Report post Posted October 15, 2004 katakan aku nak buat satu system guna mysql + php or jsp or servlet .. it will check and auto update most probably every second .. for example inventory barang2 .. it will compare expire date with current date and if the dbms found the expired stuff it will mark it expired. Benda ni kena check in second percission not every hours or daily..so soalannya .. apakah cara yang efective untuk implement benda tersebut? .. kena wat pakai server scripting (php,jsp) or dekat dbms or mysql tu boleh buat sendiri ..sila beri gambaran.. TQ Quote Share this post Link to post Share on other sites
Rads78 0 Report post Posted October 17, 2004 (edited) Depends camner ngko ndak buat auto update tuh. Kalau ngko guna PHP kat Linux, ngko boleh runkan misalnya guna command gini php autoupdate.php dimana autoupdate.php tuh akan check database every second. Cara lain ndak implement adalah guna jerk any programming language yang boleh connect ke MySQL.. dan check database every second. Misalnya ngko develop VB.NET application dimana dia check database every second (i would rather do 2 or 3 seconds intervals. Every second tuh berat jugak tuh ndak run especially kalau table yang ngko check tuh besar).... pun boleh jugak... bergantung kepada kemahiran ngko lebih cenderung kepada which language. So server scripting samaada PHP, JSP boleh digunakan ataupun any stand alone programming language.Good luckEdit:guna header nih untuk auto update <meta http-equiv="Refresh" content="5"> <meta http-equiv="Pragma" content="No-Cache"> <meta http-equiv="cache-control" content="no-store, no-cache, must-revalidate, private"> Edited October 17, 2004 by Rads78 Quote Share this post Link to post Share on other sites
shinnosuke 0 Report post Posted October 17, 2004 thanks rads78 .. aku baru tau yg guna command tu, running php takyah pakai browser .. sesuai untuk windows pasal linux leh pakai cron .. betui tak?.. Quote Share this post Link to post Share on other sites
shinnosuke 0 Report post Posted October 17, 2004 alamak.. yang auto update tu takleh pakai la pasal bila run je,dah abis sript tu dia terus keluar .. nak wat loop takleh lak..ada timeout pastu makan resource banyak.. nak pakai cron, dalam windows lak.. nak pakai schedular ikut jam pulak .. bagai mana ye? Quote Share this post Link to post Share on other sites
Rads78 0 Report post Posted October 18, 2004 So nampak gaya.. last solution. Ndak kena buat program sendiri lar. Setakat benda kekecik nih jerk... kalau ngko ada VB6 pun dah cukup.... buat program dan set timer dia suruh loop check kat database. Quote Share this post Link to post Share on other sites
sylbilassys 0 Report post Posted October 25, 2004 (edited) Mmm.. complicated gak cara korang tu. Aku cadangan ko guna teknik store procedure dalam database. Gabungkan dengan fungsi trigger. Aku tak sure kalau guna mySQL tapi kalau guna MS SQL Firebird, Oracle, Interbase atau Firebird mmg senang nak set.Cuba hang cari topik stored procedure and trigger dalam help file mySQL. Sure jumpa. Adios Edited October 25, 2004 by sylbilassys Quote Share this post Link to post Share on other sites