Submit the result of a query to the second form with no click

[huseyin]

Hello,

I have two forms written mainly in php. Here how it functions currently:

- First form has two submit buttons.
- First submit button is a search button that submits a value of an input field that activates a database query and get the result
- I control the length of the entered text with Java Script in the input field and activate the query without clicking the search button when a certain length is achieved
- second submit button submits the result to the second form as an input field on the same page.

Now, what I would like to do is the following:

- Just send the result of the query to the second form without clicking the second submit button in the first form.

So:
- Control the length of the text entered in the input field (which I already do with Javascript)
- When the length equals to certain value activate the database query (which I already do with php)
- When the result is found submit the result to the second form without clicking any other buttons (which I don't know how to do)

I know it might be better to include some bit of code but even I tried to clean it is still too long to include here.

I would appreciate any hint.

huseyin

[hsriat]

Hello,

I have two forms written mainly in php. Here how it functions currently:

- First form has two submit buttons.
- First submit button is a search button that submits a value of an input field that activates a database query and get the result
- I control the length of the entered text with Java Script in the input field and activate the query without clicking the search button when a certain length is achieved
- second submit button submits the result to the second form as an input field on the same page.

Now, what I would like to do is the following:

- Just send the result of the query to the second form without clicking the second submit button in the first form.

So:
- Control the length of the text entered in the input field (which I already do with Javascript)
- When the length equals to certain value activate the database query (which I already do with php)
- When the result is found submit the result to the second form without clicking any other buttons (which I don't know how to do)

I know it might be better to include some bit of code but even I tried to clean it is still too long to include here.

I would appreciate any hint.

huseyin

Its a unique case. Post you code here.

[acoder]

Now, what I would like to do is the following:

- Just send the result of the query to the second form without clicking the second submit button in the first form.

If you can send the result to the first form, the second form should be easy. Get the response from the Ajax script and set the field(s) in the second form instead of the first.

[huseyin]

Thanks for replies. One thing is that I am not using Ajax even, I never attempted to use it. I have to use php+javascript at the moment unless you really insist that Ajax is the only solution :) In that case I have to learn yet another tool.

I will clean the code and post it here a.s.a.p.

huseyin

[huseyin]

I think I managed to clean the code a little bit and made it readable. I hope I didn't remove an important part by mistake :)

I have added some comment lines to make it somewhat more clear.

Once more, thanks for the help.

Here is the listing:

<script type="text/javascript">
// check the number of digits entered in the search box
function check()
{
  var letters = document.additem.item_search.value.length +1;
  if (letters <= 6){
    document.additem.item_search.focus();
  } else {
    document.additem.submit();
    document.additem.addName.focus();
  }
}
function check1()
{
  document.additem.addName.focus();
}
function check2()
{
  document.additem.addName.submit();
}
function formSubmit()
{
  document.additem.addName.submit();
}
function redirectOutput(add_name) {
  var w = window.open('about:blank','Popup_Window','toolbar=no,location=no,directories=no,status=no,menubar=no,sc rollbars=no,resizable=no,copyhistory=no,width=700,height=550,top=20,left=500');
  document.add_name.target = 'Popup_Window';
  return true;
}
</Script>
</head>
<body>
<?php
  if(isset($_POST['addName'])){
    $items_to_add=array();
    $items_to_add=$_POST['id'];
    $name_to_add=$_POST['name'];
    $quantity_to_add=$_POST['quantity'];
 
    for($k=0;$k<count($items_to_add);$k++){
      $_SESSION['items_in'][]=$items_to_add[$k].' '.$name_to_add . ' ' . $quantity_to_add;
    }
  }
// posts to itself (this files name is additem.php)
  echo "<form name='additem' method='POST' action='additem.php' onSubmit='formSubmit()'>
     <table>
     <tr>
     <td>";
// If something is entered in the search box do the search
// This search is activated either by clicking the 'Go' button
// or by pushing enter or when the entered character size equals to 6
  if(isset($_POST['item_search'])  and $_POST['item_search']!=''){
    $search=$_POST['item_search'];
    $query="SELECT something FROM somewhere WHERE condition";
  }
 
  $result=mysql_query($query,$dbf_osc->conn) or die(mysql_error());
  $num_rows = mysql_num_rows($result);
//This is the Search box and Go button
  echo "<td>
    <input type='text' id='item_search' name='item_search' MAXLENGTH='6' onKeyUp='(check() && check1())'>
    <input type='submit' value='Go' id='item_go' name='item_go'></td>";
  echo "<td><select name='items[]' size='1'>\n";
 
// If there is only one result add it automatically to the second form
// (this is where I exactly fail)
// Otherwise show the found items as a select box
  if($num_rows==1){
    $row=mysql_fetch_assoc($result);
    $id=$row['id'];
    $name=$row['name'];
    $option_value=$id . ' ' . $name;
    $display_item="$row[name]";
    echo "<option selected value='".$option_value."'>".$display_item."</option>\n";
// I thought this would do, but doesn't
    echo "<script type=\"text/javascript\">
      document.additem.addName.submit();
          </Script>";
  }
  } else {
    while($row=mysql_fetch_assoc($item_result)){
      $id=$row['id'];
      $name=$row['name'];
      $option_value=$id . ' ' . $name;
      $display_item="$row[name]";
      echo "<option value='".$option_value."'>".$display_item."</option>\n";
    }
  }
  echo "</select></td>";
