if..else code didn't function as it need to

sicKo · April 4, 2009

This is the code for the image that I suppose to click..

  ....................
<TR>
                        <TD><IMG src="./shoes_files/pixel_trans2.gif" border="0" alt="" width="10" height="1"></TD>
                        <TD align="right" style="padding:5px;"><INPUT type="image" src="./shoes_files/button_new_customer.gif" border="0" alt="Continue" title=" Continue " name = "newcust"></TD>
                  </TR>
                  </TBODY></TABLE></TD></form>

This is the function when the image is clicked

<?php 
// Connect to the database 
$con = mysql_connect("localhost", "root"); 
mysql_select_db("project",$con);



if($POST['newcust'] = 'image')
{

$sql = "INSERT INTO member values ('null','".$_POST['firstname']."','".$_POST['lastname']."','".$_POST['email_address']."','".$_POST['street_address']."','".$_POST['city']."','".$_POST['postcode']."','".$_POST['country']."','".$_POST['telephone']."','".$_POST['fax']."','".$_POST['password']."','".$_POST['method_id']."')";

$result = mysql_query($sql,$con);

if(mysql_query($sql,$con))
{
echo "data saved";
}
else
{
echo "error data : ".mysql_error();
}

}
?>

When I clicked the image, it does not save the data into the database but when I refresh the page, it automatically insert empty data into the database.. Can anybody help me?

redarrow · April 4, 2009

if($POST['newcust'] = 'image') <<< what that?

if($_POST['newcust'] = 'image') corrected.

and use mysql_real_escape_string() on all posting variables for database protection.

and if it a form submiting

use

if(isset($_POST['submit'])){ // form button name submit.

}

peuge · April 4, 2009

You also have to give your input a value="image"

sicKo · April 4, 2009

I've corrected the '$POST' to '$_POST'

and I've tried 'if(isset($_POST['submit']))'

I also have add a value to my input...

but still the same.. the data is not inserted into the database when i click it..

but when I refreshed the page once, empty data will be inserted into the database twice.

Why is that?

redarrow · April 4, 2009

post you current project please.

all off it .....

sicKo · April 4, 2009

this the full code

