Write PHP Script to insert data into STUDENT TABLE with fields (roll,first_

[Madhvi_1]

Write PHP Script to insert data into STUDENT TABLE with fields (roll,first_name,Last_name,city,contact,gender).

[rproffitt]

This sounds like you need a tutorial. https://www.w3schools.com/php/php_mysql_insert.asp has examples.

[Dani]

Something like this:

<?php

// Connect to the database and create a MySQL resource handler
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

// Get variables from a form submission, and escape them so they'll be prepped to use in a database query
// and not at risk of an SQL injection attack

$first_name = $mysqli->real_escape_string($_POST['first_name']);
$last_name = $mysqli->real_escape_string($_POST['last_name']);
$city = $mysqli->real_escape_string($_POST['city']);

// Build the SQL string
$sql = "
    INSERT INTO student_table
    SET
        first_name = '$first_name',
        last_name = '$last_name',
        city = '$city'
";

// Execute the query
$mysqli->real_query($sql);