MySQL Forums
Forum List  »  Newbie

help with html + css execute mysql
Posted by: Michel mbdec
Date: November 14, 2018 06:46PM

Hello people!
I would like your help to create buttons executing mysql functions.

here is the mysql function to bring the result set and do echo

is a system of nutritionism it makes comparisons in the database, so wanted to create buttons to perform the actions and echo to display the results

Food Table:
Food_ID
Name


Table Profits_Males
Benefits_Males_ID
Name
Type ('B', 'M') (Whether it is benefit or Males)
 
Food_Benefits_Malons Table
Food_ID
Benefits_Males_ID
 
 
For example, bring all the food and its benefits

SELECT Food. *, Benefits_Males. * FROM Food JOIN Food_Beneficios_Males USING (Food_ID) JOIN Benefits_Males USING (Benefits_Males_ID) WHERE Type = 'B';
 
For example, bring all food and its ills
 
SELECT Food. *, Benefits_Males. * FROM Food JOIN Food_Beneficios_Males USING (Food_ID) JOIN Benefits_Males USING (Benefits_Males_ID) WHERE Type = 'M';
 
____________________________ -
| button to perform action | label for echo label for echo
____________________________ -------------------------- ----------------------- ----
| button to perform action |
------------------------------------

Options: ReplyQuote


Subject
Written By
Posted
help with html + css execute mysql
November 14, 2018 06:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.