Forum:

HTML Pages with CSS and JavaScript

Javascript and PHP

Ranch Hand

Posts: 79

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

hi ranches....

this may be a simple problem but am stucked how to proceed forward since am new to php and javascript...
i need to use selected value from the list box as a condition to a mysql query..
for example, i have database as follows

+----------------+----
| Name | Number |
+---------------+----
| sun | 3882
| sun | 3888
| sun | 3899
| ram | 3053
| ler | 3233
| ler | 3321
| ler | 3323
| sam | 3677
| joe | 3766
| scs | 3688
| kris | 3044

am just making a list box which consists of above names...
now when the user selects any of the name then i want the text box to be automatically filled by the numbers related to tat names...
i have tried below code. but i don know how to pass the selected value to next query which fetches the number..

can anyone help me giving some idea or sample code??

thank you.

Maya Naga

Ranch Hand

Posts: 79

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

can anyone give suggestion how to do that?
thanks

Eric Pascarello

author

Posts: 15385

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Look up Ajax double combo or linked selects.

Eric

Eric Pascarello

author

Posts: 15385

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

If you were using jQuery it is as simple as

And you php page would just return back

Eric

Maya Naga

Ranch Hand

Posts: 79

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

hi ,
i have solved getting the selected combo value and passing it to another mysql query. am getting the result.
but now i need to pass these values to textfield.
here is my code;

<html>
    <head><title> Testing </title> </head>
    <body>
        <form method="post">
            <p> Choose group </p>
            <p>
                <label for="Group">Group</label>
                <?php
                    $dbname='callreader';
                    $db_user='root';
                    $db_pass='';
                    $host='localhost';
                    $conn = mysql_connect($host, $db_user, $db_pass);
                    mysql_select_db($dbname);
                    $query="select distinct Name from billing_numbers";
                    $result=mysql_query($query,$conn) or die(mysql_error());
                    if($result)
                    {
                ?>
                <select id="Name" name="Name">
                <?php
                        while($row=mysql_fetch_assoc($result))
                        {
                            echo '<option value="'.$row['Name'].'">'.$row['Name'].'</option>';
                        }
                ?>
                </select>
                <?php
                    }
                ?>          
                <input type="submit" value="submit" />
            </p>
        </form>
        <?php
            if(isset($_POST['Name']))
            {
                $query="select Number from billing_numbers where Name='".$_POST['Name']."'";
                $result=mysql_query($query,$conn) or die(mysql_error());
                    echo '<b>';
                    echo "Group Name:" . $_POST['Name'] . "\n<br/>";
                    echo "Numbers:\n<br/>";
                    echo '<b/>';
                if($result)
                {                    
                    while($row=mysql_fetch_assoc($result))
                    {
                        echo $row['Number']."<br/>";
                    }                    
                }
            }
        ?>      
    </body>
</html>

actually this is a part of my application. my home page code would be as follows:

<html>
    <head>
        <title>Call Reader</title>
        <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
        <link type="text/css" rel="stylesheet" href="calendar.css">
        <link rel="stylesheet" type="text/css" media="all" href="themes/aqua.css" title="Calendar Theme-aqua.css" >
        <script type="javascript" src="choosedate.js"></script>
        
        <script type="text/javascript" src="src/utils.js"></script>
        <script type="text/javascript" src="src/calendar.js"></script>
        
        <script type="text/javascript" src="lang/calendar-en.js"></script>
        
        
        <script type="text/javascript" src="src/calendar-setup.js"></script>
    </head>
    <body onload=top()>
        <center>

<form name=callsubm method="get" onsubmit="return DoSubmit();" action="outgoing.php" >
                <table border="0" >
                    <tr >
                        <td align="right">
                            From Date</td>
                        <td align="center" > 
                            <input style="border-style: none;" type="text" name="beg" id="beg" size="15" ></td>
                        <td><img src="calender" alt="C" id='img1'>
                            <script language=javascript type="text/javascript">
                                var cal = new Zapatec.Calendar.setup({
                                    inputField:"beg",
                                    ifFormat:"%d-%m-%Y ",
                                    button:"img1",
                                    showsTime:false
                                });
                            </script>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            End Date</td>
                        <td > 
                            <input style="border-style: none;" type="text" name="datEnd" id="datEnd" size="15" ></td>
                        <td><img src="calender" alt="C" id='img2'>
                            <script language=javascript type="text/javascript">
                                var cal = new Zapatec.Calendar.setup({
                                    inputField:"datEnd",
                                    ifFormat:"%d-%m-%Y ",
                                    button:"img2",
                                    showsTime:false
                                });
                            </script>
                        </td>

