1. 2. 3. 4.

[answerhappygod]

1.

1 2 3 4 1 (91.07 KiB) Viewed 51 times

2.

1 2 3 4 2 (96.4 KiB) Viewed 51 times

3.

1 2 3 4 3 (59.16 KiB) Viewed 51 times

4.

1 2 3 4 4 (25.38 KiB) Viewed 51 times

The MariaDB database of the web-based conference management system is hosted in the Apache webserver with the IP address 103.26.197.21. Given the login details as shown in Table 1, modify the database.php file (shown in Figure 5) to connect to the conference_db database in MySQL. Table 1: Login details \begin{tabular}{|l|l|} \hline User name : & Batman 1915 \\ \hline Password : & 19#$15∧04$817 \\ \hline \end{tabular} \$db ['default'] = array ( 'dsn' ⇒ ' ', 'hostname' ⇒ 'locahost', 'username' ⇒ '', 'password' ⇒ ', 'database' ⇒ ',', 'dbdriver' ⇒ 'mssql', 'dbprefix' ⇒ '', 'pconnect' ⇒ FALSE, 'db_debug' ⇒ (ENVIRONMENT !== 'production'), 'cache_on' ⇒ FALSE, 'cachedir' ⇒ '', 'char_set' ⇒ 'utf 8 ', 'dbcollat' ⇒ 'utf8_general_ci', 'swap_pre' ⇒ ' ', 'encrypt' ⇒ FALSE, 'compress' ⇒ FALSE, 'stricton' ⇒ FALSE, 'failover' ⇒ array(), 'save_queries' ⇒ TRUE ) ;
Given the entity relationship diagram in Figure 6, write a SQL transaction to perform the following transactions: - Find the conf_name, conf_organizer, art_id and art_title where the art_status is "Accept" - Select the latest art_id from article relation and use the next art_id as the new art_id - Then, insert a new article data into the article relation. - After that, insert the author's details into the author_details table. You can use the dummy data to demonstrate the SQL transaction. Figure 6: conference_db Entity Relationship Diagram
Construct an Article class in Model architecture. Subsequently, write a method called queryArticle () to query and return the article records listed in Table 2. Table 2: Article Records
Construct an Article_Controller class in Controller architecture. The responsibility of this controller class is to communicate with the Article class model and returns the query result from queryArticle() to the article_details page in View architecture.