While I was experimenting with MYSQL queries, I wondered if I could get week of the month from a give date by using the MYSQL query rather than using backend languages like PHP & JAVA. So I created a query for it.
Here is the simple employees table with more than 200 thousand rows.
And it does have a column called “hire_date” with a data type as date.
What I am going to do is just copy-paste the query that I’ve created.
Of course, you can copy-paste the code from the link given in the description.
Please note that in my case, Monday as a first day and Sunday as a last day of the week.
From FLOOR to WEEK_OF_MONTH is the main formula which will give you exact week count.
Let’s check the output.
The 20th of September 2022 belongs in 4th week.
The 11th of September 2022 represents 2nd week because it is the Sunday and also the last day of 2nd week.
You can replace the table and column name with your preferred table and columns to verify it.
Step 3 : Open pubspec.yaml file, inside the "dependencies" add 2 lines.
http: any
dio: any
-----------------------------
Step 4 : Click on "pub get" link which will appear on ANDROID STUDIO.
-----------------------------
Step 5 : Install XAMPP's latest version.
-----------------------------
Step 6 : Run XAMPP and start APACHE & MySQL.
-----------------------------
Step 7 : On any browser, on URL bar, hit http://127.0.0.1/phpmyadmin/ & create a new database “test”. Go to it’s SQL, in textarea, copy-paste the following query.
Step 10 : Open the command prompt and enter "ipconfig" (to find out the IPv4 address for localhost). Make sure that it is same as an IP address which is added on the left side of "/flutter_test/store_data_flutter.php". If not, then add the IP address from command prompt. And then run the project.
==================
Flutter | POST the JSON Data Through API Using Dio | PHP as a Backend
In this tutorial, we shall create a project which can send data through API using GET & POST Methods.
We shall be using a PHP as a back-end language for the API and shall store the JSON in database.
We shall be referring a blog which contains steps to approach the task. Link of that blog is giving in the description.
First step is to create an empty Flutter project.
From 2nd step, copy-paste the whole code and paste it in main.dart file.
For 3rd step, open pubspec.yaml file and add those 2 lines under dependencies.
Make sure it is at the same level as flutter, then click on PUB GET to download important libraries.
We completed 4th point, and for the 5th point, we have to install XAMPP which will create a local domain in your computer. This will help us to create an API.
Link for XAMPP installation tutorial is given at the right-top-corner.
I already installed it so I am going to run it.
In 7th step, I shall create a database table by copy-pasting the SQL query in PHPMYADMIN.
First create a database called “test”. Click on it, and click on SQL tab.
Paste the QUERY there and execute it.
In next step, we have to create a folder called “flutter_test” in htdocs folder and then create an empty PHP file in it. Give it a name as “store_data_flutter.php”
Open that file in any text-editor, and copy-paste the code from step 9.
At last, open a command prompt and type command IPCONFIG.
Search for IPv4.
Choose any one from IPv4 and make sure that it is same an IP in flutter code. If not, then replace IP address to the one shown in your command prompt.
In response, an API returns a JSON which is displayed in console.
And when we go back to phpmyadmin, and check the table data, you will see our entered data there.
To switch from POST to GET, change function name to get. Also, in PHP code, change $_POST to $_GET.
In
this video, we shall convert date
into days
of the week
like Sunday Monday
etc and apply conditions
so that only the rows with specific
day
will be displayed.
Here,
we
have employee
table with more than 200k rows.
And
as you can see, there is a hire_date column.
We
shall create a select
query
so that the
first entry should display Monday
for 13th
of September
2021.
Make
sure that the column that you are using either has a DATE or DATETIME
as a data-type.
If
you are using varchar, then you can temporarily
convert
it into date without altering the table structure.
Video
link is at the top corner &
in the description.
First
we shall only display, employee_id and hire_date.
There
is a function in MYSQL
called “weekday()”, inside
it’s rounded bracket, use date column’s name.
This
function can convert any date into number which is basically a number
of the day.
For
example, 0 is Monday, 1 is Tuesday etc.
Let’s
edit previous query.
We
shall be using CASE functionality using CASE, WHEN, THEN and END
keywords.
Copy
that line and paste it 7 times & add proper days in front of
numbers.
Let’s
run it.
Now,
if you look at this, there is a day name according to the hire date.
Let’s
check it by adding 23 September 2021 date which is Thursday.
Now,
we shall add where condition on day column.
There
are 2 ways to do that.
If
you are using a number in
condition,
then
use “WHERE”
condition.
However,
if you are using day
name as a condition, then you have to use the
“HAVING”keyword
instead and
add alias name, which in our case is actual_day_name.
So
that is it. Query
example link given in the description.
Step 2 : Open “pubspec.yaml” file, the option will automatically appear in ANDROID STUDIO to download library, mostly the link’s label will be “Pub get”. Click on it to download library.
------------------------
Step 3 : Run the project, click on “REDIRECT” button which will show new page with API’s data inside it.
------------------------
Step 4 (Optional) : On “Unpossible.dart” file, line number 63 & 64 represent TITLES ad IMAGES respectively. Use any one of them to switch between TITLES and IMAGES.
===================
QUICKSTART to Display DATA and IMAGES from JSON API To Flutter App.
This tutorial will help you to quickly extract data from JSON file and display text or images on flutter application.
Let’s get started.
This blog contains steps that we have to follow.
There is an API link given at the top. We will be using this data which contains texts and image links.
From 1st step, download the project by clicking on the link. Click on “HERE” button to download the project.
Go to the place where it is downloaded and extract it.
Now, open the studio where you run the flutter app.
Go to the place where you extracted that file.
You will see the ICON with name as “api_quickstart”.
In studio, open the “pubspec.yaml” file. You will see the “PUB GET” link somewhere on the studio. Click on it to download important libraries which will help to extract data from API.
Let’s run the project.
Click on “REDIRECT” button, you will see titles.
If you want to see the images, open the “Unpossible.dart” file inside LIB folder.
Comment line number 63 and remove the comment from line number 64.
Let’s run it again.
So that is it, thanks for watching. Like share and subscribe.
