By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,216 Members | 1,013 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,216 IT Pros & Developers. It's quick & easy.

problem with page redirect and data insertion together

P: 45
Hi all,

i m having a problem with inserting data in oracle db.
When i use form action =(call self page) then data is inserting properly.But problem with when using form action=(Another_page).data is not insering into database.For ur kind infromation i m using oracle db and php for my application.

sample code:
Expand|Select|Wrap|Line Numbers
  1. <form action="welcome.php" method="post">
  2. Name: <input type="text" name="name" />
  3. Age: <input type="text" name="age" />
  4. <input type="submit" />
  5. </form>
pls can any one help me.

Thanks
Aug 13 '08 #1
Share this Question
Share on Google+
18 Replies


10K+
P: 13,264
In which page is the code that inserts the values in the database? That's the one you have to call if you want the values to be inserted.
Aug 13 '08 #2

P: 45
hi,
Thanks for reply.

My fisrt page is "test.php" from where i m trying to insert data
After press on submit button form data will store in db and a success massege will show on the "wlcome.php"page.
Expand|Select|Wrap|Line Numbers
  1. <html>
  2. <body><form action="welcome.php" method="post">
  3. Name: <input type="text" name="name" />
  4. Age: <input type="text" name="age" />
  5. <input type="submit" />
  6. </form></body>
  7. </html> 
so pls help me how to divert the page to "wlcome.php" as well as data will insert in to db.

Thanks
Aug 13 '08 #3

10K+
P: 13,264
header ?
Aug 13 '08 #4

P: 45
hi,
Thanks for ur cooperation.

it willbe help for me if u make it clear in my given example for how to use "header"to redirect the page into welcome.php.

thanks again
Aug 13 '08 #5

P: 45
hei,

i need ur help wthh my specified problem previously disscussed.

it's urgent for me so, pls help me.

Thanks
Aug 14 '08 #6

P: 45
Hi all,

i m having a problem with inserting data in oracle db.
When i use form action =(call self page) then data is inserting properly.But problem with when using form action=(Another_page).data is not insering into database.For ur kind infromation i m using oracle db and php for my application.

sample code:

Expand|Select|Wrap|Line Numbers
  1. <form action="welcome.php" method="post">
  2. Name: <input type="text" name="name" />
  3. Age: <input type="text" name="age" />
  4. <input type="submit" />
  5. </form>
the above code not data inserting but page is redirecting.

so how to insert data aswell as redirect the page in welcome.php ?
pls can any one help me.

Thanks
Aug 16 '08 #7

Markus
Expert 5K+
P: 6,050
Show the code you use to insert on welcome.php
Aug 16 '08 #8

samikhan83
P: 33
hi......
1. U R getting some error ...... for page not found.... if yes write the proper action for form...

2. check weather ur getting all ur required data for ur query...... by echoing or printing the data.....

3. check ur query with the database...

4. using PHP_SELF is better than using form action.....

5. if none of the above then paste ur code.....
Aug 16 '08 #9

Atli
Expert 5K+
P: 5,058
4. using PHP_SELF is better than using form action.....
That would depend on what you are attempting to do. What is "better" will always depend on the circumstance.
Not to mention that even if you use PHP_SELF, you are still using the form action ;)

But, to the OP's problem.
Whether or not you are posting the data to the current page or any other page, it shouldn't make the slightest difference. Any decent browser should simply fuse the POST data into the request before sending it.

I would bet the problem would be in your server-side script, the one that is meant to process the data into whatever database you are using.

Show us that code please, and we will do what we can to help you figure out a solution.
Aug 17 '08 #10

Markus
Expert 5K+
P: 6,050
hi......
1. U R getting some error ...... for page not found.... if yes write the proper action for form...

2. check weather ur getting all ur required data for ur query...... by echoing or printing the data.....

3. check ur query with the database...

4. using PHP_SELF is better than using form action.....

5. if none of the above then paste ur code.....
Please review the posting guidelines:
Do not use leet speak or text speak, they are not Clear English
Aug 17 '08 #11

P: 45
hi Atli,

Thank u for ur cooperation.
Here is my code :
Expand|Select|Wrap|Line Numbers
  1. <html>
  2. <head><head>
  3. code:(text)
  4. <? 
  5.  if ($c=ocilogon("aa","bb","ccc"))
  6.     //echo"successfully connected to database.\n";
  7.   ?>
  8.  
  9. <?
  10. $insert="insert into member_tbl(id,name,age) values('".$_POST['id']."','".$_POST['name']."','".$_POST['age']."')";
  11.  
  12.  
  13.     $insertparse=ociparse($c,$insert);
  14.     ociexecute($insertparse);
  15.  
  16. ?>
  17.  
  18. <body>
  19. <form action="welcome.php" method="post" name="t1">
  20.  
  21. Memberid:<input type="text" name="id" />
  22. Name: <input type="text" name="name" />
  23. Age: <input type="text" name="age" />
  24. <input type="submit"name="submit" value="Submit" />
  25.  
  26. </form
  27. </body>
  28. </html>
  29.  