// This is the addname submit button
// which submits the result of the search to the second form
  echo"
    <td><input type='submit' value='Add Name' id='addName' name='addName'></td>
    </tr>
    </table></form><br>
    <script language=\"JavaScript\">
    document.forms[0].elements[1].focus();
      </script>";
// Check if anything added to the second form
// if so show the items
  if(empty($_SESSION['items_in'])){
    echo "<center><h3>&nbsp;</h3></center>";
  }
 
  if(isset($_SESSION['items_in'])){
    $num_items=count($_SESSION['items_in']);
    $temp_item_name='';
    $temp_item_id='';
    $item_info=array();
 
// The second form is used to add some details about the search result
// i.e. I search for a name with a given number and in this form
// I add some quantity next to the name then generate a list of names
// Finally i submit the generated list to the next screen
    echo "<form name='add_name' action='list.php' method='POST' onSubmit='redirectOutput(this)'>
    ";
    echo "<table>
      <tr>
      <th>Id</th>
      <th>Name</th>
      <th>Quantity</th>
      </tr>";
// In fact at this point I get the Id from the previous form and
// perform another search with the Id and pull the quantity from the database
// if it is set earlier. To keep it short I skipped that query part
      for($k=0;$k<$num_items;$k++){
        $item_info=explode(' ',$_SESSION['items_in'][$k]);
        $temp_id=$item_info[0];
        $temp_name=$item_info[1];
        $temp_quantity=$item_info[2];
        echo "<tr>
          <td>$temp_id</td>
          <td>$temp_name</td>
          <td><input type=text name='quantity$k' value='$temp_quantity' size='3'></td>
          </tr>
          <input type='hidden' name='item_id[$k]' value='$temp_id'>
          <input type=hidden name='name[$k]' value='$temp_name'>
          <input type=hidden name='quantity[$k]' value='$temp_quantity'>";
      }
  }
 
  echo "</table>";
// The following submit gets the generated list and submits to the next screen
  echo "<table>
    <tr>
    <td><input type='submit' name='AddNames' id='AddNames' value='List'>
    </td>
    </form>
    </tr>
    </table>";
}
$dbf->closeDBlink();
?>
    </body>
    </html>
 

[hsriat]

You need to redesign the algorithm.

Use something like this:

<?php
//FILE NAME : additem.php
 
if (submit_of_form1_pressed)
{
    get_the_search_from_the_db();
    if (only_one_record present) 
    {
        display_the_result_for_that_one_record();
        OR
        redirect_to_the_second_form_action();
        //eg..
        header("Location:abc.php?q=aaa");
    }
    else
    {
        display_the_second_form();
    }
elseif (submit_of_form2_pressed)
{
    display_the_results_of_second_form();
    OR
    redirect_to_the_second_form_action();
    //eg..
    header("Location:abc.php?q=aaa");
}
else
{
    display_the_first_form();
}
?>

But I'll still recommend to use Ajax to make it better.