Implementation of using AR to directly output one-dimensional array in A Bei job / Yii

I haven"t given an AR assignment for a long time. Today we"ll take a look at my needs.

there is a datasheet, user (id, username and created_at, with a total of 4 records. This is required for the job. Use AR to achieve the following results:

An one-dimensional array whose key is user"s id, array and value"s user"s username, is similar to the following result

[
    1=>"abei",
    2=>"abei2017",
    11=>"abei2018"
]

remember, only use AR, without resorting to other class libraries, such as Helper::map

Yii2

Mar.28,2021

php built-in array: array_column ()

yii's built-in indexBy and column methods are used to implement the requirements in the problem.

  https://nai8.me/article/detai.


										
												Previous: Address problem of nuxt request backend
												                		Next: The default value of SpringBoot Jpa MySql field is CURRENT_TIMESTAMP invalidation
                							
					
						
					
															
						
														
								Yii2 adminlte
								 how do I set the menu highlight? ...
								
									
																														Yii2
																				php
																			
									
										Mar.04,2021
									
								
							
														
								Upload yii2 pictures
								 how does yii2 upload pictures across servers? There is no corresponding expansion package recommendation. Thank you ...
								
									
																														Yii2
																				php
																			
									
										Mar.04,2021
									
								
							
														
								How can the template variables of the PHP framework be used globally?
								
 I want some template variables to be available globally, such as some system setup information and website title classes, and different modules may need to call the same variables. how can such variables be used globally? 
 now I  ve done a simple test ...
								
									
																														Php
																				laravel
																				thinkphp5
																				yii2
																			
									
										Mar.05,2021
									
								
							
														
								Yii2 failed to survive composer install on the server
								
 Yii2 failed to survive composer install on the server 
root@dv: home dv-sharp composer install
Do not run Composer as root super user! See https:  getcomposer.org root for details
Loading composer repositories with package information
Installing depende...
								
									
																														Composer
																				yii2
																				yii
																			
									
										Mar.05,2021
									
								
							
														
								Yii2 calls interface across controllers?
								 how can yii2 be called across controller calling interfaces, and parameters can be passed in. ...
								
									
																														Yii2
																				php
																			
									
										Mar.05,2021
									
								
							
														
								How yii2 uses leftjoin to generate on. And query statement
								
$sql = Wrong::find()->where([
              t.fdUserID   => 4,
              t.fdStatus   => 0
        ])->alias(  t  )->leftJoin(Exercise::tableName().   exercise  ,  exercise.id=t.fdExerciseID  ,[  exercise.fdStatus  =>1]);
print_r($s...
								
									
																														Yii2
																			
									
										Mar.06,2021
									
								
							
														
								How to realize dynamic attribute assignment in yii2
								 1. The client passes a value to the server such as: username=admin  instantiate a class on the server, and the simple assignment is as follows:  $userform=new UserForm ();  $userform- > username=  "admin ";  but if the client passes password=  "123456 " ...
								
									
																														Yii2
																				php
																			
									
										Mar.06,2021
									
								
							
														
								Do the API interface, why should access_token be passed in the Header header?
								
What are the advantages of  compared to using post? 
 in addition, token changes every time you log in, so how does multi-side login work? 
...
								
									
																														Yii2
																				interface-design
																				php
																			
									
										Mar.07,2021
									
								
							
														
								(controller) query of routing configuration item in Yii2
								
  
 the document address is  https:  www.yiiframework.com .
 does not understand the  controller  configuration here. My first reaction was to name user  u , but I visited  http:  xxx.com u could not access (404)   so how to understand this configuration...
								
									
																														Yii2
																				yii2-routing
																			
									
										Mar.10,2021
									
								
							
														
								How to realize the Web Page Preview function by PHP
								
 premise: to generate a landing page according to a template, DB stores only the pictures or text information to be replaced. 
< hr >

 to make an online landing page creation tool, how to realize the preview function after the H5 page is finished, simil...
								
									
																														Php
																				yii2
																			
									
										Mar.10,2021
									
								
							
														
								PHP traverses two array problems for advice and uses the value of B to fill the value of A.
								
 Array A: 
$a = [
    0 => [  num   => 100],
    1 => [  num   => 105],
    3 => [  num   => 253],
    N.......
]
 Array B: 
$b = [
    0 => [
          id   => 1,
          num   => 300
    ],
    1 => [
          id   =>...
								
									
																														Php
																				laravel
																				yii2
																				thinkphp5
																			
									
										Mar.10,2021
									
								
							
														
								Questions about Yii2 yii\ web\ Application
								
  index.php  
$application = new yii  web  Application($config);
$application->run();
   yii   base   Application::__construct ()   
public function __construct($config = [])
{
    Yii::$app = $this;
    static::setInstance($this);
    $this->state...
								
									
																														Yii
																				yii2
																			
									
										Mar.11,2021
									
								
							
														
								Help to analyze the reasons for the slow running of YII2.
								
 I installed the advance version, which runs very fast on other people  s virtual machines. It takes me more than 3 seconds to run, just a simple page .
 enabled, but opcache,session uses redis 
   ask for help, thank you! 
...
								
									
																														Yii2
																				php
																			
									
										Mar.12,2021
									
								
							
														
								Can the Yii2 framework redis key prefix be configured?
								
 scenario  because redis is shared with other parts. In addition to specifying the library, we also need to prefix all key of our project with a  webapp:  prefix.  I now configure a    redis.prefix   = >   webapp:     in params.php.
 then use `Yii::$app-...
								
									
																														Yii2
																			
									
										Mar.15,2021
									
								
							
														
								Yii2 page turning problem
								
 I use the page flip in YII2, there is nothing on the page, and there is no error report, who will see what  s going on? I  ll post the code here.  regardless of the logic of the code, you can see  "previous page, next page " on a few code pages, but now...
								
									
																														Turn-the-page
																				yii2
																			
									
										Mar.16,2021
									
								
							
														
								How is YII2 written and configured before and after all action requests?
								
 this is my ActionTimeFilter, so how can I configure it in web.php to enable every action to pass through this filter? Wait online. I  ve been in a hurry all day. Is it so good? 
<?php
namespace app  filters;

use Yii;
use yii  base  Action;
use yii  ...
								
									
																														Yii2
																				php
																			
									
										Mar.17,2021
									
								
							
														
								Yii restful request 405
								
 the default RESTful, in the advanced application template prompts 405 Method Not Allowed [version 2.0] except GET 
 I follow the similar method of creating a new application body in the advanced application template in this article, copy the Backend app...
								
									
																														Yii2
																				php
																				yii
																			
									
										Mar.18,2021
									
								
							
														
								Yii2 php recycle mysql transactions
								
 hi, Hello, everyone.  there are now ten pieces of data that need to be inserted and ten pieces of data that need to be updated. The data that needs to be inserted in suspense is a1memery a2magina3.a10, and the data that needs to be updated is b1memb2rec...
								
									
																														Php-Framework
																				yii2
																				mysql
																				transaction
																			
									
										Mar.20,2021
									
								
							
														
								Cpu99% when phpexcel reads the file
								

  **
     * Excels
     *
     * @param string $file
     * @param array  $sheet_names
     *
     * @return array|bool
     * @throws   PHPExcel_Exception
     * @throws   PHPExcel_Reader_Exception
     * 
    public static function importExcel($file, ...
								
									
																														Cpu-is-too-high
																				yii2
																				phpexcel
																				excel
																				php
																			
									
										Mar.20,2021
									
								
							
														
								Similar to the front-end rights management of the discuz forum, how to design and implement it?
								
 want to implement a front-end privilege management similar to discuz: 

 Management group (ordinary members, moderators, VIP, etc.) 
 user level (level1, level2, etc.; different levels, different permissions) 

 each user belongs to  an administrative g...
								
									
																														Rbac
																				yii2
																				yii
																				discuz
																				php
																			
									
										Mar.20,2021


				
					
						
	
						
		css
		mysql
		arrays
		josn
		react
		html
		typescript
		webpack
		npm
		sass
		R
		objective-c
		.net
		sql-server
		jquery
		python-3.x
		angularjs
		django
		angular
		excel
		regex
		iphone
		ajax
		linux
		xml
		pandas
		vba
		spring
		database
		wordpress
		string
		wpf
		xcode
		windows
		bash
		postgresql
		oracle
		multithreading
		eclipse
		list
		firebase
		algorithm
		macos
		forms
		image
		scala
		visual-studio
		azure
		bootstrap
		spring-boot
		react-native
		python-2.7
		docker
		performance
		function
		winforms
		matlab
		powershell
		apache
		dataframe
		api
		sqlite
		numpy
		rest
		shell
		selenium
		flutter
		dart
		maven
		loops
		qt
		swing
		android-studio
		csv
		express
		file
		class
		tensorflow
		sorting
		codeigniter
		perl
	
						MySQL Query :  SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5 
 MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b30f4e-2bd5e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") 
 MySQL Errno : 1021 
 Message :  Disk full (/tmp/#sql-temptable-64f5-1b30f4e-2bd5e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") 
Need Help?