Data access (add to database)

List add data to the database. Examples are as follows

Build a from form first

<formAction= "addchuli.php"Method= "POST">    <Div>Fruit Code:<inputtype= "text"name= "IDs" /></Div>    <Div>Fruit Name:<inputtype= "text"name= "Name" /></Div>    <Div>Fruit Price:<inputtype= "text"name= "Price" /></Div>    <Div>Fruit Origin:<inputtype= "text"name= "source" /></Div>    <Div>Fruit Stock:<inputtype= "text"name= "Numbers" /></Div>    <Div><inputtype= "Submit"value= "Add" /></Div></form>

Note the name of the database and the connection address.

Then write the php file

$ids=$_post["IDs"];$name=$_post["Name"];$source=$_post["Source"];$price=$_post["Price"];$numbers=$_post["Numbers"];$db=NewMysqli ("localhost", "root", "123", "MyDB");$sql= "INSERT into fruit values (' {$ids}‘,‘{$name} ', {$price},‘{$source}‘,{$numbers},‘‘)";if($db->query ($sql)){    Echo"Added successfully! ";}Else{    Echo"Add failed! ";}

Refreshing the database shows that the add was successful.

Data access (add to database)