ȳԿ
ȲκֱFTPϴӦռ(ͳ/Ŀռ)ԡ
ѯҳʣhttp:///Ŀ¼/ (ϴֱʹmysql)
Ƽ˵鶼ȿһ,ڿš
IJ
notepad++ editplus ȱ༭ inc/conn.Php鿴ҳ ĶӦϵ
⣺incļļΪdesc.txtΪѯҳ˵ļ(֧html)
ݿ
ĬԴݿ鿴ɼԱȲѯڿԭ
xlsʽֱ˫,xlsʽExcelļ鿴
Ҫ
ںƴ߽ѹļ룬FTPָ루UTF-8ϴ
鱣ԭʼ汾ҳ棺ԭʼ汾Լĺ쳣˵⡣
ѹںʹòϢ(HTMLļ)ļڵ彨鱣
߱
ӲҪ
վԴ룬㻹Ҫվռ䡢վڿռ㻹ҪŲ/վ(ܺʱ)
Ӳ˵ѹһhtmlʽļShiYongShuoMingShu_****.html
ʹǵ߰汾ٶȣְ(chalide.cn) ײн(chalide.com)
ҪԱʹߣ߱FTPվռʹáexcelȼܡ
ãȻҪϸģؾѣ羭ʹá
ԭ
ԸƵռڶ;ȥȨϢȨ
ԶοԸõķãȨ
xlsʽά
а汾ݶ˵ƽʱ༭xlsʽάֻDzѯʱӦת
ϷϹʹ
ϷϹʹñѯϵͳߡضѡ
ʹ;
ʺIJƵԲߵɼʡҵˮѵȸ־ѯ
ģοѯ棬˵ģѯ;ȡ
ɼѯϵͳ
ÿѧУ,,ҵλԵȶõ
ʲѯϵͳ
ÿѧУ,,ҵλԵȶõ
ҵѲѯϵͳ
ÿҵ,ѧУ,еλõ
ˮѲѯϵͳ
С,ҵ˾,ѧҵ
ְѯ,¼ȡѯ,ѯ֤ѯIJĸֲѯϵͳ
ض
1.ϴӦزšλͬ⡣
Ϊ˹ܷգͬ¡쵼СΧѯ飬ͬٹѯ
2.ָݼչֽòѯ
ѧ+Уôֻ飬ΪͬĶᶼʾ
3.ֻϴݣϴصĸ˽Ϣ
ͨѧ+ѯɼͱϴ֤š绰Ϣ
4.ϴ벻Ҫ۵㡣
ںѯȴIJѯ;
5.ϷϹʹá
ϵͳΧIJѯ;
ҪðʹãײλϢ
6.ݵķش
conn.PhpݿļΪԼ֪ͬʱĶӦļơ
α̬ȷʽøݿļļвء
ʹò
1.notepad++ editplus±inc/conn.phpվ⡢ѯȲ,ļ˵
ת
οʵοĬԴݹɣ鱣ԭʼݹԺο
1.ȥߣ¶ά֣£б⣬Ժһһݣ
2.бĻúϲΪһ; кϲԪֵԪѸԪǰݡ
3.ȥࣺɾõıֻһsheet1ѯʧ볢Ϊ.xlsļ(excel97-2003)
Դϴ
1.Դϴԭнṹϴվֱʹãϴעָ루UTF-8ϴ
2.Ƽϴfilezilla(ָϴ)Ƽ߽ѹļѹ롣
߽ѹ룺ļΪĺԣʵڲоʹӢļ
ϴ
1.ϴʽFTPϴƼԶϴļ߹ȡ
2.ָͨ루ַUTF-8ϴݣϴվݿĿ¼¡
3.ѯϴһݡעԭһ¡ѯҪinc/conn.Phpõһ
4.ٲѯɾݿĿ¼¶Ӧļ
5.IJѯӦļ
6.ݣϴת滻ԭͬݡ
txt 絥ԪسƱ滻
ϸά淶xls,csvݺԱ˵
رǿ(ά)
1.ֻ֧һб⣺бϲΪһУ൱Ϊÿֻб⣩
2.ֺ֧ϲԪֵԪѸԪǰݡ
3.ݲοҳβά淶
鼼
òѯ
ѯýʹ/ѧ/֤/֤/ŵ,ð༶ȿжݡ
ԴСɿԶ
пвǵַ±Ӧļ滻ΪԼַɡûаվͲҪġ
ݵһЩ˵
룬ģʹ֤עСдͳһΪд,ôҳ˵£
ŵΪѯΪᱻת(ոᱻ ),ոĻ滻
ѯģ˵
Ƽ¼,Ӱٶȣ鱣ÿݿļ3ǧڣ˿Էֿ⣺ּݿš
ǰ˵
ںƴ߽ѹļ룬FTPָ루UTF-8ϴ
鱣ԭʼ汾ҳ棺ԭʼ汾Լĺ쳣˵⡣
ѹںʹò̵̳Ϣ(HTMLļ)ļڵ彨鱣
ɫ
1. ͨ
ԴСݿ⣬Կڸֶάѯ
ɼѯˮҵѲѯ¼ȡְࡢᡢѯͨá
2. Сչ
Դ루ʾݣֻ30-50KBȻ
ڳԱգٶȲͶοɱ
3. Ϊȫ
Դֻҳ棬ֻдûsqlעȷա
ǰǼʮMBļԽԽӣȫԽա
4.
谲װʼҲIJŸĿ¼Ŀ¼ֱʹá
FTPʵֺ̨ܣϴռ伴ʹá
FTPϴݿܸķԴҲռϴСͳʱʱȡ
FTPϴɶļһȫϣֶ֧ϵȣԷӰС
ɾ˵ļFTPɾ
5. ͺڴ
Mysql(Ϊdzݿ)ڴҲ(Mysqlܶ20%+ڴ)
6. ͺ
ڴҳ浥jsļͼKBͼƬˡ
һҳ1MBѯҳһҳֻ30KBҡ
൱ͬȴԴ£粢ʮ
ĿǰơѶƵ8MBʵ1MBĴ1000Ԫÿꡣ
ԣʡܶõͬʱѯIJ
7. ͺĶд
ѯֻдСɵҳҲJSͼƬĶȡԼԴ
˵
ⷴ
Ų
1. ҳʾPHP룺ռ䲻֧PHP
2. ҳбռıдȨ
麯mb_detect_encoding(mb_string)Ƿ֧
3. 404ļʾַӦռ롣
4. 403ԼҳļʣĬҳindex.php
5. ݲѯѯǷȫһ
ݺǷȫһ£ܶƹĻпոݣ
ʼ(ȥʽ)
xlsѯʶݣִ²
1. Excelάṹֵ±
2. ½ExcelȫѡҼ õԪʽ ָʽѡı
3. ȫѡ±ݲƵղŴexcel档
ʾ
1. ԭʼ汾ʮа˾⡣
Խ㱣ԭʼ汾ԷͬռԶԱȷжԭ
2. ڶӦʹãرPHPϵͳ汾
IISΪWINDOWS汾windowsµNGINXapacheѡlinux档
3. PHP5.4-5.6ʹ
ְ汾php7Ҳãųְ汾֧PHP7.0+
xls汾ļȡ쳣ԽPHP汾ԡ
쳣
ѣ15058593138@qq.comֻͬźţ
շѼ֧֣
https://aiyaha.taobao.com2020Ԫ
ͨṩ汾Ϣ LM1X ͼ
ͨЧݣΪ˫ʡܶʱ䡣
ά淶
άṹ
excelһǸб⣬Ժһһ
Ӧþ߱Ĺ
1. ֻеһΪб⣨ҲֶΣбȺϲΪһС
2. ϴֶεðΪѯ(ҵõIJѯ)
3. ɾɾǶάݣֻݵľ
4. ڶпʼÿһÿͬѧжѧţЧ
5. txt桿άڻسƱ滻忴̡̳
txt 絥ԪسƱ滻
1. ʽһֱexcel滻ctrl+H ȡ滻߽̳ ٶؾ顣
ݴ롾סALT10ٷſaltȻ滻ͬ\汾ݿܲͬٶȡ
2. ʽʽ滻=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(
Sheet1!
A1,CHAR(13),";"),CHAR(10),";"),CHAR(9),";")
Sheet1DZA1Aе1еԪ;Sheet1108У¿ձ1빫ʽȻõԪ½+ţȻ108еõ±
3. ʽasp滻ߣ
http://96448.cn/xls2txt/xls2txt.zip asp߱netboxУxlsļָļУˢ·ʹַѡӦļύõtxt
4.
ʽģphp(csvתtxt滻سƱ)
http://tool.chalide.cn/ (ת)
5.
ʽ壺php(csvתtxt滻سƱ)
http://tool.chalide.cn/down.php (Լ)
6. (̨ܣļɾļ,б/ȿɺ)
1:
https://download.csdn.net/download/YUJIANYUE/89049299 2:
https://gitee.com/weivote/filebox2018 ر˵: ƼԱãļΪԼ֪[ȫҪ],ַӦ仯
ע⣺Ըù߰ȫ,е֧,аٶƹܴ롣