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 ¿ØÖÆÒ»Ð©Âß¼¶¼²»ÐÐÁË.
Ïà¹ØÎÊ´ð£º
1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......
ÎÒÔÚmySqlÖÐÓÐÒ»×ֶοɴæhtml±êÇ©£¬±ÈÈç˵ÀïÃæÓÐa±êÇ©
µ«ÊÇÎÒÊäÈë²éѯÌõ¼þaµÄʱºò²¢²»Ïë²é³öÕâÌõ¼Ç¼£¬Ò²¾ÍÊÇ˵²éѯµÄʱºò²»¿¼ÂDZêÇ©,Ö»¿¼ÂÇÄÚÈÝ¡£
ÇëÎÊ´ó¼ÒÔõÑù½â¾ö£¿
¿ÉÒÔÔÙŪһ¸ö×Ö¶ÎÀ´±£´æ¹ýÂ˱êÇ©ºóµÄÄÚÈÝ¡£ ......
ÇëÎÊ
object(Helper_Uploader_File) {
protected '_file' => array(
'name' => string '4_¹âÓ°_1.jpg' (length=14)
'type ......
°²×°ÁËAPHACHE
¿ÉÊÇÔËÐÐÍøÒ³Ê²Ã´¶¼Ã»ÓÐ
¼±
»¹ÏëÇëÎÊÏÂ,JSP.PHP.ASP.NET ÄǸö¹¤×ʸ߰¡,
»ØÌû¾Í¼Ó·Ö
»¹Òª×°php5
×öµÃºÃ£¬Äĸö¹¤×ʶ¼¸ß¡£
http://download.csdn.net/source/1712990 Õâ¸öÀïÃæÓÐÕû¸öPHPµÄ° ......
ÈçÒ»¸öCSS´úÂëΪ#checkoutShipTo_giftsoflady, .checkoutBillTo_giftsoflady {}Òª±ä³É#checkoutShipTo_xxxxx, #checkoutBillTo_xxxxx{}
cssÊéд¸ñʽ²»¹Ì¶¨.
ÓпÉÄÜÊÇ#id{},.class{}
Ò²ÓпÉÄÜÊÇ#id input{}
·´ÕýÊ ......