DaniWeb Forum Index > Web Development > PHP

One form, two actions

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jul 2009

Posts: 220

Reputation: CFROG is an unknown quantity at this point

Solved Threads: 14

CFROG

Offline

Posting Whiz in Training

One form, two actions

Aug 5th, 2009

I'm working a very simple script for an email (messaging) between users. I have a form with two buttons that gives you the option to save message as a draft or just send it to the user.

Here are the two buttons on form:

 Help with Code Tags 
 html Syntax (Toggle Plain Text) 
<input type="submit" name="save" id="save" value="Save as Draft" />
<input type="submit" name="send" id="send" value="Send" />
<input type="submit" name="save" id="save" value="Save as Draft" />
<input type="submit" name="send" id="send" value="Send" />

Here is how I'm trying to differentiate between form actions.

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
if(isset($_POST['save']) && trim($_POST["save"])!==''){
	mysql_query("UPDATE mailbox SET 
		member_id='$_SESSION[user_id]',
		message='$message',
		draft='DRAFT',
		subject='$subject',
		date='$dsub' 
		WHERE id='$draftid'");
	header('Location: mailbox.php');
 
}elseif(isset($_POST['send']) && trim($_POST["send"])!==''){
	$send="INSERT INTO mailbox SET
		member_id='$memid',
		user_name='$$_SESSION[user_name]',
		user_id='$_SESSION[user_id]',
		message='$message',
		inbox='NEW',
		subject='$subject',
		date='$dsub' " ;
	$save_result=mysql_query($save);
header('Location: mailbox.php');
 
		// update draft to sent
	mysql_query("UPDATE mailbox SET
		draft='',
		sent='SENT'
		WHERE id='draftid'");}
 
	header('Location: mailbox.php');
if(isset($_POST['save']) && trim($_POST["save"])!==''){
	mysql_query("UPDATE mailbox SET 
		member_id='$_SESSION[user_id]',
		message='$message',
		draft='DRAFT',
		subject='$subject',
		date='$dsub' 
		WHERE id='$draftid'");
	header('Location: mailbox.php');

}elseif(isset($_POST['send']) && trim($_POST["send"])!==''){
	$send="INSERT INTO mailbox SET
		member_id='$memid',
		user_name='$$_SESSION[user_name]',
		user_id='$_SESSION[user_id]',
		message='$message',
		inbox='NEW',
		subject='$subject',
		date='$dsub' " ;
	$save_result=mysql_query($save);
header('Location: mailbox.php');

		// update draft to sent
	mysql_query("UPDATE mailbox SET
		draft='',
		sent='SENT'
		WHERE id='draftid'");}
	
	header('Location: mailbox.php');

Save works just fine, but in the event I try to send it disregards the Save as I would expect it to, but it also disregards the rest of the script and just executes the header. Not quite sure what I'm doing wrong here. Any ideas would be greatly appreciated.

•

Join Date: Nov 2007

Posts: 3

Reputation: elreso is an unknown quantity at this point

Solved Threads: 1

elreso

Offline

Newbie Poster

Re: One form, two actions

Aug 6th, 2009

Help with Code Tags

html Syntax (Toggle Plain Text)

$send="INSERT INTO mailbox SET
	member_id='$memid',
	user_name='$$_SESSION[user_name]',
	user_id='$_SESSION[user_id]',
	message='$message',
	inbox='NEW',
	subject='$subject',
	date='$dsub' " ;
$save_result=mysql_query($save);
 
// update draft to sent
mysql_query("UPDATE mailbox SET
	draft='',
	sent='SENT'
	WHERE id='draftid'");
 
header('Location: mailbox.php');

How bout that....
u do insert and update then after that u give the header.......
is it works?

•

Join Date: Aug 2007

Posts: 799

Reputation: darkagn has a spectacular aura about

Solved Threads: 110

darkagn

Offline

Master Poster

Re: One form, two actions

Aug 6th, 2009

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$send="INSERT INTO mailbox SET
   member_id='$memid',
   user_name='$$_SESSION[user_name]',
   user_id='$_SESSION[user_id]',
   message='$message',
   inbox='NEW',
   subject='$subject',
   date='$dsub' " ;
$save_result=mysql_query($save);
$send="INSERT INTO mailbox SET
   member_id='$memid',
   user_name='$$_SESSION[user_name]',
   user_id='$_SESSION[user_id]',
   message='$message',
   inbox='NEW',
   subject='$subject',
   date='$dsub' " ;
$save_result=mysql_query($save);

What is $save? I think you are trying to run the query $send?

There are no stupid questions, only those too stupid to ask for help.
echo is a web developer's best friend.

•

Join Date: Jul 2009

Posts: 220

Reputation: CFROG is an unknown quantity at this point

Solved Threads: 14

CFROG

Offline

Posting Whiz in Training

Re: One form, two actions

Aug 6th, 2009

I did catch the $send and changed it also removed an extra $ from SESSION[user] ... It is sending now, just not updating the 'draft' to a 'sent' mail at the bottom of the script. Still working on it.

•

Join Date: Jul 2009

Posts: 220

Reputation: CFROG is an unknown quantity at this point

Solved Threads: 14

CFROG

Offline

Posting Whiz in Training

Re: One form, two actions

Aug 6th, 2009

I got it ... finally! LOL. I was missing a "$" for my variable 'draftid' ... You stare at this stuff long enough and it's easy to overlook the little things. I almost feel foolish. Thank you guys, Problem Solved!