Help with required fields

jbachris

I have the below code to insert text into the database. How can I check to see if the field has content and if it does enter into the db, if it doesn't to give an error message?

<?

require ( "axafdasdfaz.php" );

if ( $_POST['signup'] ) {

$sql = "INSERT INTO news(news_date, news_headline) VALUES('" . $_POST['news_date'] . "','" . $_POST['news_headline'] . "')";
$add_news_rs = $conn->Execute($sql) or die ( $conn->ErrorMsg() );

header ( "Location: thanks.php" );
}

?>
<form action="<? echo $PHP_SELF; ?>" method="post" name="add_news">
News Date: <input size="25" maxlength="70" type="text" name="news_date" value="<?php echo date("Ymd"); ?>">
<br /><br />
News Headline: <input size="25" maxlength="70" type="text" name="news_headline">
</form>

vaaaska

This is a rudimentary solution, but I think the idea is clear. You'll need to figure out what's the best way to work an error note into your script.

<? 

require ( "axafdasdfaz.php" ); 

if ( $_POST['signup'] ) { 

  if (($_POST['news_headline'] != '') && ($_POST['news_headline'] != '')) {
    $sql = "INSERT INTO news(news_date, news_headline) VALUES('" . $_POST['news_date'] . "','" . $_POST['news_headline'] . "')"; 
    $add_news_rs = $conn->Execute($sql) or die ( $conn->ErrorMsg() ); 

header ( "Location: thanks.php" ); 
  } else {
    $error_note = TRUE;
  }
} 

?> 
<form action="<? echo $PHP_SELF; ?>" method="post" name="add_news">
<?php if ($error_note == TRUE) echo "<p style='class='red'>There was an error</p>"; ?> 
News Date: <input size="25" maxlength="70" type="text" name="news_date" value="<?php echo date("Ymd"); ?>"> 
<br /><br /> 
News Headline: <input size="25" maxlength="70" type="text" name="news_headline"> 
</form>

jbachris

Thanks!

If I go with more than one field it would be:

if (($_POST['news_date] != '') && ($_POST['news_headline'] != '') && ($_POST['news_story'] != '')) {