saroj bhattacharya

NA
0
42.9k

how to insert data into two table using in php mysql

May 28 2015 3:46 AM

how to insert data into two table using one single query in php mysql? my table name are popup_question and popup_answer . popup_answer table has multiple row and i went to insert multiple row on the table popup_answer and popup_question . popup_question does not have multiple row. please help me. my code is bellow

thank's

<?php

include('config.php');

session_start();

$msg="";

if(isset($_POST['h_action']))

{

$val_h_action=$_POST['h_action'];

}

if(isset($_POST['h_id']))

{

$val_h_id=$_POST['h_id'];

}

if($val_h_action=="delete")

{

mysql_query("DELETE FROM popup_question WHERE Id='$val_h_id'");

mysql_query("DELETE FROM popup_answar WHERE Question_id='$val_h_id'");

$msg=md5("1");

header("location:Add_pop_up_question.php?msg=$msg");

}

/* $option_b_campaign="<option value='' id='radi_id1'>- SELECT A CAMPAIGN -</option>";

$result2=mysql_query("select DISTINCT campaign_id from popup_question");

while($qdata=mysql_fetch_array($result2))

{

$campaign_id=$qdata['campaign_id'];

//$asset_name=$qdata['asset_type'];

$option_b_campaign .= "<option id='radi_id1' value='$campaign_id'>$campaign_id</option>";

} */

//$sql=mysql_query("select DISTINCT campaign_id from popup_question");

//while($row=mysql_fetch_array($sql))

//{

//echo "<option onclick='change("<?php echo $row['campaign_id'];

$msg1="";

if(isset($_POST['h_action']))

{

$val_h_action=$_POST['h_action'];

}

if($val_h_action=="insert")

{

$campaign=$_POST['campaign_id'];

$question=$_POST['question'];

$catagory=$_POST['mode'];

$sid=$_POST['sid'];

$qid=$_POST['qid'];

$ast=$_POST['answar_text'];

$sql=("INSERT INTO popup_question(Id,campaign_id,Question_text,Mod_id,Set_ID,Question_ID)VALUES('','$campaign','$question','$catagory','$sid','$qid')");

mysql_query($sql);

//if(isset($_POST['h_action']))

//{

// $val_h_action=$_POST['h_action'];

//}

//if($val_h_action=="insert")

//{

$total_rows = $_POST['total_record_count'];

if($total_rows <2)

{

$ast=$_POST['qid_1'];

$sql=mysql_query("INSERT INTO popup_answar(Answar_text )VALUES('$ast')");

$msg=md5("1");

}

else

{

for($m=1;$m<=$total_rows;$m++)

{

$ast = $_POST['qid_'.$m];

$sql=mysql_query("INSERT INTO popup_answar(Answar_text)VALUES('$ast')");

//echo "INSERT INTO reportsequencequestions(QuestionID)VALUES(['$qst'])";

}

$msg=md5("1");

header("location:report_sequence.php?msg=$msg");

}

//}

mysql_close($con);

//tableid1 & tableid2 are auto-incrementing primary keys

mysql_query($sql2);

$msg1=md5("1");

header("location:Add_pop_up_question.php?msg1=$msg1");

//echo"INSERT INTO popup_question(campaign_id,Question_text,Mod_id,Set_ID,Question_ID)VALUES('$campaign','$question','$catagory','$sid','$qid')";

}

<html>

<head>

