want to delete a name in database n it must display if the name exists or not

Question

<?php
    $hostname = "localhost";

    $username = "ODBC";

    $password = "";

    $dbname = "db_students";

    try{
        $dbh = new PDO("mysql:host=$hostname;dbname=$dbname",$username,$password);

        echo"Connected to database"."<br/>";

        $dbh->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

        $stmt = $dbh->prepare("DELETE FROM enrolments
                WHERE student_name = :name");

        $stmt->bindParam(":name",$name,PDO::PARAM_STR,255);

        $name = "Pietie Kock";
        $stmt->execute();

        if($student_name > 0)
        {
           echo "record deleted ". $student_name;
        }else{

           echo "record doesn't exist". $student_name;

            $dbh = null;
            }catch(PDOException $e){
            echo $e->getMessage();
            }
        ?>

You should add a least a question, and some of your problem description. — blue112, Apr 20 '16 at 09:49
its format now and i will do that next time i upload a question — Sizwe Pellicant, Apr 20 '16 at 09:54

Saty · Accepted Answer · 2016-04-20T10:11:28.387

$student_name is undefined in your code To check the number of rows affected by the last SQL statement we use rowCount()

$stmt->execute();
if ($stmt->rowCount > 0) {
        echo "record deleted " . $student_name;
    } else {

        echo "record doesn't exist" . $student_name;

        $dbh = null;
    }

You also forget to close try Your code would be

try {
    $dbh = new PDO("mysql:host=$hostname;dbname=$dbname", $username, $password);

    echo"Connected to database" . "<br/>";

    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $stmt = $dbh->prepare("DELETE FROM enrolments
                WHERE student_name = :name");

    $stmt->bindParam(":name", $name, PDO::PARAM_STR, 255);

    $name = "Pietie Kock";
    $stmt->execute();


    if ($stmt->rowCount > 0) {
        echo "record deleted " . $student_name;
    } else {

        echo "record doesn't exist" . $student_name;

        $dbh = null;
    }
} catch (PDOException $e) {// close you try
    echo $e->getMessage();
}

want to delete a name in database n it must display if the name exists or not

1 Answers1