How do I create a MySQL or MariaDB database on my web host, programming homework help

Anonymous

Question Description

Create a MySQL or MariaDB database on your web host named your first name and last name. Append your last name to each table you create. Such as “Anderson_login_table”. Most web hosts use PHPMyAdmin, a tool used to manage MySQL databases. See your web host’s documentation / support site to determine how to create a MySQL database on your specific web host. You will also need to create a username and password to allow you to access the database from your PHP script using mysqli_connect(). Search your web host documentation if this is not intuitive on your web host control panel or administrator panel. Exclude any spaces; use one word such as “yourfirstnameyourlastname.” Create a table named “comments.” In the “comments” table, create the fields ID, name, title, comments, and comment date. Use the proper field types and allow comments to be over 100 characters. Comment date should be a timestamp field that is automatically updated with the current timestamp when a new record is inserted into the table. ID should be the primary key and auto increment. This prevents having to manage the maximum ID in the table, you can leave “ID” off insert statements if the database engine auto increments it for you but you still need the ID in the where clause for updates and deletes. Develop a PHP connection script that successfully connects to your database. It should use the MySQL_error() or MySQLi_error() function appropriately to test whether a successful connection exists. Note most web hosts do not have a level of error control enabled for you to debug PHP affluently so use a local Apache/PHP/MariaDB web development environment to do this assignment on your computer before you upload your code to your web host. Use a PHP/MariaDB stack to do this or install Mysql, Apache, and PHP locally. The following packages work well: MAMP (Mac), XAMPP, or other LAMP/WAMP variants. Note, some web hosts may be using the new MySQL functions. Thus, you may notice the “I” placed in front of the latter function. You need to determine if your webhost requires new MySQL functions to work. For example, to connect to MySQL you may need to use: mysqli_connect() or mysql_connect() The textbook may use older functions and you can use the new versions by placing an “I” after “mysql” - mysqli_query(). Create a comments section on your family/friend/pet tree that is database driven. Upon successful authentication to the tree page, a user should be given a new link to a new form. The form should have a name, title, and a comment field. Proper form validation should exist. Upon form submission, the name, title, and comment data should be inserted into the associated fields in the comments database table on your web host. Write a SQL select statement against the comments table in your database and display each row properly formatted on the main tree page. The most recent comment should be displayed first. All user comments should display under the tree like: Name of the person who made the comment Title Date CSIS 410 Page 8 of 8 Comments Write update and delete SQL statements that allow comments to be updated and removed from the tree using database tables. Upon completion, comments can be added, updated, and removed from the database tables via the family tree web page.

Unformatted Attachment Preview

Create a MySQL or MariaDB database on your web host named your first name and last name. Append your last name to each table you create. Such as “Anderson_login_table”. Most web hosts use PHPMyAdmin, a tool used to manage MySQL databases. See your web host’s documentation / support site to determine how to create a MySQL database on your specific web host. You will also need to create a username and password to allow you to access the database from your PHP script using mysqli_connect(). Search your web host documentation if this is not intuitive on your web host control panel or administrator panel. Exclude any spaces; use one word such as “yourfirstnameyourlastname.” Create a table named “comments.” In the “comments” table, create the fields ID, name, title, comments, and comment date. Use the proper field types and allow comments to be over 100 characters. Comment date should be a timestamp field that is automatically updated with the current timestamp when a new record is inserted into the table. ID should be the primary key and auto increment. This prevents having to manage the maximum ID in the table, you can leave “ID” off insert statements if the database engine auto increments it for you but you still need the ID in the where clause for updates and deletes. Develop a PHP connection script that successfully connects to your database. It should use the MySQL_error() or MySQLi_error() function appropriately to test whether a successful connection exists. Note most web hosts do not have a level of error control enabled for you to debug PHP affluently so use a local Apache/PHP/MariaDB web development environment to do this assignment on your computer before you upload your code to your web host. Use a PHP/MariaDB stack to do this or install Mysql, Apache, and PHP locally. The following packages work well: MAMP (Mac), XAMPP, or other LAMP/WAMP variants. Note, some web hosts may be using the new MySQL functions. Thus, you may notice the “I” placed in front of the latter function. You need to determine if your webhost requires new MySQL functions to work. For example, to connect to MySQL you may need to use: mysqli_connect() or mysql_connect() The textbook may use older functions and you can use the new versions by placing an “I” after “mysql” - mysqli_query(). Create a comments section on your family/friend/pet tree that is database driven. Upon successful authentication to the tree page, a user should be given a new link to a new form. The form should have a name, title, and a comment field. Proper form validation should exist. Upon form submission, the name, title, and comment data should be inserted into the associated fields in the comments database table on your web host. Write a SQL select statement against the comments table in your database and display each row properly formatted on the main tree page. The most recent comment should be displayed first. All user comments should display under the tree like: Name of the person who made the comment Title Date CSIS 410 Page 8 of 8 Comments Write update and delete SQL statements that allow comments to be updated and removed from the tree using database tables. Upon completion, comments can be added, updated, and removed from the database tables via the family tree web page. ...
Purchase answer to see full attachment

Tutor Answer

criss53
School: University of Maryland

Here...

flag Report DMCA
Review

Anonymous
Goes above and beyond expectations !

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors