SHOW:
|
|
- or go back to the newest paste.
1 | <!DOCTYPE html> | |
2 | <html lang="en"> | |
3 | <head> | |
4 | <title>SQL Test</title> | |
5 | - | <script src="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootst rap.min.js"></script> |
5 | + | <script src="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js"></script> |
6 | - | <link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/bootstrap /3.2.0/css/bootstrap.min.css"> |
6 | + | <link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css"> |
7 | - | <meta name="viewport" content="width=device-width, initial-scale =1"> |
7 | + | <meta name="viewport" content="width=device-width, initial-scale=1"> |
8 | </head> | |
9 | <body> | |
10 | <div class="container"> | |
11 | ||
12 | <h2>SQL Test</h2> | |
13 | ||
14 | <?php | |
15 | ||
16 | function generateRandomString($length = 10) { | |
17 | - | $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDE FGHIJKLMNOPQRSTUVWXYZ'; |
17 | + | $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ'; |
18 | $randomString = ''; | |
19 | for ($i = 0; $i < $length; $i++) { | |
20 | - | $randomString .= $characters[rand(0, strlen($cha racters) - 1)]; |
20 | + | $randomString .= $characters[rand(0, strlen($characters) - 1)]; |
21 | } | |
22 | return $randomString; | |
23 | } | |
24 | ||
25 | - | $con = mysqli_connect("mariadb","super","AXpbZ5XlkL8i1KT9","test "); |
25 | + | $con = mysqli_connect("mariadb","super","AXpbZ5XlkL8i1KT9","test"); |
26 | ||
27 | // Check connection | |
28 | if (mysqli_connect_errno()) | |
29 | { | |
30 | - | echo "Failed to connect to MySQL: " . mysqli_connect_err or(); |
30 | + | echo "Failed to connect to MySQL: " . mysqli_connect_error(); |
31 | } | |
32 | ||
33 | $randtxt = generateRandomString(); | |
34 | $randint = rand(0, 2147483647); | |
35 | ||
36 | - | mysqli_query($con,"INSERT INTO table_1(col1, col2) VALUES ('$ran dtxt', $randint);"); |
36 | + | mysqli_query($con,"INSERT INTO table_1(col1, col2) VALUES ('$randtxt', $randint);"); |
37 | ||
38 | $result = mysqli_query($con,"SELECT * FROM table_1;"); | |
39 | ||
40 | echo "<table class=\"table table-hover\">"; | |
41 | echo "<tr><th>Text</th>"; | |
42 | #echo "<th>B64 decode</th>"; | |
43 | echo "<th>Number</th>"; | |
44 | #echo "<th>Fraction</th></tr>"; | |
45 | while($row = mysqli_fetch_array($result)) { | |
46 | echo "<tr>"; | |
47 | echo "<td>" . $row['col1'] . "</td>"; | |
48 | #echo "<td>" . base64_decode($row['col1']) . "</td>"; | |
49 | echo "<td>" . $row['col2'] . "</td>"; | |
50 | #echo "<td>" . $row['col2'] / 2147483647 . "</td>"; | |
51 | echo "</tr>\n"; | |
52 | } | |
53 | echo "</table>"; | |
54 | ||
55 | mysqli_close($con); | |
56 | ||
57 | ?> | |
58 | ||
59 | </div> | |
60 | </body> | |
61 | </html> |