PHP Form Output to Different CSV Files

[t3chb0y]

How would one be able to configure the form processor.php to output a different CSV file (or multiple) depending on the "checkmarks" selected from a submitted form.

For example...

There are 2 CSV files...one for the people in event 1 and one for the people in event 2

Bob wants to register for Event 1 and 2..He fills the form and his information is supposed to go into both

Sally registers for Event 1 so her information goes only into the Event 1 CSV file.

How would I be able to modify a PHP form file to output to multiple CSV files...
Moreover...how do we change from an SQL database to a CSV one also?

Thanks

[twm]

抱歉，我没看懂英文

Sorry, I did not understand English

[t3chb0y]

twm;10889472 wrote:

抱歉,我没看懂英文

Sorry, I did not understand English

then why did you reply...😕

[HalfaBee]

You should read the manual entry for fputcsv() and fgetcsv() , it might get you started.

[djjjozsi]

How about this:

<?
$files["eve"]="eve.csv"; /you specify the filenames
$files["walle"]="walle.csv";
$files["shrek"]="shrek.csv";
/
these are must equal with <input type="checkbox" name="checkbox[]" value="eve"> <-----
/

if(trim($_POST["checkbox"]))
{

foreach($_POST["checkbox"] AS $values)
{
 $f = $files[$values];
 //print "$values - > $f file to write";
 $fa = fopen( $f, "a" ) or die("$values file could not be opended");
 foreach($_POST["textfield"] AS $val)
 {
 if($val)
 fwrite ( $fa, addslashes($val).";");
 else
 fwrite ( $fa, "0;");
 }
 //add here a date-time function to write the date into the csv file!!!
 fwrite ( $fa, "\n");

 fclose( $fa );
}

}
?>

<form name="form1" method="post" action="?">
<p>You want to register to:<br>
<input type="checkbox" name="checkbox[]" value="eve">
Eve<br>
<input type="checkbox" name="checkbox[]" value="walle">
WAll-E<br>
<input type="checkbox" name="checkbox[]" value="shrek">
Shrek
</p>
<p>
<input type="text" name="textfield[]">
<br>
<input type="text" name="textfield[]">
<br>
<input type="text" name="textfield[]">
<br>
<input type="text" name="textfield[]">
<br>
<input type="text" name="textfield[]">
<input type="submit" name="Submit" value="Submit">
<br>
</p>
</form>

hi!
jjozsi
www.phpcode.hu

[NogDog]

t3chb0y;10889466 wrote:

...
Moreover...how do we change from an SQL database to a CSV one also?

I would strongly recommend not doing that. A DBMS is faster, more powerful, and more flexible than a CSV-file-based data management system. If at some point you need to supply a user with CSV data, it is a fairly trivial matter to generate it "on the fly" from the data in the database.

[t3chb0y]

Thanks djjjozsi...for the code

I'll see to it on using SQL as NogDog said...

my SQL script currently has something along the lines of this

$maxRows_Event1 = 10;
$pageNum_Event1 = 0;
if (isset($_GET['pageNum_Event1'])) {
  $pageNum_Event1 = $_GET['pageNum_Event1'];
}
$startRow_Event1 = $pageNum_Event1 * $maxRows_Event1;

mysql_select_db($database_localhost, $localhost);
$query_Event1 = "SELECT * FROM registrants WHERE RegEvent LIKE '%1%' ORDER BY TCHSID ASC";
$query_limit_Event1 = sprintf("%s LIMIT %d, %d", $query_Event1, $startRow_Event1, $maxRows_Event1);
$Event1 = mysql_query($query_limit_Event1, $localhost) or die(mysql_error());
$row_Event1 = mysql_fetch_assoc($Event1);

if (isset($_GET['totalRows_Event1'])) {
  $totalRows_Event1 = $_GET['totalRows_Event1'];
} else {
  $all_Event1 = mysql_query($query_Event1);
  $totalRows_Event1 = mysql_num_rows($all_Event1);
}
$totalPages_Event1 = ceil($totalRows_Event1/$maxRows_Event1)-1;


