PHP - Outputting An Array Into A Textarea Field

I have converted xml into an array with no problems, however I'm having difficulty outputting the various attributes.

Here is a sample:

Code: [Select]
[0] => Array
                        (
                            [@attributes] => Array
                                (
                                    [YourId] => 1082-1
                                    [Name] => Woodwards Metals
                                    [Description] =>
                                 )
 
                        )
The bit that is confusing me is the @attributes part. How would I output the 'Name' element for example?

I am trying to load all rows from a table in a database into a table on a webpage. I cannot understand why the following code does not work:
Code: [Select]
<?php ...
echo "You are currently in a fleet. The details of the fleet are below.<br>";
$fleetName = $_SESSION['charFleetName'];
$sqlFleetDetails = "SELECT * FROM `$fleetName`";
$queryFleetDetails = mysql_query($sqlFleetDetails);
echo "<table>";
echo "<tr>";
echo "<th>Pilot</th>";
echo "<th>Ship</th>";
echo "<th>Type</th>";
echo "</tr>";
while($rowFleetDetails = mysql_fetch_array($queryFleetDetails)) {
$charId = $rowFleetDetails['charId'];
$charName = $rowFleetDetails['charName'];
$shipHull = $rowFleetDetails['shipHull'];
$shipType = $rowFleetDetails['shipType'];
echo "<tr>";
echo "<td><a href=\"#\" onClick=\"CCPEVE.showInfo{1377, " . $charId . "}>" . $charName . "</a></td>";
echo "<td>" . $shipHull . "</td>";
if($shipType == 1)
echo "<td>Logistics</td>";
if($shipType == 2)
echo "<td>DPS Boat</td>";
if($shipType == 3)
echo "<td>Sniper 120Km+</td>";
if($shipType == 4)
echo "<td>Off-grid Booster</td>";
echo "</tr>";
}
echo "</table><br>";
I originally had the $rowFleetDetails['charId'] and others in the echo instead of loading them into variables then echoing the variables but changed it to see if that was working, neither is. If I add an extra line outside of the while loop to echo the output of the array then the information is displayed fine, so I know that the information is being transferred from the table into the array correctly, but why is it not outputting properly in the While loop?

I have a Q&A Form/script where registered Users can share there thoughts on 10 Questions.

On the backend I have these tables:  member, answer, question

Thanks to some help last night, I have been able to do a LEFT join and store the above data in a multi-dimensional array which always stoes the 10 Questions, and also any Answers that the User may have responded to.  (Questions are optional.)

I am having a hell of a time DISPLAYING this multi-dimensional array.

The key is that I want my PHP and array to stay at the top of my script and use minimal PHP in my HTML section.

Here is how I query the data and build my array...

// ********************
// Build Q&A Query. *
// ********************

// Build query.
$q7 = "SELECT q.id, q.question_no, q.question_text, a.answer_text
FROM bio_question AS q
LEFT JOIN bio_answer AS a
ON q.id=a.question_id
AND a.member_id =?
ORDER BY q.question_no";

// Prepare statement.
$stmt7 = mysqli_prepare($dbc, $q7);

// Bind variables to query.
mysqli_stmt_bind_param($stmt7, 'i', $memberID);

// Execute query.
mysqli_stmt_execute($stmt7);

// Store results.
mysqli_stmt_store_result($stmt7);

// Check # of Records Returned.
if (mysqli_stmt_num_rows($stmt7) > 0){
// Questions Found.

// Bind result-set to variable.
mysqli_stmt_bind_result($stmt7, $questionID, $questionNo, $questionText, $answerText);

// Populate PHP array with Questions & Answers.
$x=1;
while (mysqli_stmt_fetch($stmt7)){
$thoughtsArray[$x] = array('questionID' => $questionID,
'questionText' => $questionText,
'answerText' => $answerText);
$x=$x+1;
}

echo '<pre>';
print_r($thoughtsArray);
echo '</pre>';


// Close prepared statement.
mysqli_stmt_close($stmt7);



And in my HTML Form, here is how I am attempting to dynamically build the Q&A section...

<form id="changeAnswers" action="" method="post">
<fieldset>
<legend>Change Profile Answers</legend>

<?php
echo '<p>TEST: ' . $thoughtsArray[4]['answerText'] . '</p>';

foreach($thoughtsArray as $questionNo => $qaArray) {
echo '<label for="question' . $questionNo . '">' . $questionNo . '.) ' . $qaArray['questionText'] . '</label>';
echo '<textarea id="question' . $questionNo . '" name="thoughtsArray[' . $questionNo . '][\'answerText\']" cols="60" rows="2">' .
(isset($questionNo]) ? "htmlentities($thoughtsArray[$questionNo]['answerText'], ENT_QUOTES" : '') .
'</textarea>';
}
?>



