将NSData通过PHP发送到MySQL的最佳方法是什么？ [英] What would be the best way to send NSData through PHP into MySQL?
问题描述
好的，我相信这一定是非常常见的情况。我需要通过PHP页面通过HTTP页面发送NSData变量，然后将其存储在MySQL中。稍后将通过其他一些HTTP调用检索此项，然后再将其下载到NSData中。这样做的最佳方法是什么？
Ok I believe this must be a pretty common scenario. I need to send a NSData variable over a HTTP request through a PHP page which then subsequently stores it in MySQL. This will be retrieved later by some other HTTP call which then downloads it into a NSData again. What is the best way to do this?
我应该将NSData转换为某种字符串表示形式（base64等）吗？我应该将数据存储在MySQL中作为VARCHAR还是Blob？数据长度不会超过MySQL / HTTP限制。
Should I convert the NSData into some sort of string representation (base64 etc)? Should I store the data in MySQL as VARCHAR or Blob? The data length will not exceed the MySQL/HTTP limit.
推荐答案
最简单的方法是对Base64进行数据编码并创建Web服务这可以让你来回发送信息。
Easiest way is to Base64 encode the data and create a web service that lets you send the information back and forth.
这是我在网上找到的做Base64编码/解码的类别：
Here's a category for doing Base64 encoding/decoding that I found on the web:
ECBase64.h
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：
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
这篇关于将NSData通过PHP发送到MySQL的最佳方法是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
