How do i update MYSQL through a form and PHP?

[HeinekenBeer]

[FONT=Verdana]Hey

I need this code to update my MYSQL database:

<?php 
 include('../mysql_connect.php');
	$hent = mysql_query("SELECT side_overskrift FROM forside");
		while ($vis = mysql_fetch_array($hent)){
			$overskrift		= $vis['side_overskrift'];
		}
?>

<form method='POST'>
	<TEXTAREA rows="1" cols="40" name="side_overskrift" value="<?php echo $overskrift?>"><?php echo $overskrift?></TEXTAREA>
	<br />
	<br />
	<input type='submit' value='ændre'>
</form>

<?php
 include('../mysql_connect.php');
	$hent = mysql_query("SELECT side_overskrift FROM forside");
		while ($vis = mysql_fetch_array($hent)){
			$overskrift		= $vis['side_overskrift'];
		}

$overskrift = $_POST['side_overskrift'];

$query = mysql_query("UPDATE forside SET side_overskrift = ".$overskrift."");

echo $overskrift;
?>

If i try this code in the browser it echos the UPDATED text correct in the browser, but it does not update my database, whats wrong?[/FONT]

[void_function]

The $POST['side_overskrift'] will contain whatever was input in the textarea after you submit the script, providing it has the action set to that same script. Remember that HTTP works in request-response basis. You input some text, you click the submit, and whichever script was called will have the $POST['side_overskrift'] available with the contents of that textarea.

BTW, don't set the value of the textarea, it doesn't make any sense.

[HeinekenBeer]

I don't understand your replay. I allready wrote a script that contains the contents of the textarea. What i need is to get this script to update my MYSQL database:

<?php
 include('../mysql_connect.php');
	$hent = mysql_query("SELECT side_overskrift FROM forside");
		while ($vis = mysql_fetch_array($hent)){
			$overskrift		= $vis['side_overskrift'];
		}

$overskrift = $_POST['side_overskrift'];

$query = mysql_query("UPDATE forside");

echo $overskrift;
?>

This script should update my database, but it does not. Whats wrong? I dont need to know how the form actions work.

[void_function]

Well, first this:

	while ($vis = mysql_fetch_array($hent)){
		$overskrift		= $vis['side_overskrift'];
	}

Is totally redundant since:

1. You select ALL rows from forside
2. In a loop through those rows you read the field into $overskrift replacing the last loaded value
3. With the next line you overwrite that with the contents of $_POST:

	$overskrift = $_POST['side_overskrift'];

This script should update my database, but it does not. Whats wrong? I dont need to know how the form actions work.

Well, you do need to know how the form actions work. You see, when you first call your script, the $POST['side_overscrift'] does not exist. Actually, since you do not set the action of your script, you can call it as many times as you want, the $POST key will not exist.

If you set the action to same script, then on submit, the script will be called and $_POST['side_overskrift'] will contain the contents of the form element with the name "side_overskrift", in your case, the textarea element.

PHP is server side, it runs, does something, and outputs something to the client. After you load the page, there is no more PHP in the story.

[HeinekenBeer]

Okay but i still dont see why the code dont update my database.

Could you make an exampel?

[void_function]

Assuming this script is called "script.php":

include('../mysql_connect.php');

$reload= true;
if (isset($_POST['side_overskrift'])) {
  $overskrift= mysql_real_escape_string($_POST['side_overskrift']);
    // Assuming only one row is in the table, otherwise WHERE clause is needed
  $res= mysql_query("UPDATE TABLE forside SET side_overskrift='$overskrift'");
  $reload= false;
} else $overskrift= '';


if ($reload) {
    // Assuming only one row is in the table, otherwise WHERE clause is needed
    $hent = mysql_query("SELECT side_overskrift FROM forside");
        while ($vis = mysql_fetch_array($hent)){
            $overskrift        = $vis['side_overskrift'];
        }
}
?>

<form method='post' action="script.php">
    <TEXTAREA rows="1" cols="40" name="side_overskrift"><?php echo $overskrift?></TEXTAREA>
    <br />
    <br />
    <input type='submit' value='ændre'>
</form>