User Tools

Site Tools


c:mysql:mysql.h:mysql_eof

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

c:mysql:mysql.h:mysql_eof [2013/02/25 23:32]
Daniel Gohlke
c:mysql:mysql.h:mysql_eof [2024/02/16 01:12] (current)
Line 5: Line 5:
  
 ==== description of mysql_eof ==== ==== description of mysql_eof ====
-mysql_eof is in work by code-reference.com \\  +is used to test whether a quantitative result has been read completelyreturns 0 until the end of the results has not yet been reached otherwise value is 0 
-if you are faster... don't hasitate and add it+ 
 +This function is obsolete,use mysql_errno() or mysql_error()
  
 <code c> <code c>
-no example at the moment+#include <stdio.h> /* including standard library */  
 +#include <mysql/mysql.h> 
 +  
 +MYSQL *my; 
 +MYSQL_ROW  row; 
 +MYSQL_RES  *result;  
 + 
 +int main( void ){ 
 +char host[20]; 
 +char user[20]; 
 +char pass[20]; 
 +unsigned long num_rows = 0; 
 + 
 +my = mysql_init(NULL); 
 +  
 +  
 +sprintf(host,"localhost"); 
 +sprintf(user,"username"); 
 +sprintf(pass,"password"); 
 +  
 +if (my == NULL ) { 
 +printf("Cant initalisize MySQL\n"); 
 +return 1; 
 +
 +  
 +if( mysql_real_connect (my,host,user,pass,NULL,0,NULL,0)  == NULL) { 
 +  printf("Error cant login\n"); 
 +  } else { 
 +  printf("Login correct\n"); 
 +  } 
 + 
 +mysql_select_db(my, "test"); 
 +mysql_query(my, "SELECT * FROM collection WHERE 1;"); 
 + 
 +result = mysql_store_result(my); 
 + 
 +if (mysql_eof(result)) { 
 +       printf("db read complete\n"); 
 +   } else { 
 +            printf("error while read db\n"); 
 +          } 
 + 
 + 
 +num_rows = (unsigned long) mysql_num_rows(result); 
 +printf("num_rows %li\n", num_rows); 
 + 
 + 
 +mysql_close(my); 
 +return 0; 
 +}
 </code> </code>
  
 ===== output of mysql_eof c example ===== ===== output of mysql_eof c example =====
-    no example at the moment +    Login correct 
 +    db read complete 
 +    num_rows 2

on the occasion of the current invasion of Russia in Ukraine

Russian Stop this War
c/mysql/mysql.h/mysql_eof.txt · Last modified: 2024/02/16 01:12 (external edit)

Impressum Datenschutz