Tijden veranderen
Mysql help
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
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
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
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
<?php
$title = "Crime Script!";
include("connect.php");
echo "<center><b><h1>Test Crimes v.11 alpha</h1></b><br></center>";
echo "<hr><b><br>";
echo "<form action=\"{$_SERVER['PHP_SELF']}\" method=\"post\">";
$crime = array(
1 => "rob a bank",
2 => "rob a train",
3 => "rob a gas station",
4 => "pick pocket",
5 => "steal candy from a child"
);
array_push($crime,"rob a museum", "mug some one on the street", "deal drugs", "hostage a celeb");
$money1 = array(
1 => "1024",
2 => "2386",
3 => "1348",
4 => "2786",
5 => "3085"
);
$money1 = "\$".number_format($money1[mt_rand(1,count($money1))]);
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[9]\">";
echo $crime['9'];
echo '<br>';
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[6]\">";
echo $crime['6'];
echo '<br>';
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[1]\">";
echo $crime['1'];
echo '<br>';
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[2]\">";
echo $crime['2'];
echo '<br>';
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[3]\">";
echo $crime['3'];
echo '<br>';
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[8]\">";
echo $crime['8'];
echo '<br>';
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[7]\">";
echo $crime['7'];
echo '<br>';
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[4]\">";
echo $crime['4'];
echo '<br>';
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[5]\">";
echo $crime['5'];
echo "<br><br>";
echo "<input type=\"submit\" name=\"submit\" value=\"commit crime\">";
echo "</b><hr><br>";
echo '<center><b>';
if (isset($_POST['submit']) && isset($_POST['crime']) && in_array($_POST['crime'],$crime)) {
$success['a'] = mt_rand(10,15);
$success['b'] = mt_rand(10,15);
if ($_POST['crime'] == $crime['9'] && $success['a'] == $success['b']) {
echo "You succesfully hostaged a celeb! and recieved $money1 from the crime!";
}
elseif ($_POST['crime'] == $crime['6'] && $success['a'] == $success['b']) {
echo "You succesfully robbed a museum, stole some expensive artifacts! and recieved $money1 from the crime!";
}
elseif ($_POST['crime'] == $crime['1'] && $success['a'] == $success['b']) {
echo "You succesfully robbed the bank! and recieved $money1 from the crime!";
}
elseif ($_POST['crime'] == $crime['2'] && $success['a'] == $success['b']) {
echo "You succesfully robbed the train! and recieved $money1 from the crime!";
}
elseif ($_POST['crime'] == $crime['3'] && $success['a'] == $success['b']) {
echo "You succesfully robbed a gas station! and recieved $money1 from the crime!";
}
elseif ($_POST['crime'] == $crime['8'] && $success['a'] == $success['b']) {
echo "You succesfully dealed some drugs! and recieved $money1 from the crime!";
}
elseif ($_POST['crime'] == $crime['7'] && $success['a'] == $success['b']) {
echo "You succesfully mugged some-one! and recieved $money1 from the crime!";
}
elseif ($_POST['crime'] == $crime['4'] && $success['a'] == $success['b']) {
echo "You succesfully pick pocked someone! and recieved $money1 from the crime!";
}
elseif ($_POST['crime'] == $crime['5'] && $success['a'] == $success['b']) {
echo "You succesfully stole candy from a child! and recieved $money1 from the crime!";
}
else {
echo "You failed to $_POST[crime]! Better luck next time!";
}
}
echo '</center></b>';
echo "</form>";
?>
$title = "Crime Script!";
include("connect.php");
echo "<center><b><h1>Test Crimes v.11 alpha</h1></b><br></center>";
echo "<hr><b><br>";
echo "<form action=\"{$_SERVER['PHP_SELF']}\" method=\"post\">";
$crime = array(
1 => "rob a bank",
2 => "rob a train",
3 => "rob a gas station",
4 => "pick pocket",
5 => "steal candy from a child"
);
array_push($crime,"rob a museum", "mug some one on the street", "deal drugs", "hostage a celeb");
$money1 = array(
1 => "1024",
2 => "2386",
3 => "1348",
4 => "2786",
5 => "3085"
);
$money1 = "\$".number_format($money1[mt_rand(1,count($money1))]);
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[9]\">";
echo $crime['9'];
echo '<br>';
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[6]\">";
echo $crime['6'];
echo '<br>';
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[1]\">";
echo $crime['1'];
echo '<br>';
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[2]\">";
echo $crime['2'];
echo '<br>';
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[3]\">";
echo $crime['3'];
echo '<br>';
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[8]\">";
echo $crime['8'];
echo '<br>';
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[7]\">";
echo $crime['7'];
echo '<br>';
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[4]\">";
echo $crime['4'];
echo '<br>';
echo "<input type=\"radio\" name=\"crime\" value=\"$crime[5]\">";
echo $crime['5'];
echo "<br><br>";
echo "<input type=\"submit\" name=\"submit\" value=\"commit crime\">";
echo "</b><hr><br>";
echo '<center><b>';
if (isset($_POST['submit']) && isset($_POST['crime']) && in_array($_POST['crime'],$crime)) {
$success['a'] = mt_rand(10,15);
$success['b'] = mt_rand(10,15);
if ($_POST['crime'] == $crime['9'] && $success['a'] == $success['b']) {
echo "You succesfully hostaged a celeb! and recieved $money1 from the crime!";
}
elseif ($_POST['crime'] == $crime['6'] && $success['a'] == $success['b']) {
echo "You succesfully robbed a museum, stole some expensive artifacts! and recieved $money1 from the crime!";
}
elseif ($_POST['crime'] == $crime['1'] && $success['a'] == $success['b']) {
echo "You succesfully robbed the bank! and recieved $money1 from the crime!";
}
elseif ($_POST['crime'] == $crime['2'] && $success['a'] == $success['b']) {
echo "You succesfully robbed the train! and recieved $money1 from the crime!";
}
elseif ($_POST['crime'] == $crime['3'] && $success['a'] == $success['b']) {
echo "You succesfully robbed a gas station! and recieved $money1 from the crime!";
}
elseif ($_POST['crime'] == $crime['8'] && $success['a'] == $success['b']) {
echo "You succesfully dealed some drugs! and recieved $money1 from the crime!";
}
elseif ($_POST['crime'] == $crime['7'] && $success['a'] == $success['b']) {
echo "You succesfully mugged some-one! and recieved $money1 from the crime!";
}
elseif ($_POST['crime'] == $crime['4'] && $success['a'] == $success['b']) {
echo "You succesfully pick pocked someone! and recieved $money1 from the crime!";
}
elseif ($_POST['crime'] == $crime['5'] && $success['a'] == $success['b']) {
echo "You succesfully stole candy from a child! and recieved $money1 from the crime!";
}
else {
echo "You failed to $_POST[crime]! Better luck next time!";
}
}
echo '</center></b>';
echo "</form>";
?>
Ik zou zeggen, ga het zelf leren...
en ik dacht dat dit een hulp site was voor vragen en dergelijk : (
GJ:
is het zoveel gevraagd dan ? volgens mij zijn dat 2 regels,. en 1 table,. ik krijg het alleen niet voor elkaar,
en ik dacht dat dit een hulp site was voor vragen en dergelijk : (
en ik dacht dat dit een hulp site was voor vragen en dergelijk : (
1) Vreemd dat je al die code kan schrijven maar de waarde van één variabele, sorry array niet in een database krijgt?
2) Als het dan toch maar iets is van een tabel en twee regels kan het voor u geen probleem zijn dit zelf te vinden. Weet je wat helpt? Ga eens een wandelingetje maken buiten. Een frisse neus en een helder hoofd op doen. Helpt wanneer je uren naar je scherm hebt zitten staren, doen! ;o)
3) Als je het daarna zelf hebt gevonden is de voldoening des te groter. :o)
4) Dit is inderdaad een hulp forum. Schrijf die query eens, we zullen kijken wat er mis mee is.
5) Criminals? Dat is hier verboden. klik
het wil me echt niet lukken..
of een aantal aanwijzingen geven, zodat ik weet waar ik moet zoeken.
En zet
error_reporting(E_ALL);
bovenaan je script... Misschien wordt je daar wat wijzer van....
Gewijzigd op 02/03/2005 17:21:00 door Willem Jan Z
Code (php)
1
2
3
4
2
3
4
<?$sql = "INSERT INTO #tabel# VALUES('id','$crime','$money1')";
mysql_query($sql);
?>
mysql_query($sql);
?>
oid
groet