通过PHP向MySQL发送NSData的最好方法是什么？

Question

好吧，我相信这一定是一个很常见的场景。我需要通过PHP页面通过HTTP请求发送一个NSData变量，然后将其存储在MySQL中。它稍后将被其他HTTP调用检索，然后再次将其下载到NSData中。做这件事最好的方法是什么？

我应该将NSData转换成某种字符串表示形式(base64等)吗？我应该将数据存储在MySQL中作为VARCHAR还是Blob？数据长度不会超过MySQL/HTTP限制。

Answer 1

通过对来回传输到服务器的数据进行Base64编码，您可能会让事情变得容易得多。(或yEnc，或字节的某些其他ASCII码。)当然，您可以来回传输原始字节(毕竟，这就是我们对图像所做的，对吧？)，但是使用编码和其他带有字符串数据的HTTP头就没什么可担心的了。

然后，在服务器端，您可以将字符串存储在数据库的字符字段中，您可以对它们进行解码并存储在BLOB中，您可以将它们保存到文件系统中……如果不了解更多关于应用程序的要求，就很难说出“最佳”选项是什么。

Answer 2

最简单的方法是对数据进行Base64编码，然后创建一个web服务，让您来回发送信息。

这是我在网上找到的一个做Base64编码/解码的类别：

ECBase64.h

#import <Foundation/Foundation.h>



    @interface NSData ( NSDataBase64Additions )

    + (NSData*)dataWithBase64EncodedString: (NSString*)string;
    - (id)initWithBase64EncodedString: (NSString*)string;

    - (NSString*)base64Encoding;
    - (NSString*)base64EncodingWithLineLength: (NSUInteger)lineLength;

    @end

ECBase64.m：

   #import "ECBase64.h"

    static char encodingTable[64] = {
    'A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P',
    'Q','R','S','T','U','V','W','X','Y','Z','a','b','c','d','e','f',
    'g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v',
    'w','x','y','z','0','1','2','3','4','5','6','7','8','9','+','/' };

    @implementation NSData ( NSDataBase64Additions )

    + (NSData*)dataWithBase64EncodedString: (NSString*)string 
    {
        NSData* result = [[NSData alloc] initWithBase64EncodedString: string];
        return [result autorelease];
    }

    - (id)initWithBase64EncodedString: (NSString*)string 
    {
        NSMutableData* mutableData = nil;

        if ( string ) 
        {
            unsigned long ixtext = 0;
            unsigned long lentext = 0;
            unsigned char ch = 0;
            unsigned char inbuf[4], outbuf[3];
            short i = 0, ixinbuf = 0;
            BOOL flignore = NO;
            BOOL flendtext = NO;
            NSData* base64Data = nil;
            const unsigned char* base64Bytes = nil;

            // Convert the string to UTF8 data.
            base64Data = [string dataUsingEncoding: NSUTF8StringEncoding];
            base64Bytes = [base64Data bytes];
            mutableData = [NSMutableData dataWithCapacity: [base64Data length]];
            lentext = [base64Data length];

            while ( YES ) 
            {
                if ( ixtext >= lentext ) 
                    break;

                ch = base64Bytes[ixtext++];
                flignore = NO;

                if ( ( ch >= 'A' ) && ( ch <= 'Z' ) ) 
                    ch = ch - 'A';
                else if ( ( ch >= 'a' ) && ( ch <= 'z' ) ) 
                    ch = ch - 'a' + 26;
                else if ( ( ch >= '0' ) && ( ch <= '9' ) ) 
                    ch = ch - '0' + 52;
                else if ( ch == '+' ) 
                    ch = 62;
                else if ( ch == '=' ) 
                    flendtext = YES;
                else if ( ch == '/' ) 
                    ch = 63;
                else 
                    flignore = YES; 

                if ( !flignore ) 
                {
                    short ctcharsinbuf = 3;
                    BOOL flbreak = NO;

                    if ( flendtext ) 
                    {
                        if ( !ixinbuf ) 
                            break;

                        if ( ( ixinbuf == 1 ) || ( ixinbuf == 2 ) ) 
                            ctcharsinbuf = 1;
                        else 
                            ctcharsinbuf = 2;

                        ixinbuf = 3;
                        flbreak = YES;
                    }

                    inbuf [ixinbuf++] = ch;

                    if ( ixinbuf == 4 ) 
                    {
                        ixinbuf = 0;
                        outbuf [0] = ( inbuf[0] << 2 ) | ( ( inbuf[1] & 0x30) >> 4 );
                        outbuf [1] = ( ( inbuf[1] & 0x0F ) << 4 ) | ( ( inbuf[2] & 0x3C ) >> 2 );
                        outbuf [2] = ( ( inbuf[2] & 0x03 ) << 6 ) | ( inbuf[3] & 0x3F );

                        for( i = 0; i < ctcharsinbuf; ++i ) 
                            [mutableData appendBytes: &outbuf[i] length: 1];
                    }

                    if ( flbreak )  
                        break;
                }
            }
        }

        self = [self initWithData: mutableData];
        return self;
    }

    #pragma mark -
    - (NSString* ) base64Encoding 
    {
        return [self base64EncodingWithLineLength: 0];
    }

    - (NSString*)base64EncodingWithLineLength: (unsigned int)lineLength 
    {
        const unsigned char* bytes = [self bytes];
        NSMutableString* result = [NSMutableString stringWithCapacity: [self length]];
        unsigned long ixtext = 0;
        unsigned long lentext = [self length];
        long ctremaining = 0;
        unsigned char inbuf[3], outbuf[4];
        short i = 0;
        short charsonline = 0, ctcopy = 0;
        unsigned long ix = 0;

        while ( YES ) 
        {
            ctremaining = lentext - ixtext;
            if ( ctremaining <= 0 ) 
                break;

            for( i = 0; i < 3; ++i ) 
            {
                ix = ixtext + i;
                if ( ix < lentext ) 
                    inbuf[i] = bytes[ix];
                else 
                    inbuf [i] = 0;
            }

            outbuf [0] = (inbuf [0] & 0xFC) >> 2;
            outbuf [1] = ((inbuf [0] & 0x03) << 4) | ((inbuf [1] & 0xF0) >> 4);
            outbuf [2] = ((inbuf [1] & 0x0F) << 2) | ((inbuf [2] & 0xC0) >> 6);
            outbuf [3] = inbuf [2] & 0x3F;
            ctcopy = 4;

            switch ( ctremaining ) 
            {
                case 1: 
                    ctcopy = 2; 
                    break;
                case 2: 
                    ctcopy = 3; 
                    break;
            }

            for( i = 0; i < ctcopy; ++i )
                [result appendFormat: @"%c", encodingTable[outbuf[i]]];

            for( i = ctcopy; i < 4; ++i )
                [result appendFormat: @"%c",'='];

            ixtext += 3;
            charsonline += 4;

            if ( lineLength > 0 ) 
            {
                if ( charsonline >= lineLength) 
                {
                    charsonline = 0;
                    [result appendString: @"\n"];
                }
            }
        }

        return result;
    }

    @end

Answer 3

建议1:你可以把它存储在一个会话中，比如$_ session‘’mytext‘=；别忘了用session_start()；来检索你的字符串。

第二个建议:你可以把它存储在一个XML文件中。如果它支持XML的话

第三个建议:为了安全起见，从MYSQL回调即可。