<TABLE width="100&percnt;" border="0">
            <TBODY><TR>
              <TD><INPUT type="hidden" name="action" value="process"><TABLE width="100&percnt;" border="0">
              <TBODY><TR>
              <TD width="100&percnt;" class="pageHeading" style="padding-bottom:100px"></TD>
              </TR>
              <TR>
                <TD><TABLE width="100&percnt;" id="loginForm" border="0" style="border-top-color: rgb(204, 204, 204); border-right-color: rgb(204, 204, 204); border-bottom-color: rgb(204, 204, 204); border-left-color: rgb(204, 204, 204); border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; display: none; ">
                  <TBODY><TR>
          <TD width="100&percnt;"><FORM name="login" action="login.php?action=process_login" method="post"><TABLE width="100&percnt;" border="0">
                    <TBODY><TR>
                      <TD colspan="3" class="subHeader">Registered Customers - Login</TD>
                    </TR>
                                        <TR>
                      <TD colspan="3" class="loginText"><UL>
                          <LI class="loginText">Login to your account by entering your username and password below.</LI>
                          <LI class="loginText"><A href="password_forgotten.php">Forgot your password? Click here</A></LI>
                      </UL></TD>
                    </TR>
                    <TR>
                      <TD width="25&percnt;" class="loginTextTags">E-Mail Address:</TD>
                      <TD width="30&percnt;"><INPUT type="text" name="email_address"></TD>
                      <TD width="45&percnt;"> </TD>
                    </TR>
                    <TR>
                      <TD class="loginTextTags">Password:</TD>
                      <TD><INPUT type="password" name="password" maxlength="40"></TD>
                      <TD> </TD>
                    </TR>
                    <TR>
                      <TD> </TD>
                      <TD><INPUT type="image" src="./shoes_files/button_login.gif" border="0" alt="Sign In" title=" Sign In "></TD>
                      <TD> </TD>
                    </TR>
                  </TBODY></TABLE>
                  </FORM></TD>
                  </TR></TBODY></TABLE></TD>
              </TR>
                
              <TR><TD>
              <TABLE style="border: 1px solid #CCCCCC; padding: 0px" width="100&percnt;">
              <TBODY><TR><TD colspan="3" class="subHeader"><DIV id="login_header">Returning Customer</DIV></TD></TR>              
                <TR>
                <TD class="main"><DIV id="login_text" class="loginText">Login to your account by entering your username and password.</DIV></TD>
                <TD class="loginText" align="right" style="padding: 8px;">
                
                </TD>
                </TR>
                </TBODY></TABLE>
                </TD></TR>
			<FORM name="create_account" action="login.php" method="post" > 
		    <TR>                 <TD><TABLE width="100&percnt;" border="0" style="border-top-color: rgb(204, 204, 204); border-right-color: rgb(204, 204, 204); border-bottom-color: rgb(204, 204, 204); border-left-color: rgb(204, 204, 204); border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; " id="newCustomer">
                    <TBODY><TR>
                      <TD colspan="2" class="subHeader">New Customer</TD>
                    </TR>
                                        <TR>
                      <TD colspan="2"><UL>
                          <LI class="loginText">Please complete the form below with your billing address</LI>
                          <LI class="loginText">You will be able to enter a different delivery address on the next page</LI>
                          <LI class="loginText">Compulsory fields are marked with a <FONT color="#ff0000"><STRONG>*</STRONG></FONT></LI>
                      </UL></TD>
                    </TR>
                                      <TR>
                    <TD class="loginTextTags">First Name:</TD>
                    <TD class="loginTextTags"><INPUT type="text" name="firstname"> <SPAN class="inputRequirement">*</SPAN></TD>
                  </TR>
                  <TR>
                    <TD class="loginTextTags">Last Name:</TD>
                    <TD class="loginTextTags"><INPUT type="text" name="lastname"> <SPAN class="inputRequirement">*</SPAN></TD>
                  </TR>
                                  <TR>
                    <TD class="loginTextTags">E-Mail Address:</TD>
                    <TD class="loginTextTags"><INPUT type="text" name="email_address"> <SPAN class="inputRequirement">*</SPAN></TD>
                  </TR>
                        <TR>
                      <TD colspan="2" class="subHeader">Your Address</TD>
                    </TR>
                      <TR>
                        <TD class="loginTextTags">Street Address:</TD>
                        <TD class="loginTextTags"><INPUT type="text" name="street_address"> <SPAN class="inputRequirement">*</SPAN></TD>
                      </TR>
                                  <TR>
                    <TD class="loginTextTags">City:</TD>
                    <TD class="loginTextTags"><INPUT type="text" name="city"> <SPAN class="inputRequirement">*</SPAN></TD>
                  </TR>
                             <TR>
                  <TD class="loginTextTags">Post Code:</TD>
                  <TD class="loginTextTags"><INPUT type="text" name="postcode"> <SPAN class="inputRequirement">*</SPAN></TD>
                  </TR>
                  <TR>
                    <TD class="loginTextTags">Country:</TD>
                    <TD class="loginTextTags"><SELECT name="country"><OPTION value="">Please Select</OPTION><OPTION value="1">Afghanistan</OPTION><OPTION value="2">Albania</OPTION><OPTION value="3">Algeria</OPTION><OPTION value="4">American Samoa</OPTION><OPTION value="5">Andorra</OPTION><OPTION value="6">Angola</OPTION><OPTION value="7">Anguilla</OPTION><OPTION value="8">Antarctica</OPTION><OPTION value="9">Antigua and Barbuda</OPTION><OPTION value="10">Argentina</OPTION><OPTION value="11">Armenia</OPTION><OPTION value="12">Aruba</OPTION><OPTION value="13">Australia</OPTION><OPTION value="14">Austria</OPTION><OPTION value="15">Azerbaijan</OPTION><OPTION value="16">Bahamas</OPTION><OPTION value="17">Bahrain</OPTION><OPTION value="18">Bangladesh</OPTION><OPTION value="19">Barbados</OPTION><OPTION value="20">Belarus</OPTION><OPTION value="21">Belgium</OPTION><OPTION value="22">Belize</OPTION><OPTION value="23">Benin</OPTION><OPTION value="24">Bermuda</OPTION><OPTION value="25">Bhutan</OPTION><OPTION value="26">Bolivia</OPTION><OPTION value="27">Bosnia and Herzegowina</OPTION><OPTION value="28">Botswana</OPTION><OPTION value="29">Bouvet Island</OPTION><OPTION value="30">Brazil</OPTION><OPTION value="31">British Indian Ocean Territory</OPTION><OPTION value="32">Brunei Darussalam</OPTION><OPTION value="33">Bulgaria</OPTION><OPTION value="34">Burkina Faso</OPTION><OPTION value="35">Burundi</OPTION><OPTION value="36">Cambodia</OPTION><OPTION value="37">Cameroon</OPTION><OPTION value="38">Canada</OPTION><OPTION value="39">Cape Verde</OPTION><OPTION value="40">Cayman Islands</OPTION><OPTION value="41">Central African Republic</OPTION><OPTION value="42">Chad</OPTION><OPTION value="43">Chile</OPTION><OPTION value="44">China</OPTION><OPTION value="45">Christmas Island</OPTION><OPTION value="46">Cocos (Keeling) Islands</OPTION><OPTION value="47">Colombia</OPTION><OPTION value="48">Comoros</OPTION><OPTION value="49">Congo</OPTION><OPTION value="50">Cook Islands</OPTION><OPTION value="51">Costa Rica</OPTION><OPTION value="52">Cote D&#39;Ivoire</OPTION><OPTION value="53">Croatia</OPTION><OPTION value="54">Cuba</OPTION><OPTION value="55">Cyprus</OPTION><OPTION value="56">Czech Republic</OPTION><OPTION value="57">Denmark</OPTION><OPTION value="58">Djibouti</OPTION><OPTION value="59">Dominica</OPTION><OPTION value="60">Dominican Republic</OPTION><OPTION value="61">East Timor</OPTION><OPTION value="62">Ecuador</OPTION><OPTION value="63">Egypt</OPTION><OPTION value="64">El Salvador</OPTION><OPTION value="65">Equatorial Guinea</OPTION><OPTION value="66">Eritrea</OPTION><OPTION value="67">Estonia</OPTION><OPTION value="68">Ethiopia</OPTION><OPTION value="69">Falkland Islands (Malvinas)</OPTION><OPTION value="70">Faroe Islands</OPTION><OPTION value="71">Fiji</OPTION><OPTION value="72">Finland</OPTION><OPTION value="73">France</OPTION><OPTION value="74">France, Metropolitan</OPTION><OPTION value="75">French Guiana</OPTION><OPTION value="76">French Polynesia</OPTION><OPTION value="77">French Southern Territories</OPTION><OPTION value="78">Gabon</OPTION><OPTION value="79">Gambia</OPTION><OPTION value="80">Georgia</OPTION><OPTION value="81">Germany</OPTION><OPTION value="82">Ghana</OPTION><OPTION value="83">Gibraltar</OPTION><OPTION value="84">Greece</OPTION><OPTION value="85">Greenland</OPTION><OPTION value="86">Grenada</OPTION><OPTION value="87">Guadeloupe</OPTION><OPTION value="88">Guam</OPTION><OPTION value="89">Guatemala</OPTION><OPTION value="90">Guinea</OPTION><OPTION value="91">Guinea-bissau</OPTION><OPTION value="92">Guyana</OPTION><OPTION value="93">Haiti</OPTION><OPTION value="94">Heard and Mc Donald Islands</OPTION><OPTION value="95">Honduras</OPTION><OPTION value="96">Hong Kong</OPTION><OPTION value="97">Hungary</OPTION><OPTION value="98">Iceland</OPTION><OPTION value="99">India</OPTION><OPTION value="100">Indonesia</OPTION><OPTION value="101">Iran (Islamic Republic of)</OPTION><OPTION value="102">Iraq</OPTION><OPTION value="103">Ireland</OPTION><OPTION value="104">Israel</OPTION><OPTION value="105">Italy</OPTION><OPTION value="106">Jamaica</OPTION><OPTION value="107">Japan</OPTION><OPTION value="108">Jordan</OPTION><OPTION value="109">Kazakhstan</OPTION><OPTION value="110">Kenya</OPTION><OPTION value="111">Kiribati</OPTION><OPTION value="112">Korea, Democratic People&#39;s Republic of</OPTION><OPTION value="113">Korea, Republic of</OPTION><OPTION value="114">Kuwait</OPTION><OPTION value="115">Kyrgyzstan</OPTION><OPTION value="116">Lao People&#39;s Democratic Republic</OPTION><OPTION value="117">Latvia</OPTION><OPTION value="118">Lebanon</OPTION><OPTION value="119">Lesotho</OPTION><OPTION value="120">Liberia</OPTION><OPTION value="121">Libyan Arab Jamahiriya</OPTION><OPTION value="122">Liechtenstein</OPTION><OPTION value="123">Lithuania</OPTION><OPTION value="124">Luxembourg</OPTION><OPTION value="125">Macau</OPTION><OPTION value="126">Macedonia, The Former Yugoslav Republic of</OPTION><OPTION value="127">Madagascar</OPTION><OPTION value="128">Malawi</OPTION><OPTION value="129">Malaysia</OPTION><OPTION value="130">Maldives</OPTION><OPTION value="131">Mali</OPTION><OPTION value="132">Malta</OPTION><OPTION value="133">Marshall Islands</OPTION><OPTION value="134">Martinique</OPTION><OPTION value="135">Mauritania</OPTION><OPTION value="136">Mauritius</OPTION><OPTION value="137">Mayotte</OPTION><OPTION value="138">Mexico</OPTION><OPTION value="139">Micronesia, Federated States of</OPTION><OPTION value="140">Moldova, Republic of</OPTION><OPTION value="141">Monaco</OPTION><OPTION value="142">Mongolia</OPTION><OPTION value="143">Montserrat</OPTION><OPTION value="144">Morocco</OPTION><OPTION value="145">Mozambique</OPTION><OPTION value="146">Myanmar</OPTION><OPTION value="147">Namibia</OPTION><OPTION value="148">Nauru</OPTION><OPTION value="149">Nepal</OPTION><OPTION value="150">Netherlands</OPTION><OPTION value="151">Netherlands Antilles</OPTION><OPTION value="152">New Caledonia</OPTION><OPTION value="153">New Zealand</OPTION><OPTION value="154">Nicaragua</OPTION><OPTION value="155">Niger</OPTION><OPTION value="156">Nigeria</OPTION><OPTION value="157">Niue</OPTION><OPTION value="158">Norfolk Island</OPTION><OPTION value="159">Northern Mariana Islands</OPTION><OPTION value="160">Norway</OPTION><OPTION value="161">Oman</OPTION><OPTION value="162">Pakistan</OPTION><OPTION value="163">Palau</OPTION><OPTION value="164">Panama</OPTION><OPTION value="165">Papua New Guinea</OPTION><OPTION value="166">Paraguay</OPTION><OPTION value="167">Peru</OPTION><OPTION value="168">Philippines</OPTION><OPTION value="169">Pitcairn</OPTION><OPTION value="170">Poland</OPTION><OPTION value="171">Portugal</OPTION><OPTION value="172">Puerto Rico</OPTION><OPTION value="173">Qatar</OPTION><OPTION value="174">Reunion</OPTION><OPTION value="175">Romania</OPTION><OPTION value="176">Russian Federation</OPTION><OPTION value="177">Rwanda</OPTION><OPTION value="178">Saint Kitts and Nevis</OPTION><OPTION value="179">Saint Lucia</OPTION><OPTION value="180">Saint Vincent and the Grenadines</OPTION><OPTION value="181">Samoa</OPTION><OPTION value="182">San Marino</OPTION><OPTION value="183">Sao Tome and Principe</OPTION><OPTION value="184">Saudi Arabia</OPTION><OPTION value="185">Senegal</OPTION><OPTION value="186">Seychelles</OPTION><OPTION value="187">Sierra Leone</OPTION><OPTION value="188">Singapore</OPTION><OPTION value="189">Slovakia (Slovak Republic)</OPTION><OPTION value="190">Slovenia</OPTION><OPTION value="191">Solomon Islands</OPTION><OPTION value="192">Somalia</OPTION><OPTION value="193">South Africa</OPTION><OPTION value="194">South Georgia and the South Sandwich Islands</OPTION><OPTION value="195">Spain</OPTION><OPTION value="196">Sri Lanka</OPTION><OPTION value="197">St. Helena</OPTION><OPTION value="198">St. Pierre and Miquelon</OPTION><OPTION value="199">Sudan</OPTION><OPTION value="200">Suriname</OPTION><OPTION value="201">Svalbard and Jan Mayen Islands</OPTION><OPTION value="202">Swaziland</OPTION><OPTION value="203">Sweden</OPTION><OPTION value="204">Switzerland</OPTION><OPTION value="205">Syrian Arab Republic</OPTION><OPTION value="206">Taiwan</OPTION><OPTION value="207">Tajikistan</OPTION><OPTION value="208">Tanzania, United Republic of</OPTION><OPTION value="209">Thailand</OPTION><OPTION value="210">Togo</OPTION><OPTION value="211">Tokelau</OPTION><OPTION value="212">Tonga</OPTION><OPTION value="213">Trinidad and Tobago</OPTION><OPTION value="214">Tunisia</OPTION><OPTION value="215">Turkey</OPTION><OPTION value="216">Turkmenistan</OPTION><OPTION value="217">Turks and Caicos Islands</OPTION><OPTION value="218">Tuvalu</OPTION><OPTION value="219">Uganda</OPTION><OPTION value="220">Ukraine</OPTION><OPTION value="221">United Arab Emirates</OPTION><OPTION value="222" selected="">United Kingdom</OPTION><OPTION value="223">United States</OPTION><OPTION value="224">United States Minor Outlying Islands</OPTION><OPTION value="225">Uruguay</OPTION><OPTION value="226">Uzbekistan</OPTION><OPTION value="227">Vanuatu</OPTION><OPTION value="228">Vatican City State (Holy See)</OPTION><OPTION value="229">Venezuela</OPTION><OPTION value="230">Viet Nam</OPTION><OPTION value="231">Virgin Islands (British)</OPTION><OPTION value="232">Virgin Islands (U.S.)</OPTION><OPTION value="233">Wallis and Futuna Islands</OPTION><OPTION value="234">Western Sahara</OPTION><OPTION value="235">Yemen</OPTION><OPTION value="236">Yugoslavia</OPTION><OPTION value="237">Zaire</OPTION><OPTION value="238">Zambia</OPTION><OPTION value="239">Zimbabwe</OPTION></SELECT> <SPAN class="inputRequirement">*</SPAN></TD>
                  </TR>
               <TR>
                <TD class="loginTextTags">Telephone Number:</TD>
                <TD class="loginTextTags"><INPUT type="text" name="telephone"> <SPAN class="inputRequirement">*</SPAN></TD>
              </TR>
               <TR>
                <TD class="loginTextTags">Mobile Number:</TD>
                <TD class="loginTextTags"><INPUT type="text" name="fax"> </TD>
              </TR>
                    <TR>
                      
                    </TR>
                    <TR>
                      
                    </TR>
                      <TR>
                        <TD class="loginTextTags">Password:</TD>
                        <TD class="loginTextTags"><INPUT type="password" name="password" maxlength="40"> </TD>
                      </TR>
                      <TR>
                        <TD class="loginTextTags">Password Confirmation:</TD>
                        <TD class="loginTextTags"><INPUT type="password" name="confirmation" maxlength="40"> </TD>
                      </TR>
                    <TR>
                      <TD colspan="2" class="subHeader">Account Options</TD>
                    </TR>
                      <TR>
                        <TD class="loginTextTags">Newsletter:</TD>
                        <TD class="loginTextTags"><INPUT type="checkbox" name="newsletter" value="1"> </TD>
                      </TR>
                              
                              <TR>
                                <TD class="main loginTextTags">How did you hear about us?</TD>
                                <TD class="main"><SELECT name="method_id"><OPTION value="1">Search Engine</OPTION><OPTION value="2">Word Of Mouth</OPTION><OPTION value="3">Flyer</OPTION><OPTION value="5">Other</OPTION><OPTION value="6">Tell a Friend</OPTION></SELECT></TD>
                              </TR>
                                     <TR>
                        <TD><IMG src="./shoes_files/pixel_trans2.gif" border="0" alt="" width="10" height="1"></TD>
                        <TD align="right" style="padding:5px;"><INPUT type="image" src="./shoes_files/button_new_customer.gif" border="0" alt="Continue" title=" Continue " name = "newcust" value='image'></TD>
                  </TR>
                  </TBODY></TABLE></TD>
                
			</TR>
              </TBODY></TABLE></TD>
            </TR></TBODY></TABLE>

		</form>
<?php 
// Connect to the database 
$con = mysql_connect("localhost", "root"); 
mysql_select_db("project",$con);



if($_POST['newcust'] = 'image')
{

$sql = "INSERT INTO member values ('null','".$_POST['firstname']."','".$_POST['lastname']."','".$_POST['email_address']."','".$_POST['street_address']."','".$_POST['city']."','".$_POST['postcode']."','".$_POST['country']."','".$_POST['telephone']."','".$_POST['fax']."','".$_POST['password']."','".$_POST['method_id']."')";

$result = mysql_query($sql,$con);

if(mysql_query($sql,$con))
{
echo "data saved";
}
else
{
echo "error data : ".mysql_error();
}

}
?>

Fruct0se · April 4, 2009

Added == to your if statement.

And if the 'newcust' value is not passed for testing purposes check what the value is, echo post at end:

<?php
// Connect to the database 
$con = mysql_connect("localhost", "root"); 
mysql_select_db("project",$con);

if($_POST['newcust'] == 'image') //need == here
{

$sql = "INSERT INTO member values ('null','".$_POST['firstname']."','".$_POST['lastname']."','".$_POST['email_address']."','".$_POST['street_address']."','".$_POST['city']."','".$_POST['postcode']."','".$_POST['country']."','".$_POST['telephone']."','".$_POST['fax']."','".$_POST['password']."','".$_POST['method_id']."')";

$result = mysql_query($sql,$con);

if(mysql_query($sql,$con))
{
echo "data saved";
}
else
{
echo "error data : ".mysql_error();
}

} else {
echo $_POST['newcust'].' = posted value';
}
?>

