How to insert table data in mysql db using php

INSERT INTO

This function is used to insert data to table in mysqldb

Synatx

INSERT INTO TABLENAME field1=val1,field2=val2,...[where condition]

Code

<?php
include("sqlcon.php");

    $sql = "SELECT uemail,upass,vcode,verified FROM udetails WHERE uemail='$uemail'";
    $result = $conn->query($sql);


    if ($result->num_rows >=0) {
   
$sql = "INSERT INTO udetails (uemail,upass,vcode,verified,earnings)
VALUES ('$uemail','$upass',1222,0,0)";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}


$conn->close();

?>