Adding Database information to access personal data.

  • Lesley McLean

    (@lesley-mclean)


    12 years, 9 months ago

    I am new to this so please excuse me if I ask blatantly simple questions! This relates to sport, specifically to swimming times. I would like to add a database to a site so that individuals can access their own page (security required) to see and possibly update their PB’s (personal best) in a particular event, or arrange storage of timings from gala’s the individual has participated in.

    There are a number of events at each gala, and a number of gala’s per year, each individual can enter as many gala’s as they choose to.

    Currently this information is stored in an excel spreadsheet, with a tab for each individual.

    Can anyone help, or point me in the right direction? It would be very much appreciated as getting this off the ground is proving very lengthy.

Viewing 2 replies - 1 through 2 (of 2 total)
  • s_ha_dum

    (@apljdi)

    12 years, 9 months ago

    Ok.

    1) Users have their own protected ‘page’ on the WordPress backend– aka, the user profile page. You can add content to that, and don’t have to worry as much about security (but you still have to be careful). You can list the results on the backend or the front end or both. The security problem is going to be with the inputting not with the printing out, so again, this saves you so9me security worries.

    2) If you want to put everything on the front end you h ave to worry a lot more about security since you don’t have the benefit of WordPress’s built in admin section security.

    3) Getting your information out of Excel is probably less difficult than you think, as long as the information is internally consistent. The easiest way I can think of is to save your Excel file as a csv and import that into a new MySQL table. You can use that table as is, but its going to be more work inserting, updating, searching, etc, or you can then use a PHP script in your theme’s functions.php or in a temporary plugin to move things around using native WordPress functions where possible– for example to add things to wp_usermeta.

    Thread Starter Lesley McLean

    (@lesley-mclean)

    12 years, 8 months ago

    Ok. I think I understand the concept. I using WordPress security would be a definite advantage. But a couple of queries:

    First how do I open a ‘protected’ page, and would I need to do this for each individual (that would be about 150 people)?
    Secondly, how do I create a new MySQL table, or access the existing one?

    Can anyone help please?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Adding Database information to access personal data.’ is closed to new replies.