I want to show a list in PHP with the entries in a mysql-database. it works, now Now in the same .php file, a form should insert a new entry in the database, and it should be shown then in the list. How could I make that? I am a beginner in PHP, so please help me :) I've got no Ideas
Thank you very much
//EDIT So, I tried the following: PHP-Part adminlist.php:
$adminname = mysqli_real_escape_string($con, $_POST['adminname']);
$server = mysqli_real_escape_string($con, $_POST['server']);
if(!empty($adminname && $server))
{
$insert = "INSERT INTO admins (ID, Name, Passwort, Server, Anmeldungen) VALUES (NULL, '" . $adminname . "', '', '" . $server . "', '0')";
$insertquery = mysqli_query($con, $insert);
}
HTML-Part adminlist.php:
<form name='einfuegen' action='adminlist.php' method='post'>
<table>
<tr>
<th>Name</th>
<th>Server</th>
</tr>
<tr>
<td><input name='adminname' value='' /></td>
<td><input name='server' value='' /></td>
<td><input type='submit' value='Einfügen' /></td>
</tr>
</table>
</form>
in this case the last entry is always inserted in the database on every access to the site.
I've tried also to set under the form
$server = 0;
$adminname = 0;
and edited the above:
if(!empty($adminname && $server) && ($server != 0) && ($adminname != 0))
In this case it won't work and nothing is inserted. How could I set only one to be inserted and be shown then in the list?