I have the following code to submit data to my database (programControl.php)
<html>
<head>
</head>
<body>
<h1>Book It Program Control Interface</h1>
<br>
<?
$db = mysql_connect("localhost",
"bookingap
p","") or mysql_die("Unable to connect");
mysql_select_db("bookingap
p",$db);
?>
<?php
if(isset($post)){
//get values from the form
$isValid = $_POST['isValid'];
$errString = $_POST['errString'];
$allowPassword = $_POST['allowPassword'];
$password = $_POST['password'];
$lockedOutText = $_POST['lockedOutText'];
$qry = mysql_query("insert into `tblProgramControl` (`isValid`, `errString`, `allowPassword`, `password`, `lockedOutText`) values ('$isValid', '$errString', '$allowPassword', '$password', '$lockedOutText')");
$result = mysql_query ($qry,$db);
}
else
{
echo "<form method=\"post\" action=\"programControl.ph
p\">
Program is active?
<input type=checkbox name=isValid><br>
Message to display to program user:
<input type=text name=errString><br>
Allow password to unlock program?
<input type=checkbox name=allowPassword><br>
Password:
<input type=text name=password><br>
Text to display when locked out:
<input type=text name=lockedOutText><br>
<input type=submit name=post value=\"Submit\">
</form>";
}
?>
</body>
</html>
--------------------------
----------
----------
----------
----------
----------
----------
----------
----------
-----
This works correctly. The problem is in my editing page (programControlEDIT.php?id
=51). Here is the code:
<html>
<head>
<?php
function mysql_die($error = "unknown")
{
echo "<H1>Error:". $error."</H1>";
exit;
}
$db = mysql_connect("localhost",
"bookingap
p","") or mysql_die("Unable to connect");
mysql_select_db("bookingap
p",$db);
$req = "SELECT * FROM tblProgramControl WHERE id=".$id;
$requete = mysql_query($req);
$num=mysql_numrows($requet
e);
echo "<b>Your query return <font color=\"red\">$num</font> results.</b><br><br>";
$i=0;
while ($i < $num) {
$isValid = mysql_result($requete,$i,"
isValid");
$errString = mysql_result($requete,$i,"
errString"
);
$allowPassword = mysql_result($requete,$i,"
allowPassw
ord");
$password = mysql_result($requete,$i,"
password")
;
$lockedOutText = mysql_result($requete,$i,"
lockedOutT
ext");
?>
</head>
<body>
<h1>Book It Program Control Interface</h1>
<br>
<?php
if(isset($post)){
//get values from the form
$isValid = $_POST['isValid'];
$errString = $_POST['errString'];
$allowPassword = $_POST['allowPassword'];
$password = $_POST['password'];
$lockedOutText = $_POST['lockedOutText'];
$qry = mysql_query("UPDATE `tblProgramControl` SET `isValid` = '$isValid', `errString` ='$errString', `allowPassword` = '$allowPassword', `password` = '$password', `lockedouttext` = '$lockedOutText' Where id = ".$id);
$result = mysql_query ($qry,$db);
}
else
{
echo "<form method=\"post\" action=\"programControlEDI
T.php\">
Program Id:
<input type=text name=id value=$id><br>
Program is active?
<input type=checkbox name=isValid value=$isValid><br>
Message to display to program user:
<input type=text name=errString value=$errString><br>
Allow password to unlock program?
<input type=checkbox name=allowPassword value=$allowPassword><br>
Password:
<input type=text name=password value=$password><br>
Text to display when locked out:
<input type=text name=lockedOutText value=$lockedOutText><br>
<input type=submit name=post value=\"Submit\">
</form>";
}
$i++;
}
?>
</body>
</html>
Now, my two problems are
- The checkboxes are not populated correctly. Do i fix this with an IFF?
- The data is not being updated when I save the changes. How do I do that, ie make it update my changes?
Thanks in advance!
