Insert Values In SQLITE Database

Question

I tried to insert values in sqlite3 database, but it cant work on my app. I follow this code where all this values in table are varchar.

sqlite3_stmt *statement;

NSString *docsDir;
NSArray *dirPaths;
int ID;
// Get the documents directory
dirPaths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES);

docsDir = [dirPaths objectAtIndex:0];

// Build the path to the database file
databasePath = [[NSString alloc] initWithString: [docsDir stringByAppendingPathComponent: @"weather.sqlite"]];


const char *dbpath = [databasePath UTF8String];

if (sqlite3_open(dbpath, &contactDB) == SQLITE_OK)
{
    NSString *insertSQL = [NSString stringWithFormat: @"INSERT INTO satish VALUES ('jodhpur','hazy1','68','7','700','30','28','10sept')"];

    const char *insert_stmt = [insertSQL UTF8String];

    sqlite3_prepare_v2(contactDB, insert_stmt, -1, &statement, NULL);
    {
        NSLog(@"%@",statement);
        sqlite3_bind_text(statement, 1, insert_stmt, -1, SQLITE_TRANSIENT );

        if (sqlite3_step(statement) == SQLITE_ROW)
        {
            ID = sqlite3_last_insert_rowid(contactDB);

            NSLog(@"Data inserted successfully ");

        } 
        else{             
            NSLog(@"Failed to add contact");
        }
    }
    sqlite3_finalize(statement);
    sqlite3_close(contactDB);
}

NANNAV · Accepted Answer · 2012-09-17 04:51:44Z

2

//tyr this code    
// you must give the column name to insert values in DB   

     NSArray *paths = NSSearchPathForDirectoriesInDomains(NSDocumentDirectory , NSUserDomainMask, YES);
            NSString *documentsDir = [paths objectAtIndex:0];

            NSFileManager *fileManager = [NSFileManager defaultManager];
            NSError *error;
            NSString *dbPath =[documentsDir stringByAppendingPathComponent:@"register.sqlite"];
            BOOL success = [fileManager fileExistsAtPath:dbPath]; 
            sqlite3_stmt *selectstmt;
            if(!success)
            {
                NSString *defaultDBPath = [[[NSBundle mainBundle] resourcePath] stringByAppendingPathComponent:@"register.sqlite"];
                success = [fileManager copyItemAtPath:defaultDBPath toPath:dbPath error:&error];

                if (!success) 
                    NSAssert1(0, @"Failed to create writable database file with message '%@'.", [error localizedDescription]);
            }

            if (sqlite3_open([dbPath UTF8String], &database) == SQLITE_OK) {
                //*************** insert value in database******************************\\ 

                const char *sql = "insert into satish (firstname,lastname,email,company,phone) VALUES ('sdcbb','bbbb','bbbb','bbbb',1111122)";
                sqlite3_prepare_v2(database,sql, -1, &selectstmt, NULL); 
                if(sqlite3_step(selectstmt)==SQLITE_DONE)
                {
                    NSLog(@"insert successfully");
                }
                else
                {
                    NSLog(@"insert not successfully");

                }
            sqlite3_finalize(selectstmt);
                sqlite3_close(database);
            }

answered Sep 17, 2012 at 4:51

NANNAV

4,9014 gold badges34 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

12 Comments

NANNAV Over a year ago

sorry,i am not changed DB name, register.sqlite is my DB name

NANNAV Over a year ago

you change register.sqlite to weather.sqlite

NANNAV Over a year ago

and change "insert into satish (your column names) VALUES (your values)";

Shashi Sharma Over a year ago

in your code ,it give some error near database ,says use to undeclared identifier 'datadase'

NANNAV Over a year ago

add "static sqlite3 *database = nil; " in after "@implementation class name"

|

Owen Hartnett · Accepted Answer · 2012-09-17 03:32:31Z

0

I don't see where you copy your database from your bundle to the documents directory. If you do not copy a premade SQLite database, then your open call will create a new empty one. Since you did not create a table yet in your empty database, then the Insert call will fail. Solution 1: Write file routines to copy a premade SQLite database with a table named satish into your documents directory. Solution 2: If you don't want to premake a sqlite database, use a create statement in SQLite first to create the satish table.

answered Sep 17, 2012 at 3:32

Owen Hartnett

5,9352 gold badges21 silver badges35 bronze badges

Collectives™ on Stack Overflow

Insert Values In SQLITE Database

2 Answers 2

12 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

12 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related