De PHPhulp kroeg
WHILE lus zonder echo
Maar hoe kan ik hetzelfde script nou uitvoeren zonder ze te echo te geven?
Ja dat was een inkoppertje ;).
@Michiel,
Als je het niet wilt echo'en waarom dan een while lus maken?
Kun je iets duidelijker zijn?
1) Je wil een kolom of een rij ophalen?
2) Wat wil je met een while loop doen als je maar 1 kolom/rij opvraagt?
3) Wat of hoe wil je dan andere kolommen/rijen updaten?
Het is een beetje onduidelijk wat je nu precies wil ;)
Zie onderstaand het script het werkt en update de gegevens naar de datababa. Maar ik wil dit script niet zichtbaar tonen. Ik wil alleen de geupdate gegevens tonen.
Zie script:
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
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
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
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
<?php
// query Categorien ophalen uit datebase
$sql = "
SELECT * FROM category ";
$result = mysql_query($sql) or die(mysql_error());
// Resulaten ophalen van de query $result
while ($row = mysql_fetch_array($result)){
//****SCRIPT berekenen hoevel advertenties er zijn per land en resultaten direct updaten***//
// Onderstaande script per category uitvoeren
$categoryID = $row['categoryID'];
// ALL Advertenties
$sql_ALL = "
SELECT count('categoryID') AS count FROM product WHERE categoryID = $categoryID ";
$res_ALL = mysql_query($sql_ALL) or die('Sorry, we could not count the number of results' . mysql_error());
$total_ALL = mysql_fetch_assoc($res_ALL);
$total_results_ALL = $total_ALL['count'];
$catteller_ALL = ceil($total_results_ALL);
$result_ALL = mysql_query($sql_ALL) or die(mysql_error());
// NIEUW aantal updaten in de database
mysql_query("UPDATE category SET
`catTotalAds_ALL` = '$catteller_ALL'
WHERE categoryID = $categoryID
") or die(mysql_error());
// END ALL advertenties
// NL Advertenties
$sql_NL = "
SELECT count('product.productID') AS count, users.country FROM product, users
WHERE product.categoryID = $categoryID
AND users.country = 'Nederland'
AND product.usersID = users.id
";
$res_NL = mysql_query($sql_NL) or die('Sorry, we could not count the number of results' . mysql_error());
$total_NL = mysql_fetch_assoc($res_NL);
$total_results_NL = $total_NL['count'];
$catteller_NL = ceil($total_results_NL);
$result_NL = mysql_query($sql_NL) or die(mysql_error());
// NIEUW aantal updaten in de database
mysql_query("UPDATE category SET
`catTotalAds_NL` = '$catteller_NL'
WHERE categoryID = $categoryID
") or die(mysql_error());
// END NL advertenties
// BE Advertenties
$sql_BE = "
SELECT count('product.productID') AS count, users.country FROM product, users
WHERE product.categoryID = $categoryID
AND users.country = 'Belgie'
AND product.usersID = users.id
";
$res_BE = mysql_query($sql_BE) or die('Sorry, we could not count the number of results' . mysql_error());
$total_BE = mysql_fetch_assoc($res_BE);
$total_results_BE = $total_BE['count'];
$catteller_BE = ceil($total_results_BE);
$result_BE = mysql_query($sql_BE) or die(mysql_error());
// NIEUW aantal updaten in de database
mysql_query("UPDATE category SET
`catTotalAds_BE` = '$catteller_BE'
WHERE categoryID = $categoryID
") or die(mysql_error());
// END BE advertenties
// UK Advertenties
$sql_UK = "
SELECT count('product.productID') AS count, users.country FROM product, users
WHERE product.categoryID = $categoryID
AND users.country = 'UK'
AND product.usersID = users.id
";
// OTHER Advertenties
$sql_OTHER = "
SELECT count('product.productID') AS count, users.country FROM product, users
WHERE product.categoryID = $categoryID
AND users.country NOT LIKE 'Nederland'
AND users.country NOT LIKE 'Belgie'
AND users.country NOT LIKE 'Germany'
AND users.country NOT LIKE 'France'
AND users.country NOT LIKE 'Spain'
AND users.country NOT LIKE 'UK'
AND users.country NOT LIKE 'USA'
AND product.usersID = users.id
";
$res_OTHER = mysql_query($sql_OTHER) or die('Sorry, we could not count the number of results' . mysql_error());
$total_OTHER = mysql_fetch_assoc($res_OTHER);
$total_results_OTHER = $total_OTHER['count'];
$catteller_OTHER = ceil($total_results_OTHER);
$result_OTHER = mysql_query($sql_OTHER) or die(mysql_error());
// NIEUW aantal updaten in de database
mysql_query("UPDATE category SET
`catTotalAds_OTHER` = '$catteller_OTHER'
WHERE categoryID = $categoryID
") or die(mysql_error());
// END OTHER advertenties
// END AANTAL ADVERTENTIES UPDATEN VAN DE ALL Advertenties in de bepaalde CATEGORY
?>
// query Categorien ophalen uit datebase
$sql = "
SELECT * FROM category ";
$result = mysql_query($sql) or die(mysql_error());
// Resulaten ophalen van de query $result
while ($row = mysql_fetch_array($result)){
//****SCRIPT berekenen hoevel advertenties er zijn per land en resultaten direct updaten***//
// Onderstaande script per category uitvoeren
$categoryID = $row['categoryID'];
// ALL Advertenties
$sql_ALL = "
SELECT count('categoryID') AS count FROM product WHERE categoryID = $categoryID ";
$res_ALL = mysql_query($sql_ALL) or die('Sorry, we could not count the number of results' . mysql_error());
$total_ALL = mysql_fetch_assoc($res_ALL);
$total_results_ALL = $total_ALL['count'];
$catteller_ALL = ceil($total_results_ALL);
$result_ALL = mysql_query($sql_ALL) or die(mysql_error());
// NIEUW aantal updaten in de database
mysql_query("UPDATE category SET
`catTotalAds_ALL` = '$catteller_ALL'
WHERE categoryID = $categoryID
") or die(mysql_error());
// END ALL advertenties
// NL Advertenties
$sql_NL = "
SELECT count('product.productID') AS count, users.country FROM product, users
WHERE product.categoryID = $categoryID
AND users.country = 'Nederland'
AND product.usersID = users.id
";
$res_NL = mysql_query($sql_NL) or die('Sorry, we could not count the number of results' . mysql_error());
$total_NL = mysql_fetch_assoc($res_NL);
$total_results_NL = $total_NL['count'];
$catteller_NL = ceil($total_results_NL);
$result_NL = mysql_query($sql_NL) or die(mysql_error());
// NIEUW aantal updaten in de database
mysql_query("UPDATE category SET
`catTotalAds_NL` = '$catteller_NL'
WHERE categoryID = $categoryID
") or die(mysql_error());
// END NL advertenties
// BE Advertenties
$sql_BE = "
SELECT count('product.productID') AS count, users.country FROM product, users
WHERE product.categoryID = $categoryID
AND users.country = 'Belgie'
AND product.usersID = users.id
";
$res_BE = mysql_query($sql_BE) or die('Sorry, we could not count the number of results' . mysql_error());
$total_BE = mysql_fetch_assoc($res_BE);
$total_results_BE = $total_BE['count'];
$catteller_BE = ceil($total_results_BE);
$result_BE = mysql_query($sql_BE) or die(mysql_error());
// NIEUW aantal updaten in de database
mysql_query("UPDATE category SET
`catTotalAds_BE` = '$catteller_BE'
WHERE categoryID = $categoryID
") or die(mysql_error());
// END BE advertenties
// UK Advertenties
$sql_UK = "
SELECT count('product.productID') AS count, users.country FROM product, users
WHERE product.categoryID = $categoryID
AND users.country = 'UK'
AND product.usersID = users.id
";
// OTHER Advertenties
$sql_OTHER = "
SELECT count('product.productID') AS count, users.country FROM product, users
WHERE product.categoryID = $categoryID
AND users.country NOT LIKE 'Nederland'
AND users.country NOT LIKE 'Belgie'
AND users.country NOT LIKE 'Germany'
AND users.country NOT LIKE 'France'
AND users.country NOT LIKE 'Spain'
AND users.country NOT LIKE 'UK'
AND users.country NOT LIKE 'USA'
AND product.usersID = users.id
";
$res_OTHER = mysql_query($sql_OTHER) or die('Sorry, we could not count the number of results' . mysql_error());
$total_OTHER = mysql_fetch_assoc($res_OTHER);
$total_results_OTHER = $total_OTHER['count'];
$catteller_OTHER = ceil($total_results_OTHER);
$result_OTHER = mysql_query($sql_OTHER) or die(mysql_error());
// NIEUW aantal updaten in de database
mysql_query("UPDATE category SET
`catTotalAds_OTHER` = '$catteller_OTHER'
WHERE categoryID = $categoryID
") or die(mysql_error());
// END OTHER advertenties
// END AANTAL ADVERTENTIES UPDATEN VAN DE ALL Advertenties in de bepaalde CATEGORY
?>
<tr>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
Code (php)
1
2
3
4
2
3
4
<?php
} //while afsluiten
?>
} //while afsluiten
?>
Die while lus is voor je catagorieen, zodat heel die queries op elke catagorie gedraaid wordt.
Heb je dit script zelf geschreven of van internet geplukt?
$row['categoryNAME_NL'];
$row['categoryID'];
$row['catTotalAds_ALL'];
$row['catTotalAds_OTHER'];
$row['catTotalAds_NL'];
$row['catTotalAds_BE'];
$row['catTotalAds_UK'];
$row['catTotalAds_USA'];
$row['catTotalAds_DE'];
$row['catTotalAds_FR'];
$row['catTotalAds_SE'];
Toevoeging op 25/05/2012 10:01:21:
jep ik weet dat ik daarmeee de gegevens als een lijst ophaal en daarna weer update in de datebase. Maar dit moet alleen niet zichtbaar gebeuren.
$row[0];
$row[1];
$row[2];
$row[3];
$row[4];
$row[5];
$row[6];
$row[7];
$row[8];
$row[9];
$row[10];
Toevoeging op 25/05/2012 10:15:51:
krijg dan de onderstaande foutmelding:
totaalMoreInStockPRICE3.value; var rlength = 2; // The number of decimal places to round to if (rnum > 8191 && rnum < 10485) { rnum = rnum-5000; var newnumber = Math.round(rnum*Math.pow(10,rlength))/Math.pow(10,rlength); newnumber = newnumber+5000; } else { var newnumber = Math.round(rnum*Math.pow(10,rlength))/Math.pow(10,rlength); } totaalMoreInStockPRICE3.value = newnumber; } function validate1(field) { var valid = "0123456789" var ok = "yes"; var temp; for (var i=0; i
Er gaat dus iets fout in je script :D
Toevoeging op 25/05/2012 10:40:22:
Hoi Chris,
Ik heb het gevonden.Ik had onnodige regels zie voorbeeld: $result_NL = mysql_query($sql_NL) or die(mysql_error());
Bedankt voor je hulp en fijn pinksterweekend!
Groeten,
Michiel
Graag gedaan, jij ook!