Se connecter à Flutter avec Node js MySQL

CREATE DATABASE flutter_app;

CREATE TABLE `utilisateurs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(180) NOT NULL,
  `roles` json NOT NULL,
  `password` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_EMAIL` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

<?php
header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json");

require_once('../dbconnect.php');

$stmt = $pdo->query("SELECT * FROM client ORDER BY id DESC");
$clients = $stmt->fetchAll(PDO::FETCH_ASSOC);

echo json_encode($clients);

<?php
// Autorisations CORS
header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Methods: POST, OPTIONS");
header("Access-Control-Allow-Headers: Content-Type");
header("Content-Type: application/json");

// Gestion de la requête OPTIONS (pré-vol CORS)
if ($_SERVER['REQUEST_METHOD'] === 'OPTIONS') {
    http_response_code(200);
    exit;
}

require_once('../dbconnect.php');

// Lecture des données JSON envoyées
$data = json_decode(file_get_contents("php://input"));

// Sécurité basique : initialisation
$name = $data->name ?? '';
$family = $data->family ?? '';
$age = $data->age ?? 0;

// Vérification des champs requis
if (empty($name) || empty($family)) {
    echo json_encode(['success' => false, 
    'message' => 'Champs manquants']);
    exit;
}

// Requête d'insertion préparée
$stmt = $pdo->prepare("INSERT INTO 
client (name, family, age) VALUES (?, ?, ?)");
$success = $stmt->execute([$name, $family, $age]);

// Réponse JSON
echo json_encode([
    'success' => $success,
    'message' => $success ? 'Ajouté avec succès' : 'Erreur insertion'
]);

<?php
// Autorisations CORS
header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Methods: POST, OPTIONS");
header("Access-Control-Allow-Headers: Content-Type");
header("Content-Type: application/json");

// Gestion de la requête préliminaire OPTIONS (pré-vol CORS)
if ($_SERVER['REQUEST_METHOD'] === 'OPTIONS') {
    http_response_code(200);
    exit;
}

require_once('../dbconnect.php');

// Lecture des données JSON envoyées
$data = json_decode(file_get_contents("php://input"));

$id = $data->id ?? 0;
$name = $data->name ?? '';
$family = $data->family ?? '';
$age = $data->age ?? 0;

// Vérification de l'ID
if ($id <= 0) {
    echo json_encode(['success' => false, 'message' => 'ID invalide']);
    exit;
}

// Requête SQL préparée
$stmt = $pdo->prepare("UPDATE client SET name = ?, family = ?, age = ? WHERE id = ?");
$success = $stmt->execute([$name, $family, $age, $id]);

// Réponse
echo json_encode([
    'success' => $success,
    'message' => $success ? 'Mis à jour avec succès' : 'Échec de la mise à jour'
]);

<?php
header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json");

require_once('../dbconnect.php');

$data = json_decode(file_get_contents("php://input"));

$id = $data->id ?? 0;

if ($id <= 0) {
    echo json_encode(['success' => false, 'message' => 'ID invalide']);
    exit;
}

$stmt = $pdo->prepare("DELETE FROM client WHERE id = ?");
$success = $stmt->execute([$id]);

echo json_encode([
    'success' => $success,
    'message' => $success ? 'Supprimé avec succès' : 'Erreur de suppression'
]);

import 'dart:convert';
import 'package:flutter/material.dart';
import 'package:http/http.dart' as http;
import 'client_model.dart';

class HomePage extends StatefulWidget {
  const HomePage({super.key});

  @override
  State<HomePage> createState() => _HomePageState();
}

class _HomePageState extends State<HomePage> {
  final _nameCtrl = TextEditingController();
  final _familyCtrl = TextEditingController();
  final _ageCtrl = TextEditingController();

  String serverMsg = '';
  final List<Client> _clientsList = [];

  final String baseUrl = "http://10.0.2.2/flutter/mon_api/client"; // Utilisation de 127.0.0.1 pour fonctionner sur navigateur

  Future<void> _postRequest() async {
    try {
      final response = await http.post(
        Uri.parse("$baseUrl/insert.php"),
        headers: {'Content-Type': 'application/json'},
        body: jsonEncode({
          'name': _nameCtrl.text,
          'family': _familyCtrl.text,
          'age': int.tryParse(_ageCtrl.text) ?? 0,
        }),
      );

      _clearForm();

      if (response.statusCode == 200) {
        serverMsg = "Data Successfully Inserted";
        _getRequest();
      } else {
        serverMsg = "Insert Failed";
      }
    } catch (e) {
      serverMsg = e.toString();
    }
    setState(() {});
  }

  Future<void> _getRequest() async {
    try {
      final response = await http.get(Uri.parse("$baseUrl/get.php"));

      if (response.statusCode == 200) {
        final List jsonData = jsonDecode(response.body);
        _clientsList.clear();
        _clientsList.addAll(jsonData.map((e) => Client.fromJson(e)));
        serverMsg = "Data Loaded";
      } else {
        serverMsg = "Failed to Load";
      }
    } catch (e) {
      serverMsg = e.toString();
    }
    setState(() {});
  }

  Future<void> _deleteRequest(int id) async {
    try {
      final response = await http.post(
        Uri.parse("$baseUrl/delete.php"),
        headers: {'Content-Type': 'application/json'},
        body: jsonEncode({'id': id}),
      );

      if (response.statusCode == 200) {
        serverMsg = "Deleted Successfully";
        _getRequest();
      } else {
        serverMsg = "Delete Failed";
      }
    } catch (e) {
      serverMsg = e.toString();
    }
    setState(() {});
  }

  Future<void> _updateRequest(Client client) async {
    try {
      final response = await http.post(
        Uri.parse("$baseUrl/update.php"),
        headers: {'Content-Type': 'application/json'},
        body: jsonEncode(client.toJson()),
      );

      if (response.statusCode == 200) {
        serverMsg = "Updated Successfully";
        _getRequest();
      } else {
        serverMsg = "Update Failed";
      }
    } catch (e) {
      serverMsg = e.toString();
    }
    setState(() {});
  }

  void _clearForm() {
    _nameCtrl.clear();
    _familyCtrl.clear();
    _ageCtrl.clear();
  }

  @override
  void initState() {
    super.initState();
    _getRequest();
  }

  @override
  Widget build(BuildContext context) {
    return Scaffold(
      appBar: AppBar(title: const Text("CRUD Example")),
      body: SafeArea(
        child: Column(
          children: [
            Container(
              height: 300,
              color: Colors.grey[200],
              padding: const EdgeInsets.all(20),
              child: Column(
                children: [
                  TextField(
                    controller: _nameCtrl,
                    decoration: const InputDecoration(labelText: 'Name'),
                  ),
                  TextField(
                    controller: _familyCtrl,
                    decoration: const InputDecoration(labelText: 'Family'),
                  ),
                  TextField(
                    controller: _ageCtrl,
                    decoration: const InputDecoration(labelText: 'Age'),
                    keyboardType: TextInputType.number,
                  ),
                  const SizedBox(height: 16),
                  Text(
                    serverMsg,
                    style: const TextStyle(color: Colors.blue),
                  ),
                ],
              ),
            ),
            Expanded(
              child: ListView.builder(
                itemCount: _clientsList.length,
                itemBuilder: (context, index) {
                  final client = _clientsList[index];
                  return ListTile(
                    title: Text("${client.name} ${client.family}"),
                    subtitle: Text("Age: ${client.age}"),
                    trailing: Row(
                      mainAxisSize: MainAxisSize.min,
                      children: [
                        IconButton(
                          icon: const Icon(Icons.edit, color: Colors.green),
                          onPressed: () {
                            _nameCtrl.text = client.name;
                            _familyCtrl.text = client.family;
                            _ageCtrl.text = client.age.toString();

                            // Show dialog to update client
                            showDialog(
                              context: context,
                              builder: (_) {
                                return AlertDialog(
                                  title: Text("Modifier le client"),
                                  content: Column(
                                    mainAxisSize: MainAxisSize.min,
                                    children: [
                                      TextField(
                                        controller: _nameCtrl,
                                        decoration: const InputDecoration(labelText: "Name"),
                                      ),
                                      TextField(
                                        controller: _familyCtrl,
                                        decoration: const InputDecoration(labelText: "Family"),
                                      ),
                                      TextField(
                                        controller: _ageCtrl,
                                        decoration: const InputDecoration(labelText: "Age"),
                                      ),
                                    ],
                                  ),
                                  actions: [
                                    TextButton(
                                      child: const Text("Annuler"),
                                      onPressed: () => Navigator.pop(context),
                                    ),
                                    ElevatedButton(
                                      child: const Text("Mettre à jour"),
                                      onPressed: () {
                                        _updateRequest(Client(
                                          id: client.id,
                                          name: _nameCtrl.text,
                                          family: _familyCtrl.text,
                                          age: int.tryParse(_ageCtrl.text) ?? 0,
                                        ));
                                        Navigator.pop(context);
                                      },
                                    ),
                                  ],
                                );
                              },
                            );
                          },
                        ),
                        IconButton(
                          icon: const Icon(Icons.delete, color: Colors.red),
                          onPressed: () {
                            _deleteRequest(client.id);
                          },
                        ),
                      ],
                    ),
                  );
                },
              ),
            ),
          ],
        ),
      ),
      floatingActionButton: FloatingActionButton(
        onPressed: _postRequest,
        child: const Icon(Icons.add),
      ),
    );
  }
}