function show_client_list_all() { $query = "SELECT ID,FName,MName,LName FROM clients ORDER BY LName,FName,MName"; $result = try_query($query); show_client_list_result($result); }
<?php // File: edit-client-result.php // Copyright (C) 2012 WoodDuck Computer Consulting include "./header.php"; get_globals(); my_connect(); echo "<H3>Edit Client</H3>\n"; // Fetch client ID from the FORM POST data $ID = $_POST['ID']; decho("Editing client ID '{$ID}' ... <BR>"); // Do a SELECT query to get the old client data $query = "SELECT ID,FName,MName,LName from clients WHERE ID = '{$ID}'"; $result = try_query($query); // Display it as an editable form, including the INPUT boxes echo "<FORM ACTION=\"./save-client.php\" METHOD=post>\n"; if (show_client_edit_form($result)) { // Display the form buttons only if the return value was TRUE echo "<P>" . "<INPUT TYPE=submit VALUE=\" SAVE edited client data \"><P>\n" . "<INPUT TYPE=reset VALUE=\" Reset to original client data \"><P>\n"; } else { echo "<P>Sorry, no results match Client ID '{$ID}'.<P>\n"; } echo "</FORM>\n"; my_disconnect(); ?> <P> <A HREF="./edit-client.php"><BUTTON TYPE=button> Edit another client </BUTTON></A><P> <A HREF="./main.php"><BUTTON TYPE=button> Return to main page </BUTTON></A><P> <A HREF="./logout.php"><BUTTON TYPE=button> Logout </BUTTON></A>
$valid_me->validate('completed', $_POST['install_user_pass'], $validation_no_pass); //$valid_me->validate('completed',$_POST['install_user_repeat'],$validation_no_pass2); $valid_me->validate('email', $got_admin_email, $validation_invalid_mail); $valid_me->validate('length', $_POST['install_user_pass'], $validation_length_pass, MIN_USER_CHARS, MAX_USER_CHARS); $valid_me->validate('password', $_POST['install_user_pass'], $validation_alpha_pass); //$valid_me->validate('pass_match','',$validation_match_pass,'','',$_POST['install_user_pass'],$_POST['install_user_repeat']); if ($valid_me->return_val) { /** * Call the file that creates the tables and fill it with the data we got previously */ define('TRY_INSTALL', true); include_once ROOT_DIR . '/install/database.php'; /** * Try to execute each query individually */ try_query($install_queries); /** * Continue based on the value returned from the above function */ if (!empty($error_str)) { $query_state = 'err'; } else { $query_state = 'ok'; } } } ?> <?php if (isset($valid_me)) { /** If the form was submited with errors, show them here */
function show_client_list_all() { $query = "SELECT SID,sname,school FROM Students ORDER BY sname"; $result = try_query($query); show_client_list_result($result); }