help me with my php

db , php Malaysia
  • 13 years ago

    hey everyone.. once again i have problem with my php languange.. i never know it can be this hard.. anyway can any one of you tell me what's wrong with my coding? i just can't fix it because i really really dont know how.

    </style>
    <script language="JavaScript">
    function checkForm()
    {
     var cname, cemail_add, csubject, ccomment;
     int cnumber;
     with(window.document.msgform)
     {
      cname     = name;
      cnumber   = number
      cemail_add  = email_add;
      csubject  = subject;
      ccomment  = comment;
     }
     
     if(trim(cname.value) == '')
     {
      alert('Please enter your name');
      cname.focus();
      return false;
     }
     else if(trim(cnumber.value) == '')
     {
      alert('Please enter your number');
      cnumber.focus();
      return false;
     }
     else if (!isNumber(trim(cnumber.value)))
     {
      alert('Your number is not valid');
      cnumber.focus();
      return false;
     }
     else if(trim(cemail_add.value) == '')
     {
      alert('Please enter your email');
      cemail_add.focus();
      return false;
     }
     else if(!isEmail(trim(cemail_add.value)))
     {
      alert('Email address is not valid');
      cemail_add.focus();
      return false;
     }
     else if(trim(csubject.value) == '')
     {
      alert('Please enter message subject');
      csubject.focus();
      return false;
     }
     else if(trim(ccomment.value) == '')
     {
      alert('Please enter your message');
      ccomment.focus();
      return false;
     }
     else
     {
      cname.value     = trim(cname.value);
      cnumber.value = trim(cnumber.value);
      cemail_add.value= trim(cemail_add.value);
      csubject.value  = trim(csubject.value);
      ccomment.value  = trim(ccomment.value);
      return true;
     }
    }

































































    /*
    Strip whitespace from the beginning and end of a string
    Input : a string
    */
    function trim(str)
    {
     return str.replace(/^\s+|\s+$/g,'');
    }






    /*
    Check if a string is in valid email format.
    Returns true if valid, false otherwise.
    */
    function isEmail(str)
    {
     var regex = /^[-_.a-z0-9]+@(([-_a-z0-9]+\.)+(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;
     return regex.test(str);
    }







    function isNumber(str)
    {
     int regex = /^((-?[0-9]*\.[0-9]+|[[:space:]]*[+-]?[0-9]+(\.[0-9]*)?)([eE][+-]?[0-9]+)?|0x[0-9a-fA-F]+)$/i;
     return regex.test(str)
     }
    </script>
    </head>





    <body>
    <?php

    $msg    = ''; // error message
    $name    = ''; // sender's name
    $number  = ''; // sender's phone number
    $email    = ''; // sender's email addres
    $subject  = ''; // message subject
    $message  = ''; // the message itself




    if(isset($_POST))
    {
     $name    = $_POST['name'];
     $number  = $_POST['number'];
     $email_add  = $_POST['email'];
     $subject  = $_POST['subject'];
     $message  = $_POST['message'];
     
     if(trim($name) == '')
     {
      $msg = 'Please enter your name';
     }
     else if(trim($email_add) =='')
     {
      $msg = 'Please enter your email address';
     }
     else if(!isnumber($number))
     {
      $msg = 'Your email address is not valid';
     }
     else if(trim($email_add) == '')
     {
      $msg = 'Please enter your email address';
     }
     else if(!isEmail($email_add))
     {
      $msg = 'Your email address is not valid';
     }
     else if(trim($subject) == '')
     {
      $msg = 'Please enter message subject';
     }
     else if(trim($comment) == '')
     {
      $msg = 'Please enter your message';
     }
     }
    ?>




































    <?php
     if($msg == '')
     {
     $insert = "insert into tblmail(name,number,email_add,subject,comment)values('$fn','$ln','$pn','$kn','$tn')";
     
     //open db connection
    $conn = mysqli_connect('localhost','root','','mydb')





    or die("could not connect to the database!");

     
     //execute query
     if(!mysqli_query($conn,$insert))
     {
      $msg="Error insert data!";
     }
     else
     {
      $msg = "data inserted successfully.";
      
      //set vars to "" for next form input
      $fn = $ln = $pn = $kn = $tn = "";
     }
     mysqli_close($conn);
    }
    ?>














    need it asap..
    thanx

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Computer science education cannot make anybody an expert programmer any more than studying brushes and pigment can make somebody an expert painter” - Eric Raymond