<table border="1">
          <tr>
            <td>RegID</td>
            <td>TCHSID</td>
            <td>RegFirstName</td>
            <td>RegLastName</td>
            <td>RegEmail</td>
            <td>RegEvent</td>
            <td>RegAttendance</td>
<td>Action</td>
          </tr>

        <tr>
          <td><?php echo $row_Event1['RegID']; ?></td>
          <td><?php echo $row_Event1['TCHSID']; ?></td>
          <td><?php echo $row_Event1['RegFirstName']; ?></td>
          <td><?php echo $row_Event1['RegLastName']; ?></td>
          <td><?php echo $row_Event1['RegEmail']; ?></td>
          <td><?php echo $row_Event1['RegEvent']; ?></td>
          <td><?php echo $row_Event1['RegAttendance']; ?></td>
 <td><a href="reg_update.php?<?php echo $row_Event1Registrants['RegID']; ?>=">Update</a> - <a href="reg_delete.php?<?php echo $row_Event1Registrants['RegID']; ?>=">Delete</a></td>
            </tr>
            <?php } while ($row_Event1 = mysql_fetch_assoc($Event1)); ?>
    </table>

Instead of having to add more of that code every time a new event is added...is there a way to just implement a variable to just have it search the full database for all the events (lets say all events are in this format : Event### ) to reduce the hassle in the future and to lessen the amount of code needed?

[djjjozsi]

in reg_update.php how you get the data?

if i print with this,
<a href="reg_update.php?<?php echo $row_Event1Registrants['RegID']; ?>=">Update</a>

<a href="reg_update?3=">Update</a> you should use this form:

<a href="reg_update.php?Event1=<?php echo $row_Event1Registrants['RegID']; ?>">Update</a>

and after clicking in this link you reach the value with $_GET['Event1'] and not with post.

And do the same at event2...

it helped to you?

bye.

jjozsi

[t3chb0y]

djjjozsi;10889495 wrote:

in reg_update.php how you get the data?

if i print with this,
<a href="reg_update.php?<?php echo $row_Event1Registrants['RegID']; ?>=">Update</a>

<a href="reg_update?3=">Update</a> you should use this form:

<a href="reg_update.php?Event1=<?php echo $row_Event1Registrants['RegID']; ?>">Update</a>

and after clicking in this link you reach the value with $_GET['Event1'] and not with post.

And do the same at event2...

it helped to you?

bye.

jjozsi

I figured out something for that as you were replying....
(and didn't feel like double-posting so I edited my previous post)

It helps...I'm still learning ..😃 Thanks

Now I just need to find a way to have the script:
Search the database for all events and post each of them up in individual tables without needing to add code each time a new event is added.

[djjjozsi]

t3chb0y;10889496 wrote:

I figured out something for that as you were replying....
(and didn't feel like double-posting so I edited my previous post)

It helps...I'm still learning ..😃 Thanks

Now I just need to find a way to have the script:
Search the database for all events and post each of them up in individual tables without needing to add code each time a new event is added.

Session is your friend, after posted the cirrect username and password,

start the file with
<?php
session_start();
if ($POST["username"] AND $POST["password"])
{
//Lets add a $_SESSION["acces"]="ok";
//check these values from database
if it is in, set the access session variable to a string...

$_SESSION["acces"]="ok";
}
?>

And when you fill the forms, you could check if the username and password is in your session variable.

<?php
if ($_SESSION["acces"]!="ok")
{
// lets print a form to the usermane and password field
}
else
{
// lets print a form to the values of your database
}
?>
and in the processing php, let check if the session access has that value you want. if no, do not insert new rows into the table.

[t3chb0y]

if I know what you were saying..I actually wouldn't mind having the session check or not...Not having it still adds some bit of security in mind.

just that I need to find out what code to use to the script categorize all the events in tables individually without the need to add more code each time

[djjjozsi]

I misunderstood the second party of the question. sorry 🙂

I thought that you would have liked to ask for a code before an entry (username and password).

Store the structure of your board in a database, the next fields storing:
-Form code (*****ple users)
-Appearing name
-Order
-its name when post,
-Available in the search forms
-If available in search form, it takes LIKE OR BETWEEN OR just = in the SQL query
-The last field is, AND or OR will take after this Query

With this structure you could create a form for a search engine.
if you enlarge your original table, only needs to include the names (of those fields) in this searching board.

Its heavy to find so dynamic solution on a similar problem. But this form has its weak point, in complex boards it can't search.

t3chb0y;10889563 wrote:

if I know what you were saying..I actually wouldn't mind having the session check or not...Not having it still adds some bit of security in mind.

just that I need to find out what code to use to the script categorize all the events in tables individually without the need to add more code each time

[t3chb0y]

I've chosen to just take the CSV route...

<?php
$files[$values]='info/' . $values . '.csv';

/*
these are must equal with <input type="checkbox" name="checkbox[]" value="eve"> <-----
*/

if(trim($_POST["checkbox"]))
{

foreach($_POST["checkbox"] AS $values)
{
$f = $values;
//print "$values - > $f file to write";
$fa = fopen( $f, "a" ) or die("$values file could not be opened");
foreach($_POST["text"] AS $val)
{
if($val)
fwrite ( $fa, addslashes($val).";");
else
fwrite ( $fa, "0;");
}
//add here a date-time function to write the date into the csv file!!!
fwrite ( $fa, "\n");

fclose( $fa );
}

}
?>

I'm getting errors and the files are blank..

[djjjozsi]

but you must store the filenames in an array..

and with a foreach you go along the $files[]

never use that $values line... as you edit...

<?
$files["eve"]="info/eve.csv"; /you specify the filenames
$files["walle"]="info/walle.csv";
$files["shrek"]="info/shrek.csv";

/*
these are must equal with <input type="checkbox" name="checkbox[]" value="eve"> <-----
*/ 

if(trim($_POST["checkbox"]))
{

foreach($_POST["checkbox"] AS $values)
{
$f =$files[ $values];
//print "$values - > $f file to write";
$fa = fopen( $f, "a" ) or die("$values file could not be opened");
foreach($_POST["text"] AS $val)
{
if($val)
fwrite ( $fa, addslashes($val).";");
else
fwrite ( $fa, "0;");
}
//add here a date-time function to write the date into the csv file!!!
fwrite ( $fa, "\n");

fclose( $fa );
}

} 
?>

[t3chb0y]

djjjozsi;10890164 wrote:

but you must store the filenames in an array..

and with a foreach you go along the $files[]

never use that $values line... as you edit...

<?
$files["eve"]="info/eve.csv"; /you specify the filenames
$files["walle"]="info/walle.csv";
$files["shrek"]="info/shrek.csv";

/*
these are must equal with <input type="checkbox" name="checkbox[]" value="eve"> <-----
*/ 

if(trim($_POST["checkbox"]))
{

foreach($_POST["checkbox"] AS $values)
{
$f =$files[ $values];
//print "$values - > $f file to write";
$fa = fopen( $f, "a" ) or die("$values file could not be opened");
foreach($_POST["text"] AS $val)
{
if($val)
fwrite ( $fa, addslashes($val).";");
else
fwrite ( $fa, "0;");
}
//add here a date-time function to write the date into the csv file!!!
fwrite ( $fa, "\n");

fclose( $fa );
}

} 
?>

What do I change foreach with if I want to just call on a variable instead of an array?

[Weedpacket]

I guess I'm late with this but....

t3chb0y wrote:

Now I just need to find a way to have the script:
Search the database for all events and post each of them up in individual tables without needing to add code each time a new event is added.

Have one table that lists all the events with one row per event; another table with what is currently being stored in all these CSV files along with an extra field to say which event each row belongs to.

[t3chb0y]

Provided that I feel like just using CSV files...what do I use instead of foreach to refer to files that will be named after $values mentioned in the form submitted to prevent the need for future change in terms of the PHP process file itself.

[Weedpacket]

Just take the foreach out and use the value.