Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I use a PHP Page to post a file to and have PHP handle the uploading....</p> <p>This code is used to upload a photo, but it can be adapted to work with any file.</p> <p>PHP Code:</p> <pre><code>&lt;?php $uploaddir = 'photos/'; $file = basename($_FILES['userfile']['name']); $uploadfile = $uploaddir . $file; if (move_uploaded_file($_FILES['userfile']['tmp_name'], $uploadfile)) { echo "OK"; } else { echo "ERROR"; } ?&gt; </code></pre> <p>iPhone Code:</p> <pre><code>- (BOOL)uploadImage:(NSData *)imageData filename:(NSString *)filename{ NSString *urlString = @"http://www.yourdomainName.com/yourPHPPage.php"; NSMutableURLRequest *request = [[[NSMutableURLRequest alloc] init] autorelease]; [request setURL:[NSURL URLWithString:urlString]]; [request setHTTPMethod:@"POST"]; NSString *boundary = [NSString stringWithString:@"---------------------------14737809831466499882746641449"]; NSString *contentType = [NSString stringWithFormat:@"multipart/form-data; boundary=%@",boundary]; [request addValue:contentType forHTTPHeaderField: @"Content-Type"]; NSMutableData *body = [NSMutableData data]; [body appendData:[[NSString stringWithFormat:@"\r\n--%@\r\n",boundary] dataUsingEncoding:NSUTF8StringEncoding]]; [body appendData:[[NSString stringWithString:[NSString stringWithFormat:@"Content-Disposition: form-data; name=\"userfile\"; filename=\"%@\"\r\n",filename]] dataUsingEncoding:NSUTF8StringEncoding]]; [body appendData:[[NSString stringWithString:@"Content-Type: application/octet-stream\r\n\r\n"] dataUsingEncoding:NSUTF8StringEncoding]]; [body appendData:[NSData dataWithData:imageData]]; [body appendData:[[NSString stringWithFormat:@"\r\n--%@--\r\n",boundary] dataUsingEncoding:NSUTF8StringEncoding]]; [request setHTTPBody:body]; NSData *returnData = [NSURLConnection sendSynchronousRequest:request returningResponse:nil error:nil]; NSString *returnString = [[[NSString alloc] initWithData:returnData encoding:NSUTF8StringEncoding] autorelease]; return ([returnString isEqualToString:@"OK"]); } </code></pre> <p>Method Call:</p> <pre><code>[self uploadImage:UIImageJPEGRepresentation(imageView.image, 1.0) filename:imageName]; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POUpload File to FTP Server on iPhone
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USozking
    1. USDutchie432
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POUpload File to FTP Server on iPhone
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI've been attempting to implement your code, but the process always returns an ERROR. I don't fully understand the code block, so it may simply be that the way the data is being implemented is not appropriate for the NSData I'm attempting to send to the php file. What I have is an NSData object which contains the results of an NSKeyedArchiver of an NSMutableArray containing an array of custom objects (in my case database records.) Would you be able to point me to a good resource to understand the code block and/or offer suggestions on how to refine this code for my purpose?
      singulars
      1. PO
      1. USGreg Steiner
    2. COCorrection: there was one typo. The code returns OK but the file does not get saved in the directory specified.
      singulars
      1. PO
      1. USGreg Steiner
    3. COProblem solved. Please disregard earlier request. Thanks!
      singulars
      1. PO
      1. USGreg Steiner
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload