Reference column names using pg_fetch_row in PHP

Question

How can you refer to column names using PHP pg_fetch_row ?

An example about the code that we debugged using Cha.

 $dbconn = pg_connect("host=localhost port=5432 dbname=noa user=noa password=123"); $result_titles_tags = pg_prepare( $dbconn, "query777", "SELECT question_id, title FROM questions WHERE question_id IN ( SELECT question_id FROM questions ORDER BY was_sent_at_time DESC LIMIT 50 ) ORDER BY was_sent_at_time DESC LIMIT 50;" ); $result_titles = pg_execute( $dbconn, "query777", array()); while($row = pg_fetch_row( $result_titles )) { $question_id = $row[0]; // This works but following does not // We cannot use here `$question_d = $row['question_id'] // Problem here: // What is the reason that you cannot use $row['question_id']? // for some unknown reason // 

Answer 1

You are looking for pg_fetch_assoc which returns an associative array, i.e. You can call fields by name.

pg_fetch_array allows you to name them by name or index. pg_fetch_object allows pg_fetch_object to refer to them as $row->question_id .

Choose the one you like best. There is no real noticeable difference in speed.