When i prees submit button,link goes to welcome.php page.but data is not inserting.
But if i use <form action="<?=$HTTP_SERVER_VARS['PHP_SELF']?>" NAME="s1" method="post"> then data is inserting properly but link dones not goto the welcome.php page.

Pls provide me a proper solution.

Thanks
Aug 18 '08 #12

Markus
Expert 5K+
P: 6,050
hi Atli,

Thank u for ur cooperation.
Here is my code :
Expand|Select|Wrap|Line Numbers
  1. <html>
  2. <head><head>
  3. code:(text)
  4. <? 
  5.  if ($c=ocilogon("aa","bb","ccc"))
  6.     //echo"successfully connected to database.\n";
  7.   ?>
  8.  
  9. <?
  10. $insert="insert into member_tbl(id,name,age) values('".$_POST['id']."','".$_POST['name']."','".$_POST['age']."')";
  11.  
  12.  
  13.     $insertparse=ociparse($c,$insert);
  14.     ociexecute($insertparse);
  15.  
  16. ?>
  17.  
  18. <body>
  19. <form action="welcome.php" method="post" name="t1">
  20.  
  21. Memberid:<input type="text" name="id" />
  22. Name: <input type="text" name="name" />
  23. Age: <input type="text" name="age" />
  24. <input type="submit"name="submit" value="Submit" />
  25.  
  26. </form
  27. </body>
  28. </html>
  29.  
When i prees submit button,link goes to welcome.php page.but data is not inserting.
But if i use <form action="<?=$HTTP_SERVER_VARS['PHP_SELF']?>" NAME="s1" method="post"> then data is inserting properly but link dones not goto the welcome.php page.

Pls provide me a proper solution.

Thanks
You're not understanding how form submition works; the 'action' attribute of the form is where all the data from the form is sent - in your case 'welcome.php'. What you seem to be thinking is that when the forum is submitted the code on the page with the form is then run - this isn't how it works. You need to relocate the code from your form page to 'welcome.php'.
Furthermore, you could just add in a redirect to your existing code and keep the 'action' attribute as PHP_SELF.

[php]
<?
$insert="insert into member_tbl(id,name,age) values('".$_POST['id']."','".$_POST['name']."','".$_POST['age']."')";


$insertparse=ociparse($c,$insert);
ociexecute($insertparse);

// redirect: no output can come before this
header("Location: /welcome.php");
// you could alternatively output a meta refresh (uncomment to do so)
//echo '<meta http-equiv="refresh" content="2; url=/welcome.php">'

?>
[/php]

hi Atli,

Thank u for ur cooperation.
Here is my code :
Yeh.. you're welcome _
Aug 18 '08 #13

Markus
Expert 5K+
P: 6,050
boss1, it is a forum rule that when you post code you use CODE tags. Here is an example:

[code]
// code goes here
<?php
echo 'using code tags!';
?>
[/code]

Which makes it considerably easier to read!

Expand|Select|Wrap|Line Numbers
  1. // code goes here
  2. <?php
  3. echo 'using code tags!';
  4. ?>
  5.  
Aug 18 '08 #14

pbmods
Expert 5K+
P: 5,821
Boss1, you've already been asked to start using CODE tags (see Markus's previous post for more information).

This message serves as your official warning. Continued violation of the site Posting Guidelines will result in account suspension.

If you have any questions or concerns, feel free to contact me anytime.

Thanks for your time.

pbmods
Aug 18 '08 #15

P: 45
hello,
i m havimg another problem when i use header("Location: welcome.php"); i get this massege is in below:

You don't have permission to access /new/="/new/welcome.php" on this server.

i have used the directory in httpconf file is:
DirectoryIndex index.php index.html

still the the massege is showing.So now what can i do?

pls help me
Aug 19 '08 #16

Markus
Expert 5K+
P: 6,050
hello,
i m havimg another problem when i use header("Location: welcome.php"); i get this massege is in below:

You don't have permission to access /new/="/new/welcome.php" on this server.

i have used the directory in httpconf file is:
DirectoryIndex index.php index.html

still the the massege is showing.So now what can i do?

pls help me
Please show the code you are using.
My guess is that you aren't setting the uri correctly.
Aug 19 '08 #17

Atli
Expert 5K+
P: 5,058
This is a file permission error. You, or rather the user which your web-server is running on (usually nobody), does not have permission to read the file you are asking for.

You will have to log into the server and change the file permission.

This should work, either in a Linux kernel or through FTP.
Expand|Select|Wrap|Line Numbers
  1. $ chmod 755 /path/to/your/file.ext
  2.  
Aug 19 '08 #18

P: 45
hi,

A new problem is arised.A massege is coming when i use form action="selfpafe"
and redirection is used that is header("Location:/welcome.php");

The massege is:
The requested URL / welcome.php was not found on this server

Note:the previous error massege is not found again.

so what now?..pls..
Aug 19 '08 #19

Post your reply

Sign in to post your reply or Sign up for a free account.