Guest User

Untitled

a guest
Jul 15th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -(id)saveUserInfo:(NSString *)dbPath:(NSString *) uname:(NSString *) usurname:(NSString *) utelephone:(NSString *) uaddress  {
  2.    
  3.     NSString *sql;
  4.    
  5.     if (sqlite3_open([dbPath UTF8String], &database) == SQLITE_OK) {
  6.        
  7.         sql = [@"UPDATE userTABLE SET name='" stringByAppendingString:uname];
  8.         sql = [sql stringByAppendingString:@"', surname='"];
  9.         sql = [sql stringByAppendingString:usurname];
  10.         sql = [sql stringByAppendingString:@"', telephone='"];
  11.         sql = [sql stringByAppendingString:utelephone];
  12.         sql = [sql stringByAppendingString:@"', address='" ];
  13.         sql = [sql stringByAppendingString:uaddress];
  14.         sql = [sql stringByAppendingString:@"'"];
  15.        
  16.         NSLog(sql);
  17.        
  18.         const char *_sql = [sql UTF8String];
  19.        
  20.         sqlite3_stmt *selectstmt;
  21.         sqlite3_prepare_v2(database, _sql, -1, &selectstmt, NULL);
  22.         sqlite3_close(database);
  23.        
  24.     }
  25.     return 0;
  26. }
Add Comment
Please, Sign In to add comment