valicon
asked on
Auto populate form via PHP from MySQL
I have a script that functions correctly, I am trying to have the following form auto populate when a user edits a record, here is the code:
if($_GET['action'] == "edit"){
echo "
<form name=\"form1\" method=\"POST\" action=\"editdelete.php?ac tion=updat e\">
<table><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td><td><input type=\"text\" name=\"strLastName\" value=\"$ts\"></td></tr>
I added the above --> value=\"$ts\"></td></tr> at the end but it does not auto populate.
<tr><td align=center bgcolor=#EBEBEB>First Name</td><td><input type=\"text\" name=\"strFirstName\"></td ></tr>
<tr><td align=center bgcolor=#EBEBEB>MI</td><td ><input type=\"text\" name=\"strMiddle_Initial\" ></td></tr >
<tr><td align=center bgcolor=#EBEBEB>DOB</td><t d><input type=\"text\" name=\"intDOB\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Race</td>< td><input type=\"text\" name=\"strRace\"></td></tr >
<tr><td align=center bgcolor=#EBEBEB>Sex</td><t d><input type=\"text\" name=\"strSex\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Address</t d><td><inp ut type=\"text\" name=\"strAddress\"></td>< /tr>
What syntax is required to make it function correctly? Thanks.
if($_GET['action'] == "edit"){
echo "
<form name=\"form1\" method=\"POST\" action=\"editdelete.php?ac
<table><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td><td><input type=\"text\" name=\"strLastName\" value=\"$ts\"></td></tr>
I added the above --> value=\"$ts\"></td></tr> at the end but it does not auto populate.
<tr><td align=center bgcolor=#EBEBEB>First Name</td><td><input type=\"text\" name=\"strFirstName\"></td
<tr><td align=center bgcolor=#EBEBEB>MI</td><td
<tr><td align=center bgcolor=#EBEBEB>DOB</td><t
<tr><td align=center bgcolor=#EBEBEB>Race</td><
<tr><td align=center bgcolor=#EBEBEB>Sex</td><t
<tr><td align=center bgcolor=#EBEBEB>Address</t
What syntax is required to make it function correctly? Thanks.
oh yeah dont forget at the end
<input type="hidden" name="user_id" value=\"".$_GET["user_id"] ."\"></for m>
And i made a mistake. Wherever it says something like value=".$defaults["FirstNa me"]." it must say
value=\"".$defaults["First Name"]."\"
Thats why single quotes are generally better to use, they dont interfear with html double quotes.
<input type="hidden" name="user_id" value=\"".$_GET["user_id"]
And i made a mistake. Wherever it says something like value=".$defaults["FirstNa
value=\"".$defaults["First
Thats why single quotes are generally better to use, they dont interfear with html double quotes.
ASKER
I was hoping not to add a bunch of code to the original script. Isn't there a way that is shorter, code wise?
No. You need to get the users details. For that you need to query the database. Then you got to capture the details (db output) and put them into the form. You also need to do it in such a way that the script does not through errors if it is used as a regular insert. Hence the defaults array. All these steps require many operations.
Or is the user information to be filled out stored elsewhere?
Or is the user information to be filled out stored elsewhere?
ASKER
Here is the code in it's entirety, the user info is getting grabbed by the variables $ts, etc:
<?
include("search.php3");
include('db_login.php');
$connection = mysql_connect($db_host, $db_username, $db_password);
if (!$connection){
die ("Could not connect to the database: <br />". mysql_error());
}
$selected = mysql_select_db("customer" ,$connecti on) or die("Could not select database");
//execute my SQL query and return records
$result = mysql_query("SELECT * FROM tblcustomer");
if ($result &&!$_GET['action']) {
echo "<table width=90% align=center border=1><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td>
<td align=center bgcolor=#EBEBEB>First Name</td>
<td align=center bgcolor=#EBEBEB>MI</td>
<td align=center bgcolor=#EBEBEB>DOB</td>
<td align=center bgcolor=#EBEBEB>Race</td>
<td align=center bgcolor=#EBEBEB>Sex</td>
<td align=center bgcolor=#EBEBEB>Address</t d>
<td align=center bgcolor=#EBEBEB>Case Number</td>
<td align=center bgcolor=#EBEBEB>Date</td>
<td align=center bgcolor=#EBEBEB>Length</td >
<td align=center bgcolor=#EBEBEB>office</td >
<td align=center bgcolor=#EBEBEB>Edit</td>
<td align=center bgcolor=#EBEBEB>Delete</td >
</tr>";
//grab the data from the database
while ($r = mysql_fetch_array($result) ) {
$my_id = $r["id"];
$ts = $r["strLastName"];
$fname = $r["strFirstName"];
$minit = $r["strMiddle_Initial"];
$address = $r["strAddress"];
$race = $r["strRace"];
$dob = $r["intDOB"];
$sx = $r["strSex"];
$csnum = $r["intCaseNumber"];
$date = $r["intDate"];
$len = $r["strLength"];
$officer = $r["strofficename"];
echo "<tr>
<td>$ts</td>
<td>$fname</td>
<td>$minit</td>
<td>$address</td>
<td>$race</td>
<td>$dob</td>
<td>$sx</td>
<td>$csnum</td>
<td>$date</td>
<td>$len</td>
<td>$officename</td>
<td><a href=\"editdelete.php?acti on=edit&id =$my_id\"> Edit</a></ td>
<td><a href=\"editdelete.php?acti on=delete& id=$my_id\ " onclick=\"return confirm('Are you sure you want to delete this record?')\">Delete</a></td ></tr>";
}
//echo "</table>";
}
}
if($_GET['action'] == "edit"){
echo "
<form name=\"form1\" method=\"POST\" action=\"editdelete.php?ac tion=updat e\">
<table><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td><td><input type=\"text\" name=\"strLastName\" value=\"$ts\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>First Name</td><td><input type=\"text\" name=\"strFirstName\"></td ></tr>
<tr><td align=center bgcolor=#EBEBEB>MI</td><td ><input type=\"text\" name=\"strMiddle_Initial\" ></td></tr >
<tr><td align=center bgcolor=#EBEBEB>DOB</td><t d><input type=\"text\" name=\"intDOB\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Race</td>< td><input type=\"text\" name=\"strRace\"></td></tr >
<tr><td align=center bgcolor=#EBEBEB>Sex</td><t d><input type=\"text\" name=\"strSex\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Address</t d><td><inp ut type=\"text\" name=\"strAddress\"></td>< /tr>
<tr><td align=center bgcolor=#EBEBEB>Case Number</td><td><input type=\"text\" name=\"intCaseNumber\"></t d></tr>
<tr><td align=center bgcolor=#EBEBEB>Date</td>< td><input type=\"text\" name=\"intDate\"></td></tr >
<tr><td align=center bgcolor=#EBEBEB>Length</td ><td><inpu t type=\"text\" name=\"strLength\"></td></ tr>
<tr><td align=center bgcolor=#EBEBEB>office</td ><td><inpu t type=\"text\" name=\"strofficename\"></t d></tr>
<tr><td align=center bgcolor=#EBEBEB></td><td>< input type=\"hidden\" name=\"my_id\" value=\"$_GET[id]\"></td>< /tr>
<tr><td align=center bgcolor=#EBEBEB>Update</td ><td><inpu t type=\"submit\" name=\"submit\"></td>
</tr></table</form>
";
}
if($_GET['action'] == "delete") {
$deletesql = "delete from tblTrespass where id = $_GET[id]";
$resultdelete = mysql_query($deletesql);
echo "Record Deleted<br>";
echo '<a href="editdelete.php">Retu rn to Admin page</a><br />';
//echo $deletesql;
}
if ($_GET['action'] == "update") {
$updatesql = "update tblTrespass set strLastName = \"$_POST[strLastName]\", strFirstName = \"$_POST[strFirstName]\", strMiddle_Initial=\"$_POST [strMiddle _Initial]\ ", intDOB = \"$_POST[intDOB]\", strRace = \"$_POST[strRace]\", strSex = \"$_POST[strSex]\", strAddress = \"$_POST[strAddress]\", intCaseNumber = \"$_POST[intCaseNumber]\", intDate = \"$_POST[intDate]\", strLength = \"$_POST[strLength]\", strofficename = \"$_POST[strofficename]\" where id = $_POST[my_id]";
$resultupdate = mysql_query($updatesql);
echo "Record Updated<br>";
echo '<a href="editdelete.php">Retu rn to Admin page</a><br />';
// echo $updatesql;
}
//close the connection
mysql_close($connection);
?>
<?
include("search.php3");
include('db_login.php');
$connection = mysql_connect($db_host, $db_username, $db_password);
if (!$connection){
die ("Could not connect to the database: <br />". mysql_error());
}
$selected = mysql_select_db("customer"
//execute my SQL query and return records
$result = mysql_query("SELECT * FROM tblcustomer");
if ($result &&!$_GET['action']) {
echo "<table width=90% align=center border=1><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td>
<td align=center bgcolor=#EBEBEB>First Name</td>
<td align=center bgcolor=#EBEBEB>MI</td>
<td align=center bgcolor=#EBEBEB>DOB</td>
<td align=center bgcolor=#EBEBEB>Race</td>
<td align=center bgcolor=#EBEBEB>Sex</td>
<td align=center bgcolor=#EBEBEB>Address</t
<td align=center bgcolor=#EBEBEB>Case Number</td>
<td align=center bgcolor=#EBEBEB>Date</td>
<td align=center bgcolor=#EBEBEB>Length</td
<td align=center bgcolor=#EBEBEB>office</td
<td align=center bgcolor=#EBEBEB>Edit</td>
<td align=center bgcolor=#EBEBEB>Delete</td
</tr>";
//grab the data from the database
while ($r = mysql_fetch_array($result)
$my_id = $r["id"];
$ts = $r["strLastName"];
$fname = $r["strFirstName"];
$minit = $r["strMiddle_Initial"];
$address = $r["strAddress"];
$race = $r["strRace"];
$dob = $r["intDOB"];
$sx = $r["strSex"];
$csnum = $r["intCaseNumber"];
$date = $r["intDate"];
$len = $r["strLength"];
$officer = $r["strofficename"];
echo "<tr>
<td>$ts</td>
<td>$fname</td>
<td>$minit</td>
<td>$address</td>
<td>$race</td>
<td>$dob</td>
<td>$sx</td>
<td>$csnum</td>
<td>$date</td>
<td>$len</td>
<td>$officename</td>
<td><a href=\"editdelete.php?acti
<td><a href=\"editdelete.php?acti
}
//echo "</table>";
}
}
if($_GET['action'] == "edit"){
echo "
<form name=\"form1\" method=\"POST\" action=\"editdelete.php?ac
<table><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td><td><input type=\"text\" name=\"strLastName\" value=\"$ts\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>First Name</td><td><input type=\"text\" name=\"strFirstName\"></td
<tr><td align=center bgcolor=#EBEBEB>MI</td><td
<tr><td align=center bgcolor=#EBEBEB>DOB</td><t
<tr><td align=center bgcolor=#EBEBEB>Race</td><
<tr><td align=center bgcolor=#EBEBEB>Sex</td><t
<tr><td align=center bgcolor=#EBEBEB>Address</t
<tr><td align=center bgcolor=#EBEBEB>Case Number</td><td><input type=\"text\" name=\"intCaseNumber\"></t
<tr><td align=center bgcolor=#EBEBEB>Date</td><
<tr><td align=center bgcolor=#EBEBEB>Length</td
<tr><td align=center bgcolor=#EBEBEB>office</td
<tr><td align=center bgcolor=#EBEBEB></td><td><
<tr><td align=center bgcolor=#EBEBEB>Update</td
</tr></table</form>
";
}
if($_GET['action'] == "delete") {
$deletesql = "delete from tblTrespass where id = $_GET[id]";
$resultdelete = mysql_query($deletesql);
echo "Record Deleted<br>";
echo '<a href="editdelete.php">Retu
//echo $deletesql;
}
if ($_GET['action'] == "update") {
$updatesql = "update tblTrespass set strLastName = \"$_POST[strLastName]\", strFirstName = \"$_POST[strFirstName]\", strMiddle_Initial=\"$_POST
$resultupdate = mysql_query($updatesql);
echo "Record Updated<br>";
echo '<a href="editdelete.php">Retu
// echo $updatesql;
}
//close the connection
mysql_close($connection);
?>
If it's working ok, I'd do it this way:
if($_GET['action'] == "edit"){ ?>
<form name="form1" method="POST" action="editdelete.php?act ion=update ">
<table><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td><td><input type="text" name="strLastName" value=" <? echo($ts); ?> "></td></tr>
<tr><td align=center bgcolor=#EBEBEB>First Name</td><td><input type="text" name="strFirstName"></td>< /tr>
<tr><td align=center bgcolor=#EBEBEB>MI</td><td ><input type="text" name="strMiddle_Initial">< /td></tr>
<tr><td align=center bgcolor=#EBEBEB>DOB</td><t d><input type="text" name="intDOB"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Race</td>< td><input type="text" name="strRace"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Sex</td><t d><input type="text" name="strSex"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Address</t d><td><inp ut type="text" name="strAddress"></td></t r>
<tr><td align=center bgcolor=#EBEBEB>Case Number</td><td><input type="text" name="intCaseNumber"></td> </tr>
<tr><td align=center bgcolor=#EBEBEB>Date</td>< td><input type="text" name="intDate"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Length</td ><td><inpu t type="text" name="strLength"></td></tr >
<tr><td align=center bgcolor=#EBEBEB>office</td ><td><inpu t type="text" name="strofficename"></td> </tr>
<tr><td align=center bgcolor=#EBEBEB></td><td>< input type="hidden" name="my_id" value=" <? echo($_GET[id]); ?>"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Update</td ><td><inpu t type="submit" name="submit"></td>
</tr></table</form>
<?
}
You just need to add more value=" <? echo($VARIABLE); ?>" wherever you need to auto populate.
Good luck.
-V
if($_GET['action'] == "edit"){ ?>
<form name="form1" method="POST" action="editdelete.php?act
<table><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td><td><input type="text" name="strLastName" value=" <? echo($ts); ?> "></td></tr>
<tr><td align=center bgcolor=#EBEBEB>First Name</td><td><input type="text" name="strFirstName"></td><
<tr><td align=center bgcolor=#EBEBEB>MI</td><td
<tr><td align=center bgcolor=#EBEBEB>DOB</td><t
<tr><td align=center bgcolor=#EBEBEB>Race</td><
<tr><td align=center bgcolor=#EBEBEB>Sex</td><t
<tr><td align=center bgcolor=#EBEBEB>Address</t
<tr><td align=center bgcolor=#EBEBEB>Case Number</td><td><input type="text" name="intCaseNumber"></td>
<tr><td align=center bgcolor=#EBEBEB>Date</td><
<tr><td align=center bgcolor=#EBEBEB>Length</td
<tr><td align=center bgcolor=#EBEBEB>office</td
<tr><td align=center bgcolor=#EBEBEB></td><td><
<tr><td align=center bgcolor=#EBEBEB>Update</td
</tr></table</form>
<?
}
You just need to add more value=" <? echo($VARIABLE); ?>" wherever you need to auto populate.
Good luck.
-V
OK, thanks for that.
Yes, with that code there is nothing to add. It does the same thing i did as it is.
One thing i dont agree/understand is the query "SELECT * FROM tblcustomer". Thats going to select all customers. To get the particular customer you need to have "SELECT * FROM tblcustomer WHERE id = ".$_GET["id"]
Do you get the value for $ts? For example if you type anywhere after the query executes echo $ts does it return the value you need?
Yes, with that code there is nothing to add. It does the same thing i did as it is.
One thing i dont agree/understand is the query "SELECT * FROM tblcustomer". Thats going to select all customers. To get the particular customer you need to have "SELECT * FROM tblcustomer WHERE id = ".$_GET["id"]
Do you get the value for $ts? For example if you type anywhere after the query executes echo $ts does it return the value you need?
ASKER
Vulturous,
I tried it but it does not work. I just get a blank screen, the page does not display any data.
I tried it but it does not work. I just get a blank screen, the page does not display any data.
if($_GET['action'] == "edit"){
$newsql = "select * from tblcustomer where id = $_GET[id]";
$myresult = mysql_query($newsql);
$x = mysql_fetch_array($myresul t);
$tsx = $x["strLastName"];
$fnamex = $x["strFirstName"];
$minitx = $x["strMiddle_Initial"];
$addressx = $x["strAddress"];
$racex = $x["strRace"];
$dobx = $x["intDOB"];
$sxx = $x["strSex"];
$csnumx = $x["intCaseNumber"];
$datex = $x["intDate"];
$lenx = $x["strLength"];
$officerx = $x["strofficename"];
echo "
<form name=\"form1\" method=\"POST\" action=\"editdelete.php?ac tion=updat e\">
<table><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td><td><input type=\"text\" name=\"strLastName\" value=\"$tsx\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>First Name</td><td><input type=\"text\" name=\"strFirstName\" value=\"$fnamex\"></td></t r>
<tr><td align=center bgcolor=#EBEBEB>MI</td><td ><input type=\"text\" name=\"strMiddle_Initial\" value=\"$minitx\"></td></t r>
<tr><td align=center bgcolor=#EBEBEB>DOB</td><t d><input type=\"text\" name=\"intDOB\" value=\"$dobx\" ></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Race</td>< td><input type=\"text\" name=\"strRace\" value=\"$racex\" ></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Sex</td><t d><input type=\"text\" name=\"strSex\" value=\"$sexx\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Address</t d><td><inp ut type=\"text\" name=\"strAddress\" value=\"$addressx\"></td>< /tr>
<tr><td align=center bgcolor=#EBEBEB>Case Number</td><td><input type=\"text\" name=\"intCaseNumber\" value=\"$csnumx\"></td></t r>
<tr><td align=center bgcolor=#EBEBEB>Date</td>< td><input type=\"text\" name=\"intDate\" value=\"$datex\"></td></tr >
<tr><td align=center bgcolor=#EBEBEB>Length</td ><td><inpu t type=\"text\" name=\"strLength\" value=\"$lenx\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>office</td ><td><inpu t type=\"text\" name=\"strofficename\" value=\"$officerx\"></td>< /tr>
<tr><td align=center bgcolor=#EBEBEB></td><td>< input type=\"hidden\" name=\"my_id\" value=\"$_GET[id]\"></td>< /tr>
<tr><td align=center bgcolor=#EBEBEB>Update</td ><td><inpu t type=\"submit\" name=\"submit\"></td>
</tr></table</form>
";
}
$newsql = "select * from tblcustomer where id = $_GET[id]";
$myresult = mysql_query($newsql);
$x = mysql_fetch_array($myresul
$tsx = $x["strLastName"];
$fnamex = $x["strFirstName"];
$minitx = $x["strMiddle_Initial"];
$addressx = $x["strAddress"];
$racex = $x["strRace"];
$dobx = $x["intDOB"];
$sxx = $x["strSex"];
$csnumx = $x["intCaseNumber"];
$datex = $x["intDate"];
$lenx = $x["strLength"];
$officerx = $x["strofficename"];
echo "
<form name=\"form1\" method=\"POST\" action=\"editdelete.php?ac
<table><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td><td><input type=\"text\" name=\"strLastName\" value=\"$tsx\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>First Name</td><td><input type=\"text\" name=\"strFirstName\" value=\"$fnamex\"></td></t
<tr><td align=center bgcolor=#EBEBEB>MI</td><td
<tr><td align=center bgcolor=#EBEBEB>DOB</td><t
<tr><td align=center bgcolor=#EBEBEB>Race</td><
<tr><td align=center bgcolor=#EBEBEB>Sex</td><t
<tr><td align=center bgcolor=#EBEBEB>Address</t
<tr><td align=center bgcolor=#EBEBEB>Case Number</td><td><input type=\"text\" name=\"intCaseNumber\" value=\"$csnumx\"></td></t
<tr><td align=center bgcolor=#EBEBEB>Date</td><
<tr><td align=center bgcolor=#EBEBEB>Length</td
<tr><td align=center bgcolor=#EBEBEB>office</td
<tr><td align=center bgcolor=#EBEBEB></td><td><
<tr><td align=center bgcolor=#EBEBEB>Update</td
</tr></table</form>
";
}
what do you get if you just do
echo $ts anywhere after query
echo $ts anywhere after query
ASKER
Hi psimation :)
I overwrote the original code with your post above and I am getting a blank page, no results.
I overwrote the original code with your post above and I am getting a blank page, no results.
Blank page only when you click Edit, or blank page when you load up the first time?
Maybe post the complete code again?
Maybe post the complete code again?
ASKER
AlexanderR,
Using echo $ts I was just getting the echo statement in the field where the reord should have been.
Using echo $ts I was just getting the echo statement in the field where the reord should have been.
You cant "echo" $ts there, it's already in an echo.
ASKER
Blank page when it loads the first time. Here is the code:
<?
include("search.php3");
include('db_login.php');
$connection = mysql_connect($db_host, $db_username, $db_password);
if (!$connection){
die ("Could not connect to the database: <br />". mysql_error());
}
$selected = mysql_select_db("customer" ,$connecti on) or die("Could not select database");
//execute my SQL query and return records
$result = mysql_query("SELECT * FROM tblcustomer");
if ($result &&!$_GET['action']) {
echo "<table width=90% align=center border=1><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td>
<td align=center bgcolor=#EBEBEB>First Name</td>
<td align=center bgcolor=#EBEBEB>MI</td>
<td align=center bgcolor=#EBEBEB>DOB</td>
<td align=center bgcolor=#EBEBEB>Race</td>
<td align=center bgcolor=#EBEBEB>Sex</td>
<td align=center bgcolor=#EBEBEB>Address</t d>
<td align=center bgcolor=#EBEBEB>Case Number</td>
<td align=center bgcolor=#EBEBEB>Date</td>
<td align=center bgcolor=#EBEBEB>Length</td >
<td align=center bgcolor=#EBEBEB>office</td >
<td align=center bgcolor=#EBEBEB>Edit</td>
<td align=center bgcolor=#EBEBEB>Delete</td >
</tr>";
//grab the data from the database
while ($r = mysql_fetch_array($result) ) {
$my_id = $r["id"];
$ts = $r["strLastName"];
$fname = $r["strFirstName"];
$minit = $r["strMiddle_Initial"];
$address = $r["strAddress"];
$race = $r["strRace"];
$dob = $r["intDOB"];
$sx = $r["strSex"];
$csnum = $r["intCaseNumber"];
$date = $r["intDate"];
$len = $r["strLength"];
$office = $r["strofficename"];
echo "<tr>
<td>$ts</td>
<td>$fname</td>
<td>$minit</td>
<td>$address</td>
<td>$race</td>
<td>$dob</td>
<td>$sx</td>
<td>$csnum</td>
<td>$date</td>
<td>$len</td>
<td>$officename</td>
<td><a href=\"editdelete.php?acti on=edit&id =$my_id\"> Edit</a></ td>
<td><a href=\"editdelete.php?acti on=delete& id=$my_id\ " onclick=\"return confirm('Are you sure you want to delete this record?')\">Delete</a></td ></tr>";
}
//echo "</table>";
}
if($_GET['action'] == "edit"){
$newsql = "select * from tblcustomer where id = $_GET[id]";
$myresult = mysql_query($newsql);
$x = mysql_fetch_array($myresul t);
$tsx = $x["strLastName"];
$fnamex = $x["strFirstName"];
$minitx = $x["strMiddle_Initial"];
$addressx = $x["strAddress"];
$racex = $x["strRace"];
$dobx = $x["intDOB"];
$sxx = $x["strSex"];
$csnumx = $x["intCaseNumber"];
$datex = $x["intDate"];
$lenx = $x["strLength"];
$officex = $x["strofficename"];
echo "
<form name=\"form1\" method=\"POST\" action=\"editdelete.php?ac tion=updat e\">
<table><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td><td><input type=\"text\" name=\"strLastName\" value=\"$tsx\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>First Name</td><td><input type=\"text\" name=\"strFirstName\" value=\"$fnamex\"></td></t r>
<tr><td align=center bgcolor=#EBEBEB>MI</td><td ><input type=\"text\" name=\"strMiddle_Initial\" value=\"$minitx\"></td></t r>
<tr><td align=center bgcolor=#EBEBEB>DOB</td><t d><input type=\"text\" name=\"intDOB\" value=\"$dobx\" ></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Race</td>< td><input type=\"text\" name=\"strRace\" value=\"$racex\" ></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Sex</td><t d><input type=\"text\" name=\"strSex\" value=\"$sexx\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Address</t d><td><inp ut type=\"text\" name=\"strAddress\" value=\"$addressx\"></td>< /tr>
<tr><td align=center bgcolor=#EBEBEB>Case Number</td><td><input type=\"text\" name=\"intCaseNumber\" value=\"$csnumx\"></td></t r>
<tr><td align=center bgcolor=#EBEBEB>Date</td>< td><input type=\"text\" name=\"intDate\" value=\"$datex\"></td></tr >
<tr><td align=center bgcolor=#EBEBEB>Length</td ><td><inpu t type=\"text\" name=\"strLength\" value=\"$lenx\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>office</td ><td><inpu t type=\"text\" name=\"strofficename\" value=\"$officex\"></td></ tr>
<tr><td align=center bgcolor=#EBEBEB></td><td>< input type=\"hidden\" name=\"my_id\" value=\"$_GET[id]\"></td>< /tr>
<tr><td align=center bgcolor=#EBEBEB>Update</td ><td><inpu t type=\"submit\" name=\"submit\"></td>
</tr></table</form>
";
}
}
if($_GET['action'] == "delete") {
$deletesql = "delete from tblcustomer where id = $_GET[id]";
$resultdelete = mysql_query($deletesql);
echo "Record Deleted<br>";
echo '<a href="editdelete.php">Retu rn to Admin page</a><br />';
//echo $deletesql;
}
if ($_GET['action'] == "update") {
$updatesql = "update tblcustomer set strLastName = \"$_POST[strLastName]\", strFirstName = \"$_POST[strFirstName]\", strMiddle_Initial=\"$_POST [strMiddle _Initial]\ ", intDOB = \"$_POST[intDOB]\", strRace = \"$_POST[strRace]\", strSex = \"$_POST[strSex]\", strAddress = \"$_POST[strAddress]\", intCaseNumber = \"$_POST[intCaseNumber]\", intDate = \"$_POST[intDate]\", strLength = \"$_POST[strLength]\", strofficename = \"$_POST[strofficename]\" where id = $_POST[my_id]";
$resultupdate = mysql_query($updatesql);
echo "Record Updated<br>";
echo '<a href="editdelete.php">Retu rn to Admin page</a><br />';
// echo $updatesql;
}
//close the connection
mysql_close($connection);
?>
<?
include("search.php3");
include('db_login.php');
$connection = mysql_connect($db_host, $db_username, $db_password);
if (!$connection){
die ("Could not connect to the database: <br />". mysql_error());
}
$selected = mysql_select_db("customer"
//execute my SQL query and return records
$result = mysql_query("SELECT * FROM tblcustomer");
if ($result &&!$_GET['action']) {
echo "<table width=90% align=center border=1><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td>
<td align=center bgcolor=#EBEBEB>First Name</td>
<td align=center bgcolor=#EBEBEB>MI</td>
<td align=center bgcolor=#EBEBEB>DOB</td>
<td align=center bgcolor=#EBEBEB>Race</td>
<td align=center bgcolor=#EBEBEB>Sex</td>
<td align=center bgcolor=#EBEBEB>Address</t
<td align=center bgcolor=#EBEBEB>Case Number</td>
<td align=center bgcolor=#EBEBEB>Date</td>
<td align=center bgcolor=#EBEBEB>Length</td
<td align=center bgcolor=#EBEBEB>office</td
<td align=center bgcolor=#EBEBEB>Edit</td>
<td align=center bgcolor=#EBEBEB>Delete</td
</tr>";
//grab the data from the database
while ($r = mysql_fetch_array($result)
$my_id = $r["id"];
$ts = $r["strLastName"];
$fname = $r["strFirstName"];
$minit = $r["strMiddle_Initial"];
$address = $r["strAddress"];
$race = $r["strRace"];
$dob = $r["intDOB"];
$sx = $r["strSex"];
$csnum = $r["intCaseNumber"];
$date = $r["intDate"];
$len = $r["strLength"];
$office = $r["strofficename"];
echo "<tr>
<td>$ts</td>
<td>$fname</td>
<td>$minit</td>
<td>$address</td>
<td>$race</td>
<td>$dob</td>
<td>$sx</td>
<td>$csnum</td>
<td>$date</td>
<td>$len</td>
<td>$officename</td>
<td><a href=\"editdelete.php?acti
<td><a href=\"editdelete.php?acti
}
//echo "</table>";
}
if($_GET['action'] == "edit"){
$newsql = "select * from tblcustomer where id = $_GET[id]";
$myresult = mysql_query($newsql);
$x = mysql_fetch_array($myresul
$tsx = $x["strLastName"];
$fnamex = $x["strFirstName"];
$minitx = $x["strMiddle_Initial"];
$addressx = $x["strAddress"];
$racex = $x["strRace"];
$dobx = $x["intDOB"];
$sxx = $x["strSex"];
$csnumx = $x["intCaseNumber"];
$datex = $x["intDate"];
$lenx = $x["strLength"];
$officex = $x["strofficename"];
echo "
<form name=\"form1\" method=\"POST\" action=\"editdelete.php?ac
<table><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td><td><input type=\"text\" name=\"strLastName\" value=\"$tsx\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>First Name</td><td><input type=\"text\" name=\"strFirstName\" value=\"$fnamex\"></td></t
<tr><td align=center bgcolor=#EBEBEB>MI</td><td
<tr><td align=center bgcolor=#EBEBEB>DOB</td><t
<tr><td align=center bgcolor=#EBEBEB>Race</td><
<tr><td align=center bgcolor=#EBEBEB>Sex</td><t
<tr><td align=center bgcolor=#EBEBEB>Address</t
<tr><td align=center bgcolor=#EBEBEB>Case Number</td><td><input type=\"text\" name=\"intCaseNumber\" value=\"$csnumx\"></td></t
<tr><td align=center bgcolor=#EBEBEB>Date</td><
<tr><td align=center bgcolor=#EBEBEB>Length</td
<tr><td align=center bgcolor=#EBEBEB>office</td
<tr><td align=center bgcolor=#EBEBEB></td><td><
<tr><td align=center bgcolor=#EBEBEB>Update</td
</tr></table</form>
";
}
}
if($_GET['action'] == "delete") {
$deletesql = "delete from tblcustomer where id = $_GET[id]";
$resultdelete = mysql_query($deletesql);
echo "Record Deleted<br>";
echo '<a href="editdelete.php">Retu
//echo $deletesql;
}
if ($_GET['action'] == "update") {
$updatesql = "update tblcustomer set strLastName = \"$_POST[strLastName]\", strFirstName = \"$_POST[strFirstName]\", strMiddle_Initial=\"$_POST
$resultupdate = mysql_query($updatesql);
echo "Record Updated<br>";
echo '<a href="editdelete.php">Retu
// echo $updatesql;
}
//close the connection
mysql_close($connection);
?>
Sorry for misunderstandings. I just saw whats going on here. Here's another version of your code based on what i think you are trying to accomplish (i hope)
<?
include("search.php3");
include('db_login.php');
$connection = mysql_connect($db_host, $db_username, $db_password);
if (!$connection){
die ("Could not connect to the database: <br />". mysql_error());
}
$selected = mysql_select_db("customer" ,$connecti on) or die("Could not select database");
if ($_GET['action'] == "") {
//execute my SQL query and return records
$result = mysql_query("SELECT * FROM tblcustomer");
if ($result) {
echo "<table width=90% align=center border=1><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td>
<td align=center bgcolor=#EBEBEB>First Name</td>
<td align=center bgcolor=#EBEBEB>MI</td>
<td align=center bgcolor=#EBEBEB>DOB</td>
<td align=center bgcolor=#EBEBEB>Race</td>
<td align=center bgcolor=#EBEBEB>Sex</td>
<td align=center bgcolor=#EBEBEB>Address</t d>
<td align=center bgcolor=#EBEBEB>Case Number</td>
<td align=center bgcolor=#EBEBEB>Date</td>
<td align=center bgcolor=#EBEBEB>Length</td >
<td align=center bgcolor=#EBEBEB>office</td >
<td align=center bgcolor=#EBEBEB>Edit</td>
<td align=center bgcolor=#EBEBEB>Delete</td >
</tr>";
//grab the data from the database
while ($r = mysql_fetch_array($result) ) {
$my_id = $r["id"];
$ts = $r["strLastName"];
$fname = $r["strFirstName"];
$minit = $r["strMiddle_Initial"];
$address = $r["strAddress"];
$race = $r["strRace"];
$dob = $r["intDOB"];
$sx = $r["strSex"];
$csnum = $r["intCaseNumber"];
$date = $r["intDate"];
$len = $r["strLength"];
$officer = $r["strofficename"];
echo "<tr>
<td>$ts</td>
<td>$fname</td>
<td>$minit</td>
<td>$address</td>
<td>$race</td>
<td>$dob</td>
<td>$sx</td>
<td>$csnum</td>
<td>$date</td>
<td>$len</td>
<td>$officename</td>
<td><a href=\"editdelete.php?acti on=edit&id =$my_id\"> Edit</a></ td>
<td><a href=\"editdelete.php?acti on=delete& id=$my_id\ " onclick=\"return confirm('Are you sure you want to delete this record?')\">Delete</a></td ></tr>";
}
//echo "</table>";
}
} elseif($_GET['action'] == "edit"){
$result = mysql_query("SELECT * FROM tblcustomer WHERE id = ".$_GET["my_id"]);
while ($r = mysql_fetch_array($result) ) {
$my_id = $r["id"];
$ts = $r["strLastName"];
$fname = $r["strFirstName"];
$minit = $r["strMiddle_Initial"];
$address = $r["strAddress"];
$race = $r["strRace"];
$dob = $r["intDOB"];
$sx = $r["strSex"];
$csnum = $r["intCaseNumber"];
$date = $r["intDate"];
$len = $r["strLength"];
$officer = $r["strofficename"];
}
echo "
<form name=\"form1\" method=\"POST\" action=\"editdelete.php?ac tion=updat e\">
<table><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td><td><input type=\"text\" name=\"strLastName\" value=\"$ts\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>First Name</td><td><input type=\"text\" name=\"strFirstName\"></td ></tr>
<tr><td align=center bgcolor=#EBEBEB>MI</td><td ><input type=\"text\" name=\"strMiddle_Initial\" ></td></tr >
<tr><td align=center bgcolor=#EBEBEB>DOB</td><t d><input type=\"text\" name=\"intDOB\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Race</td>< td><input type=\"text\" name=\"strRace\"></td></tr >
<tr><td align=center bgcolor=#EBEBEB>Sex</td><t d><input type=\"text\" name=\"strSex\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>Address</t d><td><inp ut type=\"text\" name=\"strAddress\"></td>< /tr>
<tr><td align=center bgcolor=#EBEBEB>Case Number</td><td><input type=\"text\" name=\"intCaseNumber\"></t d></tr>
<tr><td align=center bgcolor=#EBEBEB>Date</td>< td><input type=\"text\" name=\"intDate\"></td></tr >
<tr><td align=center bgcolor=#EBEBEB>Length</td ><td><inpu t type=\"text\" name=\"strLength\"></td></ tr>
<tr><td align=center bgcolor=#EBEBEB>office</td ><td><inpu t type=\"text\" name=\"strofficename\"></t d></tr>
<tr><td align=center bgcolor=#EBEBEB></td><td>< input type=\"hidden\" name=\"my_id\" value=\"$_GET[id]\"></td>< /tr>
<tr><td align=center bgcolor=#EBEBEB>Update</td ><td><inpu t type=\"submit\" name=\"submit\"></td>
</tr></table</form>
";
}
elseif ($_GET['action'] == "delete") {
$deletesql = "delete from tblTrespass where id = $_GET[id]";
$resultdelete = mysql_query($deletesql);
echo "Record Deleted<br>";
echo '<a href="editdelete.php">Retu rn to Admin page</a><br />';
//echo $deletesql;
} elseif ($_GET['action'] == "update") {
$updatesql = "update tblTrespass set strLastName = \"$_POST[strLastName]\", strFirstName = \"$_POST[strFirstName]\", strMiddle_Initial=\"$_POST [strMiddle _Initial]\ ", intDOB = \"$_POST[intDOB]\", strRace = \"$_POST[strRace]\", strSex = \"$_POST[strSex]\", strAddress = \"$_POST[strAddress]\", intCaseNumber = \"$_POST[intCaseNumber]\", intDate = \"$_POST[intDate]\", strLength = \"$_POST[strLength]\", strofficename = \"$_POST[strofficename]\" where id = $_POST[my_id]";
$resultupdate = mysql_query($updatesql);
echo "Record Updated<br>";
echo '<a href="editdelete.php">Retu rn to Admin page</a><br />';
// echo $updatesql;
}
//close the connection
mysql_close($connection);
?>
<?
include("search.php3");
include('db_login.php');
$connection = mysql_connect($db_host, $db_username, $db_password);
if (!$connection){
die ("Could not connect to the database: <br />". mysql_error());
}
$selected = mysql_select_db("customer"
if ($_GET['action'] == "") {
//execute my SQL query and return records
$result = mysql_query("SELECT * FROM tblcustomer");
if ($result) {
echo "<table width=90% align=center border=1><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td>
<td align=center bgcolor=#EBEBEB>First Name</td>
<td align=center bgcolor=#EBEBEB>MI</td>
<td align=center bgcolor=#EBEBEB>DOB</td>
<td align=center bgcolor=#EBEBEB>Race</td>
<td align=center bgcolor=#EBEBEB>Sex</td>
<td align=center bgcolor=#EBEBEB>Address</t
<td align=center bgcolor=#EBEBEB>Case Number</td>
<td align=center bgcolor=#EBEBEB>Date</td>
<td align=center bgcolor=#EBEBEB>Length</td
<td align=center bgcolor=#EBEBEB>office</td
<td align=center bgcolor=#EBEBEB>Edit</td>
<td align=center bgcolor=#EBEBEB>Delete</td
</tr>";
//grab the data from the database
while ($r = mysql_fetch_array($result)
$my_id = $r["id"];
$ts = $r["strLastName"];
$fname = $r["strFirstName"];
$minit = $r["strMiddle_Initial"];
$address = $r["strAddress"];
$race = $r["strRace"];
$dob = $r["intDOB"];
$sx = $r["strSex"];
$csnum = $r["intCaseNumber"];
$date = $r["intDate"];
$len = $r["strLength"];
$officer = $r["strofficename"];
echo "<tr>
<td>$ts</td>
<td>$fname</td>
<td>$minit</td>
<td>$address</td>
<td>$race</td>
<td>$dob</td>
<td>$sx</td>
<td>$csnum</td>
<td>$date</td>
<td>$len</td>
<td>$officename</td>
<td><a href=\"editdelete.php?acti
<td><a href=\"editdelete.php?acti
}
//echo "</table>";
}
} elseif($_GET['action'] == "edit"){
$result = mysql_query("SELECT * FROM tblcustomer WHERE id = ".$_GET["my_id"]);
while ($r = mysql_fetch_array($result)
$my_id = $r["id"];
$ts = $r["strLastName"];
$fname = $r["strFirstName"];
$minit = $r["strMiddle_Initial"];
$address = $r["strAddress"];
$race = $r["strRace"];
$dob = $r["intDOB"];
$sx = $r["strSex"];
$csnum = $r["intCaseNumber"];
$date = $r["intDate"];
$len = $r["strLength"];
$officer = $r["strofficename"];
}
echo "
<form name=\"form1\" method=\"POST\" action=\"editdelete.php?ac
<table><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td><td><input type=\"text\" name=\"strLastName\" value=\"$ts\"></td></tr>
<tr><td align=center bgcolor=#EBEBEB>First Name</td><td><input type=\"text\" name=\"strFirstName\"></td
<tr><td align=center bgcolor=#EBEBEB>MI</td><td
<tr><td align=center bgcolor=#EBEBEB>DOB</td><t
<tr><td align=center bgcolor=#EBEBEB>Race</td><
<tr><td align=center bgcolor=#EBEBEB>Sex</td><t
<tr><td align=center bgcolor=#EBEBEB>Address</t
<tr><td align=center bgcolor=#EBEBEB>Case Number</td><td><input type=\"text\" name=\"intCaseNumber\"></t
<tr><td align=center bgcolor=#EBEBEB>Date</td><
<tr><td align=center bgcolor=#EBEBEB>Length</td
<tr><td align=center bgcolor=#EBEBEB>office</td
<tr><td align=center bgcolor=#EBEBEB></td><td><
<tr><td align=center bgcolor=#EBEBEB>Update</td
</tr></table</form>
";
}
elseif ($_GET['action'] == "delete") {
$deletesql = "delete from tblTrespass where id = $_GET[id]";
$resultdelete = mysql_query($deletesql);
echo "Record Deleted<br>";
echo '<a href="editdelete.php">Retu
//echo $deletesql;
} elseif ($_GET['action'] == "update") {
$updatesql = "update tblTrespass set strLastName = \"$_POST[strLastName]\", strFirstName = \"$_POST[strFirstName]\", strMiddle_Initial=\"$_POST
$resultupdate = mysql_query($updatesql);
echo "Record Updated<br>";
echo '<a href="editdelete.php">Retu
// echo $updatesql;
}
//close the connection
mysql_close($connection);
?>
of course i forgot to put all the value variables in your form.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I thought so "{", but I wasn't sure. Should I try the latest code post?
ummm... ok, first off, please don't ever use that conditional structure ever again, you're testing the same variable multiple times for different conditions. That section in memory will only ever contain one value at one time, there is no reason to do multiple conditionl tests when you're only looking for one value.
if($result !== false && is_set($_GET["action"])
{
switch(tolower($_GET['acti on'])
{
case 'edit':
createEditScreen($result);
break;
case 'update':
updateValues();
break;
case 'delete':
deleteValues();
break;
default:
displayDefaultScreen();
// just for debugging, lets see why we got here
echo 'we are displaying the default screen for a $_GET["action"] value of ' . $_GET['action'];
break;
}
}
else
{
displayDefaultScreen();
// this is just for debugging, to see if i'm right
if($result === false)
{
echo '$result was false, there is an issue with the sql statment being used';
}
else
{
echo '$result was true, so $_GET["action"] is not set';
}
}
chances are you weren't seeing anything because ither $result was not equal to true, or because $_GET['action'] was one of the following: not set, or not in the case you're testing against.
hope that helps
additionally, you'll see that i didn't supply the logic for the routines you'll need to write, but you methods or functions shouldn't be mutliple pages long, it makes it very hard to maintain the code.
if($result !== false && is_set($_GET["action"])
{
switch(tolower($_GET['acti
{
case 'edit':
createEditScreen($result);
break;
case 'update':
updateValues();
break;
case 'delete':
deleteValues();
break;
default:
displayDefaultScreen();
// just for debugging, lets see why we got here
echo 'we are displaying the default screen for a $_GET["action"] value of ' . $_GET['action'];
break;
}
}
else
{
displayDefaultScreen();
// this is just for debugging, to see if i'm right
if($result === false)
{
echo '$result was false, there is an issue with the sql statment being used';
}
else
{
echo '$result was true, so $_GET["action"] is not set';
}
}
chances are you weren't seeing anything because ither $result was not equal to true, or because $_GET['action'] was one of the following: not set, or not in the case you're testing against.
hope that helps
additionally, you'll see that i didn't supply the logic for the routines you'll need to write, but you methods or functions shouldn't be mutliple pages long, it makes it very hard to maintain the code.
sorry, the tolower should be a strtolower in the previous post - man, tryping code without a debugger - catches me sometimes.... there may be additional syntactial errors, but i think you'll get the gist of it
ASKER
ebosscher,
Thank you for your code, however I need a complete answer, PHP is not my forte`.
Thank you for your code, however I need a complete answer, PHP is not my forte`.
have u copied&pasted my code from 4 posts back yet? Should work "out of the box"?
ASKER
psimation,
Yes just did it this morning, awesome job :) The only issue I have is that the fields are out of alignment, i.e. the address is being displayed in the DOB field and the office field is not being written to. Not it the edit form but in the table when the page is loaded. I am trying to find the problem but haven't so far.
Yes just did it this morning, awesome job :) The only issue I have is that the fields are out of alignment, i.e. the address is being displayed in the DOB field and the office field is not being written to. Not it the edit form but in the table when the page is loaded. I am trying to find the problem but haven't so far.
ASKER
I fixed the fields so they display under the correct headings but the office field is not posting when you do a edit
ASKER
psimation,
I got it squared. It works great. Thanks again for yet another great job!
I got it squared. It works great. Thanks again for yet another great job!
if($_GET['action']=="edit"
$sqlSelectUser = "SELECT LastName, FirstName, Middle_Initial, DOB, Race, Sex, Address FROM users WHERE user_id = ".$_GET["user_id"];
/* $_GET["user_id"] is to be taken from the link where user click on their name to edit it. So that link would like look <a href="editpage.php?user_id
$rsSelectUser = $mysqli_query($db, $sqlSelectUser);
while ($rwUser = mysqli_fetch_array($rsSele
$defaults["LastName"]=$rwU
$defaults["FirstName"]=$rw
$defaults["Middle_Initial"
$defaults["DOB"] = $rwUser["DOB"];
$defaults["Race"]=$rwUser[
$defaults["Sex"]=$rwUser["
$defaults["Address"]=$rwUs
}
}
echo "
<form name=\"form1\" method=\"POST\" action=\"editdelete.php?ac
<table><tr>
<td align=center bgcolor=#EBEBEB>Last Name</td><td><input type=\"text\" name=\"strLastName\" value=".$defaults["LastNam
I added the above --> value=\"$ts\"></td></tr> at the end but it does not auto populate.
<tr><td align=center bgcolor=#EBEBEB>First Name</td><td><input type=\"text\" name=\"strFirstName\" value=".$defaults["FirstNa
<tr><td align=center bgcolor=#EBEBEB>MI</td><td
<tr><td align=center bgcolor=#EBEBEB>DOB</td><t
<tr><td align=center bgcolor=#EBEBEB>Race</td><
<tr><td align=center bgcolor=#EBEBEB>Sex</td><t
<tr><td align=center bgcolor=#EBEBEB>Address</t