PHP ½âÎöCSV
ÓÐÒ»¸öCSVÎļþ,ÈçÏÂ
login_id, password, email
11, 123, tt@gmail.com
¶ÔÓ¦Êý¾Ý¿â±í
user(login_id, password, email)
ÎÒÏëÓÃPHP½âÎöCSV, Èç¹ûlogin_idÔÚcsvÖдæÔÚ£¬ Ôò¸üÐÂÊý¾Ý¿â±í
Èç¹ûûÓоͲåÈ룬 ¸ÃÔõô×öÄØ£¿
sqlµÄ replace ÊÇʲô°¡£¬
ÎÒÖ÷ÒªÓÃËüÀ´×ö¶¨Ê±ÈÎÎñÅÜ£¬ ËùÒÔЧÂʲ»ÊÇÎÊÌ⣬ Ä㻹ÓиüºÃµÄ°ì·¨ÄØ£¿
ÄãÊÇÏëÒªPHP½âÎöCSVµÄÀàÂð£¿Êǵϰ¿ÉÒÔÓÃphpexcel£¬½âÎöºóÖ±½Ó¾Í·µ»ØÒ»¸öÊý×éÁË
Äܲ»ÄÜÓóÌÐò°ïÎÒдһÏ£¬ ÎÒ¸Õѧphp
ÓÃreplace intoÓï¾ä
mysqlÊÖ²áÀïÓÐÀý×Ó
http://dev.mysql.com/doc/refman/5.1/en/replace.html
http://dev.mysql.com/doc/refman/5.1/en/load-data.html
²»¸üÓÐÓÃÁË
´æÒ»¸öÎļþ
fgetcsv()
Ïà¹ØµÄ³ÌÐòÂß¼
load data ¿ØÖÆÒ»Ð©Âß¼¶¼²»ÐÐÁË.
Ïà¹ØÎÊ´ð£º
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿ÉÄÜÊÇÒòΪ¸ÃÕ¾µãûÓÐÄãÏëÒªµÄä¯ÀÀÆ ......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......
µ±ÎÒÓÃPHPÏÂÔØ·þÎñÆ÷ÉϵÄwavÒôÀÖÎļþʱ£¬wavÎļþÄܹ»ÏÂÔØÏÂÀ´£¬²¢ÇÒ´óСÏàͬ£¬µ«ÊÇÈ´²»Äܲ¥·Å¡£µ«ÈôÊÇͨ¹ýÎļþ·þÎñÆ÷¿½±´µ½±¾µØ£¬ÊÇ¿ÉÒÔ²¥·Å¸ÃÎļþµÄ£¬²»ÖªµÀÈçºÎÔÒò¡£Í¨¹ýMD5sum¼ì²â£¬¸ÃÎļþÏÂÔØºóÒѸı䣬²»ÖªµÀÔ ......
µÃµ½¿Í»§¶ËIPÀÏÎÊÌâÁË£¬µ«Õâ´Î»·¾³Óе㲻һÑù£¨ ¿Í»§ÊÇÕâÑùµÄ»·¾³Ã»°ì·¨£¬ËµBTµÄÇëÆ®¹ý :) £©¡£
win2k3¸Ãϵͳ£¨Ï³ÆÏµÍ³A£©ÉÏ×°ÁËVMware Server£¬VMÏÂÓиöwin2k3ϵͳ(ϳÆÏµÍ³B)¡£
ϵͳA£ºÖ±½ÓÁ¬½Ó¹«Íø¡£Óй«ÍøI ......
ÎÒÔÚÍøÕ¾µÄÒýµ¼Ò³ÖÐÌí¼ÓÁË<embed src="ÒôÀÖµØÖ·" autostart="true" loop="true" hidden="true"></embed>
Õâ¾ä»°£¬È»ºóÌø×ªÒ³Ãæºó£¬±³¾°ÒôÀÖ¾ÍûÓÐÁË£¬ÔõôÈÃÕ ......