*************

SQL code: Upload Copy Format Clear

webtintuc.sql CREATE DATABASE webtintuc; USE webtintuc; CREATE TABLE webtm_sanpham ( id INT AUTO_INCREMENT PRIMARY KEY, tenSP VARCHAR(255) NOT NULL, UrlHinh VARCHAR(255) NOT NULL, Gia INT NOT NULL );

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?php declare(strict_types=1); ?> <body> <?php include("db_con.php"); $db = new dbcon(); $sp =10; $kq1 = $db->ListSanPham(); $tsp = mysqli_num_rows($kq1); $tst =ceil($tsp / $sp); if(isset($_GET['page'])) $page=$_GET['page']; else $page= 1; $vitri = ($page-1)*$sp; ?> <table width="600" border="1" style="margin:auto"> <tr> <th>STT</th> <th>Tên sản phẩm</th> <th>Hình</th> <th>Giá</th> </tr> <tr> <?php $kq2 = $db->ListSanPhamTheoViTri($vitri, $sp); $i =1; while( $row = $kq2->fetch_assoc()) { ?> <td align="center"><?php echo $i++;?></td> <td><?php echo $row['tenSP'];?></td> <td align="center"><img src="img/<?php echo $row['UrlHinh'];?>" height="100px"></td> <td align="right"><?php echo $row['Gia']."000đ";?></td> </tr> <?php } ?> </table> <p align="center">Trang: <?php for($i=1; $i<=$tst; $i++){ if ($i == $page) echo "<span style='font-size:20px; color:red; font-weight:bold'>".$i."</span> "; else echo "<a href='dsSanPham.php?page=$i'>$i</a>  "; } ?></p> </body>

PHP version:

Show: Warnings Notice

Result: Copy Clear

PHPize Online / SQLize Online / SQLtest Online