Error 1064 in php call to mysql

Vikki · #21 (**permalink**) 06-24-08, 01:38 PM

Wow.

I can see how this works...the programming is still beyond my ability, but once I understand the logic it's only a matter of time until I get it.

That you were willing to take the time and help a newbie is very commendable. Thank you very much for taking the time to hand-hold me through this.

I have added code to Add One or Remove One from the cart, and a checkout, following the text. I'll need to figure out how to modify those so that they work with the multidimensional array.

Once I've mastered the basics, I hope to be a useful contributor here.

There is a lot to learn on these pages.

One more chapter in the book and I'll turn my focus on creating databases and pages for my Firebird website, which is why I wanted to learn this in the first place.

job0107 · #22 (**permalink**) 06-24-08, 08:05 PM

Quote:

Originally Posted by Vikki

Wow.

I can see how this works...the programming is still beyond my ability, but once I understand the logic it's only a matter of time until I get it.

That you were willing to take the time and help a newbie is very commendable. Thank you very much for taking the time to hand-hold me through this.

I have added code to Add One or Remove One from the cart, and a checkout, following the text. I'll need to figure out how to modify those so that they work with the multidimensional array.

Once I've mastered the basics, I hope to be a useful contributor here.

There is a lot to learn on these pages.

One more chapter in the book and I'll turn my focus on creating databases and pages for my Firebird website, which is why I wanted to learn this in the first place.

I started this so I took it as a challenge. And I appreciate your complement.

The multi-demensional array I created is simply a table with rows (records) and columns (fields that hold the values).

So $this->Orders[0][0] would be record 0 column 0.
And $this->Orders[0][1] would be record 0 column 1.
And $this->Orders[0][2] would be record 0 column 2.

And $this->Orders[1][0] would be record 1 column 0.
And $this->Orders[1][1] would be record 1 column 1.
And $this->Orders[1][2] would be record 1 column 2.

And so forth...

You just add another column to store the quantity that can be used with each record independently.

Add in the logic for an input field and your all set.

At checkout you just read the $this->Orders array and extract only the ones that have a value.

job0107 · #23 (**permalink**) 06-24-08, 10:27 PM

This is a revised version of ShoppingCart.php with all the junk removed.

ShoppingCart.php

PHP Code:


			
<?php
class ShoppingCart {
    private $DBConnect = "";
    private $DBName = "";
    private $TableName = "";
    private $ItemCount = 0;
     public $Orders = array();
     public $count = 0;

    public function __construct() {
       $this->DBConnect = @new mysqli("localhost", "root", "");
        if(mysqli_connect_errno()) {
           die("<p>Unable to connect to the database server.</p><p>Error code ".mysqli_connect_errno().": ".mysqli_connect_error())."</p>";
        }
    }

    public function __destruct() {
       $this->DBConnect->close();
    }

    public function setDatabase($Database) {
       $this->DBName = $Database;
       @$this->DBConnect->select_db($this->DBName) or die("<p>Unable to select the database.</p><p>Error code ".mysqli_errno($this->DBConnect).": ".mysqli_error($this->DBConnect))."</p>";
    }

    public function setTable($Table) {
       $this->TableName = $Table;
    }

    public function getProductList() {
       $SQLstring = "SELECT * FROM $this->TableName";
       $QueryResult = $this->DBConnect->query($SQLstring) or die("<p>Unable to perform the query.</p><p>Error code ".mysqli_errno($this->DBConnect).": ".mysqli_error($DBConnect))."</p>";
       echo "<table width='100%' border='1'><tr><th>Product</th><th>Description</th><th>Price Each</th><th>Select Item</th></tr>";
       $Row = $QueryResult->fetch_row();
       while($Row) {
          echo "<tr><td style='padding-left:5px;'>{$Row[1]}</td><td style='padding-left:5px;'>{$Row[2]}</td>";
          printf("<td align='center'>$%.2f</td>", $Row[3]);
          echo "<td align='center'><a href='ShowCart.php?PHPSESSID=".session_id()."&operation=addItem&productID=".$Row[0]."'>Add</a></td></tr>";
          $Row = $QueryResult->fetch_row();
       }
       echo "</table>";
    }

