Sunday 12 December 2021

Flutter : Send Data Through API Using DIO | GET & POST Methods On PHP API




Step 1 : Create a new FLUTTER project in ANDROID STUDIO.

-----------------------------

Step 2 : Copy the flutter code from below.

import 'package:flutter/material.dart';

import 'package:dio/dio.dart';

void main() {

  runApp(MyApp());

}

class MyApp extends StatelessWidget {

  @override

  Widget build(BuildContext context) {

    return MaterialApp(

      title: 'Flutter Demo',

      theme: ThemeData(

        ),

      home: MyHomePage(title: 'Flutter Demo Home Page'),

    );

  }

}

class MyHomePage extends StatefulWidget {

  MyHomePage({Key key, this.title}) : super(key: key);

  

  final String title;

  @override

  _MyHomePageState createState() => _MyHomePageState();

}

class _MyHomePageState extends State<MyHomePage> {

  int _counter = 0;

  FocusNode myFocusNode;

  @override

  void initState() {

    super.initState();

    myFocusNode = FocusNode();

  }

  @override

  void dispose() {

    

    myFocusNode.dispose();

    super.dispose();

  }

  void _incrementCounter() {

    setState(() {

      _counter++;

    });

  }

  var txt_1 = TextEditingController();

  var txt_2 = TextEditingController();

  @override

  Widget build(BuildContext context) {

    TextStyle textStyle = Theme.of(context).textTheme.title;

    

    return Scaffold(

      appBar: AppBar(

        title: Text(widget.title),

      ),

      body: Padding(

          padding: EdgeInsets.only(top: 15.0, left: 10.0, right: 10.0),

          child: ListView(

              children: <Widget>[

                Padding(

                  padding: EdgeInsets.only(top: 15.0, bottom: 15.0),

                  child: TextField(

                    controller: txt_1,

                    focusNode: myFocusNode,

                    style: textStyle,

                    onChanged: (value) {

                      debugPrint('Something changed in Name Text Field');

                    },

                    decoration: InputDecoration(

                        labelText: 'Name',

                        labelStyle: textStyle,

                        border: OutlineInputBorder(

                            borderRadius: BorderRadius.circular(5.0)

                        )

                    ),

                  ),

                ),

                Padding(

                  padding: EdgeInsets.only(top: 15.0, bottom: 15.0),

                  child: TextField(

                    controller: txt_2,

                    style: textStyle,

                    keyboardType: TextInputType.number,

                    onChanged: (value) {

                      debugPrint('Something changed in Address Text Field');

                    },

                    decoration: InputDecoration(

                        labelText: 'Age',

                        labelStyle: textStyle,

                        border: OutlineInputBorder(

                            borderRadius: BorderRadius.circular(5.0)

                        )

                    ),

                  ),

                ),

                

              ]

          )

      ),

      floatingActionButton: FloatingActionButton(

        onPressed: (){

          getHttp();

        },

        tooltip: 'Increment',

        child: Icon(Icons.add),

      ),

    );

  }

  void getHttp() async {

    var formData = FormData.fromMap({

      'name': txt_1.text,

      'age': txt_2.text,

    });

    txt_1.text="";

    txt_2.text="";

    Response response = await Dio().post('http://192.168.56.1/flutter_test/store_data_flutter.php', data: formData);

    print(response.data.toString());

    myFocusNode.requestFocus();

  }

}

-----------------------------

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.

