SELECT into TEXTAREA

Question

jackakos 0 Junior Poster in Training

15 Years Ago

I am retrieving a list from my sql db into a select option box which works fine. The other part of the script should enable a selected name to be printed into a textarea, however this bit is giving a headache. Hope someone could be of help.

<HTML>
 <HEAD>
 <TITLE>List of Employees</TITLE>
 <h1><center><img src="images/slim.gif" width="543" height="72"></p></h1>
 </HEAD>
 <BODY>

<?php
session_start(); 

   //connect to database
   $conn = mysql_connect("localhost", "", "")
      or die(mysql_error());
   mysql_select_db("me",$conn) or die(mysql_error());

   if ($_POST[op] != "view") {
      //haven't seen the form, so show it
        
     //get parts of records
     $get_list = "select emp_no, concat_ws(', ', lname, fname) as display_name
         from employee order by lname, fname";
     $get_list_res = mysql_query($get_list) or die(mysql_error());

     if (mysql_num_rows($get_list_res) < 1) {
         //no records
         echo "<p><em>Sorry, no records to select!</em></p>";
         
        
 } else {
         //has records, so get results and print in a form
         echo "
         <form method=\"post\" action=\"$_SERVER[PHP_SELF]\">
         <P><strong>List of Employees:</strong><br>
         <select name=\"sel_id\">
         <option value=\"\">— Select Colleagues —</option>";
         
	    
         

         while ($recs = mysql_fetch_array($get_list_res)) {
             $emp_no = $recs['emp_no'];
             $display_name = stripslashes($recs['display_name']);

             echo "<option value=\"$emp_no\">
                  $display_name</option>";
         }

         echo "
         </select>
         <input type=\"hidden\" name=\"op\" value=\"view\">
         <p><input type=\"submit\" name=\"submit\"
             value=\"Add to List\"></p>
         </FORM>";
      }
      
     
  } else if ($_POST[op] == "view") {

      $get_addresses = "select emp_no, fname, lname, dept, position
           from employee where emp_no = $_POST[sel_id]";
      $get_addresses_res = mysql_query($get_addresses);
      
         if (mysql_num_rows($get_addresses_res) > 0) {

          // don't have anything doing
         
          while ($add_info = mysql_fetch_array($get_addresses_res)) {
              $my_id = $add_info[emp_no];
              $my_fname = $add_info[fname];
              $my_lname = $add_info[lname];
              $my_dept = $add_info[dept];
              $my_position = $add_info[position];
			  $emp_list = "$my_id $my_fname $my_lname";
              // echo "$emp_list $my_fname $my_lname";
              
              $emp_array = array ($emp_list);
              $emp_id = array ($my_id);
                         
              // print the emp_array into the text area
              for($x=0; $x<=count($emp_array); $x++)
              {
              	echo "textspace";
              }
          }

         
      }

      }

                
  
?>
<textarea id="employees" name="textspace" cols="50" rows="5"></textarea>
 </BODY>
 </HTML>

php

3 Contributors
10 Replies
142 Views
3 Days Discussion Span
Latest Post 15 Years Ago Latest Post by jackakos

All 10 Replies

Will Gresham 81 Master Poster

15 Years Ago

I had a quick look at your script, the first thing I noticed was that these lines:

//get parts of records
     $get_list = "select emp_no, concat_ws(', ', lname, fname) as display_name
         from employee order by lname, fname";
     $get_list_res = mysql_query($get_list) or die(mysql_error());

were within the IF statement so would not be processed unless the condition is true, move these lines to above the IF statement or re-declare them in the ELSE clause to get this to work.

Will Gresham 81 Master Poster

15 Years Ago

At another look, your $_POST values are incorrect, it should be $_POST['value'] not $_POST[value] so this line:

$get_addresses = "select emp_no, fname, lname, dept, position
           from employee where emp_no = $_POST[sel_id]";

should be:

$get_addresses = "select emp_no, fname, lname, dept, position
           from employee where emp_no = " . $_POST['sel_id'] . "";

Will Gresham 81 Master Poster

15 Years Ago

<textarea id="employees" name="textspace" cols="50" rows="5"></textarea>

If you mean this one, then it would be something like:

<textarea id="employees" name="textspace" cols="50" rows="5"><?=$my_fname?></textarea>

Assuming you want the $my_fname value in the box.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

jackakos 0 Junior Poster in Training · Answer 1 · 2008-10-01T07:31:08+00:00

The statment is checking whether a submission was made becuse I am much more interested in whether submission made was the view. I have an else if statement that loads the data in the select option which I am able to see the list. However, the display of the selection into the TEXTAREA is the problem even though it displays what I select it imposes over the select option and therefore I am not able to make another selection to increase the list.

jackakos 0 Junior Poster in Training · Answer 2 · 2008-10-01T07:45:14+00:00

Xan,
Many thanks, that part is working fine now.

Still stuck with printing the option into the teaxarea. I wonder if I should put the textarea in a form or table? though it would have been ideal leaving it as it is.

