Android MySQL Retrofit2 Multipart CRUD,Search,Pagination

Am showing you the preview of the app we will create in this course. In the process we will learn alot including but not limited to:

1. How to use Retrofit to perform all the CRUD(Create Read Update Delete) operations against a mysql database. We do this by making HTTP POST and GET requests asynchronously. While performing this we show progressbar and handle response appropriately.

2. How to perform a sever side search against our data and render the result in a recyclerview. I also teach you how to highlight search results. We render as searchview in the toolbar which the user can then use to search.

3. How to perform a server side pagination using the load more technique. For this we will see how to listen to RecyclerView scroll events to assist us in pagination.

4. How to create several re-usable screens using XML in android studio. These screens will include splash screen, dashboard screen, listing screen, details screen and editing screen. In the process we use several widgets like cardviews, datepickers, lovely dialogs etc.

5. How to write quality Object Oriented PHP code that can listen, interpret our requests and return us a response which we can then process.

6. How to use custom professional fonts in your android app. The fonts can be applied as per widget, per activity or to the whole application.

This part is for you if you haven't used XAMPP before. I show you how to download XAMPP. XAMPP remember is our localhost server and will come packaged with Apache and MySQL.

This part is also for students who haven't used XAMPP before. Once you've downloaded and installed XAMPP, I show you how to start Apache and MySQL and explain what the two do for us.

This is part is for students who are not sure how to create a mysql database. We use a tool called PHPMyAdmin. This tool comes packaged with our XAMPP or WAMP server and allows us easily and visually create databases and tables. Am showing you how to do that in this lecture.

In this class am showing you how to create an index.php file. It is onto these file that we will write all our PHP code. Am also showing you where to create the file. Am explaining and showing what htdocs folder is for XAMPP.

We are starting serious business right in this lecture. Realtime coding. After this lecture you will know how to create a Constants class in PHP to hold database credentials.

In this class we are creating another class. This class will hold all our CRUD methods. After this lesson you will know how to create a re-usable method to establish a connection to MySQL database and return a mysqli instance. This method will be used by other methods to establish connection.

Am teaching you how to insert data into mysqli database from PHP in an object oriented way. Am also showing you how to receive data sent via HTTP POST request from a client. Am teaching you also how to handle several responses based on the success/failure our insertion attempt.

After this class you will know how to:

1. Receive data sent from a HTTP POST request by client.

2. Write SQL statement for updating data.

3. Encode an array into JSONObject that we then send to the client as a response for it's update request.

In this class we delete data from mysql. After this class you will know how to:

1. Receive the id of the row to be deleted.

2. Write an SQL statement for deleting data, including that id.

3. Execute our delete query.

4. Send a response to the client based in success or failure.

Am teaching you how to select all data/rows from mysql table using PHP. After this class you will know how to:

1. Write SQL select all statement and Execute it.

2. Hold the result in an array and alongside a response code and message.

3. JSON Encode that result into a JSON Object and print it out for the client.

In this class we write one method that will do for us both search and pagination in mysql. After this class you will be able to:

1. Receive search Query and Pagination parameters from the client.

2. Apply these into a SQL statement, against multiple columns as for the search.

3. Return a response to the client based on his search and pagination requests.

We write a method to act as our controller. After this class you will be able to:

1. Listen to incoming HTTP requests, categorize them and call the appropriate method.

In this class we perform a simple HTTP GET request test. By doing this we will be able to ascertain that atleast our database credentials are correct and we can move then to android.

In this lesson we create an android studio project. After this class you will be able to:

1. Create an empty android studio java project.

This lesson is all about gradle and our app's dependencies. I talk about all the libraries we will use and why. After this lesson you will be able to:

1. Install dependencies into your project.

2. Know about certain android libraries and why to use them.

Here we basically add drawables/images into our drawables directory. These are the images and icons we will use   in our project.

In this class we create the menu items we will show in our toolbars. Then later on when those menu items are clicked/selected we will see how to handle those events and perform certain operations

This class is all about our value resources. These resources include:

1. Colors - many color definitions in their Hex format. We will use these in several places in our app like toolbars and backgrounds.

2. Strings - The static strings like the app name.

3. Styles - I tell you how to create custom styles by deriving from existing styles.

4. Arrays - To hold our array of colors. We will use this array in our adapter to set random backgrounds to our material letter icon.

The video tells you the objectives we will aim to achieve practically. That is am showing you the part of the app that this section will allow us create.

How to add custom fonts in the assets folder. Then we will load the font that we want to use globaly(default font) in our next class.

In this lesson we cover the App class. This is a global class to our android app and is actually an android component. I show you how to initialize Calligraphy in this class.

This is a preview of this section's Objectives, visually. Basically the splash screen we will be creating and how it works visually.

After this class you will learn:

1. How to design a splash screen in XML.

After this class you will learn:

1. Load animations using the static loadAnimation method of the Animation class.

2. How to apply the top to bottom and fade animations to imageview and textview respectively.

3. How to sleep a thread for a custom amount of time then open our dashboard page.

I had told you that we will be performing CRUD operations. These operations I said are very fast and work smoothly. I said we are using Retrofit as our HTTP Client. This is a preview of how those operations work visually in this app before we sink into coding them.

We first need to define our model class. This is our data object or java bean if you like. Here I show you how to:

1. Make a class/object serializeable using the Serializeable interface in the java.io package.

2. I explain why we are making it serializeable.

3. I show and explain the @SerializedName attribute, and why we decorate our model fields with it.

We code this interface to define methods that will act as our RestAPI methods. We use special Retrofit attributes to designate them HTTP request types. These method include:

1. Method for retrieving data via HTTP GET request.

2. Method for inserting data via HTTP POST request.

3. Method for updating data via HTTP POST request.

4. Method for deleting data via HTTP request.

5. Method for searching and pagination data via HTTP POST request.

We pass them fields to be sent to the server, however they are abstract and we use special Retrofit attributes to empower them.

Am spending these 9 minutes showing you visually some of the features our utility methods will perform for us. Those methods will be static will be re-usable throughout the application. This saves us time and from typing repetitive code.

Let's create our Utils class to hold those methods. Then am showing you how to obtain your computer's ip address and some of the addresses you can use as well depending on the emulator you are using for testing the app.

In this class you learn:

1. How to instantiate Retrofit and assign it a converter factory.

2. What is a converter factory and why it.

In this class you learn:

1. How to create a utility method to show us Toast messages throughout our app.

2. How to validate edittexts throughout the whole app using one method.

In this class you learn how to open another activity.

Am showing you in this class how to:

1. Create a re-usable Materrial Dialog using the  LovelyDialogs library. This is an info dialog to show any information including errors throughout our app.

In this class you will learn:

1. How to create a re-usable material single choice dialog. That dialog allows users to select one item from an arbitrary number of items in a list. Then the selected item gets automatically displayed in an edittext.

Here am showing you how to:

1. Convert a string into a date safely without crashing the app.

Here am creating two static re-usable methods showing you:

1. How to send a serialized object to another activity.

2. How to receive the serialized object and deserialize it.