Multiple Submit Buttons

reub77

I've been reading and trying code from similiar problems that have been posted but so far nothing has worked out. What I have is an email tool that will, when submitted, send out an email to people. I want to add a feature that will save drafts of emails before they are sent out.

This requires me to create an additional submit button called save draft. I was thinking I would send them both to the same page and test to see which submit button was clicked and then with all the info passed either send the email or save the email.

If it's saved it will display that the email was saved and the it will return to a page that has all the if no filled out still in the form.

So far I've been successful at identifying which button has been clicked but all my form elements aren't being passed.

I'll show you the first page that passes the form elements to an additional page:

 
<form name="submitform" action="tool_broadcast_email2.php">
        <tr>
          <td>
           <select name="send2Menu">
             <option value="all">Whole Group</option>
<?PHP
$conn = db_connect(); 

//declare query
$query = "SELECT DISTINCT city FROM demographics WHERE country LIKE 'Canada' ORDER BY city";

//execute query
$result = mysql_query($query);
$x = 0;
while ($x < mysql_num_rows($result)) :
   $City = mysql_result($result, $x, 'city');    

   $x++;
endwhile; 
print "<option value='Alberta'>Alberta</option>
          <option value='British Columbia'>British Columbia</option>
          <option value='Manitoba'>Manitoba</option>
          <option value='New Brunswick'>New Brunswick</option>
          <option value='Newfoundland'>Newfoundland</option>
          <option value='Northwest Territories'>Northwest Territories</option>
          <option value='Nova Scotia'>Nova Scotia</option>
          <option value='Nunavut'>Nunavut</option>
          <option value='Ontario'>Ontario</option>
          <option value='Prince Edward Island'>Prince Edward Island</option>
          <option value='Quebec'>Quebec</option>
          <option value='Saskatchewan'>Saskatchewan</option> 
          <option value='Yukon Territories'>Yukon Territories</option> 
          <option value=''>=====================</option>
          <option value='Canada'>Canada</option>
          <option value='England'>England</option>
          <option value='United States'>United States</option>
          <option value=''>=====================</option>
          <option value='Active'>Active</option>
          <option value='Associate'>Associate</option>
          <option value='Honorary'>Honorary</option>
          <option value='Institution'>Institution</option>
          <option value='Life'>Life</option>
          <option value='Student'>Student</option>
        </select><br><br>
    </td></tr>";

print "<tr>
            <td  valign='top' width='80%'>Subject</td>
          </tr>
          <tr>
            <td>
              <textarea name='Subject' cols='50' rows='1' wrap='VIRTUAL'></textarea>
            <br><br></td>
         </tr>";

print "<tr>
            <td valign='top'>Body</td>
          </tr>
          <tr>
            <td>
            <textarea name='Body' cols='100' rows='30' wrap='VIRTUAL'></textarea>
            <br><br></td>
          </tr>";

print "<tr>
            <td>
              <input type='submit' name='Submit' value='Send E-mail'>&nbsp;
              <input type='submit' name='Save' value='Save Draft'>&nbsp;
              <input type='reset' name='Reset' value='New'>";
?>

lazzerous

dood, you're gonna have to break up and organize your code a little better before anyone will be willing to read this post....

reub77

Sorry how's that?

lazzerous

I'm pretty confused here man...

You have a loop that just assigns a different value to $City everytime it goes through, and then you manuappy print out the results that should be generated dynamically from the query...

let's clean this up a little bit more...
we really don't need all those table statements...
also, code notations should mroe describe the process than define PHP functions

<form name="submitform" action="tool_broadcast_email2.php">
<select name="send2Menu">
  <option value="all">Whole Group</option>

<?PHP
$conn = db_connect();

//pull canadian cities from the demographics table
$query = "SELECT DISTINCT city FROM demographics WHERE country='Canada' ORDER BY city";

// output select options from given DB results
// also populate the $City array with the data as well
$result = mysql_query($query);
$City = array();

while ($row=mysql_fetch_array($result))
    {
    $City[] = $row[city];
    print "<option value='$row[city]'>$row[city]</option>\n";
    }

print "<option value=''>=====================</option>
          <option value='Canada'>Canada</option>
          <option value='England'>England</option>
          <option value='United States'>United States</option>
          <option value=''>=====================</option>
          <option value='Active'>Active</option>
          <option value='Associate'>Associate</option>
          <option value='Honorary'>Honorary</option>
          <option value='Institution'>Institution</option>
          <option value='Life'>Life</option>
          <option value='Student'>Student</option>
        </select>\n";

print "<textarea name='Subject' cols='50' rows='1' wrap='VIRTUAL'></textarea>\n";

print "<textarea name='Body' cols='100' rows='30' wrap='VIRTUAL'></textarea>\n";

print "<input type='submit' name='Submit' value='Send E-mail'>\n";
print "<input type='submit' name='Submit' value='Save Draft'>\n";
print "<input type='reset' name='Reset' value='New'>\n";
?>

now, in the next script, are you making sure you are calling the variables correctly?

$City and $city are considered two different variables in PHP - everything is CaSe SeNsItIvE

as for determining what submit button they pressed:

// notice that I changed both submit buttons to be named 'Submit'
if (isset($Submit) && $Submit == "Send E-mail")
    {
    // code for sending email
    }
elseif (isset($Submit) && $Submit == "Save Draft")
    {
    // code for Draft Saving
    }


// if you end up having more than two submit buttons, you could go this route:

switch ($Submit)
    {
    case "Send E-mail":
        // code for sending email
        break;
    case "Save Draft":
        // case for Saving Draft
        break;
    }

lemme know if any of this hits the nail on the head...

-=Lazz=-

reub77

Sort kinda, not really.

I gave you the form on the page. You are missing a big chunk of code and so I can see why you thought a lot of it was unessesary. However I only really wanted the button dilemna solved. Before I added the second button everything did exactly what it needed to do. Now I need the option to save the draft. Not always though, just when they press the button. If they choose to save the email it will write to the database in another page I have. The problem is with the two button system I have layed out for you the only thing getting passed is the button variables (Submit or savedraft). Nothing else is being passed anymore as I have print statements for testing purposes on the other page printing them onto the screen if they are passed properly and they aren't printing. They were before I added the second button. Is there a trick to using two submit buttons with different names to trigger different actions on another page? I've read over some other suggestions with people who had similar problems but nothing worked.

Percadan

Not sure if you solved his problem, but you solved mine.
Thanks!

mtimdog

First, is that the entire code from the first page? I don't see a </form> so I'm a little curious. Also, could you post the second page as well, so I can see exactly what you're echoing out.