Posting multiple lines of data to a db

fender177

I have a web app that I've written using PHP / JavaScript to post to a MySQL database. The purpose of the web app is to allow users to enter their timesheets. Right now, I have to have a pop up window for each entry in the timesheet to post to the database, as when the page is built, I don't know how many entries it may have. Unfortunately, PHP doesn't allow the use of pointers or structures, otherwise I'd just do that and point the PHP page to the pointer for the info.

My question is; is there anyway to create a class that will store all of the data and then "magically" transfer that class to the other PHP page for posting to the database?

Thanks,
-Andrew

leatherback

Hi,

I Am not sure what you are asking (Since I am not using pointers in any of the languages I program in). But can't you just use array-type variables in your forms, and give the user either standard 10 / 20 / 30 lines in the form, or ask them how many lines they need? Loop through the array, and check whether data has been placed in it, then import?

e.g., how I do multiple image uploads:

File 1: <input type=file name=file[] size=30><br>
File: <input type=file name=file[] size=30><br>

...


  $FileArraySize = sizeof($_FILES['file']['name']);  // Get the number of files potentially uploaded
  $i = 0 ;                                         // Counter for outfilenames


  for ($x=0; $x<$FileArraySize; $x++)              // Check every one to see whehter a file has been uploaded
   {
   if(! empty($_FILES['file']['name'][$x]))        // If a file was uploaded, then..
     {

 if($i == 0)
   {
   $uitfile = $filebase.".jpg";
   }
 else
   {
   $uitfile = $filebase."_".$i.".jpg";
   }
 $i++;
 resizeImage(GetAName('tmp_name', $_FILES), $uitfile, $absolute_path);  // Resize the image, and copy it to the right location on the server
 }
   }

fender177

What you posted was slightly different than what I'm doing, but it works! I'm not posting files, just data inputted by the end user. So I simply made the inputs arrays and posted them, and used sizeof to get the number of entries. I did however, do something different... Instead of a for loop, I used a while loop. In the while loop I make sure 'x' is less than the number of entries, and that $_POST['asdf'][$x] != NULL. Works like a charm.

Thanks again.