Home  >  Article  >  Backend Development  >  Example explanation of how to implement shopping cart function in PHP

Example explanation of how to implement shopping cart function in PHP

迷茫
迷茫Original
2017-03-26 10:32:178409browse

The first is a few simple login pages

<body>
<form action="chuli.php" method="post">
    <p style="margin-left: 500px; margin-top: 200px;
     height: 250px; width: 250px; border: 1px dashed black">
        <p style="margin-left: 100px; "><h3>登录</h3></p>
        <p style="margin-top: 20px">用户名:<input type="text" name="uid"/></p><br/>
        <p>密 码:<input type="password" name="pwd"/></p><br/>
        <p style="margin-left: 180px"><input type="submit" value="登录"/></p>
    </p>

</form>
</body>

After the login page is written, you need to enter the processing page and retrieve the user name and password from the database:

<?php
session_start(); //开启session 必须要写到第一行
header("Content-type:text/html;charset=utf-8");

$uid=$_POST["uid"];    //从登录页面获取到用户名和密码
$pwd=$_POST["pwd"];

include("DADB.class.php");
$db=new DADB();

$sql="select password from login where username=&#39;{$uid}&#39;";
$arr=$db->Query($sql);

if($arr[0][0]==$pwd && !empty($pwd)) //判断所填写的密码和取到的密码是一样的,而且密码不能为空
{
    $_SESSION["uid"]=$uid;
    header("location:main.php");
}
else
{
    echo"登录失败";
}

This shows the login Page

Now we are going to the main page. We will retrieve all the fruit information from the database, and then we will implement the function of adding to the shopping cart.

<h2>大苹果购物网</h2>
<?php
session_start();
include("DADB.class.php");
$db=new DADB();
?>
<table border="1" width="100%" cellpadding="0" cellspacing="0">
    <tr>
        <td>代号</td>
        <td>水果名称</td>
        <td>水果价格</td>
        <td>原产地</td>
        <td>货架</td>
        <td>库存量</td>
        <td></td>
    </tr>
    <?php

    $uid=$_SESSION["uid"];

    $sql="select * from fruit";
    $arr=$db->Query($sql);
    foreach($arr as $v)
    {
        echo"<tr>
        <td>{$v[0]}</td>   // 从数据库调出我们所需要的内容
        <td>{$v[1]}</td>
        <td>{$v[2]}</td>
        <td>{$v[3]}</td>
        <td>{$v[4]}</td>
        <td>{$v[5]}</td>
        <td><a href=&#39;add.php?ids={$v[0]}&#39;>购买</a></td>  //这里的购买相当于添加购物车的功能 
    </tr>";
    }
    ?>

    <?php
 //这里显示的是 购物车有多少产品,和产品的总价格
    $ann=array();
    if(!empty($_SESSION["gwc"]))
    {
        $ann=$_SESSION["gwc"];
    }
    $zhonglei = count($ann); 

    $sum=0;
    foreach($ann as $k)
    {
        $sql1="select price from fruit where ids=&#39;{$v[0]}&#39;";

        $danjia=$db->Query($sql1);

        foreach($danjia as $n)
        {
            $sum=$sum + $n[0]*$k[1];
        }


    }
    echo"购物车有<mark>{$zhonglei}</mark>种商品,总价格为<mark>{$sum}</mark>元";
    ?>
</table>
<p>
<a href="gouwuche.php">查看购物车</a>
<a href="main.php">浏览商品</a>
<a href="zhanghu.php">查看账户</a> </p>

</body>

Main page display picture

The next step is to add the shopping cart page

<?php
session_start();

$ids = $_GET["ids"];


if(empty($_SESSION["gwc"]))
{
    //1.购物车是空的,第一次点击添加购物车
    $arr = array(
        array($ids,1)
    );
    $_SESSION["gwc"]=$arr;
}
else
{
    //不是第一次点击
    //判断购物车中是否存在该商品
    $arr = $_SESSION["gwc"]; //先存一下

    $chuxian = false;
    foreach($arr as $v)
    {
        if($v[0]==$ids)
        {
            $chuxian = true;
        }
    }

    if($chuxian)
    {
        //3.如果购物车中有该商品

        for($i=0;$i<count($arr);$i++)
        {
            if($arr[$i][0]==$ids)
            {
                $arr[$i][1]+=1;
            }
        }

        $_SESSION["gwc"] = $arr;
    }
    else
    {
        //2.如果购物车中没有该商品
        $asg = array($ids,1);
        $arr[] = $asg;
        $_SESSION["gwc"] = $arr;
    }

}
header("location:gouwuche.php");

Then the main shopping cart interface is as follows

<h2>购物车中有以下商品:</h2>
<table cellpadding="0" cellspacing="0" border="1" width="100%">
    <tr>
        <td>商品名称</td>
        <td>商品单价</td>
        <td>购买数量</td>
        <td></td>
    </tr>
 <?php
    session_start();
    //$uid=$_SESSION["uid"];

    $arr=array();

    if(!empty($_SESSION["gwc"]))
    {
        $arr=$_SESSION["gwc"];
    }
    include("DADB.class.php");
    $db=new DADB();

    foreach($arr as $v)
    {
        global $db;
        $sql="select * from fruit where ids=&#39;{$v[0]}&#39;";
        $att=$db -> Query($sql,1);
        foreach($att as $n)
        {
            echo"<tr>
        <td>{$n[1]}</td>
        <td>{$n[2]}</td>
        <td>{$v[1]}</td>
        <td>
b23b6e405e49a23bb94666e71faeec1d删除5db79b134e9f6b82c0b36e0489ee08edb90dd5946f0946207856a8a37f441edf
</tr>";} } ?> </table> <p> <a href="gouwuche.php">查看购物车</a> <a href="main.php">浏览商品</a> <a href="zhanghu.php">查看账户</a> </p> 14 15 </body>

 

Then we will When we get to the deletion page, we need to process when there is only one item in the shopping cart or when there is more than one item.

<?php
session_start();
$sy = $_GET["sy"];

//根据索引找到该数据
$arr = $_SESSION["gwc"];
$arr[$sy]; //要删除的数据

//如果数量不为1,数量减1
if($arr[$sy][1]>1)
{
    $arr[$sy][1] = $arr[$sy][1]-1;
}
else  //如果数量为1,移除
{
    unset($arr[$sy]);
}

$_SESSION["gwc"] = $arr; //最后存一下购物车的内容

header("location:gouwuche.php");

As for the submission page, we have to think about balance, inventory and other factors, so it is more cumbersome,

No I'm afraid, code it.

<?php
    session_start();
header("Content-type:text/html;charset=utf-8"); //防止出现乱码
$uid=$_SESSION["uid"];
//先查一下账户余额
include("DADB.class.php");
$db=new DADB();
$ysql="select account from login where username=&#39;{$uid}&#39;";
$yarr=$db->Query($ysql);
$yarr[0][0];//总额


//购物车的总价格,前面有写过

$arr=array();

if (!empty($_SESSION["gwc"]))
{
    $arr=$_SESSION["gwc"];
}
$sum=0;
foreach($arr as $v)
{
    $v[1];//购物车中产品的数量
    $psql="select price from fruit WHERE ids=&#39;{$v[0]}&#39;";
    $parr=$db->Query($psql);
    foreach($parr as $k)
    {
      $k[0];//产品的单价
        $sum+=$k[0]*$v[1];
    }
}

//判断余额是否满足购买
if($yarr[0][0]>=$sum)
{//余额满足,要判断库存
    foreach($arr as $v)
    {
        $ksql="select number from fruit where ids=&#39;{$v[0]}&#39;";
        $karr=$db->Query($ksql);
        $karr[0][0];//这是库存
        if($karr[0][0]<$v[1]) //表示库存不足,这时要给顾客提示库存不足
        {
            echo"库存不足";
            exit;
        }
    }

    //判断之后需要提交订单了
    //账户扣除余额
    $kcsql="update login set account=account-{$sum} where username=&#39;{$uid}&#39;";
    $db->Query($kcsql,0);//这里是修改语句,所以要加上0

    //扣除库存
    foreach($arr as $v)
    {
        $kcksql="update fruit set number=number-$v[1] where ids=&#39;{$v[0]}&#39;";
        $db->Query($kcksql,0);
    }

//所有的工作都做完了,这时我们就该提交订单了
// 这里我在数据库中做了两张表,把提交的订单添加到表中就可以保存了

//添加订单
$ddh = date("YmdHis");
$time = date("Y-m-d H:i:s");
$sdd = "insert into orders values(&#39;{$ddh}&#39;,&#39;{$uid}&#39;,&#39;{$time}&#39;)";
$db->Query($sdd,0);

//添加订单详情
    foreach($arr as $v)
    {
        $sddxq = "insert into orderdetails values(&#39;&#39;,&#39;{$ddh}&#39;,&#39;{$v[0]}&#39;,&#39;{$v[1]}&#39;)";
        $db->Query($sddxq,0);
    }
}

else
{
    echo "余额不足";
    exit;
}

?> 

##It’s no problem to implement the function

The above is the detailed content of Example explanation of how to implement shopping cart function in PHP. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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