Splitting up a string

tom_s

This involves a database, but it's 99% a PHP issue which is why I posted this in this forum.

Okay, I'm having a go at making a shopping cart system, a little mini-project to get back into PHP.

It's all going well so far, have a working login/account system. But I've hit a snag.

The way I've done it, is that all products have their own 'pid', or product ID. When a user adds a product to their shopping cart, it adds the pid of that item to the end of the users 'basket' field in the database.

So, for example, the user adds an item with a pid of '24' to his or her shopping basket, their 'basket' field would read '24'. If they then added another product with the pid '12', their basket field would then read '24, 12'. I haven't tried implementing this yet, still thinking of the best way to do it, if someone could suggest a better way, please do 😃

Okay, so here is were I'm a little stuck. Let's say that the user has added several items to their shopping basket, and are ready to order.

In my mind, I figured they would click the 'Order' button, then the PHP script would look at that users basket field, and basicly split all the numbers up into an array that I could then use to list everything that they are ordering.

That's where I'm stuck, how would I go about splitting up '12, 24, 1, 76, 1' into an array, without the commas, so it's usable in a PHP script.

Thanks,

rincewind456

With explode()

tom_s

Thanks, that worked great 😃

Another question, I've managed to use explode to be able to list everything in the 'basket' field, however I can't seem to work out how to check for quantities.

Say, if the basket field contains '1, 23, 12, 1, 1' at the moment it outputs:

Product 1

Product 23

Product 12

Product 1

What I'm looking for is for the output to be something like:

Quanity: Name:

3 Product 1
1 Product 12
1 Product 23

I've looked at different functions like split and implode, don't think they are the ones I need to use. Any ideas?

tom_s

Just looked at the trim(); function.

That is 'almost' what I'm looking for.

This is kind of what I have so far:



	//select user
		$query = "SELECT * FROM users WHERE uname='" . $username . "'";
		$result = mysql_query($query, $conn);

		$data = mysql_fetch_array($result);

		//Get basket contents
		$basket = $data['basket'];

		//split string up, count entries

		$contents = explode(",", $basket);
		$count = count($contents);

		//display table

		echo "<TABLE>
				<TR>
					<TD>Quantity</TD>
					<TD>Name</TD>
					<TD>Price per unit</TD>
					<TD>Line Cost</TD>
				</TR>";

		//loop through, display array

		for ($i=0; $i<$count; $i++)
		{

		//look in database for products matching what user has ordered
		$query2 = "SELECT * FROM products WHERE pid='$contents[$i]'";

		$result2 = mysql_query($query2, $conn);

		$numrows = mysql_numrows($result2);


			if ($numrows != "1"){
					echo "Error: One or more of the items you requested was not found.";
			};


		//count number of duplicates
		//--> this is where im stuck <--


		$data2 = mysql_fetch_array($result2);

		$p_name = $data2['name'];
		$p_costpu = $data2['saleprice'];

		echo "<TR>
				<TD></TD>
				<TD>$p_name</TD>
				<TD>$p_costpu</TD>
				<TD></TD>
			</TR>";		


		};

		//close table

		echo "<TR>
				<TD><B>Total Price</B></TD>
				<TD></TD>
				<TD></TD>
				<TD>0isk</TD>
			</TR>";

Installer

Use array_count_values.