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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to use functions on forms 2

Status
Not open for further replies.
hos2

hos2

Programmer
Joined
May 6, 2002
Messages
418
Location
NL
I have a form which uses the sqlaction.php3 when submitted. I was now wondering if I could not incorporate it as a function and that after finishing the function the same page is reloaded where it was submitted on ??

Is it possible/recommend to use functions instead of files to execute ?? or has it disadvantages ??
 
Sort by date Sort by votes
hmmm I had it for now with the function in the form. I just investigated the method I tried to use before but didn't work. I got it workin now. OK I won't win the beaty contest with it but it has te be finished by tomorrow


here is the last bit of code of the sqlaction file where I submit to for those who are interested. (the rest is above in this topic with a slight change of the insert statment
Code: 
	$query="INSERT INTO " . $tablearray[$tablekey] . " SET ". $fieldlines;
	$rs=mysql_query($query,$conn);	
	$keyvalue=mysql_insert_id();
)

Code: 
?>
<HTML>
<HEAD>
<TITLE>Record updated</TITLE>
<META HTTP-EQUIV=&quot;Pragma&quot; CONTENT=&quot;no-cache&quot;>
<script language=&quot;javascript&quot;>
function move(url)
{
window.location.replace(url);
}
move('<? 
if ($tablekey == 'orid') {echo &quot;orform.php3?orid=$keyvalue&quot;;}
if ($tablekey == 'arid') {echo &quot;arform.php3?arid=$keyvalue&quot;;}
if ($tablekey == 'clid') {echo &quot;clform.php3?clid=$keyvalue&quot;;}
if ($tablekey == 'orlid') {echo &quot;orlineform.php3?orlid=$keyvalue&quot;;}
if ($tablekey == 'cltid') {echo &quot;cltform.php3?cltid=$keyvalue&quot;;}

?>');
</script>
</head>
</html>&quot;);
<?
mysql_close($conn);
?>

 
Upvote 0 Downvote
and because it's almost christmas I give some stars for you're patience and the fact that I know now that I'm stupid instead of php ;)
 
Upvote 0 Downvote
Instead of this:
Code: 
move('<? 
if ($tablekey == 'orid') {echo &quot;orform.php3?orid=$keyvalue&quot;;}
if ($tablekey == 'arid') {echo &quot;arform.php3?arid=$keyvalue&quot;;}
if ($tablekey == 'clid') {echo &quot;clform.php3?clid=$keyvalue&quot;;}
if ($tablekey == 'orlid') {echo &quot;orlineform.php3?orlid=$keyvalue&quot;;}
if ($tablekey == 'cltid') {echo &quot;cltform.php3?cltid=$keyvalue&quot;;}
?>');

Do this:
Code: 
move('orform.php3?<?= $tablekey ?>=<?= $keyvalue?>');

Take Care,
Mike
 
Upvote 0 Downvote
also an idea but now I can also define myself where it's going to after adding an orderline I can now directly go back to the order
like
Code: 
if ($tablekey == 'orlid') {echo &quot;orform.php3?orid=$orlorid&quot;;}

when I added a new orderline. In you're example that's not possible


 
Upvote 0 Downvote
ah! I didn't notice that you were posting to different pages.

I don't know if you want do the following:
1) Combine all the different pages you post to into one page.
2) Differentiate between the type of form posted using the switch() statement.

Just an idea, don't know if that will work for you.

Take Care,
Mike
 
Upvote 0 Downvote
perhaps later on I will look at that. but this is just a small ordersystem for a bookingsagency. I first made the above handling form which saves me a lot of time. when I have to add a new field I only have to add it in mysql and to the form and that's all. the submitscript will take care of it automaticaly. I only had the problem that it staid at the submit form when finished

but like now you can also have the fuzzy logic that you want to jump back to an other form (after editing or adding a new orderline). for tonight I have succeeded in doing so
 
Upvote 0 Downvote
Cool :) glad its working now :)

Merry Christmas!

Take Care,
Mike
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

R
  • Locked
  • Question Question
How Can I Use MySQL To Send Data To An Email
Replies
1
Views
859
Chris Miller
Chris Miller
W
  • Locked
  • Question Question
how to send checked row data in php
Replies
0
Views
607
wiltang2004
W
P
  • Locked
  • Question Question
JPgraph - How to stop a line graph from dropping to zero?
Replies
2
Views
937
Chris Miller
Chris Miller
rogerte
  • Locked
  • Question Question
How to parse associative array
Replies
13
Views
3K
Chris Miller
Chris Miller
EdLentz
  • Locked
  • Question Question
I need a simple example of how to send a table of info .
Replies
8
Views
1K
EdLentz
EdLentz

Part and Inventory Search

Sponsor

Back
Top