Feature #1905
change AddAffiliateProgram to have checkboxes to select categories
0%
Description
Change https://pickleballdiscountcodes.com/addProgram.html (will probably have to make it addProgram.php).
Currently it requires entering one or more categories manually into a text field ("Categories: enter one or more (comma separated) of the categories in affCategories: "Gear", "Apparel", "Other".").
Change it to dynamically offer a list of checkboxes based on the records currently in the affPrograms table and submit that list as the "categories" field when submitting the form.
Suggested strategy (feel free to implement some other way if you have a better idea).
1) Copy the code from index.php to connect to the database.
2) Update addProgram to create the list of checkboxes (perhaps this works) ...
$sql = "SELECT cat FROM affCategories";
$result = $conn->query($sql);
$categories = array();
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$categories[] = $row["cat"];
}
}
$conn->close();
?>
<!-- HTML part to generate checkboxes -->
<form action="process_form.php" method="post">
<fieldset>
<legend>Select Categories:</legend>
<?php foreach ($categories as $category): ?>
<label>
<input type="checkbox" name="categories[]" value="<?php echo htmlspecialchars($category); ?>">
<?php echo htmlspecialchars($category); ?>
</label><br>
<?php endforeach; ?>
<br>
<input type="submit" value="Submit">
</fieldset>
</form>
3) Create 'process_form.php' (or do it some other way) to populate the 'categories' field in addProgram from the submitted checkboxes.
<label for="categories"><b>Categories</b>: enter one or more (comma separated) of the categories in affCategories: "Gear", "Apparel", "Other".</label><br>
<input type="text" id="categories" name="categories" value="Gear" size="80" required><br><br>
This is on a cPanel site, not CG, contact Kevin for credentials.
History
#1
Updated by Kevin Zaleski 9 months ago
Updated by To populate the 'categories' field in a form with the list of categories selected using checkboxes, you'll need to handle the form submission and processing using PHP. Here’s how you can modify the previous example to achieve this:
HTML Form with Checkboxes: Include checkboxes dynamically populated from your database.
PHP Form Processing: Handle form submission to display selected categories.
Here's an example of how you can achieve this:
HTML Form with Checkboxes
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Select Categories</title>
</head>
<body>
<form action="process_form.php" method="post">
<fieldset>
<legend>Select Categories:</legend>
<?php
// Example PHP code to fetch categories from database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "your_database";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT cat FROM affCategories";
$result = $conn->query($sql);
$categories = array();
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$categories[] = $row["cat"];
}
}
$conn->close();
// Check if form submitted and display selected categories
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$selectedCategories = $_POST['categories'] ?? array();
echo '<p>Selected Categories: ';
foreach ($selectedCategories as $category) {
echo htmlspecialchars($category) . ', ';
}
echo '</p>';
}
?>
<?php foreach ($categories as $category): ?>
<label>
<input type="checkbox" name="categories[]" value="<?php echo htmlspecialchars($category); ?>">
<?php echo htmlspecialchars($category); ?>
</label><br>
<?php endforeach; ?>
<br>
<input type="submit" value="Submit">
</fieldset>
</form>
</body>
</html>
PHP Form Processing (process_form.php)
In process_form.php, you handle the form submission and process the selected categories:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Processed Form</title>
</head>
<body>
<?php
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$selectedCategories = $_POST['categories'] ?? array();
echo '<p>Selected Categories: ';
foreach ($selectedCategories as $category) {
echo htmlspecialchars($category) . ', ';
}
echo '</p>';
}
?>
<p><a href="index.php">Back to Selection</a></p>
</body>
</html>
Explanation
HTML Form (index.php): This form displays checkboxes dynamically populated with categories fetched from the database. It uses PHP to fetch categories and generate checkboxes.
PHP Form Processing (process_form.php): This script handles form submission. It retrieves selected categories from $_POST['categories'] and displays them.
Notes
Ensure your database connection ($servername, $username, $password, $dbname) is correctly configured.
Replace placeholders like "localhost", "username", "password", "your_database" with your actual database credentials.
This example assumes you're using PHP with MySQL. Adjust accordingly if you're using different technologies.
This setup allows you to dynamically populate checkboxes from your database and process selected categories upon form submission. Adjust the HTML and PHP logic based on your specific requirements and environment.