Implementation of shopping cart function through php+MySQL+jQuery+Ajax-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

Implementation of shopping cart function through php+MySQL+jQuery+Ajax

Jun 15, 2018 pm 02:48 PM

html5 jquery

Recommended related mysql video tutorials: "mysql tutorial"

Database structure:

Prepare 3 files:

1.cart.php //Front-end display file

2.cart_ajax.php //Ajax processing Data

3.config.php //Database configuration

1, cart.php

&lt;pre name=&quot;code&quot; class=&quot;html&quot;&gt;&lt;?php

include &#39;config.php&#39;;
$sql = &quot;select * from cart&quot;;
$result = mysql_query($sql);
$row = array();
while($rows = mysql_fetch_array($result,MYSQL_ASSOC)){
    $row[] = $rows;
}
//print_r($row);
?&gt;
&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;zh-hans&quot;&gt;
&lt;head&gt;
    &lt;meta charset=&quot;UTF-8&quot;&gt;
    &lt;title&gt;&lt;/title&gt;
&lt;/head&gt;
&lt;body&gt;
&lt;table width=&quot;&quot; border=&quot;1&quot; cellspacing=&quot;0&quot; cellpadding=&quot;0&quot; align=&quot;center&quot;&gt;
    &lt;tr&gt;
        &lt;td&gt;商品名称&lt;/td&gt;
        &lt;td&gt;商品库存&lt;/td&gt;
        &lt;td&gt;商品单价&lt;/td&gt;
        &lt;td&gt;购买数量&lt;/td&gt;
        &lt;td&gt;小计&lt;/td&gt;
        &lt;td&gt;操作&lt;/td&gt;
    &lt;/tr&gt;
    &lt;!--遍历数据--&gt;
    &lt;?php foreach($row as $key=&gt;$val){?&gt;

    &lt;tr&gt;
        &lt;td&gt;&lt;?php echo $val[&#39;name&#39;] ?&gt;&lt;/td&gt;
        &lt;td&gt;&lt;?php echo $val[&#39;total_quantity&#39;] ?&gt;&lt;/td&gt;
        &lt;!--商品单价--&gt;
        &lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;price&quot; value=&quot;&lt;?php echo $val[&#39;price&#39;] ?&gt;&quot;&gt;&lt;/td&gt;
        &lt;td&gt;
            &lt;button onclick=&quot;minusCart(this, &#39;&lt;?php echo $val[&#39;id&#39;] ?&gt;&#39;)&quot;&gt;-&lt;/button&gt;
            &lt;!--购买数量--&gt;
            &lt;input type=&quot;text&quot; name=&quot;num&quot; value=&quot;&lt;?php echo $val[&#39;num&#39;] ?&gt;&quot; max=&quot;&lt;?php echo $val[&#39;total_quantity&#39;] ?&gt;&quot; /&gt;
            &lt;button onclick=&quot;plusCart(this, &#39;&lt;?php echo $val[&#39;id&#39;] ?&gt;&#39;)&quot;&gt;+&lt;/button&gt;
        &lt;/td&gt;
        &lt;!--小计价格  --&gt;
        &lt;td&gt;&lt;input type=&quot;text&quot; name=&quot;subtotal_price&quot; value=&quot;&lt;?php echo $val[&#39;price&#39;]*$val[&#39;num&#39;];?&gt;&quot; onclick=&quot;price()&quot;&gt;&lt;/td&gt;
        &lt;td&gt;&lt;button&gt;编辑&lt;/button&gt;&lt;button&gt;删除&lt;/button&gt;&lt;/td&gt;
    &lt;/tr&gt;

    &lt;?php }?&gt;

    &lt;tr&gt;
        &lt;!--总价--&gt;
        &lt;td&gt;总价&lt;/td&gt;
        &lt;td colspan=&quot;4&quot;&gt;0元&lt;/td&gt;
    &lt;/tr&gt;
&lt;/table&gt;
&lt;!--&lt;script src=&quot;http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.4.1.min.js&quot;&gt;&lt;/script&gt;--&gt;
&lt;script src=&quot;jquery-2.1.1.min.js&quot;&gt;&lt;/script&gt;
&lt;script&gt;
    function setPrice(o) {//设置小计和总价
        var tr = o.closest(&#39;tr&#39;);
        var ipt = tr.find(&#39;input&#39;);
        ipt.filter(&#39;:last&#39;).val(parseInt(o.val()) * parseInt(ipt.eq(0).val(), 10));
        var sum = 0;
        o.closest(&#39;tbody&#39;).find(&#39;input[name=&quot;subtotal_price&quot;]&#39;).each(function () { sum += parseInt(this.value, 0) || 0; })
            .end().find(&#39;td:last&#39;).html(sum+&#39;元&#39;)
    }
    //减
    function minusCart(_this, id){
        var num_input = $(_this).next(&#39;input[name=&quot;num&quot;]&#39;);
        var num = parseInt(num_input.val());
        num--;
        if(num &lt;= 0){
            return false;
        } else {
            num_input.val(num);
            setPrice(num_input);
            cartNum(num_input, id, num);
        }
    }
    //加
    function plusCart(_this,id){
        //获取购买数量
        var num_input = $(_this).prev(&#39;input[name=&quot;num&quot;]&#39;);
        var num = parseInt(num_input.val());
        var total_quantity = parseInt(num_input.attr(&#39;max&#39;));
        if(num &gt;= total_quantity){
            alert(&#39;库存不足&#39;);
            return false;
        }else {
            //alert(num);
            num = parseInt(num) + 1;
            num_input.val(num);
            setPrice(num_input);
            cartNum(num_input, id, num);
        }
    }

    /**
     * 修改购物车商品数量
     * @param _this
     * @param id
     * @param num
     */
    function cartNum(_this, id, num){
        $.ajax({
            type: &#39;POST&#39;,
            url: &#39;cart_ajax.php&#39;,
            data: {id: id, num: num},
            dataType: &#39;json&#39;,
            success: function (res) {
                if (res.status == 1) {
                    _this.val(num);
                }else{
                    alert(res.info);
                }
            }
        });
    }



&lt;/script&gt;
&lt;/body&gt;
&lt;/html&gt;

Copy after login

2, config.php

&lt;?php
/**
 *email:scenewood@163.com
 *name:郑小木
 */
$server = &#39;localhost&#39;;
$data = &#39;shopping&#39;;
mysql_connect($server,&#39;root&#39;,&#39;root&#39;);
mysql_set_charset(&#39;utf8&#39;);
mysql_select_db($data);

Copy after login

3 , cart_ajax.php

&lt;?php
/**
 *email:scenewood@163.com
 *name:郑小木
 */
include &#39;config.php&#39;;


//接受cart.php的数据
if ($_POST) {
    $id = $_POST[&#39;id&#39;];
    $num = $_POST[&#39;num&#39;];
    $retureInfo = array(
        &#39;status&#39; =&gt; 0,
        &#39;info&#39; =&gt; &#39;修改商品数量失败&#39;
    );
    $sql = &quot;UPDATE `cart` SET num=&#39;{$num}&#39; WHERE `id`={$id}&quot;;
    mysql_query($sql);
    $row = mysql_affected_rows();
    if ($row == 1) {
        $retureInfo[&#39;status&#39;] = 1;
        $retureInfo[&#39;info&#39;] = &#39;修改商品数量成功&#39;;
    }
    echo json_encode($retureInfo);
}

Copy after login

This article explains how to implement the shopping cart function through php MySQL jQuery Ajax. For more related content, please pay attention to the php Chinese website.

Related recommendations:

How to deploy php mysql apache through linux system Related operations

##Nginx PHP Mysql environment setup under Linux Process explanation

Nginx PHP Mysql environment setup process explanation under Linux

The above is the detailed content of Implementation of shopping cart function through php+MySQL+jQuery+Ajax. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn