AI-Powered Educational Platform

• Search
• University
• Course
• Answer Type

FSM Mohammed V University Hassan II University of Casablanca Al Akhawayn University University of Ibn Zohr University of Hassan I University of Chouaib Doukkali University of Abdelmalek Essaadi University of Mohammed Premier University of Sultan Moulay Slimane University of Moulay Ismail University of Sidi Mohamed Ben Abdellah University of Ibn Tofail University of Hassan II of Casablanca University of Cadi Ayyad University of Marrakech Cadi Ayyad University of Mohammed VI Polytechnic University of International Rabat University of Mohammed V in Rabat University of Hassan II in Casablanca University of Abdelmalek Essaadi in Tetouan University of Mohammed Premier in Oujda University of Sultan Moulay Slimane in Beni Mellal University of Moulay Ismail in Meknes University of Sidi Mohamed Ben Abdellah in Fez University of Ibn Tofail in Kenitra Semestr 1 Semestre 2 Semestre 3 Semestre 4 Semestre 5 Semestre 6 Semestre 7 Semestre 8 Semestre 9 Semestre 10 General Approximate Precise Save search history

CREATE TABLE universities ( id INT PRIMARY KEY, name VARCHAR(255) NOT NULL ); CREATE TABLE courses ( id INT PRIMARY KEY, name VARCHAR(255) NOT NULL, university_id INT NOT NULL, FOREIGN KEY (university_id) REFERENCES universities(id) ); CREATE TABLE answers ( id INT PRIMARY KEY, question VARCHAR(255) NOT NULL, answer VARCHAR(255) NOT NULL, university_id INT NOT NULL, course_id INT NOT NULL, answer_type VARCHAR(255) NOT NULL, FOREIGN KEY (university_id) REFERENCES universities(id), FOREIGN KEY (course_id) REFERENCES courses(id) ); CREATE TABLE search_history ( id INT PRIMARY KEY, question VARCHAR(255) NOT NULL, university_id INT NOT NULL, course_id INT NOT NULL, FOREIGN KEY (university_id) REFERENCES universities(id), FOREIGN KEY (course_id) REFERENCES courses(id) ); CREATE TABLE universities ( id INT PRIMARY KEY, name VARCHAR(255) NOT NULL ); CREATE TABLE courses ( id INT PRIMARY KEY, name VARCHAR(255) NOT NULL, university_id INT NOT NULL, FOREIGN KEY (university_id) REFERENCES universities(id) ); CREATE TABLE answers ( id INT PRIMARY KEY, question VARCHAR(255) NOT NULL, answer VARCHAR(255) NOT NULL, university_id INT NOT NULL, course_id INT NOT NULL, answer_type VARCHAR(255) NOT NULL, FOREIGN KEY (university_id) REFERENCES universities(id), FOREIGN KEY (course_id) REFERENCES courses(id) ); CREATE TABLE search_history ( id INT PRIMARY KEY, question VARCHAR(255) NOT NULL, university_id INT NOT NULL, course_id INT NOT NULL, FOREIGN KEY (university_id) REFERENCES universities(id), FOREIGN KEY (course_id) REFERENCES courses(id) );

connect_error) { die("Connection failed: " . $conn->connect_error); } // Get query from form $query = $_POST['query']; // Execute query $result = $conn->query($query); // Display results if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { echo $row["column_name"] . "
"; } } else { echo "0 results"; } // Close connection $conn->close(); ?>

© 2024 AI-Powered Educational Platform