form fillup html css php mysql

Question

 <html>
<head>

   
               

</head>

<body>

    <a href="#" id="filldetails" onfocusout="addFields()"><input type="text" id="member" name="member" value="">Number of members: (max. 10)<br />
    Fill Details</a>
        <form class="contact-form row" method="post" action="test.php" enctype="multipart/form-data">
    <div id="container"></div>

      
      <div class="form-field col-lg-12">
         <input class="submit-btn" type="submit" value="Submit" name="submit">
      </div>
    </form>
</body>
<?php 
include('config.php');

$i=0;

if(isset($_POST['submit']))
{

 $name = $_POST['member_name'.$i.''];



  $sql="INSERT INTO `ssk`.`members` (`member_name`) VALUES ('$name')";
  $query=mysql_query($sql,$con);
  if($query)
  {
 
  echo '<div class="alert alert-success">
    <strong>form submitted successfully your member-id is '.$member_id.' </strong> 
  </div>';?>
  <script>
  alert('Thank you! Your form has been submitted and is being verified please note-down the member-id.');
  </script>
  <?php
  }else{
echo '<div class="alert alert-success">
    <strong>unsuccessful please read the above data and fill the form accordingly.</strong> 
  </div>';
  ?>
  <script>
    alert('ERROR:Request unprocessed');
  </script>
  <?php
}
}

?>
</html>

What I want is to have a form which accepts the number of fields to be generated after which the user has to fill the generated input fields and the data has to be stored in the database is their any alternate way of doing this using PHP & MYSQL its taking entry of first data bur not working dynamic please help me with this.

What does your current code not do which you need it to do. What efforts have you made to get it to work and the specific problems you have with it? — Nigel Ren
– Nigel Ren, Commented Aug 15, 2020 at 9:31

Mark · Accepted Answer · 2020-08-15 15:14:30Z

1

Using the structure you already have you could simply put a while loop in the php:

if(isset($_POST['submit']))
{
  while(isset($_POST['member_name'.$i]))
  {
    $name = $_POST['member_name'.$i.''];

    $sql = "INSERT INTO `ssk`.`members` (`member_name`) VALUES ('$name')";
    //rest of the code here

    //increment $i
    $i++;
  }
}

You could also have used arrays for the form inputs e.g. input.name = "member_name[]" and then the loop in php could have have been foreach($_POST['member_name'] as $i=>$name).

Please also look into validating the post variables and properly preparing sql statements so you are not open to sql injection or problems if the name contained a quote.

answered Aug 15, 2020 at 15:14

Mark

1,0391 gold badge6 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

khalandar bankapur Over a year ago

thank you for your answer it was really helpful finally succeeded after lot of efforts :)

Collectives™ on Stack Overflow

form fillup html css php mysql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related