Implode () function in PHP implements character concatenation

Grammar

Implode (Separator,array)//array is an array, separator is a cut character.

Example

The code is as follows

Copy Code

Link search criteria $wheresql = Implode (' and ', $wherearr); Link search criteria function Simplode ($ids) { Return "'". Implode ("', '", $ids). " } $itemidarr = Array (); Initializing the Itemidarr array if (Empty ($_post[' item ')) {//Judge if there is a record to be done, if not, display the message and exit ShowMessage (' Space_no_item '); } $itemidstr = Simplode ($_post[' item ']); Link all action IDs with commas Check the submitted data

Instance code:

The code is as follows	Copy Code
$catidarr = Array (); if (!empty ($t 1)) $catidarr [] = ' \ '. $t 1. ' if (!empty ($t 2)) $catidarr [] = ' \ '. $t 2. ' if (!empty ($t 3)) $catidarr [] = ' \ '. $t 3. ' $catidstr = Implode (', ', $catidarr); Link all action IDs with commas

Examples of SQL statements:

The code is as follows	Copy Code
SELECT uid, name, Namestatus from ". Tname (' spaces ')." WHERE uid in (". Simplode ($uids).")

example, bulk delete data

SQL: $SQL = "Delete from ' doing ' where ID in (' 1,2,3,4 ')";

Data is separated by commas.

The code is as follows	Copy Code
Form: <form action= "? action=doing" method= "POST" > <input name= "id_dele[]" type= "checkbox" id= "id_dele[]" value= "1"/> <input name= "id_dele[]" type= "checkbox" id= "id_dele[]" value= "2"/> <input name= "id_dele[]" type= "checkbox" id= "id_dele[]" value= "3"/> <input name= "id_dele[]" type= "checkbox" id= "id_dele[]" value= "4"/> <input type= "Submit"/> </form>

Good $id_dele=$_post[' Id_dele ' will be an array, although PHP is a weak type, but there is no ASP weak. ASP can directly:

sql= delete from [doing] where ID in (' &ID_Dele& '). But PHP can't put $id_dele directly in. Because $id_dele is not ' 1,2,3,4 ' Oh, because $id_dele is an array with keys and values.

Well, PHP is not difficult, just have a function: implode (), right. A function that is exactly the opposite of the split () explode () function, which is separated by a character (such as a comma), and the former can be spliced into a string.

So:

The code is as follows	Copy Code
$ID _dele= implode (",", $_post[' Id_dele ')); $SQL = "Delete from ' doing ' where ID in ($ID _dele)";