Code666 (代码贴、代码片段)

[PHP] mysql_num_fields 和 mysql_num_rows– 根据查询 →→→→→进入此内容的聊天室

来自 , 2020-01-16, 写在 PHP, 查看 110 次.
URL http://www.code666.cn/view/dc6e224a
  1. <?php
  2. $UserName = 'abc';
  3. $Password = '1234';
  4. $DbHandle = mysql_connect ('localhost', $UserName, $Password);
  5. if (!$DbHandle) {
  6.   die 'No database connection could be established.';
  7. }
  8.  
  9. $DBName = 'w3db;
  10. if (!mysql_select_db ($DBName, $DbHandle)) {
  11.  die 'Database could not be selected.';
  12. }
  13. $Query = "SELECT ISBN, Title, Author FROM articles";
  14. $articles = mysql_query ($Query, $DbHandle));
  15.  
  16. $RowCount = mysql_num_rows ($articles);
  17. $FieldCount = mysql_num_fields ($articles);
  18. $I = 0;
  19. while ($I < $RowCount) {
  20.  $Row = mysql_fetch_assoc ($articles);
  21.  echo "Row $I<br />\n";
  22.  $J = 0;
  23.  while ($J < $FieldCount) {
  24.    echo "$Row[$J]<br />\n";
  25.    ++$J;
  26.  }
  27.  ++$I;
  28. }
  29.  
  30. mysql_close ($DbHandle);
  31. ?>
  32.  
  33.  

回复 " mysql_num_fields 和 mysql_num_rows– 根据查询"

这儿你可以回复上面这条便签

captcha

贴代码片段 - Code666