This question already has an answer here:
I'm trying to submit data from php from a html form to mysql but for some reason it's automatically submitting before i even click the submit button. I've included the php and html source. i have to write something here so i can post as it's telling me there is to much code and not enough details xD
<?php
$link = mysqli_connect("localhost", "db", "pass", "table");
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
$id = mysqli_real_escape_string($link, $_POST['id']);
$game = mysqli_real_escape_string($link, $_POST['game']);
$server = mysqli_real_escape_string($link, $_POST['server']);
$datetimepicker1 = mysqli_real_escape_string($link, $_POST['datetimepicker1']);
$et = mysqli_real_escape_string($link, $_POST['et']);
$sc = mysqli_real_escape_string($link, $_POST['sc']);
$ss = mysqli_real_escape_string($link, $_POST['ss']);
$ec = mysqli_real_escape_string($link, $_POST['ec']);
$es = mysqli_real_escape_string($link, $_POST['es']);
$dn = mysqli_real_escape_string($link, $_POST['dn']);
$sql = "INSERT INTO events (id, game, server, datetimepicker1, et, sc, ss, ec, es, dn) VALUES ('$id', '$game', '$server', '$datetimepicker1', '$et', '$sc', '$ss', '$ec', '$es', '$dn')";
if(mysqli_query($link, $sql)){
echo "Records added successfully.";
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
mysqli_close($link);
?>
<div class="form-group">
<label class="col-md-4 control-label" for="game">Game</label>
<div class="col-md-4">
<select id="game" name="game" class="form-control">
<option value="ets2mp">ETS2MP</option>
<option value="atsmp">ATS2MP</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="server">Server</label>
<div class="col-md-4">
<select id="server" name="server" class="form-control">
<option value="12">Hong Kong #1</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="datetimepicker1">Date & Time</label>
<div class="col-md-4">
<div class='input-group date' id='datetimepicker1'>
<input type='text' class="form-control" required="" />
<span class="input-group-addon">
<span class="glyphicon glyphicon-calendar"></span>
</span>
</div>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="et">Event Type</label>
<div class="col-md-4">
<select id="et" name="et" class="form-control">
<option value="1">Convoy</option>
</select>
</div>
</div>
<!-- Select Basic -->
<div class="form-group">
<label class="col-md-4 control-label" for="sc">Start City</label>
<div class="col-md-4">
<select id="sc" name="sc" class="form-control">
<option value="12">Aalborg</option>
<option value="96">Aberdeen</option>
<option value="99">Wilnet Transport</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="ec">End City</label>
<div class="col-md-4">
<select id="ec" name="ec" class="form-control">
<option value="12">Aalborg</option>
<option value="95">Zürich</option>
</select>
</div>
</div>
<div class="form-group">
<label class="col-md-4 control-label" for="es">End Site</label>
<div class="col-md-4">
<select id="es" name="endsite" class="form-control">
<option value="76">Service Station</option>
<option value="99">Wilnet Transport</option>
</select>
</div>
</div>
<div style="width:29%; margin: 20px auto 0 auto;">
<div class="form-group">
<label for="dn">Description</label>
<textarea class="form-control" id="dn" rows="3"></textarea>
</div>
</div>
<!-- Button (Double) -->
<div class="form-group">
<label class="col-md-4 control-label" for="submitButton"></label>
<div class="col-md-8">
<input type="submit" value="Submit">
<button id="cancelButton" name="cancelButton" class="btn btn-danger">Cancel</button>
</div>
</div>
</fieldset>
</form>
</div>