I am able to retrieve and display the Questions from my multi-dimensional array as seen above, however, for the life of me, I cannot get the Input Fields (with any Answers) to work properly.  I either get compile errors, or the code runs but my Input Fields are blank even when an Answer should be displayed?!

 

I am hoping this is just a syntax and/or reference error.  I'm still new to arrays, so properly retrieving an Answer from a multi-dimensional array is really tricky for me!!

So close and yet so far away?!

Can someone please help me out??

Thanks,


Debbie

I have whiled my way through any number of forums and help pages so far. However, since I am not quite comfortable yet with PHP, I am not sure which option I have been given would be the right one.

What I am trying to do:  Create the source for a set of drop-down menus. The dropdown menu has columns, and then a H2 and P that go in each column, in varied numbers, so you have
column1, h2 p; h2 p; h2 p
column2, h2 p; h2 p
etc....make sense? I am using an MySQL table as source so I can have a little CMS dashboard where I can change these and other values on the fly.

So I have a MySQL table where I have a field that identifies the column (page name), and then values to fill the h2 and p tags. I.E.:
page_name, content_title, content_text

The idea, therefore, is to use PHP to figure out what the column names (that are repeated) in the mysql table and then create the dropdown based on the value in the subsidiary fields. Output is as a string in a variable value that is output via return ();

My best estimation of how to do this is to use php to create a multidimensional array from the query result, where the first column is the page_name, followed by an array, the array being the remainder of the information.

Based on information scrounged from other sources, I have come up with this so far:


$query = "SELECT * FROM tbl_mainmenu WHERE mainmenu_type = '$mmtype'"; // what the query is
$result = mysql_query ($query, $dbc); // connect to database and run query, setting the the result to dummy array variable '$result'

// establish the multidimensional array

$mmcontent_array = array ();

//create the array where the values are content page and associated values in an array per each content page

while ($result = mysql_fetch_assoc ())

{

$page_name = $result['content_page'];

$mmcontent_array['content_page'] = $result;

}

foreach ($mmContent_array[] as $key=>$value)

{

foreach ()

{

$tmpelements[] = '<div class="col_2"><h2>' . $element[content_title] . "</h2>\n<p>" . $element[content_text] . "</p>\n</div>";

$elements = implode("\n",$tmpelements) . "\n"

}

$tmp[] = '<li><a href="#" class="drop">Products</a><!-- Begin Products Item -->\n<div class="dropdown_2columns"><!-- Begin 2 columns container -->' . $elements . 'whatever tags will close this')

}


Am I even in the ballpark?

I am not sure which way to nest the foreach ()'s. The example I was working from used echo ()'s, and I am not sure if using $variable = implode () makes the task different.

As a start, I am just wondering if I am creating the multidimensional array correctly?

Hi all,

I wonder if anyone can give me some idea; I have a form with a drop down menu [BT,Virgin, None, Other] - When user select either [BT, Virgin,None] the textarea field will be disable. But when user select option [Other] the textarea will be available.

How can I do this?


..
..
<tr align="left" valign="top" <?php if ($_POST['action'] == "register") { if ($errornum[16] == "1") { echo 'class="error"'; } } ?>>

<td>Who is your previous Internet Service Provider?</td>

<td align="left">

<select name="oldprovider">

<option value="<?php echo $prev_supplier;?>" <?php if ($_POST['action'] == "register") { if ($_POST['oldprovider'] == "") { echo "selected"; } } ?>>

Select Provider.....

</option><?php $prev_supplier="BT";?>
                                                  

<option value="<?php echo $prev_supplier;?>" <?php if ($_POST['action'] == "register"){ if ($_POST['oldprovider'] == 

"$prev_supplier") { echo "selected"; } } ?>>

<?php echo $prev_supplier;?>

</option><?php $prev_supplier="Virgin";?>
                                                  

<option value="<?php echo $prev_supplier;?>" <?php if ($_POST['action'] == "register") { if ($_POST['oldprovider'] == 

"$prev_supplier") { echo "selected"; } } ?>><?php echo $prev_supplier;?>

</option><?php $prev_supplier="None";?>
                                                  

  

<option value="<?php echo $prev_supplier;?>" <?php if ($_POST['action'] == "register") { if ($_POST['oldprovider'] == 

"$prev_supplier") { echo "selected"; } } ?>><?php echo $prev_supplier;?>

</option><?php $prev_supplier="Other";?>

            <option value="<?php echo $prev_supplier;?>" <?php if ($_POST['action'] == "register") { if ($_POST['oldprovider'] == 

"$prev_supplier") { echo "selected"; } } ?>><?php echo $prev_supplier;?>

</option>

</select>
<br /><br />
        <textarea name="oldprovider_text" cols="30" rows="2"> 

<?php if ($_POST['action'] == "register") { echo $_POST['oldprovider_text']; } ?>

</textarea></td>

</tr>


Thanks in advance.