This is for a class assignment I\'ve created a database for a restaurant on phpm

Question

This is for a class assignment

I've created a database for a restaurant on phpmyadmin, with multiple relations. I've already created tables for each relations and updated them with tuples. Using php and an index page using html i've created a website that lets you select each relationship and have it print out the data onto a table (by connecting to the database through a php file). The part i'm having trouble with is creating a free-form entry for the user in which they can enter a sql query such as select * from (can be anything) where (fill in blank), i've searched online but i've only found html forms that ask specificly for an attritube such as first name last name, email, address, etc. How would I impliment a free-form?

Explanation / Answer

This can be implemented by taking value of Table in which user wants to search in a text box and also the conditions in another text box . No on your backend insert these variables directly into your sql query and returns the desired result.

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.