console.c

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <mysql/mysql.h>

void add_member(MYSQL *conn){
    char name[100], address[200], phone[20], email[100];
    char query[1000];

    printf("Enter member name: ");
    fgets(name, sizeof(name), stdin);
    name[strcspn(name, "\n")] = 0;

    printf("Enter address: ");
    fgets(address, sizeof(address), stdin);
    address[strcspn(address, "\n")] = 0;

    printf("Enter phone number: ");
    fgets(phone, sizeof(phone), stdin);
    phone[strcspn(phone, "\n")] = 0;

    printf("Enter email: ");
    fgets(email, sizeof(email), stdin);
    email[strcspn(email, "\n")] = 0;

    sprintf(query, "INSERT INTO Members (Name, Address, Phone, Email) VALUES ('%s', '%s', '%s', '%s')", name, address, phone, email);
    if(mysql_query(conn, query)){
        fprintf(stderr, "%s\n", mysql_error(conn));
    } else {
        printf("Member added successfully!\n");
    }
}

void add_book(MYSQL *conn){
    char title[100], author[100], publisher[100], year[10], isbn[20], genre[50];
    char query[1000];

    printf("Enter book title: ");
    fgets(title, sizeof(title), stdin);
    title[strcspn(title, "\n")] = 0;

    printf("Enter author_id: ");
    fgets(author, sizeof(author), stdin);
    author[strcspn(author, "\n")] = 0;

    printf("Enter publisher: ");
    fgets(publisher, sizeof(publisher), stdin);
    publisher[strcspn(publisher, "\n")] = 0;

    printf("Enter year of publication (year only): ");
    fgets(year, sizeof(year), stdin);
    year[strcspn(year, "\n")] = 0;

    printf("Enter ISBN: ");
    fgets(isbn, sizeof(isbn), stdin);
    isbn[strcspn(isbn, "\n")] = 0;

    printf("Enter genre: ");
    fgets(genre, sizeof(genre), stdin);
    genre[strcspn(genre, "\n")] = 0;

    sprintf(query, "INSERT INTO Books (Title, author_id, publisher_id, year_published, ISBN, Genre) VALUES ('%s', '%s', '%s', '%s', '%s', '%s')", title, author, publisher, year, isbn, genre);
    if(mysql_query(conn, query)){
        fprintf(stderr, "%s\n", mysql_error(conn));
    } else {
        printf("Book added successfully!\n");
    }
}

void add_staff(MYSQL *conn){
    char name[100], position[100], phone[20], email[100];
    char query[1000];

    printf("Enter staff name: ");
    fgets(name, sizeof(name), stdin);
    name[strcspn(name, "\n")] = 0;

    printf("Enter position: ");
    fgets(position, sizeof(position), stdin);
    position[strcspn(position, "\n")] = 0;

    printf("Enter phone number: ");
    fgets(phone, sizeof(phone), stdin);
    phone[strcspn(phone, "\n")] = 0;

    printf("Enter email: ");
    fgets(email, sizeof(email), stdin);
    email[strcspn(email, "\n")] = 0;

    sprintf(query, "INSERT INTO Staff (Name, role, Phone, Email) VALUES ('%s', '%s', '%s', '%s')", name, position, phone, email);
    if(mysql_query(conn, query)){
        fprintf(stderr, "%s\n", mysql_error(conn));
    } else {
        printf("Staff added successfully!\n");
    }
}

void add_author(MYSQL *conn){
    char name[100], bio[100],query[1000];

    printf("Enter author name ");
    fgets(name, sizeof(name), stdin);
    name[strcspn(name, "\n")] = 0;

    printf("Enter bio");
    fgets(bio, sizeof(bio), stdin);
    bio[strcspn(bio, "\n")] = 0;

    sprintf(query, "INSERT INTO Authors (name,bio) VALUES ( '%s', '%s')",name, bio);
    if(mysql_query(conn, query)){
        fprintf(stderr, "%s\n", mysql_error(conn));
    } else {
        printf("Author added successfully!\n");
    }
}

