paddyhaig Posted June 7, 2010 Share Posted June 7, 2010 I have a form that I would like to use to submit details to my database. Presently the form creates a list page with a couple of hyper links to other pages that allow me to edit and delete rows from the list. I would like it if it could all be done in the same page. I have created some form input fields in the header of the table. I would like it if the (AddUser) link where to submit the data in the fields to the database. Also if the (Edit) link is clicked the information would populate the same table header form fields as used above, and then when the (Submit) link is clicked the submitted data will be submitted to the database. Here is the page so far: <?php require_once('../Connections/Example.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } mysql_select_db($database_Example, $Example); $query_rsAuth = "SELECT * FROM auth ORDER BY id ASC"; $rsAuth = mysql_query($query_rsAuth, $Example) or die(mysql_error()); $row_rsAuth = mysql_fetch_assoc($rsAuth); $totalRows_rsAuth = mysql_num_rows($rsAuth); ?> <?php include("admin_header.inc"); ?> <!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"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Example Edit staff member</title> <!-- This is both the external style sheet link and the internal style container --> <link href="../includes/primary_layout.css" rel="stylesheet" type="text/css" /> <!-- Begining of internal style container --> <style type="text/css"> #center_box { height: 223px; width: 626px; overflow:auto; padding: 0px; left: 139px; top: 110px; position: absolute; margin-top: -55px; margin-right: auto; margin-bottom: auto; margin-left: -65px; } </style> <!-- End of internal style container --> </head> <body> <div id="wrapper"> <div id="large-blue-box"> <div id="center_box"> <div id="form"> <div align="center"> <table width="90%" border="1" cellpadding="0" cellspacing="0"> <tr> <th colspan="7">* Indicates required field. Please delete and fill with appropriate info.</th> </tr> <tr> <th width="16%">Add/Remove</th> <th colspan="2">First/Last Names</th> <th colspan="2">Login/Password</th> <th width="20%">Privilege</th> <th width="6%">Edit</th> </tr> <tr> <td><div align="center"><a href="create_staff_member.php">(AddUser)</a></div></td> <!-- <th>id</th> --> <td width="10%"><div align="center"> <input name="forename" type="text" id="forename" value="*First " size="9" maxlength="15" /> </div></td> <td width="15%"><input name="surname" type="text" id="surname" value="*Last" size="9" maxlength="15" /></td> <td width="16%"><div align="center"> <input name="username" type="text" id="username" value="*Login" size="9" maxlength="15" /> </div></td> <td width="17%"><input name="password" type="text" id="password" value="*Pass" size="9" maxlength="15" /></td> <!-- <th>password</th> --> <td><div align="center"> <select name="priv" id="priv"> <option value="privilege">*Privilege</option> <option value="administrator">Administrator</option> <option value="manager">Manager</option> <option value="receptionist">Receptionist</option> </select> </div></td> <!-- <th>login_time</th> --> <!-- <th>logout_time</th> --> <td><div align="center">(Submit)</div></td> </tr> <?php do { ?> <tr> <td><div align="center"><a href="delete_user.php?id=<?php echo $row_rsAuth['id']; ?>">(Remove)</a></div></td> <!-- <td><?php $row_rsAuth['id']; ?></td> --> <td colspan="2"><div align="center"><?php echo $row_rsAuth['first_name']; ?> <?php echo $row_rsAuth['last_name']; ?></div> <div align="center"></div></td> <td colspan="2"><div align="center"><?php echo $row_rsAuth['login']; ?></div></td> <!-- <td><?php $row_rsAuth['password']; ?></td> --> <td><div align="center"><?php echo $row_rsAuth['privilege']; ?></div></td> <!-- <td><?php $row_rsAuth['login_time']; ?></td> --> <!-- <td><?php $row_rsAuth['logout_time']; ?></td> --> <td><div align="center"><a href="form_update.php?id=<?php echo $row_rsAuth['id']; ?>">(Edit)</a>*</div></td> </tr> <?php } while ($row_rsAuth = mysql_fetch_assoc($rsAuth)); ?> </table> </div> </div> <p align="center"> </p> </div> <div id="form11"><a href="staff_management.php"><img src="../graphics/general/index_button.gif" width="180" height="28" /></a> </div> </div> <?php include("../includes/footer.inc"); ?> </div> </body> </html> <?php mysql_free_result($rsAuth); ?> Quote Link to comment Share on other sites More sharing options...
paddyhaig Posted June 7, 2010 Author Share Posted June 7, 2010 Can this be done? I would like all the actions to take place on the same page? edit_staff_member.php <?php require_once('../Connections/Example.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } mysql_select_db($database_Example, $Example); $query_rsAuth = "SELECT * FROM auth ORDER BY id ASC"; $rsAuth = mysql_query($query_rsAuth, $Example) or die(mysql_error()); $row_rsAuth = mysql_fetch_assoc($rsAuth); $totalRows_rsAuth = mysql_num_rows($rsAuth); ?> <?php include("admin_header.inc"); ?> <!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"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Example Edit staff member</title> <!-- This is both the external style sheet link and the internal style container --> <link href="../includes/primary_layout.css" rel="stylesheet" type="text/css" /> <!-- Begining of internal style container --> <style type="text/css"> #center_box { height: 223px; width: 626px; overflow:auto; padding: 0px; left: 139px; top: 110px; position: absolute; margin-top: -55px; margin-right: auto; margin-bottom: auto; margin-left: -65px; } </style> <!-- End of internal style container --> </head> <body> <div id="wrapper"> <div id="large-blue-box"> <div id="center_box"> <div id="form"> <div align="center"> <table width="90%" border="1" cellpadding="0" cellspacing="0"> <tr> <th colspan="7">* Indicates required field. Please delete and fill with appropriate info.</th> </tr> <tr> <th width="16%">Add/Remove</th> <th colspan="2">First/Last Names</th> <th colspan="2">Login/Password</th> <th width="20%">Privilege</th> <th width="6%">Edit</th> </tr> <tr> <td><div align="center"><a href="create_staff_member.php">(AddUser)</a></div></td> <!-- <th>id</th> --> <td width="10%"><div align="center"> <input name="forename" type="text" id="forename" value="*First " size="9" maxlength="15" /> </div></td> <td width="15%"><input name="surname" type="text" id="surname" value="*Last" size="9" maxlength="15" /></td> <td width="16%"><div align="center"> <input name="username" type="text" id="username" value="*Login" size="9" maxlength="15" /> </div></td> <td width="17%"><input name="password" type="text" id="password" value="*Pass" size="9" maxlength="15" /></td> <!-- <th>password</th> --> <td><div align="center"> <select name="priv" id="priv"> <option value="privilege">*Privilege</option> <option value="administrator">Administrator</option> <option value="manager">Manager</option> <option value="receptionist">Receptionist</option> </select> </div></td> <!-- <th>login_time</th> --> <!-- <th>logout_time</th> --> <td><div align="center">(Submit)</div></td> </tr> <?php do { ?> <tr> <td><div align="center"><a href="delete_user.php?id=<?php echo $row_rsAuth['id']; ?>">(Remove)</a></div></td> <!-- <td><?php $row_rsAuth['id']; ?></td> --> <td colspan="2"><div align="center"><?php echo $row_rsAuth['first_name']; ?> <?php echo $row_rsAuth['last_name']; ?></div> <div align="center"></div></td> <td colspan="2"><div align="center"><?php echo $row_rsAuth['login']; ?></div></td> <!-- <td><?php $row_rsAuth['password']; ?></td> --> <td><div align="center"><?php echo $row_rsAuth['privilege']; ?></div></td> <!-- <td><?php $row_rsAuth['login_time']; ?></td> --> <!-- <td><?php $row_rsAuth['logout_time']; ?></td> --> <td><div align="center"><a href="form_update.php?id=<?php echo $row_rsAuth['id']; ?>">(Edit)</a>*</div></td> </tr> <?php } while ($row_rsAuth = mysql_fetch_assoc($rsAuth)); ?> </table> </div> </div> <p align="center"> </p> </div> <div id="form11"><a href="staff_management.php"><img src="../graphics/general/index_button.gif" width="180" height="28" /></a> </div> </div> <?php include("../includes/footer.inc"); ?> </div> </body> </html> <?php mysql_free_result($rsAuth); ?> When you click on (Edit) it goes to this page: form_update.php <?php require_once('../Connections/Example.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) { $updateSQL = sprintf("UPDATE auth SET first_name=%s, last_name=%s, login=%s, password=%s, privilege=%s, login_time=%s, logout_time=%s WHERE id=%s", GetSQLValueString($_POST['first_name'], "text"), GetSQLValueString($_POST['last_name'], "text"), GetSQLValueString($_POST['login'], "text"), GetSQLValueString($_POST['password'], "text"), GetSQLValueString($_POST['privilege'], "text"), GetSQLValueString($_POST['login_time'], "date"), GetSQLValueString($_POST['logout_time'], "date"), GetSQLValueString($_POST['id'], "int")); mysql_select_db($database_Example, $Example); $Result1 = mysql_query($updateSQL, $Example) or die(mysql_error()); $updateGoTo = "edit_staff_member.php"; if (isset($_SERVER['QUERY_STRING'])) { $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?"; $updateGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $updateGoTo)); } $colname_rsAuth = "-1"; if (isset($_GET['id'])) { $colname_rsAuth = $_GET['id']; } mysql_select_db($database_Example, $Example); $query_rsAuth = sprintf("SELECT * FROM auth WHERE id = %s", GetSQLValueString($colname_rsAuth, "int")); $rsAuth = mysql_query($query_rsAuth, $Example) or die(mysql_error()); $row_rsAuth = mysql_fetch_assoc($rsAuth); $totalRows_rsAuth = mysql_num_rows($rsAuth); ?> <!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"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Edit User</title> </head> <body> <form id="form1" name="form1" method="POST" action="<?php echo $editFormAction; ?>"> <p> <input name="id" type="hidden" id="id" value="<?php echo $row_rsAuth['id']; ?>" /> </p> <p>first_name <input name="first_name" type="text" id="first_name" value="<?php echo $row_rsAuth['first_name']; ?>" /> </p> <p>last_name <input name="last_name" type="text" id="last_name" value="<?php echo $row_rsAuth['last_name']; ?>" /> </p> <p>login <input name="login" type="text" id="login" value="<?php echo $row_rsAuth['login']; ?>" /> </p> <p> password <input name="password" type="password" id="password" value="<?php echo $row_rsAuth['password']; ?>" /> </p> <p> privilege <select name="privilege" id="privilege"> <option value="receptionist" <?php if (!(strcmp("receptionist", $row_rsAuth['privilege']))) {echo "selected=\"selected\"";} ?>>Receptionist</option> <option value="suspended" <?php if (!(strcmp("suspended", $row_rsAuth['privilege']))) {echo "selected=\"selected\"";} ?>>Suspended</option> <option value="manager" <?php if (!(strcmp("manager", $row_rsAuth['privilege']))) {echo "selected=\"selected\"";} ?>>Manager</option> <option value="administrator" <?php if (!(strcmp("administrator", $row_rsAuth['privilege']))) {echo "selected=\"selected\"";} ?>>Administrator</option> <?php do { ?> <option value="<?php echo $row_rsAuth['privilege']?>"<?php if (!(strcmp($row_rsAuth['privilege'], $row_rsAuth['privilege']))) {echo "selected=\"selected\"";} ?>><?php echo $row_rsAuth['privilege']?></option> <?php } while ($row_rsAuth = mysql_fetch_assoc($rsAuth)); $rows = mysql_num_rows($rsAuth); if($rows > 0) { mysql_data_seek($rsAuth, 0); $row_rsAuth = mysql_fetch_assoc($rsAuth); } ?> </select> </p> <p> <input name="login_time" type="hidden" id="login_time" value="<?php echo $row_rsAuth['login_time']; ?>" /> </p> <p> <input name="logout_time" type="hidden" id="logout_time" value="<?php echo $row_rsAuth['logout_time']; ?>" /> </p> <p align="center"> <input type="submit" name="submit" id="submit" value="Submit" /> </p> <input type="hidden" name="MM_update" value="form1" /> </form> <p> </p> </body> </html> <?php mysql_free_result($rsAuth); ?> When you click on the (Remove) link it removes the specified row and brings you right back to the original list/form page minus the row you just deleted. Here is the script it uses below: delete_user.php <?php require_once('../Connections/Example.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } if ((isset($_GET['id'])) && ($_GET['id'] != "")) { $deleteSQL = sprintf("DELETE FROM auth WHERE id=%s", GetSQLValueString($_GET['id'], "int")); mysql_select_db($database_Example, $Example); $Result1 = mysql_query($deleteSQL, $Example) or die(mysql_error()); $deleteGoTo = "edit_staff_member.php"; if (isset($_SERVER['QUERY_STRING'])) { $deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?"; $deleteGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $deleteGoTo)); } ?> <!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"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Delete User</title> </head> <body> <p>No User to delete! </p> <p><a href="edit_staff_member.php">Go Back?</a></p> <p> </p> </body> </html> What I am trying to do is compact all the above onto one page coded in a logical and efficient way. Please help if you can? Quote Link to comment Share on other sites More sharing options...
paddyhaig Posted June 7, 2010 Author Share Posted June 7, 2010 I almost forgot. This page is used to submit to the same db list. create_staff_member.php <?php require_once('../Connections/Example.php'); ?> <?php if (!function_exists("GetSQLValueString")) { function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") { if (PHP_VERSION < 6) { $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue; } $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue); switch ($theType) { case "text": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "long": case "int": $theValue = ($theValue != "") ? intval($theValue) : "NULL"; break; case "double": $theValue = ($theValue != "") ? doubleval($theValue) : "NULL"; break; case "date": $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL"; break; case "defined": $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue; break; } return $theValue; } } $editFormAction = $_SERVER['PHP_SELF']; if (isset($_SERVER['QUERY_STRING'])) { $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']); } if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form6")) { $insertSQL = sprintf("INSERT INTO auth (first_name, last_name, login, password, privilege) VALUES (%s, %s, %s, %s, %s)", GetSQLValueString($_POST['forename'], "text"), GetSQLValueString($_POST['surname'], "text"), GetSQLValueString($_POST['login'], "text"), GetSQLValueString($_POST['password'], "text"), GetSQLValueString($_POST['priviege'], "text")); mysql_select_db($database_Example, $Example); $Result1 = mysql_query($insertSQL, $Example) or die(mysql_error()); $insertGoTo = "edit_staff_member.php"; if (isset($_SERVER['QUERY_STRING'])) { $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?"; $insertGoTo .= $_SERVER['QUERY_STRING']; } header(sprintf("Location: %s", $insertGoTo)); } mysql_select_db($database_Example, $Example); $query_Recordset1 = "SELECT * FROM auth"; $Recordset1 = mysql_query($query_Recordset1, $Example) or die(mysql_error()); $row_Recordset1 = mysql_fetch_assoc($Recordset1); $totalRows_Recordset1 = mysql_num_rows($Recordset1); ?> <!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"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Edit User Details</title> <style type="text/css"> th { color: #FFF; } </style> </head> <body> <div align="center"> <p> </p> <form id="form6" name="form6" method="POST" action="<?php echo $editFormAction; ?>"> <table width="234" border="1" cellpadding="0" cellspacing="0"> <tr bgcolor="#283a86"> <th width="95" scope="row">First Name </th> <td width="133"><input name="forename" type="text" id="forename" size="19" /></td> </tr> <tr bgcolor="#283a86"> <th scope="row">Last Name</th> <td><input name="surname" type="text" id="surname" size="19" /></td> </tr> <tr bgcolor="#283a86"> <th scope="row">User Name</th> <td><input name="login" type="text" id="login" size="19" /></td> </tr> <tr bgcolor="#283a86"> <th scope="row">Password</th> <td><input name="password" type="password" id="password" size="19" /></td> </tr> <tr bgcolor="#283a86"> <th scope="row">Privilege</th> <td><select name="priviege" id="priviege"> <option value="receptionist">Receptionist</option> <option value="manager">Manager</option> <option value="administrator">Administrator</option> <option value="suspended">Suspended</option> </select></td> </tr> </table> <p> <input type="submit" name="submit" id="submit" value="Submit" /> <input type="hidden" name="MM_insert" value="form6" /> </form> </p> </div> </body> </html> <?php mysql_free_result($Recordset1); ?> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.