Reference no: EM131107677
Web Development Assignment: Database Connections
Create a MySQL or MariaDB database on your web host named your first name and last name. 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().
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.
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, 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
Comments
Write update and delete SQL statements that allow comments to be updated and removed from the tree. Upon completion, comments can be added, updated, and removed from the database via the family tree web page.
Seems to be triggering the challenging behavior
: What is the target behavior? What seems to be triggering the challenging behavior? What are the consequences that seem to maintain it? What function does this behavior serve for the child?
|
Explain what the criticisms are surrounding the act
: Explain what the criticisms are surrounding the Act. Explain the economic consequences for companies as a result of implementing the Act. Explain if the Sarbanes-Oxley Act has achieved its goals so far. Provide examples to support your reasoning.
|
Determine its age assuming that in living trees
: Note that the half life of carbon-14 is 5700 years and the Avogadro number is 6.02 × 1023.
|
Document for analysis on poor claim letter
: I hate to write to you with a complaint, but my company purchased four of your Multifunction SX500 photocopiers, and we've had nothing but trouble ever since.
|
Develop a php connection script
: 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.
|
Explain the potential personal liability to acme fireworks
: Discuss the different employment types and relationships relevant to agency law, and analyze the advantages and disadvantages of each type specific to Acme Fireworks.
|
Law of one price being violated
: Suppose you are shopping for a new automobile. You find the same car at two dealers but at different prices. Is the law of one price being violated? Why or why not?
|
Bartender at the tucson racquet club
: Cathy Livingston, bartender at the Tucson Racquet Club, can serve drinks at the rate r of one every 50 seconds, During a hot evening recently, the bar was particularly busy and every 55 second someone was at the bar asking for a drink.
|
Encountering a learning organization
: How can you tell when you are encountering a learning organization?
|