php - how to call a sql variable in javascript selected by html onchange, canned response function -

-

what want able to:

--- have "on change" on drop list (containing table data "titles")

--- on change runs javascript function

--- javascript populates text area "message" column of data in same table corresponding title being selected in drop list.

<li><label for="frm_precan">canned response</label>             <span class="input">                                             <select id="frm_precan" name="precan" onchange="updatetext();">                             <option value="">--please select--</option>                             <?php foreach($precan_list $precan) : ?>                             <option value="<?=$precan['id'];?>"><?=$precan['name'];?></option>                             <?php endforeach; ?>                                 </select>             </span>         </li>         </ul>            <textarea style="width: 100%; margin: 0; padding: 0; border-width: 1; font-family: courier;" name="message" rows="10" id="text_area"></textarea>           <script type="text/javascript">         function updatetext()             {             var value = $("#frm_precan option:selected").text();             $('#text_area').val(value);;             }         </script>

this code, , can put selected title in text area. however, need data database according selected index of dropdown , fill textbox it. how can this?

you cannot fill textbox pure javascript. javascript works client-side , need access database on change of selection in dropdown menu. that, need recall same page on dropdown selection change. after data database, it's easy create textbox data "echo" command.

<? if (isset($_post['my_selection'])) {     $result=mysql_query("select * `table` `column`='".mysql_real_escape_string($_post['my_selection'])."'");     $row=mysql_fetch_array($result);     echo "<input type='text' value='".$row['column']."'>";     echo "<input type='text' value='".$row['column1']."'>"; } ?> <select name='my_selection'> existing select box here...

Comments

Post a Comment

Popular posts from this blog

c# - SVN Error : "svnadmin: E205000: Too many arguments" -

-
i trying reposotries using c# code process svncommand = null; var psi = new processstartinfo("svnadmin"); psi.redirectstandardoutput = true; psi.redirectstandarderror = true; psi.useshellexecute = false; psi.arguments= @"dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump"; using (svncommand = process.start(psi)) { var myoutput = svncommand.standardoutput; var myerror = svncommand.standarderror; debug.write("output :" + environment.newline + environment.newline + myoutput.readtoend() + environment.newline + "error :" + environment.newline + environment.newline + myerror.readtoend()); svncommand.close(); } when use dump command commandline svnadmin dump c:\repositories\myrepo > c:\temp\myrepodumpfile.dump it works fine when try ...
Read more

c# - Copy ObservableCollection to another ObservableCollection -

-
how copy observablecollection item observablecollection without reference of first collection? here observablecollection item value changes affecting both collections. code private observablecollection<ratemodel> _allmetalrate = new observablecollection<ratemodel>(); private observablecollection<ratemodel> _metalrateondate = new observablecollection<ratemodel>(); public observablecollection<ratemodel> allmetalrate { { return this._allmetalrate; } set { this._allmetalrate = value; notifypropertychanged("metalrate"); } } public observablecollection<ratemodel> metalrateondate { { return this._metalrateondate; } set { this._metalrateondate = value; notifypropertychanged("metalrateondate"); } } foreach (var item in metalrateondate) allmetalrate.add(item); what causing , how can solve it? you need clone object referenced item before it's a...
Read more

All overlapping substrings matching a java regex -

-
is there api method returns (possibly overlapping) substrings match regular expression? for example, have text string: string t = 04/31 412-555-1235; , , have pattern: pattern p = new pattern("\\d\\d+"); matches strings of 2 or more characters. the matches are: 04, 31, 412, 555, 1235. how overlapping matches? i want code return: 04, 31, 41, 412, 12, 55, 555, 55, 12, 123, 1235, 23, 235, 35. theoretically should possible -- there obvious o(n^2) algorithm enumerates , checks substrings against pattern. edit rather enumerating substrings, safer use region(int start, int end) method in matcher . checking pattern against separate, extracted substring might change result of match (e.g. if there non-capturing group or word boundary check @ start/end of pattern). edit 2 actually, it's unclear whether region() expect zero-width matches. specification vague, , experiments yield disappointing results. for example: string line = "xx90xx"; strin...
Read more