PHP购物网站(含购物车、全部源码、数据库设计表及其源码)

PHP购物网站(含购物车、全部源码、数据库设计表及其源码)这是我在研究生期间 老师要求做的一个类似原始淘宝网的购物网站 因为不会 PHP 为了写这个作业而新学的 做这个网站用了两周时间 在此把这个小项目做一个总结 功能 DONE 用户权限管理 包括管理员和普通用户 管理员有所有权限 包括更新网站状态登录的其他值为用户名和密码 用户名和密码正确 跳转到下一页 ADMIN 具有添加 删除 更新等权限 用户只能查看手机 只能添加到购物车

声明!

最近几个月,不断地有站友向我索要完整的代码,其实之前我是全部粘贴到博客里供大家参考交流的。之所以删掉一部分,是因为有一些网站全盘照抄并标明为原创,以抄袭获取流量甚至盈利,违背了我的初衷。

感谢各位不嫌弃我的代码粗陋。如果还有站友想要源代码,请在这篇博客下留下自己的联系方式。但是再次声明,之前和今后私下从我这里以任何方式要走的代码,都不能用作商业用途!

请勿转载!

谢谢!

还是有很多值得改进的地方。

功能:

DONE. 用户权限管理。包括管理员和普通用户。管理员有所有权限,包括更新网站状态
登录的其他值为用户名和密码,用户名和密码正确,跳转到下一页。
ADMIN具有添加,删除,更新等权限。用户只能查看手机,只能添加到购物车中的手机等。




DONE.新用户:此模块适用于没有帐户的用户。这里用户可以创建一个帐户来登录。账户的创建是通过填写注册表单和用户的详细信息,如姓名,电话,电子邮件等来完成的。

DONE.产品管理和展示:该模块展示手机产品信息,如产品编号,项目,名称,类别,产品图像,说明,功能和产品限制等。所有这些都将输入到数据库,因此可以在网站上找到。

DONE.搜索:该模块可帮助客户根据自己的预算或兴趣来放松搜索。搜索可以在不同的类别上完成,如品牌,型号名称,型号,颜色或价格等。

DONE:交易:在此模块中,购物车的管理已完成。此模块购物者可以选择任意数量的物品(手机,配件)并将它们添加到购物车,在从购物车购买物品后,所有要购买的物品都可以再次查看。如果他以后不喜欢,购物者也可以从购物车中取出。购物者还可以逐一检查购物车中保存的产品。由于产品从购物车中检出,总价格将相加。

DONE:装运:在这个模块中,购物者可以选择合适的装运选项。购物者可以使用不同服务提供商提供的各种运送选项。

DONE:付款:该模块描述了客户完成的付款。购物者可以选择不同的支付方式,并根据所选的支付方式的要求提供机密的支付信息。付款信息还可能包括购买型号,数量和供应商名称等信息。

DONE:报告:在此模块中,将生成所有报告。无论何时出售物品或客户订购产品,都应立即通过电子邮件向其供应商发送警报,以便他可以尽快装运该物品。该模块有3个子模块;股票报告,订单报告和交付报告。

  • 股票报告将生成可用产品数量和产品状态的报告。
  • 订单报告将列出订购的产品清单以及购买该产品的客户详细信息,这些信息未送达。
  • 交付报告将生成已售出产品清单及其交付状态。

Design ideas of relational schema:
Since the website will not be too complex, so I just design basic fields of the whole website logic. As for the tables “order_info” and “orderDetailRecord_info”, I separate order information into two tables to solve the problem that one order may have two types of products. Plus, the “p_image_url” field in the table “product_info”, will be used for analyzing url of images of products. Plus plus: actually an order may conclude many products, every products may choose different delivery method, but here we simplify it and assume that an order only have one delivery method.

附上刚开始创建数据表的mysql代码,后期自此基础上有一些修改

