dybalabj
Last Activity: Dec 28 '07, 12:19 AM
Joined: Nov 18 '07
Location:
-
Thanks again for your help so far. In the interest of time, I've decided to drop the autofill feature as it is, and break the form up into 3 different submissions: get customer info, get price info, and add invoice to database. The first 2 technically reload the form, but keep the already entered data, plus adding the information from the query. It may not be the most responsive and efficient solution, but it works well enough for the purposes... -
I apologize for not reading the notice about posting homework problems. I did not mean to give the impression I am trying to get this work done for me. I am just trying to learn how to properly code this solution, and unfortunately the only teachers I can go to don't know much more than I do and haven't been much help. I'm more just trying to learn to proper syntax for what I want to accomplish, not have someone do the work for me. I will certainly...Leave a comment:
-
I tried making most of the changes you suggested except for the loop idea, but nothing is getting updated in my form at this point. For now I'd like to focus on the customer section, then once that's working I can go back to the product lines.
Btw, this is for a school project in my Databases course, and I need a working demo by Friday, Nov 30 :)
Anyway, here's the form for the customer info:
[PHP]<form action="studio_ update.php"...Leave a comment:
-
Ajaxrand,
Thanks so much for your help. I apologize in advance for posting so much code, but you asked for it :)
Here is the segment of code for the product lines in the form:
[PHP]$i=1;
echo "<script src='autofill_p rice.js'></script>";
while($i<=5){
echo "$i";
echo "<input type='text' size=5 name='quantity$ i'>   ";...Leave a comment:
-
If possible, I'd like to do this with pure PHP, but if it's easier to do w/ php-ajax I'm certainly willing to learn it. As for the document.getEle mentByID() line in your last post, would those go in the stateChanged() function in the javascript file from the examples on w3schools? Or would those go in the php file after my sql query returns my results?
Thanks,
Dybs...Leave a comment:
-
Ajaxrand,
Thanks again for your help. Just to make sure I understand that that example is doing:
1. The <span> tags are placeholders to individual fields, and I can arrange them wherever I need to, they don't necessarily have to be on separate lines, like the <div> tags seem to do.
2. In the PHP page in the example, for the line:
[PHP]echo "<firstname >" . $row['FirstName']...Leave a comment:
-
OK, It's almost working perfectly now :) I used that tutorial from w3schools and I now have the product and customer info updating correctly, but not quite in the right locations on the page. I think the problem has to do with the placeholder from the <div> tag. I have 2 of these: one for the customer towards the top of the page, another further down for each product line. Here's the code for the customer info:
[PHP]<?php...Leave a comment:
-
Ajaxrand,
Thanks for the info. It looks to be almost exactly what I need. However, it only looks to fill the info into a table format. I'd like the info to go into text boxes that the user can edit (say, if the customer moves and needs to change a phone number or something). The only way I know to specify a value in a text box is when it's created by <input type="text" value="somethin g>. Is there anywhere...Leave a comment:
-
PHP autofill text box from MySQL
I realize this should probably be a simple solution, but I have only been learning PHP and MySQL for a couple weeks. I am attempting to write an invoicing system that uses a MySQL database to store invoices, product pricing, and customer contact info. I would like to automatically fill in the customer's contact info after typing in the first and last name, and the product pricing info after typing in the product name. From my searches I've found...
No activity results to display
Leave a comment: