TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
saroj bhattacharya
NA
0
43.2k
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>
<link rel="stylesheet" href="themes/ui-lightness/jquery.ui.all.css">
<link href="css/cssmenu.css" rel="stylesheet" type="text/css" />
<link href="css/inner.css" rel="stylesheet" type="text/css" />
<link href="css/style.css" rel="stylesheet" type="text/css" />
<script src="popjquery/jquery-1.10.2.js"></script>
<script src="js/jquery-1.7.1.min.js"></script>
<script type="text/javascript">
$(document).ready(function () {
$('.p').hide()
$('#text').click(function(){
$('.p').show()
});
});
</script>
<script type="text/JavaScript">
function insert()
{
document.form1.h_action.value="insert";
document.form1.submit();
}
</script>
<script>
/* function change(id){
alert(id);
document.form1.h_value.value=id;
document.form1.h_action.value='selectcam';
document.form1.submit();
}*/
</script>
<script>
function upload()
{
document.form1.h_action.value="upload";
document.form1.submit();
}
</script>
<script language="javascript">function addRow(tableID) {
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>
<script type="text/JavaScript">
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>
<script type="text/JavaScript">
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>
<script type="text/JavaScript">
function change(){
document.getElementById("myform").submit();
}
</script>
</head>
<body>
<?php include ('header.php');?>
<div class="maindiv">
<div class="wapper">
<div class="mainbody" style="height:auto;">
<div class="loginbar">
<h3>Qualify Question Entry</h3>
</div>
<div class="content-box-content">
<form action="" name="form1" method="post" onsubmit="return validation();" id="myform">
<input type="hidden" name="h_action" >
<input type="hidden" name="h_value" />
<input type="hidden" name="h_id">
<table border="10">
<tr><td class="style1">
<label style="font-size:15px;font-style:italic;">Campaign</label></td><td>
<select class="medium" name="campaign_id" style="width:450px;" onChange="this.form.submit()" >
<option value="blank">Select campaign</option>
<?php
$sql=mysql_query("select DISTINCT campaign_id from popup_question");
while($row=mysql_fetch_array($sql))
{
?>
<option id="id_radio1" value="<?php echo $row['campaign_id']; ?>" <?php if($row['campaign_id'] == $_REQUEST['campaign_id']){ echo 'selected';}?> ><?php echo $row['campaign_id']; ?> </option>
<?php
}
?>
</select>
</td>
<td>
</td>
</tr>
<tr>
<td class="style1">
<label style="font-size:15px;font-style:italic;">Question</label></td><td>
<input type="text" name="question" Class="medium" style="width:450px;height:35px;" >
</td>
<td>
</td>
</tr>
<tr>
<td class="style1">
<label style="font-size:15px;font-style:italic;">Category</label></td><td>
<select Class="medium" name="mode" style="width:450px;">
<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 class="style1">
<label style="font-size:15px;font-style:italic;">Set ID</label></td><td>
<input type="text" name="sid" Class="medium" style="width:450px;height:35px;" >
</td>
<td>
</td>
</tr>
<tr>
<td class="style1">
<label style="font-size:15px;font-style:italic;">Question ID</label></td><td>
<input type="text" name="qid" Class="medium" style="width:450px;height:35px;">
</td>
<td>
</td>
</tr>
<tr>
<td class="style1">
<label style="font-size:15px;font-style:italic;">ANSWAR OPTION</label>
<input type="text" name="answar_text" Class="medium" style="width:450px;height:35px;">
</td>
<td>
<div class="p">
<table id="dataTable" width="350px" border="1">
<tr bgcolor="#33FFFF"><th>Action</th><th>SL</th><th>Value</th></tr>
<tbody><tr>
<td><input type="checkbox" name="chk"></td>
<td> 1 </td>
<td> <input type="text" name="qid_1"> </td>
<input type="hidden" id="total_record_count" name="total_record_count" value="">
</tr>
</tbody>
</table>
<table border="1">
<tr><td><input type="button" value="Add row" onClick="addRow('dataTable')" class="btnz"></td>
<td><input type="button" value="Delete row" onClick="deleteRow('dataTable')" Class="btnz"></td></tr>
</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>
<tr><td><input type="button" value="Submit" onClick="insert();" Class="btnz"></td></tr>
</table>
</div>
<div class="loginbar">
<h3>Existing Pop Up Questions</h3>
</div>
<div class="content-box-content">
<p style="width: 100%; height: auto">
<?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); */
?>
<table border="2" >
<tr bgcolor="#33FFFF">
<th>SL</th>
<th>Question</th>
<th>Answer Mode</th>
<th>Answer Text</th>
<th>Condition Status</th>
<th>Edit</th>
<th>Delete</th>
<th></th></tr>
<?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))
{
?>
<tr bgcolor="#D8D8D8 "><td><?php echo $row['Id']; ?></td>
<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 style="font-size:15px;font-family:normal;"><?php echo $row['Mode']; ?></td>
<td style="font-size:15px;font-family:normal;"><?php echo $row['Answar_text']; ?></td>
<td style="font-size:15px;font-family:normal;"><input type="checkbox"></td>
<td><a href="edit_popup_question.php?id=<?php echo $row['Id']; ?>"><img src="images/edit-24.png"></a></td>
<td><input type="image" src="images/delete-24.png" value="Delete" onclick="del(<?php echo $row['Question_id'];?>)"></td>
<td><a href="edit_condition.php"><button type="button">Edit Condition</button></a></td>
</tr>
<?php
$count++;
}
?>
</table>
</p>
</div>
</div>
</div>
<!--Main Body Ends-->
</div>
</form>
<?php include('footer.php');?>
</body>
</html>
Reply
Answers (
2
)
how to insert data into two table using in php mysql
how to show output into multiple row in mysql?