`admin_info(admin_id,admin_name,admin_pwd)` CREATE TABLE IF NOT EXISTS admin_info( admin_id int(10) NOT NULL AUTO_INCREMENT, admin_name varchar(50) NOT NULL, admin_pwd varchar(50) NOT NULL, PRIMARY KEY(admin_id) ); `user_info(u_id,u_name,u_pwd,u_phone,u_email)` CREATE TABLE IF NOT EXISTS user_info( u_id int(10) NOT NULL AUTO_INCREMENT, u_name varchar(50) NOT NULL, u_pwd varchar(50) NOT NULL, u_phone int(50) NOT NULL, u_email varchar(50) NOT NULL, PRIMARY KEY(u_id) ); `product_info(p_id, p_name,p_brand, p_type,p_price,p_inventory,p_descr,p_color,p_image_url)` CREATE TABLE IF NOT EXISTS product_info( p_id int(10) NOT NULL AUTO_INCREMENT, p_name varchar(50) NOT NULL, p_brand varchar(50) NOT NULL, p_type int(50) NOT NULL, p_price varchar(50) NOT NULL, p_inventory varchar(50) NOT NULL, p_descr varchar(100) NOT NULL, p_color varchar(50) NOT NULL, p_image_url varchar(200) NOT NULL, PRIMARY KEY(p_id) ); `payment_info(pay_id,pay_user,receive_user,pay_account,receive_account,pay_status)` CREATE TABLE IF NOT EXISTS payment_info( pay_id int(10) NOT NULL AUTO_INCREMENT, pay_user varchar(50) NOT NULL, receive_user varchar(50) NOT NULL, pay_account int(50) NOT NULL, receive_account int(50) NOT NULL, pay_status boolean NOT NULL, PRIMARY KEY(pay_id) ); `delivery_info(d_id,d_company,d_init_add,d_trgt_add,d_price)` CREATE TABLE IF NOT EXISTS delivery_info( d_id int(10) NOT NULL AUTO_INCREMENT, d_company varchar(50) NOT NULL, d_init_add varchar(50) NOT NULL, d_trgt_add varchar(50) NOT NULL, d_price varchar(50) NOT NULL, PRIMARY KEY(d_id) ); `order_info(o_id,u_id,d_id,o_date,pay_id)` CREATE TABLE IF NOT EXISTS order_info( o_id int(10) NOT NULL AUTO_INCREMENT, u_id int NOT NULL, d_id int NOT NULL, o_date int(50) NOT NULL, pay_id int NOT NULL, PRIMARY KEY(o_id), FOREIGN KEY (u_id) REFERENCES user_info(u_id), FOREIGN KEY (d_id) REFERENCES delivery_info(d_id), FOREIGN KEY (pay_id) REFERENCES payment_info(pay_id) ); `orderDetailRecord_info(r_id,o_id,p_id,p_num)` CREATE TABLE IF NOT EXISTS orderDetailRecord_info( r_id int(10) NOT NULL AUTO_INCREMENT, o_id int NOT NULL, p_id int NOT NULL, p_num int(50) NOT NULL, PRIMARY KEY(r_id), FOREIGN KEY (o_id) REFERENCES order_info(o_id), FOREIGN KEY (p_id) REFERENCES product_info(p_id) ); `stock_info(s_id,p_id,p_inventory)` CREATE TABLE IF NOT EXISTS stock_info( s_id int(10) NOT NULL AUTO_INCREMENT, p_id int(10), p_inventory int(50), PRIMARY KEY(s_id), FOREIGN KEY(p_id) REFERENCES product_info(p_id) ); 
 
   
   Phones on saling 
   

Phones on saling!

Sign in the website.

Login into the website.





chooseCharacter.html

 
   
   Sign in to phone website 
   

Choose your charactor

Please choose which kind of charactor you want to sign in?




chooseCharacter.php
//选择相应的角色后,会跳转到不同角色的注册界面

 Choose charactor 
   
 
   
   Sign in to phone website as admin user 
   

