VNC stopt er mee :(
Include werkt niet exclude wel
Hoe kan dat?
newuseradd.php
Code (php)
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
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
<?php
$username = $_GET['username'];
$password = $_GET['password'];
$key = $_GET['key'];
$name = $_GET['name'];
$email = $_GET['email'];
$level = $_GET['level'];
$sql = 'SELECT * FROM AdminUsers';
$result = mysqli_query($connect, $sql);
$details = mysqli_fetch_all($result, MYSQLI_ASSOC);
mysqli_free_result($result);
mysqli_close($connect);
foreach($details as $detail) {
if($username == $detail['Username']) {
echo "<tr><td colspan='7'>Username already in use!</td></tr>";
if($name == $detail['Name']) {
echo "<tr><td colspan='7'>Name already in use!</td></tr>";
if($email == $detail['email']) {
echo "<tr><td colspan='7'>Email already in use!</td></tr>";
}
}
} else {
$query = 'INSERT INTO AdminUsers (Username, Passwd, LoginKey, Name, email, Level) VALUES ('.$username.', '.md5($password).', '.$key.', '.$name.', '.$email.', '.$level.')';
$result = mysqli_query($connect, $query);
echo "<tr><td>New User added</td></tr>";
}
}
?>
$username = $_GET['username'];
$password = $_GET['password'];
$key = $_GET['key'];
$name = $_GET['name'];
$email = $_GET['email'];
$level = $_GET['level'];
$sql = 'SELECT * FROM AdminUsers';
$result = mysqli_query($connect, $sql);
$details = mysqli_fetch_all($result, MYSQLI_ASSOC);
mysqli_free_result($result);
mysqli_close($connect);
foreach($details as $detail) {
if($username == $detail['Username']) {
echo "<tr><td colspan='7'>Username already in use!</td></tr>";
if($name == $detail['Name']) {
echo "<tr><td colspan='7'>Name already in use!</td></tr>";
if($email == $detail['email']) {
echo "<tr><td colspan='7'>Email already in use!</td></tr>";
}
}
} else {
$query = 'INSERT INTO AdminUsers (Username, Passwd, LoginKey, Name, email, Level) VALUES ('.$username.', '.md5($password).', '.$key.', '.$name.', '.$email.', '.$level.')';
$result = mysqli_query($connect, $query);
echo "<tr><td>New User added</td></tr>";
}
}
?>
Dit is de code en werkt wel als ik hem op de achtergrond laat werken, maar als hij door een include wordt aangeroepen, werkt hij niet. Alle variable staan goed, dus daar is niks mis mee.
PS: bij de exclude laadt ik wel de database.php config in
Gewijzigd op 05/06/2022 17:14:25 door Arno van Zanten
Is dit nou gokwerk omdat include() niet werkt, en dat je maar een niet bestaande functie exclude() probeert, of bedoel je wat anders met exclude?
Gewijzigd op 05/06/2022 17:16:10 door - Ariën -
Als ik de page opzich laad werken met include('dbase.php'); werkt het wel.
Maar doe ik hem met een include aanroepen, dan werkt het niet.
Gewijzigd op 05/06/2022 17:36:38 door - Ariën -
users.php
Code (php)
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
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
<?php
$sql = 'SELECT * FROM AdminUsers';
$result = mysqli_query($connect, $sql);
$users = mysqli_fetch_all($result, MYSQLI_ASSOC);
mysqli_free_result($result);
mysqli_close($connect);
echo " <tr class='tr_mail_0'><td colspan='7' align='left'><a href='index.php?menu=newuser'>Add new Employee</a></td></tr>
<tr class='tr_mail_1'><td>Name</td><td>Email</td><td>Username</td><td>LoginKey</td><td>Level</td><td>Edit</td><td>Delete</td></tr>";
foreach($users as $user) {
echo"<div class='container'><tr><td>".$user['Name']."</td><td>".$user['email']."</td><td>".$user['Username']."</td><td>".$user['LoginKey']."</td>";
if($_SESSION['Level'] <= $user['level']){
echo "<td>Not displayed</td>";
}else {
echo "<td>".$user['Level']."</td>";
}
if($_SESSION['Level'] <= $user['level']){
echo "<td>Edit</td><td>Delete</td></tr></div>";
} else {
echo "<td><a href=index.php?menu=edituser'>Edit</a></td><td><a href=index.php?menu=deluser'>Delete</a></td></tr></div>";
}
}
?>
$sql = 'SELECT * FROM AdminUsers';
$result = mysqli_query($connect, $sql);
$users = mysqli_fetch_all($result, MYSQLI_ASSOC);
mysqli_free_result($result);
mysqli_close($connect);
echo " <tr class='tr_mail_0'><td colspan='7' align='left'><a href='index.php?menu=newuser'>Add new Employee</a></td></tr>
<tr class='tr_mail_1'><td>Name</td><td>Email</td><td>Username</td><td>LoginKey</td><td>Level</td><td>Edit</td><td>Delete</td></tr>";
foreach($users as $user) {
echo"<div class='container'><tr><td>".$user['Name']."</td><td>".$user['email']."</td><td>".$user['Username']."</td><td>".$user['LoginKey']."</td>";
if($_SESSION['Level'] <= $user['level']){
echo "<td>Not displayed</td>";
}else {
echo "<td>".$user['Level']."</td>";
}
if($_SESSION['Level'] <= $user['level']){
echo "<td>Edit</td><td>Delete</td></tr></div>";
} else {
echo "<td><a href=index.php?menu=edituser'>Edit</a></td><td><a href=index.php?menu=deluser'>Delete</a></td></tr></div>";
}
}
?>
newuser.php
Code (php)
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
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
<?php
// add new user
echo"
<tr>
<td colspan='7'>
<div class='container'>
<form id='contact' action='./index.php?menu=newuseradd' method='post'>
<h3>Add new Employee</h3>
<fieldset>
<input type='text' name='username' placeholder='Username' required>
</fieldset>
<fieldset>
<input type='password' name='password' placeholder='Password' required>
</fieldset>
<fieldset>
<input type='text' name='key' placeholder='Key' required>
</fieldset>
<fieldset>
<input type='text' name='name' placeholder='Full name of Employee' required>
</fieldset>
<fieldset>
<input type='text' name='email' placeholder='Email address' required>
</fieldset>
<fieldset>
<label for='level'>Select Employee level</label>
<select id='level' name='level'>
<option value='1'>1</option>
<option value='2'>2</option>
<option value='3'>3</option>
<option value='4'>4</option>
<option value='5'>5</option>
<option value='6'>6</option>
<option value='7'>7</option>
</select>
</fieldset>
<fieldset>
<button type='submit' name='submit'>Add Employee</button>
</fieldset>
</form>
</div>
</td>
</tr>
";
?>
// add new user
echo"
<tr>
<td colspan='7'>
<div class='container'>
<form id='contact' action='./index.php?menu=newuseradd' method='post'>
<h3>Add new Employee</h3>
<fieldset>
<input type='text' name='username' placeholder='Username' required>
</fieldset>
<fieldset>
<input type='password' name='password' placeholder='Password' required>
</fieldset>
<fieldset>
<input type='text' name='key' placeholder='Key' required>
</fieldset>
<fieldset>
<input type='text' name='name' placeholder='Full name of Employee' required>
</fieldset>
<fieldset>
<input type='text' name='email' placeholder='Email address' required>
</fieldset>
<fieldset>
<label for='level'>Select Employee level</label>
<select id='level' name='level'>
<option value='1'>1</option>
<option value='2'>2</option>
<option value='3'>3</option>
<option value='4'>4</option>
<option value='5'>5</option>
<option value='6'>6</option>
<option value='7'>7</option>
</select>
</fieldset>
<fieldset>
<button type='submit' name='submit'>Add Employee</button>
</fieldset>
</form>
</div>
</td>
</tr>
";
?>
newuseradd.php
Code (php)
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
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
<?php
$username = $_GET['username'];
$password = $_GET['password'];
$key = $_GET['key'];
$name = $_GET['name'];
$email = $_GET['email'];
$level = $_GET['level'];
$sql = 'SELECT * FROM AdminUsers';
$result = mysqli_query($connect, $sql);
$details = mysqli_fetch_all($result, MYSQLI_ASSOC);
mysqli_free_result($result);
mysqli_close($connect);
foreach($details as $detail) {
if($username == $detail['Username']) {
echo "<tr><td colspan='7'>Username already in use!</td></tr>";
if($name == $detail['Name']) {
echo "<tr><td colspan='7'>Name already in use!</td></tr>";
if($email == $detail['email']) {
echo "<tr><td colspan='7'>Email already in use!</td></tr>";
}
}
} else {
$query = 'INSERT INTO AdminUsers (Username, Passwd, LoginKey, Name, email, Level) VALUES ('.$username.', '.md5($password).', '.$key.', '.$name.', '.$email.', '.$level.')';
$result = mysqli_query($connect, $query);
echo "<tr><td>New User added</td></tr>";
}
}
?>
$username = $_GET['username'];
$password = $_GET['password'];
$key = $_GET['key'];
$name = $_GET['name'];
$email = $_GET['email'];
$level = $_GET['level'];
$sql = 'SELECT * FROM AdminUsers';
$result = mysqli_query($connect, $sql);
$details = mysqli_fetch_all($result, MYSQLI_ASSOC);
mysqli_free_result($result);
mysqli_close($connect);
foreach($details as $detail) {
if($username == $detail['Username']) {
echo "<tr><td colspan='7'>Username already in use!</td></tr>";
if($name == $detail['Name']) {
echo "<tr><td colspan='7'>Name already in use!</td></tr>";
if($email == $detail['email']) {
echo "<tr><td colspan='7'>Email already in use!</td></tr>";
}
}
} else {
$query = 'INSERT INTO AdminUsers (Username, Passwd, LoginKey, Name, email, Level) VALUES ('.$username.', '.md5($password).', '.$key.', '.$name.', '.$email.', '.$level.')';
$result = mysqli_query($connect, $query);
echo "<tr><td>New User added</td></tr>";
}
}
?>
dan komt dan nog bij deze codes die erbij horen
header.php
Code (php)
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
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
<?php
// header.php
session_start();
include("./inc/dbase.php");
echo "
<BODY>
<head>
<link rel='stylesheet' href='./inc/style.css'>
</head>
<div class='content'>";
echo $_SESSION['Level'];
echo "
<table class='table'>
";
if(isset($_SESSION['Username'])){
echo "
<tr>
<td colspan='3'>Welcome back <font color='ff9900'><b>".$_SESSION['Name']."</b></font></td>
<td colspan='3' align='right'><a href='./inc/logout.php'>logout</a></td>
<td align='right'><a href='./index.php?menu=users'>Users</a>
</td>
</tr>";
}
echo" <tr>
<td colspan='7'>
<img src='./img/banner_small.png'>
</td>
</tr>
";
?>
// header.php
session_start();
include("./inc/dbase.php");
echo "
<BODY>
<head>
<link rel='stylesheet' href='./inc/style.css'>
</head>
<div class='content'>";
echo $_SESSION['Level'];
echo "
<table class='table'>
";
if(isset($_SESSION['Username'])){
echo "
<tr>
<td colspan='3'>Welcome back <font color='ff9900'><b>".$_SESSION['Name']."</b></font></td>
<td colspan='3' align='right'><a href='./inc/logout.php'>logout</a></td>
<td align='right'><a href='./index.php?menu=users'>Users</a>
</td>
</tr>";
}
echo" <tr>
<td colspan='7'>
<img src='./img/banner_small.png'>
</td>
</tr>
";
?>
view.php
Code (php)
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
66
67
68
69
70
71
72
73
74
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
66
67
68
69
70
71
72
73
74
<?php
// view.php
echo $_GET['menu'];
echo "
<tr class='tr'>
<td colspan='7'>
";
if(!$_GET['menu']) {
include("inc/welcome.php");
}
if($_GET['menu'] == 'news') {
include("inc/news.php");
// echo "News Page";
}
if($_GET['menu'] == 'addnews') {
include("inc/addnews.php");
}
if($_GET['menu'] == 'delnews') {
include("inc/delnews.php");
}
if($_GET['menu'] == 'editnews') {
include("inc/editnews.php");
}
if($_GET['menu'] == 'activate') {
include("inc/activation.php");
}
if($_GET['menu'] == 'deactivate') {
include("inc/activation.php");
}
if($_GET['menu'] == 'quallity') {
include("inc/quallity.php");
}
if($_GET['menu'] == 'info') {
include("inc/info.php");
}
if($_GET['menu'] == 'editprofile') {
include("inc/editprofile.php");
}
if($_GET['menu'] == 'gallery') {
include("inc/gallery.php");
}
if($_GET['menu'] == 'order') {
include("inc/order.php");
}
if($_GET['menu'] == 'contact') {
include("inc/contact.php");
}
if($_GET['menu'] == 'read') {
include("inc/readmail.php");
}
if($_GET['menu'] == 'back') {
include("inc/mailsaw.php");
}
if($_GET['menu'] == 'delmail') {
include("inc/delmail.php");
}
if($_GET['menu'] == 'addcontact') {
include("inc/addcontact.php");
}
if($_GET['menu'] == 'users') {
include("inc/users.php");
}
if($_GET['menu'] == 'newuser') {
include("inc/newuser.php");
}
if($_GET['menu'] == 'newuseradd') {
include("inc/newuseradd.php");
}
echo "
</td>
</tr>
";
?>
// view.php
echo $_GET['menu'];
echo "
<tr class='tr'>
<td colspan='7'>
";
if(!$_GET['menu']) {
include("inc/welcome.php");
}
if($_GET['menu'] == 'news') {
include("inc/news.php");
// echo "News Page";
}
if($_GET['menu'] == 'addnews') {
include("inc/addnews.php");
}
if($_GET['menu'] == 'delnews') {
include("inc/delnews.php");
}
if($_GET['menu'] == 'editnews') {
include("inc/editnews.php");
}
if($_GET['menu'] == 'activate') {
include("inc/activation.php");
}
if($_GET['menu'] == 'deactivate') {
include("inc/activation.php");
}
if($_GET['menu'] == 'quallity') {
include("inc/quallity.php");
}
if($_GET['menu'] == 'info') {
include("inc/info.php");
}
if($_GET['menu'] == 'editprofile') {
include("inc/editprofile.php");
}
if($_GET['menu'] == 'gallery') {
include("inc/gallery.php");
}
if($_GET['menu'] == 'order') {
include("inc/order.php");
}
if($_GET['menu'] == 'contact') {
include("inc/contact.php");
}
if($_GET['menu'] == 'read') {
include("inc/readmail.php");
}
if($_GET['menu'] == 'back') {
include("inc/mailsaw.php");
}
if($_GET['menu'] == 'delmail') {
include("inc/delmail.php");
}
if($_GET['menu'] == 'addcontact') {
include("inc/addcontact.php");
}
if($_GET['menu'] == 'users') {
include("inc/users.php");
}
if($_GET['menu'] == 'newuser') {
include("inc/newuser.php");
}
if($_GET['menu'] == 'newuseradd') {
include("inc/newuseradd.php");
}
echo "
</td>
</tr>
";
?>
Als iets niet werkt, probeer dit eens in een compacte testcase te plaatsen. Hele lappen code op een forum plaatsen levert vaak weinig animo op voor anderen om door te spitten.
Je zou je 209 regels prima kunnen bewoorden in +/- 15 regels.
Echter wanneer ik hem aanroep doormiddel van include, laadt hij niet door.
De reden ervan is mij onduidelijk.
Misschien had ik idd de codes wat kunnen inkorten, maar zo zie je wel de hele structuur.
Maar ik ben ook steeds opzoek, maar meer ogen zien meer
Toevoeging op 05/06/2022 17:51:24:
De new user aanroepen doet hij wel, maar zodra hij dus moet controleren of de user bestaat, klapt de page vast.
Doe ik hem zeg maar op de achtergrond, dan doet hij het wel. dan moet ik wel de dbase.php includen.
Dus ja ik stress hier een beetje van
Toevoeging op 05/06/2022 17:52:25:
en php checker geeft geen fout aan
Op een gegeven moment kom je op de plek waar ongeveer het probleem in zit, waarbij je een hele hoop, op dat moment overbodige code, aan de kant hebt geschoven en je script voor 90% hebt kaalgesnoeid.
Dan heb je juist ook het beste overzicht.
Gewijzigd op 05/06/2022 17:53:05 door - Ariën -
Want de newuseradd is belangrijk. die moet controleren of de user niet al bestaat.
Toevoeging op 05/06/2022 18:18:39:
Ik had 1 ding over het hoofd gezien
Code (php)
1
2
3
4
5
6
7
8
2
3
4
5
6
7
8
<?php
$username = $_GET['username'];
$password = $_GET['password'];
$key = $_GET['key'];
$name = $_GET['name'];
$email = $_GET['email'];
$level = $_GET['level'];
?>
$username = $_GET['username'];
$password = $_GET['password'];
$key = $_GET['key'];
$name = $_GET['name'];
$email = $_GET['email'];
$level = $_GET['level'];
?>
maar dat moest dit zijn
Code (php)
1
2
3
4
5
6
7
8
2
3
4
5
6
7
8
<?php
$username = $_POST['username'];
$password = $_POST['password'];
$key = $_POST['key'];
$name = $_POST['name'];
$email = $_POST['email'];
$level = $_POST['level'];
?>
$username = $_POST['username'];
$password = $_POST['password'];
$key = $_POST['key'];
$name = $_POST['name'];
$email = $_POST['email'];
$level = $_POST['level'];
?>
De controlle doet hij nu, maar toevoegen nog niet.
Arno van Zanten op 05/06/2022 18:15:14:
welke code zou ik dan moeten snoeien?
Wat overbodig is. Allereerst die hele berg aan includes. Dan kan je heel HTML wegsnoeien.
En kijk ook welke scripts ergens betrekking op hebben.
Quote:
Want de newuseradd is belangrijk. die moet controleren of de user niet al bestaat.
Uiteindelijk wel, maar omdat het includeren niet werkt is dit een bijzaak. Dus dit kan je ook gerust wegsnoeien.
Als het toevoegen niet werkt, vertel dan WAT er niet werkt, en WAT er gebeurt?
Gewijzigd op 05/06/2022 18:21:17 door - Ariën -
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
2
3
4
5
6
7
8
9
10
11
12
<?php
echo "<tr><td colspan='7'>Input new user</td></tr>";
$query = 'INSERT INTO AdminUsers
(Username, Passwd, LoginKey, Name, email, Level)
VALUES
("'.$username.'", "'.md5($password).'", "'.$key.'", "'.$name.'", "'.$email.'", "'.$level.'")';
$result = mysqli_query($connect, $query);
echo "<tr><td colspan='7'>".$query."</td></tr>";
?>
echo "<tr><td colspan='7'>Input new user</td></tr>";
$query = 'INSERT INTO AdminUsers
(Username, Passwd, LoginKey, Name, email, Level)
VALUES
("'.$username.'", "'.md5($password).'", "'.$key.'", "'.$name.'", "'.$email.'", "'.$level.'")';
$result = mysqli_query($connect, $query);
echo "<tr><td colspan='7'>".$query."</td></tr>";
?>
- Ik zie dat je wel mysqli_real_escape-string() mist om je query te beschermen. Pas deze toe
- Bouw een controle op $result of deze false is. In dat geval toon je mysqli_error($conn), en anders geef je de uitvoer aan.
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
<?php
echo "<tr><td colspan='7'>Input new user</td></tr>";
$query = 'INSERT INTO AdminUsers
(Username, Passwd, LoginKey, Name, email, Level)
VALUES
("'.$username.'", "'.md5($password).'", "'.$key.'", "'.$name.'", "'.$email.'", "'.$level.'")';
echo "<tr><td colspan='7'>".$query."</td></tr>";
$result = mysqli_query($connect, $query);
echo "<tr><td colspan='7'>".$query."</td></tr>";
if(mysqli_query($connect, $query)) {
echo "<br>Record Updated Succesfully";
} else {
echo "<br>Error Updating record";
}
echo "<tr><td>New User added</td></tr>";
?>
echo "<tr><td colspan='7'>Input new user</td></tr>";
$query = 'INSERT INTO AdminUsers
(Username, Passwd, LoginKey, Name, email, Level)
VALUES
("'.$username.'", "'.md5($password).'", "'.$key.'", "'.$name.'", "'.$email.'", "'.$level.'")';
echo "<tr><td colspan='7'>".$query."</td></tr>";
$result = mysqli_query($connect, $query);
echo "<tr><td colspan='7'>".$query."</td></tr>";
if(mysqli_query($connect, $query)) {
echo "<br>Record Updated Succesfully";
} else {
echo "<br>Error Updating record";
}
echo "<tr><td>New User added</td></tr>";
?>
Toevoeging op 05/06/2022 18:59:49:
na de echo input new user, blijft hij hangen.
Je zou met deze code minimaal de inhoud van $query moeten zien.
Als de gebruiker niet bestaat, gaat hij naar de insert toe en daar blijft hij steken.
Code (php)
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
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
<?php
$username = $_POST['username'];
$password = $_POST['password'];
$key = $_POST['key'];
$name = $_POST['name'];
$email = $_POST['email'];
$level = $_POST['level'];
$sql = 'SELECT * FROM AdminUsers';
$result = mysqli_query($connect, $sql);
$details = mysqli_fetch_all($result, MYSQLI_ASSOC);
mysqli_free_result($result);
mysqli_close($connect);
foreach($details as $detail) {
if($username == $detail['Username']) {
echo "<tr><td colspan='7'>Username already in use!</td></tr>";
if($name == $detail['Name']) {
echo "<tr><td colspan='7'>Name already in use!</td></tr>";
if($email == $detail['email']) {
echo "<tr><td colspan='7'>Email already in use!</td></tr>";
}
}
} else {
echo "<tr><td colspan='7'>Input new user</td></tr>";
$query = 'INSERT INTO AdminUsers
(Username, Passwd, LoginKey, Name, email, Level)
VALUES
("'.$username.'", "'.md5($password).'", "'.$key.'", "'.$name.'", "'.$email.'", "'.$level.'")';
echo "<tr><td colspan='7'>".$query."</td></tr>";
$result = mysqli_query($connect, $query);
echo "<tr><td colspan='7'>".$query."</td></tr>";
if(mysqli_query($connect, $query)) {
echo "<br>Record Updated Succesfully";
} else {
echo "<br>Error Updating record";
}
echo "<tr><td>New User added</td></tr>";
}
}
?>
$username = $_POST['username'];
$password = $_POST['password'];
$key = $_POST['key'];
$name = $_POST['name'];
$email = $_POST['email'];
$level = $_POST['level'];
$sql = 'SELECT * FROM AdminUsers';
$result = mysqli_query($connect, $sql);
$details = mysqli_fetch_all($result, MYSQLI_ASSOC);
mysqli_free_result($result);
mysqli_close($connect);
foreach($details as $detail) {
if($username == $detail['Username']) {
echo "<tr><td colspan='7'>Username already in use!</td></tr>";
if($name == $detail['Name']) {
echo "<tr><td colspan='7'>Name already in use!</td></tr>";
if($email == $detail['email']) {
echo "<tr><td colspan='7'>Email already in use!</td></tr>";
}
}
} else {
echo "<tr><td colspan='7'>Input new user</td></tr>";
$query = 'INSERT INTO AdminUsers
(Username, Passwd, LoginKey, Name, email, Level)
VALUES
("'.$username.'", "'.md5($password).'", "'.$key.'", "'.$name.'", "'.$email.'", "'.$level.'")';
echo "<tr><td colspan='7'>".$query."</td></tr>";
$result = mysqli_query($connect, $query);
echo "<tr><td colspan='7'>".$query."</td></tr>";
if(mysqli_query($connect, $query)) {
echo "<br>Record Updated Succesfully";
} else {
echo "<br>Error Updating record";
}
echo "<tr><td>New User added</td></tr>";
}
}
?>
Arno van Zanten op 05/06/2022 18:58:45:
na de echo input new user, blijft hij hangen.
Wat is hangen? Blauw scherm? Blijft het resfreshen? Bevriest je PC?
Echt, wees gewoon eens duidelijk. Zeg gewoon gedetailleerd mogelijk wat je op je scherm ziet, en wat er gebeurt.
Gewijzigd op 05/06/2022 19:02:16 door - Ariën -
Je zou dan ook moeten zien wat de query doet:
Record Updated Succesfully of Error Updating record
Ook raad ik aan om bovenaan je script dit te plaatsen:
Code (php)
1
2
3
4
5
2
3
4
5
<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
?>
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
?>
Je wilt tenslotte ALLE error's zien.
Gewijzigd op 05/06/2022 19:10:19 door - Ariën -
Fatal error: Uncaught Error: mysqli object is already closed in /www/test/admin/inc/newuseradd.php:38 Stack trace: #0 /www/test/admin/inc/newuseradd.php(38): mysqli_query(Object(mysqli), 'INSERT INTO Adm...') #1 /www/test/admin/inc/view.php(67): include('/www/test/admin...') #2 /www/test/admin/index.php(12): include('/www/test/admin...') #3 {main} thrown in /www/test/admin/inc/newuseradd.php on line 38