Posting to same php page

Jon12345

Can you have a php page with a form on it that when you click Submit, it runs some code but that code is on the same page rather than having

Frederick

Yes you can.

<?php
if (isset($_POST["buttonName"])) {
     // form processing items
} else {
?>
Your form and stuff goes here
<?php
}
?>

Jon12345

Oh that's just what I need. Thank you!

I want to display a list of data from a MySQL database, possibly in a listbox. When I click on an article I want it to populate the fields in a form on that page. Then I can alter them and click a Save button to save those changes.

Can a form be autofilled on selecting an entry in a listbox? Or would you need some javascript to do that?
Can you have two buttons on a form, one saying Add, the other saying Save? The idea is that you can either add or save the article, depending if you are editing an existing entry or adding a new one.

Thanks,

Jon

bradgrafelman

For your first question, yes. Once they've selected an article, and you have the ID of that article, try something like:

<?PHP $query = mysql_query("SELECT * FROM MyTable WHERE ID = '$id' LIMIT 1");
$result = mysql_fetch_assoc($query);
?>
<form method=POST action="<?=$_SERVER['PHP_SELF'];?>">
Name: <input type="text" name="name" value="<?=$result['name'];?>"><br>

Article: <textarea name="article"><?=$result['article'];?></textarea>

As for your second question... if they're adding a new article, you would just need a blank form, right? So just output the blank form with a button that says Add. If they're editing an article, use the above code with a button that says Save.

Jon12345

My code to process the Form and stay on the same page is not altogether doing what I hoped.

When I enter a value into the form and click submit, it adds the value to the database but then the form vanishes!

How can I get it to always show the form?

Code is below...

<?php
if (isset($_POST["Submit"])) {
// form processing items

$dbh=mysql_connect ("localhost", "alwaysac", "xxx") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("alwaysac_MyArticles");
mysql_query("insert into Articles (TopicName) values
('$Topic')");

} else {
?>
<form name="form1" method="post" action="pea.php">
<p> </p>
<table width="200" border="0" cellspacing="0" cellpadding="5">
<tr>
<td>Topic</td>
<td><input name="Topic" type="text" id="Topic"></td>
</tr>
<tr>
<td>MetaTitle</td>
<td><input name="MetaTitle" type="text" id="MetaTitle"></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
<p> </p>
<p> </p>
</form>
<?php
}
?>

Frederick

You can't always show the form. How PHP works is you must either direct the user to a process page or direct them back to the beginning of the page for the code to process. PHP works from the top of the page to the bottom. So to run your code, they must be redirected, hence, the form disappears.

After your query, you can place a header() to redirect them back to the form after processing. Remember, using the header() function, you can not echo any html or print of any kind before this function or you will get an error.

header("Location: pea.php");

laserlight

Just a little catch when using header() with location.
You must use an absolute URI, so "pea.php" would be incorrect.
To get an absolute URI, you would probably use something like $SERVER['HTTP_HOST'] or $SERVER['PHP_SELF'], maybe with [man]dirname/man.

Frederick

Why do you say it won't work. I use it all the time without an absolute url and never have had an issue. Just curious why you mention that. I maybe missing something somewhere.

laserlight

From RFC 2616:

14.30 Location

The Location response-header field is used to redirect the recipient
to a location other than the Request-URI for completion of the
request or identification of a new resource. For 201 (Created)
responses, the Location is that of the new resource which was created
by the request. For 3xx responses, the location SHOULD indicate the
server's preferred URI for automatic redirection to the resource. The
field value consists of a single absolute URI.
   Location       = "Location" ":" absoluteURI
An example is:
   Location: [url]http://www.w3.org/pub/WWW/People.html[/url][/quote]

Jon12345

Sorry, but I don't really understand.

Under what line of code do I put...

header("Location: pea.php");

laserlight

Under what line of code do I put...

header("Location: pea.php");

You would place it where you want to re-direct, but before any output is printed, including text, HTML code, and blank lines.

As I said, dont just use pea.php, use something like:
header("Location: " . dirname($_SERVER['PHP_SELF']) . "/pea.php");

Jon12345

I can't get it to work. I have the following code now.

<?php
if (isset($_POST["Submit"])) {
// form processing items

} else {
header("Location: " . dirname($_SERVER['PHP_SELF']) . "/pea.php");
?>
<form name="form1" method="post" action="pea.php">
<p> </p>
<table width="200" border="0" cellspacing="0" cellpadding="5">
<tr>
<td>Topic</td>
<td><input name="Topic" type="text" id="Topic"></td>
</tr>
<tr>
<td>MetaTitle</td>
<td><input name="MetaTitle" type="text" id="MetaTitle"></td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
<p> </p>
<p> </p>
</form>
<?php
}
?>

bradgrafelman

If you're wanting to redirect them after they've submitted the form and you've processed the data, place the header after you process the data...

change:

} else { 
header("Location: " . dirname($_SERVER['PHP_SELF']) . "/pea.php");

to:

header("Location: " . dirname($_SERVER['PHP_SELF']) . "/pea.php");
} else {

(Also, start using the

 tags when posting PHP code.)