I have one question! How can i check form fields against the database and then display an error! Please help me for example go to mycsmi.org There is a form on the index.php page .... a user submits the info to the database but what if there is a duplicate .... how would i display to the user that the information is already provided!
Thanks and Have a Blessed Day!
Jump to PostQuery the database with the information you are going to insert. If a record exists, do not do the insert and specify a 'duplicate message', otherwise continue and make an insert database call.
Jump to PostWill be glad to help, please post the code that you have for now and we can go off of that.
Query the database with the information you are going to insert. If a record exists, do not do the insert and specify a 'duplicate message', otherwise continue and make an insert database call.
Query the database with the information you are going to insert. If a record exists, do not do the insert and specify a 'duplicate message', otherwise continue and make an insert database call.
Please explain that to me cause im a beginner with MySQL/PHP 5
Will be glad to help, please post the code that you have for now and we can go off of that.
<!-- The contact form starts from here-->
<?php $error = ''; // error message
$fname = ''; // sender's name
$lname = ''; // sender's name
$email = ''; // sender's email address
$myspace = ''; // myspace
$client = ''; // IM Client
$screenname = ''; // IM screen name
$service = ''; // service
$phone = ''; // address
$address = ''; // address
$city = ''; // address
$state = ''; // address
$country = ''; // address
$zip = ''; // zip code
$tos = ''; // agree to terms of service
if(isset($_POST['send']))
{$fname = $_POST['fname'];
$lname = $_POST['lname'];
$email = $_POST['email'];
$myspace = $_POST['myspace'];
$client = $_POST['client'];
$screenname = $_POST['screenname'];
$service = $_POST['service'];
$phone = $_POST['phone'];
$address = $_POST['address'];
$city = $_POST['city'];
$state = $_POST['state'];
$country = $_POST['country'];
$zip = $_POST['zip'];
$tos = $_POST['tos'];
$ip = $_POST['ip'];
if(trim($fname) == '')
{
$error = '<div class="errormsg">Please enter your first name!</div>';
}
if(trim($lname) == '')
{
$error = '<div class="errormsg">Please enter your last name!</div>';
}
else if(trim($email) == '')
{
$error = '<div class="errormsg">Please enter your email address!</div>';
}
else if(!isEmail($email))
{
$error = '<div class="errormsg">Invalid Email address, Try Again!</div>';
}
if(trim($myspace) == '')
{
$error = '<div class="errormsg">Please enter you MySpace URL</div>';
}
if(trim($client) == '')
{
$error = '<div class="errormsg">Please select an IM Client!</div>';
}
if(trim($screenname) == '')
{
$error = '<div class="errormsg">Please enter your IM screen name!</div>';
}
if(trim($service) == '')
{
$error = '<div class="errormsg">Please select a Service!</div>';
}
if(trim($address) == '')
{
$error = '<div class="errormsg">Please enter your address!</div>';
}
if(trim($phone) == '')
{
$error = '<div class="errormsg">Please enter your Phone Number (USA EX: 19996382764)</div>';
}
if(trim($zip) == '')
{
$error = '<div class="errormsg">Please enter your zip code!</div>';
}
if(trim($tos) == '')
{
$error = '<div class="errormsg">Please agree to MDT(CSMI) Terms of Use/Privacy Policy!</div>';
}
if($error == '')
{
if(get_magic_quotes_gpc())
{
$message = stripslashes($message);
}
// the email will be sent here
// make sure to change this to be your e-mail
$to = "MDT@mycsmi.org";
// the email subject
// '[Contact Form] :' will appear automatically in the subject.
// You can change it as you want
$subject = 'MDT(CHRISTSPACE) Service Request!';
// the mail message ( add any additional information if you want )
$msg = "From : $fname $lname \r\nAccount Number: $id\r\nE-Mail : $email \r\nMySpace : $myspace \r\nIM 24/7 : $client | $screenname \r\nMinistry Service : $service \r\nPhone: $phone \r\nAddress : $address $city, $state $zip, $country \r\nAgree To MDT(CSMI) TOS : $tos";
mail($to, $subject, $msg, "From: $email\r\nReply-To: $email\r\nReturn-Path: $email\r\n");
?>
<!-- Message sent! (change the text below as you wish)-->
<div style="text-align:center;"><table width="500" height="105" border="0">
<tr><td height="101"><h5 align="center" class="style38 style8 style8 style8 style55">Welcome to MDT International </h5>
<h5 align="center" class="style1 style8 style8 style8">Thank you <?=$fname;?> <?=$lname;?> , we have recieved your <br>
Service Request Application!<br>
<br>WE WILL RESPOND WITHIN 15 HOURS! </h5></td>
</tr></table></div><p><!--End Message Sent-->
<?php
}
}
if(!isset($_POST['send']) || $error != '')
{
?></p>
<table width="516" border="0" align="center">
<tr><td><div align="center" class="style49"><?=$error;?></div></td> </tr></table>
<form method="post" name="contFrm" id="contFrm" onSubmit="return jcap();">
<table width="516" height="376" border="0" align="center">
<tr>
<td width="145" height="36"><div class="float-left"><strong><span class="required">*</span> First/Last Name:</strong></div></td>
<td width="384"><input name="fname" type="text" class="box" id="fname" size="23" value="<?=$fname;?>" />
<input name="lname" type="text" class="box" id="lname" size="23" value="<?=$lname;?>" /></td></tr>
<tr><td width="145" height="36"><div class="float-left"><strong><span class="required">*</span> Email: </strong></div></td>
<td><input name="email" type="text" class="box" id="email" size="30" value="<?=$email;?>" /></td></tr>
<tr><td width="145" height="36"><div class="float-left"><strong><span class="required">*</span> MySpace URL: </strong></div></td>
<td>myspace.com/<input name="myspace" type="text" class="box" id="myspace" size="30" value="<?=$myspace;?>" />
<a href="extras/LifePoint/viewtopic.php?f=31&t=11">WANT 1 </a></td>
</tr>
<tr><td width="145" height="36"><div class="float-left"><strong><span class="required">* </span>IM 24/7 : </strong></div></td>
<td><select name="client" id="client">
<option value="AOL AIM" selected>AOL AIM</option>
<option value="Google Talk">Google Talk</option>
<option value="MSN Live">MSN Live</option>
<option value="MySpace IM">MySpace IM</option>
<option value="Yahoo! IM">Yahoo! IM</option>
</select>
|
<input name="screenname" type="text" class="box" id="screenname" size="20" value="<?=$screenname;?>" /></td></tr>
<tr><td height="34"><div class="float-left"><strong><span class="required">*</span> Ministry Service: </strong></div></td>
<td><select name="service" id="service">
<option value="MDT(CSMI)" selected>MDT(CHRISTSPACE)</option>
<option value="IM 24/7">IM 24/7</option>
<option value="NSR">NO SHAME</option>
<option value="FICA(GOTCHRIST)">FICAMAIL</option>
<option value="MINISTRYKONNECT">MINISTRYKONNECT</option>
<option value="T3 STREET">T3 STREET</option>
<option value="MYSPACE">MYSPACE</option>
<option value="VOLUNTEER">MDT(CSMI) VOLUNTEER</option>
</select>
<a href="extras/LifePoint/">MORE DETAILS ... </a></td></tr>
<tr><td width="145" height="36"><div class="float-left"><strong><span class="required">*</span> Phone Number: </strong></div></td>
<td><input name="phone" type="text" class="box" id="phone" value="<?=$phone;?>" size="10" maxlength="10" />
<span class="style46"><strong><a href="services/MKI/">INTERNATIONAL USERS</a> </strong></span></td>
</tr>
<tr><td height="36" valign="top"><div class="float-left"><strong><span class="required">*</span> Address: </strong></div></td>
<td><input name="address" type="text" class="box" id="address" size="30" value="<?=$address;?>" /></td></tr>
<tr><td height="36" valign="top"><div class="float-left"><strong><span class="required">*</span> City, State: </strong></div></td>
<td><p><input name="city" type="text" class="box" id="city" size="20" value="<?=$city;?>" />, <span class="right">
<select class="other" name="state" id="state" onBlur="validate(this,'Required')">
<option>PR</option>
<option>GU</option>
<option>USVI</option>
<option>NMI</option>
<option>--</option>
<option>AL</option>
<option>AK</option>
<option>AR</option>
<option>AZ</option>
<option>CA</option>
<option>CO</option>
<option>CT</option>
<option>DC</option>
<option>DE</option>
<option>FL</option>
<option>GA</option>
<option>HI</option>
<option>ID</option>
<option>IL</option>
<option>IN</option>
<option>IA</option>
<option>KS</option>
<option>KY</option>
<option>LA</option>
<option>ME</option>
<option>MD</option>
<option>MA</option>
<option>MI</option>
<option>MN</option>
<option>MS</option>
<option>MO</option>
<option>MT</option>
<option>NE</option>
<option>NV</option>
<option>NH</option>
<option>NJ</option>
<option>NM</option>
<option>NY</option>
<option>NC</option>
<option>ND</option>
<option>OH</option>
<option>OK</option>
<option>OR</option>
<option>PA</option>
<option>RI</option>
<option>SC</option>
<option>SD</option>
<option>TN</option>
<option>TX</option>
<option>UT</option>
<option>VT</option>
<option>VA</option>
<option>WA</option>
<option>WV</option>
<option>WI</option>
<option>WY</option>
</select></span></td></tr>
<tr><td width="145" height="36" valign="top"><div class="float-left"><strong><span class="required">*</span> Country, ZIP Code: </strong></div></td><td><p><span class="right">
<select class="other" name="country" id="country" onBlur="validate(this,'Required')">
<option selected="selected">United States</option>
<option>Abkhazia</option>
<option>Afghanistan</option>
<option>United Kingdom Akrotiri and Dhekelia</option>
<option>Aland</option>
<option>Albania</option>
<option>Algeria</option>
<option>American Samoa</option>
<option>Andorra</option>
<option>Angola</option>
<option>Anguilla</option>
<option>Antigua and Barbuda</option>
<option>Argentina Argentina</option>
<option>Armenia</option>
<option>Aruba</option>
<option>United Kingdom Ascension Island</option>
<option>Australia</option>
<option>Austria</option>
<option>Azerbaijan</option>
<option>The Bahamas</option>
<option>Bahrain</option>
<option>Bangladesh</option>
<option>Barbados</option>
<option>Belarus</option>
<option>Belgium</option>
<option>Belize</option>
<option>Benin</option>
<option>Bermuda</option>
<option>Bhutan</option>
<option>Bolivia</option>
<option>Bosnia and Herzegovina</option>
<option>Botswana</option>
<option>Brazil</option>
<option>Brunei</option>
<option>Bulgaria</option>
<option>Burkina Faso</option>
<option>Burundi</option>
<option>Cambodia</option>
<option>Cameroon</option>
<option>Canada</option>
<option>Cape Verde</option>
<option>Cayman Islands</option>
<option>Central African Republic</option>
<option>Chad</option>
<option>Chile</option>
<option>People's Republic of China</option>
<option>Republic of China</option>
<option>Christmas Island</option>
<option>Cocos (Keeling) Islands</option>
<option>Colombia</option>
<option>Comoros</option>
<option>Congo</option>
<option>Cook Islands</option>
<option>Costa Rica</option>
<option>C�te d'Ivoire</option>
<option>Croatia</option>
<option>Cuba</option>
<option>Cyprus</option>
<option>Czech Republic</option>
<option>Denmark</option>
<option>Djibouti</option>
<option>Dominica</option>
<option>Dominican Republic</option>
<option>Ecuador</option>
<option>Egypt</option>
<option>El Salvador</option>
<option>Equatorial Guinea</option>
<option>Eritrea</option>
<option>Estonia</option>
<option>Ethiopia</option>
<option>Falkland Islands</option>
<option>Faroe Islands</option>
<option>Fiji</option>
<option>Finland</option>
<option>France</option>
<option>French Polynesia</option>
<option>Gabon</option>
<option>The Gambia</option>
<option>Georgia</option>
<option>Germany</option>
<option>Ghana</option>
<option>Gibraltar</option>
<option>Greece</option>
<option>Greenland</option>
<option>Grenada</option>
<option>Guam</option>
<option>Guatemala</option>
<option>Guernsey</option>
<option>Guinea</option>
<option>Guinea-Bissau</option>
<option>Guyana Guyana</option>
<option>Haiti Haiti</option>
<option>Honduras</option>
<option>Hong Kong</option>
<option>Hungary</option>
<option>Iceland</option>
<option>India</option>
<option>Indonesia</option>
<option>Iran</option>
<option>Iraq</option>
<option>Ireland</option>
<option>Israel</option>
<option>Italy</option>
<option>Jamaica</option>
<option>Japan</option>
<option>Jersey</option>
<option>Jordan</option>
<option>Kazakhstan</option>
<option>Kenya</option>
<option>Kiribati</option>
<option>North Korea</option>
<option>South Korea</option>
<option>Kosovo</option>
<option>Kuwait</option>
<option>Kyrgyzstan</option>
<option>Laos</option>
<option>Latvia</option>
<option>Lebanon</option>
<option>Lesotho</option>
<option>Liberia</option>
<option>Libya</option>
<option>Liechtenstein</option>
<option>Lithuania</option>
<option>Luxembourg</option>
<option>Macau</option>
<option>Macedonia</option>
<option>Madagascar</option>
<option>Malawi</option>
<option>Malaysia</option>
<option>Maldives</option>
<option>Mali</option>
<option>Malta</option>
<option>Marshall Islands</option>
<option>Mauritania</option>
<option>Mauritius</option>
<option>Mayotte</option>
<option>Mexico</option>
<option>Micronesia</option>
<option>Moldova</option>
<option>Monaco</option>
<option>Mongolia</option>
<option>Montenegro</option>
<option>Montserrat</option>
<option>Morocco</option>
<option>Mozambique</option>
<option>Myanmar</option>
<option>Nagorno-Karabakh</option>
<option>Namibia</option>
<option>Nauru</option>
<option>Nepal</option>
<option>Netherlands</option>
<option>Netherlands Antilles</option>
<option>New Caledonia</option>
<option>New Zealand</option>
<option>Nicaragua</option>
<option>Niger</option>
<option>Nigeria</option>
<option>Niue</option>
<option>Norfolk Island</option>
<option>Turkish Republic of Northern Cyprus</option>
<option>Northern Mariana</option>
<option>Norway</option>
<option>Pakistan</option>
<option>Palau</option>
<option>Palestine</option>
<option>Panama</option>
<option>Papua New Guinea</option>
<option>Paraguay</option>
<option>Peru</option>
<option>Philippines</option>
<option>Pitcairn Islands</option>
<option>Poland</option>
<option>Portugal</option>
<option>Transnistria Pridnestrovie</option>
<option>Puerto Rico</option>
<option>Qatar</option>
<option>Romania</option>
<option>Russia</option>
<option>Rwanda</option>
<option>Saint Barthelemy</option>
<option>Saint Helena</option>
<option>Saint Kitts and Nevis</option>
<option>Saint Lucia</option>
<option>Saint Martin</option>
<option>Saint Pierre and Miquelon</option>
<option>Saint Vincent and the Grenadines</option>
<option>Samoa</option>
<option>San Marino</option>
<option>S�o Tom� and Pr�ncipe</option>
<option>Saudi Arabia</option>
<option>Senegal</option>
<option>Serbia</option>
<option>Seychelles</option>
<option>Sierra Leone</option>
<option>Singapore</option>
<option>Slovakia</option>
<option>Slovenia</option>
<option>Solomon Islands</option>
<option>Somalia</option>
<option>Somaliland</option>
<option>South Africa</option>
<option>South Ossetia</option>
<option>Spain</option>
<option>Sri Lanka</option>
<option>Sudan</option>
<option>Suriname</option>
<option>Svalbard</option>
<option>Swaziland</option>
<option>Sweden</option>
<option>Switzerland</option>
<option>Syria</option>
<option>Tajikistan</option>
<option>Tanzania</option>
<option>Thailand</option>
<option>Timor-Leste</option>
<option>Togo</option>
<option>Tokelau</option>
<option>Tonga</option>
<option>Trinidad and Tobago</option>
<option>Tristan da Cunha</option>
<option>Tunisia</option>
<option>Turkey</option>
<option>Turkmenistan</option>
<option>Turks and Caicos Islands</option>
<option>Tuvalu</option>
<option>Uganda</option>
<option>Ukraine</option>
<option>United Arab Emirates</option>
<option>United Kingdom</option>
<option>Uruguay</option>
<option>Uzbekistan</option>
<option>Vanuatu</option>
<option>Vatican City</option>
<option>Venezuela</option>
<option>Vietnam</option>
<option>British Virgin Islands</option>
<option>US Virgin Islands</option>
<option>Wallis and Futuna</option>
<option>Western Sahara</option>
<option>Yemen</option>
<option>Zambia</option>
<option>Zimbabwe</option>
</select>
</span>
<input name="zip" type="text" class="box" id="zip" value="<?=$zip?>" size="5" maxlength="5" /></td></tr>
<tr>
<td height="32"><div class="float-left"><strong><span class="required">*</span> Agree to TOS: </strong></div></td>
<td><label>
<input name="tos" type="checkbox" id="tos" value="Y">
<span class="style46"><strong>YES, I ABIDE BY THE MDT(CSMI) TERMS </strong></span></label></td>
</tr></table>
<input name="send" type="submit" class="button" id="send" value="" onClick="return checkForm();" />
<?php
} else {
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$email = $_POST['email'];
$myspace = $_POST['myspace'];
$client = $_POST['client'];
$screenname = $_POST['screenname'];
$service = $_POST['service'];
$phone = $_POST['phone'];
$address = $_POST['address'];
$city = $_POST['city'];
$state = $_POST['state'];
$country = $_POST['country'];
$zip = $_POST['zip'];
$tos = $_POST['tos'];
$ip = $_POST['ip'];
mysql_query("INSERT INTO `MDT(CSMI)`
(fname, lname, email, myspace, client, screenname, service, phone, address, city, state, country, zip, tos) VALUES ('$fname','$lname','$email','$myspace','$client','$screenname','$service','$phone','$address','$city','$state','$country','$zip','$tos' ) ");
}
?>
<?php
function isEmail($email)
{
return(preg_match("/^[-_.[:alnum:]]+@((([[:alnum:]]|[[:alnum:]][[:alnum:]-]*[[:alnum:]])\.)+(ad|ae|aero|af|ag|ai|al|am|an|ao|aq|ar|arpa|as|at|au|aw|az|ba|bb|bd|be|bf|bg|bh|bi|biz|bj|bm|bn|bo|br|bs|bt|bv|bw|by|bz|ca|cc|cd|cf|cg|ch|ci|ck|cl|cm|cn|co|com|coop|cr|cs|cu|cv|cx|cy|cz|de|dj|dk|dm|do|dz|ec|edu|ee|eg|eh|er|es|et|eu|fi|fj|fk|fm|fo|fr|ga|gb|gd|ge|gf|gh|gi|gl|gm|gn|gov|gp|gq|gr|gs|gt|gu|gw|gy|hk|hm|hn|hr|ht|hu|id|ie|il|in|info|int|io|iq|ir|is|it|jm|jo|jp|ke|kg|kh|ki|km|kn|kp|kr|kw|ky|kz|la|lb|lc|li|lk|lr|ls|lt|lu|lv|ly|ma|mc|md|mg|mh|mil|mk|ml|mm|mn|mo|mp|mq|mr|ms|mt|mu|museum|mv|mw|mx|my|mz|na|name|nc|ne|net|nf|ng|ni|nl|no|np|nr|nt|nu|nz|om|org|pa|pe|pf|pg|ph|pk|pl|pm|pn|pr|pro|ps|pt|pw|py|qa|re|ro|ru|rw|sa|sb|sc|sd|se|sg|sh|si|sj|sk|sl|sm|sn|so|sr|st|su|sv|sy|sz|tc|td|tf|tg|th|tj|tk|tm|tn|to|tp|tr|tt|tv|tw|tz|ua|ug|uk|um|us|uy|uz|va|vc|ve|vg|vi|vn|vu|wf|ws|ye|yt|yu|za|zm|zw)$|(([0-9][0-9]?|[0-1][0-9][0-9]|[2][0-4][0-9]|[2][5][0-5])\.){3}([0-9][0-9]?|[0-1][0-9][0-9]|[2][0-4][0-9]|[2][5][0-5]))$/i"
,$email));
}
?></p>
In the code from 475-505 is the coding that is used to communicate with MySQL! I hope u can help me better answer my question.
From 35-81 is the PHP that contains the error code is that where i need to validate the form field AGAINST the database!
For example: when i update the form i will add a username field so how would i check to see if the username is taken with PHP/MySQL!
Also, I am in the need to create custom account number beginning with
MDT############ to work with PHP/MySQL. The way i need the account number is:
EXAMPLE: MDT122506154108
1. First 2 digits are the month - 12
2. Digits 3-4 are the day - 25
3. Digits 5-6 are the year - 06
4. Digits 7-8 are the hour - 15
5. Digits 9-10 are the minute - 41
6. Digits 11-12 are the second - 08
So, now its easier to understand my number system, now i need to implement it!
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.