Ampboy
-
Posts
4 -
Joined
-
Last visited
Everything posted by Ampboy
-
I have something that I cannot get to work.. The code I usually use uses INSERT and not UPDATE and has the user fill out all the fields. What I have now is a form where the user updates their PIN and email address. I have the update working. I just need to figure out how to get an email to the admin and to the end user based on where they are located Here is what I have: $dbhost = "localhost"; $dbname = "jimkoons_freshstart"; $dbuser = "jimkoons_start"; $dbpass = "Koons123"; $conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass); $sql = "Update Customers SET Email = :Email WHERE PIN = :PIN"; $stmt = $conn->prepare($sql); $stmt->bindValue(':PIN', $_POST['PIN'], PDO::PARAM_STR); $stmt->bindValue(':Email', $_POST['Email'], PDO::PARAM_STR); header("Location: http://koonsfreshstart.com/thank-you"); $stmt->execute(); Here is the snippet I use to email based on location in previous applications $STH->bindValue(':PIN', $_POST['PIN']); $STH->bindValue(':FirstName', $_POST['First']); $STH->bindValue(':LastName', $_POST['Last']); $STH->bindValue(':Email', $_POST['Email']); try { // Retrieve the user's name and associated list items $sql = "SELECT * FROM Customers WHERE PIN = PIN"; $stmt = $conn->prepare($sql); // Prepare the statement if($stmt->execute(array($_POST['PIN']))) { // Loop through the returned results while($row = $stmt->fetch()) { // Save the Store name $PIN = $row['PIN']; // Create an array of items $items[] = $row['PIN']; } $stmt->closeCursor(); // Free memory used in this query $first = $_POST["first"]; $last = $_POST["last"]; $email = $_POST["email"]; $PIN = $_POST['PIN']; switch ($PIN) { case "East": $to = "[email protected]"; $subject = "Mail"; $message = "$first $last Email Address: $email"; $user = "$email"; $usersubject = "Thank You for your submission"; $userheaders = "From: [email protected]\n"; $usermessage = "Thank you for submitting your information. We will be contacting you soon with more information on a customized extended service agreement for your vehicle. We look forward to working with you!"; mail($to,$subject,$message,$headers); mail($user,$usersubject,$usermessage,$userheaders); header("Location: http://mail.com/second/"); break; etc... Any help on making this work would be appreciated.. It is showing any errors, but it is not redirecting or emailing any of the data. Thanks for your help!
-
-
Thank you for the quick reply. I truly appreciate it. Not sure what you mean about the business from presentation... Can you expand? Not looking for a band-aid fix per se, but trying to learn what I am doing. I will take your advice and work on a re-write based on thoughts you may have
-
I am a newbie to php.. Used to do work in Cold Fusion and I cannot figure out what I am doing with a registration page I have created. I am looking to have the page insert into two databases, which it is doing, and then redirect to the main member's page. I have been looking for something and have not found anything here or online that works for me. I understand that you cannot use header() after any type of html or echo, but I have tried .js and other methods. I am not throwing errors, just no redirect... Also I am interested in hearing how bad my code is... any positive criticism is appreciated, as I am still learning Here is my code: <?php include("dbc.php"); ?> <!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> <title>Registration Page</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <link rel="stylesheet" href="style.css" type="text/css" charset="utf-8"> <link rel="stylesheet" href="styles.css" type="text/css" charset="utf-8"> //Some Javascript... </script> </head> <body> //Some Styling... <!-- content goes here --> <h1>Register</h1> <?php ob_start(); error_reporting(0); $_POST = array_map('secure', $_POST); if($_POST['submit']) { $user_name = mysql_real_escape_string($_POST['user_name']); $query = mysql_query("SELECT * FROM xxxxusers WHERE user_name='$user_name'"); $query = mysql_query("SELECT * FROM xxxusers WHERE user_name='$user_name'"); if(mysql_num_rows($query) != 0) { echo "<div style="font-size: 9pt; font-weight: bold;color: red;">Username already exists</div>"; } else { $user_password = mysql_real_escape_string($_POST['user_password']); $user_pass = mysql_real_escape_string($_POST['user_pass']); $user_email = $_POST['user_email']; $query = mysql_query("SELECT * FROM xxxxusers WHERE user_email='$user_email'"); $query = mysql_query("SELECT * FROM xxxusers WHERE user_email='$user_email'"); if(mysql_num_rows($query) != 0) { echo "<div style="font-size: 9pt; font-weight: bold;color: red;">Email already exists</div>"; } else { $enc_password = md5($user_password); $enc_password = md5($user_pass); if($user_name && $user_password && $user_pass && $user_email) { if (strlen($user_name)>20) { echo "<div style="font-size: 9pt; font-weight: bold;color: red;">Your Name is Too Long</div>"; } $email = htmlspecialchars($_POST['user_email']); if (!preg_match("/([\w\-]+\@[\w\-]+\.[\w\-]+)/",$email)) { echo "<div style="font-size: 9pt; font-weight: bold;color: red;">E-mail address not valid</div>"; } { require "dbc.php"; mysql_query("INSERT INTO xxxxusers stuff....) VALUES(stuff....) ") or die(mysql_error()); mysql_query("INSERT INTO xxxusers stuff....) VALUES(stuff....) ") or die(mysql_error()); } } else echo "<div style="font-size: 9pt; font-weight: bold;color: red;">All Fields Are Required</div>"; } } } ob_end_flush(); ?> <form action="register.php" method="post"> <table align="left" border="0" cellspacing="0" cellpadding="3"> <tr> <td>Username:</td> <td><input type="text" name="user_name" maxlength="30" value="<?php echo "$user_name"; ?>"></td> </tr> <tr> <td>Password:</td> <td><input type="password" name="user_password" maxlength="30" value=""></td> </tr> <tr> <td>Confirm password:</td> <td><input type="password" name="user_pass" maxlength="30" value=""></td> </tr> <tr> <td>Email address:</td> <td><input type="text" name="user_email" maxlength="50" value=""<?php echo "$user_email"; ?>""></td </tr> <tr><td colspan="2" align="right"> <input type="submit" value="Register!" id="submit" name="submit"></td></tr> <tr><td colspan="2" align="left"><a href="index.php">Back to Home Page</a></td></tr> </table> </form>