PHP - Make A Tab Delimited File From Array Or Object

Hi all!

Ok I am trying to put a delimited list like so , EX. item qty, item name, item price | item qty, item name, item price | item qty, item name, item price | etc. into an array so I can access it like this - $product[0] = qty, $product[1] = name, etc. My code just isnt working. This is what I have so far.

$prod = array();
//breaking products text down for display
$products1 = explode("|", $products);
$num_prod1 = count($products1);
$count = 0;
foreach($products1 as $p) {
$prod[] = $p;
$products2 = explode(",", $p);
foreach($products2 as $p2) {
$prod[$count] = $prod[$count][$p2];
}
$count++;
}

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.

 

 

 

Hey!

I have a table and in that table I have a "name" field, and a "description" field. I'm trying to make a tag system for these rows.

I'd like to use a denormalized approach because I can't wrap my head around a normalized approach.

I don't have a problem adding, for instance, catid_1, catid_2, catid_3 columns and do a WHERE statement to fetch only rows with that particular column IE: $sql = mysql_query("SELECT * FROM tablename WHERE catid_1='categorynameortag' ORDER BY DESC")

How would I make it so rather than having individual columns, I can put all that data into one field with comma's. Then also, how would I fetch and display  only rows with one of the words in the field?

Thank you for your help.

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);
?>

I need to return a specific key from the object converted to array but it seems that it dosent work

Code: [Select]
$toarray = (array)$tmp;
$name = array_keys($toarray,'name');
print_r($toarray);
print:Array ( [id] => 9 [name] => dfd [text] => fdsf [rating] => 0 [totalv] => 0 )

and when i try to return the key

Code: [Select]
print_r($name);
Array ( => rating [1] => totalv )

But I only need the key whit the 'name' value