What kind of array in post

I am not quite sure how to put my array populating line to save all the content to the array. That is if you really want to have a different name id[key] on each checkbox of the html form not very efficient. If not you can just name them all the same, i.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 9 years, 3 months ago. Active 5 years, 2 months ago. Viewed k times. Improve this question. James Stafford James Stafford 1 1 gold badge 11 11 silver badges 39 39 bronze badges. Add a comment. If you know C, this is not unlike the C syntax for initializing structures. You can put double quotes around any element value, and must do so if it contains commas or curly braces.

More details appear below. Thus, the general format of an array constant is the following:. Among the standard data types provided in the PostgreSQL distribution, all use a comma , , except for type box which uses a semicolon ;. Each val is either a constant of the array element type, or a subarray. An example of an array constant is:. Any upper- or lower-case variant of NULL will do. If you want an actual string value "NULL" , you must put double quotes around it. These kinds of array constants are actually only a special case of the generic type constants discussed in Section 4.

The constant is initially treated as a string and passed to the array input conversion routine. An explicit type specification might be necessary. Multidimensional arrays must have matching extents for each dimension. A mismatch causes an error, for example:. Notice that the array elements are ordinary SQL constants or expressions; for instance, string literals are single quoted, instead of double quoted as they would be in an array literal.

Now, we can run some queries on the table. First, we show how to access a single element of an array. This query retrieves the names of the employees whose pay changed in the second quarter:. The array subscript numbers are written within square brackets. By default PostgreSQL uses a one-based numbering convention for arrays, that is, an array of n elements starts with array[1] and ends with array[ n ].

We can also access arbitrary rectangular slices of an array, or subarrays. An array slice is denoted by writing lower-bound : upper-bound for one or more array dimensions. For example, this query retrieves the first item on Bill's schedule for the first two days of the week:. If any dimension is written as a slice, i. Any dimension that has only a single number no colon is treated as being from 1 to the number specified. For example, [2] is treated as [] , as in this example:.

To avoid confusion with the non-slice case, it's best to use slice syntax for all dimensions, e. An array subscript expression will return null if either the array itself or any of the subscript expressions are null. Also, null is returned if a subscript is outside the array bounds this case does not raise an error. For example, if schedule currently has the dimensions [][] then referencing schedule[3][3] yields NULL. Similarly, an array reference with the wrong number of subscripts yields a null rather than an error.

An array slice expression likewise yields null if the array itself or any of the subscript expressions are null. However, in other cases such as selecting an array slice that is completely outside the current array bounds, a slice expression yields an empty zero-dimensional array instead of null.

This does not match non-slice behavior and is done for historical reasons. If the requested slice partially overlaps the array bounds, then it is silently reduced to just the overlapping region instead of returning null.

Note : This is a 'superglobal', or automatic global, variable. This simply means that it is available in all scopes throughout a script. Handling external variables The filter extension. Submit a Pull Request Report a Bug. Notes Note : This is a 'superglobal', or automatic global, variable. See Also Handling external variables The filter extension.