taking user input from keyboard(not source code)

joy39 · #1 (**permalink**) 01-10-12, 12:04

if we have to insert records into a mysql database using c api then the general code is this

Code:

if (mysql_query(conn, "insert into empinfo values ('saikat banerjee')")) 
  {
      printf("4Error %u: %s\n", mysql_errno(conn), mysql_error(conn));
      exit(1);
  }

but, here we have to enter the record from the code itself .

but, i want to enter records from direct user inputs.
like, save the user input in a say, string variable and then use that string variable to store the record in the database. ie. i ant to do something like this

Code:

char empname[100]

then i ask for user input

Code:

printf("please enter a employee name");
  fgets(empname,100,stdin);
  printf("%s",empname);

and then,

Code:

if (mysql_query(conn, "insert into empinfo values (empname)")) 
  {
      printf("4Error %u: %s\n", mysql_errno(conn), mysql_error(conn));
      exit(1);
  }

but, this is storing NULL in the table.

is there any way to do this?
please help!

it-iss.com · #2 (**permalink**) 01-10-12, 12:16

The insert is a string that has to be generated try the following:

char query[1024];
sprintf(query, "INSERT INTO empinfo VALUES ('%s')", empname);

then inside mysql_query pass the conn and the query string above and this should work. There are other ways where you bind values to parameters but this is a good first step.

if (mysql_query(conn, query))
{
printf("4Error %u: %s\n", mysql_errno(conn), mysql_error(conn));
exit(1);
}

joy39 · #3 (**permalink**) 01-10-12, 13:21

thanks a lot! it works fine!

Internet Services

Web Development

Digital Marketing

Consumer Tech