mysqlconnectivityphp

 php mysql oops connectivity:

<?php

$con=new mysqli("localhost","root","root","test");

if($con->connect_error){

    die("connection failed".$con->connect_error);

}

else{

    $sql="select * from records where name='amit'";

    $result=$con->query($sql);

    if($result->num_rows>0){

        while($data=$result->fetch_assoc()){

            echo $data['name']."",$data['class'];

        }

    }

    

}

pdo connectivity:

<?php

$dbname="mysql:host=localhost;dbname=student";

$con=new PDO($dbname,"root","");

$sql=$con->query("select * from student_records");

while($data=$sql->fetch(PDO::FETCH_ASSOC)){

    //print_r($row);

    echo $data['student_id']."".$data['student_name'];

}

?>