    public function addItem() {
       $ProdID = $_GET["productID"];
       for($i=0;$i<count($this->Orders);$i++) {
          if($this->Orders[$i][0]==$ProdID) {
             exit("<div style='width:385px;padding:5px;border:2px solid #ff0000;color:#cc0000;font-zixe:20px;font-weight:bold;'>You already selected that item!  Please choose a category.</div>");
          }
       }
       $this->Orders[$this->ItemCount][0] = $ProdID;
       $this->Orders[$this->ItemCount][1] = $this->TableName;
       $this->ItemCount++;
    }

    public function __wakeup() {
       $this->DBConnect = @new mysqli("localhost", "root", "");
       if(mysqli_connect_errno()) {
          die("<p>Unable to connect to the database server.</p><p>Error code ".mysqli_connect_errno().": ".mysqli_connect_error())."</p>";
       }
       @$this->DBConnect->select_db($this->DBName) or die("<p>Unable to select the database.</p><p>Error code ".mysqli_errno($this->DBConnect).": ".mysqli_error($this->DBConnect))."</p>";
    }

    public function showCart() {
       $sw = 0;
       for($i=0;$i<count($this->Orders);$i++) {
          $Order = $this->Orders[$i];
          $Table_Name = $Order[1] ? $Order[1] : "";
          $ProdID = $Order[0] ? $Order[0] : "";
          $OrderQTY = 2;
          if($Table_Name && $ProdID) {
             if($sw == 0) {
                echo "<table width='100%' border='1'><tr><th>Remove Item</th><th>Product</th><th>Quantity</th><th>Price Each</th></tr>";
                $sw = 1;
             }
             $SQLstring = "SELECT * FROM ".$Table_Name." WHERE productID='".$ProdID."'";
             $QueryResult = @mysqli_query($this->DBConnect, $SQLstring) or die("<p>Unable to perform the query.</p><p>Error code ".mysqli_errno($this->DBConnect).": ".mysqli_error($this->DBConnect))."</p>";
             $Row = mysqli_fetch_row($QueryResult);
             $Total += $Row[3] * $OrderQTY;
             $Total_total += $Total;
             $Total = 0;
             echo "<tr>
                   <td align='center'><a href='ShowCart.php?PHPSESSID=".session_id()."&operation=removeItem&productID=".$Row[0]."'>Remove</a></td>
                   <td style='padding-left:10px;'>{$Row[1]}</td>
                   <td align='center'>$OrderQTY</td>";
                   printf("<td align='center'>$%.2f</td></tr>", $Row[3]);
             $found = TRUE;
             $this->count++;
          }
       }
       if(!$found){echo "<table width='100%' border='1'><tr>";}
       else {
          $link = $Total_total ? "<a href='ShowCart.php?PHPSESSID=".session_id()."&operation=emptyCart'><strong>Empty Cart</strong></a>" : "";
          echo "<tr><td align='center'>$link</td>";
       }
       echo "<td colspan='2'><strong>&nbsp;&nbsp;&nbsp;Your shopping cart contains ".$this->count." product(s).</strong></td>";
       printf("<td align='center'><strong>Total: $%.2f</strong></td></tr>", $Total_total);
       echo "</table>";
       $this->count = 0;
    }

    public function removeItem() {
       $ProdID = $_GET['productID'];
       for($i=0;$i<count($this->Orders);$i++) {
          if($this->Orders[$i][0] == $ProdID) {
             $this->Orders[$i][0] = "";
             $this->Orders[$i][1] = "";
          }
       }
    }

    public function emptyCart() {
       for($i=0;$i<count($this->Orders);$i++) {
          $this->Orders[$i][0] = "";
          $this->Orders[$i][1] = "";
       }
    }
}
?>

wirehopper · #24 (**permalink**) 06-25-08, 10:52 PM

This loop

PHP Code:


			
for($i=0;$i<count($this->Orders);$i++) {

          $this->Orders[$i][0] = "";

          $this->Orders[$i][1] = "";

       }

could be written like so:

PHP Code:


			
j=count($this->Orders);  // Evaluated once

for (i=0;i<j;i++)

  unset($this->Orders[$i]);

Both approaches are valid and equivalent.

jaimenacach · #25 (**permalink**) 04-20-09, 02:11 AM

Currently taking off post.

Working on code at the moment. Will repost again soon.

jaimenacach · #26 (**permalink**) 04-22-09, 05:39 PM

Hi, I'm new to the forum,

I have had the exact same issue as Vikki had, with every same EXACT problem throughout her posts.

I've taken the code from ShoppingCart.php in Post #23 by Job0107 and replaced it in my Shoppingcart.php. The shopping cart now works perfeclty. You can add items from any category, at any time, and the shopping cart ADDs them perfectly!

Thanks so much for the information you provided job0107!

I'm new to PHP programming too, and also have taken this challenge on my own, as I'm not part of any class, and don't get a grade!

It's too bad the author of our text book (Gosselin) did not review his code before printing his book. There are several errors.

In any case, if anyone needs the entire code from the various pages. Here they are. They are the pages that one creates for you Chapter Directory for Chapter 11 for the book called "PHP Programming with MySQL" by Don Gosselin.

Good luck to all the new students in the future!

ShoppingCart.php

PHP Code:


			
<?php

class ShoppingCart {

    private $DBConnect = "";

    private $DBName = "";

    private $TableName = "";

    private $ItemCount = 0;

     public $Orders = array();

     public $count = 0;



    public function __construct() {

       $this->DBConnect = @new mysqli("localhost", "root", "yourownpassword");

        if(mysqli_connect_errno()) {

           die("<p>Unable to connect to the database server.</p><p>Error code ".mysqli_connect_errno().": ".mysqli_connect_error())."</p>";

        }

    }



    public function __destruct() {

       $this->DBConnect->close();

    }



    public function setDatabase($Database) {

       $this->DBName = $Database;

       @$this->DBConnect->select_db($this->DBName) or die("<p>Unable to select the database.</p><p>Error code ".mysqli_errno($this->DBConnect).": ".mysqli_error($this->DBConnect))."</p>";

    }



    public function setTable($Table) {

       $this->TableName = $Table;

    }



    public function getProductList() {

       $SQLstring = "SELECT * FROM $this->TableName";

       $QueryResult = $this->DBConnect->query($SQLstring) or die("<p>Unable to perform the query.</p><p>Error code ".mysqli_errno($this->DBConnect).": ".mysqli_error($DBConnect))."</p>";

       echo "<table width='100%' border='1'><tr><th>Product</th><th>Description</th><th>Price Each</th><th>Select Item</th></tr>";

       $Row = $QueryResult->fetch_row();

       while($Row) {

          echo "<tr><td style='padding-left:5px;'>{$Row[1]}</td><td style='padding-left:5px;'>{$Row[2]}</td>";

          printf("<td align='center'>$%.2f</td>", $Row[3]);

          echo "<td align='center'><a href='ShowCart.php?PHPSESSID=".session_id()."&operation=addItem&productID=".$Row[0]."'>Add</a></td></tr>";

          $Row = $QueryResult->fetch_row();

       }

       echo "</table>";

    }



    public function addItem() {

       $ProdID = $_GET["productID"];

       for($i=0;$i<count($this->Orders);$i++) {

          if($this->Orders[$i][0]==$ProdID) {

             exit("<div style='width:385px;padding:5px;border:2px solid #ff0000;color:#cc0000;font-zixe:20px;font-weight:bold;'>You already selected that item!  Please choose a category.</div>");

          }

       }

       $this->Orders[$this->ItemCount][0] = $ProdID;

       $this->Orders[$this->ItemCount][1] = $this->TableName;

       $this->ItemCount++;

    }



    public function __wakeup() {

       $this->DBConnect = @new mysqli("localhost", "root", "yourownpassword");

       if(mysqli_connect_errno()) {

          die("<p>Unable to connect to the database server.</p><p>Error code ".mysqli_connect_errno().": ".mysqli_connect_error())."</p>";

       }

       @$this->DBConnect->select_db($this->DBName) or die("<p>Unable to select the database.</p><p>Error code ".mysqli_errno($this->DBConnect).": ".mysqli_error($this->DBConnect))."</p>";

    }



