#include
#include
#include
#include
#include "mysql.h"

int main(int argc,char *argv[])
{
//informacja o rodzaju dokumentu
printf("Content-type: text/html");

char host[40] ="localhost";
char user[40] ="user";
char pass[40] ="pass";
char db[40] ="univ";

MYSQL_ROW row; MYSQL_RES *res;MYSQL *sock, mysql;
int rn=0;

//podlacz sie do bazy
if( !(sock = mysql_connect( &mysql, host, user, pass )) ) {
fprintf( stderr, "Couldn't connect to server! %s\n\n", mysql_error( &mysql ) );
exit(1);
}
//wybierz baze
if( mysql_select_db( sock, db) ) {
fprintf( stderr, "Couldn't select db ! %s\n", mysql_error( sock ) );
exit(1);
}
//pobierz wynik zapytania
sprintf( data, "select * from students order by id limit 0,1");
if( mysql_query( sock, data ) ) {
fprintf( stderr, "Query failed (%s)\n", mysql_error( sock ) );
exit(1);
}
if( !(res = mysql_store_result( sock )) ) {
fprintf( stderr, "mysql_store_result( sock ) failed (%s)\n", mysql_error( sock ) );
exit(1);
}
rn = mysql_num_rows(res); //ile zapytanie zwrocilo wierzy
if (rn) {
row = mysql_fetch_row(res);
printf("

%s

%s

%s

",
row[0],row[1],row[2]);
}

mysql_close(sock);
exit(0);
}