get_info.php 717 B

123456789101112131415161718192021222324252627
  1. <?php
  2. mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
  3. $mysqli = mysqli_connect("18.18.18.18", "root", "实际密码", "vps2022","53306");
  4. $result = mysqli_query($mysqli, "SELECT name FROM text");
  5. // $result = mysqli_query($mysqli, "SELECT * FROM text WHERE name = 'addfile.py'");
  6. $rows = mysqli_fetch_all($result, MYSQLI_ASSOC); // MYSQLI_ASSOC, MYSQLI_NUM, or MYSQLI_BOTH
  7. foreach ($rows as $row) {
  8. printf("%s\n", $row["name"]);
  9. // printf("%s (%s)\n", $row["name"], $row["text"]);
  10. }
  11. var_dump($rows);
  12. /** MYSQLI_ASSOC
  13. array(11) {
  14. [0]=>
  15. array(1) {
  16. ["name"]=>
  17. string(10) "addfile.py"
  18. ** MYSQLI_NUM
  19. array(11) {
  20. [0]=>
  21. array(1) {
  22. [0]=>
  23. string(10) "addfile.py"
  24. */