sicKo · April 4, 2009

still not working after i add '=='.. but at least when I refresh the page, empty data was not inserted into the database..

Fruct0se · April 4, 2009

What was the value of your $_POST data after submitting the form? I added the echo line to the bottom of your code.

Fruct0se · April 4, 2009

Try this:

sicKo · April 4, 2009

the code $_POST at the bottom didn't return any value..

Try this:

<INPUT type="image" src="./shoes_files/button_new_customer.gif" border="0" alt="Continue" title=" Continue " name = "newcust" value="image">

This code works.. thank you very much but still have problem though..

When I click the image, data was inserted into the database but was inserted twice...

When I refresh the page, the last data that I enter in the field will automatically inserted into the database as well, twice..

Fruct0se · April 4, 2009

Looks like your running the query twice, once by $result and again in your if statement, try this code:

<?php
// Connect to the database 
$con = mysql_connect("localhost", "root"); 
mysql_select_db("project",$con);

if($_POST['newcust'] == 'image') //need == here
{

$sql = "INSERT INTO member values ('null','".$_POST['firstname']."','".$_POST['lastname']."','".$_POST['email_address']."','".$_POST['street_address']."','".$_POST['city']."','".$_POST['postcode']."','".$_POST['country']."','".$_POST['telephone']."','".$_POST['fax']."','".$_POST['password']."','".$_POST['method_id']."')";

$result = mysql_query($sql,$con);

if($result)
{
echo "data saved";
}
else
{
echo "error data : ".mysql_error();
}
?>

sicKo · April 4, 2009

Looks like your running the query twice, once by $result and again in your if statement, try this code:

<?php
// Connect to the database 
$con = mysql_connect("localhost", "root"); 
mysql_select_db("project",$con);

if($_POST['newcust'] == 'image') //need == here
{

$sql = "INSERT INTO member values ('null','".$_POST['firstname']."','".$_POST['lastname']."','".$_POST['email_address']."','".$_POST['street_address']."','".$_POST['city']."','".$_POST['postcode']."','".$_POST['country']."','".$_POST['telephone']."','".$_POST['fax']."','".$_POST['password']."','".$_POST['method_id']."')";

$result = mysql_query($sql,$con);

if($result)
{
echo "data saved";
}
else
{
echo "error data : ".mysql_error();
}
?>

Yeah... it works... u're rite.. stupid mistake, huh? .. Thank you again but the 'refresh problem' still occured..

Everytime I refresh the page, the last data that i enter in the field is inserted into the database..

Fruct0se · April 4, 2009

You may want to check for duplicate entries before adding to the database, so run a query that searches for the data submitted, if it does not exist then add it. The code you have written will add data every time the form is refreshed because it does not care if the same data already exists.

sicKo · April 4, 2009

I thought when we put the 'if' statement (if($_POST['newcust'] == 'image')), the code will only run if we click the button.. if not , the code shouldn't run...

Am I right?

Anyway, thank you very much for ur help n time

Fruct0se · April 4, 2009

Yes that is true, however when you refresh a page all of the posted data is sent again so it looks like the button was clicked again.

sicKo · April 4, 2009

Thank you very much.. Problems solved..

Sign In

if..else code didn't function as it need to

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information