Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

PHP ½âÎöCSV

ÓÐÒ»¸öCSVÎļþ,ÈçÏÂ
login_id, password, email
11, 123, tt@gmail.com


¶ÔÓ¦Êý¾Ý¿â±í
user(login_id, password, email)

ÎÒÏëÓÃPHP½âÎöCSV, Èç¹ûlogin_idÔÚcsvÖдæÔÚ£¬ Ôò¸üÐÂÊý¾Ý¿â±í
Èç¹ûûÓоͲåÈ룬 ¸ÃÔõô×öÄØ£¿

ÒýÓÃ
ÕâÑù×öЧÂʺܵÍ

½¨Ò齫login_id×÷ΪÖ÷¼ü
ÓÃsqlµÄ replace Íê³ÉÄãµÄ²Ù×÷


sqlµÄ replace ÊÇʲô°¡£¬

ÎÒÖ÷ÒªÓÃËüÀ´×ö¶¨Ê±ÈÎÎñÅÜ£¬ ËùÒÔЧÂʲ»ÊÇÎÊÌ⣬ Ä㻹ÓиüºÃµÄ°ì·¨ÄØ£¿

ÄãÊÇÏëÒªPHP½âÎöCSVµÄÀàÂð£¿Êǵϰ¿ÉÒÔÓÃphpexcel£¬½âÎöºóÖ±½Ó¾Í·µ»ØÒ»¸öÊý×éÁË

ÒýÓÃ
ÄãÊÇÏëÒª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Õ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´Ô­Òò£¬ÏÈлÁË¡£
¿ÉÄÜÊÇÒòΪ¸ÃÕ¾µãûÓÐÄãÏëÒªµÄä¯ÀÀÆ ......

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

ÀûÓÃPHPͨ¹ýapacheÏÂÔØwavÒôÀÖÎļþÎÞ·¨´ò¿ªÎļþ

µ±ÎÒÓÃPHPÏÂÔØ·þÎñÆ÷ÉϵÄwavÒôÀÖÎļþʱ£¬wavÎļþÄܹ»ÏÂÔØÏÂÀ´£¬²¢ÇÒ´óСÏàͬ£¬µ«ÊÇÈ´²»Äܲ¥·Å¡£µ«ÈôÊÇͨ¹ýÎļþ·þÎñÆ÷¿½±´µ½±¾µØ£¬ÊÇ¿ÉÒÔ²¥·Å¸ÃÎļþµÄ£¬²»ÖªµÀÈçºÎÔ­Òò¡£Í¨¹ýMD5sum¼ì²â£¬¸ÃÎļþÏÂÔØºóÒѸı䣬²»ÖªµÀÔ ......

PHP»ñÈ¡IP

µÃµ½¿Í»§¶ËIPÀÏÎÊÌâÁË£¬µ«Õâ´Î»·¾³Óе㲻һÑù£¨ ¿Í»§ÊÇÕâÑùµÄ»·¾³Ã»°ì·¨£¬ËµBTµÄÇëÆ®¹ý :) £©¡£
win2k3¸Ãϵͳ£¨Ï³ÆÏµÍ³A£©ÉÏ×°ÁËVMware Server£¬VMÏÂÓиöwin2k3ϵͳ(ϳÆÏµÍ³B)¡£
ϵͳA£ºÖ±½ÓÁ¬½Ó¹«Íø¡£Óй«ÍøI ......

ÈçºÎÔÚphpÍøÕ¾ÖÐÌí¼Ó±³¾°ÒôÀÖ - PHP / »ù´¡±à³Ì

ÎÒÔÚÍøÕ¾µÄÒýµ¼Ò³ÖÐÌí¼ÓÁË<embed src="ÒôÀÖµØÖ·" autostart="true" loop="true" hidden="true"></embed>
Õâ¾ä»°£¬È»ºóÌø×ªÒ³Ãæºó£¬±³¾°ÒôÀÖ¾ÍûÓÐÁË£¬ÔõôÈÃÕ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