join

(PHP 4, PHP 5)

join — 别名 implode()

说明

此函数是该函数的别名： implode().

lcfirst

implode

[edit] Last updated: Fri, 25 May 2012

add a note User Contributed Notes join

John 28-May-2012 10:42


An example of table join.



<?php

$conn = mysql_connect("localhost", "username", "password");

mysql_select_db("database name", $conn)

or die ('Database not found ' . mysql_error() );

$sql = "select * from consumer, application where consumer.consumernum = application.consumernum and applicationnum = $variable";

$rs = mysql_query($sql, $conn)

or die ('Issue arose with query' . mysql_error());

?>

datacompboy at call2ru dot com 21-Feb-2009 09:43


Very useful function i have using: joinr (join-recursive).

It allows you easy join of multi-level arrays.

For example, if you have

  $intervals = array(array(5, 9), array(11, 15), array(22, 24))

and want to have comma-separated list of dash-separated intervals, just do

  print joinr(array(",","-"), $intervals);



Here is function code:

<?php

    function joinr($join, $value, $lvl=0)

    {

        if (!is_array($join)) return joinr(array($join), $value, $lvl);

        $res = array();

        if (is_array($value)&&sizeof($value)&&is_array(current($value))) { // Is value are array of sub-arrays?

            foreach($value as $val)

                $res[] = joinr($join, $val, $lvl+1);

        }

        elseif(is_array($value)) {

            $res = $value;

        }

        else $res[] = $value;

        return join(isset($join[$lvl])?$join[$lvl]:"", $res);

    }

?>

manbss at yahoo dot co dot in 09-May-2007 09:38


<?php



$array = array('lastname', 'email', 'phone');

$comma_separated = join(",", $array);



echo $comma_separated; // lastname,email,phone



?>

add a note