PHP - Explode Comma Delimited Field For Tagging System

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.

 

 

 

I am attempting to submit a form that includes multiple check boxes for one data field. I have set it up the implode the data and make it a comma delimited array. I am able to echo the results, yet I have not been able to post the information to the database. I believe that I have just one simple thig to do, yet I am not being successful. Here is my code I have attached the .txt file also:

<?php require_once('Connections/rotarysantarosa.php'); ?>
<?php
   if (isset($_POST['submit']))
   {
      if (isset($_POST['currentClubPosition']))
      {
         $strcurrentClubPosition = implode(",", $_POST['currentClubPosition']);
      }
      else
      {
         $strcurrentClubPosition = "";
      }

   }
?>
 
 <?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;   
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "frmMemberInsert")) {
  $insertSQL = sprintf("INSERT INTO members (firstName, lastName, photo, pastPresident, currentClubPosition, classification, workPosition, company, workAddress, workCity, workState, workZip, officePhone, fax, homePhone, cellPhone, email, website, homeAddress, homeCity, homeState, homeZip, birthdayMonth, birthdayDay, spouse, yearJoined) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['firstName'], "text"),
                       GetSQLValueString($_POST['lastName'], "text"),
                       GetSQLValueString($_POST['photo'], "text"),
                       GetSQLValueString($_POST['pastPresident'], "text"),
                       GetSQLValueString($_POST['currentClubPosition'], "text"),
                       GetSQLValueString($_POST['classification'], "text"),
                       GetSQLValueString($_POST['workPosition'], "text"),
                       GetSQLValueString($_POST['company'], "text"),
                       GetSQLValueString($_POST['workAddress'], "text"),
                       GetSQLValueString($_POST['workCity'], "text"),
                       GetSQLValueString($_POST['workState'], "text"),
                       GetSQLValueString($_POST['workZip'], "text"),
                       GetSQLValueString($_POST['officePhone'], "text"),
                       GetSQLValueString($_POST['fax'], "text"),
                       GetSQLValueString($_POST['homePhone'], "text"),
                       GetSQLValueString($_POST['cellPhone'], "text"),
                       GetSQLValueString($_POST['email'], "text"),
                       GetSQLValueString($_POST['website'], "text"),
                       GetSQLValueString($_POST['homeAddress'], "text"),
                       GetSQLValueString($_POST['homeCity'], "text"),
                       GetSQLValueString($_POST['homeState'], "text"),
                       GetSQLValueString($_POST['homeZip'], "text"),
                       GetSQLValueString($_POST['birthdayMonth'], "text"),
                       GetSQLValueString($_POST['birthdayDay'], "int"),
                       GetSQLValueString($_POST['spouse'], "text"),
                       GetSQLValueString($_POST['yearJoined'], "int"));

  mysql_select_db($database_rotarysantarosa, $rotarysantarosa);
  $Result1 = mysql_query($insertSQL, $rotarysantarosa) or die(mysql_error());

  $insertGoTo = "members.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_rotarysantarosa, $rotarysantarosa);
$query_rsStates = "SELECT * FROM states ORDER BY stateName ASC";
$rsStates = mysql_query($query_rsStates, $rotarysantarosa) or die(mysql_error());
$row_rsStates = mysql_fetch_assoc($rsStates);
$totalRows_rsStates = mysql_num_rows($rsStates);

mysql_select_db($database_rotarysantarosa, $rotarysantarosa);
$query_rsMemberInsert = "SELECT * FROM members ORDER BY lastName ASC";
$rsMemberInsert = mysql_query($query_rsMemberInsert, $rotarysantarosa) or die(mysql_error());
$row_rsMemberInsert = mysql_fetch_assoc($rsMemberInsert);
$totalRows_rsMemberInsert = mysql_num_rows($rsMemberInsert);

mysql_select_db($database_rotarysantarosa, $rotarysantarosa);
$query_rsClubPosition = "SELECT * FROM clubpositions ORDER BY `Club Position` ASC";
$rsClubPosition = mysql_query($query_rsClubPosition, $rotarysantarosa) or die(mysql_error());
$row_rsClubPosition = mysql_fetch_assoc($rsClubPosition);
$totalRows_rsClubPosition = mysql_num_rows($rsClubPosition);

mysql_select_db($database_rotarysantarosa, $rotarysantarosa);
$query_rsClassification = "SELECT * FROM classifications ORDER BY Classification ASC";
$rsClassification = mysql_query($query_rsClassification, $rotarysantarosa) or die(mysql_error());
$row_rsClassification = mysql_fetch_assoc($rsClassification);
$totalRows_rsClassification = mysql_num_rows($rsClassification);

mysql_select_db($database_rotarysantarosa, $rotarysantarosa);
$query_rsBirthMonth = "SELECT * FROM birthdaymonth";
$rsBirthMonth = mysql_query($query_rsBirthMonth, $rotarysantarosa) or die(mysql_error());
$row_rsBirthMonth = mysql_fetch_assoc($rsBirthMonth);
$totalRows_rsBirthMonth = mysql_num_rows($rsBirthMonth);

mysql_select_db($database_rotarysantarosa, $rotarysantarosa);
$query_rsBirthDay = "SELECT * FROM birthdayday ORDER BY birthdayday ASC";
$rsBirthDay = mysql_query($query_rsBirthDay, $rotarysantarosa) or die(mysql_error());
$row_rsBirthDay = mysql_fetch_assoc($rsBirthDay);
$totalRows_rsBirthDay = mysql_num_rows($rsBirthDay);
?>

Hi, i got help earlier with the this code-- exploding a field and getting an array, then inserting the array into a multiselect box-- That part is easy and works fine.

Now the explode function gives an array of words with duplicate words in it:
I tried several ways most either give a blank option/value, or the array word..

here is the code:


$query = "SELECT DISTINCT property_functionsexperience FROM #__users_profiles WHERE published = '1' ORDER BY property_functionsexperience ASC";
      $functionsexperiencelistgeneral=doSelectSql($query);      
        foreach($functionsexperiencelistgeneral as $words)
      $property_funcexperilist=$words->property_functionsexperience;      
        $wording = explode(', ', $property_funcexperilist);
        foreach($wording as $funciex)
      $funcexi=array_unique($funciex);
      $funcexpList .= "<option value=\"".$funcexi.','."\">".$funcexi."</option>";
      $funcexpList .= "</optgroup>";
            }
         $funcexpList.="</select>";
         $output['FUNCEXPLIST']=$funcexpList;         


this code is adapted slightly from the working original that gives the double words-- this code gives a blank, but i think its on the correct track!?

Hello Guys,

I check the price field on the server side and I am trying to figure out how to allow a comma in the price field

example 2,300

Here is the code I use to check the price.
Code: [Select]
function check_Price($price,$member_id,$description,$ip){
if (isset($price) && (!is_numeric($price)))
{
      do something here
}

}
Thanks in Advance!
Dan

If I explode a string well using a substring when I implode that substring is now missing.

for example.
Code: [Select]
$exploded = explode("[MAC]",$data);

$data = implode($exploded);
Now [MAC] would be missing in the $data string. any way to get around this?