Hilfe beim PHP Script

index.html:

<html>
<body>
<form action="insertdata.php" method="get">

    <p>Name: <input type="text" name="name" /></p>
    <p>Firma: <input type="text" name = "firma"/>
	<p>Rufnummer: <input type="text" name = "nummer"/>
	<p>Adresse: <input type="text" name="adresse">
	<p>Anfrage: <input type="text" name="anfrage">
    	    <input type="submit" value="absenden" />
 
 <input  type="reset">
</form>
Show <a href="showdata2.php">all sets of data</a>
</body>
</html>

index.php

 <?php
    $servername = "db5000051603.hosting-data.io";
    $database = "dbs4652";
    $username = "dbu131697";
    $password = "evvvvvvvvvv";
    // Create connection
    $conn = mysqli_connect($servername, $username, $password, $database);
    // Check connection
    if (!$conn) {
          die("Connection failed: " . mysqli_connect_error());
    }
     
    echo "Connected successfully";
     
    $sql = "INSERT INTO personen (name, firma, email, adresse, anfrage) VALUES ('Test', 'Testing', 'Testing@tesing.com','test','test')";
    if (mysqli_query($conn, $sql)) {
          echo "New record created successfully";
    } else {
          echo "Error: " . $sql . "<br>" . mysqli_error($conn);
    }
    mysqli_close($conn);
    ?>

insertdata.php:

 <?php
    $servername = "db5000051603.hosting-data.io";
    $database = "dbs46522";
    $username = "dbu131697";
    $password = "evvvvvvvvvvv";
    // Create connection
    $conn = mysqli_connect($servername, $username, $password, $database);
    // Check connection
    if (!$conn) {
          die("Connection failed: " . mysqli_connect_error());
    }
     
    echo "Connected successfully";
     
    $sql = "INSERT INTO personen (name, firma, email, adresse, anfrage);
    if (mysqli_query($conn, $sql)) {
          echo "Daten eingtragen";
    } else {
          echo "Error: " . $sql . "<br>" . mysqli_error($conn);
    }
    mysqli_close($conn);
    ?>

insertdata2.php

<?php
                                                            
     
 $db = mysql_connect("ldb5000051603.hosting-data.io" ,"dbu131697","evvvvvvvvvvvr");           
                                                            

 $res = mysql_db_query("dbs46522"", "select * from personen");   
                                                            
$num = mysql_num_rows($res);                                
                                                            
                                                            
  for ($i=0; $i<$num; $i++)                                 
  {                                                         
    $nn = mysql_result($res, $i, "firma");                   
    $vn = mysql_result($res, $i, "name");                
    $pn = mysql_result($res, $i, "nummer");                    
    $ge = mysql_result($res, $i, "adresse");                 
    $gt = mysql_result($res, $i, "anfrage");           
    echo "$nn, $vn, $pn, $ge, $gt <br>";                    
  }                                                         
mysql_close($db);                                           
?>

showdata2.php:

<?php
    $servername = "db5000051603.hosting-data.io";
    $database = "dbs46522";
    $username = "dbu131697";
    $password = "esiddddddddddd";
    // Create connection
    $conn = mysqli_connect($servername, $username, $password, $database);

 $res = mysqli_query("dbs46522" , "select * from personen");   
                                                            
$num = mysqli_num_rows($res);                                
                                                            
                                                            
  for ($i=0; $i<$num; $i++)                                 
  {                                                         
    $nn = mysql_result($res, $i, "firma");                   
    $vn = mysql_result($res, $i, "name");                
    $pn = mysql_result($res, $i, "nummer");                    
    $ge = mysql_result($res, $i, "adresse");                 
    $gt = mysql_result($res, $i, "anfrage");           
    echo "$nn, $vn, $pn, $ge, $gt <br>";                    
  }                                                         
mysqli_close($db);      
print "es wurden keine einträge gefunden";                                     
?>

https://www.w3schools.com/php/php_forms.asp