PHP coding error accessing database!

[donnan]

Hi guys,

I am trying my hand at using the joomla way of accessing my database records but not having much luck.

I have a "while" loop that I need to execute to display each of my records from the database.

Can someone please help me with the correct code to achieve this.

This is what I have tried without success.

I did try the "while" loop but commented it out and tried the "foreach"...but it's no good either.

Code: Select all

 $db->setQuery($query);
$row = $db->loadAssoc();


//while($row = mysqli_fetch_array($row)) {

		foreach($query->result() AS $row) {


echo "Record".$row['id'];
echo "Name".$row['name'];
}

I think I am probably way off, but I am trying.

This is the error I am getting: " Call to a member function result() on string "

[toivo]

Here are two ways to access the rows and columns:

Code: Select all

$rows  = $db->loadAssocList();
foreach($rows AS $row)
{
	echo $row['id'] . ' ' . $row['name'] . PHP_EOL;
}

Code: Select all

$rows  = $db->loadObjectList();
foreach($rows AS $row)
{
	echo $row->id . ' ' . $row->name . PHP_EOL;
}

[donnan]

Thank you so much toivo.

Did the trick nicely.

[donnan]

Must I use this line EVERY time I want to access the database?

$db = JFactory::getDbo();

I wish to get some more information from another table while in the 'foreach' loop.

[toivo]

Not necessarily every time, normally just once in each script. It is possible to pass the $db object as a parameter to a function defined in a different script, but that does not reduce overheads because the getDbo() function creates a new JDatabaseDriver object only when it is called the first time in a PHP session.

However, if the script sets up a number of different queries, it is good practice to clear the query object before the next query is built:

Code: Select all

$query->clear();

If you build a new query inside the results loop, be careful to use a different variable for the second level of results, for example $rows2.

It may also be possible to combine the second query with the first using JOIN, in which case only one query is run.

[donnan]

thanks toivo so much.

I am just learning how to program a little more the way joomla does it and it's certainly a big learning curve for me.

I appreciate you taking the time to help me out.