PHP - Add Comma After Each Selected Checkbox When Outputting To Email

I am trying to give role based access here. I want to display the pages which user has access in checkbox format. Here is my code

$sql = "SELECT p.page_id AS pid, 
                            p.page, 
                            p.href, 
                            ra.pages AS rpage 
             FROM pages p 
             INNER JOIN role_access ra 
             WHERE p.page_id IN (ra.page) 
             AND ra.role=1";

$query = mysqli_query($con, $sql) or die(mysqli_error($con));

$checked_arr = array();

while($row = mysqli_fetch_array($query)) { 
$checked_arr = explode(",",$row['rpage']);

foreach ($checked_arr as $page) {

    echo "<br/><input type='checkbox' name=\"pages[]\" value='$page' />$page<br>";
}

My tables are like this

ROLE

CREATE TABLE `role` (
  `rid` int(5) NOT NULL,
  `role_name` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `role` (`rid`, `role_name`) VALUES
(1, 'Admin'),
(2, 'Others');

ALTER TABLE `role`
  ADD PRIMARY KEY (`rid`);


ROLE-ACCESS

CREATE TABLE `role_access` (
  `id` int(10) NOT NULL,
  `page` varchar(160) NOT NULL,
  `role` int(7) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `role_access` (`id`, `page`, `role`) VALUES
(1, '1,2,3,4,5', 1),
(2, '2,4,5', 2);

ALTER TABLE `role_access`
  ADD PRIMARY KEY (`id`);



PAGES

CREATE TABLE `pages` (
  `page_id` int(11) NOT NULL,
  `code` varchar(10) NOT NULL,
  `page` varchar(100) NOT NULL,
  `href` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `pages` (`page_id`, `code`, `page`, `href`) VALUES
(1, 'Patient', 'Registration', '/patient_registration.php'),
(2, 'Patient', 'List', '/patient_list.php'),
(3, 'Patient', 'Edit', '/edit_patient.php'),
(4, 'Patient', 'Export', '/export_patient.php'),
(5, 'Patient', 'MRD', '/patient_MRD.php');

ALTER TABLE `pages`
  ADD PRIMARY KEY (`page_id`);

 

 

In above query i get result like this

But required result is

if i change checkbox display like

while($row = mysqli_fetch_array($query)) { 
$checked_arr = explode(",",$row['rpage']);
$pname = $row['page'];
foreach ($checked_arr as $page) {

    echo "<br/><input type='checkbox' name=\"pages[]\" value='$page' />$pname<br>";
}
}

i get result

 

How to get the names for that file.

 

 

 

Hi guys, im having a radio button which i need it to be checked if its status is equal to something.

as an example i need to use the checkbox below checked if its field in mysql is equal to male

     <p>Male
                <input type="radio" name="male" value="Male"/>
                <br/>


this is made for a profile page where users can insert their gneder, I know i have to return the value from myslq to check if its equal to radio button value, I can do select mysql_query from my db but how should i say if its match, check the radio button?
can u please help me how to do it?

I have an audio mix submitting form on my website. The first part of the form takes the details from the user and inserts a new row in the first table 'mix', auto incrementing to generate a mix_id primary key.

The second part then uses a series of check boxes  to select which genres the mix contains and a foreach for the resulting array to insert, into the 2nd table 'genres_for_mix', a new row for each genre id (foreign key for the genres table) that is selected and the mix_id that it concerns.

Now I'm starting to think this is a bad way to do this because:

1. I don't know how to echo this out when a user edit's the mix to make all the relevant checkboxes selected.
2. When a user deselects a choice, it would be quite long winded to delete the nessesary row.


So instead I'm thinking that it would be much wiser to user the serialise functions to put the array into the database


However, I still don't know how to make the right checkboxes selected when I echo out the edit form. Do I use something like inarray()? If so how?

Also, it's really important that I can query the database for mixes that are associated with a specific genre. Without unserialising the array and therefore echo'ing out all the results, I don't know how to query this. Would I just use a 'WHERE genre_field LIKE 'genre_id'?

Can anyone help me with this please?

Hi,

I am new to php and need help.
I am building a library system for an assignment.
I want to provide a functionality that registers (adds) all transactions to defferent databases.
I am stuck on how to add a selected row (selected by a checkbox) to the database and make sure that 2 users cannot update the same record at the same time.

Thanks for your help.

bellow is my code:

Code: [Select]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
  <meta http-equiv="content-type" content="text/html; charset=windows-1250">
  <meta name="generator" content="PSPad editor, www.pspad.com">
  <title>Web Works DD - Web Development & Software Solutions</title>
         <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3/jquery.min.js"></script>
      <link rel="stylesheet" type="text/css" href="css/style.css" />
 
  </head>
  <body>
  <!--<div class="utilities">
         <!-- UTILITIES MENU --
      <a href="index.php" style=text-decoration:none;><img src="images/home.png" border="0" alt="Home Page"/> Home Page</a>    <a href="sitemap.php" style=text-decoration:none;><img src="images/sitemap.png" border="0" alt="Sitemap"/> Sitemap</a>
        </div><!-- END UTILITIES -->
 
  <div id="right_bar">   <!-- right bar starts here -->
  </div> <!-- end of right bar -->
 
  <div id="top_bar">   <!-- top bar starts here -->
  <a href="index.php" style=text-ecoration:none; title="Web Works DD - Web Development & Software Solutions"><img src="images/mainLib.jpg" border=0 style=height:180;/> </a>
  <img src="images/topText.jpg" border=0 style=height:180;/>
  </div> <!-- end of top bar -->
       
 <div id="container">
 <div id="top-logo">
  <!--<a href="index.php" style=text-ecoration:none; title="Web Works DD - Web Development & Software Solutions"><img src="images/Main_logo.jpg" border=0 /> </a> -->
  </div>   
         
     <ul class="dropdown dav">
     <li><a href="index1.php">HOME</a></li>
     <li><a href="#" class="dir">VIEW RWSOURCES</a>
      <ul>
         <li><a href="books.php">BOOKS</a></li>
         <li><a href="dvds.php">DVDS</a></li>
         <li><a href="journals.php">JOURNALS</a></li>
    </ul>
   </li>
   <li><a href="staffLogin.php">STAFF ZONE</a></li>
    <li><a href="studentsLogin.php">STUDENT ZONE</a></li>
   
</ul>

<table>
<!--This defines a new form -->
<form action="" method="post">
<!--This creates the dropdown in html-->
<select name="fields">
<option value="1">Please select...</option>
<option value="isbnno">isbnno</option>
<option value="title">title</option>
<option value="description">description</option>
<option value="author">author</option>   
</select>
</td>
</tr>
<tr>
<td>
<input type="text" name="value" size="40">
</td>
</tr>
<tr>
<td>
<!-- Create a button -->
<input type="submit" value="Select" name="select">
</td>
</tr>
</form>
</table>
 
<?php
 session_start();
 include("secure/db_open.php");
       /* $myusername=$_SESSION['myusername']; 
        echo $myusername;
        $insert = $checkbox[$i];
        $cops = $_POST['copies'];
        $userid ="SELECT id FROM students WHERE username = '$myusername'";  
        $uido = mysql_query($userid); 
        $row = mysql_fetch_array($uido);
        echo $row['id'];    */
        
        
  
// get variable after selecting something from the dropdown with name 'fields'

$select = $_POST['select']; 
$valu = $_POST['value'];
// if something has been chosen
if (!empty($select)) 
{ 

$fields = $_POST['fields'];  //get the chosen value
$allbooks="SELECT * FROM books WHERE {$fields} = '$valu'";
//select books that are available - driven by the user's input
$copas="SELECT * FROM books WHERE {$fields} = '$valu' AND available_copies > 0";
$copy = mysql_query($copas); 
//count the number of rows resulting from the query
$count=mysql_num_rows($copy);
//$copse = mysql_fetch_array($copy);

//select books that are not available
$notavailable="SELECT * FROM books WHERE {$fields} = '$valu' AND available_copies = 0";
$shownotavailable=mysql_query($notavailable);
$count1=mysql_num_rows($shownotavailable);

//display a form 
echo "<table width='1100' border='0' cellspacing='1' cellpadding='0'>";
echo "<tr>";
echo "<td>" ;
echo "<form name='form1' method='post' action=''>";
echo "<table width='1100' border='0' cellpadding='3' cellspacing='1' bgcolor='#CCCCCC'>";
echo "<tr>";
echo "<td align='center' colspan='9' bgcolor='#FFFFFF'>";
echo "<strong>Available to Loan </strong>" ;
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='center' bgcolor='#FFFFFF'>Loan</td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>ISBN No.</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Title</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Description</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Author</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Loan Type</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Location</strong></td>"; 
echo "<td align='center' bgcolor='#FFFFFF'><strong>Available Copies</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Desired Num of Copies</strong></td>";
echo "</tr>"; 
while(($row = mysql_fetch_assoc($copy)))
  {  
  echo "<tr>";
  echo "<td align='center' bgcolor='#FFFFFF'><input name='checkbox[]' type='checkbox' id='checkbox[]' value=".$row['bookid']."></td>";
  echo "<td>" .$row['isbnno']. "</td>";
  echo "<td>" .$row['title']. "</td>";
  echo "<td>" .$row['description']. "</td>";
  echo "<td>" .$row['author']. "</td>";
  echo "<td>" .$row['loan_type']. "</td>";
  echo "<td>" .$row['location']. "</td>";
  echo "<td>" .$row['available_copies']. "</td>"; 
  echo "<td align='center' bgcolor='#FFFFFF'><input name='copies' type='text' id='copies' size='2'></td>";  
  echo "</tr>";
  }        
echo "<tr>";
echo "<td colspan='9' align='center' bgcolor='#FFFFFF'><input name='loan' type='submit' id='loan' value='Loan Book'></td>";
echo "</tr>";
echo "</table>"; 

if (isset($_POST))
{
      session_start();
        $myusername=$_SESSION['myusername'];     
        $cops = $_POST['copies'];
        $userid ="SELECT id FROM students WHERE username = $myusername";  
        $uido = mysql_query($userid); 
        $row1 = mysql_fetch_array($uido);
        $sid = $row1['id']; 
        
    for ($i=0;$i<$count;$i++)
    {   
        $insert = $checkbox[$i];
       //echo "Welcome, ".$row['id'];
        $insertloaned="INSERT INTO studentloanedbooks(studentid, bookid, noofcopies) VALUES ($sid, $insert, $cops)";
        $loaned = mysql_query($insertloaned);
            
    }   
     
}  
    
if($count1>0)
{
    //display the books details
    //display a form 
echo "<br>";
echo "<br>";  
echo "<table width='1100' border='0' cellspacing='1' cellpadding='0'>";
echo "<tr>";
echo "<td>" ;
echo "<form name='form1' method='post' action=''>";
echo "<table width='1100' border='0' cellpadding='3' cellspacing='1' bgcolor='#CCCCCC'>";
echo "<tr>";
echo "<td align='center' colspan='9' bgcolor='#FFFFFF'>";
echo "<strong>Available to Loan </strong>" ;
echo "</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='center' bgcolor='#FFFFFF'>Loan</td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>ISBN No.</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Title</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Description</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Author</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Loan Type</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Location</strong></td>"; 
echo "<td align='center' bgcolor='#FFFFFF'><strong>Available Copies</strong></td>";
echo "<td align='center' bgcolor='#FFFFFF'><strong>Desired Num of Copies</strong></td>";
echo "</tr>"; 
while(($row = mysql_fetch_assoc($shownotavailable)))
  {  
  echo "<tr>";
  echo "<td align='center' bgcolor='#FFFFFF'><input name='checkbox[]' type='checkbox' id='checkbox[]' value='.$row[bookid]'></td>";
  echo "<td>" .$row['isbnno']. "</td>";
  echo "<td>" .$row['title']. "</td>";
  echo "<td>" .$row['description']. "</td>";
  echo "<td>" .$row['author']. "</td>";
  echo "<td>" .$row['loan_type']. "</td>";
  echo "<td>" .$row['location']. "</td>";
  echo "<td>" .$row['available_copies']. "</td>"; 
  echo "<td align='center' bgcolor='#FFFFFF'><input name='copies' type='text' id='copies' size='2'></td>";  
  echo "</tr>";
  }        
echo "<tr>";
echo "<td colspan='9' align='center' bgcolor='#FFFFFF'><input name='reserve' type='submit' id='reserve' value='Reserve Book'></td>";
echo "</tr>";
echo "</table>"; 

    
}



}
// include("secure/db_close.php");   


 //include("secure/db_close.php");  
?>
   


<!--if($cop>0){  -->



<!-- this is my footer div -->
<div id="footer">
Copyright &copy; 2010 | <a href="privacy.php">Privacy Policy</a> | <a href="terms.php">Terms of Service</a>
<img src="images/mini_logo1.png" align="right" style="margin-right:5" />
</div>   <!-- End footer div -->

    </div>
    </div>
  </body>
</html>

MOD EDIT: [code] . . . [/code] BBCode tags added.

I am simply trying to keep a check box checked once selected. What I have works, but not correctly.

Because I am calling each array element in my checkbox like

 name="checkbox[]"

And I am using this as the input return the check:

<input type="checkbox" name="checkbox[]" value="checkOneValue" <?php if(isset($_POST['checkbox'])) echo "checked"; ?> />

I have 5 checkboxes that use the same code! And as I said it works, but returns ALL checkboxes as selected when submitted.

I only want the actual selected boxes to remained checked.

Any insight on a work around? The problem is I cannot solve how to identify unique array values as they are all named the same... Maybe I am not thinking right on all of this.

Here is my full source code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Checkbox Echoing Test</title>
</head>
<body>
<form name="" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
  One
  <input type="checkbox" name="checkbox[]" value="checkOneValue" <?php if(isset($_POST['checkbox'])) echo "checked"; ?> />
  <br />
  Two
  <input type="checkbox" name="checkbox[]" value="checkTwoValue" <?php if(isset($_POST['checkbox'])) echo "checked"; ?> />
  <br />
  Three
  <input type="checkbox" name="checkbox[]" value="checkThreeValue" <?php if(isset($_POST['checkbox'])) echo "checked"; ?> />
  <br />
  Four
  <input type="checkbox" name="checkbox[]" value="checkFourValue" <?php if(isset($_POST['checkbox'])) echo "checked"; ?> />
  <br />
  Five
  <input type="checkbox" name="checkbox[]" value="checkFiveValue" <?php if(isset($_POST['checkbox'])) echo "checked"; ?> />
  <br />
  <input type="submit" name="submit" value="Echo Checkbox Data!" />
</form>
<?php



if (isset($_POST['checkbox']) && (isset($_POST['submit']))) { 

$checkbox = $_POST['checkbox'];

foreach ($checkbox as $checkboxValue) {

var_dump($checkboxValue);

if (!empty($checkboxValue)) {
echo "<br />$checkboxValue is checked";
}
}
}; // End of foreach loop

if (!isset($_POST['checkbox']) && (isset($_POST['submit']))) {
echo "<br />No checkboxes were selected!";
};

?>
</body>
</html>