Solved

php: read text out of the row/column and put it into mysql

Posted on 2006-11-22
7
534 Views
Last Modified: 2012-05-05
Hello,

Currently, I have a php file that reads a .csv file and puts the text thats in there on a html page in a table, row by row. First and second columns are text from the file, the third and fourth are inputs from the user. The third column is just textarea boxes and the fourth is an option group with a yes or no value. How do I read the text in column 1 2 and 4 that are being submitted row by row into a mysql table?

I have already experimented with creating a table..etc (so its already in there). I can read the value of the text area boxes into the table fine. The things that are missing are column 1, 2, and 4, which are text from the file on the page (1 and 2) and 4 is the optgroup value.

Any help is appreciated!
0
Comment
Question by:worpx
  • 4
  • 3
7 Comments
 
LVL 35

Accepted Solution

by:
Raynard7 earned 250 total points
ID: 18000414
Hi,

The only way to attain this csv information that you printed on the page for the user to view is to either:
1.  Put these values in hidden values on your form- so you can read them back in when submitted
2.  Save these values in a session variable and retreive them when it is time to write to the database
3.  Save these values in a session cookie and retreive them when it is time to write to the database
4.  Save these values in a database table, and storing the primary key of these in any of the above methods, so when it comes to saving you can link to this primary key
0
 
LVL 2

Author Comment

by:worpx
ID: 18000533
Hi,

Thank you for getting back to me so quickly. Can you explain a little more on what you mean by "1.  Put these values in hidden values on your form- so you can read them back in when submitted" and "4.  Save these values in a database table, and storing the primary key of these in any of the above methods, so when it comes to saving you can link to this primary key".

Which would be the easiest to implement and most efficient?

Also, in mysql tables, lets say I am storing these forms and there are going to be 4 per day. Do I store everything in 1 table, appending all the forms or multiple tables for all the different forms. I don't know if mysql will blow up when a certain point is reached.
0
 
LVL 35

Expert Comment

by:Raynard7
ID: 18000547
mysql will not blow up unless you have terrabytes of data in these forms.

depending on your security requirements each may be more efficient.

you can put data into a form by having an input with type = "hidden"

I'd reccomend option 2 for the fastest and most secure option - using $_SESSION[] to save your data
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 2

Author Comment

by:worpx
ID: 18000572
I don't mean to keep being so inquisitive, but would you happen to have any good examples of this $SESSION[] in use?

Thanks
0
 
LVL 35

Expert Comment

by:Raynard7
ID: 18000624
0
 
LVL 2

Author Comment

by:worpx
ID: 18000699
i'll give it a try; thanks a lot!
0
 
LVL 35

Expert Comment

by:Raynard7
ID: 18000779
Glad I could help you
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
Creating and Managing Databases with phpMyAdmin in cPanel.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

825 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question