Jump to content

Search the Community

Showing results for tags 'html php mysqli'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • W3Schools
    • General
    • Suggestions
    • Critiques
  • HTML Forums
    • HTML/XHTML
    • CSS
  • Browser Scripting
    • JavaScript
    • VBScript
  • Server Scripting
    • Web Servers
    • Version Control
    • SQL
    • ASP
    • PHP
    • .NET
    • ColdFusion
    • Java/JSP/J2EE
    • CGI
  • XML Forums
    • XML
    • XSLT/XSL-FO
    • Schema
    • Web Services
  • Multimedia
    • Multimedia
    • FLASH

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests


Languages

Found 1 result

  1. Hi, I have spent hours on this and not figured it out. researched online extensively, and I'm sure I'm not the first one , but I haven't been able to figure it out. Help please? I have an action_page1.php script. I have an html contact form. I have a msqli db setup. The form looks ok on the html in the browser. The form seems to work alright when I enter the information, in so much that it seems to take the info and spit out a the return screen that says: "Connection to server successfully established. New record created successfully. Last inserted ID is: 9First Name: Last Name: Phone: Address: City: State: Zip: Email Address: Country: Comments: Subscribe to Mailing List?: Error connecting to database." Issues: 1. I don't know why it says "Error" connecting to database" at the end. huh? I know I programmed it in there, but I'm not sure why it's showing up there if the top says it's fine?! 2. How do I get the 'First Name" to sit under the ID instead of next to it? 3. When I go to see the record in the database, it is empty...why? here is a snap shot of what the records looks like: https://drive.google.com/open?id=1gPZEosBsouyo5hrkI_u4ZzB5Xanh35Vr 4. Why are the fields in the returned screen above, empty also? here is the script file: "<?php $host_name = "db......."; $database = "db......"; $user_name = "db......"; $password = ".........."; $connect = mysqli_connect($host_name, $user_name, $password, $database); if(mysqli_connect_errno()) { echo '<p>Failed to connect to Server: '.mysqli_connect_error().'</p>'; } else { echo '<p>Connection to server successfully established.</p>'; } $mysqli = "INSERT INTO contactpage (first_name, last_name, phone_number, address, city, state, zip, country, email_address, comments, join_mailing_list) VALUES ('$first_name','$last_name','$phone_number','$address','city','state','zip','$country','$email_address', '$comments','$join_mailing_list')"; if ($connect->query($mysqli) === TRUE) { $last_id = $connect->insert_id; echo "New record created successfully. Last inserted ID is: " . $last_id; } else { echo "Error: " . $mysqli . "<br>" . $connect->error; } // define variables and set to empty values $first_name = $_POST['first_name']; $last_name = $_POST['last_name']; $phone_number = $_POST['phone_number']; $address = $_POST['address']; $city = $_POST['city']; $state = $_POST['state']; $zip = $_POST['zip']; $email_address = $_POST['email_address']; $country = $_POST['country']; $comments = $_POST['comments']; $join_mailing_list = $_POST['join_mailing_list']; $first_nameErr = $last_nameErr = $phone_numberErr = $addressErr = $cityErr = $stateErr = $zipErr = $countryErr = $email_addressErr = $commentsErr = $join_mailing_listErr = ""; $email = "............."; $emailSubject = "test"; $headers = "From:$emailaddress\r\n"; $headers .= "Content-type: text/html\r\n"; $body = <<<EOD <br><hr><br> First Name : $first_name <br> Last Name : $last_name <br> Phone Number : $phone_number <br> Address : $address <br> City : $city <br> State : $state <br> Zip : $zip <br> Country : $country <br> Email Address : $email_address <br> Comments : $comments <br> Subscribe to Mailing List : $join_mailing_list <br> EOD; $success = mail($email, $emailSubject, $body, $headers); $theResults = <<<EOD "Thank you. Your message has been sent and you will be contacted soon" echo "<br>"; echo "<h2>Your Input:</h2>"; echo $first_name; echo "<br>"; echo $last_name; echo "<br>"; echo $phone_number; echo "<br>"; echo $address; echo "<br>"; echo $city; echo "<br>"; echo $state; echo "<br>"; echo $zip; echo "<br>" echo $country; echo "<br>"; echo $email_address; echo "<br>"; echo $comments; echo "<br>"; echo $join_mailing_list; echo "<br>"; EOD; echo "First Name: " . $first_name . "<br>"; echo "Last Name: " . $last_name . "<br>"; echo "Phone: " . $phone_number . "<br>"; echo "Address: " . $address . "<br>"; echo "City: " . $city . "<br>"; echo "State: " . $state . "<br>"; echo "Zip: " . $zip . "<br>"; echo "Email Address: " . $email_address . "<br>"; echo "Country: " . $country . "<br>"; echo "Comments: " . $comments . "<br>"; echo "Subscribe to Mailing List?: " . $join_mailing_list . "<br>"; $db = mysqli_connect("localhost","db..........","........."); if(!$db) die("Error connecting to database."); mysqli_select_db("db.........." ,$db); $mysqli = "INSERT INTO contactpage (first_name, last_name, phone_number, address, city, state, zip, country, email_address, comments, join_mailing_list) VALUES (". PrepmySQLi($varfirst_name) . ", " . PrepmySQLi($varlast_name) . ", " . PrepmySQLi($varphone_number) . ", " . PrepmySQLi($varaddress) . ", " . PrepmySQLi($varcity) . ", " . PrepmySQLi($varstate) . ", " . PrepmySQLi($varzip) . ", " . PrepmySQLi($varcountry) . ", " . PrepmySQLi($varemail_address) . ", " . PrepmySQLi($varcomments) . ", " . PrepSQL($varjoin_mailing_list) . ", " . mysqli_query($mysqli); if ($_SERVER["REQUEST_METHOD"] == "POST") { if (empty($_POST["first_name"])) { $first_nameErr = "First name is required"; } else { $first_name = test_input($_POST["first_name"]); if (!preg_match("/^[a-zA-Z ]*$/",$first_name)) { $first_nameErr = "Only letters and white space allowed"; } } if (empty($_POST["last_name"])) { $last_nameErr = "Last name is required"; } else { $last_name = test_input($_POST["last_name"]); if (!preg_match("/^[a-zA-Z ]*$/",$last_name)) { $last_nameErr = "Only letters and white space allowed"; } } if (empty($_POST["phone_number"])) { $phone_numberErr = "Please enter a phone number"; } else { $phone_number = test_input($_POST["phone_number"]); } if (empty($_POST["address"])) { $addressErr = "Address is required"; } else { $address = test_input($_POST["address"]); } if (empty($_POST["city"])) { $cityErr = "City is required"; } else { $city = test_input($_POST["city"]); } if (empty($_POST["state"])) { $stateErr = "State is required"; } else { $state = test_input($_POST["state"]); } if (empty($_POST["zip"])) { $zipErr = "Zip is required"; } else { $zip = test_input($_POST["zip"]); } if (empty($_POST["country"])) { $countryERR = "please enter your country"; } else { $country = test_input($_POST["country"]); } if (empty($_POST["email_address"])) { $email_addressErr = "Email is required"; } else { $email_address = test_input($_POST["email_address"]); if (!filter_var($email_address, FILTER_VALIDATE_EMAIL)) { $email_addressErr = "Invalid email format"; } } if (empty($_POST["comments"])) { $comments = ""; } else { $comments = test_input($_POST["comments"]); } if (empty($_POST["join_mailing_list"])) { $join_mailing_listErr = "requres a yes or no"; } else { $join_mailing_list = test_input($_POST["join_mailing_list"]); } function test_input($data) { $data = trim($data); $data = stripslashes($data); $data = htmlspecialchars($data); return $data; } if($_POST['formSubmit'] == "Submit") { $varfirst_name = $_POST['first_name']; $varlast_name = $_POST['last_name']; $varphone_number = $_POST['phone_number']; $varaddress = $_POST['address']; $varcity = $_POST['city']; $varstate = $_POST['state']; $varzip = $_POST['zip']; $varcountry = $_POST['country']; $varemail_address = $_POST['email_address']; $varcomments = $_POST['comments']; $varjoin_mailing_list = $_POST['join_mailing_list']; $errorMessage = ""; // - - - snip - - - } echo "$theResults"; } $connect->close(); ?>" Thanks for any help you can offer!
×