CREATE TABLE `flutter_data_check` (

 `id` int(11) NOT NULL AUTO_INCREMENT,

 `post_data` text NOT NULL,

 PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1

-----------------------------

Step 8 : At the folder where the XAMPP is installed, go to “htdocs” folder and create a new folder called “flutter_test”.

-----------------------------

Step 9 : Create a new php file “store_data_flutter.php” and copy-paste the following code.

<?php

if(isset($_POST))

{

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "test";

$data_array=array();

// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection

if ($conn->connect_error) {

    die("Connection failed: " . $conn->connect_error);

}

//print_r($_POST);

$sql = "INSERT into flutter_data_check(post_data)

VALUES(

'".json_encode($_POST)."'

)

";

$conn->query($sql);

echo json_encode([array(

"new_id"=>$conn->insert_id,

    "title"=>$_POST)]);

}

?>

-----------------------------

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

-------------------------------

Install XAMPP Tutorial:-

https://www.youtube.com/watch?v=-f8N4FEQWyY


Download Project:-

https://unpossiblepog.com/projects/FLUTTER+JSON+PHP/Send-JSON-Data-To-API


Subscribe my Channel:- 

http://www.youtube.com/user/SanketRooney?sub_confirmation=1 


Facebook Page:- 

https://www.facebook.com/UnpossibleNS 


Twitter Account:- 

https://twitter.com/UnpossiblePOG 


Blog:- 

https://unpossiblepog.blogspot.com/ 


Website:- 

https://unpossiblepog.com/ 


Gaming Instagram:- (@unpog.gaming)

https://www.instagram.com/unpog.gaming/

-------------------------------

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.

You can download a whole project from my website.

A download link is given in the description.

Thanks for watching. Like share and subscribe.

Monday 25 October 2021

External JS Changes Are Not Reflecting | Quick Fix | No Need Of Deleting Cookies & History | No Force Refresh Required


-------------------------------
Convert 
<script src="scripts.js"></script>

To
<script src="scripts.js?version=1"></script>
-------------------------------

Subscribe my Channel:- 
http://www.youtube.com/user/SanketRooney?sub_confirmation=1 

Facebook Page:- 
https://www.facebook.com/UnpossibleNS 

Twitter Account:- 
https://twitter.com/UnpossiblePOG 

Blog:- 
https://unpossiblepog.blogspot.com/ 

Website:- 
https://unpossiblepog.com/ 

Gaming Instagram:- (@unpog.gaming)
https://www.instagram.com/unpog.gaming/
-------------------------------
Have you found the problem where even if you make changes in external javascript file, and try to refresh the page, the older output remains there.
Of course you can force-refresh it or rename the javascript file, or delete cookies, but all of them don’t sound right or are time consuming.
So I have a simple solution for this.
In this example, I am demonstrating using the ANGULAR JS. But for other JS framework or for basic js implementation, the solution also works.
Here, the external JS file calls the data from JSON file and displays it on browser.
I am making changes in JSON file.
But as you can see, the change is not reflecting even after refreshing.
So to solve that, first go to the place where you linked that Javascript file.
Just add any random REQUEST variable after the filename by adding question mark.
And when you refresh the page, new changes will be reflected.
Next time, if the JS is not reflecting after deploy, just change the version number as shown on the screen.
Thanks for watching. Like share and subscribe.

Wednesday 29 September 2021

MYSQL | Replace HAVING With WHERE Condition | Use WHERE Clause Instead Of Having




MYSQL | Replace HAVING With WHERE Condition | Use WHERE Clause Instead Of HAVING Clause.
-------------------------------

QUERY EXAMPLE :-
SELECT * from (SELECT *,job_id+department_id as new_random_id FROM employees) random_table where new_random_id >=10 and new_random_id<=15

Subscribe my Channel:- 
http://www.youtube.com/user/SanketRooney?sub_confirmation=1 

Facebook Page:- 
https://www.facebook.com/UnpossibleNS 

Twitter Account:- 
https://twitter.com/UnpossiblePOG 

Blog:- 
https://unpossiblepog.blogspot.com/ 

Website:- 
https://unpossiblepog.com/ 

Gaming Instagram:- (@unpog.gaming)
https://www.instagram.com/unpog.gaming/
-------------------------------
Hey guys, in this video we shall learn how to use WHERE clause instead of HAVING clause.
The HAVING clause is mandatory when you use alias columns.
Let me explain it with an example.
In employees table, let say we need a temporary column which is the addition of job_id and department_id, we give it a name as new_random_id.
At core query, we can use HAVING clause to get data where the addition is between 10 and 15.
But when we use where, it gives a syntax error.
So, to force the query to run on WHERE clause, we have to add an extra table layer.
So add rounded bracket around the query, from SELECT to the TABLE NAME.
At the beginning, add SELECT * FROM.
After the end of rounded bracket, add any random name, which will act like a temporary table name.
And that’s it. The WHERE clause will work.
Thanks for watching. Like share and subscribe.

Thursday 16 September 2021

MYSQL | Select Query | Convert Date Into Days Of The Week & Apply Where Condition On Those Days





MYSQL | Select Query | Convert Date Into Days Of The Week Like Sunday Monday etc. & Apply Where Condition on Those Days.

QUERY EXAMPLE 1:

SELECT employee_id,hire_date,

CASE

WHEN weekday(hire_date)='0' THEN 'Monday'

WHEN weekday(hire_date)='1' THEN 'Tuesday'

WHEN weekday(hire_date)='2' THEN 'Wednesday'

WHEN weekday(hire_date)='3' THEN 'Thursday'

WHEN weekday(hire_date)='4' THEN 'Friday'

WHEN weekday(hire_date)='5' THEN 'Saturday'

WHEN weekday(hire_date)='6' THEN 'Sunday'

END as actual_day_name

FROM `employees` WHERE  weekday(hire_date)!='6'




QUERY EXAMPLE 2:

SELECT employee_id,hire_date,

CASE

WHEN weekday(hire_date)='0' THEN 'Monday'

WHEN weekday(hire_date)='1' THEN 'Tuesday'

WHEN weekday(hire_date)='2' THEN 'Wednesday'

WHEN weekday(hire_date)='3' THEN 'Thursday'

WHEN weekday(hire_date)='4' THEN 'Friday'

WHEN weekday(hire_date)='5' THEN 'Saturday'

WHEN weekday(hire_date)='6' THEN 'Sunday'

END as actual_day_name

FROM `employees` HAVING actual_day_name!='Monday'



-------------------------------

Temporarily Convert Date into Varchar:-

https://youtu.be/05Gebxap5W8

Subscribe my Channel:-
http://www.youtube.com/user/SanketRooney?sub_confirmation=1

Facebook Page:-
https://www.facebook.com/UnpossibleNS

Twitter Account:-
https://twitter.com/UnpossiblePOG

Blog:-
https://unpossiblepog.blogspot.
com/

Website:-
https://unpossiblepog.
com/

Gaming Instagram:- (@unpog.gaming)
https://www.instagram.com/unpog.gaming/

-------------------------------

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.

Thanks for watching. Like share and subscribe.


Saturday 10 July 2021

Flutter | Display Text And Images From API



NOTE : The API used for this tutorial is https://unpossiblepog.com/flutter-json/data.php

Step 1 : Download project’s ZIP file from following link. Extract it.

https://unpossiblepog.com/projects/FLUTTER+JSON/Display-Text-And-Images-From-JSON-REST-API

------------------------

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.

-------------------------------


Instructions:-

https://unpossiblepog.blogspot.com/2021/07/flutter-display-text-and-images-from-api.html


Download Project:-

https://unpossiblepog.com/projects/FLUTTER+JSON/Display-Text-And-Images-From-JSON-REST-API


Subscribe my Channel:- 

http://www.youtube.com/user/SanketRooney?sub_confirmation=1 


Facebook Page:- 

https://www.facebook.com/UnpossibleNS 


Twitter Account:- 

https://twitter.com/UnpossiblePOG 


Blog:- 

https://unpossiblepog.blogspot.com/ 


Website:- 

https://unpossiblepog.com/ 


Gaming Instagram:- (@unpossiblepoggaming)

https://www.instagram.com/unpossiblepoggaming/

-------------------------------

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.


Monday 5 July 2021

Upload Files From Local Machine To CPANEL | Bad Config Value For receive.denycurrentbranch Solution | Git & GIT VERSION CONTROL




Upload files from Local Computer to CPANEL’s file manager using git version control.
-------------------------------
SSH Key generation command:-
ssh-keygen -t rsa -b 4096 -C "your_email_id"

BASHRC File code:-
export PATH=/usr/local/cpanel/3rdparty/lib/path-bin:$PATH

Subscribe my Channel:- 
http://www.youtube.com/user/SanketRooney?sub_confirmation=1 

Facebook Page:- 
https://www.facebook.com/UnpossibleNS 

Twitter Account:- 
https://twitter.com/UnpossiblePOG 

Blog:- 
https://unpossiblepog.blogspot.com/ 

Website:- 
https://unpossiblepog.com/ 

Gaming Instagram:- (@unpossiblepoggaming)
https://www.instagram.com/unpossiblepoggaming/
-------------------------------
Hello guys, in this video we shall upload files from LOCAL COMPUTER to domain’s CPANEL using git and git version control.
There are 2 requirements to complete this task.
1st, , make sure that you have SSH access is enabled on your domain. In my case as I purchased it from godaddy, so there is a setting for it.
Also I do have CPANEL access of it. Make sure that it has git version control enabled.
2nd requirement is have GIT installed on your computer. 
Now in command prompt, notice that this is the default location, which is C drive, USERS folder and then the username.
Copy the command that is provided in the description of the video, paste it in command prompt.
Type your email address inside double quote.
It will create a public-private keys.
Do no add any text, leave them empty by pressing ENTER button of your keyboard.
Now go to this location.
There will be a “.ssh” folder, if there is not, it will be hidden. Go to settings and make it visible.
Now go inside ssh folder, and there you will see the file with an extension as “.pub” which means the public key.
Open it in text editor like notepad or anything.
Copy it and go to CPANEL of your domain, go to SSH ACCESS option, click on “IMPORT KEY”, give any random name.
Leave private key and passphrase empty. 
In PUBLIC KEY TEXTAREA, paste that public key.
Click on IMPORT.
Now authorize that newly added key.
Let’s go to CPANEL dashboard, click on GIT VERSION CONTROL.
Click on create, uncheck the “CLONE REPOSITORY” option.
I shall add file name which will automatically create a new folder in cpanel.
Now, go back to the listing, click on MANAGE button in front of newly created repository, and copy the CLONE URL.
Now, on your computer, choose any location, create a folder there.
Open that folder in GIT BASH.
Type command “git clone”, then paste the path, and then give any random name to it. I gave it a name as “testing”.
If it asks question, type YES.
Of course our repository is empty so ignore the warning.
Let’s create idex.html file there, open it in text-editor.
Type something inside it.
Let’s add that in change list.
My mistake, you have to go inside that testing folder so use the CD command to enter inside it.
Now, we are inside testing folder.
Let’s run commands to upload those files.
Now, before pushing files to CPANEL, check the available branches.
We have one available known as “refs/heads/master”.
Lets push file inside it.
There is one error called “bad config value for ‘receive.denycurrentbranch’ in ./config”.
To solve that, go to FILE MANAGER of cpanel, go to settings and make sure that “show hidden files” is checked. Save settings.
Search file “.bashrc”. Let’s edit that page.
On top of file, paste the following code that I provided in the description.
Save it.
Now, let’s run that command again.
Let’s check if changes are reflected.
As you can see, there is an index.html file and it has the text that we typed.
Let’s make more changes. Save them.
And, those changes are reflected.
So that is it, thanks for watching. Like share and subscribe.

Saturday 26 June 2021

New Instagram Account For Gaming | Unpossible POG





 Instagram (@unpossiblepoggaming) : https://www.instagram.com/unpog.gaming/

When I upload videos on my youtube channel, I always post it on this blog. But this blog's main focus is to provide more information on programming tutorials which comes in the category of EDUCATION. But the gaming is different, it is mostly an ENTERTAINMENT. So instead of promoting gaming videos on blog, I decided to open an instagram account where gaming videos are more suited.

Sunday 13 June 2021

Digital Animation With HTML And Javascript




-------------------------------
Code :-

<html>
  <head>
    <link href="http://fonts.cdnfonts.com/css/led-digital-7" rel="stylesheet">
    <style>
      div {
        font-family: 'LED Digital 7', sans-serif;
        font-size: 48px;
        text-shadow: 4px 4px 4px #aaa;
      }
    </style>
  </head>
  <body>
    <div id="appear"></div>
  </body>
  <script type="text/javascript">
    var string="UNPOSSIBLE-POG";
    var final_string=""; 
    for(let i=1;i<=(string.length)*4;i++)
    {
       
      setTimeout(function deplay_this(){ 
        var to_display="";
        if(i%4==3){
          to_display=final_string+"8";
        }
        if(i%4==2){
          to_display=final_string+"0";
        }
        if(i%4==1){
          to_display=final_string+"1";
        }
        if(i%4==0){
          final_string=final_string+string[(i/4)-1];
          to_display=final_string;
        }
        document.getElementById("appear").innerHTML=to_display; 

      }, i*100);
      
    }
  </script>
</html>

-------------------------------

Subscribe my Channel:- http://www.youtube.com/user/SanketRooney?sub_confirmation=1


Facebook Page:- https://www.facebook.com/UnpossibleNS


Twitter Account:- https://twitter.com/UnpossiblePOG


Blog :- https://unpossiblepog.blogspot.in/


Wednesday 26 May 2021

Flutter Add & Edit Page To Insert & Update Data Inside SQFLITE Database Table






NOTE : You can download a whole project from  https://unpossiblepog.com/projects/dart+flutter+sqflite/Flutter-Basic-SQFLITE-Database-Project-Create-Insert-Update-Delete


1. In main.dart file, need to add new column called action, which will contain an EDIT button for each entry. For that, replace the “getDynamicTable” function with following code.


Table getDynamicTable() {

List<TableRow> rows = [];

rows.add(TableRow(children: [

Text("Id"),

Text("Name "),

Text("Address "),

Text("Actions"),

]));

if(employeeFinalList!=null)

{

for (int i = 0; i < this.employeeFinalList.length; ++i) {

rows.add(TableRow(children: [

Text(""+employeeFinalList[i]['id'].toString()),

Text("" + employeeFinalList[i]['name'].toString()),

Text("" + employeeFinalList[i]['address'].toString()),

new RaisedButton(

child: new Text('EDIT'),

onPressed: () {

Navigator.push(

context,

MaterialPageRoute(builder: (context) => insertPage(id:int.parse(employeeFinalList[i]['id']))),

);

},

)

]));

}

}

return Table(

border:TableBorder.all(width: 2.0,color: Colors.black),

columnWidths: {

0: FixedColumnWidth(100.0),

0: FixedColumnWidth(100.0),

1: FlexColumnWidth(),

},

children: rows,

);

}

-------------------------------

2. Create a new dart file at the place where the main.dart file is present. Give it a name as “addEditPage.dart” and paste the following code inside it.


import 'package:flutter/material.dart';

import 'dart:async';

import 'package:<your_project_folder_name>/database_connector.dart';

import 'package:sqflite/sqflite.dart';

import 'main.dart';

class insertPage extends StatelessWidget {

int id;

String name;

String address;

int fetchData=0;

// This widget is the root of your application.

insertPage({this.id});

var txt_1 = TextEditingController();

var txt_2 = TextEditingController();

@override

Widget build(BuildContext context) {

//print(""+id.toString());

if(id!=0)

{

DBConDisplaySpecificId(id);

}

TextStyle textStyle = Theme.of(context).textTheme.title;

return Scaffold(

appBar: AppBar(

title: Text("Second Route"),

),

body: Padding(

padding: EdgeInsets.only(top: 15.0, left: 10.0, right: 10.0),

child: ListView(

children: <Widget>[

Padding(

padding: EdgeInsets.only(top: 15.0, bottom: 15.0),

child: TextField(

controller: txt_1,

style: textStyle,

onChanged: (value) {

debugPrint('Something changed in Name Text Field');

},

decoration: InputDecoration(

labelText: 'Name',

labelStyle: textStyle,

border: OutlineInputBorder(

borderRadius: BorderRadius.circular(5.0)

)

),

),

),

Padding(

padding: EdgeInsets.only(top: 15.0, bottom: 15.0),

child: TextField(

controller: txt_2,

style: textStyle,

onChanged: (value) {

debugPrint('Something changed in Address Text Field');

},

decoration: InputDecoration(

labelText: 'Address',

labelStyle: textStyle,

border: OutlineInputBorder(

borderRadius: BorderRadius.circular(5.0)

)

),

),

),

Padding(

padding: EdgeInsets.only(top: 15.0, bottom: 15.0),

child: Row(

children: <Widget>[

Expanded(

child: RaisedButton(

color: Theme.of(context).primaryColorDark,

textColor: Theme.of(context).primaryColorLight,

child: Text(

'Save',

textScaleFactor: 1.5,

),

onPressed: () {

debugPrint("Save button clicked");

getValuesFromTextbox();

Navigator.push(

context,

MaterialPageRoute(builder: (context) => MyApp()),

);

},

),

),

Container(width: 5.0,),

],

),

)

]

)

),

);

}

void getValuesFromTextbox()

{

DatabaseConnect con = DatabaseConnect();

final Future<int> dbFuture = con.insertUpdateDynamic(id,txt_1.text,txt_2.text);

}

void DBConDisplaySpecificId(id){

DatabaseConnect con = DatabaseConnect();

List<Map<String, dynamic>> list=[];

final Future<Database> dbFuture = con.initializeDatabase();

dbFuture.then((database) {

Future<List<Map<String, dynamic>>> noteListFuture = con.getSpecificEmployee(id);

noteListFuture.then((emp_data) {

for(var i=0;i<emp_data.length;i++)

{

Map m=emp_data[i];

m.forEach((k,v) =>

{

//print('${k}: ${v}'),

if('${k}'=="name")

{

txt_1.text='${v}',

},

if('${k}'=="address")

{

txt_2.text='${v}',

}

}

);

}

print(emp_data);

});

});

}

}

-------------------------------

3. Then import that file by pasting the following code in “main.dart” file.


import 'addEditPage.dart';

-------------------------------

4. In floating button, onPressed event, add the following code.


() {

Navigator.push(

context,

MaterialPageRoute(builder: (context) => insertPage(id: id)),

);

},

-------------------------------

5. Add new integer variable in the first line of "Widget build" function.


int id=0;

-------------------------------

6. In database_connector.dart file, add the following code inside “DatabaseConnect” class.


Future<int> insertUpdateDynamic(int id,String name,String address) async {

Database db = await this.database;

var result=0;

if(id==0)

{

result = await db.rawInsert("INSERT INTO employee(name,address) VALUES('"+name+"','"+address+"')");

}

else

{

await db.rawUpdate("UPDATE employee set name='"+name+"', address='"+address+"' where id='"+id.toString()+"'");

result=id;

}

return result;

}

Future<List<Map<String, dynamic>>> getSpecificEmployee(int id) async {

    Database db = await this.database;

    var result = await db.rawQuery('SELECT * FROM employee where id='+id.toString()+' order by id ASC');

    return result;

}

-------------------------------
END
-------------------------------

Subscribe my Channel:- http://www.youtube.com/user/SanketRooney?sub_confirmation=1

Facebook Page:- https://www.facebook.com/UnpossibleNS

Twitter Account:- https://twitter.com/UnpossiblePOG

Blog :- https://unpossiblepog.blogspot.in/

-------------------------------

In last part, we displayed database in table format. In this video, we are going create add & edit page from where we can insert or update data.

We already have table structure ready, we shall add new column for edit button.

And we already have add button floating at the bottom of simulator screen.

I created a blog which contains code and instructions.

We just have to copy-paste it.

From 1st point, copy the code and replace the getDynamicTable function.

It will help to add new EDIT column.

For 2nd point, create a new dart file in LIB folder.

Paste the whole code in it.

Make sure to add correct project name, in my case it is “steps”

3rd point says that you have to import newly created file.

From 4th point, onpressed function of floating button, add the given code.

In 5th point, create a new int variable called ID with default value as 0.

From last point, copy the code, go to database_connector.dart file and paste the code inside the class.

Now let’s run the project.

Peter Parker came twice, so I am going to edit the entry.

Let’s add new entry by clicking on floating button.

So that is it, thanks for watching. Like share and subscribe.