How can I make a Shopping cart using Mysql and PHP

mhillock89 · March 17, 2010

Hello, I'm so stuck with this, I need major help on what I need to add to my code to make the items displayed from my database go into a cart which is displayed onto another page called cart.php. Here's the code I have so far...

This is the page which displays the items users can purchase (BooksLoggedIn.php):

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Student Books</title>

</head>

<body>

<?php

require_once("dbconnect.php");

session_start();

if (isset($_SESSION['login']))

{

$username = $_SESSION['login'];

echo "<h4>User $username is logged in, <a href='Books.php?'>Logout</a></h4>";

}

?>

</div>

<?php

//cart code here!

?>

</div>

<h1>Computing - The Online Book store</h1>

</div>

</form>

</div>

<tr>

<td><h2>Title</h2></td>

<td><h2>Price</h2></td>

<td><h2>Add to basket</h2></td>

<td><h2>Remove</h2></td>

<tr>

<?php

require_once("dbconnect.php");

$query = "SELECT * FROM Books ORDER BY 'title'";

$dbRecords = mysql_query("SELECT * FROM Books", $dbConn)

or die("Problem reading table: " + mysql_error());

while ($arrRecords = mysql_fetch_array($dbRecords))

{

$id = $arrRecords["id"];

$title = $arrRecords["title"];

$price = $arrRecords["price"];

echo "<tr>";

echo "<td><h2>$id</h2></td>";

echo "<td><h2><a href = 'BookDetails.php?id=$id'>$title </a></h2></td>";

echo "<td><h2>£$price</h2></td>";

echo "<td><h2><a href='cart.php?action=add&id=1'>Add to cart</a></h2></td>";

echo "<td><h2><a href='cart.php?action=delete&id=1'>Remove</a></h2></td>";

echo "</tr>";

}

?>

</table>

</div>

</body>

</html>

And this is all I have for my cart.php page:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

<?php

?>

<p><a href="BooksLoggedIn.php">Back to bookshop...</a></p>

</body>

</html>

Any help would be really appreciated, thanks .

[attachment deleted by admin]

Sign In

How can I make a Shopping cart using Mysql and PHP

Recommended Posts

mhillock89

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information