Sign in

User name:
User password:
Confirm user password:
Invitation number:












If you have already signed in, please click here to login.
Login into the website.


adminSign.php
//处理管理员注册请求

 Sign in the phone web as admin user, success! 
   
 
   
   Sign in to phone website 
   

Sign in

User name:
User password:
Confirm user password:
Phone:
Email:















sign.php
//处理用户注册请求,收集基本信息并加入到数据库。如果存在数据缺失,则不能注册,对两次输入的密码做了基本的检测,并检测邮箱格式的正确性。
//注册后会跳转到login.php界面,但是因为普通用户注册后,会自动为当前用户登录,并在当前的cookie中存储用户登录的状态,因此不需要再登录一次,可以直接由网页链接跳转到手机购买界面。




 
   
   Sign in sucess! 
    
    
  
 
   
   Login in to phone website 
    
   

User Login



Click here to buy phones.

User name:
User password:















process_login.php处理登录请求

 
  "; } if($userName == ""||$pwd == ""){ echo "None of the value can be empty!"; echo " 
"; } //declare the sql var and decides the value //$sql; if($selected_Charactor == "admin"){ $sql = "SELECT admin_id FROM admin_info WHERE admin_name = '" . $userName . "' and admin_pwd = '". $pwd ." ' ;" ; $result = executeSql($sql); if ($result[0]) { header('Location: p_manage.php'); } else { echo "Error! Something wrong in your username or password!"; echo "
"; } }else if($selected_Charactor == "user"){ $sql = "SELECT u_id FROM user_info WHERE u_name = '" . $userName ."' and u_pwd = '".$pwd."' ;" ; $result = executeSql($sql); if($result[0]){ setcookie('login_status',true); while ($row = mysqli_fetch_assoc($result[1])){ $u_id=$row["u_id"]; setcookie('u_id',$u_id); } header('Location: showPhones.php'); }else{ echo "Error! Something wrong in your username or password!"; echo "
"; } } ?>








 Add new product  

Hello admin user, you can add a new product into database!

Product Name Product Brand Product Type Product Price Product Inventory Product Description Product Color Product Url

add_product.php
//处理增加请求

 Add new product 
  "; }else{ $servername = "localhost"; $username = "root"; $password = ""; $dbname = "hw"; // 创建连接 $conn = new mysqli($servername, $username, $password, $dbname); // 检测连接 if ($conn->connect_error) { die("Fail to connect!: " . $conn->connect_error); } //执行sql语句 if ($conn->query($sql) === TRUE) { $flag = TRUE; } else { echo "Error: " . $sql . " 
" . $conn->error; } $conn->close(); return $flag; } } $p_name=$_POST["name"]; $p_brand=$_POST["brand"]; $p_type=$_POST["type"]; $p_price=$_POST["price"]; $p_inventory=$_POST["inventory"]; $p_descr=$_POST["descr"]; $p_color=$_POST["color"]; $p_image_url=$_POST["url"]; if($p_name ==""||$p_brand ==""||$p_type ==""||$p_price ==""||$p_inventory ==""||$p_descr ==""||$p_color ==""){ echo "You can not provide empty values!"; }else{ $sql = "INSERT INTO product_info(p_name,p_brand,p_type,p_price,p_descr,p_color,p_image_url) VALUES ('".$p_name."','".$p_brand."','".$p_type."','".$p_price."','".$p_descr."','".$p_color."','".$p_image_url."');"; $result = executeSql($sql); if($result){ $servername = "localhost"; $username = "root"; $password = ""; $dbname = "hw"; // 创建连接 $conn = mysqli_connect($servername, $username, $password, $dbname); // Check connection if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $select_sql = "SELECT * FROM product_info WHERE p_name = '".$p_name."';"; $result=mysqli_query($conn,$select_sql);//result is a PHP array var_dump($result); $num_rows=mysqli_num_rows($result); //echo $num_rows; mysqli_close($conn); while ($row = mysqli_fetch_assoc($result)){ $p_id=$row["p_id"]; $insert_sql = "INSERT INTO stock_info(p_id,p_inventory) VALUES (".$p_id.",".$p_inventory.");"; $feedback = executeSql($insert_sql); if($feedback){ header("location:p_manage.php"); } } } } ?>






 
   
   Read product information from database 
    
   

