php - Suitable design for a database application -

-

I have a question related to a web app that I have developed in PHP MYSQL.

Originally part 1: I display the results in the table to test the software. 

  ID Prod_Name Set Date Results Platform 1 Alpha 1 Pro 1 01.01.01 Pass 2.3.1.2_OS

Now, I have divided the tables accordingly < / P> 

  table name: result id, name, date, result table name: set id, set_name, prod_name table name: platform id, platform_name, now, in each table the ID is an incremental value And is not related to.  
 My php app starts by getting results from 'results' table. Since I want to display the SET in every line, I am creating another connection from the database and using the query set  
  Set_name with where Prod_name = row ['name' ] // row ['name'] has been received from the results table.  
 
 Now I want to display the platform I am using from the platform table above, or create another connection and  Set_Name = row ['Set_Name']  from the set table 
 
 Any other way to get the same results for my application now? 
 
 Generally, for large Web based applications, if data is coming from the database server, then a majority of connections from a DB server are making a viable option? 
 
 Please do not consider the fact that MySQL announces a content statement once needed, but what about MSSQL server? Do we have to write a long SQL statement with many Join / Sedge / Unions and use those variables on all applications? 
 
 How will the application be designed for this matter? 
 
 Thanks 
 
 Thank you. 
 
 Thanks

I do not understand everything, but something similar here is. First of all, let's make an ER model.

Now, because you do not like to add, create a view in the database. 

  Project ID = P. F. PleafideID = T on productive join platform F. See product ID, product name, test name, date, result, platform name, as v_test from platform APs as platform AID as Platfide Aid.

With this place, you can simply use it: 

  SELECT * to v_test WHERE ProductName = 'alpha1'  < / Pre> 
 You can also take a look at   with a similar scenario.

Comments

Post a Comment

Popular posts from this blog

MVP, design question -

-
I am working on an MVP designated application and there are some design questions: I presenter how to communicate while writing code in the layer Should go between different presenters / ideas? Let's say I have a window window with a window viewer and I want to set the window title on the window from the second window. I have a title-setter on the window view, which wraps the actual Gui title. Should I call the title-setter directly on the scene (window viewer.tit = "title") or should I wrap the view title as the presentation title setter (window-creator.tit = "title")? Ask yourself how you will test it? If you do a window presentation. View. Tight = "Title", how can you test that the presenter is setting the title?
Read more

excel - Populate list via a bi-Condition -

-
I'm interested in implementing something but I'm not sure it would be possible and would like to take it on. This is my scenario: I will have two verification cells, which will be shown as a list, from which I will select. This is my condition that I want to remember and remember my list from a database. I have a list of agents, which has been thrown at B13: B23 and the next two, I have columns of data that assume that my data base looks like this bcdx | Y Z Agent 1 1 | 1 | 0 Agent 2 0 | 1 | 0 Agent 3 0 | 1 | 1 agent 4 1 | 0 | 0 ... I want to populate a list named agent from column B, when I verify cell 1: x and verification cell 2: 1 I choose from. It should only show an agent in column X with column: agent1 agent4 or 0 ... I read somewhere Array formula but I do not know if this is convenient and I have unfortunately not any background in the macro :( But I know C ++ is quite easy with some conditional statement like this. Advance Thanks, This
Read more

iphone - How do I make a UIPickerView in a UIActionSheet -

-
Just want to know how I will create UIPickerView in a UIActionSheet with a simple array. Well, I really know how to put it in an action sheet but I like my way because it is more for my app, thanks, but I I also want to know how to put options in UIPKviewView, I just have an array with colors already on top of that part: red, green, blue, yellow, black, etc. in this, but I want to know how it In the preview d L'be if I am using the already Instifrem:? Please help anyone. I know that this is a stupid question, but I'm cheating my head on my $$$$$$ MacBook. Instead you want to do this, create your UIPickerView interface builder and have it in your view controller Connect to the outlet. Add it as a subview of your main view and set its frame coordinates so that it is offset right below the edge, x = 0, y = 480 Then, when you want to display a picker, animate it like something with the screen: [UIView startup permissions: zero reference: zero]; [Color picture setfr
Read more