[RESOLVED] Help Creating String From Query

[fotofx]

I have a database table called orders_products that includes three columns called products_model, products_quantity,orders_id

There may be one or several items with the same orders_id that I need to create a string from. I would need to query by the orders_id and return all matching records in a string like the below example.

Ordered products: format is "q1#model1|q2#model2|..." where q1 is the quantity for the product with the model1. Use | to separate any number of products.
Example:"1#itema|2#itemb|1#itemc|5#itemd"

I am fairly new at this and can figure out how to get 1 record but an order can have multiple products. Inserting the divider is also driving me crazy because it only goes between and not before or after..

Any help is appreciated
Steve

[laserlight]

One way to do that would be to use [man]implode/man, e.g.,

$products = array();
while ($row = $stmt->fetch()) {
    $products[] = $row['quantity'] . '#' . $row['model'];
}
echo implode('|', $products);

[fotofx]

Hmm.. That generates:

PHP Fatal error: Call to a member function fetch() on a non-object

Steve

[laserlight]

PHP Fatal error: Call to a member function fetch() on a non-object

Well, you obviously cannot blindly use my example code. Do you understand my example? It uses the PDO extension, though fetch() is rather generic where database wrappers are concerned.

[fotofx]

No, I really don't understand it. I appreciate the help.

Steve

[laserlight]

Okay, what is your current code?

[fotofx]

Here is my current query.

$products_array = array();
$products_query = mysql_query("select products_id, products_name,products_quantity,products_model from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$orders['orders_id'] . "' order by products_name");
while ($products = mysql_fetch_array($products_query)) {
  $products_array[] = array('id' => $products['products_model'],
                            'text' => $products['products_name'],
                            #'style' => ''ducts['products_model'],
                            'qty' => $products['products_quantity']);
}

Steve

[laserlight]

Try this:

$products_query = mysql_query("SELECT products_quantity, products_model
    FROM TABLE_ORDERS_PRODUCTS
    WHERE orders_id = '" . (int)$orders['orders_id'] . "'");

$products = array();
while ($row = mysql_fetch_assoc($products_query)) {
    $products[] = $row['quantity'] . '#' . $row['model'];
}
echo implode('|', $products);

The idea is to retrieve the quantity and model, then loop through the result set and create an array of string. Each string will have the quantity with the # and the model appended. Then you use implode() to join the strings together with the | as the glue.

[fotofx]

Seems to be working but now I have to move that to part of another array. Here is a snippet of that code. Does this look right?

$awd_values = array
(
"cust_id" => $awd_cust_id,
"tran_key" => $awd_tran_key,
"testmode" => $TESTING,
"order_type" => "wholesale",
"order_products" => $products,
"order_continueifnotexist" => 1,
"invoicebymail" => 1
);

[laserlight]

It seems that your snippet of code has not actually done the "move that to part of another array".

[fotofx]

"order_products" => $products,

shouldn't this do it?

[fotofx]

laserlight, you there??

[fotofx]

laserlight, I think my problem is that I do not truly understand how arrays work. My background was in Dataflex programming and thinks were done using "MOVE" commands. I understand that the array now has two rows named "quantity" and "model", What I am having difficulty figuring out is how to get that data over to a string varible. If it was only one I think I could figure it out but because there are no set number of items, that is where I am confused. How would I figure out how many items are in the array? Could I then do a loop that would put them in the string and stop when the number of items is reached???

Thanks for the help.
Steve

[laserlight]

I understand that the array now has two rows named "quantity" and "model", What I am having difficulty figuring out is how to get that data over to a string varible.

Oh, sorry, I did not understand what you meant by "move". Yes, your code would copy $products to $awd_values['order_products'].

How would I figure out how many items are in the array?

You can use [man]count/man. However...

Could I then do a loop that would put them in the string and stop when the number of items is reached?

To loop over an associative array, we would use a foreach loop. As such, I am not sure what you mean by "number of items".

[fotofx]

Now I am really confused, Where did we copy $products to $awd_values['order_products']?

[laserlight]

Now I am really confused, Where did we copy $products to $awd_values['order_products']?

On this line:

"order_products" => $products,

You might want to read the PHP manual on arrays.

[fotofx]

OK, I see where we did it but the array is coming back empty. I think it needs to be a simple string before going into the $awd_values. It looks like we are putting an array in the array. When it is transmitted they are getting everthing else but that one varible.

[fotofx]

Not only did I read the manual but I went out last night and bought "PHP5 and MySql Bible" Of course it may take me awhile to get through the 1000+ pages.

Is there a simple way of converting the array you created to a string formatted like I need?

Thanks

[fotofx]

I tried a print_r($products) and it returns

Array ( )

[laserlight]

Is there a simple way of converting the array you created to a string formatted like I need?

I think you need to be clear on what you are doing. Honestly, I have no idea which array and which string you are talking about.