You mention that a user has to be logged in to change their password, why not use their session key to look up the user_id in your .db file?

If I were to change the "hidden" value I could change someone elses password. Using the extra layer of abstraction (sess_id) makes this take substantially more difficult.

I have never used the DBI for text files, however there is a csv driver that looks like it would do exactly what youre after. It would mean a bit of work, but you'd be able to update only the fields you want to.

There is also the advantage of making your app more portable, and flexible. For example if one day you're able to use an RBDMS there shouldnt be too much you'll need to change in your code.

In reply to Re: Help with database management by Ryszard
in thread Help with database management by drewboy

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.