note 117439 added to intro.mysqli
| From: | sampletext | Date: | Wed, 10 Jun 2015 19:43:30 +0000 |
| Subject: | note 117439 added to intro.mysqli | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-202813@lists.php.net to get a copy of this message | ||
include("includes/connect.php");
//Verwijderen
if(isset($_GET['verwijderen'])){
$LeerlingID = $_GET['verwijderen'];
$strQuery = "DELETE FROM leerlingen where leerlingid='$LeerlingID'";
$mysqli->query($strQuery);
}
//Aanpassen
if(isset($_GET['aanpassen'])){
$aanpasid = $_GET['aanpassen'];
}
if(isset($_POST['btnAanpassen'])){
$aanpasNaam = $_POST['txtAanpasNaam'];
$aanpasVoornaam = $_POST['txtAanpasVoornaam'];
$strQuery = "UPDATE leerlingen set voornaam='$aanpasVoornaam',
naam='$aanpasNaam' WHERE leerlingid='$aanpasid'";
$mysqli->query($strQuery);
echo "<script>window.location.href='index.php';</script>";
}
//Toevoegen
if(isset($_POST['btnSubmit'])){
$strVoornaam = $_POST['txtVoornaam'];
$strNaam = $_POST['txtNaam'];
$strQuery = "INSERT into leerlingen(voornaam,naam)
values('$strVoornaam','$strNaam')";
$mysqli->query($strQuery);
}
$strQuery = "SELECT * FROM leerlingen left join klassen on leerlingen.klasid =
klassen.klasid";
$strResultaat = $mysqli->query($strQuery);
----
Server IP: 72.52.91.14
Probable Submitter: 81.242.255.95
----
Manual Page -- http://php.net/manual/en/intro.mysqli.php
Edit -- https://master.php.net/note/edit/117439
Del: integrated -- https://master.php.net/note/delete/117439/integrated
Del: useless -- https://master.php.net/note/delete/117439/useless
Del: bad code -- https://master.php.net/note/delete/117439/bad+code
Del: spam -- https://master.php.net/note/delete/117439/spam
Del: non-english -- https://master.php.net/note/delete/117439/non-english
Del: in docs -- https://master.php.net/note/delete/117439/in+docs
Del: other reasons-- https://master.php.net/note/delete/117439
Reject -- https://master.php.net/note/reject/117439
Search -- https://master.php.net/manage/user-notes.php