extract function in php_PHP tutorial

The extract function is used to decompose a number into multiple variables for direct use. The following is the W3C's explanation: The PHP extract() function imports variables from an array into the current symbol table. For each element in the array, the key name is used for the variable name and the key value is used for the variable value. The second parameter type is used to specify how the extract() function treats such conflicts when a variable already exists and there is an element with the same name in the array. This function returns the number of successfully set variables.

The following table is parameter description:

Grammar

extract(array,extract_rules,prefix)

Parameters Description

array Required. Specifies the input to use.

extract_rules

Optional. The extract() function will check whether each key name is a legal variable name, and also checks whether it conflicts with the variable name in the symbol table.

The handling of illegal, numeric and conflicting key names will be determined based on this parameter. Can be one of the following values:

Possible values:

EXTR_OVERWRITE - Default. If there is a conflict, existing variables are overwritten.

EXTR_SKIP - Do not overwrite existing variables if there is a conflict. (Ignore elements with the same name in the array)

EXTR_PREFIX_SAME - Prefix the variable name with prefix if there is a conflict. As of PHP 4.0.5, this also includes handling of numeric indexes.

EXTR_PREFIX_ALL - Prefix all variable names with prefix (third parameter).

EXTR_PREFIX_INVALID - Prefix only illegal or numeric variable names with prefix. This tag is newly added in PHP 4.0.5.

EXTR_IF_EXISTS - Only overwrite the values ​​of variables with the same name if they already exist in the current symbol table. Others are not processed. It can be used when a set of legal variables has been defined, and then you want to overwrite these variables by extracting values ​​from an array such as $_REQUEST. This tag is newly added in PHP 4.2.0.

EXTR_PREFIX_IF_EXISTS - Only when a variable with the same name already exists in the current symbol table, a variable name with a prefix is ​​created, and nothing else is processed. This tag is newly added in PHP 4.2.0.

EXTR_REFS - Extract variables as references. This is a strong indication that the imported variable still references the value of the var_array parameter. This flag can be used alone or in combination with any other flag using OR in extract_type. This tag is newly added in PHP 4.3.0.

prefix

Optional. Note that prefix is ​​only required if the value of extract_type is EXTR_PREFIX_SAME, EXTR_PREFIX_ALL, EXTR_PREFIX_INVALID or EXTR_PREFIX_IF_EXISTS. If the result after appending the prefix is ​​not a legal variable name, it will not be imported into the symbol table.

An underscore is automatically added between the prefix and the array key name.

This is very useful when getting a row of data from the database. Let’s take a look at the following example

Copy code

$db = mysql_connect('localhost','root','Ctrip07185419') or die('can not connect to mysql');

mysql_select_db('moviesite',$db) or die(mysql_error($db));

mysql_query('set names gbk',$db);

if(isset($_GET['action']) && $_GET['action'] == 'edit')

{

$query = 'SELECT movie_name,movie_type,movie_year,movie_leadactor,movie_director FROM movie WHERE movie_id='.$_GET['id'];

//echo $query;

$result = mysql_query($query, $db) or die(mysql_error($db));

extract(mysql_fetch_assoc($result));

}

else

{

$movie_name='';

$movie_type=0;

$movie_year=date('Y');

$movie_leadactor=0;

$movie_director=0;

}

?>

                                                                                   

           

                    Movie Name

                   

               

               

                    Movie Type

                   

                   

                        $query = 'select movietype_id,movietype_label from movietype order by movietype_label';

                        $result = mysql_query($query , $db) or die(mysql_error($db));

                        while($row = mysql_fetch_assoc($result))

                        {

                            if($row['movietype_id'] == $movie_type)

                            {

                                echo ''.$row["movietype_label"].'';

                            }

                            else

                            {

                                echo ''.$row["movietype_label"].'';

                            }

                        }

                    ?>

                   

               

               

                    Movie Year

                   

                   

                        for($yr = date('Y');$yr>1970;$yr--)

                        {

                            if($yr == $movie_year)

                            {

                                echo ''.$yr.'';

                            }

                            else

                            {

                                echo ''.$yr.'';

                            }

                        }

                    ?>

                   

               

               

                    Lead actor

                   

                   

                        $query = 'select people_id,people_fullname from people where people_isactor = 1 order by people_fullname';

                        $result = mysql_query($query,$db) or die(mysql_error($db));

                        while($row = mysql_fetch_assoc($result))

                        {

                            if($row["people_id"] == $movie_leadactor)

                            {

                                echo ''.$row["people_fullname"].'';

                            }

                            else

                            {

                                echo ''.$row["people_fullname"].'';

                            }

                            

                        }

                    ?>

                   

               

               

                    Director

                   

                   

                        $query = 'select * from people where people_isdirector=1 order by people_fullname';

                        $result = mysql_query($query , $db) or die(mysql_error($db));

                        while($row = mysql_fetch_assoc($result))

                        {

                            if($row['people_id'] == $movie_director)

                            {

                                echo ''.$row["people_fullname"].'';

                            }

                            else

                            {

                                echo ''.$row["people_fullname"].'';

                            }

                        }

                    ?>

                   

               

               

                   

                       

                        if('edit' == $_GET['action'])

                        {

                            echo '';

                        }

                        ?>

                       

                   

               

           

       

   

复制代码

 

 

注意标红的语句，在使用extract之后可以直接使用变量，并且变量的名字是字段名字，变量的值是字段的值，这个有点类似于ado.net中从DataReader或DataSet中取得数据的方法Movie.Name = DataSet.Table[o].Row[i]["Name "].ToString()  Movie.Name=reader["Name "].ToString();

http://www.bkjia.com/PHPjc/766055.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/766055.htmlTechArticleextract函数用来将一个数字分解成多个变量直接使用，下面是W3C的解释：PHP extract() 函数从数组中把变量导入到当前的符号表中。对于数组中...

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Show More

Hot Article

How to fix KB5055612 fails to install in Windows 10?

4 weeks ago By DDD

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys

4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Roblox: Grow A Garden - Complete Mutation Guide

3 weeks ago By DDD

Nordhold: Fusion System, Explained

4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Mandragora: Whispers Of The Witch Tree - How To Unlock The Grappling Hook

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Show More

Hot Tools

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Show More

Hot Topics

Java Tutorial

1673

14

CakePHP Tutorial

1428

52

Laravel Tutorial

1333

25

PHP Tutorial

1278

29

C# Tutorial

1257

24

Show More