0

for some reason that i can't seem to find, i can't get my mysqli code to write in my database. The "echo $newUserResult." ".$fullName;" work fine. I am pretty new to coding and i have spent lot of time trying to troubleshoot this. I'm sorry for wasting your guys time but i just can't see why it doesn't work.

<-----     Data Base Connection     ----->

<?php

$serverName = "localhost";
$dbUsername = "root";
$dbPassword = "";
$dbName = "stw";

$conn = mysqli_connect($serverName, $dbUsername, $dbPassword, $dbName);

if (!$conn){
    die("Connection Failed: " . mysqli_connect_error());
}

<-----     My Code     ----->

<?php

if(isset($_POST["nameSubmit"])){

    session_start();
    $newUser = $_SESSION["newUser"];
    $firstName = $_POST["firstName"];
    $lastName = $_POST["lastName"];
    $fullName = $firstName." ".$lastName;
    $fullNameLength = strlen($fullName);

    require_once 'dbc-inc.php';
    require_once 'functions-inc.php';

    if(emptyNameInput($firstName, $lastName) !== false){
        header("location: ../profile.php?error=Emptynameinput");
        exit();
    }
    if(invalidNamelength($fullNameLength) !== false){
        header("location: ../profile.php?error=invalidnamelength");
        exit();
    }
    if(invalidName($firstName, $lastName) !== false){
        header("location: ../profile.php?error=invalidname");
        exit();
    }
    addName($conn, $newUser, $fullName);
}
else{
    header("location: ../profile.php");
}

<-----     addName Function     ----->

function addName($conn, $newUser, $fullName){

    $sql = "INSERT INTO users (unew, uname) VALUES (?, ?)";
    $stmt = mysqli_stmt_init($conn);

    if(!mysqli_stmt_prepare($stmt, $sql)){
        header("location: ../profile.php?error=namestmtfailed");
        exit();
    }

    $newUserResult = $newUser + 1;

    mysqli_stmt_bind_param($stmt, "is", $newUserResult, $fullName);
    mysqli_stmt_execute($stmt);
    echo $newUserResult." ".$fullName;
    exit();
}
Dharman
  • 30,962
  • 25
  • 85
  • 135
  • 1
    Do you have an error message ? If so please provide it, it would helps a lot to find where's the issue is. – Nino Dec 02 '20 at 18:35
  • Please enable error reporting and then update the question with the error. [How to get the error message in MySQLi?](https://stackoverflow.com/a/22662582/1839439) – Dharman Dec 02 '20 at 18:37

0 Answers0