Trying to insert a PHP form into SQL

Question

Some of the code in this problem can be kind of long so I will try to pinpoint where I think the problem lies. The one issue I am having is I am not sure how to tell where the code is failing. All I have is an either it loads or it doesn't. Right now it just doesn't load without any reason why.

First I will show my form code:

function show_form($messages) {         


        // Assign post values if exist
        $username="";
        $password="";
        $firstname="";
        $lastname="";
        $address="";
        $city="";
        $state="";
        $zip="";
        $phone="";
        $card_number="";
        $expire="";
        $code="";
        $product_name="";
        if (isset($_POST["username"]))
          $username=$_POST["username"];
        if (isset($_POST["password"]))
          $password=$_POST["password"];   
        if (isset($_POST["firstname"]))
          $firstname=$_POST["firstname"];  
        if (isset($_POST["lastname"]))
          $lastname=$_POST["lastname"];
        if (isset($_POST["address"]))
          $address=$_POST["address"];     
        if (isset($_POST["city"]))
          $city=$_POST["city"];  
        if (isset($_POST["state"]))
          $state=$_POST["state"];
        if (isset($_POST["zip"]))
          $zip=$_POST["zip"];     
        if (isset($_POST["phone"]))
          $phone=$_POST["phone"];  
        if (isset($_POST["card_number"]))
          $card_number=$_POST["card_number"];
        if (isset($_POST["expire"]))
          $expire=$_POST["expire"];   
        if (isset($_POST["code"]))
          $code=$_POST["code"];  
        if (isset($_POST["product_name"]))
          $product_name=$_POST["product_name"];

    echo "";
    echo " Enter New Customers Data";
    echo "";     
    ?>
    Complete the information in the form below and click Submit to create your account. All fields are required.
        

  Username:

  

  Last name:

  

  Street Address:

  

  First name:

  

  Last name:

  

  Street Address:

  

  City:

  

  

  
  

  

  Zipcode:

  


   Visa

   MasterCard

   American Express

   Discover

   Pay Pal


  Phone Number:

  

  Credit Card Number:

  

  Expiration Date (Mon/Year):

  

  Security Code:

I never had a problem with the above code I am just providing it to show you what I am working with. Next I will show you some of the code that I added which gave me problems later. I know I should of just did a small bit at a time but I screwed that up.

Thank you for shopping with us! ";         
    }
    else 
    {
        echo "A customer account with that username already exists. ";         
    }   
  }

 function countCustomer ($customer)
  {          
    // Connect to the database
   $mysqli = connectdb();
   $firstname = $customer->getFirstname();
   $lastname = $customer->getLastname();
   $username = $->getUsername();


        // Connect to the database
    $mysqli = connectdb();

    // Define the Query
    // For Windows MYSQL String is case insensitive
     $Myquery = "SELECT count(*) as count from Customer
           where username='$username'";  

     if ($result = $mysqli->query($Myquery)) 
     {
        /* Fetch the results of the query */         
        while( $row = $result->fetch_assoc() )
        {
          $count=$row["count"];                                           
        }    

        /* Destroy the result set and free the memory used for it */
        $result->close();         
   }

    $mysqli->close();   

    return $count;

  }

  function insertCustomer ($customer)
  {

        // Connect to the database
   $mysqli = connectdb();


   $firstname = $customer->getFirstname();
   $lastname = $customer->getLastname();
   $username = $->getUsername();

        // Add Prepared Statement
        $Query = "INSERT INTO Customer 
             (username,password,firstName,lastName,address,city,state,zip,phone,card_number,expire,code,product_name) 
               VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)";


        $stmt = $mysqli->prepare($Query);

$stmt->bind_param("sssssssiiiiis", $username, $password, $firstname, $lastname, $city, $state, $zip, $phone, $card_number, $expire, $code, $product_name);
$stmt->execute();



    $stmt->close();
    $mysqli->close();

        return true;
    }

I know this is a lot of code to put out there for help but I have no way of finding a way to pinpoint the error. If anyone knows of anywhere I can put this code that will display errors that may help. I tried using W3C Validation. However, it told me I could not use it on nonpublic domains.

Here is some more of the code:

class StudentClass
{
    // property declaration
    private $username="";
    private $password="";
    private $firstname="";
    private $lastname="";
    private $address="";
    private $city="";   
    private $state="";
    private $zip="";
    private $phone="";
    private $card_number="";
    private $expire="";
    private $code="";
    private $product_name="";


    // Constructor
    public function __construct($username,$password,$firstname,$lastname,$address,$city,$state,$zip,$phone,$card_number,$expire,$code,$product_name)
    {
      $this->username = $username;
      $this->password = $password;
      $this->firstname = $firstname;
      $this->lastname = $lastname;
      $this->address = $address;
      $this->city = $city;
      $this->state = $state;
      $this->zip = $zip;
      $this->phone = $phone;
      $this->card_number = $card_number;
      $this->expire = $expire;
      $this->code = $code;
      $this->product_name = $product_name;

    }

    // Get methods 
      public function getUsername ()
    {
        return $this->username;
    } 
      public function getPassword ()
    {
        return $this->password;
    } 
      public function getFirstname ()
    {
        return $this->firstname;
    } 
      public function getLastname ()
    {
        return $this->lastname;
    } 
      public function getAddress ()
    {
        return $this->address;
    } 
      public function getCity ()
    {
        return $this->city;
    } 
      public function getState ()
    {
        return $this->state;
    } 
      public function getZip ()
    {
        return $this->zip;
    } 
      public function getPhone ()
    {
        return $this->phone;
    } 
      public function getCardNumber ()
    {
        return $this->card_number;
    } 
      public function getExpire ()
    {
        return $this->expire;
    } 
      public function getCode ()
    {
        return $this->code;
    } 
      public function getProductName ()
    {
        return $this->product_name;
    } 


    // Set methods 
    public function setusername ($value)
    {
        $this->username = $value;       
    }
    public function setPassword ($value)
    {
        $this->password = $value;       
    }
    public function setFirstname ($value)
    {
        $this->firstname = $value;      
    }
    public function setLastname ($value)
    {
        $this->lastname = $value;       
    }
    public function setAddress ($value)
    {
        $this->address = $value;        
    }
    public function setCity ($value)
    {
        $this->city = $value;       
    }     
    public function setState ($value)
    {
        $this->state = $value;      
    }
    public function setZip ($value)
    {
        $this->zip = $value;        
    }
    public function setPhone ($value)
    {
        $this->phone = $value;      
    }
    public function setCardNumber ($value)
    {
        $this->card_number = $value;        
    }
    public function setExpire ($value)
    {
        $this->Expire = $value;     
    }
    public function setCode ($value)
    {
        $this->code = $value;       
    }
    public function setProductName ($value)
    {
        $this->product_name = $value;       
    }  
} // End Studentclass

?>

Any help or insight would be appreciated. Thanks

Trying to insert a PHP form into SQL

Answers (1)

Related Questions