PHP MySQL recipe search based on what ingredients are provided -

-

Say I have a database of recipes, and I want to search based on the content I have.

There should be 3 tables:

Recipes (free, rname), content (iid, iname),
relationship (redemption, id)

Next, imagine that I have a recipe for 'toast' and there is a recipe for 'bread and butter pudding' - the toast has 2 ingredients (bread and butter) - in the pudding, bread and butter, plus flour, eggs and There can be water - then 5 overall.

My problem is, prepare a SQL query based on the content provided in a search. If I present 3 materials in my search - bread, butter and eggs - then (only discussed with 2 recipes) only one result should be produced - Toast! - Because there is not enough material to make pudding!

So what exactly does such SQL queries look like? I have tried everything, everything is gone and now my brain can not handle it anymore.

I do not know if this is the best way, but for example you did this job: 

  Select recipes from the selection, do not get rid of (/ * exclude all recipes with other ingredients * / relieve selection relationship   
 My Sorry for English =)  
 Edit: Content 'IDs are in the order that they' in your question, then there is 1 bread, 2 butter, 4 eggs:  
 "Iid"; "Iname" "1"; "Bread" "2"; "Butter" "3"; "Dough" "4"; "Eggs" "5"; "Water"

Comments

Post a Comment

Popular posts from this blog

mysql - BLOB/TEXT column 'value' used in key specification without a key length -

-
I have developed an extension which works up to 1.6 on Magren (I'm trying Enterprise Edition, And I think the community is the same problem, because it is the same code). In my install script, I see the $ installer-> gt; CreateEntityTables ($ this- & gt; getTable ('alphanum / info')); The installation is done until it is not in the _text unit table. It crashed there! It turns out that when I log in to SQL and run it via PHPmyadmin, then this error is: Blob / Text column 'value' is used without the key 'key' . I saw the code there, and this is what is trying to create an index on the value column: -> addIndex ($ this- & gt; getIdxName ($ eavTableName, array ( 'attribute_id array (' attribute_id ',' value ')) - & gt; addIndex ($ this- & gt; getIdxName ($ eavTableName, array (' entity_type_id ' , 'Value')), array ('entity_type_id', 'value')) If there is no if statement is n...
Read more

memcached - Django cache performance -

-
We are now using Redis for in-memory cache for our Django application (we used the first memcatch The difference in performance is no big, and we're using Redis because the disc dump feature). The problem is that Django cache's performance in my view - terrible, we have a view with 102 cache hits (no miss), and it has 81 ms (only the cash part, which is with the DJBugBug toolbar Is measured). In my opinion - this is a very long time, I know, asking for a question for DB can be 10x more (or 100x) time, but that is also not good with cash performance of that fact. We are running radis (and the first memacatch) on different hosts, connected to the local network with other servers. Is there a way to maximize cache performance in Django? Instead of displaying problem cache, there is a possibility of the number of items to be received for each page 102 Cash calls mean long time lost due to network latency. With full control of the code, you may be able to fix it with m...
Read more

java : convert string value to int -

-
to JTable , I follow the row for [row 1] and calculate the values Do: Last Array List & lt; String & gt; Value = new array list & lt; String & gt; (); End end nb = myTable.getRowCount (); Int sum = 0; (Int i = 1; i & lt; nb; i ++) for {string column = value = myTable.getColumnValue (i, columnName); Yoga = Yoga + Integer.parseInt (columnValue); Value list Add (column value); } But I found: java.lang.NumberFormatException: for input string: "java.lang.NumberFormatException.forInputString (unknown source) Java.lang.Integer.parseInt (unknown source) at Java.lang.Integer.parseInt (unknown source) Your table contains at least one empty cell. Here's a suggestion: Try {sum + = integer.parseont (columnValue) );} Hold (Number Format Expection NFE) {// Cell is either empty or not an integer number // Note, method getColumnValue (int i, string name) javax.swing. JTable is not defined for . If you use the subclass of JTable , then there ...
Read more