943,516 Members | Top Members by Rank

Web Development > Databases > MySQL > Please seriously HELP ME!
Ad:
  • MySQL Discussion Thread
  • Unsolved
  • Views: 712
  • MySQL RSS
Permalink
Sep 2nd, 2008
0

Please seriously HELP ME!

Expand Post »
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!
Reputation Points: 10
Solved Threads: 0
Newbie Poster
mycsmi is offline Offline
8 posts
since Aug 2008
Permalink
Sep 2nd, 2008
0

Re: Please seriously HELP ME!

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.
Reputation Points: 133
Solved Threads: 141
Veteran Poster
dickersonka is offline Offline
1,162 posts
since Aug 2008
Permalink
Sep 2nd, 2008
0

Re: Please seriously HELP ME!

Click to Expand / Collapse  Quote originally posted by dickersonka ...
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
Reputation Points: 10
Solved Threads: 0
Newbie Poster
mycsmi is offline Offline
8 posts
since Aug 2008
Permalink
Sep 2nd, 2008
0

Re: Please seriously HELP ME!

Will be glad to help, please post the code that you have for now and we can go off of that.
Last edited by dickersonka; Sep 2nd, 2008 at 4:11 pm.
Reputation Points: 133
Solved Threads: 141
Veteran Poster
dickersonka is offline Offline
1,162 posts
since Aug 2008
Permalink
Sep 3rd, 2008
0

