Display and Save Data on another page

dicko_md

I have some simple code for submitting and displaying some code on another page when I hit the button.

If I leave the page and go back to the display page, it has fogot what I have just submitted.

Is there a way of actually updating the page permantley without a table ?

All I am wanting to do is let the football manager pick a series of drop down menus to update the homepage of the next game and meeting time.

input form on input.php

Display.php

<body>
Your name is: <? echo $GET[home]; ?>
<br />
your address is: <? echo $GET[away]; ?>
</body>

Thanks

Dicko

Ashley_Sheridan

Ideally you'd have a database that stores the data, but failing that you can store it in a simple text file. However, pointing your form to test.txt does not store the data there, so you'll need to make the action attribute point to a PHP file instead. The PHP script can then get the form data, save it to a text file or database and display any output which you might want.

Do you know if you have a database for your site?

dicko_md

Thanks. I knew it must be possible but I am new to PHP, so I just needed to know it could be done. I will search more now.

I do have some databases and tables for the website ie secure area login form for the manager to change the data and also the blogg for the team captain to report on matches and news within the camp, etc.

Is the code simple to do it to a text file or is it just easier to create a simple table and update on a primary ID so that you can just update that row each week with who they are playing and what time the meet is after submit is pressed?

Thanks

Dicko

Ashley_Sheridan

It's easier to update on a database I'd say! Just create your table, with the right number of fields for your purpose, and each time you need to update, it's a simple SQL query:

UPDATE meets SET player1='name',player2='name',player3='etc' WHERE id=1

Where 1 is your primary ID.

dicko_md

Thats great. I will have a play about with it this weekend and let you know how I go.

UPDATE meets SET player1='name',player2='name',player3='etc' WHERE id=1

If I just want to update all where id=1 do I have to stipulate them by SET as it will always be different or can I ignore that part of the formula for example I will be showing the line below

Team A v Team B meet on Saturday 30th August 2008 at 11 00

But I will be picking all the below from a fixed drop down boxes and then clicking on Submit button

Team A
Team B
Day
Date
Month
Year
Hour
Min

Thanks

Dicko

Ashley_Sheridan

Yeah, the SET part is just to show how you update the individual fields in your table. It goes as a comma delimited list of field=value pairs.

dicko_md

Ashley

Thats fantastic. I have the mysql doing the updates that I require. I just need to connect them to my actual webpage now. How would I add the query to the webpage ? I am using dreamweaver. Do I just add the query in the submit button ?

Thanks again

Dicko

Ashley_Sheridan

No, PHP is a server-side technology, and a button is a client-side thing. You can however, make the submit button part of a form whose action attribute points to the PHP page. The $REQUEST array will hold all your data (you can use $GET or $POST if you prefer, depending on how you sent the data from your form), with each element of the $REQUEST array directly translating to a form element.

dicko_md

I managed to get the web page to update the database but I get the error below
when I click on the update button.

Warning: Cannot modify header information - headers already sent by (output started at /home/thorncli/public_html/sponsors1.php:2) in /home/thorncli/public_html/sponsors1.php on line 59

The data below is from lines 54 to 60

$updateGoTo = "sponsors.php";
if (isset($SERVER['QUERY_STRING'])) {
$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
$updateGoTo .= $SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $updateGoTo));
}

Please could somebody help ?

Thanks

Dicko

John_B

Have you previously called the headers in something like an "includes/headers.php" file?
Also you may consider using the ob_start() function followed by the ob_end_clean() or ob_flush() functions.

<?php
ob_start();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<title>my Site</title>
</head>
<body>

<?php

etc, etc...
?>

</body>
</html>

<?php
ob_end_flush();
?>

dicko_md

Not to my knowledge have I included any includes/headers.php in my script. I created the page with dreamweaver, so that could have added it. Ive had a look and nothing like that is in there.

Why does the update work when I use a record set field text field, but if I change it to a drop down list and bridge it with the Record set it does not update the data ?

Thanks

Dicko

dicko_md

This line works at inserting the data when its just a record set line

but when its a drop down box ive created and bridged to the record set it doesnt insert any data.

<tr valign="baseline">
<td nowrap="nowrap" align="right"><div align="left">Year:</div></td>
<td><div align="left">
<select name="select3" id="select3" title="<?php echo $row_RS_NextGame['Year']; ?>">
<option value="2008" <?php if (!(strcmp(2008, htmlentities($row_RS_NextGame['Year'], ENT_COMPAT, 'utf-8')))) {echo "selected=\"selected\"";} ?>>2008</option>
<option value="2009" <?php if (!(strcmp(2009, htmlentities($row_RS_NextGame['Year'], ENT_COMPAT, 'utf-8')))) {echo "selected=\"selected\"";} ?>>2009</option>
<option value="2010" <?php if (!(strcmp(2010, htmlentities($row_RS_NextGame['Year'], ENT_COMPAT, 'utf-8')))) {echo "selected=\"selected\"";} ?>>2010</option>
<option value="2011" <?php if (!(strcmp(2011, htmlentities($row_RS_NextGame['Year'], ENT_COMPAT, 'utf-8')))) {echo "selected=\"selected\"";} ?>>2011</option>
<?php
do {

?>
<option value="<?php echo $row_RS_NextGame['Year']?>"<?php if (!(strcmp($row_RS_NextGame['Year'], htmlentities($row_RS_NextGame['Year'], ENT_COMPAT, 'utf-8')))) {echo "selected=\"selected\"";} ?>><?php echo $row_RS_NextGame['Year']?></option>
<?php
} while ($row_RS_NextGame = mysql_fetch_assoc($RS_NextGame));
$rows = mysql_num_rows($RS_NextGame);
if($rows > 0) {
mysql_data_seek($RS_NextGame, 0);
$row_RS_NextGame = mysql_fetch_assoc($RS_NextGame);
}
?>
</select>
</div></td>
</tr>

Does anything stick out ?

Ive been looking at it for a while now and I cant see anything wrong. Maybe ive been staring too long at it

Dicko

Ashley_Sheridan

If you have any non-PHP code characters appear in the PHP file before you have the <?php part, then this is classed as output, which triggers the headers to be automatically sent through to the browser.

dicko_md

Thanks for all the help. I have managed to sort this page now and it works great

Dicko

Ashley_Sheridan

Could you post what the solution and cause of the problem was? This will help anyone else with the same issue.