Loading
Doesnt save into my DB    
  •                                 class="form-group">    
  •                                     for="email">Email    
  •                                     "text" class="form-control" id="email" name="email" />    
  •                                     
  •                                 class="form-group">    
  •                                     for="passw">password    
  •                                     "passw" class="form-control" id="passw" name="passw" />    
  •                                     
  •                                 class="form-group">    
  •                                     for="num">Phone Number    
  •                                     "num" class="form-control" id="num" name="num" />    
  •                                     
  •                                 "submit" class="btn btn-primary">    
  •                                     
  •                                 
  •                             class="panel-footer text-right">    
  •                                 © Israel Mfwamba    
  •                                 
  •                           
    • index.php
    1. $servername = "localhost:3307";  
    2. $database = "registrationform1";  
    3. $db_found = new mysqli($servername, $database );  
    4. $SQL = $db_found->prepare("INSERT INTO registration (firstName, lastname, gender, email, passw, num) VALUES (?, ?, ?, ?, ?, ?)");  
    5. //$SQL->bind_param('ssssss', $firstName, $lastname, $gender, $email, $passw, $num);  
    6. $SQL->bind_param($SQL,'sssssd', $firstName, $lastname, $gender, $email, $passw, $num);  
    7. $SQL->execute();  
    8. $stmt = $conn->prepare($SELECT);  
    9. $stmt->bind_param("s", $firstName, $lastname, $gender, $email, $passw, $num);  
    10. $stmt->execute();  
    11. $stmt->bind_result($firstName, $lastname, $gender, $email, $passw, $num);  
    12. $stmt->store_result();  
    13. $rnum = $stmt->num_rows;  
    14. if ($rnum==0)  
    15. {  
    16. $stmt->close();  
    17. $stmt = $conn->prepare($INSERT);  
    18. $stmt->bind_param("ssssss", $firstName, $lastname, $gender, $email, $passw, $num);  
    19. $stmt->execute();  
    20. echo "New record inserted sucessfully";  
    21. }  
    22. ?> 

    3 Replies

    Know the answer? Post it — somebody with the same question will find it here.