sql;"> CREATE DATABASE book_sc; #创建book_sc数据库

USE book_sc; #使用book_sc数据库

CREATE TABLE customers #创建用户表
(
customerid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,name CHAR(60) NOT NULL,address CHAR(80) NOT NULL,city CHAR(30) NOT NULL,state CHAR(10),zip CHAR(10),country CHAR(20) NOT NULL
);

CREATE TABLE orders #创建订单表
(
orderid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,customerid INT UNSIGNED NOT NULL,amount FLOAT(6,2),date DATE NOT NULL,order_status CHAR(10),ship_name CHAR(60) NOT NULL,ship_address CHAR(80) NOT NULL,ship_city CHAR(30) NOT NULL,ship_state CHAR(20),ship_zip CHAR(10),ship_country CHAR(20) NOT NULL
);

CREATE TABLE books #创建图书表
(
isbn CHAR(13) NOT NULL PRIMARY KEY,author CHAR(80),title CHAR(100),catid INT UNSIGNED,price FLOAT(4,2) NOT NULL,description VARCHAR(255)
);

CREATE TABLE categories #创建目录表
(
catid INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,catname CHAR(60) NOT NULL
);

CREATE TABLE order_items #订单物品表
(
orderid INT UNSIGNED NOT NULL,isbn CHAR(13) NOT NULL,item_price FLOAT(4,quantity TINYINT UNSIGNED NOT NULL,PRIMARY KEY(orderid,isbn)
);

CREATE TABLE admin #管理员表
(
username char(16) NOT NULL PRIMARY KEY,password CHAR(40) NOT NULL
);

GRANT SELECT,INSERT,UPDATE,DELETE
on book_sc.*
to book_sc@localhost IDENTIFIED by 'password';

sql;"> USE book_sc;

INSERT INTO books VALUES ('0672329166','Luke Welling and Laura Thomson','PHP and MysqL Web Development',1,49.99,'PHP & MysqL Web Development teaches the reader to develop dynamic,secure e-commerce web sites. You will learn to integrate and implement these technologies by following real-world examples and working sample projects.');
INSERT INTO books VALUES ('067232976X','Julie Meloni','Sams Teach Yourself PHP,MysqL and Apache All-in-One',34.99,'Using a straightforward,step-by-step approach,each lesson in this book builds on the prevIoUs ones,enabling you to learn the essentials of PHP scripting,MysqL databases,and the Apache web server from the ground up.');
INSERT INTO books VALUES ('0672319241','Sterling Hughes and Andrei Zmievski','PHP Developer\'s Cookbook',39.99,'Provides a complete,solutions-oriented guide to the challenges most often faced by PHP developers\r\nWritten specifically for experienced Web developers,the book offers real-world solutions to real-world needs\r\n');

INSERT INTO categories VALUES (1,'Internet');
INSERT INTO categories VALUES (2,'Self-help');
INSERT INTO categories VALUES (5,'Fiction');
INSERT INTO categories VALUES (4,'Gardening');

INSERT INTO admin VALUES ('admin',sha1('admin'));

PHP;"> PHP

/**

• @author switch
• @copyright 2015
• 网站首页，显示系统中的图书目录
  */
  //require_once语句和require语句完全相同,唯一区别是PHP会检查该文件是否已经被包含过,如果是则不会再次包含。
  require_once('book_sc_fns.PHP');

session_start(); //开始会话
do_html_header('Welcome to Book-O-Rama'); //页头

echo "

Please choose a category:

";

$cat_array = get_categories(); //从数据库获取目录

display_categories($cat_array); //显示目录链接

if(isset($_SESSION['admin_user'])) //如果是管理员，显示管理员操作
display_button("admin.PHP","admin-menu","Admin Menu");
do_html_footer(); //页尾
?>

query($query); if(!$result) //查询失败，返回false return false; $num_cats = @$result ->num_rows; if($num_cats == 0) //数据库中无目录，返回false return false; $result = db_result_to_array($result); return $result; }

PHP;"> function display_categories($cat_array) //输出目录 { if(!is_array($cat_array)) { echo "

No categories currently available

"; return; } echo "

"; foreach($cat_array as $row) { $url = "show_cat.PHP?catid=". $row['catid']; $title = $row['catname']; echo "
• "; do_html_URL($url,$title); echo "
"; } echo "

"; echo "

---

"; }

for($count = 0; $row = $result ->fetch_assoc(); $count++)
$res_array[$count] = $row;

return $res_array;
}

PHP;"> /**

• @author switch
• @copyright 2015
• 显示特定目录包含的所有图书
  */
  //require_once语句和require语句完全相同,如果是则不会再次包含。
  require_once('book_sc_fns.php');

session_start();

@$catid = $_GET['catid'];
$name = get_category_name($catid);

do_html_header($name);

$book_array = get_books($catid);

display_books($book_array);

//如果是管理员，显示管理界面按钮
if(isset($_SESSION['admin_user']))
{
display_button("index.php","continue","Continue Shopping");
display_button("admin.php","Admin Menu");
display_button("edit_category_form.php?catid=". $catid,"edit-category","Edit Category");
}
else //否则显示主界面按钮
{
display_button("index.php","continue-shopping","Continue Shopping");
}
do_html_footer();
?>

query($query); if(!$result) //查询失败，原因为查询出错 return false;

$num_cats = @$result ->num_rows;

if($num_cats == 0) //查询失败，原因为无目录
return false;
$row = $result ->fetch_object();
return $row ->catname;
}

$conn = db_connect();
$query = "select * from books where catid = '". $catid ."'";
$result = @$conn ->query($query);
if(!$result) //查询失败，原因为查询出错
return false;

$num_books = @$result ->num_rows;

if($num_books == 0) //查询失败，原因为无图书
return false;

$result = db_result_to_array($result);
return $result;
}

PHP;"> function display_books($book_array) //输出图书 { if(!is_array($book_array)) echo "

No books currently available in this category

"; else //有图书，建表 { echo "foreach($book_array as $row)
{
$url = "show_book.PHP?isbn=". $row['isbn'];
echo "<tr><td>";
// 如果图片存在
if(@file_exists("images/". $row['isbn'] .".jpg"))
{
$title = "<img src=\"images/". $row['isbn'] .".jpg\" style=\"border: 1px solid black\"/>";
do_html_URL($url,$title);
}
else
echo " ";

echo "</td><td>";
$title = $row['title'] ." by ". $row['author'];
do_html_URL($url,$title);
echo "</td></tr>";
}
echo "</table>";
}
echo "

---

";
}

PHP and MysqL Web Development的详细信息

代码实现：

PHP

4.11 book_fns.PHP文件中的函数get_book_details()

4.12 output_fns.PHP文件中的函数display_book_details()

<div class="jb51code">
<pre class="brush:PHP;">
function display_book_details($book) //输出图书详细说明
{
if(is_array($book))
{
echo "<table><tr>";
// 如果图片存在
if(@file_exists("images/". $book['isbn'] .".jpg"))
{
$size = getimagesize("images/". $book['isbn'] .".jpg");
if(($size[0] > 0) && ($size[1] > 0))
{
echo "<td><img src=\"images/". $book['isbn'] .".jpg\" style=\"border: 1px solid black\"/></td>";
}
}
echo "<td>

";
echo "

• Author:

  ";
  echo $book['author'];
  echo "

• ISBN:

  ";
  echo $book['isbn'];
  echo "

• Our Price:

  ";
  echo number_format($book['price'],2);
  echo "

• Description:

  ";
  echo $book['description'];
  echo "

</td></tr></table>";
}
else
{
echo "

The details of this book cannot be displayed at this time.

";
}
echo "

---

";
}

5、实现购物车

不使用参数的脚本只显示购物车的内容

带有参数new的脚本将添加一个物品到购物车

代码实现： 5.1 show_cart.PHP

PHP文件中的函数display_cart()

<div class="jb51code">
<pre class="brush:PHP;">
function display_cart($cart,$change = true,$images = 1) //显示购物车
{
echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\">
<form action=\"show_cart.PHP\" method=\"post\">
<tr>
<th colspan=\"". (1 + $images) ."\" bgcolor=\" #cccccc\">Item
<th bgcolor=\"#cccccc\">Price
<th bgcolor=\"#cccccc\">Quantity
<th bgcolor=\"#cccccc\">Total
</tr>";
//输出购物车中每一项
foreach($cart as $isbn => $qty)
{
$book = get_book_details($isbn);
echo "<tr>";
if($images == true)
{
echo "<td align=\"left\">";
if(file_exists("images/". $isbn .".jpg"))
{
$size = getimagesize("images/". $isbn .".jpg");
if(($size[0] > 0) && ($size[1] > 1)) //图片长宽
{
echo "<img src=\"images/". $isbn .".jpg\"
style=\"border: 1px solid black\"
width=\"". ($size[0] / 3) ."\"
height=\"". ($size[1] / 3) ."\"/>";
}
}
else
echo " ";
echo "</td>";
}
echo "<td align=\"left\">
<a href=\"show_book.PHP?isbn=". $isbn ."\">". $book['title'] ." by". $book['author'] ."</td>
<td align=\"center\">\$". number_format($book['price'],2) ."</td><td align=\"center\">";

//如果允许更改数量
if ($change == true)
{
echo "<input type=\"text\" name=\"".$isbn."\" value=\"".$qty."\" size=\"3\">";
}
else
{
echo $qty;
}
echo "</td><td align=\"center\">\$".number_format($book['price']*$qty,2)."</td></tr>\n";
}

//总数
echo "<tr>
<th colspan=\"". (2 + $images) ."\" bgcolor = \"#cccccc\">
<th align = \"center\" bgcolor=\"#cccccc\">". $_SESSION['items'] ."
<th align = \"center\" bgcolor=\"#cccccc\">\$". number_format($_SESSION['total_price'],2) ."</tr>";

//保存按钮
if($change == true)
{
echo "<tr>
<td colspan = \"". (2 + $images) ."\"> </td>
<td align = \"center \">
<input type=\"hidden\" name=\"save\"value=\"true\" />
<input type = \"image\" src = \"images/save-changes.gif\" border = \" 0 \" alt = \" Save Changes \" />
</td>
<td> </td>
</tr>";
}
echo "</table>";
}

5.3 book_fns.PHP文件中的函数calculate_price()

5.4 book_fns.PHP文件中的函数calculate_items()

获取顾客的详细信息

由以下代码实现： 5.5 checkout.PHP

5.6 output_fns.PHP文件中的display_checkout_form()

PHP" method="post">
</tr>
<tr>
<td>Name</td>
<td><input type="text" name="ship_name" maxlength=""/></td>
</tr>
<tr>
<td>Address</td>
<td><input type="text" name="ship_address" value="" maxlength="40" size="40"/></td>
</tr>
<tr>
<td>City/Suburb</td>
<td><input type="text" name="ship_city" value="" maxlength="20" size="40"/></td>
</tr>
<tr>
<td>State/Province</td>
<td><input type="text" name="ship_state" value="" maxlength="20" size="40"/></td>
</tr>
<tr>
<td>Postal Code or Zip Code</td>
<td><input type="text" name="ship_zip" value="" maxlength="10" size="40"/></td>
</tr>
<tr>
<td>Country</td>
<td><input type="text" name="ship_country" value="" maxlength="20" size="40"/></td>
</tr>
<tr>
<td colspan="2" align="center">

Please press Purchase to confirm your purchase,or Continue Shopping to add or remove items.

PHP }

已填写好信息的订单

获取客户信用卡信息

代码实现： 5.7 purchase.PHP

5.8 order_fns.PHP文件中的函数insert_order()

<div class="jb51code">
<pre class="brush:php;">
function insert_order($order_details) //提取订单细节作为变量
{
extract($order_details);

//设置邮寄地址为当前地址
if((!$ship_name) && (!$ship_address) && (!$ship_city) && (!$ship_state) && (!$ship_zip) &&(!$ship_country))
{
$ship_name = $name;
$ship_address = $address;
$ship_city = $city;
$ship_state = $state;
$ship_zip = $zip;
$ship_country = $country;
}

//连接数据库
$conn = db_connect();

//事务开始，必须关闭自动提交
$conn ->autocommit(false);

$query = "select customrid from customers where
name ='". $name ."' and address = '". $address ."'
and city = '". $city ."' and state = '". $state ."'
and zip = '". $zip ."' and country = '". $country ."'";

$result = $conn ->query($query);

if(@$result ->num_rows > 0)
{
$customer = $result ->fetch_object();
$customerid = $customer ->customerid;
}
else
{
$query = "insert into customers values
('','". $name ."','". $address ."','". $city ."','". $state ."','". $zip ."','". $country ."')";
$result = $conn ->query($query);

if(!$result)
return false;
}

$customerid = $conn ->insert_id; //返回上次查询中自增量的ID

$date = date("Y-m-d");

$query ="insert into orders values
('','". $customerid ."','". $_SESSION['total_price'] ."','". $date ."','PARTIAL','". $ship_name ."','". $ship_address ."','". $ship_city ."','". $ship_state ."','". $ship_zip ."','". $ship_country ."')";

$result = $conn ->query($query);
if(!$result)
return false;

$query = "select orderid from orders where
customerid ='". $customerid ."' and
amount > (". $_SESSION['total_price'] ."-.001) and
amount < (". $_SESSION['total_price'] ."+.001) and
date ='". $date ."' and
order_status = 'PARTIAL' and
ship_name ='". $ship_name ."' and
ship_address ='". $ship_address ."' and
ship_city ='". $ship_city ."' and
ship_state ='". $ship_state ."' and
ship_zip ='". $ship_zip ."' and
ship_country ='". $ship_country ."'";

$result = $conn ->query($query);

if($result ->num_rows > 0)
{
$order = $result ->fetch_object();
$orderid = $order ->orderid;
}
else
return false;

foreach($_SESSION['cart'] as $isbn => $quantity)
{
$detail = get_book_details($isbn);
$query = "delete from order_items where
orderid = '". $orderid ."' and isbn = '". $isbn ."'";
$result = $conn ->query($query);

$query = "insert into order_items values
('". $orderid ."','". $isbn ."',". $detail['price'] .",$quantity)";
$result = $conn ->query($query);
if(!$result)
return false;
}

//事务关闭，开启自动提交
$conn ->commit();
$conn ->autocommit(true);

return $orderid;
}

5.9 output_fns.PHP文件中的函数display_shipping()

<tr> <th colspan="2" bgcolor="#cccccc">Shipping Address(leave blank if as above)

PHP }

5.10 output_fns.PHP文件中的函数display_card_form()

PHP" method="post"> required) Year PHP for($y = date("Y"); $y < date("Y") + 10; $y++) echo ""; ?>

Please press Purchase to confirm yout purchase,or Continue Shopping to add or remove items

PHP }

5.11 db_fns.PHP文件中的函数db_connect()

autocommit(true); return $result; }

6、实现付款

已填写好信息的信用卡详细信息

购物成功

代码实现： 6.1 process.PHP

PHP;"> PHP

/**

• @author switch
• @copyright 2015
• 处理付款细节，将订单添加到数据库
  */
  //require_once语句和require语句完全相同,如果是则不会再次包含。
  require_once('book_sc_fns.PHP');

session_start();

do_html_header('Checkout');

//创建变量
$card_type = $_POST['card_type'];
$card_number = $_POST['card_number'];
$card_month = $_POST['card_month'];
$card_year = $_POST['card_year'];
$card_name = $_POST['card_name'];

if(($_SESSION['cart']) && ($card_type) && ($card_number) && ($card_month) && ($card_year) &&($card_name))
{
//显示没有图片，不允许更改数量的购物车
display_cart($_SESSION['cart'],0);

display_shipping(calculate_shipping_cost());

if(process_card($_POST))
{
//清空购物车
session_destroy();
//这里可以写一些关于信用卡接口调用的函数，调用银行写好的接口
echo "

Thank you for shopping with us. Your order has been placed.

";

display_button("index.PHP","Continue Shopping");
}
else
{
echo "

Could not process your card. Please contact the card issuer or try again.

";
display_button("purchase.PHP","back","Back");
}
}
else
{
echo "

You did not fill in all the fields,please try again.

---

";
display_button("purchase.PHP","Back");
}
do_html_footer();
?>

以上就是PHP实现购物车功能的前篇，代码很详细，希望对大家的学习有所帮助，之后还有下篇分享给大家，不要错过。

php购物车购物车

• 上一篇：WordPress开发中自定义菜单的相关P下一篇：Yii中创建自己的Widget实例

猜你在找的PHP相关文章

Hessian通讯协议【附PHP源代码】

Hessian开源的远程通讯，采用二进制 RPC的协议，基于 HTTP 传输。可以实现PHP调用Java,Pyt...

作者：前端之家 时间：2021-02-22

初识Mongodb总结

初识Mongodb的一些总结,在Mac Os X下真实搭建mongodb环境,以及分享个Mongodb管理工具,学习...

作者：前端之家 时间：2021-02-22

初识Mongodb之[CURD]-PHP版

边看边操作,这样才能记得牢,实践是检验真理的唯一标准.光看不练假把式,光练不看傻把式,边看...

作者：前端之家 时间：2021-02-22

php学习日志 - echo&print

在php中，结果输出一共有两种方式：echo和print，下面将对两种方式做一个比较。 echo与pri...

作者：前端之家 时间：2021-02-21

The mbstring extension is missing. Please check your PHP configuration错误及解决方法

在安装好wampServer后，一直没有使用phpMyAdmin,今天用了一下，phpMyAdmin显示错误：The m...

作者：前端之家 时间：2021-02-21

解决Windows Live Writer错误:WindowsLive.Writer.CoreServices.HttpRequestHelper的类型初始值设定发生异常

以前用Windows Live Writer写日志都好好的，前几天用写完日志，点击发布，突然弹出意外错误...

作者：前端之家 时间：2021-02-21

在PHP项目中使用Standford Moss代码查重系统

Standford Moss 系统是斯坦福大学大名鼎鼎的代码查重系统，它可以查出哪些同学提交的代码是...

作者：前端之家 时间：2021-02-18

Windows下PHP安全环境的搭建

笔者一直在Windows环境下搭建PHP的运行环境，大大小小的运行环境用过不少，从开始的WAMP到...

作者：前端之家 时间：2021-02-18

ThinkPHP5作业管理系统中处理学生未交作业与已交作业信息

在作业管理系统中，学生登陆到个人中心后可以通过左侧的菜单查看自己已经提交的作业和未提...

作者：前端之家 时间：2021-02-18

ThinkPHP5项目目录规划实践

ThinkPHP5安装后（或者下载后的压缩文件解压后）可以看到下面的目录结构： 一般的信息管理...

作者：前端之家 时间：2021-02-18

编程分类

PHPJavaJava SEPythonC#C&C++RubyVBasp.NetGoPerlnettyDjangoDelphiJsp.NET CoreSpringFlaskSpringbootSpringMVCLuaLaravelMybatisAspGroovyThinkPHPYiiswoole

最新文章

• • Hessian通讯协议【附PHP源
• • 初识Mongodb总结
• • 初识Mongodb之[CURD]-PHP版
• • php学习日志 - echo&p
• • The mbstring extension i
• • php学习日志 - php变量
• • 解决Windows Live Writer错
• • 在PHP项目中使用Standford
• • Windows下PHP安全环境的搭
• • ThinkPHP5作业管理系统中处

热门标签 更多 ►

文件时间pythonm相等性PHP Warning时间问题问题解决pcntl_signal采样点wav模块动态文本调用频率限制对外暴露多个访问请求更新数据表模型结构type()方法比较速度手写体sobel算子保存模型Image类nn.Conv2dpytorch1.0kaggleDCGAN交并比range()用法打印模型反卷积卷积