How to show a string from column whose record matched with the credentials a user has entered ?

Question

1.00/5 (1 vote)

See more:

I have a database on my server in which I have a table named as accounts. This table has 4 columns namely Place (varchar), Reserved (int), Mobile no (int), textmsg (varchar).
Now as soon as the user enters place, reserved and mobile no through my activity in the android application it will go to my server..check with this table. If all three fields match to a particular record then I want to display the the message stored in my 4th column i.e. textmsg as a toast to the user. Can anyone please specify code for this. Any suggestion or advice will be highly appreciated. Thank you all.

Posted 17-Mar-14 17:15pm

MJR4PJCT

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2014-03-17T17:28:00

Solution 1

The typical setup is like this, your android app will have to communicate with some web services on a server which in turn communicates with the mysql for any database operations.
Suggest you go through this tutorial first, then you can adapt it to meet your project needs:
how-to-connect-android-with-php-mysql[^]

Posted 17-Mar-14 17:28pm

Peter Leow

Updated 17-Mar-14 17:29pm

v3

Comments

MJR4PJCT 17-Mar-14 23:40pm

Thank you for your quick reply. I have already implemented this but I wanted to know that how can I shoe the msg from my textmsg column whose record got matched. code for that much part only.

Peter Leow 18-Mar-14 0:22am

We do not supply code here. You will find the answer if you go through the tutorial. The general idea is like this:
1. Send your inputs, i.e. Place, Reserved,... in json format to the web service.
2. The web service will query the database to retrieve the msg that matches your inputs.
3. The web service will pass this msg in json format to your android app which will display in any way you like, be it toast or what.
Learn to do it yourself. Good luck.

MJR4PJCT 18-Mar-14 1:24am

Thank you for your reply but I was not using JSON in my application. I had done it before without JSON and it worked and hence trying the same trick for this too.

Krunal Rohit · Answer 2 · 2014-03-17T19:05:00

Solution 2

It's really very simple. As I can see you can communicate with your database, you can easily put a check between data from the activity and the database, iterate through all the records and the if you find the exact match, Toast it...
Simple, huh !! :)

See the similar kind of example over here on AndroidHive[^]

Posted 17-Mar-14 19:05pm

Krunal Rohit

Comments

MJR4PJCT 18-Mar-14 1:23am

Thank you for your reply. Can you suggest anything for my this query too ? Here is the link http://www.codeproject.com/Questions/745495/How-do-I-send-sms-like-those-are-sent-after-a-mone [^]