saroj bhattacharya

NA
0
41.2k

join three table in mysql using php

May 19 2015 8:46 AM

hi i am trying to fetching data from the database when i am selecting the campaign name from dropdown list item without submit button click in php mysql.

and the data is fetch from the three table . my table name is popup_question, popup_answar, and answar_mode,

the table field in popup_question are Id,question_text, mod_id, set_id, question_id, and campaign_id

and the table popup_answar are contain id, question_id, answar_text

and table answar_mode contain id, mode field. i am trying to select campaign_id and get the result from database . the result table contain field

and data r bellow

answar_text, question_text, answar_mode. please help me i am new in this field.

my code is bellow----

<?php

include('config.php');

/* $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'];

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'];

$sql=mysql_query("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 addRow(tableID) {

var table = document.getElementById(tableID);

var rowCount = table.rows.length;

var row = table.insertRow(rowCount);

//Column 1

var cell1 = row.insertCell(0);

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

element1.type = "button";

var btnName = "button" + (rowCount + 1);

element1.name = btnName;

element1.setAttribute('value', 'Delete'); // or element1.value = "button";

element1.onclick = function () { removeRow(btnName); }

cell1.appendChild(element1);

//Column 2

var cell2 = row.insertCell(1);

cell2.innerHTML = rowCount + 1;

//Column 3

var cell3 = row.insertCell(2);

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

element3.type = "text";

cell3.appendChild(element3);

}

function removeRow(btnName) {

try {

var table = document.getElementById('dataTable');

var rowCount = table.rows.length;

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

var row = table.rows[i];

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

if (rowObj.name == btnName) {

table.deleteRow(i);

rowCount--;

}

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>

</head>

<body>

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

<h3>Qualify Question Entry</h3>

</div>

<table>

<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="0">Manual</option>

<option value="1" 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 style="width:300px;"></tr>

</tr>

</table>

</div>

</td>

</tr>

</table>

</form>

</div>

<h3>Existing Pop Up Questions</h3>

</div>

<?php

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

$selection = $_POST['campaign_id'];

echo $selection ;

}

/* $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 a.Question_text,b.Mode,c.Answar_text FROM popup_question a INNER JOIN answar_mode b ON a.ID_id=b.ID INNER JOIN popup_answar c ON a.Question _ID=c.Question_id WHERE campaign_id='$campain'");

while($row = mysql_fetch_array( $query))

{

</tr>

<?php

}

</table>

</div>

</div>

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

</body>

</html>

Answers (1)

Mail from HTML page using PHP

How to pass variables between php scripts?