Mobile Application Development with Phonegap, MySQL and PHP | EDWARD DANIEL VIDAL GARCIA | Skillshare

Mobile Application Development with Phonegap, MySQL and PHP

EDWARD DANIEL VIDAL GARCIA, Mobile and web developer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
18 Lessons (1h 31m)
    • 1. Register for Free Hosting

      2:36
    • 2. Creating the Database with MySQL

      2:31
    • 3. Creating database connection file with php

      2:11
    • 4. Creating Service to save with PHP

      2:55
    • 5. Creating Service to Edit and Delete with PHP

      2:38
    • 6. Service to Consult with PHP and Json

      5:17
    • 7. Upload files to the Server with Filezilla

      2:47
    • 8. Installing Phonegap

      11:18
    • 9. Creating the project and form to Save Information

      9:13
    • 10. Designing the Form to Edit, Delete and Display Information

      3:57
    • 11. Creating File to Get Url

      1:16
    • 12. Coding Form to Save Information

      12:44
    • 13. Coding Form to Display Information

      13:39
    • 14. Coding Form to Edit and Delete Information

      8:21
    • 15. Testing Application

      2:21
    • 16. Adding icon and configuration from config.xml file

      4:30
    • 17. Generate test APK

      1:04
    • 18. Installing APK on the cell phone

      1:56
18 students are watching this class

About This Class

Course summary

Beginner Mobile Developer - Learn the world of mobile app development, related technologies, and make money with mobile app.

Hybrid application: learn the technology to develop a mobile hybrid application

Mobile user interface: learn how to create responsive pages with bootstrap

Connect web service - Learn how to send data between the mobile app and the web service and web API (PHP).

MySQL database: how to get a mobile application to handle data transfer with MySQL database.

Functionality - Learn how to create services to consume with ajax.

Why should you take this course?

You can create a mobile application

Supports client systems, iOS, Android, Windows Phone.

I have many questions.

Ask questions in the video. And have answers in the shortest time possible

Updating content continuously.

Sign up for the course Mobile Application Development with Phonegap, MySQL and PHP, Don't let time pass,

Sign up now!

Transcripts

1. Register for Free Hosting: In this chapter we are going to start creating our database, but for this we are going to register at a free hosting that we must host everything that we are going to do on the server side. For that I have chosen this hosting that is www.000webhost.com that has turned out very very good. Here I will give you where it says login. Initially I'm going to register, I'm going to give you here where it says register for free, it will say get free for this I created an email called [email protected] I'm going to put a password here I'm going to put phonegap udemy too and I'm going to tell it to get hosting free, register it, I will select this little part, I will select this and I will select this to verify. So now we are going to give you free hosting. We are going to wait for it to load that here it appears to us that it is loading invades tells us that there was an error. We are going to continue, I am going to put another password that can also happen to you, I am going to tell you again get free hosting, for sure. We did not verify the Captcha hosting. Let's check it again, let's give it one more time to get free hosting. Now if this can happen to you too That is why we are going to leave it. Let's say OK I just want to learn and for that I will receive an email to an email where I must verify bill. We will wait for it to arrive and verify, once the mail arrives. We are going to open it, we are going to confirm, verify email we are going to proceed, we are going to verify to be able to do use of all tools. Let's close this one, ok here it tells us that the email has been verified and we can now use all the tools Here we can create our database. Here we can upload our files. 2. Creating the Database with MySQL: We continue creating the database where we are going to save all the records and all the information in the www.000webhosting.com, in client-side hosting We are going to give you where it says Manage database or Database Administrator, It depends on the language you have it. We are going to give it Manage database in this case, we are going to wait for it to load us a moment, it appears here. Now yes, we are going to give you where it says new databases. I'm going to call the database phonegap, I'm going to put a root user and a password, I'm going to give it where it says create A message appears that the database has been created but we must wait for it to go through the whole Preloader to be created correctly, here it says that you are creating the database, these are going to be the parameters from our database for when we are creating our connection file. This is how the user database name is created and those numbers are added and the host if we are local host remains, we wait a few moments while the whole preloader reloads us This doesn't take long. There it is loading the entire database. We will complete our load. Then once the database is created, the options appear. I'm going to tell you where I made PHP My Admin from so that it opens the database administrator here we open the PHPMyAdmin Some may already be familiar with the interface. Here I am going to click on the phonegap database and to save a little time I am already here I have the script from the database, go from the table, the table I called it book. I have a field that is auto increment. I have a field that is name, author and price, I will copy it I will paste it and I will continue if in this case it is empty and with this we have finished our creation of the database. 3. Creating database connection file with php: We are going to start creating all the files and all the services that we are going to consume on the server side that we are going to upload later here to the file manager to the File manager here if I tell it to upload files, this is where I am going to upload our files that we are going to host inside the server hopefully it loads, redirect us This is where I am going to upload all my files, the database is already created I'm going to create a folder here on the desktop I'm going to call it phonegap, I'm going to call this folder drag to sublime text and I'll start creating my connection.php file So here I am going to create the file that is going to connect to the database. The host is local host, the user the user. We are going to look at it, the user can be seen here in the Manage database or database administrator Here I can see the user. I rooted it, but as it is a free hosting we must, these numbers are created here the password password I put 90 100 100 and the database. It's called "id7729275_phonegap, here we have it, ready here I'm going to create a variable that I'm going to call connection and I'm going to tell you new mysqli SQL, which is a method that gathers all the variables to connect to the database and the server Here $ pw, $ pw And finally the database we save and we create our connection file. 4. Creating Service to save with PHP: We continue creating the insert file which will fulfill the function of saving in the database In this folder I am going to create a new file called insert.php I am going to open them php the tags I am going to include my connection file called connection.php There I am joining this file with this one, so I am going to say yes I give click the button with the POST method I am going to call them, I am going to click the Insert button What are we going to do ? We are going to capture the variables first of all, I am going to capture the variable name everything will be with the POST method I am going to capture the author variable, here I am creating them and here I am capturing them, I am capturing the author and I'm going to create the price variable. I also capture the price and here I am going to create a variable, I am going to call it sql where I am going to have my statement to save in the book table, the one we create in the database as the first field is auto incremental I am going to put a double quote here, here I am going to send you the name data, then I am going to send you too within the quotation mark everything I will send the author. And finally I am going to send you the price, semicolon we are going to tell you to execute, we are going to create a variable We are going to call it execute and we are going to pass it the connection variable that comes from here that is going to connect to the database and with the covering method we are going to send the SQL variable We lead to ask that if executing if it is correct, print them correct that is correct. We are not going to use it later but we print an error and with that we create the service or function that we are going to save in our database. With that we finish the link. 5. Creating Service to Edit and Delete with PHP: We are going to create two files. One we will call update.php the other we are going to call delete.php I am going to copy everything I have in the insert, in the update and what I am going to modify here is that when I click update here, that's how my button is going to be called, I must also capture the id because that is the condition I'm going to to send, then here the id and what we are going to modify here is the query in the database, I am going to say update the book table, the fields name will be equal to: in quotes I sent the variable name, I will send the author equal to: In quotes he sent the author variable, which will contain the change and the value of that variable and price the same as that one of type int integer, I will put a price, I will delete these spaces, I will remove this space from here and this one too, here it will tell you with the condition where the id is equal to, in quotes you I will send the id and we close, with this we have already concluded the update. We are going to copy this here again, and we are going to say delete, for the delete We only need the id, that is, we can remove these others and the query will say, the query will do delete from the book where the id is going to be the same as the id that I am going to send you with get method, we already have our file to update the service to update and delete the service, which we will run in the phonegap application on our device mobile. 6. Service to Consult with PHP and Json: A file is missing, which is the one that will show us the data from the database. I'm going to call it select.php What I am going to do is that I am going to copy this little part to erase code, here what I am going to say is, the query that we are going to send in this file is to select everything from the book table, ok. We are going to delete this and what we are going to do now is go through all the rows of the book table with the mysql_fetch_objet method, this is what it will show us is the names of the fields and here we go to pass the variable execute, we are going to create a variable of type Array to save all our files our fields sorry, then here the variable data I'm going to call it, I'm going to pass all the data that is going to be housed inside the $ row variable, then while it goes through the while with all the data, it will save them in an array And finally to show the data we are going to show them with json_encode, which will encode the data in json and We are going to save them here, we are going to pass the data parameter that has all the files and what it is going to show us is a json, then we are going to save. Now we are going to upload our files to the free server and we are going to give it where it says Row manager or Administrator of files. We are going to tell you to upload files now, we hope it will redirect us to the administrator files and we open our files, the folder where all our files are. We are going to return to the server and here we are going to select our files and we are going to drag them to the server, let's load them. We wait for a moment while they load and we return here to our hosting administrator, here he tells us what is the path of us that would be phonegap, in the database I saved in the table, I saved a field in the book table, in the book table I saved a data If you want, we can save another data again. Let's select where it says insert. Let's call a book around here, "The open veins of Latin America" by Eduardo Galeano. We are going to tell you that the price is also 20. We already saved another field, then here. That is the address that we are going to use from our mobile device to consume that service that we have stored there, here I am going to open the connection file. If nothing comes out it is because it is fine, correct. There is no structure error. We are going to open the select, what it is doing is showing us, oh let's see that we have a small trouble ! It tells us that we have. I am going to leave it, I am not going to edit it, we are going to correct it directly from here, because you it can also happen to them ok. Here we lacked an i, we can do it here or we can also modify it from the server. Let's wait for this to load, let's refresh it here we missed an i That is why it does not work for us, so we are going to wait for our files to load us I can modify it here directly and I'm going to give you save. Let's update. There it is, there we can see that in my select file, I'm printing it with an echo. I'm printing all the data with a json_encode, here it is and these are the data that I have saved in my table in the database. With this we finish the whole part of the server and we will continue with the part of the client that would be the whole mobile device part with phonegap 7. Upload files to the Server with Filezilla: To upload the files to the server we can use two methods, we can upload them through from FTP or we can upload them directly to the file manager. I already have all my files here, but I can also connect with this program called FileZilla to my server, here I can see what my credentials are and I can use these credentials to upload files via FTP, because many times the file manager in this free hosting does not work for us. So I'm going to copy the host, I'm going to copy the user and I'm going to copy the password and I'm going to tell him connect, then if all the parameters are correct I will get a connection to my server. Here it is telling me that my connection has failed. Surely it is because of the password, I am going to re-login, and here I already connected to the server. I can see in the public_HTML folder the files that I have on my server, if I enter here they are the same files, that is, around here I can add all those same files, delete them. I can add my other files, for example if I wanted to add this connection file, what I do is to drag it directly to that public_HTML folder and it will overwrite I am going to tell him that overwrite or any of those other options, I'm going to tell you to overwrite. There it is already overwriting the file and here I can see that my. The last modification is dated today that I made the last modification and so I can add my files to my server both by FTP with FileZilla or I can add them directly by the File manager that It is my file manager, I tell it to load now and then what it does is open this part to me So we already learned how to upload our files via FTP or through the administrator 000webhost files 8. Installing Phonegap: We will start with the whole client part, in this case we are going to download PhongeGap. We are going to give it on the official page, we are going to give it where it says Get Started, we are going to install depending on whether we have Mac or we have Windows. Let's give it download, we have to download three files, sorry two files, one that is the desktop application I already have it here, I'm going to give it here, it is very easy to install, we say next next next, hopefully it is installed, here it is opening, on Mac it dragged it to Applications, on Windows is to give next next next and with that we already have it installed, it is very easy to install. After we install this part, what we are going to do is also download this application on our cell phone. This application is also downloaded from the Play Store or from the App Store depending on the system operating that the cell phone has, then I am going to double click to install, here it is already running, I to close this folder hopefully it loads. We do the same on our cell phone. We are going to download the application, I already have it downloaded, I am going to look here. where I have it downloaded I can share here, my cell phone screen for us to look here. Well, initially that's what we have to do, we are going to install this application and we are going to install also the application for the cell phone once we have our application downloaded. Here I have the interface, where I can create our projects, but let's first see what I also already have my cell phone downloaded, I can share what I have on my cell phone here let's wait a moment while, oh could not connect! well let's wait a moment let's reconnect. I want them to see that the application has to be downloaded You don't want to connect. I'm going to see if I'm entering my id wrong We are going to tell you: 1101634406, I am going to connect you as an associate now yes, TeamViwer is very good because I can see everything I have from my cell phone. Well, here I am already manipulating my cell phone, there you can see the screen and there I have the phonegap downloaded. Here you can see it, in fact here I am going to open Phongap and that is the phonegap interface from the application which is the one that will help us to test our applications to see how we are doing and if they are working. Once the two programs are installed, I can from the terminal or the Windows CMD, I can try this command: phonegap, to see if it is installed correctly. Here I can see the version that I have installed, I think it is 8 and I can also create projects I can create projects here, phonegap, but I'm going to create a folder in applications, I'm going create a folder, I will call it phonegap, first then I will enter that folder Here it is, dragged it here and ready now if I'm inside that folder it's with phongap create I can call him for example Crud. So so I can create a project in phonegap, I can do it from the command line or with this application that I have, which is the desktop application, here in the + icon, I can tell you to create a new phonegap project, I can create it blank, I can create templates that already have some examples, come on to create it in white, we are going to give next and here I can tell you where I am going to create our project. Here I am also taking the applications and phonegap, here I am going to put a test and I am going to tell it to create a project They already have a folder called phonegap, I'm going to change it. for Applications, I'm going to change it for the desktop. Oops, this one can't be created there !, let's create it Well what happens is that I could not create that folder directly because this same file. That same application created that folder for me and I had created it manually. I already have it here, we are going to change the name we are going to call it Phonegap, ready. We are going to tell it to create Project, we are going to go through the steps again, create a new blank project, we are going to call it test, let's create a new project. the folder has a folder that already has one called Phonegap Could it be that she still has it? ready. Let's get out of here. Well let's first look at the folder that created us, which we just created. Ready. Here I already have my project, I'm going to drag it to sublime to see what created me, let's open it Let's open sublime This here Ready, here I already have my phonegap folder, I'm going to create all my files inside the folder www. I did want to first try why this phonegap is not there Ready, there it should work. We are going to configure the port, well around here it also gives me the possibility to load it from the CMD. But as I already created a folder called phonegap, that's why this happened to me, because it doesn't have a file which is called config.xml Let's do something, let's create it manually. We are going to tell it here Phone and we are going to drag this folder here, and here I am going to create a new file and I am going to call it let's take a good look at how it is okay Well that problem no longer appeared, it was no longer recognizing the address because I had created a folder I had created a folder, called phonegap and that same program was going to create it for me, so here I can see that the server is running on this route 192.168 So there what is loading me, here I have an emulator but I am going to remove it, what it has is a blank application, I can load it directly from here or I can test from my cell phone on that server, let's look at what 168.0.13 was If I tell her to connect, what she will do is that she will load me with this same project that I have in the test folder, I created the test folder so I have nothing there, I have nothing. That is why here the application from my cell phone is not showing anything good, but in order not to get confused I am going to continue with my project that I created directly from the command line that would be this, I am going to enter the phone folder, here with ls, I can look at the projects I have, but I'm going to enter the folder crud that would be this, this one here has this file. Let's stop the server, let's tell it, let's cancel, here it should appear that the server is running there it is, what I am going to do is that I am going to clean it and I'm going to stop it directly from here, I'm going to enter the folder to the test folder and I will stop it with phonegap ctrl c, there I already stopped the server Well, in the next chapter we are going to enter well to configure phonegap well and start to create our interfaces and not to get confused. 9. Creating the project and form to Save Information: We are going to start creating our interfaces from the project that we are developing of the crud but I want to delete this folder, to recreate it from scratch. So this folder will no longer exist. I'm going to go to Applications / Phone, this folder won't exist either and I'm going to clean, that's it. I'm going to get out of here I'm going to go to the CD folder I'm going to create my project with the phonegap create command and I'm going to call it crudMySql, that's what I'm going to call it. Then there we will begin to create our project with which we are going to start we hope, all the files are being created there. Ready Here our project has already been created. We are going to enter phone, here we can see it, we are going to drag that folder here, we are going to close these other files, ready then here in crud We are going to include everything inside that www folder, that's where we are going to save our files, this index I'm going to delete I'm going to start it from scratch. There she is, I'm going to create her. We are going to use Bootstrap we are going to use Jquery Done, we are going to enter bootstrap and we are going to enter jquery CDN Ready then in bootstrap We are going to click on "Get Started" and we are going to take the stylesheet that is the one we are going to use. Let's put it around here. Besides we are also going to use JQuery we are going to copy this line everything we are going to do with phonegap is going to be with HTML and Boostrap and Jquery with ajax, then another file that we will also use to put it from once in the header, it will be the icons, the Bootstrap icons, we will use the phone icons. This one here, we are going to include it at once to leave all the relationships ready. Here's how to use it, we can use whatever we want from HTML, so here we have it. Let's copy this stylesheet that has the phone icons, done. So those are the files that we are going to relate. Let's copy, let's get this right ok here we have ready, until here. Here we are going to start designing our form. We are going to start designing our form, here we are going to create a "nav" with class navbar and we are going to put "navbar-dark", all this is from bootstrap "bg-dark" is the color that we are going to put. Well this works for us up to that part with the tabulator and we put this class here, ready. I am going to create a label. Well let's leave it for the moment until here, let's start with the form "div.container" Here we are going to add our form, we are going to add a "form" tag there we are going to add our form, we are going to give it a title here, we are going to tell H6 a title that is centered. Let's put the bootstrap class to it: "d-flex justify-content-center" You can see all this in the bootstrap documentation and here we are going to put books, here in the form we are going to start doing We are going to create a class "div.form.group" and here we are going to put a label to save Name. We are going to put the input type text, a class "form-control" that all this is bootstrap and we are going to put a id once name, ready, let's copy and paste what would be the name, author, price and here the button will go, Done, so here we change author, author and this will be price and this will be of type Number We are going to change it for price and we are missing the Button button Let's put a class on it "btn btn-primary" And here we are going to put an id that this id must match what we have on the server. that the insert is going to call here insert as it is here, then this coincides with this button here and here we are going to put save. With this we conclude the design of our form, if we want it if we want to see it running directly on the mobile device. So here what we are going to do is tell phonegap server Well first we have to enter the folder that is "cd crudMySql" and here we say phonegap serve, then here They are going to enable us a server and a port in which we can enter. Then we can enter through this port, we can go looking at how it looks both in the browser, and OK I had not saved, so there we can see, so we can run it both in the browser I'm going to open phonegap and I'm going to connect to the server that put us here, the server was See it here is the 13, it is the same as we have here, we are going to connect it and here I am directly manipulating my cell phone to see how our form was. We wait a moment while the files are being downloaded, they are extracted and there it tells us in the menu It tells us if the extraction was correct or not, then there it appears that it is extracting the files and there it appears to us that it was correct. Here I can see that what I just designed and for example here a price as I put it type number appears in the numbers, I put the type date also the calendar will appear. Well then we continue to analyze well what more functionalities it has, now we continue with the update form. 10. Designing the Form to Edit, Delete and Display Information: Let's start designing the form to edit, let's create it here, let's call it edit.html What we are going to do is copy everything from the insert We are going to paste it, then since this is the one to edit, this will be called update, it must be exactly as it is called in this method. It will be called update and we also need the We are going to put the danger class so that it appears in red, delete, around here we are going to add input type hidden so that it is hidden and here we are going to save the id, because with it the id is that we are going to update and with the one that we are going to eliminate, then we bring that id to this input type hidden and then we show it. Well we will also have the select to show the information, I will call it select.html, we will re-copy all the structure and good in the update we are going to put the title "Manage Books" We close, we also close this Index here we are going to put "Consult Books", ready we are going to erase this form and here outside the container, that information We are going to show it in tables so we are going to close this, this is from cell phone transmission. We are going to div with class table responsive, so that we have a responsive table adaptable to the device and we are going to create the table with class tablet, all those classes we are bringing from bootstrap, so if you want more information about these classes that I'm putting you can go directly to the boostrap page, then here I will show the name, I will show the author, I will show the price and I'm going to show the Edit button. Well here I needed to put it inside a tr All of this goes within a tr we are going to put it here and with tab we run it. Here he also lacked the thead, which is the head of the table. Here we put it, there it stayed that would be our table and here we would put the body of tbody. There in this tbody is where we with Ajax are going to, with Jquery, we are going to show the information we already have our edit forms, we already have our select forms and we already have our insert or save form. We still need to give functionality to this entire page of the mobile application. 11. Creating File to Get Url: In JavaScript we needed to add this function, what this function will do is obtain the url where we send the data to the server or where we receive the data. So I'm going to copy it here, this is the entire function. I'm going to save it inside the js folder and I'm going to call it geturl.js So I'm going to call it, get the url where we look at the data right now, when we are giving with the coding of the forms they will understand it a little better. So in the Index we are going to add after the Jquery, we are going to add here we are going to relate the folder js / geturl.js, so we keep it, we will copy this to the other files. We are going to create here and we are going to put it here. There we already have our file or the function that is going to be in charge of obtaining the urls and send the urls to our server. 12. Coding Form to Save Information: The save form. Let's start coding it, let's go at the end, we will verify the id that we put name, author and price So at the bottom of the footer, I am going to create a script because we are going to consume the service with Ajax Here we are going to put the document.ready Let's open and close. We are going to put the semicolon at once and here we are going to say yes. if that button and click method is clicked, we will create a function. Here we open and close, we also put a semicolon if you click on insert We are going to capture the name variables and we are going to capture this value here, name, author and price, then we go to capture here with the dollar sign. The name.val and we will do the same with author In quotes we are going to put author, we are going to capture the value and we are going to create another variable with price. We capture that variable price quotes that were the names that we put in the ready id, inside a variable I will call it data we are going to save all those parameters, those parameters that our insert will receive which would be the author's name and price. These are the values ‚Äč‚Äčthat our service is waiting for, so here we are going to name it, it will be equal to plus the name variable, more to concatenate, here we will put the ampersand and author will be equal to plus Author We do the same with the price, the price is the same. More and here we pass the price variable to it and conclude with the insert which is the method it is waiting for our service. Ready here we are going to put the same and semicolon, here we talk about saying that Sorry, if the trim method of the variable name, sorry point lengh, is greater than zero, it means The trim method is to remove the spaces from the name variable and the lengh method to obtain the length If it is greater than zero it is because something was entered and the trim point of the variable (author) .lenght is greater and .trim (price) .lenght> 0 it is because all the fields were filled and if all the fields were filled. Now with the Ajax method we are going to send the data we open and we are going to send the data through the method POST, here in URL We are going to pass the url to it, we are going to pass the url to it What does my site have that would be, here we are going to put it url slash method, the service we are going to call is insert point PHP. We are going to put it as and the data that it is going to receive will be that this variable data It will contain all our data, we are going to tell it here data and here we are going to ask with the method, with the function success if correct function Function if the data to be received is the same the same. Ah correct because in the insert, I am passing it here what is going to return is correct or error. So I'm asking him if he returns me correct, if he returns me correct, here I go to say alert saved correctly. Semicolon, if it does not return an alert with the message Error ready. Here we go. Here we close this, we close the success, here we close, we are closing Ajax, in Ajax we are going to verify There is fine we have a semicolon, we close this here, this if, here we close the clicl method and here we close the document ready Here we apparently already have everything fine, so what we are going to do is that we are going to activate the server let's put phonegap server There I already activated the server to run, let's open that I already have it here on my cell phone. I will open here. The phonegap file let's wait for it to load and let's connect meanwhile we are going to open the database to see if our file is saved, ready I am going to give it a name, for example the name of the book One Hundred, Gabriel and price 50, I am going to give it to save. Well apparently we have a small error. Let's check our code to see where we can find it. Not. Here it seems to me something, ok, here I am missing the weight sign, let's look in our database Let's see here where we have a small error well let's correct something in our database well let's organize something in our database. We are going to enter here we are going to insert a record. Let's put e and 12 for example. Let's continue. Let's see the insert, let's see what it throws at us, this insert We are going to organize it in our inser.php We are going to wait for them to load us. Well let's organize something in our database which is this OK let's organize something. We are going to generate an insert, an insert from our database to put it, we are going to give it continue We are going to copy this insert and take it to our file. We are going to put it here, we are going to specify the fields that we are going to fill. That is another way to fill our insert We will send the name, the author and we will send the price in quotation marks. Let's save. We are going to verify that here our price has already been modified Let's look here, yes, let's change this to varchar like we have it here Let's check our index code ready. So let's try it, let's put edw, ed and 12, let's give it save And now if it tells us saved correctly, we are going to delete its controls that it was testing some little things Ready now if we go to the database. Let's see the one we just saved, here we have it. If we connect from the cell phone we will connect directly from the cell phone to test it. come on now yes let's give it connect with associated give it Open TeamViewer Ok our server is running here. I'm going to open the phonegap We wait a moment while it loads us, we are going to connect it that the server is the same as we had here. If we see in the terminal it is writing it with a number 200 200 it means that the file was compressed and sent it to us correctly. Let's put you to the test test 1 and let's put 100 on it. We are going to give it to save and here it shows us a message saved correctly here I know it by testing directly from my cell phone. If I go to the database I'm going to examine it and here I can see that from my mobile application that I created I can already save information directly to a SQL database. 13. Coding Form to Display Information: continue Memos in the party last controlled US return without are in K. Don't knows that was getting the most in West Rosinha toe. Same Western Satara and formula. You say like Anthony boy or cook anything that a sip Our cooler ego could be arrested. Local resident square and Blanco esta part is it? Read the Marais. Your key workman's are after I love really They? Mm. The me service you Celik, Syria s Sayaka or Secure Key. You know, Come here for a little silly but the most cases a lick your committee Saturday in those rooms It's when Jason but my family's are loudly lucky. That s their start. You're looking the separation The moon Jae shin They tour like for my gin card. Your tango in U. S. A. Up in town Look a job look adore. Pretend, though, is most racing form. Assume in Metallica There's a key. A model too literal metal Goingto often there, Jason, You Bama's Oppa's are really But we don't have enough once you on. Hey, someone had Amar tile. All right, Suit Police. Um my mom, Saudi Jai's. Was this a lapidary pointed comma? Diagne eyes your key, but most are according to a surge age Was that according local on age, Almost as he left a in the lower your literacy cuttin in those that choose Coleman a home till gotta cora bump really coma. He knows battles by Jamaar camps least Saudi zero a que edge a model bar I did, but it'll come pooh poohed I d say be Just call most and laws that bar number. But Iguala come to Toronto Number and bar I will talk Iguala Camp ive our praise You got very well come 4.0, rich as he's come or salvation At least that's surfacing for months. You're looking for much, Angela Most Earnest said Troy. Now I must write a corn. It's still a monster and they work least upon a oneto up in. But inspector dentro toy were Krayer Hey, you were coming up with that loss? Come! Okay, guys Arian Campo number joy upon their my body only number Welcome cutting Lumbly months point. Well Yotam, my old daughter, masked hero and, uh, one Gugliotta. We can cut in a key and but it's lease must. Yeah, but they and yucky when okie a key vento three every day. You and tomato que Syria and data. Look at us. There is coming a greater dramatic it I would be in Cologne connecting us. I'm a bit then you may think and and then you on pretty much. Oh, what a pity. Let in police. I'm not talking the stock and electoral, though upon their los Campos lies here case in your condo lately as a what? Donator. So by general more general. A big food too. I took them early. I must know at Gregory's single the prevalent a low ambient lost that force. Um, you like D A. Keep knowing MBIA Any number My eyes number and no young via a long tour must out door, do you, Leo Young mia. Okay. No swelling that we are laying bridge because I keep on the moors, But it's you equal must But Lisa 00 commedia My mother made Iraqi Come on our remove Kim. Okay. A car plant that must least must. Why are you so you where and yucky weapon A loon. What's our weapon out early? Equal there. Last they lost phone call the last from getting worker. This is getting worker for now it's, um, looking like a classic case. Utility operators is far, far, far Gyun. Okay, Wrong, Tino. For a young, far young age this is area Lee Kuan Okamoto Lie. It is the common I am must. But most are gonna gardocki then then tries Juniper being cool. Classy Battaini Okay, I yes, everybody who are ill Arlene, this one toe check their email happen alone. But there June three months e Certainly in the unity of me it's put up Another law must speak a At least it was up in our uni Konopka Yeah. Oneto cross documents up on every leg for arguing home. Yaka not secure. Come back as fast What Obama's At least it's a custom arsenal Celic. And until it knows, But you're really a Lindy's years. The Lindus Gettleman lawyer is here. Kmet radio, huh? I'll say like us Lama happen alone. Search how much I wanted that Iraqi. The lamb was in contractor. There's no geo. He when I cannot struggling with that, we don't know struggle commanders with scary mosque in order a strike I mean, I just want to go a key. OK, I'm on its back a card game when take your most calm problems or low notice that agenda and number. Okay. A low door monoliths. A Trojan tomato meter. He knows you're alone. Rajan. My, my higher Complete the come for number computer Our cart animals Common least hockey tambien e Oh, I see are just animals Have the contract are lucky Knows almost. Randall number a long tour. You'll press a key. Impress you. My mom got 11 signal. I the best. I still must contact police. That's all. No among us. Africa Liisa tries when Nothing. Those are really good signal pace. Mm. My mother upon our Lord hunky I got It's been a musket cargo, but it's a Karaganda President Gino Plato's Harry Tommy Thomas Khumalo Most open with a key corn Next. I used to the so much actually, sir. Fact Numbness Aggregate Endo help! Fresh bread! Oh, Ari Turlock, our eternal Come with the peninsula. What? I have Nazi putting moment. You are in the city. There's late there is constabulary click And like ours It Giada lean with If you lower click and in boots car may be our last concert. Is it a little clique in eight Are Major Garland Minister Orchestra e Akinola, Minister or my file will happen early. Okay, Ministro, our in a lily my file happen Nearly came I j r me home. Oh, come on, dear. Unless control lucky Yes, sir, I see. I looked anxiously lower Click imbues car Majerus console Absolutely. Casita majora. Alan, this are you more connector for a little A lot of proximity. Most cuomo commercial and dispositive or more lucky? Open spit. Almost. He is your connector. Valmont has put out of no segunda internews cardigan and turbulence. A Korean dozy bomb was, uh, Arial phone Got an excellent lover para Que nos Cora was competing with stuff because you're just I must carry Moses. Better need Santa me in trust. The most cargo Lamos connector you cannot terminal most really dozy and toast is a connect a satisfactory Ament. Our local just a single problem with estrogen. The little two years, he our car just sums least courageous citizen is a doula. You pour water that room in that locker. It was a fun in a key literally. You know, front nausea. They went up on the little dears. Yearlong was having water that for a least a war without Kordic Termine Torno Okay are taxable skills in trade exterminated time Intel is controlled Was our Lincoln to test Ballo Ke So little time we kill Is your leg une tarte men area travelers that those I say formal aereo But I do up for these are loose women are look it up Almost better kill Principia tingle a casita Nothing works Signally Elie Cohen I deserved They will scare. Yeah already Toncontin was kind of the police are yet daily, Nina. 14. Coding Form to Edit and Delete Information: we must connell for malaria, your daily meaner. There's more hours that little day The instructor were cooked here. So it's a party Gita open a cantina. Yaki Brahmos out there is that it's so minimal but almost complete support. Look day. Yes, The cumbia glom on to our final day. Kids in the most Italy's are less who loved ones when they get really Perrachon knows Tiger lower. Really An answer. The quantity Louis leak about on a retired documents that region are formal. Are you and Mr Markie Markie broken? My surgeon? This commits a vaginal fruit. Are you to assess body out, please? You know, we work up to that. What I got there's aqui Cuando lay click in a day I can see is a job by syriza party Aquino's falta lower a lady care I said he gwahd Uh, no matter. I want to buy how you start released. Ah Arche lawyer Gregor In a separate casita d equals Ah, I did equal a month. I d mask. I see Least we are keep most Captain Love batteries Bar e d Uh, the quality. Why would he Yeah. No, I tried metal get wearily. Goodbye a que women are being Kamala. Jimmy, kick my soccer great today by least again since ticketing work hard and get wherever. Yeah, killer. I cannot write that in and I d least you just Loomis more as they're called a number. Hold your pressure lap. Unlucky number number. Okay, A little You for our team. The name was but it this circular coral reef. Okay, how would I win? Lose burn Notice Lewis somewhat about those buttery skipper put. Never really sang without in a self body of our boy. A signal control a kid? No open air. No matter. I d going to bad. But I least you'll know those threes. He quit. It's a necessity. He did number a little. You you put it the stock. I just someone boy. Yeah, but I didn't know I go the model ghetto My doctor Liza. But Mazar Lake Country Star He said Correcto When the delay in a terminal traveling for months you are? Yes, sir. This spread on the metro help fresh. I was I mean that I no special pressure least press you. Okay if you cut our seeming travel pressure there is loaning coca programmer for both orange. Actually, saps really mean a toy. And often once upon a lucky venti, quite bombings are left. Police are e no, Sacco. When police Iraqi Poconos, we'll tow will signal one person, liberal policy, Muslim, Iraqi and say, like, could you Sammy down the support? Is it okay? Cool. But I must Are this good? Okay, supper's on a low skill. He's a lawyer key in eight hours, Jackie and the when elop were whirling for margin Could win be your president Obama gonna required a low total number. A lady never thought point out of land. Really? When he put it all in economics, a police and the correct time in telling for a month, he the one Babeu's car You don't leg, I say a clip on walkie governor here really go. Actually, sir, those means actually correct aumentar Hey, And by much better care that these factories are correct out. I'm not a continual Connolly meaner eliminar What I said like Gwendolyn was click in Alberta on their late late Ah, By most start Oso hockey mom was born Achille metal is almost present. The port of gate put out in a glove herbal or the lower. Really? Achille. Any intervention regiment? The late What happened? Look. Payment Like my stallion. The late e aqui local. Among the bazaar is Lowry early I d s Sayaka. I was up in that lab for Kim and bundle lawyer Lady I like the most a mosque leader. My l NATO in their legs least a country comma. Listen, taste like you, Ellie. Me? No, correct Um it says yes. Who knows the most consulates She were Correcto. She loves that may provoke. Correct my presently me. Now it's You know how much quicker he didn't go in Western Serbia in search you Almost 1/4 year is the Boskalis Some was some wasn't me and the public. There's a tambien system. Others in the program can be almost propagate List my mom Uh what of that Montag police are but most are really contradictory. Gay Barmasai z relay a samosa alumina career Waas Women are you know so let me know Jap I must bear can Castle immuno Correct Tomic, There's like you almost Cuando releasing conduct police bomb Assad er law Celic. From what I see like Gwendolyn Meaning? Tell me, Momma Lohan Zelic, the tambien Cuando worthy? Almost. I feel like a large area, I'm saying. Okay. Documents term in a motel day, a lemina. 15. Testing Application: journalism was probably the most replicas. Unilaterally. Despite it. Your moral mom was a me dad. Misapplication Korean Georgia Nelson you love in Topeka to complete Welcome longer, please Almost legitimated LNG query muestra your arms are moving your not look at what the other point most pro are Kenton in I go panel lay as part of our learning this positive, more per case was a battle court The jockey poor put him floodwater that on my own on oil weapons testing 0/3 Ed uar be the even up don't presently see what? That they seek war that correct MNT I know separatism and most okay knows they Jr less control. There's I point most readily, Timo, because he John my tasty never dilemmas eight are was I come every president for crazy and delinquent hazing Most police are This is actually correct. MMT knows Bambi are putting Was better kill president Totally so e but much I have lived for Amina Amina this is a liminal. Correct. Um anything Jackie general parties Most burke easily mean correct. The 10 emotional about Auntie told the La Casa they really needs your ultimate in a model bottom. Zito, the Brusca, Coniston Concrete Ministro Employees. Coma is demonstrate capacity or more for most career replicas. Your next money Poland does that. My years equally come cheap. Kim frequent Getting hammered Maestro Serbia's You in London for Casey Lot the name of local. Maintain Nola's buffoons Una parquet until a lot of little okay, personally parameter, your more. The next day. There came with Rose Service. Use a 7 1000 in Serbia people. Amusement. Heuristic is gratis. It has concluded. You know, Martin, not again. Take classic was instructor Elizondo, which is the most months? A It wouldn't your own escaped any longer. 16. Adding icon and configuration from config.xml file: my mother comments. American people are demonstrably Kasun. But as we are most tropical, it's But I do have to your own people kiss the perimeter cameras as it is comfortable and legal. Tangle me. You know, in the best of my company in here. McGregor in the carpet, then the projector and grew three low level in order on the rays. Equal Andre a que a Gregory. Least they didn't carry a gun with a car. Technical was the You're gonna go. OK, Siaca, your key most already noticed what you're calling people summarily on the most valleys are powerless. Come, people, as you know, is demonstrably catch you. I can't participate toe maestro. Discreet. Your normally that's preferred and tell us plugging killed because you're not gonna go automatic come into occasional a plataforma. Andre cannot let our man look a mother that has come. People are really cool. No model can be can be really cool. Yeah, let's get to it. I loved immense units correspondence, but because our economy is more place Boy apprentice. I mean, we're gonna keep on a multi Kizzie Ramos Agriculture illness plus screen on the Karjala Ponta Komaki must cooperate scar Moonstruck Que zero Gregory Lee Kuan Autumn input values Boria Harakah Stay casual somewheres in the Iraqi Jacqueline was a kilo up on any number because you end up on their where within a kilo, upon a number of market cap. Mariska, they said number one. Come on, Joel. Was Carlo in the play store for me? I keep Warren after Kenya. A script soon. Course I and there's a rodeo. They're really classy. Honest, More Gillis Fungal AKI do up when they really made day. Lepers, Anakin, Days ago. Joe, you're appointed a meal. I keep hoping there will now find out where. Let me, um you killed open number. They know it or they left because you Well, what of that? You keep the name was Ah, they're on the poem. Except origin and monsters are Jews. Don't sprocket. You're letting go Kapoor the road again. There's the quail Carollo since the Navy Capt. K Joep oil aggregate attitudes tanto stare. Most coming terminals. Jackie Thing worked, uses Amazon s read up on the juvenile Lupica no more unequal. It was cheaper. Monastic cannot sink went. But I also and from got off Cordova teen and including pajama while these there is a great please go loco avoris instead of low in west roar in my strap the Iraqi and letter Amina we're gonna gotta meet by you know Okay, so I just do what I tell you. I said I'm a fruit. What's OK to stay there? You ever start? It's like a bit least I just really didn't recruit. Yes are paired with a Parker Who says tengan Really him the Iraqi where copy are asleep looking kid your tango a se plug in Isparta Boy, it's a McGregory can come pick Clint Trickett down with the monarchy It's a plugging Melissa explicar looking on There be this predicament point As it turned out, she was a ceremony Come voice your 10 Welcome that you insert no or through e or truck is in the holster up Last Wednesday's jaquilla You know Greg O s a plug in local Cuando yo general epic Are you insulin? Insulin Levitsky Memorize your kids are chosen Quinta commanders Sam Ostrander Condi Query was replicas. You know our phones, you know, is Boris alot The calm people are Muslim Poco alert your calm people Kissing made 17. Generate test APK: in Italy. Logica com was in Salahuddin was a lot of the player by most out please our commander fungal boy under Mama's Arlen. Very quizzical. Monday Look as it is clear known, was through a picker. The most disturbing trend was carpet tile project. Oh, these bombers has better chance Ternana some amateur p import, But I can attended Endless Tropic. I must be in a Tokamak card. London with those cartoons more great. Angela Plataforma, Landry the Ark and Andre Sekar picked up a blunt Force 100 interest soccer play tunnel back and auto Bama's Amita. Some was, in fact, first Andre in the carpet. Uh, boy. Well, back out on the carpet ties early out boots on my carpet Topic come the book. Yucky. Eston was about you. Cornices! Solo commando Messina That must throw a pick. I will be a separate kind of promotion Sullivan List listener. But our commerce is coma. Calico No, E c sistan with the reason the dollars won't you know, even with stop because you're 18. Installing APK on the cell phone: insula. Mr. Application, Different withdraws ruler they do acquire. Is that become you? Come to the normal upon it, Of course. So course Jamaar Colson, La Suite on the two of you? No, he had a key party Alguno used is lucky A insider on this when I was gonna go, let's put up. Get cut again. Less than I become. No! Yeah, I keep pushing states killing. I said put us Caneda! And well, now it's the Julian. Your this card are limited, but enter Korakia meat incidents is less. Let them a cool supermoon toe. Take us pitta Laminar Directed you us practice upon number Disease practices were correct Omitting or does he? There's the Missoula Noah and I don't think I memorized convertible as if you okay? I am a size car gun kissing money. Poland A judgment? No, I already is. Just wear khaki Issa logo. Okay, usually Cano it. Come on Jam and strappy casual and comfy was there s tinny police lawyer Insular. How much has been up? Mientras Eno's in summer? Most of those incentives Summary mortar Illinois authorities open a well man Ceasar Correct They were kids and lose I Queller Samia boy, I made a rocky ended excretory. Oh, then I still say Lola. Yeah, I keep well, banister Lovely Kachin, Kiko correct aumentar in summer.