void add_publisher(MYSQL *conn){
    char name[100], address[100], contact[100],query[1000];

    printf("Enter publisher name: ");
    fgets(name, sizeof(name), stdin);
    name[strcspn(name, "\n")] = 0;

    printf("Enter address: ");
    fgets(address, sizeof(address), stdin);
    address[strcspn(address, "\n")] = 0;

    printf("Enter contact info: ");
    fgets(contact, sizeof(contact), stdin);
    contact[strcspn(contact, "\n")] = 0;
    
    sprintf(query, "INSERT INTO Publishers (name,address, contact_info) VALUES ('%s', '%s', '%s')", name,address,contact);
    if(mysql_query(conn, query)){
        fprintf(stderr, "%s\n", mysql_error(conn));
    } else {
        printf("Publisher added successfully!\n");
    }
}

void add_fine(MYSQL *conn){
    char member_id[10], amount[10], reason[200];
    char query[1000];

    printf("Enter Member ID: ");
    fgets(member_id, sizeof(member_id), stdin);
    member_id[strcspn(member_id, "\n")] = 0;

    printf("Enter amount: ");
    fgets(amount, sizeof(amount), stdin);
    amount[strcspn(amount, "\n")] = 0;

    printf("Enter date(YYYY-MM-DD): ");
    fgets(reason, sizeof(reason), stdin);
    reason[strcspn(reason, "\n")] = 0;

    sprintf(query, "INSERT INTO Fines (member_id, Amount,date_paid) VALUES ('%s', '%s', '%s')", member_id, amount, reason);
    if(mysql_query(conn, query)){
        fprintf(stderr, "%s\n", mysql_error(conn));
    } else {
        printf("Fine added successfully!\n");
    }
}

void add_borrowing(MYSQL *conn){
    char book_id[100], member_id[100], borrow_date[100], due_date[100], return_date[100], staff_id[100],query[1000];
    MYSQL_RES *res;
    MYSQL_ROW row;
    printf("Enter book_id:");
    fgets(book_id,sizeof(book_id),stdin);
    book_id[strcspn(book_id,"\n")]=0;

    printf("Enter member Id: ");
    fgets(member_id,sizeof(member_id),stdin);
    member_id[strcspn(member_id,"\n")]=0;

    printf("Enter Date (YYYY-MM-DD): ");
    fgets(borrow_date,sizeof(borrow_date),stdin);
    borrow_date[strcspn(borrow_date,"\n")]=0;
    
    printf("Enter due_date (YYYY-MM-DD):");
    fgets(due_date,sizeof(due_date),stdin);
    due_date[strcspn(due_date,"\n")]=0;

    printf("Enter return date (YYYY-MM-DD): ");
    fgets(return_date,sizeof(return_date),stdin);
    return_date[strcspn(return_date,"\n")]=0;

    printf("Enter your staff Id: ");
    fgets(staff_id,sizeof(staff_id),stdin);
    staff_id[strcspn(staff_id,"\n")]=0;
    
    sprintf(query, "INSERT INTO Borrowings (book_id, member_id,borrow_date, due_date, return_date, staff_id) VALUES ('%s', '%s', '%s','%s', '%s', '%s')", book_id, member_id,borrow_date, due_date, return_date, staff_id);
    if(mysql_query(conn, query)){
        fprintf(stderr, "%s\n", mysql_error(conn));
    } else {
        printf("Borrowed book recorded successfully!\n");
    }
    
}

void list_books(MYSQL *conn){
    MYSQL_RES *res;
    MYSQL_ROW row;

    if(mysql_query(conn, "SELECT * FROM Books")){
        fprintf(stderr, "%s\n", mysql_error(conn));
        return;
    }

    res = mysql_store_result(conn);
    printf("Here's what we've got\n");
    while((row = mysql_fetch_row(res)) != NULL)
        printf("ID %s, Title: %s, Genre: %s\n", row[0], row[1], row[5]);

    mysql_free_result(res);
}

void list_members(MYSQL *conn){
    MYSQL_RES *res;
    MYSQL_ROW row;

    if(mysql_query(conn, "SELECT * FROM Members")){
        fprintf(stderr, "%s\n", mysql_error(conn));
        return;
    }

    res = mysql_store_result(conn);
    printf("Member List\n");
    while((row = mysql_fetch_row(res)) != NULL){
        printf("ID %s, Name: %s, Phone: %s, Email: %s\n", row[0], row[1], row[3], row[4]);
    }

    mysql_free_result(res);
}

void list_staff(MYSQL *conn){
    MYSQL_RES *res;
    MYSQL_ROW row;

    if(mysql_query(conn, "SELECT * FROM Staff")){
        fprintf(stderr, "%s\n", mysql_error(conn));
        return;
    }

    res = mysql_store_result(conn);
    printf("Staff List\n");
    while((row = mysql_fetch_row(res)) != NULL){
        printf("ID %s, Name: %s, Position: %s, Email: %s\n", row[0], row[1], row[2], row[4]);
    }

    mysql_free_result(res);
}

void list_fines(MYSQL *conn){
    MYSQL_RES *res;
    MYSQL_ROW row;

    if(mysql_query(conn, "SELECT * FROM Fines")){
        fprintf(stderr, "%s\n", mysql_error(conn));
        return;
    }

    res = mysql_store_result(conn);
    printf("Fines List\n");
    while((row = mysql_fetch_row(res)) != NULL){
        printf("Fine ID %s, Member ID: %s, Amount: %s\n", row[0], row[1], row[2]);
    }

    mysql_free_result(res);
}

void list_authors(MYSQL *conn){
    MYSQL_RES *res;
    MYSQL_ROW row;

    if(mysql_query(conn, "SELECT * FROM Authors")){
        fprintf(stderr, "%s\n", mysql_error(conn));
        return;
    }

    res = mysql_store_result(conn);
    printf("Fines List\n");
    while((row = mysql_fetch_row(res)) != NULL){
        printf("Author ID: %s, name: %s, bio: %s\n", row[0], row[1], row[2]);
    }

    mysql_free_result(res);
}

void list_publisher(MYSQL *conn){
    MYSQL_RES *res;
    MYSQL_ROW row;

    if(mysql_query(conn, "SELECT * FROM Publishers ")){
        fprintf(stderr, "%s\n", mysql_error(conn));
        return;
    }

    res = mysql_store_result(conn);
    printf("Publishers List\n");
    while((row = mysql_fetch_row(res)) != NULL){
        printf("Author ID: %s, name: %s, bio: %s\n", row[0], row[1], row[2]);
    }

    mysql_free_result(res);

}

void list_borrowings(MYSQL *conn){
    MYSQL_RES *res;
    MYSQL_ROW row;

    if(mysql_query(conn, "SELECT * FROM Borrowings")){
        fprintf(stderr,"%s\n",mysql_error(conn));
        return;
    }

    res=mysql_store_result(conn);
    printf("Borrowings list\n");
    while((row=mysql_fetch_row(res))!=NULL){
        printf("Num: %s Book number: %s Member number: %s Date Borrowed: %s Due date: %s, Return_date: %s Staff number: %s\n",row[0],row[1],row[2],row[3],row[4],row[5],row[6]);
    }
    mysql_free_result(res);
}
int main(){
    MYSQL *conn = mysql_init(NULL);
    char choice[10];

    if(conn == NULL){
        fprintf(stderr, "mysql_init() failed\n");
        return EXIT_FAILURE;
    }

    if(mysql_real_connect(conn, "localhost", "root", "", "library", 0, NULL, 0) == NULL){
        fprintf(stderr, "%s\n", mysql_error(conn));
        mysql_close(conn);
        return EXIT_FAILURE;
    }

    while(1){
        printf("\nChoose an option:\n");
        printf("1. Add Member\n");
        printf("2. Add Book\n");
        printf("3. Add Staff\n");
        printf("4. Add Fine\n");
        printf("5. List Books\n");
        printf("6. List Members\n");
        printf("7. List Staff\n");
        printf("8. List fines\n");  
        printf("9. Add author\n"); 
        printf("10.List author\n");
        printf("11.Add publisher\n");
        printf("12.List publishers\n");
        printf("13.Add Borrowings\n");
        printf("14.List Borrowings\n");
        printf("0. Exit\n");
        printf("Enter choice: ");
        fgets(choice, sizeof(choice), stdin);

        switch(atoi(choice)){
            case 1: add_member(conn); break;
            case 2: add_book(conn); break;
            case 3: add_staff(conn); break;
            case 4: add_fine(conn); break;
            case 5: list_books(conn); break;
            case 6: list_members(conn); break;
            case 7: list_staff(conn); break;
            case 8: list_fines(conn); break;
            case 9: add_author(conn); break;
            case 10: list_authors(conn);break;
            case 11: add_publisher(conn);break;
            case 12: list_publisher(conn);break;
            case 13: add_borrowing(conn);break;
            case 14: list_borrowings(conn);break;
            case 0: mysql_close(conn); exit(0);
            default: printf("Invalid choice. Try again.\n"); break;
        }
    }

    mysql_close(conn);
    return EXIT_SUCCESS;
}