Code: Select all
$db = &NEWADOConnection(DB_TYPE);
$db->Connect(DB_HOST, DB_USER, DB_PASSWD, DB_NAME);
$db->SetFetchMode(ADODB_FETCH_ASSOC);
$rs = $db->Execute($sql);
$rs->GetAssoc();
print_r($rs->fields);Tanks!
Moderator: General Moderators
Code: Select all
$db = &NEWADOConnection(DB_TYPE);
$db->Connect(DB_HOST, DB_USER, DB_PASSWD, DB_NAME);
$db->SetFetchMode(ADODB_FETCH_ASSOC);
$rs = $db->Execute($sql);
$rs->GetAssoc();
print_r($rs->fields);Code: Select all
$db = NewADOConnection(DATA_DSN) or trigger_error('Failed to connect to database.', E_USER_ERROR);
$db->SetFetchMode(ADODB_FETCH_ASSOC);
$query = "SELECT $what $from $where $groupby $having $orderby";
$result = $db->SelectLimit($query, $rows_per_page, $offset) or trigger_error($db->ErrorMsg(), E_USER_ERROR);
$rows = array();
while ($row = $result->FetchRow())
{
$rowsї] = $row;
}
print_r($rows);Code: Select all
$db->SetFetchMode(ADODB_FETCH_ASSOC);
$result = $db->GetAll($sql) or trigger_error($db->ErrorMsg(), E_USER_ERROR);
$rows = array();
while ($row = $result->FetchRow())
{
$rowsї] = $row;
}Line 21 is:Fatal error: Call to a member function on a non-object in /home/ritterr/public_html/rf/index.php on line 21
Code: Select all
while ($row = $result->FetchRow())GetAll($sql)
Executes the SQL and returns the all the rows as a 2-dimensional array. The recordset is discarded for you automatically. If an error occurs, false is returned
this means that if you $db->GetAll you recieve an array.. you can iterate through that arary with foreachSelectLimit($sql,$numrows=-1,$offset=-1,$inputarr=false)
Returns a recordset if successful. Returns false otherwise. Performs a select statement, simulating PostgreSQL's SELECT statement, LIMIT $numrows OFFSET $offset clause.
Code: Select all
$rows = $db->GetAll($query);
foreach($rows as $row)
{
print_r($row);
echo "<br>";
}Code: Select all
$sql = "SELECT id, title, brief, story, date FROM rf_news ORDER BY date LIMIT 5";
$rs = $db->Execute($sql);
if (!$records = $rs->GetAssoc())
{
end_script(__LINE__, __FILE__);
}and this...Each recordset saves and uses whatever fetch mode was set when the recordset was created in Execute() or SelectLimit().
Once I figured out this the rest has been pretty clear sailing.Whenever we want to query the database, we call the ADOConnection.Execute() function. This returns an ADORecordSet object