$(document).ready(function () {

$('.p').hide()

$('#text').click(function(){

$('.p').show()

});

</script>

function insert()

{

document.form1.h_action.value="insert";

document.form1.submit();

}

</script>

/* function change(id){

alert(id);

document.form1.h_value.value=id;

document.form1.h_action.value='selectcam';

document.form1.submit();

}*/

</script>

function upload()

{

document.form1.h_action.value="upload";

document.form1.submit();

}

</script>

var table = document.getElementById(tableID);

var rowCount = table.rows.length;

var row = table.insertRow(rowCount);

var cell1 = row.insertCell(0);

var element1 = document.createElement("input");

element1.type = "checkbox";

element1.name = "chkbox[]";

cell1.appendChild(element1);

var cell2 = row.insertCell(1);

cell2.innerHTML = rowCount;

var cell3 = row.insertCell(2);

var element2 = document.createElement("input");

element2.type = "text";

element2.name = "qid_"+rowCount;

cell3.appendChild(element2);

document.getElementById('total_record_count').value = rowCount;

}

function deleteRow(tableID) {

try {

var table = document.getElementById(tableID);

var rowCount = table.rows.length;

for (var i = 0; i < rowCount; i++) {

var row = table.rows[i];

var chkbox = row.cells[0].childNodes[0];

if (null != chkbox && true == chkbox.checked) {

table.deleteRow(i);

rowCount--;

i--;

}

} catch (e) {

alert(e);

}

</script>

function validation()

{

if(document.form1.campaign_id.value=="blank")

{

alert("Please select campaign Id..");

return false;

}

if(document.form1.question.value=="")

{

alert("Enter text question ..");

return false;

}

if(document.form1.mode.value=="blank1")

{

alert("Please select catagory mode..");

return false;

}

if(document.form1.sid.value=="")

{

alert("Please enter set id..");

return false;

}

if(document.form1.qid.value=="")

{

alert("Please enter Question id..");

return false;

}

</script>

function del(i)

{

//var r=confirm("Are you Confirm to delete");

if (confirm("Are you Confirm to delete!") == true){

document.form1.h_id.value=i;

document.form1.h_action.value="delete";

document.form1.submit();

}

</script>

function change(){

document.getElementById("myform").submit();

}

</script>

</head>

<body>

<?php include ('header.php');?>

<h3>Qualify Question Entry</h3>

</div>

<label style="font-size:15px;font-style:italic;">Campaign</label></td><td>

<option value="blank">Select campaign</option>

<?php

$sql=mysql_query("select DISTINCT campaign_id from popup_question");

while($row=mysql_fetch_array($sql))

{

<?php

}

</select>

</td>

<td>

</td>

</tr>

<tr>

<label style="font-size:15px;font-style:italic;">Question</label></td><td>

</td>

<td>

</td>

</tr>

<tr>

<label style="font-size:15px;font-style:italic;">Category</label></td><td>

<option value="blank1">select mode</option>

<option value="1">Manual</option>

<option value="2" id="text">Multiple Option</option>

</select>

</td>

<td>

</td>

</tr>

<tr>

</td>

<td>

</td>

</tr>

<tr>

<label style="font-size:15px;font-style:italic;">Question ID</label></td><td>

</td>

<td>

</td>

</tr>

<tr>

<label style="font-size:15px;font-style:italic;">ANSWAR OPTION</label>

</td>

<td>

<tr bgcolor="#33FFFF"><th>Action</th><th>SL</th><th>Value</th></tr>

</tr>

</tbody>

</table>

</table>

</div>

</td>

</tr>

<tr><?php if(isset($_GET['msg1'])!=""){?><td style="color: green;">Insert Successfully</td><?php } ?><?php if(isset($_GET['msg'])!=""){?><td style="color: red;">Deleted Successfully</td><?php } ?></tr>

</table>

</div>

<h3>Existing Pop Up Questions</h3>

</div>

<?php

/* $val_h_action=$_POST['h_action'];

$val_h_id=$_POST['h_value'];

if($val_h_action=='selectcam')

{ */

//$Campaign_Name=$_POST['campaign_id'];

/* $query="SELECT * FROM popup_question WHERE campaign_id='$val_h_id'";

$run=mysql_query($query);

$numrow = mysql_num_rows($run); */

<th>Question</th>

<th>Answer Mode</th>

<th>Answer Text</th>

<th>Condition Status</th>

<th>Delete</th>

<?php

$campain=$_POST['campaign_id'];

$query=mysql_query("SELECT popup_question.*,popup_answar.*,answar_mode.*,GROUP_CONCAT(Answar_text SEPARATOR ',')Answar_text FROM popup_question, popup_answar, answar_mode

WHERE popup_question.Id = popup_answar.Question_id AND popup_question.Mod_id=answar_mode.id AND campaign_id='$campain' GROUP BY Question_text");

$count=1;

while($row = mysql_fetch_array( $query))

{

<td><a href="popup_selection.php?campaign_id=<?php echo $campain; ?>" style="font-size:15px;font-family:normal;"><?php echo $row['Question_text']; ?></a></td>

<td><a href="edit_condition.php"><button type="button">Edit Condition</button></a></td>

</tr>

<?php

$count++;

}

</table>

</p>

</div>

</div>

</form>

<?php include('footer.php');?>

</body>

</html>

Answers (1)

how to insert data into two table using in php mysql