INSERT INTO EMP (EMP_ID,NAME,SALARY) VALUES (106, 'Advith' ,6000) Įmployee ID: '. INSERT INTO EMP (EMP_ID,NAME,SALARY) VALUES (105, 'Likitha' ,5000) INSERT INTO EMP (EMP_ID,NAME,SALARY) VALUES (104, 'Tyagraj' ,4000) INSERT INTO EMP (EMP_ID,NAME,SALARY) VALUES (103, 'Manu' ,3000) Returns numeric string array, number of elements is same as number of columns, index starts from “0”.ĬREATE TABLE EMP(EMP_ID INT (5), NAME VARCHAR (30), SALARY INT (6)) Also this is numeric array, can get the data using numeric string key, key being starts from “0”. Returns associative array with column names as keys. This will push the array onto the end of your current array. All arrays have a cursor, and you can freely move it around - it is used in the while loop above, where we need to iterate through an array.

Returns stdClass object with column names as variables Returns associative array with column names as keys Below functions can be used to fetch data from results. That is, the 'id' > 56 will be replaced by 'id'> 57 and so on, and at the end youll have one array with three associative keys, holding the last set of values. When it fails to get the next row, it returns false, and your loop ends. :) Anyway, no, you cant have one array with all the values referenced using associative keys, because the values will overwrite as each new key is processed.

Hence storing two different information in one array element.PHP makes it easy to get data from your results and loop over it using a while statement. We can save more data, as we can have a string as key to the array element, where we can have associated data to the value to be stored, like in our example, we stored the type of the car as key along with the name of the car as value.We can provide more meaningful key or index values to our array elements.Here are a few advantages of using associative array in our program/script: ' car ' ĭon't get confused by the syntax as $key=>$value, it means in every iteration of the foreach we are representing the array as key-value pair. Using foreach to traverse an associative array is a better approach if you have to traverse the whole array, as we do not have to bother about calculating the size of the array to loop around the array.īelow we have used the foreach to traverse the $lamborghinis array. While using the for loop to traverse an associative array we must know the size/length of the array, which can be found using the count() function.Īlso, as the index in associative array is not numeric and not sequentially, hence to find the index values or keys(as data saved in associative array is in the form of key-value), we can use the function array_keys() to get an array of the keys used in the associative array.įollowing is the syntax for traversing an array using the for loop. This is of course the correct and preferred solution. To know the syntax and basic usage of for and foreach loop, you can refer to the PHP for and foreach loop tutorial. Thiago already mentions the way to access the key and the corresponding value. We can traverse an associative array either using a for loop or foreach. Traversing an array means to iterate it starting from the first index till the last element of the array. Hence, to access an associative array, we have to use the array name along with the index of the element in square brackets, the only difference here is that the index will be a string not a numeric value like in indexed array.

No matter how we initialize the array, we can access the array as follows, Syntax for the 1st way to create associative array: 'Urus', 'sports'=>'Huracan', 'coupe'=>'Aventador') Īnd the syntax for the 2nd way to create associative array is: Just like indexed array, there are two different ways of creating an associative array in PHP, they are,

An associative array is similar to an indexed array, but rather than storing data sequentially with numeric index, every value can be assigned with a user-designed key of string type.

Php associative array while loop