Re: Please seriously HELP ME!

  
 
 
MySQL Syntax (Toggle Plain Text)
 
 
  1. <!-- The contact form starts from here-->
  2. <?php $error       = ''; // error message 
  3. $fname        = ''; // sender's name
  4. $lname        = ''; // sender's name
  5. $email       = ''; // sender's email address
  6. $myspace     = ''; // myspace
  7. $client      = ''; // IM Client
  8. $screenname  = ''; // IM screen name
  9. $service     = ''; // service
  10. $phone       = ''; // address
  11. $address        = ''; // address
  12. $city        = ''; // address
  13. $state        = ''; // address
  14. $country        = ''; // address 
  15. $zip       = ''; // zip code
  16. $tos       = ''; // agree to terms of service
  17.  
  18.             if(isset($_POST['send']))
  19.             {$fname     = $_POST['fname'];
  20. 			$lname     = $_POST['lname'];
  21. 			$email    = $_POST['email'];
  22. 			$myspace     = $_POST['myspace'];
  23. 			$client      = $_POST['client'];
  24. 			$screenname  = $_POST['screenname'];
  25. 			$service     = $_POST['service'];
  26. 			$phone     = $_POST['phone'];
  27. 			$address     = $_POST['address'];
  28. 			$city      = $_POST['city'];
  29. 			$state       = $_POST['state'];
  30. 			$country      = $_POST['country'];
  31. 			$zip      = $_POST['zip'];
  32. 			$tos       = $_POST['tos'];
  33. 			$ip       = $_POST['ip'];
  34.  
  35. 				if(trim($fname) == '')
  36.                 {
  37.                     $error = '<div class="errormsg">Please enter your first name!</div>';
  38.                 }
  39. 				if(trim($lname) == '')
  40.                 {
  41.                     $error = '<div class="errormsg">Please enter your last name!</div>';
  42.                 }
  43.             	    else if(trim($email) == '')
  44.                 {
  45.                     $error = '<div class="errormsg">Please enter your email address!</div>';
  46.                 }
  47.                 else if(!isEmail($email))
  48.                 {
  49.                     $error = '<div class="errormsg">Invalid Email address, Try Again!</div>';
  50.                 }
  51. 				if(trim($myspace) == '')
  52.                 {
  53.                     $error = '<div class="errormsg">Please enter you MySpace URL</div>';
  54.                 }
  55. 				if(trim($client) == '')
  56.                 {
  57.                     $error = '<div class="errormsg">Please SELECT an IM Client!</div>';
  58.                 }
  59. 				if(trim($screenname) == '')
  60.                 {
  61.                     $error = '<div class="errormsg">Please enter your IM screen name!</div>';
  62.                 }
  63. 				if(trim($service) == '')
  64.                 {
  65.                     $error = '<div class="errormsg">Please SELECT a Service!</div>';
  66.                 }
  67. 				if(trim($address) == '')
  68.                 {
  69.                     $error = '<div class="errormsg">Please enter your address!</div>';
  70.                 }
  71. 				if(trim($phone) == '')
  72.                 {
  73.                     $error = '<div class="errormsg">Please enter your Phone Number (USA EX: 19996382764)</div>';
  74.                 }
  75. 				if(trim($zip) == '')
  76.                 {
  77.                     $error = '<div class="errormsg">Please enter your zip code!</div>';
  78.                 }
  79. 				if(trim($tos) == '')
  80.                 {
  81.                     $error = '<div class="errormsg">Please agree to MDT(CSMI) Terms of USE/Privacy Policy!</div>';
  82.                 }
  83.                 if($error == '')
  84.                 {
  85.                     if(get_magic_quotes_gpc())
  86.                     {
  87.                         $message = stripslashes($message);
  88.                     }
  89.  
  90.                     // the email will be sent here
  91.                     // make sure to change this to be your e-mail
  92.                     $to      = "MDT@mycsmi.org";
  93.  
  94.                     // the email subject
  95.                     // '[Contact Form] :' will appear automatically in the subject.
  96.                     // You can change it as you want
  97.  
  98.                     $subject = 'MDT(CHRISTSPACE) Service Request!';
  99.  
  100.                     // the mail message ( add any additional information if you want )
  101.                     $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";
  102.  
  103.                     mail($to, $subject, $msg, "From: $email\r\nReply-To: $email\r\nReturn-Path: $email\r\n");
  104.             ?>
  105.                   <!-- Message sent! (change the text below as you wish)-->
  106. <div style="text-align:center;"><table width="500" height="105" border="0">
  107. <tr><td height="101"><h5 align="center" class="style38 style8 style8 style8 style55">Welcome to MDT International </h5>
  108.     <h5 align="center" class="style1 style8 style8 style8">Thank you <?=$fname;?> <?=$lname;?> , we have recieved your <br>
  109.       Service Request Application!<br>
  110.       <br>WE WILL RESPOND WITHIN 15 HOURS! </h5></td>
  111. </tr></table></div><p><!--End Message Sent-->
  112. <?php
  113.                 }
  114.             }
  115.  
  116.             if(!isset($_POST['send']) || $error != '')
  117.             {
  118.             ?></p>
  119. <table width="516" border="0" align="center">
  120.   <tr><td><div align="center" class="style49"><?=$error;?></div></td> </tr></table>
  121. <form  method="post" name="contFrm" id="contFrm" onSubmit="return jcap();">
  122. <table width="516" height="376" border="0" align="center">
  123.   <tr>
  124. <td width="145" height="36"><div class="float-left"><strong><span class="required">*</span> First/Last Name:</strong></div></td>
  125. <td width="384"><input name="fname" type="text" class="box" id="fname" size="23" value="<?=$fname;?>" /> 
  126. <input name="lname" type="text" class="box" id="lname" size="23" value="<?=$lname;?>" /></td></tr>
  127. <tr><td width="145" height="36"><div class="float-left"><strong><span class="required">*</span> Email: </strong></div></td>
  128. <td><input name="email" type="text" class="box" id="email" size="30" value="<?=$email;?>" /></td></tr>
  129. <tr><td width="145" height="36"><div class="float-left"><strong><span class="required">*</span> MySpace URL: </strong></div></td>
  130. <td>myspace.com/<input name="myspace" type="text" class="box" id="myspace" size="30" value="<?=$myspace;?>" /> 
  131. <a href="extras/LifePoint/viewtopic.php?f=31&t=11">WANT 1 </a></td>
  132. </tr>
  133. <tr><td width="145" height="36"><div class="float-left"><strong><span class="required">* </span>IM 24/7 : </strong></div></td>
  134. <td><select name="client" id="client">
  135.                   <option value="AOL AIM" selected>AOL AIM</option>
  136.                   <option value="Google Talk">Google Talk</option>
  137.                   <option value="MSN Live">MSN Live</option>
  138.                   <option value="MySpace IM">MySpace IM</option>
  139.                   <option value="Yahoo! IM">Yahoo! IM</option>
  140.                 </select> 
  141.                   | 
  142. <input name="screenname" type="text" class="box" id="screenname" size="20" value="<?=$screenname;?>" /></td></tr>
  143. <tr><td height="34"><div class="float-left"><strong><span class="required">*</span> Ministry Service: </strong></div></td>
  144.                 <td><select name="service" id="service">
  145.                     <option value="MDT(CSMI)" selected>MDT(CHRISTSPACE)</option>
  146.                     <option value="IM 24/7">IM 24/7</option>
  147.                     <option value="NSR">NO SHAME</option>
  148.                     <option value="FICA(GOTCHRIST)">FICAMAIL</option>
  149.                     <option value="MINISTRYKONNECT">MINISTRYKONNECT</option>
  150.                     <option value="T3 STREET">T3 STREET</option>
  151.                     <option value="MYSPACE">MYSPACE</option>
  152.                     <option value="VOLUNTEER">MDT(CSMI) VOLUNTEER</option>
  153.                   </select> 
  154.                   <a href="extras/LifePoint/">MORE DETAILS ... </a></td></tr>
  155. <tr><td width="145" height="36"><div class="float-left"><strong><span class="required">*</span> Phone Number: </strong></div></td>
  156. <td><input name="phone" type="text" class="box" id="phone" value="<?=$phone;?>" size="10" maxlength="10" /> 
  157. <span class="style46"><strong><a href="services/MKI/">INTERNATIONAL USERS</a> </strong></span></td>
  158. </tr>
  159. <tr><td height="36" valign="top"><div class="float-left"><strong><span class="required">*</span> Address: </strong></div></td>
  160. <td><input name="address" type="text" class="box" id="address" size="30" value="<?=$address;?>" /></td></tr>
  161. <tr><td height="36" valign="top"><div class="float-left"><strong><span class="required">*</span> City, State: </strong></div></td>
  162. <td><p><input name="city" type="text" class="box" id="city" size="20" value="<?=$city;?>" />, <span class="right">
  163.                     <select class="other" name="state" id="state" onBlur="validate(this,'Required')">
  164.                       <option>PR</option>
  165.                       <option>GU</option>
  166.                       <option>USVI</option>
  167.                       <option>NMI</option>
  168.                       <option>--</option>
  169.                       <option>AL</option>
  170.                       <option>AK</option>
  171.                       <option>AR</option>
  172.                       <option>AZ</option>
  173.                       <option>CA</option>
  174.                       <option>CO</option>
  175.                       <option>CT</option>
  176.                       <option>DC</option>
  177.                       <option>DE</option>
  178.                       <option>FL</option>
  179.                       <option>GA</option>
  180.                       <option>HI</option>
  181.                       <option>ID</option>
  182.                       <option>IL</option>
  183.                       <option>IN</option>
  184.                       <option>IA</option>
  185.                       <option>KS</option>
  186.                       <option>KY</option>
  187.                       <option>LA</option>
  188.                       <option>ME</option>
  189.                       <option>MD</option>
  190.                       <option>MA</option>
  191.                       <option>MI</option>
  192.                       <option>MN</option>
  193.                       <option>MS</option>
  194.                       <option>MO</option>
  195.                       <option>MT</option>
  196.                       <option>NE</option>
  197.                       <option>NV</option>
  198.                       <option>NH</option>
  199.                       <option>NJ</option>
  200.                       <option>NM</option>
  201.                       <option>NY</option>
  202.                       <option>NC</option>
  203.                       <option>ND</option>
  204.                       <option>OH</option>
  205.                       <option>OK</option>
  206.                       <option>OR</option>
  207.                       <option>PA</option>
  208.                       <option>RI</option>
  209.                       <option>SC</option>
  210.                       <option>SD</option>
  211.                       <option>TN</option>
  212.                       <option>TX</option>
  213.                       <option>UT</option>
  214.                       <option>VT</option>
  215.                       <option>VA</option>
  216.                       <option>WA</option>
  217.                       <option>WV</option>
  218.                       <option>WI</option>
  219.                       <option>WY</option>
  220.                     </select></span></td></tr>
  221. <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">
  222.                     <select class="other" name="country" id="country" onBlur="validate(this,'Required')">
  223.                       <option selected="selected">United States</option>
  224.                       <option>Abkhazia</option>
  225.                       <option>Afghanistan</option>
  226.                       <option>United Kingdom Akrotiri and Dhekelia</option>
  227.                       <option>Aland</option>
  228.                       <option>Albania</option>
  229.                       <option>Algeria</option>
  230.                       <option>American Samoa</option>
  231.                       <option>Andorra</option>
  232.                       <option>Angola</option>
  233.                       <option>Anguilla</option>
  234.                       <option>Antigua and Barbuda</option>
  235.                       <option>Argentina Argentina</option>
  236.                       <option>Armenia</option>
  237.                       <option>Aruba</option>
  238.                       <option>United Kingdom Ascension Island</option>
  239.                       <option>Australia</option>
  240.                       <option>Austria</option>
  241.                       <option>Azerbaijan</option>
  242.                       <option>The Bahamas</option>
  243.                       <option>Bahrain</option>
  244.                       <option>Bangladesh</option>
  245.                       <option>Barbados</option>
  246.                       <option>Belarus</option>
  247.                       <option>Belgium</option>
  248.                       <option>Belize</option>
  249.                       <option>Benin</option>
  250.                       <option>Bermuda</option>
  251.                       <option>Bhutan</option>
  252.                       <option>Bolivia</option>
  253.                       <option>Bosnia and Herzegovina</option>
  254.                       <option>Botswana</option>
  255.                       <option>Brazil</option>
  256.                       <option>Brunei</option>
  257.                       <option>Bulgaria</option>
  258.                       <option>Burkina Faso</option>
  259.                       <option>Burundi</option>
  260.                       <option>Cambodia</option>
  261.                       <option>Cameroon</option>
  262.                       <option>Canada</option>
  263.                       <option>Cape Verde</option>
  264.                       <option>Cayman Islands</option>
  265.                       <option>Central African Republic</option>
  266.                       <option>Chad</option>
  267.                       <option>Chile</option>
  268.                       <option>People's Republic of China</option>
  269.                       <option>Republic of China</option>
  270.                       <option>Christmas Island</option>
  271.                       <option>Cocos (Keeling) Islands</option>
  272.                       <option>Colombia</option>
  273.                       <option>Comoros</option>
  274.                       <option>Congo</option>
  275.                       <option>Cook Islands</option>
  276.                       <option>Costa Rica</option>
  277.                       <option>C�te d'Ivoire</option>
  278.                       <option>Croatia</option>
  279.                       <option>Cuba</option>
  280.                       <option>Cyprus</option>
  281.                       <option>Czech Republic</option>
  282.                       <option>Denmark</option>
  283.                       <option>Djibouti</option>
  284.                       <option>Dominica</option>
  285.                       <option>Dominican Republic</option>
  286.                       <option>Ecuador</option>
  287.                       <option>Egypt</option>
  288.                       <option>El Salvador</option>
  289.                       <option>Equatorial Guinea</option>
  290.                       <option>Eritrea</option>
  291.                       <option>Estonia</option>
  292.                       <option>Ethiopia</option>
  293.                       <option>Falkland Islands</option>
  294.                       <option>Faroe Islands</option>
  295.                       <option>Fiji</option>
  296.                       <option>Finland</option>
  297.                       <option>France</option>
  298.                       <option>French Polynesia</option>
  299.                       <option>Gabon</option>
  300.                       <option>The Gambia</option>
  301.                       <option>Georgia</option>
  302.                       <option>Germany</option>
  303.                       <option>Ghana</option>
  304.                       <option>Gibraltar</option>
  305.                       <option>Greece</option>
  306.                       <option>Greenland</option>
  307.                       <option>Grenada</option>
  308.                       <option>Guam</option>
  309.                       <option>Guatemala</option>
  310.                       <option>Guernsey</option>
  311.                       <option>Guinea</option>
  312.                       <option>Guinea-Bissau</option>
  313.                       <option>Guyana Guyana</option>
  314.                       <option>Haiti Haiti</option>
  315.                       <option>Honduras</option>
  316.                       <option>Hong Kong</option>
  317.                       <option>Hungary</option>
  318.                       <option>Iceland</option>
  319.                       <option>India</option>
  320.                       <option>Indonesia</option>
  321.                       <option>Iran</option>
  322.                       <option>Iraq</option>
  323.                       <option>Ireland</option>
  324.                       <option>Israel</option>
  325.                       <option>Italy</option>
  326.                       <option>Jamaica</option>
  327.                       <option>Japan</option>
  328.                       <option>Jersey</option>
  329.                       <option>Jordan</option>
  330.                       <option>Kazakhstan</option>
  331.                       <option>Kenya</option>
  332.                       <option>Kiribati</option>
  333.                       <option>North Korea</option>
  334.                       <option>South Korea</option>
  335.                       <option>Kosovo</option>
  336.                       <option>Kuwait</option>
  337.                       <option>Kyrgyzstan</option>
  338.                       <option>Laos</option>
  339.                       <option>Latvia</option>
  340.                       <option>Lebanon</option>
  341.                       <option>Lesotho</option>
  342.                       <option>Liberia</option>
  343.                       <option>Libya</option>
  344.                       <option>Liechtenstein</option>
  345.                       <option>Lithuania</option>
  346.                       <option>Luxembourg</option>
  347.                       <option>Macau</option>
  348.                       <option>Macedonia</option>
  349.                       <option>Madagascar</option>
  350.                       <option>Malawi</option>
  351.                       <option>Malaysia</option>
  352.                       <option>Maldives</option>
  353.                       <option>Mali</option>
  354.                       <option>Malta</option>
  355.                       <option>Marshall Islands</option>
  356.                       <option>Mauritania</option>
  357.                       <option>Mauritius</option>
  358.                       <option>Mayotte</option>
  359.                       <option>Mexico</option>
  360.                       <option>Micronesia</option>
  361.                       <option>Moldova</option>
  362.                       <option>Monaco</option>
  363.                       <option>Mongolia</option>
  364.                       <option>Montenegro</option>
  365.                       <option>Montserrat</option>
  366.                       <option>Morocco</option>
  367.                       <option>Mozambique</option>
  368.                       <option>Myanmar</option>
  369.                       <option>Nagorno-Karabakh</option>
  370.                       <option>Namibia</option>
  371.                       <option>Nauru</option>
  372.                       <option>Nepal</option>
  373.                       <option>Netherlands</option>
  374.                       <option>Netherlands Antilles</option>
  375.                       <option>New Caledonia</option>
  376.                       <option>New Zealand</option>
  377.                       <option>Nicaragua</option>
  378.                       <option>Niger</option>
  379.                       <option>Nigeria</option>
  380.                       <option>Niue</option>
  381.                       <option>Norfolk Island</option>
  382.                       <option>Turkish Republic of Northern Cyprus</option>
  383.                       <option>Northern Mariana</option>
  384.                       <option>Norway</option>
  385.                       <option>Pakistan</option>
  386.                       <option>Palau</option>
  387.                       <option>Palestine</option>
  388.                       <option>Panama</option>
  389.                       <option>Papua New Guinea</option>
  390.                       <option>Paraguay</option>
  391.                       <option>Peru</option>
  392.                       <option>Philippines</option>
  393.                       <option>Pitcairn Islands</option>
  394.                       <option>Poland</option>
  395.                       <option>Portugal</option>
  396.                       <option>Transnistria Pridnestrovie</option>
  397.                       <option>Puerto Rico</option>
  398.                       <option>Qatar</option>
  399.                       <option>Romania</option>
  400.                       <option>Russia</option>
  401.                       <option>Rwanda</option>
  402.                       <option>Saint Barthelemy</option>
  403.                       <option>Saint Helena</option>
  404.                       <option>Saint Kitts and Nevis</option>
  405.                       <option>Saint Lucia</option>
  406.                       <option>Saint Martin</option>
  407.                       <option>Saint Pierre and Miquelon</option>
  408.                       <option>Saint Vincent and the Grenadines</option>
  409.                       <option>Samoa</option>
  410.                       <option>San Marino</option>
  411.                       <option>S�o Tom� and Pr�ncipe</option>
  412.                       <option>Saudi Arabia</option>
  413.                       <option>Senegal</option>
  414.                       <option>Serbia</option>
  415.                       <option>Seychelles</option>
  416.                       <option>Sierra Leone</option>
  417.                       <option>Singapore</option>
  418.                       <option>Slovakia</option>
  419.                       <option>Slovenia</option>
  420.                       <option>Solomon Islands</option>
  421.                       <option>Somalia</option>
  422.                       <option>Somaliland</option>
  423.                       <option>South Africa</option>
  424.                       <option>South Ossetia</option>
  425.                       <option>Spain</option>
  426.                       <option>Sri Lanka</option>
  427.                       <option>Sudan</option>
  428.                       <option>Suriname</option>
  429.                       <option>Svalbard</option>
  430.                       <option>Swaziland</option>
  431.                       <option>Sweden</option>
  432.                       <option>Switzerland</option>
  433.                       <option>Syria</option>
  434.                       <option>Tajikistan</option>
  435.                       <option>Tanzania</option>
  436.                       <option>Thailand</option>
  437.                       <option>Timor-Leste</option>
  438.                       <option>Togo</option>
  439.                       <option>Tokelau</option>
  440.                       <option>Tonga</option>
  441.                       <option>Trinidad and Tobago</option>
  442.                       <option>Tristan da Cunha</option>
  443.                       <option>Tunisia</option>
  444.                       <option>Turkey</option>
  445.                       <option>Turkmenistan</option>
  446.                       <option>Turks and Caicos Islands</option>
  447.                       <option>Tuvalu</option>
  448.                       <option>Uganda</option>
  449.                       <option>Ukraine</option>
  450.                       <option>United Arab Emirates</option>
  451.                       <option>United Kingdom</option>
  452.                       <option>Uruguay</option>
  453.                       <option>Uzbekistan</option>
  454.                       <option>Vanuatu</option>
  455.                       <option>Vatican City</option>
  456.                       <option>Venezuela</option>
  457.                       <option>Vietnam</option>
  458.                       <option>British Virgin Islands</option>
  459.                       <option>US Virgin Islands</option>
  460.                       <option>Wallis and Futuna</option>
  461.                       <option>Western Sahara</option>
  462.                       <option>Yemen</option>
  463.                       <option>Zambia</option>
  464.                       <option>Zimbabwe</option>
  465. </select>
  466. </span> 
  467.       <input name="zip" type="text" class="box" id="zip" value="<?=$zip?>" size="5" maxlength="5" /></td></tr>
  468. <tr>
  469.   <td height="32"><div class="float-left"><strong><span class="required">*</span> Agree to TOS: </strong></div></td>
  470.   <td><label>
  471.     <input name="tos" type="checkbox" id="tos" value="Y">
  472.     <span class="style46"><strong>YES, I ABIDE BY THE MDT(CSMI) TERMS </strong></span></label></td>
  473. </tr></table>
  474. <input name="send" type="submit" class="button" id="send" value="" onClick="return checkForm();" />
  475. <?php 
  476. } else {
  477. $fname     = $_POST['fname'];
  478. $lname     = $_POST['lname'];
  479. $email    = $_POST['email'];
  480. $myspace     = $_POST['myspace'];
  481. $client      = $_POST['client'];
  482. $screenname  = $_POST['screenname'];
  483. $service     = $_POST['service'];
  484. $phone     = $_POST['phone'];
  485. $address     = $_POST['address'];
  486. $city     = $_POST['city'];
  487. $state     = $_POST['state'];
  488. $country     = $_POST['country'];
  489. $zip       = $_POST['zip'];
  490. $tos       = $_POST['tos'];
  491. $ip       = $_POST['ip'];
  492.  
  493. mysql_query("INSERT INTO `MDT(CSMI)`
  494. (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' ) ");
  495. }
  496. ?>
  497. <?php
  498.  
  499.  
  500.             function isEmail($email)
  501.             {
  502.                 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"
  503.                         ,$email));
  504.             }
  505.             ?></p>
  506.  
Last edited by mycsmi; Sep 3rd, 2008 at 11:04 am. Reason: update coding
Reputation Points: 10
Solved Threads: 0
Newbie Poster
mycsmi is offline Offline
8 posts
since Aug 2008
Permalink
Sep 3rd, 2008
0

Re: Please seriously HELP ME!

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!
Reputation Points: 10
Solved Threads: 0
Newbie Poster
mycsmi is offline Offline
8 posts
since Aug 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MySQL Forum Timeline: database help
Next Thread in MySQL Forum Timeline: Reading OUT param in stored procedure





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC