douliang7068 2013-03-04 18:55
浏览 33
已采纳

轮询页面重新访问PHP / AJAX

So, I thought I had this figured out, but, nope. So I could use any help here.

I have a html page. On that page I have three links. Each link representing a different piece of data. When a user clicks those links it will then post to a PHP page and carry that data to the PHP page. The PHP page will then update a database. Then, the PHP page will return the updated results BACK to the HTML page.

I know this requires JQuery, PHP, and Ajax.

Here is what I NOW have with some help from the boards:

HTML PAGE

<script src="_js/jquery-1.7.2.min.js"></script>     <!-- Linking jQuery -->
<script>                        

$(document).ready(function () {
$('.answer').click ( function (e) {
    var color = $(this).attr("data-color");
    $.ajax({
        url: 'mm.php',
        type: 'POST',
        data: '{ color: "'+color+'" }',
        success: function (res) {
            ...
        },
        error: function (jqXHR) {
            ...
        }
    })
})
                  }
</script>

<title>M&M Poll</title>

</head>

<body>
<h1>VOTE FOR YOUR FAVORITE COLOR M&M</h1>
<h2>Click the M&M to vote</h2>

<div id="wrapper">

<div id="red" data-color="red" class="answer">
<a href="#"><img src="images/red.jpg" width="100%" /></a>
</div>



<div id="blue" data-color="blue" class="answer">
<a href="#"><img src="images/blue.jpg" width="100%" /></a>
</div>


<div id="green" data-color="green" class="answer">
<a href="#"><img src="images/green.jpg" width="100%" /></a>
</div>


<div id=rvotes>
TEST
</div>

<div id=bvotes>
TEST
</div>

<div id=gvotes>
TEST
</div>

PHP Page

<?php

function showVotes()

{
 $sql = "SELECT * FROM mms";
 $result = mysql_query($sql) or die(mysql_error());
 $showresult = mysql_query("SELECT * from mms") or die("Invalid query: " . mysql_error());
   while ($row = mysql_fetch_array($showresult))
    {
     echo ("<br> M&M = ". $row["color"] . " has " . $row["votes"] . "votes <br>");
    }
}

function addVote() 

{
 $sql= "UPDATE mms SET votes = votes+1 WHERE color = 'red'";
 $result= mysql_query($sql) or die(mysql_error());
 return $result;
}

?>

I know my database works. I just need to connect the HTML/AJAX/PHP

Any help is super appreciated!!

  • 写回答

2条回答 默认 最新

  • duanchongchu5177 2013-03-04 19:22
    关注

    Well, you're almost there, just going through it piece by piece - not necessarily putting in the code for you so you can figure it out for yourself and you'll learn more.

    In your jQuery, you put in a type: 'post' which means the php file that is being called will contain data in $_POST.

    If you're not sure what is in the $_POST array - print it out.

    e.g.

    print_r($_POST);
    

    You may see an array being outputted that contains 'color'

    Next - you'll need to insert it into your function. Ideally, your function takes in parameters in addVote() - because that's what it needs to input. This will also teach you methodologies of cleaning up information that's coming into your function in the long run so you're not in risk of sql infjections.

    So a quick and dirty is:

    // you already have this function - add a parameter
    addVote ( $color ) { // blah }
    
    addVote ( $_POST['color'] );
    

    Now in your addVote() function, you aren't really a particular color in because everything is red, so you'll need to fix that.

    $sql= "UPDATE mms SET votes = votes+1 WHERE color = '$color'";
    

    Side note: You're also using mysql_query() which is btw outdated, people here will flog you if you continue using that - look up MySql PDO or mysqli (depending on who you ask). But that's a different thread.

    Through these steps, you should see that the table has been updated, the next thing is to output the results, which is where you call in your other function - showVotes();

    Hope that helps

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 C++使用Gunplot
  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)