    public function showCart() {

       $sw = 0;

       for($i=0;$i<count($this->Orders);$i++) {

          $Order = $this->Orders[$i];

          $Table_Name = $Order[1] ? $Order[1] : "";

          $ProdID = $Order[0] ? $Order[0] : "";

          $OrderQTY = 1;

          if($Table_Name && $ProdID) {

             if($sw == 0) {

                echo "<table width='100%' border='1'><tr><th>Remove Item</th><th>Product</th><th>Quantity</th><th>Price Each</th></tr>";

                $sw = 1;

             }

             $SQLstring = "SELECT * FROM ".$Table_Name." WHERE productID='".$ProdID."'";

             $QueryResult = @mysqli_query($this->DBConnect, $SQLstring) or die("<p>Unable to perform the query.</p><p>Error code ".mysqli_errno($this->DBConnect).": ".mysqli_error($this->DBConnect))."</p>";

             $Row = mysqli_fetch_row($QueryResult);

             $Total += $Row[3] * $OrderQTY;

             $Total_total += $Total;

             $Total = 0;

             echo "<tr>

                   <td align='center'><a href='ShowCart.php?PHPSESSID=".session_id()."&operation=removeItem&productID=".$Row[0]."'>Remove</a></td>

                   <td style='padding-left:10px;'>{$Row[1]}</td>

                   <td align='center'>$OrderQTY</td>";

                   printf("<td align='center'>$%.2f</td></tr>", $Row[3]);

             $found = TRUE;

             $this->count++;

          }

       }

       if(!$found){echo "<table width='100%' border='1'><tr>";}

       else {

          $link = $Total_total ? "<a href='ShowCart.php?PHPSESSID=".session_id()."&operation=emptyCart'><strong>Empty Cart</strong></a>" : "";

          echo "<tr><td align='center'>$link</td>";

       }

       echo "<td colspan='2'><strong>&nbsp;&nbsp;&nbsp;Your shopping cart contains ".$this->count." product(s).</strong></td>";

       printf("<td align='center'><strong>Total: $%.2f</strong></td></tr>", $Total_total);

       echo "</table>";

       $this->count = 0;

    }



    public function removeItem() {

       $ProdID = $_GET['productID'];

       for($i=0;$i<count($this->Orders);$i++) {

          if($this->Orders[$i][0] == $ProdID) {

             $this->Orders[$i][0] = "";

             $this->Orders[$i][1] = "";

          }

       }

    }



    public function emptyCart() {

       for($i=0;$i<count($this->Orders);$i++) {

          $this->Orders[$i][0] = "";

          $this->Orders[$i][1] = "";

       }

    }

}

?>

ShowCart.php

PHP Code:


			
<?php

session_start();

require_once("ShoppingCart.php");

if (!isset($_SESSION['curCart']))

    header("location:GosselinGourmetGoods.php");

?>



<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Gosselin Gourmet Goods</title>

<link rel="stylesheet" href="php_styles.css" type="text/css" />

</head>

<body>

<h1>Gosselin Gourmet Goods</h1>

<h2>Shop by Category</h2>

<p><a href="GosselinGourmetCoffees.php">Gourmet Coffees</a><br />

<a href="GosselinGourmetOlives.php">Specialty Olives</a><br />

<a href="GosselinGourmetSpices.php">Gourmet Spices</a></p>

<?php

$Cart = unserialize($_SESSION['curCart']);

if (isset($_GET['operation'])) {

    if ($_GET['operation'] == "addItem")

        $Cart->addItem();

    if ($_GET['operation'] == "removeItem")

        $Cart->removeItem();

    if ($_GET['operation'] == "emptyCart")

        $Cart->emptyCart();

}

$Cart->showCart();

$_SESSION['curCart'] = serialize($Cart);

?>

</body>

</html>

GosselingGourmetCoffee.php

PHP Code:


			
<?php

session_start();

