Results 1 to 2 of 2

Thread: Trying to insert data using prepared statements in PHP.

Hybrid View

  1. #1
    Join Date
    Aug 2009
    Posts
    2

    Trying to insert data using prepared statements in PHP.

    <?php
    $username = stripslashes($_POST['username']);
    $password = stripslashes($_POST['password']);
    $state = stripslashes($_POST['state']);
    $state_code = stripslashes($_POST['state_code']);
    $conn = new mysqli("localhost", "root", "icecold","test");

    if (mysqli_connect_errno()){
    echo "Unable to connect to database<br>";
    echo "Error ". mysqli_connect_errno() . " - ".mysqli_connect_error();
    exit;
    }

    $username = mysqli_real_escape_string($conn, $_POST['username']);
    $password = mysqli_real_escape_string($conn, $_POST['password']);
    $state = mysqli_real_escape_string($conn, $_POST['state']);
    $state_code = mysqli_real_escape_string($conn, $_POST['state_code']);

    $sql = "INSERT INTO user_records(username, password, state_code)
    VALUES (?, ?, ?)";
    $sql2 = "INSERT INTO states(states, state_code)
    VALUES (?, ?)";

    // initialize prepared statement
    $stmt = $conn->stmt_init();
    if ($stmt->prepare($sql)) {
    // bind parameters and execute statment
    $stmt->bind_param('sss', $username, $password, $state_code);
    $stmt->execute();
    /*
    if ($stmt->prepare($sql2)) {
    // bind parameters and execute statment
    $stmt->bind_param('ss', $states, $state_code);
    $stmt->execute();
    */
    $conn->close();

    echo $username."</br>".$password."</br>".$state_code."</br>".$state ;


    ?>

  2. #2
    Join Date
    Aug 2009
    Posts
    2
    I meant to ask why I was doing wrong because I keep getting an error pointing to the last line.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •