Untitled

**HTML file**
..........
..........
</style>
<body>
<H1>Create Grup</h1>
<br>
<form action="creategrup.php" method="post">

    <p>
        <label for="codigo">Grup Id:</label>
        <input type="text" required="required" autofocus="autofocus"
        maxlength="4" name="codigo" id="codigo">
    </p>
    <p>
        <label for="nombre">Grupo description:</label>
        <input type="text" required="required" name="nombre" id="nombre"">
    </p>
    <input type="submit" value="Submit">
</form>

</body>
</html>


**And PHP is**
<?php
include 'connectdb.php';
$nombre=$_POST['nombre'];
$codigo=$_POST['codigo'];
$sql = "select codigogrupo,nombregrupo from grupo where
codigogrupo='$codigo'";
$query = mysqli_query($conn, $sql);
if (mysqli_num_rows($query) >0) {
    echo "<p><h1><b>Grup Id $codigo allready exist....</h1></b></p><br>";
    echo "<a href='creategrup.html'>Go Back</a>";
}
else {
  mysqli_query($conn, "insert into grupo(codigogrupo,nombregrupo)
    values('$codigo','$nombre')");

if(mysqli_affected_rows($conn)>0){
    echo "<p><h1><b>Grup  $nombre added</h1></b></p>";
    echo "<a href='creategrup.html'>Go Back</a>";
} else {
echo "Grup not added<br>";
echo mysqli_error ($conn);
}
}
?>

**Connectdb.php**
<?php

$servername = "server name";
$username = "user name";
$password = "password";
$dbname = "database";

// Create connection
$conn = mysqli_connect($servername, $username, $password,$dbname);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
// echo "Connected successfully";
?>