require_once("ShoppingCart.php");

?>



<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<title>Gosselin Gourmet Goods</title>

<link rel="stylesheet" href="php_styles.css" type="text/css" />

</head>

<body>

<h1>Gosselin Gourmet Goods</h1>

<h2>Shop by Category</h2>

<p><a href="GosselinGourmetCoffees.php">Gourmet Coffees</a><br />

<a href="GosselinGourmetOlives.php">Specialty Olives</a><br />

<a href="GosselinGourmetSpices.php">Gourmet Spices</a></p>

<h2>Gourmet Coffees</h2>

<?php

$Database = "gosselin_gourmet"; 

$Table = "coffee";

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

    $Cart = unserialize($_SESSION['curCart']);

else {

    if (class_exists("ShoppingCart")) {

        $Cart = new ShoppingCart();

        $Cart->setDatabase($Database);

    }

    else

        exit("<p>The ShoppingCart class is not available!</p>");

}

$Cart->setTable($Table);

$Cart->getProductList();

$_SESSION['curCart'] = serialize($Cart);

?>

<p><a href='<?php echo "ShowCart.php?PHPSESSID=" . session_id() ?>'>Show Shopping Cart</a></p>

</body>

</html>

thanks so much once again

Jaime Nacach

jaimenacach · #27 (**permalink**) 04-22-09, 06:27 PM

Hello,

I would like to know if someone can explain to me some of the code that user "job0107" used for declaring some variables from post #23. Part of it is shown below. It's part of the code for the function called showCart() within the ShoppingCart Class on ShoppingCart.php.

I don't understand how the following declarations works, or what they mean. How is the notation $ProdID = $Order[0] ? $Order[0] : ""; read, or what does it mean?
What does the "?" and the ":" represent?
I've tried searching for the meaning online. But can't find anything, or just don't know how to Google for it.

I know that the way it's written WORKS properly and that the variables do print out the correct TABLE name and product ID. I just want to know why.

Once the multidimensional array $Orders is broken down,
Why can't we just declare the following:
$Table_Name = $Order[1];
$ProdID = $Order[0];

Thanks for the help!

PHP Code:


			
$sw = 0;
       for($i=0;$i<count($this->Orders);$i++) {
          $Order = $this->Orders[$i];
          $Table_Name = $Order[1] ? $Order[1] : "";
          echo "$Table_Name<br />";
          $ProdID = $Order[0] ? $Order[0] : "";
          $OrderQTY = 1;
          if($Table_Name && $ProdID) {
             if($sw == 0) {
                echo "<table width='100%' border='1'><tr><th>Remove Item</th><th>Product</th><th>Quantity</th><th>Price Each</th></tr>";
                $sw = 1;
             }

Jaime Nacach

Jcbones · #28 (**permalink**) 04-30-09, 12:20 AM

Quote:

I don't understand how the following declarations works, or what they mean. How is the notation $ProdID = $Order[0] ? $Order[0] : ""; read, or what does it mean?

This is just an easy and fast way to write an if/else statement. Syntax is as follows

($argument) ? 'true' : 'false';

So,

PHP Code:


			


//if $Order[0] returns true, set $ProdID to $Order[0], else set it as NULL;

$ProdID = ($Order[0]) ? $Order[0] : NULL; 



//Same as above

if($Order[0] != NULL)

  {

      $ProdID = $Order[0];

  }

else

  { 

      $ProdID = NULL;

  }

jaimenacach · #29 (**permalink**) 04-30-09, 12:15 PM

Thank you so much for the answer....
that's very helpful!

I knew I had seen it somewhere, but could not reference back to it. Thanks for the post.

job0107 · #30 (**permalink**) 04-30-09, 12:49 PM

Quote:

Originally Posted by jaimenacach

Thank you so much for the answer....
that's very helpful!

I knew I had seen it somewhere, but could not reference back to it. Thanks for the post.

The other reason to use Boolean logic or an if/else statement is so the variable gets initialized whether the array element exists or not.
In some instances if the variable is not initialized before it is used, then a caution! warning will be generated.

It's always good practice to initialize your variables either with a value or null.