how to send data from sqlite to MYSQL

Question

I had developed an Application in android in which I fetch some data from MYSQL database and do some operations on it and store it in SQLite.Now I want to send all the data stored in SQLite to MYSQL.I know i need to use JSON there.I will store my result in Cursor say Cursor c="select * from emp" (just example) now how i will parse this cursor into String to send it to the php page? and how i will decode it there?? Please help me.

Where is the SQLite database, and where is the MySQL database? You want to do this once? Or is this some regular part of your application? — Brad
– Brad, Commented Aug 10, 2011 at 16:59
It is very hard to answer this question, we need more information. The title sounds as if you want to to database replication (i.e. store EVERYTHING in the client DB in the server DB - every table, every row). On the other hand, if you just want to send SOME data from the client to the server for some reason, then it has nothing to do with the actual DBs - it is just a question of how to transfer data, and then, yes, JSON would be a possible option as the transmission format. — Tom
– Tom, Commented Aug 10, 2011 at 17:20
@Brad it is a regular part of my Application,SQLitie Db is inside my phone and MySQL is at the webserver. — require_once
– require_once, Commented Aug 10, 2011 at 18:30
@Tom I want to send every data mean each row to the webserver means select * from the table and send it to MysqL — require_once
– require_once, Commented Aug 10, 2011 at 18:31

sivann · Accepted Answer · 2011-08-10 18:38:23Z

1

If what you are asking is how you can encode data and send it to php as GET parameter you could use the following:

$encoded=base64_encode(serialize($data)) and then call example.com/?data=$encoded where $data could be the query result from $data=$sth->fetchAll(PDO::FETCH_ASSOC);

and on the receiving end: $decoded=unserialize(base64_decode($_GET['data']))

but this will limit you to about 2K of data.

If you can use POST, then use POST.

answered Aug 10, 2011 at 18:38

sivann

2,1614 gold badges30 silver badges47 bronze badges

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

1 Comment

require_once Over a year ago

I didint get it.My data will be stored in a cursor when i retrieve all records from Db.How i will send it to the php?

Collectives™ on Stack Overflow

how to send data from sqlite to MYSQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related