Form to submit, but also display data?

**johny10151981** · Aug 25 '10, 06:44 PM

You can do it in several ways.

The best way i propose is

index.php

Code:

<?php
if(isset($_GET['submit'])==false)
{
 $id="";
 $name="";
 $age="";
 exit;
}
 $name=$_GET['name'];
 $age=$_GET['age']; 
 // mysql queries start 
 $id=from mysql query....
 // mysql queries end
 
 include_once('index_gui.php');
?>

index_gui.php

Code:

<form action="index.php" method=POST>
<span><?php echo $id;?></span>
<input name="name" value='<?php echo $name;?>'>
<input name="age" value='<?php echo $age;?>'>
<input type=submit name="submit" value='Submit'>
</form>

Try this way.....

**ChrisPintys** · Aug 25 '10, 08:27 PM

Thanks a lot for the reply.

If I'm understanding it correctly, you have a page with 2 input controls on it, if it's the first load of the page, all values are empty, but if submit had been hit, then it queries the database to populate the controls, correct?

I wish I had asked this before programming most of the App.

I have it setup like this:

Code:

<?php 
echo'<select name="TSH1">';
echo'<option value=""></option>'; 
$conn1 = odbc_connect('daisy','chrisbwamp',''); 
if ($conn1) 
{ 
  $query1 = "SELECT DESCRIPTION, HIERARCHY1 FROM TRADE_SPEND_HIER1"; 
  $result1=odbc_exec($conn1, $query1); 
  while(odbc_fetch_row($result1))
  { 
  $DESCRIPTION1=odbc_result($result1,"DESCRIPTION");
  $HIERARCHY1=odbc_result($result1,"HIERARCHY1");   
  echo'<option value="'.$HIERARCHY1.'">'.$DESCRIPTION1.'</option>'; 
  } 
  }
	echo "</select>";
	odbc_close($conn1);
?>

So each control is doing it's own query, it's not all done upfront, and then variables used (as it probably should be).

Sounds like I need to do this query (and all others) at the beginning, and put it into an array or two, and then call the array rather then perform the whole query at each control.

Either that, or have a variable set to true or false (for being submitted) and put an if statement and on each control.

Also, mine is setup, so that POST goes to an "upload.php " file that stores the data they entered into a database. If they hit submit and it goes to upload.php, how should I go about redirecting them back to the main page?

for example:

index.php:

They select "display" and type in a WebID and hit submit, it then goes to upload.php which does a check, sees that display was selected, and redirects back to index.php passing on the WebID variable

Thanks a TON for reading this, and for helping the first time around.

**ChrisPintys** · Aug 25 '10, 08:41 PM

Looking around a bit more, it looks like another option may be to have a section in my page that queries my database (when the user selects "Display") based on the WebID, stores them each in variables, and then sets all the controls at once using Javascript, any thoughts on this as well?

**johny10151981** · Aug 26 '10, 02:14 AM

You can do this.

So far what ever you did.

Keep your upload page as it is.

Now made few change at submit page.

Try to submit data using ajax you can call the upload.php. After processing upload.php will send you back a xml file which will include uploaded data.

Try this.

**ChrisPintys** · Aug 26 '10, 02:57 PM

Thanks for the reply, but I'm not sure I quite understand what your saying.

I'm very new to HTML/Javascript/PHP ... like 2 weeks new lol.

Your saying that I should let it POST to upload.php, then once there, save the data to an XML file, then redirect (how?) back to the main page, and load the values from xml (also not sure how?).

Thanks again for taking the time to reply.

**ChrisPintys** · Aug 27 '10, 02:02 PM

Anyone have any ideas?

I'm at a bit of a loss here.

If I click any button on the page, it's going to go to upload.php, which is fine, I can do queries and get the data I need to display in variables there, but how do I redirect the user back to the previous page, and get the variables available there, and then set the elements to those variables.

I don't need an answer, just an idea of what method to use.

Thanks.

**TheServant** · Aug 27 '10, 10:14 PM

I suggest looking into header redirect:

So if you form is on index.php and it submits to process.php, you can put:

Code:

header("Location: index.php");

which will start delivering that page instead. The catch is, header() can only be used if NO output has been sent. As in, no echo's or print's, and definitely no HTML. If process.php works how it should all it does is process stuff, it doesn't output stuff.

No the next question is how to give success/fail messages. Glad you asked. This is where you should use $_GET variables. Put this in your process.php:

Code:

if ($success) {
    $gets = "?success=true";
} else {
    $gets = "?success=false";
}

and then change your header() in your process.php to:

Code:

header("Location: index.php$gets"); // returns a URL like: http://domain.com/index.php?success=true

And then finally in your index file put this at the top:

Code:

if ($_GET['success']) {
    $message = "SUCCESS!!!";
} else {
    $message = "FAIL :(";
}

And then in your index's HTML in a nice location:

Code:

<p class="message"><?php echo $message; ?></p>

That might need some minor debugging, but you get the idea ;)

Form to submit, but also display data?

Form to submit, but also display data?

Comment

Comment

Comment

Comment

Comment

Comment

Comment