How To Fetch Data In My Sql Using PHP

The SQL SELECT statement is used to select the records from database tables.

To select all columns from the table * character used.

To select all the data table, we will use the code mentioned below

Syntax fetch all rows :

SELECT * FROM table_name

Syntax fetch selected rows :

SELECT column1,column2,column3 FROM table_name

Curd operation select code

<?php

    $query = "SELECT * FROM phpmaincrud";
    $data = mysqli_query($con, $query);
    $result = mysqli_num_rows($data);
    
?>

Download Full Code HERE