How do i get data from database with php prepared statements like in my code and echo them out in a webpage?

Question

I'm trying to get out data in a page with a prepared statement. Is this code wrong or:`

$conn = mysqli_connect("localhost", "root", "123456", "test");
if (mysqli_connect_errno()) {
    die("error".mysqli_connect_error());
    exit();
}

$query=" SELECT * FROM persons WHERE name=? AND last=? ;";
$stm=mysqli_stmt_init($conn);
if(! mysqli_stmt_prepare($stm, $query)){
    echo "statment  failed";
}
else{
    mysqli_stmt_bind_param( $stm , "ss", $name , $last);
};

mysqli_stmt_execute($stm);

`

yes i tryed pavel , modified the code but it doesn't work ! I can't echo the code out , or i make a mistake in code writing or in can't output the code in the index page — user8262026
– user8262026, Commented Jun 28, 2018 at 20:00
@vinay thoese actually should be the values of the variables wich i get from the Database. — user8262026
– user8262026, Commented Jul 1, 2018 at 14:47

Vinay · Accepted Answer · 2018-07-02 13:30:45Z

1

Try this:

    $conn = mysqli_connect("localhost", "root", "123456", "test");
    if (mysqli_connect_errno()) {
    die("error".mysqli_connect_error());
    exit();
    }

    $name = 'eliot';
    $last = 'carbone';

    $query=" SELECT * FROM persons WHERE name=? AND last=? ;"

    if($stmt1 = mysqli_prepare($conn, $query)){
        mysqli_stmt_bind_param($stmt1,"ss", $name , $last);

        if(mysqli_stmt_execute($stmt1)){    

            $result = mysqli_stmt_get_result($stmt1);
            if(mysqli_num_rows($result) > 0){
            $foundnum = mysqli_num_rows($result);

            while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){

            echo $name = $row['year'];

                }
            }
        }
    }
    mysqli_stmt_close($stmt1);

answered Jul 2, 2018 at 13:30

Vinay

2,3394 gold badges23 silver badges34 bronze badges

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

Comments

Jyothish V · Accepted Answer · 2018-06-27 18:28:41Z

0

mysqli_stmt_execute($stm);    
$result = mysqli_stmt_get_result($stm);
while ($row = mysqli_fetch_array($result, MYSQLI_NUM))
{
    var_dump($row); # your result
}
mysqli_stmt_close($stm);
mysqli_close($conn);

answered Jun 27, 2018 at 18:28

Jyothish V

869 bronze badges

Collectives™ on Stack Overflow

How do i get data from database with php prepared statements like in my code and echo them out in a webpage?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related