lkpke.blogg.se - Source code php stok barang

My main purpose was to show the fetched array into a table, showing the results side by side instead of underneath each other, and heres what I've come up with. If you have questions, just send me a mail. s.Name, s.Birhtday) even if they are not duplicated. Please be aware that by using this function, you have to access all fields with their alias name (e.g. The usage of this function will be pretty similar to calling mysql_fetch_array: Lets asume we have 2 tables student and contact each having fID as the index field and want to access both fID fields in php. $rowCount = mysql_num_fields ( $result ) If (!( $row = mysql_fetch_array ( $result ))) You should either truncate the array or (more sensibly in my mind) check that the result of mysql_fetch_array is not false before adding it to the array.įor all of you having problems accessing duplicated field names in queries with their table alias i have implemented the following quick solution:įunction mysql_fetch_alias_array ( $result ) Yes, that will generate a dummy array element containing the false of the final mysql_fetch_array. You need to delete the last one because this will always be empty.īy this you can easily read the entire table to an array and preserve the keys of the table columns. $result = mysql_query("SELECT * FROM table ") or die(mysql_error()) įor($i = 0 $array = mysql_fetch_assoc($result) $i++) I have found a way to put all results from the select query in an array in one line. Don't fetch BOTH unless you really need them, and most of the time you don't. it's even faster to use fetch_row rather than passing fetch_array MYSQL_NUM, or fetch_assoc rather than fetch_array MYSQL_ASSOC.

mysql_data_seek() - Move internal result pointerĪs you can see, it's twice as effecient to fetch either an array or a hash, rather than getting both.

mysql_fetch_assoc() - Fetch a result row as an associative array.

mysql_fetch_row() - Get a result row as an enumerated array.

Note: This function sets NULL fields to the PHP null value. Note: Field names returned by this function are case-sensitive. SELECT table1.field AS foo, table2.field AS bar FROM table1, table2Įxample #2 mysql_fetch_array() with MYSQL_NUMĮxample #3 mysql_fetch_array() with MYSQL_ASSOCĮxample #4 mysql_fetch_array() with MYSQL_BOTHĪn important thing to note is that using mysql_fetch_array() is not significantly slower than using mysql_fetch_row(), while it provides a significant added value. For aliased columns, you cannot access the contents with the original column name.Įxample #1 Query with aliased duplicate field names

Must use the numeric index of the column or make an alias for the column.

To access the other column(s) of the same name, you If two or more columns of the result have the same field names, the last column will take precedence.

Indices (as mysql_fetch_assoc() works), using MYSQL_NUM, you only get number indices (as mysql_fetch_row() works). Using MYSQL_ASSOC, you only get associative By using MYSQL_BOTH (default), you'll get an array with both associative and number indices. The type of returned array depends on how result_type is defined. Returns an array of strings that corresponds to the fetched row, or false if there are no more rows. It's a constant and can take the following values: MYSQL_ASSOC, MYSQL_NUM, and This result comes from a call to mysql_query(). The result resource that is being evaluated. Mysql_fetch_array( resource $result, int $result_type = MYSQL_BOTH): array Mysql_fetch_array - Fetch a result row as an associative array, a numeric array, or both

How do you check if SQL result is empty in PHP?.