Advertisement
Guest User

Code

a guest
Dec 16th, 2016
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.14 KB | None | 0 0
  1. <?php
  2. echo "Starting code.php<br>";
  3. $servername = "localhost";
  4. $username = "myusername";
  5. $password = "mypassword";
  6. $dbname = "mydatabasename";
  7.  
  8. // Create Connection
  9.  
  10. $conn = new mysqli($servername, $username, $password, $dbname);
  11.  
  12. // Check Connection
  13. if ($conn->connect_error) {
  14.     die("Connection failed: " . $conn->connect_error);
  15. }
  16. echo "Connected successfully<br>";
  17.  
  18.     // Prepare and Bind
  19.    
  20.     if ($stmt = $conn->prepare("INSERT INTO MyFieldData (field1, field2, field3, field4, field5, field6) VALUES (?, ?, ?, ?, ?, ?)")) {
  21.         $stmt->bind_param("ssssss", $field1, $field2, $field3, $field4, $field5, $field6);
  22.     } else {
  23.         echo "Prepare() returned false! VAR_DUMP RESULTS: ";
  24.         var_dump(error);
  25.     }
  26.    
  27.     // Set Parameters & Filter
  28.  
  29.     $field1 = filter_input(INPUT_POST, 'u_username', FILTER_UNSAFE_RAW, FILTER_FLAG_STRIP_LOW);
  30.     echo $username; // When I try this, nothing ever comes up on the screen...
  31.     $field2 = $_POST['u_pwd'];
  32.     $field3 = $_POST['u_email'];
  33.     $field4 =  $_POST['u_growid'];
  34.     $field5 = $_POST['u_world'];
  35.     $field6 = $_POST['u_gender'];
  36.    
  37.     $stmt->execute();
  38. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement