Fetch information from Database?

Silvercat90
OFFLINE
Posts: 5
Thanks: 0
Karma: 0

6 years 3 days ago #309400 by Silvercat90

Fetch information from Database? was created by Silvercat90

Hello

I need to get the info from CB which is saved in the Database - how do I do this?
The plugin I used before CB fixed the problem like this:

Code:

foreach ($rows3 as $row3) {	
					if($row3->key == "MOBIL_TLF")
						$tlf = $row3->value;
					if($row3->key == "ADRESSE")
						$adresse = $row3->value;
					if($row3->key == "LAND")
						$land = $row3->value;
					if($row3->key == "POSTBY")
						$postby = $row3->value;
					if($row3->key == "HJEMMESIDE")
						$hjemmeside = $row3->value;
					if($row3->key == "OPDRAET_STAMNAVN")
						$stamnavn = $row3->value;
				}

The info I need is listed like this

user id - firstname - middlename - lastname - cb_opdrtstamnavn - cb_beskrivelseafopdrt -cb_gadenavn_nummer - cb_postnummer_by - cb_hjemmeside

The above info were previously listed under "key" and not in one line.

Can anyone help me?

Kind Regards

Please Log in or Create an account to join the conversation.

krileon
ONLINE
Posts: 48622
Thanks: 8302
Karma: 1446

6 years 2 days ago #309409 by krileon

Replied by krileon on topic Fetch information from Database?

You'll need to load and use CB API to obtain the CB user object. See the below documentation on how to do this.

www.joomlapolis.com/documentation/279-community-builder/tutorials/18357-including-cb-api-for-usage-outside-of-cb

www.joomlapolis.com/documentation/279-community-builder/tutorials/18359-establishing-a-cb-user-object

www.joomlapolis.com/documentation/279-community-builder/tutorials/18361-obtaining-field-values-through-getfields-api

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in or Create an account to join the conversation.

Silvercat90
OFFLINE
Posts: 5
Thanks: 0
Karma: 0

6 years 1 day ago #309420 by Silvercat90

Replied by Silvercat90 on topic Fetch information from Database?

Thank you!

Unfortunately it seems to be a bit above my coding level, but now I know what to get help with. I appreciate your help a lot!

Please Log in or Create an account to join the conversation.

Moderators: beat, nant, krileon