</tr>
                    <tr>
                        <td>
                            Time</td>
                        <td > 
                            <input  style="border-style: none;" name=time id=time type="text" size="15"></td>
                        <td><input type="image" id=time name=time src="Time.png"></td>
                    </tr>
                    <tr>
                        <td>
                            Extension</td>
                        <td > 
                            <input  style="border-style: none;" name=inTxt id=inTxt type="text" size="15"></td>
                        <td><input type="image" id=callBtn name=callBtn src="phone.png"  ></td>
                    </tr>
                </table>
		//here is were i need to implement that code and have to pass the result to above textfield 'inTxt'
           <?php
            $dbname='callreader';
            $db_user='root';
            $db_pass='';
            $host='localhost';
            $conn = mysql_connect($host, $db_user, $db_pass);
            mysql_select_db($dbname);
            //$result = mysql_query($query, $connection) or die('Dynamic query function: error making query');
            $sql = mysql_query("SELECT distinct Name FROM billing_numbers ",$conn);
           ?>
                <select class="style01" style="width:9em;" id="intercom" name="intercom" onchange="PrintCombo(document.forms[0])" style="font-size:12px;color:#006699;font-weight: bold;font-family:verdana;background-color:#ffffff;" >
           <?php
            while ($row = mysql_fetch_array($sql))
            {
                echo "<option value='$row[Name]'>$row[Name]";
                echo $_GET['Name']==$row['Name'] ? 'selected' : '';
                echo '</option>';
                $var=$row[Name];
            }
            ?>
            </select>
             <br/><br/>
                <table>
                    <tr align="center">
                        <td align="center">Single </td>
                        <td><input class="submit" type=radio  id=optSingle name=optSingle onclick=selectpage(name)>
                        </td>
                        <td>Datewise </td>
                        <td><input class="submit" type=radio checked id=optDat name=optDat onclick=selectpage(name)>
                        </td>
                    </tr>
                </table>
                <input TYPE=HIDDEN NAME="pageNum" value="1">
                <input TYPE=HIDDEN NAME="rowsPerPage" value="10">
            </form>
        </center>
    </body>
    <script type="text/javascript">
        function PrintCombo(form) {
                //If you use the options value attribute for course fees
                var item=form.intercom.selectedIndex;
                var Result=form.intercom.options[item].text;
                //var view=form.course.value;
                //alert($view);
                // document.write(resu);
                form.inTxt.value = Result;
                //location.href="SampleValidate.php?Result=" + Result;
            }
        function DoSubmit()
        {
            if(document.callsubm.datEnd.value=="")
            {
                document.callsubm.datEnd.value=document.callsubm.beg.value;
            }

if (document.callsubm.inTxt.value=="")
            {
                alert ("Please enter extension number");
                document.callsubm.inTxt.focus();
                return false;
            }
            else
                {
                    return true;
                }

}
        function selectpage(value)
        {
            if(value=='optSingle')
            {
                callsubm.optDat.checked=!callsubm.optDat.checked;
            }
            if(value=='optDat')
            {
                callsubm.optSingle.checked=!callsubm.optSingle.checked;
            }
        }
    </script>
</html>

can anyone help how to pass the result value to textfield...[is it possible without using ajax]
thanks in advance.

Maya Naga

Ranch Hand

Posts: 79

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

hi ranches...

my doubt is whether we can pass the query result '$no' directly to javascript variable to fill in the textbox using onchange() function. i dono how to pass this value. i tried the below code but its not working. please someone say how to proceed. i need the query result value to be displayed in textfield when user selects item from combobox.

function PrintCombo(value) 
             {
                 alert("hi");
                form.numbers.value =value;            
             }

<?php
                echo "<select id='Name' name='Name' onchange='PrintCombo('$no')';>";
                        while($row=mysql_fetch_assoc($result))
                        {
                            echo '<option value="'.$row['Name'].'">'.$row['Name'].'</option>';
                        }
                        echo '</select>';
                ?>
                
                <?php
                    }
                ?>          
                <input type="submit" value="submit" />
            </p>
       
        <?php
            if(isset($_POST['Name']))
            {
                $query="select Number from billing_numbers where Name='".$_POST['Name']."'";
                $result=mysql_query($query,$conn) or die(mysql_error());
                    echo '<b>';
                    echo "Group Name:" . $_POST['Name'] . "\n<br/>";
                    echo "Numbers:\n";
                    echo '<b/>';
                if($result)
                {                    
                    while($row=mysql_fetch_assoc($result))
                    {
                        $no=$row['Number'];
                       // echo $no."<br/>";
                       $var='PrintCombo("'.$no.'")';
                    }                    
                }
            }
        ?>
            <input type="text" name="numbers" value="<?php echo $no; ?>" />

Eric Pascarello

author

Posts: 15385

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Shouldn't

be

Eric

Maya Naga

Ranch Hand

Posts: 79

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

thanks eric..
but when i used to pass the variable $total_numbers through onchange function, the alert results as "hi undefined"...
how to pass the result value $total_numbers to textbox through onchange function.. here is my code which shows result in textbox when submit button is cliked..
please is any other way to solve this?

Eric Pascarello

author

Posts: 15385

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Sounds like you are mixing up php and JavaScript. The php code will not run once the page has been completely rendered.

If you want to pass the selected value with JavaScript it would be just

Eric

Maya Naga

Ranch Hand

Posts: 79

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

thanks eric..
i solved this problem by just giving document.form.submit();
its just works fine....

And then we all jump out and yell "surprise! we got you this tiny ad!"

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser