php实现购物车功能（上）

4.6 book_fns.php文件中的函数get_category_name()

function get_category_name($catid) //获取目录名 
 { 
 $conn = db_connect(); //连接数据库 
 $query = "select catname from categories where catid = '". $catid ."'"; 
 $result = @$conn ->query($query); 
 if(!$result) //查询失败，原因为查询出错 
  return false; 
  
 $num_cats = @$result ->num_rows; 
  
 if($num_cats == 0) //查询失败，原因为无目录 
  return false; 
 $row = $result ->fetch_object(); 
 return $row ->catname; 
 } 

4.8 book_fns.php文件中的函数get_books()

function get_books($catid) //从数据库中获取图书 
 { 
 if((!$catid) || ($catid == '')) //如果目录ID为空 
  return false; 
  
 $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; 
 } 

4.9 output_fns文件中的函数display_books()

function display_books($book_array) //输出图书 
 { 
 if(!is_array($book_array)) 
  echo "<p>No books currently available in this category</p>"; 
 else //有图书，建表 
 { 
  echo "<table width = "100%" border="0">"; 
  
  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 "<hr/>"; 
 } 

PHP and MySQL Web Development的详细信息

由以下代码实现：

4.10 show_book.php

<?php 
 /** 
 * @author switch 
 * @copyright 2015 
 * 显示特定图书的详细信息 
 */ 
 //require_once语句和require语句完全相同,唯一区别是PHP会检查该文件是否已经被包含过,如果是则不会再次包含。 
 require_once('book_sc_fns.php'); 
 
 session_start(); 
 
 $isbn = $_GET['isbn']; 
 
 $book = get_book_details($isbn); 
 do_html_header($book['title']); 
 display_book_details($book); 
 
 //设置继续按钮 
 $target = "index.php"; 
 if($book['catid']) 
 $target = "show_cat.php?catid = ". $book['catid']; 
 
 //如果是管理员，显示编辑链接 
 if(check_admin_user()) 
 { 
 display_button("edit_book_form.php?isbn=". $isbn,"edit-item","Edit Item"); 
 display_button("admin.php","admin-menu","Admin Menu"); 
 display_button($target,"continue","Continue"); 
 } 
 else 
 { 
 display_button("show_cart.php?new=". $isbn,"add-to-cart","Add". $book['title']." To My Shopping Cart"); 
 display_button($target,"continue-shopping","Continue Shopping"); 
 } 
 do_html_footer(); 
?> 								 
 3/9   首页 上一页 1 2 3 4 5 6 下一页 尾页