I'm having trouble getting this into a $_POST value how would I go about this? So basically I want to get each value.
<?php
require "scripts/db.ini.php";
$sql22 = "SELECT * FROM `category` WHERE `delete` = '0' AND `side` = 'right'";
//query
$query22 = mysqli_query($db,$sql22);
while($rows22 = mysqli_fetch_assoc($query22)){
$db_id = $rows22['id'];
$db_name =$rows22['name'];
echo "<input type='checkbox' name='$db_name' value='$db_id'>$db_name<br>";
}
?>
Try use foreach like this
$sql22 = "SELECT * FROM `category` WHERE `delete` = '0' AND `side` = 'right'";
//query
$query22 = mysqli_query($db,$sql22);
echo '<form action="" method="POST">';
while($rows22 = mysqli_fetch_assoc($query22)) {
foreach($rows22 as $row) {
echo '<input type="checkbox" name="'.$row['name'].'" value="'.$row['id'].'">'.$row['name'].'<br>';
}
}
echo '<input type="submit">';
echo '</form>';
echo '<pre>';
print_r($_POST);
echo '</pre>';