MySQL RSS MySQL RSS

Please seriously HELP ME!

Reply

•
•
Join Date: Aug 2008
Posts: 8
Reputation: mycsmi is an unknown quantity at this point 
Solved Threads: 0
mycsmi's Avatar
mycsmi mycsmi is offline Offline
Newbie Poster

Please seriously HELP ME!

 
0
  #1
Sep 2nd, 2008
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!
Jake Parks
President/CEO
MDT International
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 1,160
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 137
dickersonka dickersonka is offline Offline
Veteran Poster

Re: Please seriously HELP ME!

 
0
  #2
Sep 2nd, 2008
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.
Custom Application & Software Development
www.houseshark.net
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 8
Reputation: mycsmi is an unknown quantity at this point 
Solved Threads: 0
mycsmi's Avatar
mycsmi mycsmi is offline Offline
Newbie Poster

Re: Please seriously HELP ME!

 
0
  #3
Sep 2nd, 2008
•
•
•
•
Originally Posted by dickersonka View Post
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
Jake Parks
President/CEO
MDT International
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 1,160
Reputation: dickersonka will become famous soon enough dickersonka will become famous soon enough 
Solved Threads: 137
dickersonka dickersonka is offline Offline
Veteran Poster

Re: Please seriously HELP ME!

 
0
  #4
Sep 2nd, 2008
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.
Custom Application & Software Development
www.houseshark.net
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 8
Reputation: mycsmi is an unknown quantity at this point 
Solved Threads: 0
mycsmi's Avatar
mycsmi mycsmi is offline Offline
Newbie Poster

Re: Please seriously HELP ME!

 
0
  #5
Sep 3rd, 2008 
  
 
  
 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
Jake Parks
President/CEO
MDT International
Reply With Quote Quick reply to this message  
•
•
Join Date: Aug 2008
Posts: 8
Reputation: mycsmi is an unknown quantity at this point 
Solved Threads: 0
mycsmi's Avatar
mycsmi mycsmi is offline Offline
Newbie Poster

Re: Please seriously HELP ME!

 
0
  #6
Sep 3rd, 2008
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!
Jake Parks
President/CEO
MDT International
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Other Threads in the MySQL Forum
Thread Tools Search this Thread



agplv3 alfresco amazon api artisticlicense aws bizspark breathalyzer camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword keywords kickfire laptop legal license licensing linux maintenance mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns saas select sharepoint simpledb sourcecode spotify sql sugarcrm syntax techsupport thunderbird transparency virtualization
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC