通过html向mysql表添加新值

Question

I am trying to add new elements to my database on mysql through my webpage.

This is what I've got so far

<form action="MyCurrentPage.php" method="post" >
<label for="playername"> Player </label>
<input type="text" name="addplayer" id="playername"/>
<input type= "submit" value="submit" name="submit"/>
</form>

and this

<?php
 if (isset($_POST['submit'])) {
     $addplayerv=$_POST['addplayer'];
     $mysqli->select_db("player", $player);

     $sql="INSERT INTO player (nameofplayer) VALUES ('".$addplayerv."')";
    $mysqli->query($sql, $mysqli);
    $mysqli->close($mysqli);
     }


?>

I am getting the following errors:

• Notice: Undefined variable: player
• Warning: mysqli::select_db() expects exactly 1 parameter, 2 given
• Warning: mysqli::query() expects parameter 2 to be integer, object given
• Warning: mysqli::close() expects exactly 0 parameters, 1 given

Answer 1

You have not declared $player you should do that first. The select_db() function is unnesisary if you use $mysli like this: $mysqli = new mysqli("localhost", "user", "password", "database");

your query should execute after you did take these steps with this line: mysqli_query($mysqli,"INSERT INTO player (nameofplayer) VALUES ('".$addplayerv."')");