duanpaxin3531
2013-04-11 16:48
浏览 58
已采纳

使用表单上的php / mysql数据库查询和单选按钮实时刷新

I have a drop down list that is populated with a column “product_name” from a database “products”.

Each of these products has a finish level, “good”, “better”, “best” with a different price associated with that level. (i.e. product 1 has 3 different prices in 3 separate columns)

I would like to have radio buttons labeled “good”, “better”, “best” underneath the drop down that take the selected “product name” and look up the price in the database table associated with the selected radio button finish level and place that value into a text box underneath the radio buttons that the user can see, but obviously not edit.

I would want it to refresh in real time if the user changes the selection of the drop down menu.

This is all on a form that is submitted at the end to a php page that does some math to make an invoice.

图片转代码服务由CSDN问答提供 功能建议

我有一个下拉列表,其中填充了数据库“products”中的“product_name”列。

这些产品中的每一个都有一个完成级别,“好”,“更好”,“最好”,与该级别相关的价格不同。 (即产品1在3个单独的列中有3种不同的价格)

我希望在下拉列表下方标有“好”,“更好”,“最佳”的单选按钮 选择“产品名称”并在与所选单选按钮完成级别关联的数据库表中查找价格,并将该值放入用户可以看到的单选按钮下方的文本框中,但显然不能编辑。 \ n

如果用户更改下拉菜单的选择,我希望它能够实时刷新。

这都是在最后提交的表单上 到一个PHP页面做一些数学来制作发票。

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

2条回答 默认 最新

  • douhuan1648 2013-04-22 19:04
    已采纳

    This works:

    <?php
    //***************************************
    // This is downloaded from www.plus2net.com //
    /// You can distribute this code with the link to www.plus2net.com ///
    //  Please don't  remove the link to www.plus2net.com ///
    // This is for your learning only not for commercial use. ///////
    //The author is not responsible for any type of loss or problem or damage on using this script.//
    /// You can use it at your own risk. /////
    //*****************************************
    
    $dbservertype='mysql';
    $servername='localhost';
    // username and password to log onto db server
    $dbusername='';
    $dbpassword='';
    // name of database
    $dbname='dd';
    
    ////////////////////////////////////////
    ////// DONOT EDIT BELOW  /////////
    ///////////////////////////////////////
    
    connecttodb($servername,$dbname,$dbusername,$dbpassword);
    
    function connecttodb($servername,$dbname,$dbuser,$dbpassword)
    {
    global $link;
    $link=mysql_connect ("$servername","$dbuser","$dbpassword");
    if(!$link){die("Could not connect to MySQL");}
    mysql_select_db("$dbname",$link) or die ("could not open db".mysql_error());
    }
    //////// End of connecting to database ////////
    ?>
    
    <!doctype html public "-//w3c//dtd html 3.2//en">
    
    <html>
    
    <head>
    <title>Multiple drop down list box from plus2net</title>
    
    
    
    
    <SCRIPT language=JavaScript>
    
    function reload(form)
    {
    var val=form.cat.options[form.cat.options.selectedIndex].value;
    self.location='dd.php?cat=' + val ;
    }
    
    </script>
    
    
    
    
    </head>
    
    <body>
    <?
    
    /*
    If register_global is off in your server then after reloading of the page to get the value of cat from query string we have to take special care.
    To read more on register_global visit.
    http://www.plus2net.com/php_tutorial/register-globals.php
    */
    
    
    @$cat=$_GET['cat']; // Use this line or below line if register_global is off
    if(strlen($cat) > 0 and !is_numeric($cat)){ // to check if $cat is numeric data or     not. 
    echo "Data Error";
    exit;
    }
    
    
    //@$cat=$HTTP_GET_VARS['cat']; // Use this line or above line if register_global is off
    
    ///////// Getting the data from Mysql table for first list box//////////
    $quer2=mysql_query("SELECT DISTINCT category,cat_id FROM category order by category"); 
    ///////////// End of query for first list box////////////
    
    /////// for second drop down list we will check if category is selected else we will display all the subcategory///// 
    if(isset($cat) and strlen($cat) > 0)
        {
    $quer=mysql_query("SELECT DISTINCT subcategory FROM subcategory where cat_id=$cat order by subcategory"); 
    }
    else
    {
    $quer=mysql_query("SELECT DISTINCT subcategory FROM subcategory order by subcategory");
    } 
    ////////// end of query for second subcategory drop down list box     ///////////////////////////
    
    
    echo "<form method=post name=f1 action='dd-check.php'>";
    /// Add your form processing page address to action in above line. Example  action=dd-check.php////
    
    
    //////////        Starting of first drop downlist /////////
    echo "<select name='cat' onchange=\"reload(this.form)\"><option value=''>Select one</option>";
    
    while($noticia2 = mysql_fetch_array($quer2))
    { 
    if($noticia2['cat_id']==@$cat)
    {
    echo "<option selected value='$noticia2[cat_id]'>$noticia2[category]</option>"."<BR>";
    }
    else
        {
        echo  "<option value='$noticia2[cat_id]'>$noticia2[category]</option>";
        }
    }
    echo "</select>";
    //////////////////  This will end the first drop down list ///////////
    
    
    
    //////////        Starting of second drop downlist /////////
    echo "<select name='subcat'><option value=''>Select one</option>";
    
    while($noticia = mysql_fetch_array($quer)) 
        { 
        echo  "<option value='$noticia[subcategory]'>$noticia[subcategory]</option>";
        }
    
    echo "</select>";
    //////////////////  This will end the second drop down list ///////////
    
    
    
    //// Add your other form fields as needed here/////
    
    
    
    echo "<input type=submit value=Submit>";
    echo "</form>";
    ?>
    
    <center><a href='http://www.plus2net.com'>PHP SQL HTML free tutorials and scripts</a>     
    </center> 
    </body>
    
    </html>
    
    点赞 评论
  • douli0531 2013-04-11 17:24

    There is way too much background knowledge needed, to answer this in a single question.

    You should start off by getting to know javascript. There is a good tutorial here: http://www.w3schools.com/js/

    When you have a good feeling for that, learn about AJAX here: http://www.w3schools.com/ajax/default.asp

    You should probably look for the onChange events on the controls affected (radio buttons and dropdown) and fire an AJAX call when one of the values changes, which will give you the result you would like to put in the third input field.

    Hope this helps you :)

    点赞 评论

相关推荐 更多相似问题