[studentbooks15] r91 committed - Actually really Integrated Bria's 'add to cart' buttons to the search ...

[student...@googlecode.com]

Revision: 91
Author: sben...@fau.edu
Date: Sat Dec 4 22:50:57 2010
Log: Actually really Integrated Bria's 'add to cart' buttons to the search
page. Jhonny's Change_Password function is also in here.
http://code.google.com/p/studentbooks15/source/detail?r=91

Deleted:
/trunk/BookGet/Include/backend/AccountDB.php
Modified:
/trunk/BookGet/search.php

=======================================
--- /trunk/BookGet/Include/backend/AccountDB.php Fri Dec 3 19:06:02 2010
+++ /dev/null
@@ -1,136 +0,0 @@
-<?php
-/**
- * AccountDB - Class to manage user accounts. Creates and maintains
- * a connection to the user database
- *
- * @author saul
- */
-class AccountDB {
-
- // We need to implement these!
- public function create_user($email, $uname, $pwd, $firstname,
$lastname, $fbid=NULL) {
- if ($fbid == null)
- $info = $this->get_userId($uname);
- else
- $info = $this->get_fb_userId ($fbid);
-
- if ($info == null)
- {
- $query = "INSERT INTO users (Email, Uname, Password,
FirstName, LastName, fb_uid) VALUES ".
- "('". $email ."','". $uname ."','". $pwd ."','".
$firstname ."','". $lastname ."','". $fbid."')";
- mysql_query($query);
-
- } else {
- throw new Exception("Account exists", 0);
- }
- }
-
- public function create_from_fb($user) {
- $this->get_fb_userId($user['id']);
-
- if ($info != null)
- return;
-
- $this->create_user($user['email'], "", "", $user['first_name'],
- $user['last_name'], $user['id']);
- }
-
- public function get_userId($name) {
- $name = mysql_real_escape_string($name);
- $query = "SELECT Id FROM users
- WHERE Uname = '". $name ."'";
-
- $result = mysql_query($query);
-
- if ($result != null) {
- if (mysql_num_rows($result) > 0) {
- return mysql_result($result,0);
- }
- } else {
- print("\$result was null D:\n");
- return NULL;
- }
- }
-
- public function verify_credentials($name, $pass) {
- $name = mysql_real_escape_string($name);
- $pass = mysql_real_escape_string($pass);
-
- $query = "SELECT Password FROM users
- WHERE Uname = '". $name ."'";
- $object = mysql_query($query);
- $result = false;
-
- if ($object != null) {
- if (mysql_num_rows($object) > 0) {
- if(mysql_result($object,0) == "") {
- $result = false;
- } elseif(mysql_result($object,0) == $pass) {
- $result = true;
- }
- }
- }
-
- return $result;
- }
-
- public function get_fb_userId($fbid) {
- $name = mysql_real_escape_string($fbid);
- $query = "SELECT Id FROM users
- WHERE fb_uid = '". $fbid ."'";
-
- $result = mysql_query($query);
-
- if ($result != null) {
- if (mysql_num_rows($result) > 0) {
- return mysql_result($result,0);
- }
- } else {
- //print("\$result was null D:\n");
- return NULL;
- }
- }
- public function verify_fb_credentials($fbid)
- {
-// $query = "SELECT Id FROM users WHERE fb_uid = '". $fbid ."'";
-// $object= mysql_query($query);
-// $result = false;
-//
-// if ($object != null) {
-// if (mysql_num_rows($object) > 0) {
-// $result = true;
-// }
-// }
-// return $result;
- return $this->get_fb_userId($fbid);
- }
-
- public static function getInstance() {
- if (!self::$instance instanceof self) {
- self::$instance = new AccountDB();
- }
-
- return self::$instance;
- }
-
- function __construct() {
- $this->con = mysql_connect($this->dbHost, $this->user, $this->pass)
- or die ("Could not connect to db: " . mysql_error());
- mysql_query("SET NAMES 'utf8'");
- mysql_select_db($this->dbName, $this->con)
- or die ("Could not select db: " . mysql_error());
- }
-
- // db connection config vars
- protected $user = "bookget";
- protected $pass = "bookget15";
- protected $dbName = "bookget";
- protected $dbHost = "localhost";
- protected $con = null;
-
- // This class can only be instantiated once. This is the
- // current instance:
- private static $instance = null;
-
-}
-?>
=======================================
--- /trunk/BookGet/search.php Sat Dec 4 20:58:26 2010
+++ /trunk/BookGet/search.php Sat Dec 4 22:50:57 2010
@@ -100,9 +100,6 @@
$id = $searchresults[$i]["BookID"];
$Description = $searchresults[$i]["Description"];

-
-
-
print "<fieldset>";
print "< form method=\"post\" action=\"\"
class=\"jcart\">\n";
print "< input type=\"hidden\" name= \"BOOK_ID\"
value= \"$id\" />\n";