How to display data from MySql database in joomla 2.5?

For Joomla! 2.5 Coding related discussions, please use: http://groups.google.com/group/joomla-dev-general
Note: All 1.6, 1.7 and 3.5 releases have reached end of life and should be updated to 3.x.

Moderator: ooffick

Forum rules
Please use the mailing list here: http://groups.google.com/group/joomla-dev-general rather than this forum.
Locked
sinivasan
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Tue Mar 20, 2012 10:49 am
Location: Salem, INDIA

How to display data from MySql database in joomla 2.5?

Post by sinivasan » Sun Jul 29, 2012 6:02 am

Hi, I have a table called "student_results" , and it has id, reg_no, name, sub1, sub2, sub3, subj4, total.

I want to display these information to front end by typing "reg_no" then it should display in table as below

Register No.= reg_no
Name = name
Subject1 = sub1
Subject2 = sub2
Subject3 = sub3
Subject4 = sub4
Total = total

There is any extension(free) can do this? or php code for custom html or any other method for this requirement?

Note : I am using fabrik for Inserting, Updating & Deleting data from/to database. but I don't know how to display these information in front end as described above.

Kindly help me.
sorry for my english

User avatar
bewebdev
Joomla! Ace
Joomla! Ace
Posts: 1017
Joined: Tue Apr 17, 2012 11:28 am
Location: Lincolnshire, UK

Re: How to display data from MySql database in joomla 2.5?

Post by bewebdev » Sun Jul 29, 2012 4:34 pm

sinivasan

Head over to
http://extensions.joomla.org/extensions ... ta-reports

I'm sure you will find something that suits your needs

regards
@bewebdev
Joomla & Magento Specialists.
white label web talent
http://www.missingmojo.co.uk

sinivasan
Joomla! Apprentice
Joomla! Apprentice
Posts: 7
Joined: Tue Mar 20, 2012 10:49 am
Location: Salem, INDIA

Re: How to display data from MySql database in joomla 2.5?

Post by sinivasan » Sun Jul 29, 2012 5:41 pm

bewebdev wrote:sinivasan

Head over to
http://extensions.joomla.org/extensions ... ta-reports

I'm sure you will find something that suits your needs

regards
@bewebdev
Thanks for your interest to help me!

But none of the extensions found to fulfill my requirement?

User avatar
uaintgotthisid
Joomla! Explorer
Joomla! Explorer
Posts: 367
Joined: Wed Sep 10, 2008 6:05 pm
Location: Essex, England, United Kingdom
Contact:

Re: How to display data from MySql database in joomla 2.5?

Post by uaintgotthisid » Fri Nov 18, 2016 12:16 pm

Why don't you consider writing something yourself then? https://docs.joomla.org/Portal:Developers

Or if you prefer to use an extension, give us more information as to why it doesn't work. Have you considered using DP Fields? It looks like it could handle what you are trying to achieve the only part would be the total, but that would just be some minor PHP which would be reasonably easy. DP Fields is being added to the core soon too.
Joomla lover, web designer, marketeer
https://www.squareballoon.co.uk
JOIN US at Joomla! User Group London
https://www.joomlalondon.co.uk

User avatar
uaintgotthisid
Joomla! Explorer
Joomla! Explorer
Posts: 367
Joined: Wed Sep 10, 2008 6:05 pm
Location: Essex, England, United Kingdom
Contact:

Re: How to display data from MySql database in joomla 2.5?

Post by uaintgotthisid » Fri Nov 18, 2016 12:17 pm

This tutorial might help you on your way https://www.[youtube].com/watch?v=0nZWBL_8lno
Joomla lover, web designer, marketeer
https://www.squareballoon.co.uk
JOIN US at Joomla! User Group London
https://www.joomlalondon.co.uk


Locked

Return to “Joomla! 2.5 Coding”