Help: Inserting data in DB via php scrpt

Anon

I would like that have a single php file that handles inserting a new story into my db of articles.

I want to write the script such that if it sees that no information is being submitted to it, it will print out the form html. If it sees that it is being sent form information (values), it should parse and process the text instead of printing the from html.

Ex.: (name of script os "insert.php")

if ( <I'm looking to insert a new article> ) {
print("
<form method="post" action="insert.php">
etc...
}

else if ( <I want script to parse text sent to it>) {
<process the text>
}

Anon

The way I've done similar is to write a little function that checks if the form field have been filled out like this:

function fields_are_complete() {
  if(empty(£first_val)) {
    return FALSE;
  } elseif(empty(£second_val)) {
    return FALSE;
  } else return TRUE;
}

then....

if(fields_are_complete()) {
   insert_article();
} elseif(!fields_are_complete()) {
   reprint_form_with_values();
} else print_blank_form();

It's a rough idea of what I do in a script I'm working on so if it doesn't work then I hope yu at least get the generall idea.

Let me know how you get on and if neccessary I'll send you my code so you can take a better look.

Nick Wilson

Anon

I get what you're saying, but isn't it a little tedious to go through each value one by one? Couldn't you use a for loop on the array of values?

I tried this:

if( !empty($submit) ) {
<process info>
}

else {
<print my form html>
}

But that didn't work too well. I would sumbit the form, but the it wouldn't processs the info, it would just print the html again.

Also, is there a function to flush out the info from the previous form? I want the info from the previous time I submitted something to be removed.

Anon

It's onæy tedius once if you use a function, I couldn't see any other way of doing it.

Looks like you'll need to be looking at sessions to achieve what you're after so you have stuff like this:
<input type="text" name="value" value="<?=$temp_value; ?>">
register the temp vars and when you need a blank form unset them.

Nick