In PHP, the implode () function combines array elements into a string, and the explode function is exactly what it is, and here are some examples of implode functions.
Grammar
Implode (Separator,array)//array, separator is a separator.
Example
Link search Conditions $wheresql = implode (' and ', $wherearr); Link search condition function simplode ($ids) {return "'". Implode ("', '", $ids). "'"; $itemidarr = Array (); Initialize the Itemidarr array if (empty ($_post[' item ')) { //To determine if there are pending records submitted, and if not, display a message and exit showmessage (' Space _no_item '); } $itemidstr = Simplode ($_post[' item '); Link all operation IDs with commas //Check submitted data
Instance 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 operation IDs with commas
Examples of SQL statements:
Select UID, name, Namestatus from ". Tname (' space ')." 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.
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& ') "is deleted. 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 opposite to the split () explode () function, which is split with a character (such as a comma), while the former can be stitched together as a string.