[RESOLVED] shopping cart check out

[mbx5nitro]

I have a shopping cart that when a user clicks check out it sends a email to me with the item code and quantiy they want. I have the script so it sends the email although in the message area of the e-mail it says "Array" How do i fix it. Here is the code that does the check out.

case 'order':
		global $db;
		$items = explode(',',$cart);
		$contents = array();
		foreach ($items as $item) {
			$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
		}
		foreach ($contents as $id=>$qty) {
			$sql = 'SELECT * FROM cvs_data WHERE id = '.$id;
			$result = $db->query($sql);
			$row = $result->fetch();
			extract($row);
			$output[] = ''.$item.'';
			$output[] = ''.$qty.'';
			$output[] = '\n';
		}
		$to      = '[e-mail]';
		$subject = ''.$firstname.' Order';
		$message = ''.$output.'';
		$headers = 'From: '.$email.'' . "\r\n" .
		   'X-Mailer: PHP/' . phpversion();

	mail($to, $subject, $message, $headers);

break;

[bpat1434]

append the information onto $Output... don't make it an array 😉

So this code:

foreach ($contents as $id=>$qty) {
            $sql = 'SELECT * FROM cvs_data WHERE id = '.$id;
            $result = $db->query($sql);
            $row = $result->fetch();
            extract($row);
            $output[] = ''.$item.'';
            $output[] = ''.$qty.'';
            $output[] = '\n';
        }

becomes:

$output = '';
foreach ($contents as $id=>$qty) {
            $sql = 'SELECT * FROM cvs_data WHERE id = '.$id;
            $result = $db->query($sql);
            $row = $result->fetch();
            extract($row);
            $output .= ''.$item.'';
            $output .= ''.$qty.'';
            $output .= '\n';
        }

[mbx5nitro]

Thank you that worded well although i have one more thing i cant solve. Wen it sends the e-mail i want the item code and the qty on the same line then a line break and another item and qty on the next line and so on but i cant figure it out even with the \n deal.
here is the code.

	case 'order':
		global $db;
		$cart = $_SESSION['cart'];
		$items = explode(',',$cart);
		$contents = array();
		foreach ($items as $item) {
			$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
		}
 $output = '';
foreach ($contents as $id=>$qty) {
            $sql = 'SELECT * FROM cvs_data WHERE id = '.$id;
            $result = $db->query($sql);
            $row = $result->fetch();
            extract($row);
            $output .= ''.$item.' '.$qty.'       ';  //this is the line that makes the output on the e-mail
        } 
		$to      = '[e-mail]';
		$subject = ''.$firstname.' Order';
		$message = ''.$output.'';
		$headers = 'From: [e-mail]' . "\r\n" .
   		'Reply-To: [e-mail]' . "\r\n" .
   		'X-Mailer: PHP/' . phpversion();

	mail($to, $subject, $message, $headers);

break;

[bpat1434]

the \n character needs to be encased in double quotes, not single quotes. So if you look at your line now:

$output .= ''.$item.' '.$qty.'       ';

php won't parse anything between the quotes (it's in the manual 😉 ) and so certain items are skipped. \t (tabs) wouldn't work either with single quotes. If you change it to this:

$output .= ''.$item.' '.$qty."\n";

it will work.

Notice how you do it down in the headers section?

$headers = 'From: [e-mail]' . "\r\n" . 

[mbx5nitro]

Thanks bpat1434,

I knew it was something so easy i over looked it. It works great now.

[mbx5nitro]

Once again im looking over something to much and messing up.
In this code

