?
Solved

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

Posted on 2006-11-22
7
Medium Priority
?
538 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying 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

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
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

719 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