From TRCCompSci - AQA Computer Science
public IActionResult OnPost()
{
string username = Request.Form["user"];
string pass1 = Request.Form["password1"];
string pass2 = Request.Form["password2"];
int status = 0;
if (pass1 == pass2)
{
using var connection = GetConnection;
connection.Open();
string sql = "insert into test values(@p1, @p2, @p3);";
using var Command = new MySqlCommand(sql, connection);
Command.Parameters.AddWithValue("@p1", username);
Command.Parameters.AddWithValue("@p2", pass1);
Command.Parameters.AddWithValue("@p3", status);
Command.ExecuteNonQuery();
connection.Close();
}
return Page();
}