Re: dependable combo boxes with mysql database
| From: | concept-I) | Date: | Sat, 05 Nov 2005 13:09:12 +0000 |
| Subject: | Re: dependable combo boxes with mysql database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-225157@lists.php.net to get a copy of this message | ||
It's simply a matter of echoing HTML/ JS statements in PHP. The easiest way to integrate JS into a PHP page is like this -
<?php
// PHP CODE HERE
print("<script src=""functions.js""/>")
// CONTINUE PHP CODE HERE
?>
All your JS code is to be put into the functions.js file. Watch for the correct relative path.
You could also use this method -
<?php
// PHP CODE HERE
?>
<script src="functions.js"/>
<?php
// CONTINUE PHP CODE
?>
This is all email-code. There may be some syntax errors, which you'll have to fix at your end. But the gist remains the same. I'd suggest you also spend some time reading the HTML output from your PHP code. It's the best way to learn.
Regards,
Pranav
www.concept-i.co.in
Bhoomi Vora wrote:
Hello, Thanks for the reply. But I do not know how to integrate javascript with php and mysql. I mean javascript can be written using <script language=javascript>....code....</script> and fetching data from mysql is using $query,$result and $mysql_fetch_array. I am confused how to integrate this in php page. If anybody can help on this i will highly appreciate it, otherwise if this is not the proper question for this list then i have to go for other options. Thanks and regards, Bhoomi --- "Pranav Negandhi (concept-I)" <pranav@concept-i.co.in> wrote:This might be slightly OT on this list, but here goes nothing. 1. Submit the form when the user shifts focus from D1 using Javascript's onBlur event 2. On the server side, use PHP to retrieve the values for D2 and generate the page again 3. Repeat 1 & 2 when the value of D2 changes. HTH Pranav www.concept-i.co.in Bhoomi Vora wrote:__________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.comHello All, I have a php page which contains three comboboxes.The first one will have the value from the mysql database table on page load itself. Then depending upon the value selected in thefirstcombobox the second combo box should be populated with the respective valuesfromanother mysql database table, and once again depending upon the value selected insecondcombobox the third combobox should be populated with the respective valuesfromone more different database table. I have read through mailing list and also searchedingoogle and found that it can be done with javascript onblur function but nothingisworking. Here is the code:.....d similarlyD3 should be populated on event like 'onblur' toD2.Pl. give me the exact code or proper guideline how should I accomplish this on the same page. Appreciate your replies. Thanks and regards. BJV __________________________________ Yahoo! FareChase: Search multiple travel sites inone click.http://farechase.yahoo.com-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php