TOUGH QUESTION-NEED FORM EXPERT

RPGguy · Dec 15, 2003

I suspect this won't be easy. I have a form to enter customers with 10 or so input fields. The form is described as:
<form method=POST action="updCust.html">

and the update button as:
<td><input type="submit" value="Update Customer" name="B1"></td>

This is great in that it automatically passes the fields to my update script. The update script looks like this:
<HTML>
<?php
$query4 = "UPDATE tblCust SET Cust='$cust',Name='$name',Contact='$contact',Address1='$address1',Address2='$address2',City='$city',State='$state',Zip='$zip',Type='$type',Phone='$phone',Fax='$fax',Notes='$notes' where Cust = '$cust'";

$link = mysql_connect("localhost", "***", "*****&quot

;
mysql_select_db("Liebert&quot

;

$result = mysql_query($query4);

<table border="1" cellpadding="3" cellspacing="3" style="border-collapse: collapse" width="325" id="AutoNumber1" height="92" bgcolor="#FFFFFF" bordercolor="#FFFFFF" align="left">

<tr>
<td width="509" height="7" valign="baseline" align="left" bordercolor="#FFFFFF" bgcolor="#FFFFFF" rowspan="2">
<p align="center">Record successfully updated!</p>
<p align="center">
<input type="button" value="Return" name="bReturn" width="30" onClick="self.history.back();">
</td>
</tr>
</table>
?>
</BODY>
</HTML>

Everything works fine except that I would like my update message to appear in a pop up window. I've tried the javascript command to open a pop up window but that stops my update script from receiving the fields as parameters.

If this can't be done can someone suggest an alternate way of accomplishing it. Prehaps I can move the pop up to a new script executed by the update script. I just want to be sure when the user clicks the 'Back' button they return all the way back to the original form.

Thanks in advance.

Scott

Bastien · Dec 15, 2003

since you are using php, place the separate elements into functions and then you have the ability to call functions as you need them.

Code:

if (!$_POST['submit']){

    //the submit button not pressed so show the data form
    show_form();

}else{

    //process the data and run the update
    process_form();

}
function show_form()
{
//html [and php] code to show the form as required

}
function process_form()
{

//php code to accept,[v]verfiy[/b] and update the db


if ($result){  //db query works - does what its supposed to
    show_confirmation();  //call confirmation function
}else{
    show_failure();       //call failure function
}

}
function confirmation()
{
//html code to show a page/pop up that confirms entry success - personally I prefer a full page as you can provide link to show the form again (&quot;update another customer&quot;) or pass the user to somewhere else
}
function show_failure()
{
//html code to show a page/pop up that confirms entry success - personally I prefer a full page as you can provide link to show the form again with the user data filled out [b]to be edited as needed[/b]-->uses the value attribute of the element tag to provide values filled in
}

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!

tweenerz · Dec 16, 2003

If I understand the question correctly, you want the form to submit to a popup window. This can be done by first using the javascript open function to open a blank window, sized to you liking, and linking to "about:blank". Then in the submit tag put in this:

onSubmit="popWindow();" target="window_name"

window_name is then name you gave the window in the javascript function.

The question then remains, what do you want to do with the original form page? Because it will still have the information stored in the form.

RPGguy · Dec 16, 2003

With the current code in the original form:

The form is described as:
<form method=POST action="updCust.html">

and the update button as:
<td><input type="submit" value="Update Customer" name="B1"></td>

the submit passes all my input fields as parameters directly into updCust.html which works great.

I want to preserve this functionality but with updCust.html giving me a message in a pop up window. I've tried using the 'popupwindow()' to use updCust.html and lost all my input values.

Do you think your method will work this way?

Bastien · Dec 16, 2003

Well the problem really is that you have no way to notify the user if something goes wrong...you are simply going to open a pop-up that gives the user a message.

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!

RPGguy · Dec 16, 2003

I agree the error handling has to be addressed. I'm pretty new to all of this (hence the RPG moniker) and I'm trying to get a feel for the functionality.

I can empathize with being laid off. The last 2 years have been shaky for me too.

Bastien · Dec 16, 2003

One note...the action=updateCust.html is never going to work. HTML pages can not interact with the server/db/filesystem in any way shape or form...you are gonna need to direct the page to .php, .asp. etc so that the server know there is a scripting language engine to invoke and make the whole sucker go

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!

Bastien · Dec 16, 2003

One other note, many people now employ pop-up blockers, that may or may not affect the functionality of the site

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

TOUGH QUESTION-NEED FORM EXPERT

RPGguy

Programmer

Bastien

Programmer

tweenerz

Programmer

RPGguy

Programmer

Bastien

Programmer

RPGguy

Programmer

Bastien

Programmer

Bastien

Programmer

Similar threads

Part and Inventory Search

Sponsor