ridiculously easy question

wakanda

Hi. I have a page which extracts data from a PAD file and prefills the form with it. The code is here:

http://www.padspec.org/padsdk/php/

at number two. I know it's dead easy but I don't know how to get it to insert the data into the database as an option after having made the user prefill the fields.

jkurrle

Are you looking for information on how to insert into a database, or are you looking for information regarding user interaction?

wakanda

Yes, I'm trying to insert the extracted xml data into the database I'm using (MySQL) because the sample code doesn't deal with the database insertion part. Once I prefill the form with data from this PAD file here for instance,
http://www.file-portal.net/temp/pad_file.xml

using the "prefill" button, I would like to be able to insert the data into a MySQL table. Only I don't know how to do it in PHP, although I know SQL enough to do it using PHPMyAdmin for instance. I added the "Submit" button

<input class="submitbutton" type="submit" name="insert_data" value="Submit" />

and tried to do something like

if (isset($_POST['insert_data'])) {

("INSERT INTO [db_table] VALUES (NULL, '$author', '$email', '$subject', '$story', now(), '$url1', '$url2', '$url3', '$url4', '$url5', '$url6', '$url7', '$url8')");

and nothing happened.

jkurrle

Well, that seems a little complicated to me, being a newbie, but to do an insert in MySQL isn't too complicated. Assuming you know how to connect to the database already, here's the basics:

$insert = "insert into My_Table (column_name1, column_name2)
    values ('value1','value2')";
$result = mysql_query($insert)
    or die("Error inserting values into My_Table table.");

If you are looking to extract the data into values, I'm not the best at doing this, but I'd explore using the explode() function, combined with array_shift().

Hope this helps...

wakanda

Originally posted by jkurrle
Well, that seems a little complicated to me, being a newbie, but to do an insert in MySQL isn't too complicated. Assuming you know how to connect to the database already, here's the basics:
$insert = "insert into My_Table (column_name1, column_name2)
    values ('value1','value2')";
$result = mysql_query($insert)
    or die("Error inserting values into My_Table table.");
If you are looking to extract the data into values, I'm not the best at doing this, but I'd explore using the explode() function, combined with array_shift().

Hope this helps... [/B]

Thanks for taking the time to answer. There was a little quote missing which caused everything to go apart silently. Otherwise the code I was using was just the same as yours but since it failed for no apparent reason, I thought there was something wrong with it.