Jump to content

Caladan

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Posts posted by Caladan

  1. Hi everybody, I'm a real noob at php but i try to muddle through as best I can.
    Recently I had cause to make a webpage that includes a petition on it and i set it ut up like this.

    I have a webpage with multiple form fields on it, one for name, address, email and comment.
    I use php to connect to a mysql db that has all those fields in it and the script the checks if name and email exists, if they dont it inserts the form fields to a new entry, if they do exist it redirects to another page.

    My problem is I seem to mess up the checking of the two fields part. I thought I'd been clever and set it up so that it checks if both fields exits in a given row but users can not add just a name without and email adress.

    Any help here would be great, just keep in mind I am fairly new to php.

    I will include my code here:


    <?php

    include "./scripts/config.php";
    include "./scripts/opendb.php";


    if(isset($_POST['add']))
    {
    $conn = mysql_connect($dbhost,$dbuser,$dbpass) or die ('Error connecting to mysql');
    mysql_select_db($dbname,$conn) or die("Could not connect to db");

    $navn = $_POST['navn'];
    $adresse = $_POST['adresse'];
    $email = $_POST['email'];
    $kommentar = $_POST['kommentar'];

    $query = "SELECT * FROM $table WHERE navn = '$navn' OR email = '$email'";
    $result = mysql_query($query);
    $numR = mysql_num_rows($result);

    if($numR >= 1) {
    header('Location: [a href=\"http://www.somesite.com/denied.html');\" target=\"_blank\"]http://www.somesite.com/denied.html');[/a]
    }
    else {
    $query = "INSERT INTO $table (navn,adresse,email,kommentar) VALUES ('$navn','$adresse','$email','$kommentar')";
    mysql_query($query,$conn) or die('Error, insert query failed'.mysql_error());

    mysql_close();
    header('Location: [a href=\"http://www.somesite.com/thankyou.html');\" target=\"_blank\"]http://www.somesite.com/thankyou.html');[/a]
    }
    }

    After this i have another else statement that prints the form and such and after that there is a ?>
    So the code analyzer in zend studio tells me it should be well formatted.

    Caladan
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.