ȳԿ
ȲκֱFTPϴӦռԡ
ѯҳʣhttp://ַ/Ŀ¼/ (ϴֱʹmysql)
IJ
notepad++inc/conn.Asp鿴ҳĶӦϵ
⣺incļļΪdesc.txtΪѯҳ˵ļ(֧html)
ݿ
ĬԴݿ鿴ɼԱȲѯڿԭ
xlsʽֱ˫,xlsʽExcelļ鿴
Ҫ
ںƴ߽ѹļ룬FTPָ루gb2312ϴ
鱣ԭʼ汾ҳ棺ԭʼ汾Լĺ쳣˵⡣
ѹںʹò裻ļڵ彨鱣
߱
ӲҪ
վԴ룬㻹Ҫվռ䡢վڿռ㻹ҪŲ/վ(ܺʱ)
Ӳ˵ѹһhtmlʽļShiYongShuoMingShu_****.html
ʹǵ߰汾ٶȣְ(chalide.cn) ײн(chalide.com)
ҪԱʹߣ߱FTPվռʹáexcelȼܡ
ãȻҪϸģؾѣ羭ʹá
ԭ
ҵʹñԴ룬ǰǣȥȨϢȨ
ԶοԸõķãȨ
xlsʽά
а汾ݶ˵ƽʱ༭xlsʽάֻDzѯʱӦת
ϷϹʹ
ϷϹʹñѯϵͳߡضѡ
ʹ;
ʺIJƵԲߵɼʡҵˮѵȸ־ѯ
ģοѯ棬˵ģѯ;ȡ
ɼѯϵͳ
ÿѧУ,,ҵλԵȶõ
ʲѯϵͳ
ÿѧУ,,ҵλԵȶõ
ҵѲѯϵͳ
ÿҵ,ѧУ,еλõ
ˮѲѯϵͳ
С,ҵ˾,ѧҵ
ְѯ,¼ȡѯ,ѯ֤ѯIJĸֲѯϵͳ
ض
1.ϴӦزšλͬ⡣
Ϊ˹ܷգͬ¡쵼СΧѯ飬ͬٹѯ
2.ָݼչֽòѯ
ѧ+Уôֻ飬ΪͬĶᶼʾ
3.ֻϴݣϴصĸ˽Ϣ
ͨѧ+ѯɼͱϴ֤š绰Ϣ
4.ϴ벻Ҫ۵㡣
ںѯȴIJѯ;
5.ϷϹʹá
ϵͳΧIJѯ;
ҪðʹãײλϢ
6.ݵķش
conn.AspݿļΪԼ֪ͬʱĶӦļơ
α̬ȷʽøݿļļвء
ʹò
1.±inc/conn.aspվ⡢ѯȲ,ļ˵
ת
οʵοĬԴݹɣ鱣ԭʼݹԺο
ȫıάֱӿԲѯݶôԺ
1.½excelļ½book1.xlsļ--->ȫѡ--->ʽ--->Ԫ--->--->ѡı--->ȷ
2.ȥԭĸʽԭ.xlsݿ--->Ʊλ--->½±ļ--->ճ--->ȫѡ--->
3.ճȥʽݵļƵĽճbook1.xls--->ļ--->ļ(ѡ)
Դϴ
1.Դϴԭнṹϴվֱʹãϴעָ루gb2312ϴ
2.Ƽϴfilezilla(ָϴ)Ƽ߽ѹļѹ롣
߽ѹ룺ļΪĺԣʵڲоʹӢļ
ϴ
1.ϴʽFTPϴƼԶϴļ߹ȡ
2.ָͨ루ַgb2312ϴݣϴվݿĿ¼¡
3.ѯϴһݡעԭһ¡ѯҪinc/conn.Aspõһ
4.ٲѯɾݿĿ¼¶Ӧļ
5.IJѯӦļ
6.ݣϴת滻ԭͬݡ
رǿ(ά)
1.ֻ֧һб⣺бϲΪһУ൱Ϊÿֻб⣩
2.ֺ֧ϲԪֵԪѸԪǰݡ
3.ݲοҳβά淶
鼼
òѯ
ѯýʹ/ѧ/֤/֤/ŵ,ð༶ȿжݡ
ԴСɿԶ
пвǵַ±Ӧļ滻ΪԼַɡûаվͲҪġ
ݵһЩ˵
룬ģʹ֤עСдͳһΪд,ôҳ˵£
ŵΪѯΪᱻת(ոᱻ ),ոĻ滻
ѯģ˵
Ƽ¼,Ӱٶȣ鱣ÿݿļ3ǧڣ˿Էֿ⣺ּݿš
ǰ˵
ںƴ߽ѹļ룬FTPָ루gb2312ϴ
鱣ԭʼ汾ҳ棺ԭʼ汾Լĺ쳣˵⡣
ѹںʹò裻ļڵ彨鱣
ྭʾ
1. ԭʼ汾ʮа˾⡣
Խ㱣ԭʼ汾ԷͬռԶԱȷжԭ
2. ڶӦʹãرPHPϵͳ汾
IISΪWINDOWS汾windowsµNGINXapacheѡlinux档
3. PHP5.4-5.6ʹ
ְ汾php7Ҳãųְ汾֧PHP7.0+
xls汾ļȡ쳣ԽPHP汾ԡ
4. ռʹñԴ
ľͰԭݲͬԴ룬һݰȫϵͱڣԴ뼰Ҳᱻ
кܶԴԼα̬ԴС
5. ߽ѹԴ룬ƼFTPʽ
߽ѹرlinuxļѺãϴļ
߽ѹõļļеȨܻԱȨޣWWWд
ɫ
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ͼƬĶȡԼԴ
˵
ⷴ
쳣
绰15058593138ͬźţ
ͨṩ汾Ϣ AM3X ͼ
ͨЧݣΪ˫ʡܶʱ䡣
Ѽ֧
踶Ѽ֧Ʋ
https://aiyaha.taobao.com 15058593138 һָΪʡСʱʱ䡣
ͬռ䲻ͨ
inc/conn.aspͷУ
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%Session.CodePage=936%>
רҵнӸѯйܷ
ά淶
άṹ
excelһǸб⣬Ժһһ
Ӧþ߱Ĺ
1. ֻеһΪб⣨ҲֶΣбȺϲΪһС
2. ϴֶεðΪѯ(ҵõIJѯ)
3. ɾɾǶάݣֻݵľ
4. ڶпʼÿһÿͬѧжѧţЧ
5. άڻسƱ滻忴̡̳
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. ʽphp(ճתtxt滻سƱ)
http://teel.chalide.cn/ (ת)
7. ʽߣphp(ճתtxt滻سƱ)ϵ15058593138@qq.comȡ (Լ)
ʼ(ȥʽ)
xlsѯʶݣִ²
1. Excelάṹֵ±
2. ½ExcelȫѡҼ õԪʽ ָʽѡı
3. ȫѡ±ݲƵղŴexcel档