[observ]

Hi,

I am trying to update data from a column in a database using a php script. But for some reason it doesn't update the database, but i get no error feedback.
So first i select a random entry from the database and i add it as a parameter to the next page. This page contains the form and the php script to get the parameter:

PHP Code:

     <?

  $server = "myserver";

  $username = "myusername";

  $password = "mypass";

  $database = "dbname";

  $con = mysql_connect($server, $username, $password);

  $ok = mysql_select_db($database, $con);

 

 

' ' . htmlspecialchars($_GET["param"]) . '';

 

if(empty($_GET))

    echo "<h2>The request is invalid</h2>";

else

    $param_code = ($_GET[param]); 

 

?>

    <form name="form1" method="post" action="insert.php">

        <input type="text" name="code" disabled value="<? print_r ($param_code); ?>">

        <input type="submit" name="submit" id="submit" value="Submit">

    </form>

here is the insert.php:

PHP Code:

<?

  $server = "myserver";

  $username = "myusername";

  $password = "mypass";

  $database = "dbname";

  $con = mysql_connect($server, $username, $password);

  $ok = mysql_select_db($database, $con);

 

if(isset($_POST['submit']))

{

   $submit = $_POST['code'];

}

 

mysql_query(" UPDATE table_name SET code_used= '0' WHERE param_code ='{$submit}' ", $con) or die (mysql_error());

 

mysql_close($con);

 

     ?>

My database is very simple. It has only one table and 3 columns.
PHP Syntax (Toggle Plain Text)

Code:

| id | param_code | code_used|
| 1  | abc2qsaa   |     1    |  --> This is a not used code
| 2  | safd3235   |     0    |  --> This is a used code.

[maneetpuri]

Hi,

The code looks fine, try echo the update query on the screen, it might give some clue.

Cheers,


~Maneet

[lufeceba]

Hi,

if you set the text field as disabled:

Code:

<input type="text" name="code" disabled value="<? print_r ($param_code); ?>">

then your insert.php script won't ever receive the variable, consequently your UPDATE query won't work because your are trying to match param_code field with an empty string

BTW. You should avoid using short tags for PHP code!

Regards,