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

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

Download Full Code HERE