from text file to database

CodyG

I cobbled together a petition module. Until this morning it was all working just groovy. Now I'm thinking I should be using a database for the information and not a text file. My php-nuke site was featured on UniverseToday (www.universetoday.com), and it is suddenly busy!!! www.friendsofnasatv.org

This is how I put the data into the text file: How difficult is it going to be to convert this into a mysql database in phpnuke?

 $myPet = fopen("modules/pet/pet.txt", "a");
      fputs($myPet, "$sender_name\n$sender_email\n$sender_loc\n$message\n");

  /* convert <br> to "n"new "l"ine "br"eak */
  $con = str_replace("<br />", " ", "$con");

  fclose($myPet);

And I retrieve from the text file to view on a page like this:

<?php

   if (file_exists("pet.txt")) {
      $myPet = file("pet.txt");
      for ($num = count($myPet), $i = $num / 4; $num >= 4; $num -= 4, $i--) {
         print("<b>Entry $i</b><br>");
         print("<b>Name:</b> " . $myPet[$num-4] . "<br>");
         print("<b>Email:</b> <a href=\"mailto:" . $myPet[$num-3] . "\">" . $myPet[$num-3] . "</a><br>");
         print("<b>Location:</b> " . $myPet[$num-2] . "<br>");
         print("<b>Comments:</b> " . stripslashes($myPet[$num-1]) . "<hr class=\"font1\">");
      }
   }
?>

I'm familiar with using phpmyadmin, but I'm really not sure exactly what I need to do to get this all working with a database. And, I'm in a bit of a hurry, which doesn't help.

Thanks for any suggestions, words, and hints.

ozzythaman

create a database with correct types of columns and then use

LOAD DATA INFILE "modules/pet/pet.txt" INTO TABLE pet;
(manual chapter 6.4.9)

or directly use phpmyadmin, it has functions for formatting the input made simple (column, row delimiters etc)..

CodyG

I created this table, using the variables from my script as fields. I'm guessing that's right. I'm guessing at the structure too. I hope it will work.

Table structure for table `nuke_petition`

CREATE TABLE nuke_petition (
pet_id int(10) NOT NULL auto_increment,
sender_name varchar(50) NOT NULL default '',
sender_email varchar(255) NOT NULL default '',
sender_loc varchar(50) NOT NULL default '',
message text NOT NULL,
PRIMARY KEY (post_id)
) TYPE=MyISAM;

I need to figure out how to put the form data into that table via script. Would it look like this?

sql_query("INSERT INTO ".$prefix."_petition (sender_name, sender_email, sender_loc, message) VALUES ('$sender_name', '$sender_email', '$sender_loc', '$message')", $dbi);

Tried that, didn't get any errors, but the data didn't get put into the table.

This has one more field, pet_id, than the data that went to the text file. How do I handle that? Perhaps that id field is not required?