Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><code>lineArray</code> should be declared as an array of <code>char *</code> instead of a pointer to char:</p> <pre><code>char *lineArray[MAX_LINES]; </code></pre> <p>Also, consider what happens when you enter the <code>while</code> loop: your code has undefined behavior, because you are accessing <code>lineArray[x]</code>, which was never initialized, and will contain garbage values.</p> <p>You should use <code>fgets</code> instead to read a whole line into <code>line</code>, and then copy it into <code>lineArray</code>. Something like this:</p> <pre><code>while (fgets(line, sizeof(line), file) != NULL) { lineCount++; lineArray[x] = malloc(strlen(line)); strcpy(lineArray[x], line); printf("%s\n", lineArray[x]); x++; } </code></pre> <p>From your post, it appears that you don't want to be limited to <code>MAX_LINES</code>, and you want to read the whole file first to determine the array size. To do so, you can use a similar loop to count the number of lines first, like this:</p> <pre><code>while (fgets(line, sizeof(line), file) != NULL) { lineCount++; } </code></pre> <p>After this loop, <code>lineCount</code> will hold the size for <code>lineArray</code>. </p> <p>In this case, you may want to declare <code>lineArray</code> as <code>char **</code> and allocate it dynamically:</p> <pre><code>lineArray = malloc(sizeof(char *)*lineCount); </code></pre> <p>Then, get back to the beginning of the file by calling <code>rewind(file);</code> and execute the loop that copies each line into <code>lineArray</code>. In summary, your code would look something like:</p> <pre><code>while (fgets(line, sizeof(line), file) != NULL) { lineCount++; } lineArray = malloc(sizeof(char *)*lineCount); rewind(file); while (fgets(line, sizeof(line), file) != NULL) { lineArray[x] = malloc(strlen(line)); strcpy(lineArray[x], line); printf("%s\n", lineArray[x]); x++; } </code></pre> <p>Note 1: This is inefficient. File I/O is extremely slow, and you're reading it twice. Consider if this is really how you want to do it. Maybe a good approach would be to force input files to say how many lines they have.</p> <p>Note 2: You should check <code>malloc()</code>'s return value. I didn't do it in this example, but in real world, please do it.</p> <p>Note 3 : In the end, remember to <code>free()</code> every position <code>lineArray[i]</code>, and after that, free <code>lineArray</code>.</p>
    singulars
    1. This table or related slice is empty.
    1. POFile input into array by line as string
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USFilipe Gonçalves
    1. USFilipe Gonçalves
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POFile input into array by line as string
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. CODo you know what is meant by "Get file pointer to the beginning"? Your help is much appreciated. What you have given me is working, but my next step after the 4 bullets I have above is to "Reserve memory for a dynamic array of strings". So, I believe I need to use malloc later.
      singulars
      1. PO
      1. USWorldDominator
    2. COGet file pointer to the beginning is basically calling `rewind(file)`. I included that in my answer. You need to do it because after you read the file for the first time, your pointer will be at the end of the file, and you need to get it back up. And reserving memory for a dynamic array of strings is as simple as `lineArray = malloc(sizeof(char *)*lineCount);`. In the final piece of code, lines are counted, a dynamic array of strings is created, the pointer is reset, and the file is read again to copy each line into the newly allocated array.
      singulars
      1. PO
      1. USFilipe Gonçalves
    3. COThank you sir. I have been staring at this all weekend and I finally decided to make an account here and I'm glad I did!
      singulars
      1. PO
      1. USWorldDominator
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload