Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2006-11-22
7
Medium Priority
?
539 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 1000 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
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!

 
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month9 days, 22 hours left to enroll

926 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