Re: [PHP] PHP and Palm Pilot interaction

2003-12-15 Thread Adam i Agnieszka Gasiorowski FNORD
Dave G wrote:

[...]

> But on the other hand, I was wondering if it may be possible to
> make use of the simple text editor on the Palm, or perhaps the newer
> Excel editors (which I have not yet tried), to create a file of flat
> data which could then be uploaded and interpreted by PHP and then
> entered into the DB. It seems to me that a simple text file would
> probably be easy to upload and read by PHP, but then I'd have to do more
> work to get the teachers to conform to layout standards and do more
> error checking since the text file allows for a wide range of mistakes
> to happen. The Excel file would make it easier for the teachers to see
> where to enter data and have less mistakes, but then it might be more
> difficult to get the data out of it, through PHP, and into the database.

[...]

Make a custom sheet in Excel for the
 teachers. Excel can generate a comma delimited
 (CSV) file out of a sheet. The you can very
 easily import that file into your PHP program
 :8] (there is even a function for it, IIRC).

-- 
Seks, seksić, seksolatki... news:pl.soc.seks.moderowana
http://hyperreal.info  { iWanToDie }   WiNoNa)   (
http://szatanowskie-ladacznice.0-700.pl  foReVeR(  *  )
Poznaj jej zwiewne kształty... http://www.opera.com 007

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP] PHP and Palm Pilot interaction

2003-12-15 Thread Dave G
PHP Gurus,
I have a web site that helps people sign up for workshops and
classes. The classes happen away from any computer or web access. What I
want to do is be able to collect data about payment and attendance and
be able to send it to the web site for inclusion into the MySQL
database.
Of course, I could go low tech and just have people write things
down and then later type in results when they finally get web access.
However, if possible, I would like to take advantage of the fact
that the teachers of these classes all carry Palm Pilots. If it were
possible, could they record data in some fashion that would allow them
to copy the data over to their PC when they hot synch, and then upload
it to a page where it would automatically be integrated into the site
database.
I have only the faintest notions about how this could work, and
I suspect it may simply not be possible.
But on the other hand, I was wondering if it may be possible to
make use of the simple text editor on the Palm, or perhaps the newer
Excel editors (which I have not yet tried), to create a file of flat
data which could then be uploaded and interpreted by PHP and then
entered into the DB. It seems to me that a simple text file would
probably be easy to upload and read by PHP, but then I'd have to do more
work to get the teachers to conform to layout standards and do more
error checking since the text file allows for a wide range of mistakes
to happen. The Excel file would make it easier for the teachers to see
where to enter data and have less mistakes, but then it might be more
difficult to get the data out of it, through PHP, and into the database.
If anyone has any pointers or advice about how to best approach
this problem, please let me know.

-- 
Yoroshiku!
Dave G
[EMAIL PROTECTED]

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php