www.webdeveloper.com
Results 1 to 4 of 4

Thread: form having multiple checkbox and insert the data in database using ajax

  1. #1
    Join Date
    Jul 2014
    Posts
    1

    Smile form having multiple checkbox and insert the data in database using ajax

    sir i want to insert data i database using ajax by submitting form having multiple type of input
    my html code id here....

    1.index.html
    HTML Code:
    <html>
      <head>
          <script type="text/javascript" src="jqueru.js"></script>
           <script>
              $(document).ready(function()
              $("#submit").click(function(){
                 $.post(
                     "phpindex.php",{
                       name:$(#ib1).val(),
                       mygender:$(#ib2).val(),
                       mygender:$(#ibi3).val(),
                       lang1:$(#ib4).val(),
                       lang2:$(#ib5).val()
                    },
                  function(data){
                $("#mydiv").html(data)
                 }
              )
               });
         )};
    </script>
    </head>
    <body>
    <table>
                    name:-<input type=text  name="" id="id1"/><br/>
                    gender:-<input type=radio name="mygender" value="" id="ib2"/>male
                                <input  type=radio name="mygender" value="" id="ib3"/>female<br/>
                  lamguage:-<input  type=checbox name="lang1" value=""  id="ib4"/>hindi
                                  <inut type=checkbx    name="lang2" value="" id="ib5"/>nglish
             
                    <input type="submit" name="submit" id="submit">
    </table>
    </body>
    </html>
    .................................................................................................... ........................................................
    problem is that only name is being inserted rest gender and language is data is not inserted in the table .the php file regurding this html is below
    .................................................................................................... .....................................................
    2.phpndex.php

    PHP Code:
    <?php
    mysql_connect
    ("localhost","root","");
    mysql_select_db("mydb");
    $var1=$_POST['name'];
    $var2=$_POST['mygender'];
    $var3=$_POST['mygender'];
    $var4=$_POST['lang1'];
    $var5=$_POST['lang2'];
    $var6=$var4.$var5;
    $query="insert into mytable4 values('$var1','$var2','$var3','$var6')";
    $result=mysql_query($query);
    if(
    $result{echo"data is inserted";)
    else{echo
    "data is not inserted";}
    ?>

  2. #2
    Join Date
    Mar 2012
    Posts
    1,559
    1. Why are you using javascript to interface HTML input to a PHP script?

    2. Why have you used a <table> tag instead of <form>?

    3. Syntax error:

    if($result{echo"data is inserted"; )
    else{echo"data is not inserted";}

    should be:

    if($result){echo"data is inserted";}
    else{echo"data is not inserted";}

    4. Why post this in Web Video??? - moved to PHP...
    Last edited by jedaisoul; 07-23-2014 at 11:26 AM.

  3. #3
    Join Date
    Oct 2013
    Posts
    490
    In addition, should
    Code:
          <script type="text/javascript" src="jqueru.js"></script>
    be:
    Code:
          <script type="text/javascript" src="jquery.js"></script>
    ??

  4. #4
    Join Date
    Dec 2011
    Posts
    163
    What are you using to code this? You have a LOT of spelling errors, so I hope you did not copy this from a coding program...

    Please repost your code.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles