list01.php\ud30c\uc77c\uc758 \uc18c\uc2a4\ucf54\ub4dc \uc785\ub2c8\ub2e4.
\uc785\ub825\ub41c \ub370\uc774\ud130\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ubd80\ubd84\uc785\ub2c8\ub2e4.
\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uc18d,\uc778\uc99d \ubd80\ubd84\uc740 \uae30\uc874 \ubd80\ubd84\uacfc \ub3d9\uc77c \ud569\ub2c8\ub2e4.
\uc790\uc138\ud788 \uc0b4\ud3b4\ubd10\uc57c \ub420 \ubd80\ubd84\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n
This is the source code of the list01.php file.
This part shows the entered data.
The database connection and authentication parts are the same as the existing parts.
Here are some things to look at in detail<\/p>\n\n\n\n
1.SQL QUERY<\/strong> 2.$row = $result->fetch_assoc()<\/strong> \uc544\ub798\uc758 \ub9c1\ud06c\ub97c \ud1b5\ud574\uc11c \ud14c\uc2a4\ud2b8 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4
testuser \ud14c\uc774\ube14\uc5d0\uc11c id\ud544\ub4dc\ub97c \uae30\uc900\uc73c\ub85c \ub0b4\ub9bc\ucc28\uc900 \uc815\ub82c\ud558\uace0 10\uac1c\uc758 \uac8c\uc2dc\ubb3c\uc744 0\ubc88\uc9f8 \ub2e4\uc74c\ubd80\ud130 \uac80\uc0c9\ud569\ub2c8\ub2e4.
Sort the testuser table in descending order based on the id field and search for the 10 posts starting from 0.<\/p>\n\n\n\n $sql = \"select * from testuser order by id desc limit 10 offset 0\";\n $result = $mysqli->query($sql);<\/code><\/pre>\n\n\n\n
\uc2e4\ud589\ub41c \uacb0\uacfc\ub97c \ubc30\uc5f4\ub85c \uac00\uc9c0\uace0 \uc640\uc11c \ud654\uba74\uc5d0 \ucd9c\ub825\ud569\ub2c8\ub2e4.
Runs the results and displays them on the screen.<\/p>\n\n\n\n while($row = $result->fetch_assoc()){\n $r_id = $row['id']; \n $r_name = $row['name'];\n $r_title = $row['title'];\n\n echo \"<tr><td>\" . $r_id . \"<\/td><td>\" . $r_name . \"<\/td><td>\" . $r_title . \"<\/td><\/tr>\";\n \n }<\/code><\/pre>\n\n\n\n<!DOCTYPE html>\n<html>\n <head>\n \u200b <title>List\ud30c\uc77c<\/title>\n <!--\uc774 \ubd80\ubd84\uc740 html\ucf54\uba58\ud2b8 \uc601\uc5ed This part is the html comment area,\ub9c8\uc784\ud0c0\uc785\uc124\uc815 Mime type settings\/\/-->\n <meta charset=\"utf-8\">\n <!-- \ubaa8\ubc14\uc77c\ud3f0 \uc2a4\ud06c\ub9b0 \uc635\uc158 Mobile phone screen options\/\/-->\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\n <!--\ubd80\ud2b8\uc2a4\ud2b8\ub7a95 CDN\ubc29\uc2dd \ub9c1\ud06c Bootstrap 5 CDN method link\/\/-->\n <link href=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.2.3\/dist\/css\/bootstrap.min.css\" rel=\"stylesheet\">\n <script src=\"https:\/\/cdn.jsdelivr.net\/npm\/bootstrap@5.2.3\/dist\/js\/bootstrap.bundle.min.js\"><\/script>\n\n <\/head>\n <body>\n<!--\ud14c\uc774\ube14 \uc2dc\uc791 table start \/\/-->\n<div class=\"container mt-3\">\n <table class=\"table table-dark table-hover\">\n <tr>\n <td>ID<\/td><td>\uc774\ub984<\/td><td>\uc81c\ubaa9<\/td>\n <\/tr>\n<?php\n \/\/\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc778\uc99d\n \/\/DATABASE AUTENTICATION\n $servername = \"localhost\";\n $username = \" \";\n $password = \" \";\n $dbname = \" \";\n\n \/\/\ub370\uc774\ud130 \ubca0\uc774\uc2a4 \uc811\uc18d \n \/\/DATABASE CONNECTION\n $mysqli = new mysqli($servername,$username,$password,$dbname);\n \n \/\/\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc811\uc18d\uccb4\ud06c\n \/\/DATABASE CONNECTION CHECK\n if($mysqli->connect_error){\n die(\"connect failed\". $mysqli->connect_error);\n \n }\n \/\/ SQL QUERY\n $sql = \"select * from testuser order by id desc limit 10 offset 0\";<\/mark>\n $result = $mysqli->query($sql);\n while($row = $result->fetch_assoc()<\/mark>){\n $r_id = $row['id']; \n $r_name = $row['name'];\n $r_title = $row['title'];\n\n echo \"<tr><td>\" . $r_id . \"<\/td><td>\" . $r_name . \"<\/td><td>\" . $r_title . \"<\/td><\/tr>\";\n \n }\n\n $mysqli->close();\n?>\n <tr>\n <td colspan=3><a href=\"form6.php\">write<\/a><\/td>\n <\/tr>\n <\/table>\n<\/div>\n<!--\ud14c\uc774\ube14 \ub05dtable end\/\/-->\n <\/body>\n<\/html><\/code><\/pre>\n\n\n\n
You can test it through the link below
https:\/\/freelifemakers.org\/lec\/list01.php<\/a><\/p>\n\n\n\n