Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite
1

How to add nsmutablearray into the sqlite database table?Can any one help me to code?

share|improve this question
What is the data in your array?? Provide some code snippet , if possible. – iUser Sep 24 '12 at 11:25
string value @iUser – iosdev Sep 24 '12 at 11:30
Why you unaccepted my answer after accepting it ?? – iUser Sep 25 '12 at 5:00

3 Answers

up vote 3 down vote accepted

Use looping Controls to sort the array and insert each values

Example:

for(int itemIndex = 0; itemIndex < [yourArray count];itemIndex++){

     NSString *myname = [yourArray objectAtIndex:itemIndex];

    //insert myname to database.

}

To retrieve, you can use the sample below code

        if(sqlite3_open([path UTF8String], &dataBase) == SQLITE_OK)
        {
            NSString *query = [NSString stringWithFormat:@"select name from syncTable where Crc = %d",crc];         const char *sql = [query UTF8String];
            sqlite3_stmt *statement;
            if (sqlite3_prepare(dataBase, sql, -1, &statement, NULL) == SQLITE_OK)
            {
                char *name;
                unsigned int value;
                while(sqlite3_step(statement) == SQLITE_ROW)
                {
                    name = (char *)sqlite3_column_text(statement, 0);   
                    [yourArray addObject:[NSString stringWithUTF8String:fileName]];

                }
                sqlite3_finalize(statement);
            }
        }
share|improve this answer
it showing error on NSString *myname = [yourArrayCount objectAtIndex:itemIndex]; yourArraycount.. – iosdev Sep 24 '12 at 11:49
again!!! :) lol – Ramshad Sep 24 '12 at 12:57
while accessing from database can i read directly as a array? or what shud i do.. – iosdev Sep 24 '12 at 13:15
No. you can write a while loop and each items in to an array... – Ramshad Sep 24 '12 at 13:21
i have edited my answer.. still you not accepted my answer :) – Ramshad Sep 24 '12 at 13:23
show 2 more comments
up vote 3 down vote

You can use :

 for (int i = 0; i < [mutArray count]; i++)
    {
       NSString *string = [mutArray objectAtIndex:i];
       // insert query
       insert into table_name ('string') values(column_name);
    }
share|improve this answer
up vote 1 down vote

Here is a list of tutorials for using sqlite with iphone. Its not a matter of simulator or device. It will work fine with simulator also.

Create your db structure properly and work based on this tutorials.

http://mobileorchard.com/iphone-sqlite-tutorials-and-libraries/

Or

I'd recommend you to use Core Data if you want you work with databases on iPhone OS.

This tutorial should match your app quite well: http://mobile.tutsplus.com/tutorials/iphone/iphone-core-data/

Please ask if any more questions.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.