how to insert data into two table using in php mysql

Question

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

saroj bhattacharya · Answer

i just want to insert data into two table using single query in php mysql. and also one table has multiple row. please help me... my code is bellow . 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= - SELECT A CAMPAIGN - ; $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 .=  $campaign_id ; } */ //$sql=mysql_query(select DISTINCT campaign_id from popup_question); //while($row=mysql_fetch_array($sql)) //{ //echo  $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']; $sql=mysql_query(INSERT INTO popup_question(campaign_idQuestion_textMod_idSet_IDQuestion_ID)VALUES('$campaign''$question''$catagory''$sid''$qid')); $msg1=md5(1); header(location:Add_pop_up_question.php?msg1=$msg1); //echoINSERT INTO popup_question(campaign_idQuestion_textMod_idSet_IDQuestion_ID)VALUES('$campaign''$question''$catagory''$sid''$qid'); } ?> $(document).ready(function () { $('.p').hide() $('#text').click(function(){ $('.p').show() }); }); function insert() { document.form1.h_action.value=insert; document.form1.submit(); } /* function change(id){ alert(id); document.form1.h_value.value=id; document.form1.h_action.value='selectcam'; document.form1.submit(); }*/ function upload() { document.form1.h_action.value=upload; document.form1.submit(); } 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 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); } } 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; } } 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(); } } function change(){ document.getElementById(myform).submit(); } Qualify Question Entry Campaign Select campaign $sql=mysql_query(select DISTINCT campaign_id from popup_question); while($row=mysql_fetch_array($sql)) { ?>  > } ?> Question Category select mode Manual Multiple Option Set ID Question ID ANSWAR OPTION Action SL Value 1 Insert Successfully Deleted Successfully Existing Pop Up Questions /* $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); */ ?> SL Question Answer Mode Answer Text Condition Status Edit Delete $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)) { ?>  style=font-size:15px;font-family:normal;> > )> Edit Condition $count++; } ?>

Dipankar Biswas · Answer

Hi.. try it.. Nname: Password: Address: Phone No: $con= mysql_connect(localhostroot); mysql_select_db(phptutor$con); if (!$con){ die('could not connect'.mysql_error); } @$a=$_POST['Uname']; @$b=$_POST['Upass']; @$c=$_POST['Uadrs']; @$d=$_POST['Uph']; if(@$_POST['addval']) { $sql=insert into tbl_insert_data(User_nameUser_passUser_addressUser_ph) values('.$a.''.$b.''.$c.''.$d.'); echo insert data; mysql_query($sql); } $con= mysql_connect(localhostroot); mysql_select_db(phptutor$con); if (@$_POST['showdata']) { echo $show_result=mysql_query(select User_nameUser_passUser_addressUser_ph from tbl_insert_data); echo  All User User_name User_pass User_address User_ph ; while($row=mysql_fetch_array($show_result)) { echo  ; echo  .$row['User_name']. ; echo  .$row['User_pass'].  ; echo  .$row['User_address']. ; echo  .$row['User_ph']. ; echo  ; } } echo   ?> Check my video... How to create function and procedure in mysql database. Thanks..

saroj bhattacharya · Answer

thanks for send this answer .but it is not working in page...... please modify my code which are wrong .. please help me thanks

Nanhe Siddique · Answer

hi saroj read this link http://stackoverflow.com/questions/22384391/insert-data-into-2-tables-using-one-query-using-php-and-mysql itmay help you