PHP - How Do I Clear The Form Fields After It Has Been Submitted ??

I have an account on theirsite.com and I want to be able to submit my login credentials from mysite.com/page1.php and then redirect back to mysite.com/page2.php.

I've been Googling for hours now and nothing I can find works and I don't know a thing about cURL and would rather not get into it. Not to mention, I'm using free hosting for now and I don't believe I'm able to use cURL anyways.

I can get it to log in with the credentials just fine, that's no problem, but I just have no clue how to get it to redirect back to my page or just send the credentials and then staying on my page because I could work with that as well (send credentials to theirsite.com from mysite.com/page1.php and staying on mysite.com/page1.php).

Is there anyone that could give me a hand on how to do this without using cURL since my php.ini is not editable?

Thanks

how can i disply this message withing the form echo "data submitted successfully!";

currently after validation check when data is entered the message show on top of my page not within the form



function insertDATA($postData) {

if(!ifEmailExists($postData['email'])){
$sql = " INSERT INTO tbl SET
email = '".$postData['email']."',
name = '".$postData['name']."',
phone = '".$postData['phone']."'
";
                      echo "data submitted successfully!";//this line withing the form
executeSql($sql);
}

Hello all,

I am having a bit of trouble with this contact form. Everything submits fine, errors work and all but the information isn't sent to my inbox. Can anyone point out where the problem is? Thanks in advance!

Code: [Select]
if(isset($_POST['Email_Address'])) {

include 'free_settings.php';

function died($error) {
echo "Sorry, but there were error(s) found with the form you submitted. ";
echo "These errors appear below.<br /><br />";
echo $error."<br /><br />";
echo "Please go back and fix these errors.<br /><br />";
die();
}

if(!isset($_POST['Full_Name']) ||
!isset($_POST['Email_Address']) ||
!isset($_POST['Your_Message'])) {
died('We are sorry, but there appears to be a problem with the form you submitted.');
}

$full_name = $_POST['Full_Name']; // required
$email_from = $_POST['Email_Address']; // required
$comments = $_POST['Your_Message']; // required

$error_message = "";
$email_exp = '/^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$/';
  if(preg_match($email_exp,$email_from)==0) {
  $error_message .= 'The Email Address you entered does not appear to be valid.<br />';
  }
  if(strlen($full_name) < 2) {
  $error_message .= 'Your Name does not appear to be valid.<br />';
  }
  if(strlen($comments) < 2) {
  $error_message .= 'The Comments you entered do not appear to be valid.<br />';
  }
 
  if(strlen($error_message) > 0) {
  died($error_message);
  }
$email_message = "Form details below.\r\n";

function clean_string($string) {
  $bad = array("content-type","bcc:","to:","cc:","href");
  return str_replace($bad,"",$string);
}

$email_message .= "Full Name: ".clean_string($full_name)."\r\n";
$email_message .= "Email: ".clean_string($email_from)."\r\n";
$email_message .= "Message: ".clean_string($comments)."\r\n";

$headers = 'From: '.$email_from."\r\n".
'Reply-To: '.$email_from."\r\n" .
'X-Mailer: PHP/' . phpversion();
@mail($email_to, $email_subject, $email_message, $headers);
header("Location: $thankyou");
?>
<script>location.replace('<?php echo $thankyou;?>')</script>
<?php

Hi.. all

I have a problem in my web site. There I have created a page call download.php and using it users can download song. I used a form to download button to display download box. after users click on download link i need to cancel it on that page. that mean I want to disappear it on download.php page. now when i click on browser's refresh button that download box still display on page. so any body can i help me to do it..

http://www.mist.lk/d...ad.php?index=52

thanks in advance for any help....

Hi,
 Say I have the situation shown below:  

Good afternoon,   I was wondering if you could help me out with a few things.  I have created a registration page and it stores the information into my database.  A success page then appears with some of the details they entered as a confirmation page.  Unfortunately I cannot get the information to appear on the page.  I have included some code, any help would be greatly appreciated.   <?php

Following is the form.Now i want to see if submit button is pressed or not.Usually if html had

Code: [Select]
<input type="submit" value="Submit" name = "submit" />
i would simply use
Code: [Select]
<?php
if(isset($_POST['submit']))
?>
But below is the form which has an image as a submit button

Form -
Code: [Select]
<form action="" method="post" id="sendemail">
            <ol>
              <li>
                <label for="name">Name (required)</label>
                <input id="name" name="name" class="text" />
              </li>
              <li>
                <label for="email">Email Address (required)</label>
                <input id="email" name="email" class="text" />
              </li>
              <li>
                <label for="email">Phone number</label>
                <input id="phone" name="phone" class="text" />
              </li>
               <li>
                <label for="address">Address(required)</label>
                <input id="address" name="address" class="text" />
              </li>
              <li>
                <label for="city">City(required)</label>
                <input id="city" name="city" class="text" />
              </li>
              <li>
                <label for="state">State(required)</label>
                <input id="state" name="state" class="text"/>
              </li>
               <li>
                <label for="zipcode">Pincode/Zipcode(required)</label>
                <input id="zipcode" name="zipcode" class="text" />
              </li>
              <li>
                <input type="image" name="submit" id="imageField" src="images/submit.gif" class="send" />
                <div class="clr"></div>
              </li>
            </ol>
          </form>   
How should i check if form is submitted or not when instead of submit button there is an image ?

----------------------------------------------------------------- Alternative Solution ----------------------------------------------------------------------------

 I tried sending it to other page but then i had to send an array back to this page and i didn't know how to send that either.I tried
Code: [Select]
<?php
$error = serialize($error);
  echo "<meta http-equiv='refresh' content='0;url=about.php?array=".$error."'> ";
?>
But even after

Code: [Select]
$array = unserialize($array);
$array contained nothing.

Can someone please show me how to send in array in between pages for future ?

Hi,

I am working on a registration login system and after a person registers and logs in, they will get the option to upload a profile picture. The picture and registration info will need to be in two different tables. I want to know the best way to associate the two (registration info and photo) so that I know who's picture goes with what registration info? I thought about IP address, but a user might register on one computer and login and upload a photo on another computer. 

Hi-
the code below lets me upload a CSV file to my database if I have 1 field in my database and 1 column in my CSV.
I need to add to my db "player_id" from the CVS file and "event_name" and "event_type" from the form... any ideas???

here's the code:
Code: [Select]
<?php
$hoststring =""; 
$database = "";
$username = "";
$password = "";
$makeconnection = mysql_pconnect($hoststring, $username, $password);
?>
<?php
ob_start();
mysql_select_db($database, $makeconnection);
$sql_get_players="
SELECT * 
FROM tabel 
ORDER BY player_id ASC";
//
$get_players = mysql_query($sql_get_players, $makeconnection) or die(mysql_error());
$row_get_players = mysql_fetch_assoc($get_players);
//
$message = null;
$allowed_extensions = array('csv');
$upload_path = '.'; //same directory

if (!empty($_FILES['file'])) {

if ($_FILES['file']['error'] == 0) {
// check extension
$file = explode(".", $_FILES['file']['name']);
$extension = array_pop($file);

if (in_array($extension, $allowed_extensions)) {

if (move_uploaded_file($_FILES['file']['tmp_name'], $upload_path.'/'.$_FILES['file']['name'])) {

if (($handle = fopen($upload_path.'/'.$_FILES['file']['name'], "r")) !== false) {
$keys = array();
$out = array();
$insert = array();
$line = 1;

while (($row = fgetcsv($handle, 0, ',', '"')) !== FALSE) {

foreach($row as $key => $value) {    

if ($line === 1) {
$keys[$key] = $value;       
} else {       
$out[$line][$key] = $value;              
}       
}                
$line++;          
}        

fclose($handle);            

if (!empty($keys) && !empty($out)) {        
$db = new PDO(
'mysql:host=host;dbname=db', 
'user', 
'pw');   

$db->exec("SET CHARACTER SET utf8");        

foreach($out as $key => $value) {        
$sql  = "INSERT INTO `table` (`";
$sql .= implode("`player_id`", $keys);    
$sql .= "`) VALUES (";    
$sql .= implode(", ", array_fill(0, count($keys), "?"));    
$sql .= ")";    
$statement = $db->prepare($sql);    
$statement->execute($value);       
}      

$message = '<span>File has been uploaded successfully</span>';      
}
}
}
} else {
$message = '<span>Only .csv file format is allowed</span>';
}
} else {
$message = '<span>There was a problem with your file</span>';
}
}
ob_flush();?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>CSV File Upload</title>
</head>
<body>

<form class="form" action="" method="post" enctype="multipart/form-data">
<h3>Select Your File</h3>
<p><?php echo $message; ?></p>
<input type="file" name="file" id="file" size="30" />
<br/>
<label>Event Name:</label><input name="event_name" type="text" value="" />
<br/>
<label>Event Type:</label><input name="event_type" type="text" value="" />
<br/>
<input type="submit" id="btn" class="button" value="Submit" />
</form>

<br/>
<h3>Results:</h3>
<?php do { ?>
<p><?php echo $row_get_players['player_id'];?></p>
<?php } while ($row_get_players = mysql_fetch_assoc($get_players)); ?>
</body>
</html>

 

I need help with a form ..

My form needs to allow an additional drop down field for Groups. This form also needs to save the extra fields chosen into my MySQL DB.

Here is my form..
Code: [Select]
<form action='' method='post' class='assessment'>
<h1>Create User</h1>
<div class='label'>First Name</div>
<div class='field'><input type='text' name='firstname' value='<?=$preUser->firstname?>' /></div>
<div class='cb'></div>
<div class='label'>Last Name</div>
<div class='field'><input type='text' name='lastname'  value='<?=$preUser->lastname?>' /></div>
<div class='cb'></div>
<div class='label'>Password</div>
<div class='field'><input type='text' name='password'  value='<?=$preUser->password?>' /></div>
<div class='cb'></div>
<div class='label'>Company</div>
<div class='field'><input type='text' name='company'  value='<?=$preUser->company?>' /></div>
<div class='cb'></div>
<div class='label'>Job Title</div>
<div class='field'><input type='text' name='job'  value='<?=$preUser->job?>' /></div>
<div class='cb'></div>
<div class='label'>Group Name</div>
<div class='field'><select name='group'><?=$groupSelect?></select></div>
<div class='cb'></div>
<div class='label'>Address</div>
<div class='field'><input type='text' name='street1'  value='<?=$preUser->street1?>' /></div>
<div class='cb'></div>
<div class='label'>Address (optional)</div>
<div class='field'><input type='text' name='street2'  value='<?=$preUser->street2?>' /></div>
<div class='cb'></div>
<div class='label'>City</div>
<div class='field'><input type='text' name='city'  value='<?=$preUser->city?>' /></div>
<div class='cb'></div>
<div class='label'>State</div>
<div class='field'><input type='text' name='state'  value='<?=$preUser->state?>' /></div>
<div class='cb'></div>
<div class='label'>Postal Code</div>
<div class='field'><input type='text' name='postal'  value='<?=$preUser->postal?>' /></div>
<div class='cb'></div>
<div class='label'>Country</div>
<div class='field'><input type='text' name='country'  value='<?=$preUser->country?>' /></div>
<div class='cb'></div>
<div class='label'>Fax</div>
<div class='field'><input type='text' name='fax'  value='<?=$preUser->fax?>' /></div>
<div class='cb'></div>
<div class='label'>Phone</div>
<div class='field'><input type='text' name='phone1'  value='<?=$preUser->phone1?>' /></div>
<div class='cb'></div>
<div class='label'>Phone 2</div>
<div class='field'><input type='text' name='phone2'  value='<?=$preUser->phone2?>' /></div>
<div class='cb'></div>
<div class='label'>Email</div>
<div class='field'><input type='text' name='email'  value='<?=$preUser->email?>' /></div>
<div class='cb'></div>
<div class='label'>Website</div>
<div class='field'><input type='text' name='website'  value='<?=$preUser->website?>' /></div>
<div class='cb'></div>
<div class='label'>Photo</div>
<div class='field imgupload'>
<input type='hidden' name='photo' />
<? if( $preUser->photo ){ ?>
<img src="../<?=$preUser->photo?>" style="height:300px; float:left;" />
<span class="rmimage" style="color:red; cursor:pointer; font-size:20px;padding-left:15px;" alt="<?=$preUser->photo?>">x</span>
<? }else{ ?>
<iframe src="../view/photo_upload.php" frameborder="0" scrolling="no" width="300" height="30"></iframe>
<? } ?>
</div>
<div class='cb'></div>
<div class='label'>Payment Option</div>
<div class='field'>
<input type='radio' name='payment' value='Pay' <? if( $preUser->payment == 'Pay' ) echo "checked='checked'"; ?> />Pay<br />
<input type='radio' name='payment' value='NonPaid' <? if( $preUser->payment == 'NonPaid' ) echo "checked='checked'"; ?> />NonPaid
</div>
<div class='cb'></div>
<div class='label'>Dashboard Options</div>
<div class='field'>
<div><input type='checkbox' name='mysteps' <? if( $preUser->mysteps ) echo "checked='checked'"; ?> value='1' />My Steps</div>
<div><input type='checkbox' name='mycalendar' <? if( $preUser->mycalendar ) echo "checked='checked'"; ?> value='1' />My Calendar</div>
<div><input type='checkbox' name='myprofiles' <? if( $preUser->myprofiles ) echo "checked='checked'"; ?> value='1' />My Profile</div>
<div><input type='checkbox' name='myplans' <? if( $preUser->myplans ) echo "checked='checked'"; ?> value='1' />My Plans</div>
</div>
<div class='cb'></div>
<div class='submit_assessment'><input type='submit' name='create_user' class='submit' value='Create User' /> <input type='button' value='Back' class='back' name='admin_create' /></div>
<div class='cb'></div>
</form>
<script>
function setUploadedImage(flink){
$('.imgupload > input:first').after('<img src="../'+flink+'" style="height:300px; float:left;" /><span class="rmimage" style="color:red; cursor:pointer; font-size:20px;padding-left:15px;" alt="'+flink+'">x</span>');
$('.imgupload > iframe:first').remove();
$('.imgupload > input:first').val(flink);
}
$('.rmimage').live('click', function (){
$(this).prev().prev().val('');
$(this).prev().remove();
$(this).after('<iframe src="../view/photo_upload.php" frameborder="0" scrolling="no" width="300" height="30"></iframe>');
$.post('../ajax/admin.php',{remove_image:$(this).attr("alt")});
$(this).remove();
});
</script>
the specific area in question is this...
Code: [Select]
<div class='label'>Group Name</div>
<div class='field'><select name='group'><?=$groupSelect?></select></div>
I need to be able to add another dropdown list to allow for multiple group selections that get saved into the DB once submitted.

How do I go about doing this??????

Hi Guys i need help on a small matter.

if you go to https://www.mywebchambers.co.uk/invoiceman/form.php

when submitted all works ok.

However if you delete rows 3, 4 and 5 and submit the page shows a value of 0.00 in the total column on rows 3, 4 and 5.

How do i get this value removed so it is blank same as the rest ?

 

My form action is toolstation3.php code below

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Toolstation</title>
<meta name="generator" content="WYSIWYG Web Builder 14 - http://www.wysiwygwebbuilder.com">
<link href="toolstation.css" rel="stylesheet">
<link href="toolstation.css" rel="stylesheet">
</head>
<body>

<?php

{$orderno =($_POST["orderno"]);}
{$date =($_POST["date"]);}
{$totalvalue =($_POST["totalvalue"]);}
{$code1 =($_POST["code1"]);}
{$name1 =($_POST["name1"]);}
{$price1 =($_POST["price1"]);}
{$amount =($_POST["amount"]);}
{$quantity1 =($_POST["quantity1"]);}
{$total =($_POST["total"]);}
{$contact1 =($_POST["contact1"]);}
{$contact2 =($_POST["contact2"]);}
{$contact3 =($_POST["contact3"]);}
{$contact4 =($_POST["contact4"]);}
{$contact5 =($_POST["contact5"]);}
{$depot =($_POST["depot"]);}
{$company =($_POST["company"]);}
{$title =($_POST["title"]);}
{$firstname =($_POST["firstname"]);}
{$lastname =($_POST["lastname"]);}
{$mobile =($_POST["mobile"]);}
{$email =($_POST["email"]);}
{$vatband1 =($_POST["vatband1"]);}

{$code2 =($_POST["code2"]);}
{$name2 =($_POST["name2"]);}
{$price2 =($_POST["price2"]);}
{$quantity2 =($_POST["quantity2"]);}
{$vatband2 =($_POST["vatband2"]);}

{$code3 =($_POST["code3"]);}
{$name3 =($_POST["name3"]);}
{$price3 =($_POST["price3"]);}
{$quantity3 =($_POST["quantity3"]);}
{$vatband3 =($_POST["vatband3"]);}

{$code4 =($_POST["code4"]);}
{$name4 =($_POST["name4"]);}
{$price4 =($_POST["price4"]);}
{$quantity4 =($_POST["quantity4"]);}
{$vatband4 =($_POST["vatband4"]);}

{$code5 =($_POST["code5"]);}
{$name5 =($_POST["name5"]);}
{$price5 =($_POST["price5"]);}
{$quantity5 =($_POST["quantity5"]);}
{$vatband5 =($_POST["vatband5"]);}

{$sum1 =($_POST["sum1"]);}
{$sum2 =($_POST["sum2"]);}
{$sum3 =($_POST["sum3"]);}
{$sum4 =($_POST["sum4"]);}
{$sum5 =($_POST["sum5"]);}

{$nil =($_POST["nil"]);}

{$net =($_POST["net"]);}
{$vat =($_POST["vat"]);}
{$percentage =($_POST["percentage"]);}

$sum1=$quantity1*$price1;
$sum2=$quantity2*$price2;
$sum3=$quantity3*$price3;
$sum4=$quantity4*$price4;
$sum5=$quantity5*$price5;

$net=$sum1+$sum2+$sum3+$sum4+$sum5;

$total=$net+$vat;
$vatrate=20;
$vat=$net/100*20;
$total=$net+$vat;

$sum1 = number_format($sum1, 2, '.', '');
$sum2 = number_format($sum2, 2, '.', '');
$sum3 = number_format($sum3, 2, '.', '');
$sum4 = number_format($sum4, 2, '.', '');
$sum5 = number_format($sum5, 2, '.', '');

$net = number_format($net, 2, '.', '');
$vat = number_format($vat, 2, '.', '');
$total = number_format($total, 2, '.', '');

if(empty($_POST['quantity3']) && empty($_POST['price3'])) {echo " $nil";}
$nil='';

echo "<H3> &nbsp&nbsp Toolstation Invoice";

echo "<br>&nbsp&nbsp&nbsp____________________________________________________________________________________________________<br><br>";

echo "<H3> &nbsp&nbsp Address &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp Details  ";

echo "<br>&nbsp&nbsp&nbsp___________________________________________________________ &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp____________________________________<br><br>";

echo "<table cellpadding=3 border=0 style='float:left'>";

echo "<tr>
<td>Contact<br><br>$contact1<br>$contact2<br>$contact3<br>$contact4<br>$contact5</td>
</td>";
echo "</table>";

echo "<table cellpadding=3 border=0 style='float:left'>";

echo "<tr>
<td>Delivery<br><br>$contact1<br>$contact2<br>$contact3<br>$contact4<br>$contact5</td>
</td>";
echo "</table>";

echo "<table cellpadding=3 border=0 style='float:left'>";

echo "<tr>
<td>Payment &nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp<br><br>$contact1<br>$contact2<br>$contact3<br>$contact4<br>$contact5</td>
</td>";
echo "</table>";

echo "<table cellpadding=3 border=0 style='float:left'>";

echo "<tr> 
<td>Order No<br>Placed On<br>Completed On<br>Total Value<br>Currency<br>Depot<br>Payment<br>UID<br>Company<br>Title<br>First Name<br>Last Name<br>Mobile<br>E Mail</td>
</td>";
echo "</table>";

echo "<table cellpadding=3 border=0>";

echo "<tr>
<td>QR4298562763000001<br>$date<br>$date<br>$total<br>GBP<br>Rotherham (R4)<br>Cash<br>CWW01074397<br>$company<br>$title<br>$firstname<br>$lastname<br>$mobile<br>$email</td>
</td>";
echo "</table>";

echo "<H3> &nbsp&nbsp Items";

echo "<br>&nbsp&nbsp&nbsp__________________________________________<br><br>";

echo "<table cellpadding=3 border=1>";

echo "<tr><th>Code</th><th>Name</th><th>Quantity</th><th>Price</th><th>Total</th><th>Vat Band</th></tr>";

echo "<tr><td>$code1</td><td>$name1</td><td>$quantity1</td><td>$price1</td><td>$sum1</td><td>$vatband1</td> ";

echo "<tr><td>$code2</td><td>$name2</td><td>$quantity2</td><td>$price2</td><td>$sum2</td><td>$vatband2</td> ";

echo "<tr><td>$code3</td><td>$name3</td><td>$quantity3</td><td>$price3</td><td>$sum3</td><td>$vatband3</td> ";

echo "<tr><td>$code4</td><td>$name4</td><td>$quantity4</td><td>$price4</td><td>$sum4</td><td>$vatband4</td> ";

echo "<tr><td>$code5</td><td>$name5</td><td>$quantity5</td><td>$price5</td><td>$sum5</td><td>$vatband5</td> ";

echo "</table>";

echo "<br>";

echo "<H3> &nbsp&nbsp VAT Analysis";

echo "<br>&nbsp&nbsp&nbsp__________________________________________<br><br>";

echo "<table cellpadding=5 border=1>";

echo "<tr><th>Band</th><th>Rate</th><th>Net</th><th>VAT</th><th>Total</th></tr>";

echo "<tr><td>5</td><td>20%</td><td>$net</td><td>$vat</td><td>$total</td> ";

echo "</table>";

?>

<div id="container">
</div>
</body>
</html>

 

Is there anything wrong (or insecure) with using hidden form fields?

I am working on a page where the user can choose one of 4 different subscription options.

The approach I was going to use is to have a separate form for each plan, and when the user chooses one, submit a hidden form value so my script knows which subscription plan to grab out of the database.

Thoughts?

Hello. So I already know an extremely elementary way to check to see if a form field is blank using PHP. For example:
Code: [Select]
if ($subject == "")
The question I have is, is there a way to have php check every field in a form to make sure it has some sort of value? I want to create an 'if' statement which basically says, "If all form fields have something filled in, then do this" For example

Code: [Select]
if ($subject == "any value") & ($name == "any value") & ($comment == "any value")

Not sure if that makes sense. Any help would be greatly appreciated!!!

I have got another of those problems that should be easy to solve but I cannot get my head round it!

I have a form to enter data into a table and one of the fields can be left blank. However, I'd data is entered in the field it can be a Zero. This is leaving me a problem as I cannot find a way to get the script to insert NULL if the field is blank but actually put the Zero in if that is what is entered.

I have tried several permutations of nested if's using empty or isset, but whatever I try, the same result is inserted in both scenarios.

The arguments I need to pass are......
If field is empty INSERT null
If field is 0 INSERT 0
If field is not empty and not 0 INSERT field

Thanks in advance for any suggestions.

Steve

 I have a database field

 `color` enum('red','blue','green','white') DEFAULT NULL,
and php form

<label for="color">Colors</label><br />
<input type="text" name="color" />
How do i display enum value on the php form from mysql database? Please help

php mysql