jackakos 0 Junior Poster in Training · Answer 3 · 2008-10-01T08:13:32+00:00

I have tried the solution in the last post #6 but it doesn't work.

Should the textarea be inserted somewhere within the php script? or the position shouldn't matter?

jackakos 0 Junior Poster in Training · Answer 4 · 2008-10-02T04:15:49+00:00

I have made changes to the script, there has been an improvement - whereby if I click on the 'ADD To LIST' button, the TEXTAREA as well as the page stays put. However, the selected option is printed next to the TEXTAREA.

I am also interested in putting all the list that will be selected and printed into the TEXTAREA into an array that I will refer to further processing.

the new code is found below, i will need your help.

<?php
session_start(); 

   //connect to database
   $conn = mysql_connect("localhost", "", "")
      or die(mysql_error());
   mysql_select_db("me",$conn) or die(mysql_error());
   
   $get_list = "select emp_no, concat_ws(', ', lname, fname) as display_name
         from employee order by lname, fname";
                  
     $get_list_res = mysql_query($get_list) or die(mysql_error());

     if (mysql_num_rows($get_list_res) < 1) {
         //no records
         echo "<p><em>Sorry, no records to select!</em></p>";
         
         } else {
         //has records, so get results and print in a form
         echo "
         <form method=\"post\" action=\"$_SERVER[PHP_SELF]\">
         <P><strong>List of Employees:</strong><br>
         <select name=\"sel_id\">
         <option value=\"\">— Select Colleagues —</option>";
         
	        

         while ($recs = mysql_fetch_array($get_list_res)) {
             $emp_no = $recs['emp_no'];
             $display_name = stripslashes($recs['display_name']);

             echo "<option value=\"$emp_no\">
                  $display_name</option>";
         }
         
          echo "
         </select>
         <input type=\"hidden\" name=\"op\" value=\"view\">
         <p><input type=\"submit\" name=\"submit\"
             value=\"Add to List\"></p>
         </FORM>";
        }
        
      // draw the textarea
      echo "<textarea id='employees' name=\"textspace\" cols=\"40\" rows=\"5\" wrap=\"virtual\">".$textspace."</textarea>";
	  
	  
	  if ($_POST[op] == "view") {

      $get_addresses = "select emp_no, fname, lname, dept, position
           from employee where emp_no = " . $_POST['sel_id'] . "";
      $get_addresses_res = mysql_query($get_addresses);
      
         if (mysql_num_rows($get_addresses_res) > 0) {

          // don't have anything doing
          /**
           * while the employees are being selected put their emp_no into an array
           * which will be used search their free slots
           */

          while ($add_info = mysql_fetch_array($get_addresses_res)) {
              $my_id = $add_info[emp_no];
              $my_fname = $add_info[fname];
              $my_dept = $add_info[dept];
              $my_position = $add_info[position];
              $my_lname = $add_info[lname];
			  $emp_list = "$my_id $my_fname $my_lname";
		     $emp_name = "$my_fname $my_lname";
		     $textspace = $emp_name;
		     echo "$textspace";
            //  echo "$emp_list $my_fname $my_lname";
            
            
              
              $emp_array = array($emp_list);
              $emp_id = array ($my_id);
              
              //print ("<textarea id=\"employees\" name=\"textspace\" cols=\"50\" rows=\"5\">.$emp_name</textarea>");
                         
            // print the emp_array into the text area
              for($x=0; $x<=count($emp_array); $x++)
              {
              	  $employees = $emp_name;
				  //echo "emps.employees.value='$employees'";
              }
          }

         
      }

      }
?>

jackakos 0 Junior Poster in Training · Answer 5 · 2008-10-02T18:57:42+00:00

Would somebody be kind enough to point out what to do to get the selected option to display in the TEXTAREA?

R0bb0b 344 Posting Shark · Answer 6 · 2008-10-02T20:37:49+00:00

Would somebody be kind enough to point out what to do to get the selected option to display in the TEXTAREA?

in between the opening and closing textarea tags include this line of code

<? echo isset($_POST['sel_id'])?$_POST['sel_id']:""; ?>

jackakos 0 Junior Poster in Training · Answer 7 · 2008-10-04T03:02:00+00:00

The statements are already in php tags so I had to take out the <? ?> with the answer you gave. It gave a an error and I had tried debugging but now the error jumps to the next code instead. So I have inserted what I you had wanted done into the code. may be you can take a look and figure out the syntax.

echo "<textarea id=\"employees\" name=\"textspace\" cols=\"40\" rows=\"5\" wrap=\"virtual\"><? echo isset($_POST['sel_id'])?$_POST['sel_id']:""; ?></textarea>";
	echo "<input type=\"reset\" name=\"clear\" value=\"Reset\">";
	echo "     ";
	echo "<input type=\"submit\" name=\"myfix\" value=\"Next Step\">";

SELECT into TEXTAREA

Recommended Answers Collapse Answers

All 10 Replies

Recommended Answers