´óÊý¾ÝÁ¿csv¸ñʽphpµ¼ÈëmysqlÓÐʲôºÃµÄ½â¾ö·½°¸£¿
´óÊý¾ÝÁ¿µÄcsv¸ñʽ£¬5£6ÍòÌõÊý¾Ý
¿Í»§¶Ë phpµ¼ÈëmysqlÓÐʲôºÃµÄ½â¾ö·½°¸£¿
ĿǰµÄ˼·£¨ÊÖ»úºÅÂë¹ÜÀí£©
1£º¿Í»§ä¯ÀÀÉÏ´«
2£º¶ÁÈ¡ÉÏ´«»º´æÎļþ $_FILES['csvfile']['tmp_name']
3£º¸ñʽ´¦Àí
4£ºÅжÏÊÇ·ñ´æÔÚÊÖ»úºÅÂë
5£º²åÈë/¸üÐÂÊý¾Ý¿â
ĿǰдµÄÎļþ¸üиö2000¶àÌõÖ´ÐÐËٶȾͿ¨¿¨µÄ
PHP code:
// ÅúÁ¿ÉÏ´«ÉÌÆ·µÄ×Ö¶Î
$_LANG['upload_goods']['mobilenumber'] = 'ÊÖ»úºÅÂë';
$_LANG['upload_goods']['name'] = 'ÐÕÃû';
$_LANG['upload_goods']['address'] = 'ÊôµØ'; // ÐèҪת»»³Ébrand_id
$_LANG['upload_goods']['brand'] = 'Æ·ÅÆ';
$_LANG['upload_goods']['price'] = '½ð¶î';
$_LANG['upload_goods']['paytime'] = '½É·Ñʱ¼ä';
$_LANG['batch_upload_ok'] = 'ÅúÁ¿ÉÏ´«³É¹¦';
$_LANG['goods_upload_confirm'] = 'ÅúÁ¿ÉÏ´«È·ÈÏ';
$line_number = 0;
$goods_list = array();
$field_list = array_keys($_LANG['upload_goods']); // ×Ö¶ÎÁбí
$data = file($_FILES['csvfile']['tmp_name']);
foreach ($data AS $line)
{
// Ìø¹ýµÚÒ»ÐÐ
if ($line_number == 0)
{
$line_number++;
continue;
}
$line = iconvs('gb2312', 'utf8', $line);
// ³õʼ»¯
$arr = array();
$buff = '';
$quote = 0;
$len = strlen($lin
Ïà¹ØÎÊ´ð£º
ʹÓÃPHPµÄexecº¯Êýµ÷ÓÃlinuxµÄshellÃüÁÈçdateÈ¥ÐÞ¸Äʱ¼ä»òshutdownȥʵÏֹػú/ÖØÆô£¬µ«ÊÇ·µ»ØÖµ¶¼ÊÇʧ°ÜµÄ¡£¾¹ý¶à´ÎÊÔÑ飬È϶¨ÊÇûÓÐȨÏÞµÄÎÊÌâ¡£
ËùÒÔ£¬Ð¡µÜÔÚ´ËÇë½Ì¸÷룬ÈçºÎ²ÅÄÜÉèÖÃȨÏÞ£¬µ÷ÓÃlinux shellà ......
ÇëÎÊһϸ÷λ´óϺ£¬ÎÒÓÃphp×ö¸öÍøÒ³ÓÎÏ·£¬µ±È»ÊÇ×îÀ¬»øµÄÄÇÖÖhtmlµÄ£¬
ÏÖÔÚÎÒÏë°ÑËùÓÐÍæ¼ÒºÍ¹ÖÎnpcµÄÊý¾Ý´¢´æ£¬
µ±È»£¬Êý¾Ý¿âÖе±È»ÓУ¬µ«ÊÇÎÒÓÖ²»Ïë¹ý¶àµÄÈ¥²éѯÊý¾Ý¿â£¬
±ÈÈçÕ½¶·ÏµÍ³£¬¿Ï¶¨ÒªÏȳõʼ»¯Ë«·½Êý ......
¸÷λ´óÏÀ
ÇóÒ»¶Îphp´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ  ......
¸÷λ´óÏÀ
ÇóÒ»¶Îphp´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ  ......
ÎÒÊÇÓÃmysql×Ô´øµÄC API
if(mysql_real_connect(&mysql,"125.0.0.108","root","root","home",3306,NULL,0))
{
AfxMessageBox("Êý¾Ý¿âÁ¬½Óʧ°Ü") ......