Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @foreach(var row in db.Query(getKamers))
- {
- <form id="@row.id" action='_DataConn.php' method='post' class='ajaxform'>
- <input type="text" value="@row.id" name="id" id="td-id" />
- <input type="text" value="@row.oppervlakte" name="oppervlakte" id="td-opp" />
- <input type="text" value="@row.locatie" name="locatie" id="td-loc" />
- <input type="text" value="@row.type" name="type" id="td-type" />
- <input type="text" value="@row.kamernr" name="nummer" id="td-kamernr" />
- <input type="text" value="@row.vrij" name="vrij" id="td-vrij" />
- <input type="submit" value="opslaan" name="opslaan" id="@row.id" />
- </form>
- }
- $(document).ready(function () {
- $('.ajaxform').submit(function () {
- $.ajax({
- url: $(this).attr('action'),
- type: $(this).attr('method'),
- dataType: 'json',
- data: $(this).serialize(),
- success: function (data) {
- console.log(data);
- }
- });
- return false;
- });
- <?php
- $dbhost = "localhost";
- $dbuser = "root";
- $dbpass = "root";
- $dbname = "Studentenkamers";
- //Connect to MySQL Server
- mysql_connect($dbhost, $dbuser, $dbpass);
- //Select Database
- mysql_select_db($dbname) or die(mysql_error());
- // Retrieve data from Query String
- $id = $_POST['id'];
- $oppervlakte = $_POST['oppervlakte'];
- $locatie = $_POST['locatie'];
- $kamernr = $_POST['nummer'];
- $type = $_POST['type'];
- $vrij = $_POST['vrij'];
- echo 'ok'
- // Escape User Input to help prevent SQL Injection
- $id = mysql_real_escape_string($id);
- $oppervlakte = mysql_real_escape_string($oppervlakte);
- $locatie = mysql_real_escape_string($locatie);
- $kamernr = mysql_real_escape_string($kamernr);
- $type = mysql_real_escape_string($type);
- $vrij = mysql_real_escape_string($vrij);
- //build query
- //"UPDATE Studentkamer SET oppervlakte='" + room[1] + "', locatie='" + room[2] + "', type='" + room[3] + "', vrij='" + room[4] + "' WHERE id='" + room[0] + "'";
- $query = "UPDATE Studentkamer SET oppervlakte = '$id', locatie = '$locatie', type='$type', kamernr = '$kamernr', vrij = '$vrij' WHERE id='$id'";
- //Execute query
- $qry_result = mysql_query($query) or die(mysql_error());
- ?>
- ID and NAME tokens must begin with a letter ([A-Za-z]) and may be followed by any number
- of letters, digits ([0-9]), hyphens ("-"), underscores ("_"), colons (":"), and periods (".").
Add Comment
Please, Sign In to add comment