Please enter your email address
'; } else { $email = trim(strip_tags($_POST['email'])); // Strip HTML and potentially dangerous scripts } // Execute if there are no problems with the form if (!$problem) { // Retrieve username from supplied email address $query = "SELECT username, companyid FROM Client WHERE email = '".$email."'"; $r = pg_query($dbc,$query); // Run the query // If email address is not on file if (pg_num_rows($r) < 1) { print $form.'We are unable to match a username to your email address. Please contact us by phone on 0800 GPS 001 or via email at admin@precisiontracking.co.nz
.'; } // If email address has a username ... else { // Prepare to email username while ($row = pg_fetch_array($r)) { $username = $row['username']; $company_id = $row['companyid']; // Construct HTML email message $html_message = 'Precision Tracking received a request to send your username to you.
Your username is '.$username.'.
If you experience any difficulties, or you did not request your username to be sent to you, please do not hesitate to contact us by phone on 0800 GPS 001 or via email at admin@precisiontracking.co.nz. '; // Insert email send details into email_outbox table where it will automatically be sent $email_query = "INSERT INTO email_outbox ( src_address, dest_address, company_id, subject, text_message, html_message ) VALUES ( 'info@precisiontracking.co.nz','$email','$company_id','Your username','','$html_message')"; $email_insert = pg_query($dbc, $email_query); if (pg_affected_rows($email_insert) == 1) { // Success message for screen print '
Your username has been emailed to '; print $email; print '.
If you experience any difficulties, please do not hesitate to contact us.
'; } else { print 'We are unable to retreive your username at the moment. Please contact us by phone on 0800 GPS 001 or via email at admin@precisiontracking.co.nz.
'; } } // End while } } // No problem! } // End of form submission IF. else // Print form as user has loaded page for first time { print $form; } ?>