$lname = $db->sanitizeInput($_POST['lastname']); $email = $db->sanitizeInput($_POST['email']); $phonenum = $db->sanitizeInput($_POST['phonenumber']); $username = $_SESSION['valid_user']; //$teams_checked = sanitize_input_for_db($_POST['team']); $password = sha1($_POST['password']); $address = $db->sanitizeInput($_POST['address']); $city = $db->sanitizeInput($_POST['city']); $state = $db->sanitizeInput($_POST['state']); $zip = $db->sanitizeInput($_POST['zip']); $table = 'member'; //check to see if password is entered echo "confirmed passwd: " . $_POST['confirm_password'] . "\n"; echo "passwd: " . $_POST['password']; if ($_POST['password'] == $_POST['confirm_password']) { $query = "UPDATE {$table} SET fname = '{$fname}', lname='{$lname}', password='******', phone_number='{$phonenum}', street='{$address}', city='{$city}', state='{$state}', zip='{$zip}' \r\n\t\tWHERE username='******'"; $result = $db->query($query); $message = "Your account had been updated successfully."; } else { $message = "Both password must be the same, Please try again"; } $db->closeConnection(); //diplay message $wp = new WebPages("NVC Account Update"); echo $wp->content_area_tag; $wp->displayLeftMenus(); $wp->displayContentFullWidthWithLeftMenu($message); $wp->displayFooter(); echo $wp->content_area_tag_end; echo $wp->wrapper_tag_end; echo $wp->body_tag_end;
<?php require_once 'nvd/initialize.php'; // ************************************************************ //create connection $ses_db = new MySQLDatabase('ses'); // find data // find students $ses_students = $ses_db->findAll('tblstudents'); // close connection $ses_db->closeConnection(); // *********************************************************** $db = new MySQLDatabase(); // insert students pr($ses_students); foreach ($ses_students as $ses_std) { // if($db->create($ses_std, 'pages') ){ // echo "<p>Created</p>"; // } }