Click here to Skip to main content
14,640,094 members
Home » Discussions » Database
   

Database

 
GeneralRe: Http 500 error with register page Pin
and180y2-Jul-20 4:57
Memberand180y2-Jul-20 4:57 
QuestionReporting data Pin
Joan M19-Jun-20 10:03
professionalJoan M19-Jun-20 10:03 
AnswerRe: Reporting data Pin
Mycroft Holmes19-Jun-20 12:25
professionalMycroft Holmes19-Jun-20 12:25 
Joan M wrote:
And I would like to solve this in the database part, not creating different tables and then working in the PHP area
Wrong tools for the jobs, database for servicing your data query and PHP for the presentation.

You could store your queries in a table, relate them to a query/stored proc and expose a title in a combo box for the user to select. Display would need to be an auto generated table to support different result sets.

The problem with this is that you may need to support different filtering parameters and you end up with an entire framework to support the reporting when it is faster and simpler to build a result page and query for each report request.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP

GeneralRe: Reporting data Pin
Joan M20-Jun-20 1:11
professionalJoan M20-Jun-20 1:11 
GeneralRe: Reporting data Pin
David Mujica22-Jun-20 4:27
MemberDavid Mujica22-Jun-20 4:27 
GeneralRe: Reporting data Pin
Joan M22-Jun-20 8:40
professionalJoan M22-Jun-20 8:40 
Questionhow to create relationship between tables based on field Pin
Cenator13-Jun-20 2:12
MemberCenator13-Jun-20 2:12 
AnswerRe: how to create relationship between tables based on field Pin
Richard Deeming15-Jun-20 0:59
mveRichard Deeming15-Jun-20 0:59 
Questiondriver oracle 9i por .net Pin
Member 148339584-Jun-20 3:11
MemberMember 148339584-Jun-20 3:11 
AnswerRe: driver oracle 9i por .net Pin
Richard MacCutchan4-Jun-20 3:14
mveRichard MacCutchan4-Jun-20 3:14 
AnswerRe: driver oracle 9i por .net Pin
Jörgen Andersson4-Jun-20 4:29
professionalJörgen Andersson4-Jun-20 4:29 
GeneralRe: driver oracle 9i por .net Pin
Member 148339584-Jun-20 22:25
MemberMember 148339584-Jun-20 22:25 
GeneralRe: driver oracle 9i por .net Pin
Jörgen Andersson5-Jun-20 1:08
professionalJörgen Andersson5-Jun-20 1:08 
GeneralRe: driver oracle 9i por .net Pin
Member 148339587-Jun-20 21:58
MemberMember 148339587-Jun-20 21:58 
GeneralRe: driver oracle 9i por .net Pin
Jörgen Andersson7-Jun-20 23:20
professionalJörgen Andersson7-Jun-20 23:20 
GeneralRe: driver oracle 9i por .net Pin
Member 148339589-Jun-20 4:27
MemberMember 148339589-Jun-20 4:27 
GeneralRe: driver oracle 9i por .net Pin
Jörgen Andersson9-Jun-20 4:45
professionalJörgen Andersson9-Jun-20 4:45 
GeneralRe: driver oracle 9i por .net Pin
Member 148339589-Jun-20 4:27
MemberMember 148339589-Jun-20 4:27 
QuestionFailed to connect Mysql shared server database with Workbench 8.0.20 tool. Pin
Member 1167692314-May-20 22:49
MemberMember 1167692314-May-20 22:49 
AnswerRe: Failed to connect Mysql shared server database with Workbench 8.0.20 tool. Pin
Bohdan Stupak29-Jun-20 4:26
professionalBohdan Stupak29-Jun-20 4:26 
Questionatabase constraints must follow relvar constraints Pin
Tara1112-May-20 14:15
MemberTara1112-May-20 14:15 
QuestionConvert raw byte[8192] of SQL Server XML datatype into a C# string? Pin
arnold_w1-May-20 2:32
Memberarnold_w1-May-20 2:32 
AnswerRe: Convert raw byte[8192] of SQL Server XML datatype into a C# string? Pin
phil.o1-May-20 3:06
mvephil.o1-May-20 3:06 
QuestionRead data from Azure database with C#-application, without installing a lot of applications? Pin
arnold_w25-Apr-20 7:24
Memberarnold_w25-Apr-20 7:24 
AnswerRe: Read data from Azure database with C#-application, without installing a lot of applications? Pin
Richard MacCutchan25-Apr-20 7:42
mveRichard MacCutchan25-Apr-20 7:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.