openclaw - 💡(How to fix) Fix [Collection]: Collection of user cases of OpenClaw [1 comments, 2 participants]

// Import required modules
const express = require('express');
const app = express();
const mysql = require('mysql');

// Set up database connection
const db = mysql.createConnection({
  host: 'your_host',
  user: 'your_user',
  password: 'your_password',
  database: 'your_database'
});

// Create a web form
app.get('/submit', (req, res) => {
  res.send(`
    <form action="/submit" method="post">
      <label>Case Name:</label>
      <input type="text" name="caseName"><br><br>
      <label>Use Case:</label>
      <input type="text" name="useCase"><br><br>
      <label>Channel:</label>
      <input type="text" name="channel"><br><br>
      <label>Workflow:</label>
      <input type="text" name="workflow"><br><br>
      <label>Benefits:</label>
      <input type="text" name="benefits"><br><br>
      <input type="submit" value="Submit">
    </form>
  `);
});

// Handle form submission
app.post('/submit', (req, res) => {
  const { caseName, useCase, channel, workflow, benefits } = req.body;
  db.query(`INSERT INTO use_cases (case_name, use_case, channel, workflow, benefits) VALUES (?, ?, ?, ?, ?)`, [caseName, useCase, channel, workflow, benefits], (err, results) => {
    if (err) {
      console.error(err);
      res.status(500).send('Error submitting use case');
    } else {
      res.send('Use case submitted successfully');
    }
  });
});

// Display collected use cases
app.get('/use-cases', (req, res) => {
  db.query('SELECT * FROM use_cases', (err, results) => {
    if (err) {
      console.error(err);
      res.status(500).send('Error retrieving use cases');
    } else {
      res.send(results);
    }
  });
});