php - How to print multiple ID's from a $_GET variable using while() and array() -


i'm here today because i'm under minor issue can't seem solve , it's why brings here. issue i'm trying multiple id's $_get variable print out. tried use array , great, works thing makes separate arrays [0] , need 1 in same array not array() array() doing.

so i'm using while() mysql_fetch_array results off database , depends on $_get url in-order grab correct id's. in url pass in api.php?do=remove&id=1,4,7 print out first id , not others name. said tried array() , came out :

array ( [0] => bzlxo.jpg ) array ( [0] => chztk.jpg ) array ( [0] => 9yset.jpg ) array ( [0] => ss04v.jpg )

i don't understand why doing need in 1 array in

array ( [0] => bzlxo.jpg, [1] => chztk.jpg, [2] => 9yset.jpg, [3] => ss04v.jpg )

so way when implode them show text in: "you removed image(s) "bzlxo.jpg,chztk.jpg,9yset.jpg,ss04v.jpg" like

 $iname[imagename] = array($iname[imagename]); $name = implode(",", $iname[imagename]);

here code:

this url "api.php?do=remove&id=1,4,7"

 $id = $_get['id']; $query = "select id,imagename uploads id in ({$id}) , username = '{$uploader}'"; $result = mysql_query($query); while( $iname = mysql_fetch_array($result)){ $querys = "delete uploads id in ({$id}) , username = '{$uploader}'"; $results = mysql_query($querys); if(!$results) { $api_message = 'failed removal result'; } else { $iname[imagename] = array($iname[imagename]); $name = implode(",", $iname[imagename]); $api_message = "you removed image(s) $name"; } }

the output :

you removed image(s) bzlxo.jpg

but need be:

the output : removed image(s) "bzlxo.jpg,chztk.jpg,9yset.jpg,ss04v.jpg"

any appreciated, if more information needed please let me know , i'll include

in addition solution posted raina77ow, there problem control flow in executing delete uploads id in (...) statement each iteration of while loop. delete records on first iteration. need change like:

$id = $_get['id']; $names = array(); $query = "select id,imagename uploads id in ({$id}) , username = '{$uploader}'"; $result = mysql_query($query); while( $iname = mysql_fetch_array($result)){ $querys = "delete uploads id = {$iname['id']} , username = '{$uploader}'"; $results = mysql_query($querys); if(!$results) { $api_message = 'failed removal result'; } else { $names[] = $iname['imagename']); } } $name = implode(",", $names); $api_message = "you removed image(s) $name";

Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more