3

I have installed PAW server in my android board. In PAW server I have added plug-in PHP. from there I am able to open my all php pages.

BUT the problem is I am not able to do INSERT and UPDATE query to my SQlite3 database.

Do not know what is wrong with that..

Anybody can please help me out.

Improve this question
2
  • You say you can open all your pages, does that also mean that SELECT queries work or is that also a problem? Commented Sep 27, 2012 at 4:57
  • Yeap SELECT queries are working fine. Commented Sep 27, 2012 at 5:00

2 Answers 2

Reset to default
1

I'm using phpLiteAdmin together with PAW on a daily basis. So you can try to install phpLiteAdmin just to check if your setup is working.

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

Comments

0

Ensure that the folder where the SQLite3 database was placed as well as the file have write permissions. Your SELECT statement will work fine but INSERT and UPDATE cannot write to the database.

I also found a link of how you can install/verify the PAW PHP runtime: http://fun2code-blog.blogspot.com/2012/03/paw-runtime-php.html.

Also, have a look at this post I found explaining step by step how to run sqlite from your phone using the correct permissions: http://code.google.com/p/phpliteadmin/issues/detail?id=66

Improve this answer

1 Comment

thank you JLC007 for you help. I am not using PAW Runtime, I am using PAW server . But still I downloaded and installed PAW Runtime but it is not working on system. I have given all read-write access to my database. Any thing else I need to do to make INSERT and UPDATE quires to work?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.