Insert to database multiple options from HTML form via PHP
You need to create forms with this format
<form action="insert.php" method="post"> <ul> <li> <input name="CertificateType[0]" type="hidden"> <input name="CertificateType[0]['STCWCode']" type="text"> <input name="CertificateType[0]['CertNo']" type="text"> <input name="CertificateType[0]['PlaceofIssueCert']" type="text"> <input name="CertificateType[0]['FromCert']" type="date"> <input name="CertificateType[0]['ToCert']" type="date"> </li> <li> <input name="CertificateType[1]" type="hidden"> <input name="CertificateType[1]['STCWCode']" type="text"> <input name="CertificateType[1]['CertNo']" type="text"> <input name="CertificateType[1]['PlaceofIssueCert']" type="text"> <input name="CertificateType[1]['FromCert']" type="date"> <input name="CertificateType[1]['ToCert']" type="date"> </li> ...</ul></form>When you submit form with this format , you will receive Numeric Key array in $_POST['CertificateType'] in insert.php
array( "0" => array( "STCWCode" => "somevalue", "CertNo" => "somevalue", "PlaceofIssueCert" => "somevalue", "FromCert" => "somevalue", "ToCert" => "somevalue", ), "1" => array( "STCWCode" => "somevalue", "CertNo" => "somevalue", "PlaceofIssueCert" => "somevalue", "FromCert" => "somevalue", "ToCert" => "somevalue", ), . . .)Here each index will represent one row.This can be retrived using foreach loop as below :
Update your php code as
foreach($_POST['CertificateType'] as $val){ $CertificateType = $val;$CertificateType = $val; $STCWCode = $val['STCWCode']; $CertNo = $val['CertNo']; $FromCert = $val['FromCert']; $ToCert = $val['ToCert']; $CertificateType = mysqli_real_escape_string($link, $CertificateType); $STCWCode = mysqli_real_escape_string($link, $STCWCode); $CertNo = mysqli_real_escape_string($link, $CertNo); $FromCert = mysqli_real_escape_string($link, $FromCert); $ToCert = mysqli_real_escape_string($link, $ToCert); $sql3 = "INSERT INTO Tbl ( CertificateType ,UserId ,STCWCode ,CertNo ,FromCert ,ToCert ,DateCreated) VALUES ( '$CertificateType', '$UserID', '$STCWCode', '$CertNo', '$FromCert', '$ToCert', now())";if(mysqli_query($link, $sql3)){ echo "Resume created successfully.";} else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);}}
Use your fiddle JavaScript and add certificate type in hidden field for every row; and name it RowCertificateType same as other fields for row;
<input type="hidden" name="RowCertificateType[]" value="" /><!-- set value of this field same as you are showing in li as label for this row; -->then in your php script use as follows:
foreach($_POST['RowCertificateType'] as $key=> $val){ $CertificateType = $val; $STCWCode = $_POST['STCWCode'][$key]; $CertNo = $_POST['CertNo'][$key]; $FromCert = $_POST['FromCert'][$key]; $ToCert = $_POST['ToCert'][$key]; $CertificateType = mysqli_real_escape_string($link, $CertificateType); $STCWCode = mysqli_real_escape_string($link, $STCWCode); $CertNo = mysqli_real_escape_string($link, $CertNo); $FromCert = mysqli_real_escape_string($link, $FromCert); $ToCert = mysqli_real_escape_string($link, $ToCert); $sql3 = "INSERT INTO Tbl ( CertificateType ,UserId ,STCWCode ,CertNo ,FromCert ,ToCert ,DateCreated ) VALUES ( '$CertificateType', '$UserID', '$STCWCode', '$CertNo', '$FromCert', '$ToCert', now())"; if(mysqli_query($link, $sql3)){ echo "Resume created successfully."; }else{ echo "ERROR: Could not able to execute $sql. " . mysqli_error($link); }} :)
See, what i found is:
First, Replace
CertificateType[]withCertificateTypein<select id='options' name="CertificateType[]" class="field-style div-format align-left">Because, this dropdown is not multiple. On based upononchangefunctionality only you are getiingSTCWCode,CertNo,FromCert&ToCertvalues, which are multiple (NotCertificateTypedropdown). What you can do is: you can append onehidden textnamelyCertificateTypeHidden[]in which value ofCertificateTypedropdown will get inserted.As i pointed in Ist Point.
CertificateTypeis not multiple. So, it's considering only one value. What you can do is : As i wrote above, instead ofCertificateType, you can useCertificateTypeHidden[]Likeforeach($_POST['CertificateTypeHidden'] as $key => $val){.
After Changes, code should look like this way. (If you follow above points)
<?phpforeach($_POST['CertificateTypeHidden'] as $key => $val){ $CertificateType = $_POST['CertificateTypeHidden'][$key]; $STCWCode = $_POST['STCWCode'][$key]; $CertNo = $_POST['CertNo'][$key]; $FromCert = $_POST['FromCert'][$key]; $ToCert = $_POST['ToCert'][$key]; . . .}?>For my testing purpose. I removed foreach($_POST['CertificateType'] as $key => $val){ with foreach($_POST['STCWCode'] as $key => $val){. All appended multiple textbox values coming correctly.
<?phpforeach($_POST['STCWCode'] as $key => $val){ $CertificateType = $_POST['CertificateTypeHidden'][$key]; $STCWCode = $_POST['STCWCode'][$key]; $CertNo = $_POST['CertNo'][$key]; $FromCert = $_POST['FromCert'][$key]; $ToCert = $_POST['ToCert'][$key]; . . .}?>This is the only issue. All well. Just append one hidden field. (<input type='hidden' name='CertificateTypeHidden[]'>). In which values of selected dropdown come and sit in value attribute of this hidden field. In submit page or insert.php page, do foreach using CertificateTypeHidden.
Go through it. All the best.