MySQL or PHP PDO error

Question

Im getting a:

Warning: PDOStatement::execute() [pdostatement.execute]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'classnum' cannot be null in /home/content/49/11554349/html/gb/dev/post.php on line 66

This is the php it refers too:

public function CheckIfEmptyTutor($class,$classnum,$studentyear){

    if(empty($class) && empty($classname) && empty($studentyear)){
        echo "All fields are requiered to create the post.";
        return true;
    }
    else{
        return false;
    }           
}


public function TutorPost($class,$classnum,$studentyear){

    $stmt = $this->db->prepare("INSERT INTO tutors(class, classnum, studenyear) VALUES(?,?,?)");
    $stmt->bindParam(1,$class);
    $stmt->bindParam(2,$classnum);
    $stmt->bindParam(3,$studentyear);
    $stmt->execute();       
    if($stmt->rowCount() == 1){
        echo "Successfully posted!";
    }
    //For testing purposes.
    else{
        echo "Something went wrong.";   
    }
}

Those are the functions I made, 1 is to check if the form is completely filled out, the other to actually post the data on the database.

And this is how im calling it in the html.

if(isset($_POST["submit"])){
    $class = $_POST["class"];
    $classnum = $_POST["classnum"];
    $studentyear = $_POST["studentyear"];
    $newpost = new UserPost();
    if(!$newpost->CheckIfEmptyTutor($class,$classnum,$studentyear)){
       $newpost->BookBoardPost($class,$classnum,$studentyear);
    }
}

replace $classname with $classnum and enable error_reporting — Iłya Bursov
– Iłya Bursov, Commented Dec 1, 2013 at 20:38

Vincent Ramdhanie · Accepted Answer · 2013-12-01 20:38:48Z

3

Your function is accepting a parameter called $classname but you are binding $classnum. Since there is no $classnum it is probably passing null into the statement.

$stmt->bindParam(2,$classname);

answered Dec 1, 2013 at 20:38

Vincent Ramdhanie

103k23 gold badges143 silver badges196 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Vincent Ramdhanie Over a year ago

So the problem could be before the call to this function. Try printing the values of the variables and see if any are null.

phpnoob Over a year ago

echoed all of them, none are null so why is there a problem when calling the function?

Nadi Hassan Hassan · Accepted Answer · 2013-12-01 21:20:38Z

0

I think the function call has a problem , print out the data you sent to the function to make sure it's not null . Post it here or an a fiddle if you can

answered Dec 1, 2013 at 21:20

Nadi Hassan Hassan

1421 silver badge14 bronze badges

1 Comment

Nadi Hassan Hassan Over a year ago

Change the && to || in the check function

Iłya Bursov · Accepted Answer · 2013-12-01 22:37:32Z

0

you have error:

public function CheckIfEmptyTutor($class,$classnum,$studentyear){
    if(empty($class) && empty($classname) && empty($studentyear)){

here should be

public function CheckIfEmptyTutor($class,$classnum,$studentyear){
    if(empty($class) || empty($classnum) || empty($studentyear)){

answered Dec 1, 2013 at 22:37

Iłya Bursov

24.4k4 gold badges36 silver badges68 bronze badges

Collectives™ on Stack Overflow

MySQL or PHP PDO error

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related