data insert into db

/////////////////////////////////////// //// db schema to create a cities table ////////////////////////////////////// CREATE TABLE cities( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, state VARCHAR(30) NOT NULL, city VARCHAR(30) NOT NULL ); /////////////////// //// index.html ////////////////// data insert into db // for main.js refer to the js file here // https://code.sololearn.com/W6rqi00oXPVn/?ref=app /////////////////// ////insert-city.php ////////////////// connect_error) { die("Connection failed: " . $mysqli->connect_error); } // insert query execution $sql = "INSERT INTO cities (state, city) VALUES ('" . $_POST['state'] . "', '" . $_POST['city'] . "')"; if($mysqli->query($sql) === TRUE) { echo "A new record, state='".$_POST['state']."' city='".$_POST['city']."' created successfully"; } else { echo "Error: " . $sql . "
" . $mysqli->error; } ?> ///////////////////////////////////////////////// /* Please note that you need a PHP server with //MySQL db to execute this script, it would not run from code playground. */ /////////////////////////////////////////////////

php data insert into mysql db table