php fgetscv only first column

asapscotland

Hi phpbuilders,

I am new at this and wonder if anyone can help. I run a charity to get teens more to do. I have a php membership form that contains personal details (phone numbers, medical, etc). I would like to use this membership form to automatically create an attendance form in php script. In the attendance form, I only want to see the child's name with a radio box for when they attend.

Any anyone help me sort out this type of code. The membership form is detailed below.

<?php

/ subject email variable /

$emailSubject = 'Membership Form';
$webMaster = 'stephen@asapscotland.org';

/Gathering Data Variables /

$Name 				= $_POST['Name'];
$Email  			= $_POST['Email'];
$DoB				= $_POST['DoB'];

$Phone  			= $_POST['Phone'];

$Gender				= $_POST['Gender'];
$Year				= $_POST['Year'];

$body = <<<EOD

Name: 				$Name 				<br>
Phone:  			$Phone  			<br>
Email: 			    $Email 			    <br>
Gender: 			$Gender 			<br>
Year: 				$Year 				<br>

EOD;

$cvsData = $fn . $Name ."," . $Gender ."," . $Year ."," . $Phone ."," . $Email ."\n";
$ofile = fopen("Membership.txt","a+");
fwrite($ofile, $cvsData);
fclose ($ofile);

$theResults = <<<EOD

<html>
<head>
<title>ASAP says thank you</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">

</style>
</head>

$file = new SplFileObject("Membership.txt");
$file->setFlags(SplFileObject::READ_CSV);
foreach ($file as $row) {
list($name, $id, $date) = $row;

<div>
<div align="left">Thank you becoming a member and we hope you enjoy the experience!</div>
</div>
</body>
</html>

EOD;
echo "$theResults";

Thank you for any suggestions.

Stephen

bradgrafelman

Is there any particular reason why you aren't using a SQL database to store the information?

asapscotland

Not sure what SQL is nor how to get it to work. Can you point me to the right direction on how to learn more about it? Thx s

laserlight

asapscotland wrote:
Not sure what SQL is nor how to get it to work. Can you point me to the right direction on how to learn more about it?

A search of the Web for "PHP SQL" could give you many places to start. That said, seeing that you are a complete beginner in this area, I suggest that you read Clare Churcher's Beginning Database Design in addition to whatever PHP related tutorials you find online.

Weedpacket

For reading from a CSV file, you will need to read the entire file even if you do only want one column (and ignore the rest), because that's the only way for the routine reading the file to work out where each field begins and ends. To get around that would involve either using an existing (SQL-based) database solution, or recapitulating half a century's worth of research into efficient storage and retrieval of data, and implementing one yourself 🙂.

asapscotland

Thanks for this information.

I now understand how to make mysql data bases.

I wonder if anyone could point me in the right direction on how to get the php code that would:-
1. dynamically generate a simple attendance form in html listing all of the names exist in the attendance mysql table
2. put a tick box next to all the names and
3. when the attendance form is submitted generate a column back in the attendance table with the date for all those who have been ticked (have attended).

Any support would be most welcomed.