blob: e894d5c48b9e585d14ee4369ef4d72fcfacf9abb (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
|
<?php
class deleteClass{
private $link;
public function __construct() {
$this->link = mysql_connect('localhost', 'root', 'lsfks-openslx');
if (!$this->link) {
die('keine Verbindung möglich: ' . mysql_error());
}
echo 'Verbindung erfolgreich'."\n";
mysql_select_db('pbs');
}
public function __destruct() {
mysql_close($this->link);
unset($this->link);
}
public function deletePerson($i){
$anz = mysql_num_rows(mysql_query("SELECT * FROM pbs_membership WHERE personID = $i;");
mysql_query("DELETE FROM pbs_person WHERE personID = $i;");
if(mysql_num_rows(mysql_query("SELECT * FROM pbs_person WHERE personID = $i;") < 1) {
if($anz > 0) {
if(mysql_num_rows(mysql_query("SELECT * FROM pbs_membership WHERE personID = $i;")) < 1) {
echo "Löschen erfolgreich";
} else {
echo "Löschen nicht erfolgreich";
}
} else {
echo "Löschen erfolgreich";
}
} else {
echo "Löschen nicht erfolgreich";
}
}
public function deleteGroup($i){
}
public function deleteRight($i){
}
public function deleteRole($i){
}
public function deleteMemberships(){
}
public function deleteAll(){
$this->deletePerson(20);
$this->deleteGroup(10);
$this->deleteRight(20);
$this->deleteRole(20);
$this->deleteMemberships();
}
}
$u = new deleteClass();
$u->deleteAll();
|
