473,396 Members | 1,933 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

update table field when submit the form value in another page

Here is my two files.. in view.php file there is a 2nd last field is Remarks..whenever user want to gives the remarks then he/she will click on Remarks field then a new page (form.php) will be opened and give the remarks over here and submit the form..
i just want when user submit then his/her remarks will added automatically in Remarks field in (view.php) page...

Please resolve my this problem.

my view.php code is..

Expand|Select|Wrap|Line Numbers
  1. <?php
  2. mysql_connect("localhost","root","") or die(mysql_error());
  3. mysql_select_db("call_conference") or die(mysql_error());
  4.  
  5. ?>
  6. <main class="content">
  7. <table border="1" style="margin:-55px 5px 5px 5px;" align="left" width="auto">
  8. <tr><td colspan="11" align="center"style="background-color: #A0CFEC;color:black;font-weight:600;
  9.  font-size:20px; height:30px; padding:3px auto;">View All Report</td></tr>
  10. <tr>
  11. <!--<td align="center"> DD/HH:MI</td>-->
  12. <td align="center"style="background-color: #A0CFEC;color:black; padding:3px; font-weight:600; font-size:15px;">Customer Name</td>
  13. <td align="center"style="background-color: #A0CFEC;color:black; padding:3px; font-weight:600; font-size:15px;">Customer Mobile No.</td>
  14. <td align="center"style="background-color: #A0CFEC;color:black; padding:3px; font-weight:600; font-size:15px;">Email Id</td>
  15. <td align="center"style="background-color: #A0CFEC;color:black; padding:3px; font-weight:600; font-size:15px;">Company Mobile Number</td>
  16. <td align="center"style="background-color: #A0CFEC;color:black; padding:3px; font-weight:600; font-size:15px;">Call Start Time</td>
  17. <td align="center"style="background-color: #A0CFEC;color:black; padding:3px; font-weight:600; font-size:15px;">Call End Time</td>
  18. <td align="center"style="background-color: #A0CFEC;color:black; padding:3px; font-weight:600; font-size:15px;">Customer Call Duration </td>
  19. <td align="center"style="background-color: #A0CFEC;color:black; padding:3px; font-weight:600; font-size:15px;">Total Duration</td>
  20. <td align="center"style="background-color: #A0CFEC;color:black; padding:3px; font-weight:600; font-size:15px;">Balance Left</td>
  21. <td align="center"style="background-color: #A0CFEC;color:black; padding:3px; font-weight:600; font-size:15px;">Remarks</td>
  22. <td align="center"style="background-color: #A0CFEC;color:black; padding:3px; font-weight:600; font-size:15px;">Next Call Schedule Date Time </td>
  23. </tr>
  24. <?php
  25. $select="select A_PARTY_NAME,A_PARTY,EMAIL_ID,B_PARTY,CALL_START_TIME,CALL_END_TIME,A_PARTY_DURATION,TOTAL_DURATION,BALANCE_LEFT,REMARKS from tbl_call_detail order by CALL_START_TIME desc";
  26. $data=mysql_query($select);
  27. while($row=mysql_fetch_array($data))
  28. {
  29. ?>
  30.  
  31. <tr style="font-size:13px;">
  32. <td align="center"><?php  echo $row['A_PARTY_NAME']?></td>
  33. <td align="center"><?php  echo $row['A_PARTY']?></td>
  34. <td align="center"><?php  echo $row['EMAIL_ID']?></td>
  35. <td align="center"><?php  echo $row['B_PARTY']?></td>
  36. <td align="center"><?php  echo $row['CALL_START_TIME']?></td>
  37. <td align="center"><?php  echo $row['CALL_END_TIME']?></td>
  38. <td align="center"><?php  echo $row['A_PARTY_DURATION']?></td>
  39. <td align="center"><?php  echo $row['TOTAL_DURATION']?></td>
  40. <td align="center"><?php  echo $row['BALANCE_LEFT']?></td>
  41. <td align="center"><a href="form.php" style="text-decoration:none;
  42. font-size:15px; font-weight:600; color:#F70D1A" target="_blank"><?php  echo $row['REMARKS']?></td></a>
  43. </tr>
  44.  
  45. <?php }
  46. ?>
  47.  
  48. </table>
  49. </div>
  50.  
  51. and my form.php file code is...
  52.  
  53.  <form method="post" name="myform" method="POST" action="remark.php"> 
  54.         <fieldset style="align:center; ">
  55.  
  56.  
  57.             <p style="padding:18px;">
  58.            <label type="" style="font-size:16px; margin-left:-10px; margin-top:30px; font-weight:bold;">Give Your Remarks:</label>
  59.            <textarea id="text" class="text" name="fmessage" placeholder="Give Your Remarks Here" style="FONT-SIZE:10pt; 
  60.            width:260px; height:70px; margin:-40px 0px 0px 170px;" autocomplete="off" ></textarea>
  61.          </p>
  62.  
  63.  
  64.            <p>
  65.  
  66.     <span style="font-weight:600; font-size:16px; margin-left:6px;font-weight:bold;">Please Select Date </span>
  67.         <a href="javascript:NewCal('demo1','DDMMYYYY',true,24)"><img src="c.png"></a>
  68.     <input type="Text" id="demo1" name="demo1" maxlength="30" size="39" style="margin-top:-20px;margin-left:20px;">
  69.           </p>        
  70.  
  71.                 <p>
  72.             <button id="registerNew" type="submit" name="webpanel">Call ME</button></a>
  73.  
  74.  
  75.  
  76.         </p>
  77.         </fieldset>
  78.     </form>
Jul 30 '14 #1
1 1533
omerbutt
638 512MB
have you been able to open another page (form.php) by clicking on the textarea in the view.php, what procedure have you followed , did you redirected your current ppage to the new page form.php, used window.popup() or used a thickbox / lighbox interface to open the new form.php page
regards,
Omer Aslam
Aug 12 '14 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Fiala | last post by:
Table A +--------+-----------+ | A-num | text | | 1 | | | 2 | | | 3 | | | 4 | | | 5 | | +--------+-----------+
1
by: Simon Wigzell | last post by:
I have a form with several different submit buttons that does different thinkgs depending which button is clicked. (All the submit buttons are named "Submit" and my form uses the asp...
6
by: cyoung311 | last post by:
I'm trying to do an automatic update of one table from another through a form. Basically, when a selection is made for an item, in this case a particular workshop, I want to get the associated...
2
by: Uwe Range | last post by:
Hi to all, I am working on a form with a combi-field on a subform. I want to give the user the opportunity to alter the list-content (which is based on a table) in a separate form. The user...
1
by: AndrewWithy | last post by:
We have an aspx page that is submitting a form that redirects to a 3rd party website to take a payment from the customer. We have had 19 instances over a 3 day period where the user never made it...
3
by: indhu | last post by:
Hi all Is it possible to insert 5 table field into single form. all the table has same values except typeof work 11 columns 6 rows i ve to display. totally 72 fields suggesstion and help...
13
by: abcdefghijklmnop | last post by:
I have a "Questions" form that reads off of a table and contains a multi-value field called "Keywords". I already know that having a multi-value field is a horrible idea, however, I am patching up a...
4
by: MichaelK | last post by:
Hello. I have all data already collected on the current page? I want to open another window with the form, fill the fields and submit that form. So basically the question is how can I fill all...
6
by: wellsfargouser | last post by:
Hey everyone, this is driving me crazy. I have a table which lists all the files users have on the server. This table is called risklist. It lists the pathname and size. The goal is to make a form...
8
stonward
by: stonward | last post by:
Greetings All. I am trying to find the syntax for an SQL Update Table instruction. They're quite straightforward it seems until you try to use variables as criteria. So, I want to update the...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.