Mysql row maximum php
De code is:
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
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
<center><style>
th {
font-size:25px;
font-family:arial;}
</style><?php include 'style.css'?><?php
{ if(isset($_GET['id']))
$id = intval($_GET['id']);
} include "style.css";
if(isset($_GET['club']))
{ $club = $_GET['club']; }
$host = "localhost";
$user = "root";
$pass = "superbart";
$db = "webshop";
$con=mysqli_connect($host, $user, $pass) or die ("Unable to connect!");
mysqli_select_db($con, 'webshop') or die ("Unable to select database!");
$query = "SELECT * FROM winkelwagen WHERE user_id=$id ORDER BY productnaam ASC";
$result = mysqli_query($con,$query) or die ("Error in query: $query. ".mysqli_error());
if (mysqli_num_rows($result) > 0) {
echo "<div class='tabelle'><table height=85px width=300px>";
echo "<tr><th colspan=4><center><b><i>Je winkelwagen:</center><i></b></th></tr>";
while($row = mysqli_fetch_array($result)) {
echo "<td><b><center><img src='" . $row['productnaam'] . ".jpg'class='image2'/></center></b>";
echo "<b><center>".$row['productnaam']."</center></b>";
echo "<b><center>€".$row['prijs'].",-</center></b></td>";}
echo "</table></div>";}
else { echo "Je winkelwagen is leeg!"; }
mysqli_free_result($result);
mysqli_close($con);
?></center>
th {
font-size:25px;
font-family:arial;}
</style><?php include 'style.css'?><?php
{ if(isset($_GET['id']))
$id = intval($_GET['id']);
} include "style.css";
if(isset($_GET['club']))
{ $club = $_GET['club']; }
$host = "localhost";
$user = "root";
$pass = "superbart";
$db = "webshop";
$con=mysqli_connect($host, $user, $pass) or die ("Unable to connect!");
mysqli_select_db($con, 'webshop') or die ("Unable to select database!");
$query = "SELECT * FROM winkelwagen WHERE user_id=$id ORDER BY productnaam ASC";
$result = mysqli_query($con,$query) or die ("Error in query: $query. ".mysqli_error());
if (mysqli_num_rows($result) > 0) {
echo "<div class='tabelle'><table height=85px width=300px>";
echo "<tr><th colspan=4><center><b><i>Je winkelwagen:</center><i></b></th></tr>";
while($row = mysqli_fetch_array($result)) {
echo "<td><b><center><img src='" . $row['productnaam'] . ".jpg'class='image2'/></center></b>";
echo "<b><center>".$row['productnaam']."</center></b>";
echo "<b><center>€".$row['prijs'].",-</center></b></td>";}
echo "</table></div>";}
else { echo "Je winkelwagen is leeg!"; }
mysqli_free_result($result);
mysqli_close($con);
?></center>
- Ariën -:
Gelieve in het vervolg bij code de [code][/code]-tags gebruiken i.p.v. de quote-tags.
Hier kan je meer lezen over de mogelijke opmaakcodes.
Alvast bedankt!
Hier kan je meer lezen over de mogelijke opmaakcodes.
Alvast bedankt!
Gewijzigd op 18/03/2016 11:52:40 door - Ariën -
