[PHP-DB] grid unsetting vars
We'll I've got a query based on mysql_fetch_object to show the results of the previous search and print them out in tables. Then I got the the $grid idea for printing an array in a horizontally columned table from the book php cookbook from o'reilly (quite useful) then I print it all insed the grid, but when it is supposed to send the selected objects with a checkbox to the next page. It doesn't while everything works just fine without the grid. #sigh# I've tried to see what's the grid doing to my checkboxes that i the end they don't send anything at all bu i cant see what. Does anyone? ... while ($inb = mysql_fetch_object($resultInfs)) { //trying to put it right --- values --- if (!empty($inb->pix)) $ipix=""; } else { $ipix=""; } if (!empty($inb->infType)) { $ity="$inb->infType,"; } if (!empty($inb->infName)) { $inm="$inb->infName"; } if (!empty($inb->infRef)) { $irf="$inb->infRef"; } if (!empty($inb->infMeas)) { $ims="$inb->infMeas"; } if (!empty($inb->infSerial)) { $isr="SERIAL N°: $inb->infSerial"; } if (!empty($inb->infDescription)) { $ids="DETAILS: $inb->infDescription,"; } if (!empty($inb->infArtw)) { $irt="$inb->infArtw,"; } if (!empty($inb->infCover)) { $irc="$inb->infCover,"; } // T.T $value deosn't go as $_POST for orderdata.php!!! $value = $inb->infID; //for function, hope as objects $infs[ ] = $ipix.' '.$ity.' '.$inm.' '.$irf.' '.$ims.' '.$isr.' '.$ids.' '.$irt.' '.$irc.' '.$value; } ///changes to function from phpckbk function grid_horizontal($array, $size) { // compute width %ages $table_width = 100; $width = intval($table_width / $size); $grid = "$tr"; // define how our and tags appear // sprintf() requires us to use %% to get literal % $tr = ''; $td = "%sAdd to Cart!"; // open table // loop through entries and display in rows of size $sized // $i keeps track of when we need a new table tow $i = 0; foreach ($array as $e) { $grid .= sprintf($td, $e); $i++; // end of a row // close it up and open a new one if (!($i % $size)) { $grid .= "$tr"; } } // pad out remaining cells with blanks while ($i % $size) { $grid .= sprintf($td, ' '); $i++; } // add , if necessary $end_tr_len = strlen($tr) * -1; if (substr($grid, $end_tr_len) != $tr) { $grid .= ''; } else { $grid = substr($grid, 0, $end_tr_len); } // close table $grid .= ''; return $grid; } //final results printing $grid = grid_horizontal($infs, 3); print $grid; If the grid can not work with a sending to another php (that is with my checkboxes, how could i print them ordered then? - Créez gratuitement votre Yahoo! Mail avec 100 Mo de stockage ! Créez votre Yahoo! Mail Le nouveau Yahoo! Messenger est arrivé ! Découvrez toutes les nouveautés pour dialoguer instantanément avec vos amis.Téléchargez GRATUITEMENT ici !
[PHP-DB] error on count()
hello, this is problably newbie question, but I can not understand why my count() function doesn't work. I need to count how many items has a determinated customer ordered ever. 1. I tired to get the array like this: $una = $check["uname"]; function orderquantity ($una) { $pss = mysql_query("SELECT OID FROM orders WHERE una = '".trim($una)."'") or die (mysql_error("Query error on Order search")); while($pisao=mysql_fetch_array($pss)) { return count($pisao); } } $okuan = orderquantity(); 2. and like this: $una = $check["uname"]; function orderquantity ($una) { $pss = mysql_query("SELECT OID FROM orders WHERE una = '".trim($una)."'") or die (mysql_error("Query error on Order search")); return count($pss); } okuan = orderquantity(); None of them gave me a valid value, is it because the OID is an int value? - Créez gratuitement votre Yahoo! Mail avec 100 Mo de stockage ! Créez votre Yahoo! Mail Le nouveau Yahoo! Messenger est arrivé ! Découvrez toutes les nouveautés pour dialoguer instantanément avec vos amis.Téléchargez GRATUITEMENT ici !
[PHP-DB] split query per $_POST???
Could anyone, please, help me with this one. If I add the insert inside the loop it inserts as many orders in the order table as products have been chosen. There is really no way to split this? I have a problem with a script that gets the ID's of the selected products from the previous script and shows them with mysql_fetch_object. Now I'd like to insert them in the db, but when I pass every value to $vars and insert them it inserts only one of the selected products. I tried a change with mysql_fetch_array, with split and implode, ...useless. How can I get the products to be apart without breaking the values, ie, put name of all the selected products in name field in the db, put serial number of the selected products in serial field in the db, etc?: ... while($isc = mysql_fetch_object($antw)){ if (!empty($isc->pic)) { echo (""); } if (!empty($isc->Meas)) { echo ("$isc->infMeas"); } if (!empty($isc->Name)) { echo ("$isc->Name, "); } if (!empty($isc->Ref)) { echo ("$isc->Ref,"); } $ipic = $isc->pic; $iMeas = $isc->Meas; $iName = $isc->Name; $iRef = $isc->Ref; } ... $dem = "INSERT INTO orders VALUES('$ipic','$iMeas','$iName','$iRef'); ... By the way how can I get them apart in the previous page by rows of 3 products each in the table?: ... echo (""); if (!empty($inb->pic)) { echo (""); } else { echo (""); } if (!empty($inb->Type)) { echo ("$inb->Type,"); } if (!empty($inb->Name)) { echo ("$inb->Name"); } if (!empty($inb->Ref)) { echo ("$inb->Ref"); } if (!empty($inb->Meas)) { echo ("$inb->Meas"); } if (!empty($inb->Ref)) { echo ("$inb->Ref"); } if (!empty($inb->Serial)) { echo ("SERIAL N°: $inb->Serial"); } if (!empty($inb->Description)) { echo ("DETAILS: $inb->Description,"); } if (!empty($inb->Artw)) { echo ("$inb->Artw,"); } if (!empty($inb->Cover)) { echo ("$inb->Cover,"); } echo (""); - Créez gratuitement votre Yahoo! Mail avec 100 Mo de stockage ! Créez votre Yahoo! Mail Le nouveau Yahoo! Messenger est arrivé ! Découvrez toutes les nouveautés pour dialoguer instantanément avec vos amis.Téléchargez GRATUITEMENT ici !