Databases
StackOverflow2013
Postsdbo
POWhat is the best way to save and load an activity log in PHP?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhat is the best way to save and load an activity log in PHP?
    primarykey
    data
    text
    <p>Before I begin, THIS IS AN ASSIGNMENT. I am just after a helping hand an some guidance :)</p> <p>I am developing a gym membership website which allows users to register, login, and book an activity.</p> <p>I have everything working, besides the activity booking system, and that is what I need guidance with. I have a single txt file that contains an activity log of each activities name, time, how many can attend in total. I would like to add to the end of each activities line of who is attending exactly. Therefore, allowing users to book the activity, which adds their username to the activity.</p> <p>This is exactly how I currently have my activity.txt file printing (besides the 'Book' buttons on the far right.</p> <pre><code>NumberOne 3 Wednesday 8am (BOOK) NumberTwo 7 Thursday 10am (BOOK) NumberThree 20 Monday 1pm (BOOK) NumberFour 15 Tuesday 5pm (BOOK) </code></pre> <p>Basically, what I need guidance with is the 'Book' buttons. Once a 'Book' button is pressed, it will book the user in to the activity.</p> <p>This is how my activity.txt file currently looks:</p> <pre><code>NumberOne,3,Wednesday 8am NumberTwo,7,Thursday 10am NumberThree,20,Monday 1pm NumberFour,15,Tuesday 5pm </code></pre> <p>And this is the code I currently have that is printing the activities:</p> <pre><code>function bookActivity() { $fileContentsArray = file("activity.txt"); echo "&lt;table&gt;"; foreach($fileContentsArray as $one_persons_data) { echo '&lt;tr&gt;'; $splitted = preg_split('/,/', $one_persons_data); foreach ($splitted as $one) { echo "&lt;td&gt;$one&lt;/td&gt;"; } echo '&lt;/tr&gt;'; } echo "&lt;/table&gt;"; } </code></pre> <p>Below is my users.txt file if needed. All passwords are saved in MD5</p> <pre><code>jiten:3fc0a7acf087f549ac2b266baf94b8b1 jb:3fc0a7acf087f549ac2b266baf94b8b1 test:bed128365216c019988915ed3add75fb joeBlogg:bed128365216c019988915ed3add75fb userX:bed128365216c019988915ed3add75fb userY:bed128365216c019988915ed3add75fb </code></pre> <p>All help is greatly appreciated. Very confused on how to do this.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USYogesh Suthar
    1. USFizzix
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POWhat is the best way to save and load an activity log in PHP?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POWhat is the best way to save and load an activity log in PHP?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POWhat is the best way to save and load an activity log in PHP?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThis would be one of those cases where a database comes in handy.
      singulars
      1. POWhat is the best way to save and load an activity log in PHP?
      1. USnaththedeveloper
    2. COAgreed. Although, we are forced to use a txt file :(
      singulars
      1. POWhat is the best way to save and load an activity log in PHP?
      1. USFizzix
    3. COwhat your trying to do
      singulars
      1. POWhat is the best way to save and load an activity log in PHP?
      1. USBacktrack
 

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