case 'order':
		global $db;
		$myuser = $_SESSION['myusername'];
		$cart = $_SESSION['cart'];
		$items = explode(',',$cart);
		$contents = array();
		foreach ($items as $item) {
			$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
		}
 		$output = '';
		foreach ($contents as $id=>$qty) {
			$sql = "SELECT email, firstname FROM ilogin WHERE username='$myuser'";
            $sql = 'SELECT * FROM cvs_data WHERE id = '.$id;
            $result = $db->query($sql);
            $row = $result->fetch();
            extract($row);
            $output .= ''.$item.' '.$qty."\n";
        } 
		$to      = '[e-mail]';
		$subject = ''.$firstname.' Order';
		$message = ''.$output.'';
		$headers = 'From: '.$email.'' . "\r\n" .
   		'X-Mailer: PHP/' . phpversion();
		mail($to, $subject, $message, $headers);
	break;

I cant get it to get the email or firstname variables from the ilogin database.
Any ideas

[bradgrafelman]

You define a query for that table, but then you never do anything with it. Right after that, you define a new query in $sql.

I'm jumping into this in the middle, so I'm not quite sure what's being done here, but you need to query and then fetch data from the database after you define the query for the ilogin table in $sql and BEFORE you re-define the $sql variable with a separate query for the cvs_data table.

[mbx5nitro]

So for the first query i made it this

			$sql = "SELECT email, firstname FROM ilogin WHERE username='$myuser'";
			$result = $db->query($sql);
			$row = $result->fetch();

But it still doesnt work. any more ideas i know it is something simple.

[bradgrafelman]

After you do that, you'll need to pull variables out of $row. Later in your script, you have this:

        $subject = ''.$firstname.' Order'; 
        $message = ''.$output.''; 
        $headers = 'From: '.$email.'' . "\r\n" .

I'm assuming the firstname and email variables you used are supposed to come from the database? Well how is PHP to know what they are unless you define them?

After you fetch the data from the database, use [man]extract[/man] like you did in your second query to pull variables out of the $row array.

[mbx5nitro]

I knew it was something simple. lol

but now im getting this error.
Warning: extract(): First argument should be an array in /home/httpd/vhosts/robertstropicalfish.com/httpdocs/products/confirm.php on line 43

[bradgrafelman]

Actually, apparently fetch() is supposed to extract the results into variables by itself. (Sorry for my lack of experience here - I don't use PHP5 nor MySQLi nor any OOP stuff :p).

Get rid of the extract() stuff, and do this:

$sql = "SELECT email, firstname FROM ilogin WHERE username='$myuser'"; 
            $result = $db->query($sql); 
            $result->bind_result($email, $firstname);
            $row = $result->fetch(); 
echo 'Test name: ' . $firstname;

Does it show the name correctly?

[mbx5nitro]

OK with it like this now

	case 'order':
		global $db;
		$myuser = $_SESSION['myusername'];
		$cart = $_SESSION['cart'];
		$items = explode(',',$cart);
		$contents = array();
		foreach ($items as $item) {
			$contents[$item] = (isset($contents[$item])) ? $contents[$item] + 1 : 1;
		}
 		$output = '';
		foreach ($contents as $id=>$qty) {
			$sql = "SELECT * FROM ilogin WHERE username='$myuser'";
			$result = $db->query($sql);
			$row = $result->fetch();
            $sql2 = 'SELECT * FROM cvs_data WHERE id = '.$id;
            $result2 = $db->query($sql2);
            $row2 = $result2->fetch();
			extract($row2);
            $output .= ''.$item.' '.$qty."\n";
        } 
		$to      = '[e-mail]';
		$subject = ''.$firstname.' Order';
		$message = ''.$output.'';
		$headers = 'From: '.$email.'' . "\r\n" .
   		'X-Mailer: PHP/' . phpversion();
		mail($to, $subject, $message, $headers);
	break;

I gets the $email but not the $firstname

[bradgrafelman]

As I mentioned, I'm not experienced in MySQLi. In addition, I'm not exactly sure on your table structure and whatnot, so I'm afraid this has progressed beyond my capabilities.

Sorry I couldn't help!

[mbx5nitro]

I figured it out. I had trouble with the id feilds in the 2 tables. after i changed to first query to only get what i needed all worked well. Thanks for the help.