Welcome! Admin user. This is the page of Product Management.

'; echo '
"; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; //$image = 'https://cdn2.gsmarena.com/vv/pics/apple/apple-iphone-x-new-1.jpg'; $imageData = base64_encode(file_get_contents($p_image_url)); //var_dump($imageData); //echo ' '; //echo ' '; //echo " "; ?> "; $i++; } mysqli_close($conn); ?>
Product ID Product Name Product Brand Product Type Product Price Product Inventory Product Description Product Color Product Image Delete Product
".$p_id."".$p_name."".$p_brand."".$p_type."".$p_price."".$p_inventory."".$p_descr."".$p_color."[外链图片转存失败(img-WDPS9q7a-95)(data:image/jpeg;base64,'.$imageData.')]Delete








4.用户购买手机

showPhones.php
//代码和p_manage.php类似,有些功能类似或重合

 
   
   Product information 
    
   

Welcome! You can buy your own phone here.

"; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; //$image = 'https://cdn2.gsmarena.com/vv/pics/apple/apple-iphone-x-new-1.jpg'; $imageData = base64_encode(file_get_contents($p_image_url)); //var_dump($imageData); echo ' '; ?> "; $i++; } mysqli_close($conn); ?>
Product Name Product Brand Product Type Product Price Product Inventory Product Description Product Color Product Image Add to Cart
".$p_name."".$p_brand."".$p_type."".$p_price."".$p_inventory."".$p_descr."".$p_color."[外链图片转存失败(img-ePhuvnsp-96)(data:image/jpeg;base64,'.$imageData.')]addCart


Enough adding, click here to shopcart.

















 All fees of shipment. 
   

2)view_shopCart.php//查看购物车

 
   
   
   Shop cart 
   

View your shop cart here.

"; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; ?> "; $singlePrice = $p_price * $goods_num; $totalPrice = $totalPrice + $singlePrice; $totalItem = $totalItem + $goods_num; setcookie("total_item",$totalItem); setcookie("phones_price",$totalPrice); } } //echo $p_info; setcookie('p_info',$p_info); ?>
Product Name Product Brand Product Price Product Description Product Color Counts Delete from Cart
".$p_name."".$p_brand."".$p_price."HKD".$p_descr."".$p_color."".$goods_num."Delete
Clear cart

Shipment


Back to add goods











购物车中会展示所有产品的信息,并计算他们的总价格。

3)delCart.php
//如果用户在查看购物车时点击删除某项产品,将该产品从购物车中全部删除

 
   

4)clearCart.php
//如果用户在查看购物车时,点击了清空购物车,将当前购物车中内容全部清空

 
  "; echo "
"; $result = session_destroy(); }else{ echo "There is no goods in shop cart!"; } echo "
"; echo $result; echo "
"; echo "
"; var_dump($_SESSION); header("location:view_shopCart.php"); ?>










 
   
   Shipment 
    
   

You have already fill the shipment information

Click here to pay

Choose your shipment way

Delivery Company Orign Location Target Location



process_shipment.php
//处理物流信息请求

 All fees of shipment. 
   
 
   
   Shop cart 
   

Total money here, please fill your payment information.


Click here to continue "; echo " "; echo " "; echo " "; echo " "; echo " "; echo ""; ?>
Total Item Phones Price Shipment Way Shipment Price Total Price
".$total_item."".$phonesPrice."".$shipment_way."".$shipment_price."".$totalPrice."

Alipay WeChatPay Credit card UnionPay
Pay user Pay account Receive user Receive account









