Android Login Form Tutorial with mySQL and PHP

[shabkct]

the video is not clear.. please put up a clear video

[crosbymichaela]

To make an apk, in your menu bar: Project >> Export Release Build.

All you have to do is move the PHP file from your local development computer to your webserver.  Then it is ready for production, that is all you have to do. If you plug in your phone and Project >> Export Release Build, it will run exactly the same (if you are connected to your wifi) as it does in the video.

[gabrielgpp]

I was talking about generating an Android application (. Apk) with PHP backend, but so far not seen any video or tutorial showing it.

[gabrielgpp]

I understand, but what about the client-server communication? The tablet makes requests to the Apache web server? I have not found where to configure it ...

[crosbymichaela]

@gabrielgpp I'm sry but I don't understand the question. Tablet's communicate just like phones or even laptops and computers. As far as Apache, you do have to have an *AMP stack running. ie Apache, mySQL, and PHP. The communication is done with PHP in this example. All this example does it takes a url to a php page. ie the URLRequest in views.MainLoginView.mxml is where you put a url to your server.

[crosbymichaela]

If you want more info, I have an hour long tutorial for $7. I posted the link in the video description, I can't post links in youtube comments.

[pedroalexm1979]

Thank you @ crosbymichaela.

This tutorial helped me a lot, good job. People like you make a smarter world.

thanks

Pedro

[batista603]

Great tutorial....is there anyway you can continue by doing the successview showing information being retrieved from a different table of same database? e.g. showing first name, middle, last, etc.

[crosbymichaela]

@batista603 If I have time....

[batista603]

@crosbymichaela okay, I see that you sell tutorials. If it will help, if you could create a tutorial on what i asked for, i wouldnt mind paying for it. I also may need to see examples on how to insert and update to if you decide to do it. Keep up the good work

[crosbymichaela]

@batista603 So I think I will do a check in app for the tutorial. It' would have a signup, you could check in your GPS location, add friends and view their location and information. Remove friends(all this data is stored in mySQL). So that would cover more views, adding, updating, deleting data from mySQL. And interacting with all the views. I will charge some money for it because this is alot of code I have to write, but it will be close to an hour video and you get all php and mobilecode

[batista603]

@crosbymichaela Sounds good, just let me know when its posted.

[batista603]

@crosbymichaela hows the app coming along?



[gabrielgpp]

hello, this application could run on a tablet true? What are the changes to be made?

[crosbymichaela]

@gabrielgpp It can run on a tablet as is. But you should do UI changes for tablets. All underlying code stays the same.

[batista603]

if ( !mysql_select_db("$dbname")) die("Could Not Open Database");

[batista603]

I wouldnt let me send the rest

[batista603]

Okay, cool. One more thing, for some reason, when I try to access the database, I'm getting denied. I have been up and down this php code the whole time and I think I changed everything. I'm using xampp to do this.

[crosbymichaela]

@batista603 i don't know xampp. If you are on windows try:

wampserver . com

Linux:

install tasksel

then lamp

[batista603]

@crosbymichaela I still can't connect using your code, but I can connect with this code:

<?php

$dbuser = 'root';

$dbhost = 'localhost';

$dbpass = 'ats603';

$dbname = 'usalogin';

$dbtble = 'credentials';

if ( !($mssql_link = mysql_connect("$dbhost","$dbus­er","$dbpass"))) die("Could Not Connect to Database");

[batista603]

okay, so lets say I created multiple tables in a database that has a relationship to the username and password that displays for example his location like city,state, etc., do I have to create another select.php like you created. 

[crosbymichaela]

@batista603 Ya, you just make another select statement and echo out the results.

[batista603]

Great tutorial. I have a question, if I wanted to have a home screen that will provide information based on login, how would I go about doing that?

[crosbymichaela]

@batista603 Not sure I understand what you want. After a successful login, you just push to another view, your home view, and get user data from the database and have PHP echo it out.

[fizzy6868]

Brilliant thanks just what I needed thanks so much :)