Zen Cart Logo
Forums / General Questions / How do I get information from the database for my custom reports?

How do I get information from the database for my custom reports?

Views: 933

Results 1 to 9 of 9
11 Jun 2012, 10:21 PM
#1
bparker avatar

bparker

Zen Follower

Join Date:
Oct 2008
Location:
Rochester, NY
Posts:
232
Plugin Contributions:
0

How do I get information from the database for my custom reports?

I'm creating a new page independent of my store. It will reside on the same server. How do I extract information from the database in order to create my own custom reports for the invoices? I want to be able to grab customer information, item information, and so on.

I'm good with MySQL and PHP, I'm just asking for the logic of this to get me started.

Thanks!

http://www.amalgamweb.com

15 Jun 2012, 8:23 PM
#2
bparker avatar

bparker

Zen Follower

Join Date:
Oct 2008
Location:
Rochester, NY
Posts:
232
Plugin Contributions:
0

Re: How do I get information from the database for my custom reports?

Any ideas? Anyone?

http://www.amalgamweb.com

15 Jun 2012, 8:37 PM
#3
afo avatar

afo

Totally Zenned

Join Date:
Aug 2004
Location:
New York City
Posts:
6,800
Plugin Contributions:
0

Re: How do I get information from the database for my custom reports?

Does this help? http://www.zen-cart.com/downloads.php?do=file&id=9

Mary Ellen
I came; I saw; I Zenned
Taking over the world... one website at a time
Make sure brain is engaged before putting mouth in gear... or fingers to keyboard.

Holzheimer
Fan Odyssey

16 Jun 2012, 8:23 AM
#4
bparker avatar

bparker

Zen Follower

Join Date:
Oct 2008
Location:
Rochester, NY
Posts:
232
Plugin Contributions:
0

Re: How do I get information from the database for my custom reports?

Maybe. Thanks for sharing. How do I know what it does before I install it? The description is quite vague.

http://www.amalgamweb.com

16 Jun 2012, 9:11 PM
#5
bparker avatar

bparker

Zen Follower

Join Date:
Oct 2008
Location:
Rochester, NY
Posts:
232
Plugin Contributions:
0

Re: How do I get information from the database for my custom reports?

Ok, I looked at the program. It's close, but doesn't have everything I need.

However, I can build what I need. I just need help getting started. All I need to do is be able to grab information from the database. If I can do it for one variable, I can figure out the rest.

http://www.amalgamweb.com

17 Jun 2012, 5:18 AM
#6
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,513
Plugin Contributions:
176

Re: How do I get information from the database for my custom reports?

If you use that plugin as a base, it'll save you a lot of time and trouble in your learning curve.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

24 Nov 2012, 12:49 AM
#7
aalthouse avatar

aalthouse

New Zenner

Join Date:
Oct 2012
Posts:
5
Plugin Contributions:
0

Re: How do I get information from the database for my custom reports?

Hi OP - did you ever get the data you need? I'm on the same quest as you and am looking at alternatives.

-AA

24 Nov 2012, 1:12 PM
#9
lat9 avatar

lat9

Administrator

Join Date:
Sep 2009
Location:
Stuart, FL
Posts:
14,109
Plugin Contributions:
56

Re: How do I get information from the database for my custom reports?

Using the mod/plugin as a basis will, as gjh42 and DrByte said previously, help to guide you through how to structure your PHP to gather and display the information you desire. A similar question was asked and answered here (http://www.zen-cart.com/showthread.php?202524-how-to-look-for-a-field-value-in-db-base-on-relatived-filed-value) about how to retrieve a single value from a single table in the database based on a single condition.

My website