2)pay_way.php
//将用户支付信息填入数据库表中,并跳转到pay_money.php

 
   

3)pay_money.php
//根据payInfo.php中选择的支付方式,打开相应的界面,让用户登录并付钱。
然后将订单信息全部丢给process_order.php处理
//这里有一点需要特别说明的是,因为这是一个练习,数据都是虚拟的,所以无法从支付宝或者微信,银联等获知用户支付已经支付成功,所以这里将是否已经支付的判定设置为,只要用户填写了付款信息,并点击付款,打开了支付页面,这里就在cookie中设置为已支付状态






 
  window.open('https://auth.alipay.com/login/index.htm?goto=https%3A%2F%2Fmy.alipay.com%2Fportal%2Fi.htm')";
	//$image_url = "https://www.hkelectric.com/zh/CustomerServices/PublishingImages/Alipay_Download_QR.jpg";
	//$imageData = base64_encode(file_get_contents($image_url));
	//echo '[外链图片转存失败(img-0UVbanjU-1562059529497)(data:image/jpeg;base64,'.$imageData.')]';
}else if($payWay == "WeChatPay"){
	//$image_url = "https://3.bp.blogspot.com/-ymZs4Aij_f8/WnXUq9v5Z9I/AAAAAAAAFeA/Zrnru65sDLEgGbVbJ_KevD9_izoL3YO5wCLcBGAs/s1600/wechat.jpg";
	//$imageData = base64_encode(file_get_contents($image_url));
	//var_dump($imageData);
	//echo '[外链图片转存失败(img-Ji9HZKJS-1562059529497)(data:image/jpeg;base64,'.$imageData.')]';
	echo ""; }else if($payWay == "Credit"){ echo ""; }else if($payWay == "UnionPay"){ echo ""; } setcookie('pay_status',true); $sql = "UPDATE payment_info SET pay_status=1 WHERE pay_id = ".$_COOKIE['pay_id'].";"; $result = executeSql($sql); if($result[0]){ echo "
"; echo "
"; echo "Click here to see order information."; }else{ echo "You have to pay first!"; } ?>




 Order information 
   

2)view_order.php
//查看订单信息,并给出生成报告的链接

 Order Information 
   
  "; echo " 
    "; echo " 
     "; echo " 
     "; echo " 
     "; echo " 
     "; echo " 
     "; echo " 
     "; echo " 
     "; if($pay_status){ echo " 
     "; }else{ echo " 
     "; } echo ""; echo " 
    

Order information

Order id User Tracking Number Product Price Delivery Price Total Items Total Price Payment ID Pay Status
".$o_id."".$u_id."".$tracking_num."".$phones_price."HKD".$shipment_price."HKD".$total_item."".$total_price."HKD".$pay_id."PaidNot Paid
"; echo "
"; echo "Export Product Report"; echo "
"; echo "
"; echo "Export Order Report"; echo "
"; echo "
"; echo "Export Delivery Report"; }else{ header('location:payInfo.php'); } ?>














9.导出报告

1)eOrderReport.php
//导出订单报告

 Export Report 
   

2)eStockReport.php
//导出库存报告

 Export Report 
  Host = "ssl://smtp.gmail.com"; $mail = new PHPMailer(); //实例化 $mail->IsSMTP(); // 启用SMTP //$mail->Host = "smtp.163.com"; //SMTP服务器 163邮箱例子 $mail->Host = "smtp.126.com"; //SMTP服务器 126邮箱例子 //$mail->Host = "smtp..com"; //SMTP服务器 邮箱例子 $mail->Port = 25; //邮件发送端口 $mail->SMTPAuth = true; //启用SMTP认证 $mail->CharSet = "UTF-8"; //字符集 $mail->Encoding = "base64"; //编码方式 $mail->Username = ""; //你的邮箱 $mail->Password = ""; //你的密码 $mail->Subject = "Product information updating"; //邮件标题 $mail->From = ""; //发件人地址(也就是你的邮箱) $mail->FromName = ""; //发件人姓名 $address = "";//收件人email $mail->AddAddress($address, ""); //添加收件人1(地址,昵称) //$mail->AddAttachment('xx.xls','我的附件.xls'); // 添加附件,并指定名称 $mail->IsHTML(true); //支持html格式内容 //$mail->AddEmbeddedImage("logo.jpg", "my-attach", "logo.jpg"); //设置邮件中的图片 $mail->Body = $file_stream; //邮件主体内容 //发送 if(!$mail->Send()){ echo "Fialed to send " . $mail->ErrorInfo; } else { echo "Successfully send the email!"; } } php_sendmail($file_stream); header('location:view_order.php'); ?> 
    
  

