Treating .csv Files As Database Data - Showing .CSV data on a web page

free web hosting
Open Discussion > CONTRIBUTE > The Internet > Web Design

Treating .csv Files As Database Data - Showing .CSV data on a web page

mrdee
I use a nice program (which I helped to beta test) called 'Simfatic Forms' to generate forms on web pages.
The only problem is that it does not (yet) support MySQL databases, it saves the form data as a .CSV file.

Now I was wondering if you can do the same with a .CSV file as you do with a MySQL databse, ie. displaying the data in that file on a web page which adjusts automatically as data are added to the file.

To clarify: eg. if I make a form to sign a petition online, the data are saved to a .CSV file every time someone fills in the form, is it now possible, using HTML or PHP, to put the people who signed the petition on a web page, without me having to update the page manually every time someone signs the petition?

Would it also be possible to only display some of the data instead of all of them? Eg. when people sign the petition they will be asked for their name, City and email address, but for protection of their privacy I would only display their name and city on the result page.

Is there a way to achieve all of the above and, if so, how should it be done?

Thanks in advance for any help.

 

 

 


Reply

jlhaslip
When I was starting out learning php, I wrote a Contact Form that displayed the messages onto the Web page below the Form.
It used a csv file to do that.
Example: http://www.jlhaslip.trap17.com/contact_form/contact.php

Let me know if you would like to see the zip file for it.

Reply

mrdee
QUOTE(jlhaslip @ Feb 2 2008, 04:51 PM) *
Let me know if you would like to see the zip file for it.

Yes, Jim.
That would definitely be helpful.
Thanks.


Reply



Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.

Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

(Maximum characters: 10,000)
You have characters left.

Recent Queries:-
  1. "csv to database" - 90.12 hr back. (1)
  2. web page database query - 91.29 hr back. (1)
  3. import csv to database - 468.08 hr back. (1)
  4. query csv file like database in java - 566.44 hr back. (1)
Similar Topics

