473,548 Members | 2,697 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

update table field when submit the form value in another page

1 New Member
Here is my two files.. in view.php file there is a 2nd last field is Remarks..whenev er 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 1542
omerbutt
638 Contributor
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
7586
by: Fiala | last post by:
Table A +--------+-----------+ | A-num | text | | 1 | | | 2 | | | 3 | | | 4 | | | 5 | | +--------+-----------+
1
1588
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 request.form("Submit") to get the value of the button clicked) I would like another page to not only submit the form on this page - I can do that by having a...
6
6155
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 price of that workshop from the Workshop table and update my ScheduleDetails table. The tables are as follows: tblStudent StudentID LastName...
2
2479
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 can call the edit form while the main form stays open in the background (so the user gets back to the spot / record after closing the edit form).
1
2292
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 to the 3rd party site but were redirected back to the page that was submitted. These 19 instances came from only 3 users, with 2 users repeating...
3
2703
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 from u all
13
1847
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 few things in a database I did not create and there are other factors involved in my need to keep that particular multi-valued field. What I would...
4
4341
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 fields and submit the form on another window. Regards, Michael
6
2135
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 that users can open up, filter for their user id and choose one of four options for each individual record. I've built a query that runs based on a...
8
10189
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 Diameters field of my Products Table to the Diameter value on my current form, only updating the record of the ProductID from my current form. ...
0
7518
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7711
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7954
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7805
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6039
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5367
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5085
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
1
1054
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
755
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.