3)eDeliveryReport.php
//导出物流报告

 Export Report 
   
 
   
   Search phones 
   

Search what you want



Enter your condition here:


If you choose price, please enter the price range here:
Low range:
High range:
























2)search.php
//处理查询请求

 
  "; } if($selected_Condition == "brand"){ $value = $_POST["value"]; if($value ==""){ echo "The value can't be empty!"; echo " 
"; }else{ $sql = "SELECT * FROM product_info WHERE p_brand LIKE '%".$value."%';"; showResult($sql); } }else if($selected_Condition == "name"){ $value = $_POST["value"]; if($value ==""){ echo "The value can't be empty!"; echo "
"; }else{ $sql = "SELECT * FROM product_info WHERE p_name LIKE '%".$value."%';"; showResult($sql); } }else if($selected_Condition == "type"){ $value = $_POST["value"]; if($value ==""){ echo "The value can't be empty!"; echo "
"; }else{ $sql = "SELECT * FROM product_info WHERE p_type LIKE '%".$value."%';"; showResult($sql); } }else if($selected_Condition == "color"){ $value = $_POST["value"]; if($value ==""){ echo "The value can't be empty!"; echo "
"; }else{ $sql = "SELECT * FROM product_info WHERE p_color LIKE '%".$value."%';"; showResult($sql); } }else if($selected_Condition == "price"){ $low_range = $_POST["low_range"]; $high_range = $_POST["high_range"]; if($low_range ==""||$high_range == ""){ echo "The range can't be empty!"; echo "
"; }else{ $sql = "SELECT * FROM product_info WHERE p_price BETWEEN ".$low_range." AND ".$high_range.";"; showResult($sql); } } function showResult($sql){ $servername = "localhost"; $username = "root"; $password = ""; $dbname = "hw"; $conn = mysqli_connect($servername, $username, $password, $dbname); // Check connection if (mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $result=mysqli_query($conn,$sql);//result is a PHP array $num_rows=mysqli_num_rows($result); mysqli_close($conn); if($num_rows == 0){ echo "There is no meeted results."; }else{ echo ' '; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; $i=0; while ($row = mysqli_fetch_assoc($result)){ $p_name=$row["p_name"]; $p_brand=$row["p_brand"]; $p_type=$row["p_type"]; $p_price=$row["p_price"]; $p_descr=$row["p_descr"]; $p_color=$row["p_color"]; $p_image_url = $row["p_image_url"]; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; echo " "; $imageData = base64_encode(file_get_contents($p_image_url)); echo ' '; echo " "; $i++; } echo "
Product NameProduct BrandProduct TypeProduct PriceProduct DescriptionProduct ColorProduct Image
".$p_name."".$p_brand."".$p_type."".$p_price."".$p_descr."".$p_color."[外链图片转存失败(img-CAzDYQv5-98)(data:image/jpeg;base64,'.$imageData.')]
"; } } ?>














版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请联系我们举报,一经查实,本站将立刻删除。

发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/202208.html原文链接:https://javaforall.net

(0)
上一篇 2026年3月20日 上午7:38
下一篇 2026年3月20日 上午7:39


相关推荐

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注

关注全栈程序员社区公众号