Keywords : treating, csv, files, database, data, showing, csv, data, web, page

  1. How To Use A Database For Chess Results?
    How to set-up, configure, and utilize a database to store chess result (0)
  2. Auto-upload Files With Filezilla And Autohotkey
    (0)
    If your web host only allows FTP access and not shell access then you have to edit files locally and
    then upload them. If you are debugging your website that means making a lot of changes to a file or
    files and lots of manual uploads after each change to a file. FileZilla works great to upload and
    download files to a remote FTP site and it even allows you to set a default editor so you can right
    click on a remote file and click view/edit. It then downloads the file to a temporary directory and
    monitors any changes made to the file. When it detects that you have saved the....
  3. Naming Web Page Files
    Which way you like- MyPage.html or my-page.html or my_page.html (9)
    Everybody talks about meta tags, keywords, good title names and how they can increase page rankings,
    etc. But I was wondering whether the page name itself holds any value in indexing. Yes, I am
    talking about the web page file names (some-thing.html) NOT the one which you put in title tags. I
    am going to express my views and want to know what you think is correct. I have seen pages named in
    various ways like these: 1) my_web_page.html 2) DoYouLikeMyPage.html 3) hey-see-my-webpage.html (I
    think this way is more appropriate) 4) this.is.a.page.html (somewhat confusing) ....
  4. Need Help With My Database [resolved]
    retrive data as a link (6)
    This is the situation: I have a database where you can add bands ( theire albums, genre other
    info) For the album part they can add for each album the songs. So what do i want: When i show
    the results there only shoul display the bandname which should be a link to the more detailed info
    like albums biography etc. How do I do that. Is there a name for this and are there any
    tutorials. thx in advance....
  5. Mysql
    Several files in one field. (2)
    Hi guys. I want t know if it is posible to have so many entries for one object in a field in MySQL.
    I know my question may not be clear because I lack in terminology but pliz try and help. What I want
    to do is for axample have a database of my clients with the following fields for every client:
    fname, lname, more than one photos, contrubutions(comments, jokes, testimonials posted) etc. I want
    to have the things like the photos in the same field but they have to be unique so that my php code
    can deal with them individually llike they are coming from different fields.....
  6. Index In A Mysql Database
    Make the numbers follow (3)
    I hope I am on topic here (It does have to do with web design, after all). I have noticed that in a
    MySQL database, the 'id' field just keeps its numbers for every record, with the backdraw
    that, whenever you remove (a) record(s) from the table, you get your list numbered as eg.
    1,5,6,7,12,25 etc. This makes it a bit difficult of keeping track of the number of records in your
    table. Is there a way of achieving (either in PHPMyAdmin or through the use of PHP) that the id
    field in your table gets sort of 'refreshed and updated' so you have a clearer view....
  7. Accessing Mysql From Javascript
    Javascript to communicate with database (4)
    I found a nice program which allows you to put quizzes on your web site. You can design your own
    questions, set the layout of your page, and there is also a possibility of having the results
    emailed to you. It further offers a facility to store the results and all that, all you have to do
    is put a link in the program, telling it which page takes care of that. However, when I look at the
    HTML code the program generates, I see that most of it is written in Javascript. Obviously, it also
    uses variable names, but as I don't know any Java, I was wondering if those variab....
  8. Another Question On Mysql Table Data Type
    text field for lots of text. (1)
    In my MySQL table I would like to use one text field which can contain lots of text. What I want to
    use it for is for student records, and I want to be able to add to it without destroying what is
    already there. I want the field to contain something like: ****03/11/2007**** Chopin prelude No 9:
    small problem bars 12-15. Advice given on how to practice. ****10/11/2007**** Problem in Prelude
    overcome, piece successfully completed. New piece set: Beethoven Sonata No 1, movement 1. etc. This
    is of course just an example, but that is how I want to set up my student records....
  9. Which Data Type To Use In Mysql Table
    Using a 5 character number (4)
    If I wanted to use an ID field which automatically increments when data are addad, but displays the
    ID as a 5 figure number, which data type would I have to use? I would want a type that assigns a
    number to a record in the format "00001", "00002", etc. However, when I use "int" as datatype, it
    only displays th field contents as "1", "2" etc. So, which data type could do the job for me? i do
    not need a decimal point or anything, just an id that displays in 5 figures, including the leading
    zeros. Thanks in advance.....
  10. Where Am I Going Wrong This Time?
    Can't enter data into database (4)
    Hi, on my local machine (with Apache 2.0, PHP 5.2.4 and MySQL 5.0) I come across weird things. I
    have successfully made a table, but when I try to enter data into it it just will not accept the
    empty string for the first field (id). This was the creation line: QUOTE $query="CREATE
    TABLE members (id int(20) auto_increment,first varchar(15) NOT NULL,last varchar(15) NOT NULL,phone
    varchar(20) NOT NULL,mobile varchar(20) NOT NULL,fax varchar(20) NOT NULL,email varchar(30) NOT
    NULL,web varchar(30) NOT NULL,PRIMARY KEY (id),UNIQUE id (id),KEY id_2 (id))"; This has....
  11. Help With Database
    (24)
    I know I might sound a bit novice, but I'd like to know how to make a register and login
    database. I'm making a serious website for the very first time and I can't find on internet
    how to make one (don't even know how it is named). I would really appreciate me if someone could
    link me to a tutorial or give me the explanation, also the program to use (I think Microsoft Access
    is good?)....
  12. Merging Database Php Mysql
    (5)
    Hii i need help margning script. i have coppermine gallery, AzDGDating Site, Noah's
    Classifieds they all have user sign-up login. but they have different like i need to have 3 seperate
    account for each script is there any way like mergning one user name and password would work for 3
    section. if you don't get my question please tell me i will try to explain more in detail
    thank you for your time and help ....
  13. Help Or Advise Needed For Access Database Webpage Conversions
    I need some help with getting a linked webform so that the data can be (0)
    Hello All. I'm looking for some advise or assistance with getting a web page/access page
    running so that i can have the page online and collect the data live into my database for Project
    Management... Currently I'm developing a database using M$ Access, and need to have staff
    data enter sales information directly into a web form that can be linked to a database? I've
    looked at using a M$ Front page web form with data collected into a .CSV text file and
    extracting the data but i need to be able to let the staff review and update the data for eac....
  14. Host Files On Other Site
    (3)
    To save the disk usages of our host, we can upload files somewhere else like fileXoom or
    filelodge and any other file hosting service... but is there any filehosting service that provides
    gigabytes of space for free? If there's any, please tell... I have a lot of files to be upload
    to the net. If anyone can help me find free file host that provides 1 or 2 gigabytes of space.......
  15. How Do You Combine Multiple Mysql Databases Into One Database?
    (3)
    How do you combine multiple mysql databases into one database? I was thinking thta soem servers
    restrict you to one to five mysql databases. If I have a dynamic part of a table on my site, I
    would use one database for that. For every table of dynamic information, I use one database. Can I
    streamline what I am doing and combine all of my databases into one? I could make multipple tables
    in the same database. Would that work? thanks....
  16. Import From Excel File Into Mysql Database
    (11)
    Has anyone tried using the excel import function that comes with phpmyadmin
    http://www.phpmyadmin.net/home_page/ - it does not require any additional plug-ins or scripts and
    is fairly straightforward to use. In phpmyadmin, if you click on the database table which you wish
    to import the data to , there is a link on the bottom left corner which says "insert data from a
    text file into the table" - although it says text file it still can be used to import an excel file.
    When you click on this link you will be taken to a page where you will be asked for the file name
    (the....
  17. Free Dhtml Menu That Reads A Database
    Anyone know one? (7)
    Hey, anybody know a DHTML menu that reads info from a database? for people who don't know, just
    like windows' "start menu" with the popup menus I want to mod it so that in phpnuke I can edit
    it admin panel end. I would like it to be vertical. Do not use note tags because they are only for
    admins and moderators. ....
  18. Webpage Design- Autodownloading Hosted Files
    hosted "zip" file download-How To ??? (1)
    Hi Guys, Posted this inquiry over a week ago & got no replys so I'm re-posting via new thread.
    How do I setup a automatic download to a webpage visitor to my website? If I "host" (ie. store the
    file ) on my website how do I make it so that the visitor can click on a button & get the file to
    automatically download to their computer.??? This may seem obvious to youall but I'm very new
    and have no idea. All Info appreciated!!! Any Links to "How To"s ?? Tutorials ?? Thanks
    in advance RGPHNX....
  19. Website Building- E-mail Forwarding & Downloads
    Response Forms & downloading zip files (9)
    Hi guys, Am new to designing. How do I : 1) include a popup form on my webpage for the visitor to
    input info & have the info forwarded to my personal e-mail account (not trap17). 2) make links to
    download files (ie. zip etc.) hosted on my website for ftp direct download to the visitors computer.
    (You know, click a link & the file automatically downloads) Any info appreciated !!!
    Tutorials ????????????????? Step by step info ???????????? Thanks in advance RGPHNX....
  20. Another Good Place To Host Files
    But not so good like the latest post (0)
    http://yousendit.com - You can host and shre your uploaded files (Up to 1 Gb) - But the link
    to download the file will be active for 7 days or 25 downloads and you can send to an email while
    you upload it. - The speed is very fast, beleave me. Maybe already some of the members know this
    free service, but know all the members will know the power of this great free service. More links
    to come, or go to my website to view them in file storage menu.....
  21. Good Places To Storage Files
    to share them (2)
    http://ezshare.de ezShare is a absolutely free service for hosting files without the need to
    sign-up. The whole service is ad-financed. More infos can be found in our FAQ. FAQ: 1-Klick
    Hosting at RapidTec - Frequently Asked Questions Can I embed uploaded images directly in
    HTML-files? Like every big Service in the net, we have to assure that the traffic can be paid. If
    the images are embedded directly, we have absolutely no chance to do any advertising at all. Due to
    this, the DIRECT embedding of images is not possible. Can I delete my uploaded files? Sure....
  22. A Lot Of Photoshop Templates
    Just 2 zip files (0)
    Here it is: CODE http://www.buycheapwebsites.com/download/bct-psd1.zip CODE
    http://www.buycheapwebsites.com/download/bct-psd2.zip Carpe diem.....

    1. Looking for treating, csv, files, database, data, showing, csv, data, web, page

*RANDOM STUFF*





*SIMILAR VIDEOS*
Searching Video's for treating, csv, files, database, data, showing, csv, data, web, page

*MORE FROM TRAP17.COM*
advertisement



Treating .csv Files As Database Data - Showing .CSV data on a web page



 

 

 

 

ADD REPLY / Got an Opinion! a humble request :-) RAPID SEARCH! Free Hosting [X]
Express your Opinions, Thoughts or Contribute your information that might help someone here.
Ask your Doubts & Queries to get answers.. "Together, We enlight each other!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE