Question: Create a PHP Program that perform the following Connect to database server Create database under your name (DB_YOURNAME ) Create 3 tables as Table 1

Create a PHP Program that perform the following

Connect to database server

Create database under your name (DB_YOURNAME )

Create 3 tables as

Table 1 : Guest ( G_ID,G_Name, G_Gender , G_PhoneNo, G_Email, G_Address)

Table 2 : Rooms (R_ID,R_Size,R_Style, R_Level)

Table 3: Reservation (R_ID,R_R_data,R_Type,R_Payment)

Insert sample data into the three tables

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Create a PHP Program that perform the following Connect to database server Create database under your name (DB_YOURNAME ) Create 2 tables Table 1 : Customer ( Cust_ID,Cust_Name,Cust_PhoneNo,...

Q:

Create a PHP Program that perform the following a. Connect to database server b. Create database under your name (DB_YOURNAME) c. Create 2 tables i. Table 1 : Customer ( Cust ID, Cust Name, Cust...

Q:

Start by creating an R Project and then within that project, create an R Program ( Script ) with the file name LastNameF.CRDB . CS 5 2 0 0 . R where LastName is your last name and F is your first...

Q:

The following relational model represents a hotel's relational database schema. guest (gid: int, gname: varchar, age: int, city: varchar) soom (rnum: int, rtype: varchar, floor: int) booking...

Q:

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Q:

The assignment specification The java file JabberServer.java package com.bham.fsd.assignments.jabberserver; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet;...

Q:

This policy will be reviewed no later than 5 years of its authorisation date. At this point it will need to be re-authorised by the relevant authority at Xxz Financial Services Version Published...

Q:

The following relational model represents a hotel's relational database schema. guest (gid: int, gname: varchar, age: int, city: varchar) soom (rnum: int, rtype: varchar, floor: int) booking...

Q:

(e) Assume you have an HTML Form which contains three text-fields elements (username, password and threshold respectively). The form is submitted to your PHP program using POST method. Write a...

Q:

IMPORTANT Use the exact names and capitalisation of all tables, classes, methods, etc. that are specified in this document. Do not add to or remove parameters from methods, omit access specifiers,...

Q:

Show that u and v are parallel if and only if u x v = 0.

Q:

Wronskian Suppose that f and g are differentiable functions on the unit interval I. The Wronskian of f and g is given by Show that if W[f, g] (t) ( 0 for all t in I, then f and g are linearly...

Q:

1.54 Coffee and Prostate Cancer The September 2011 issue of the Berkeley Wellness Letter said that coffee reduces the chance of prostate cancer. A study of 48,000 male health care professionals...

Q:

Whicwhich of the following ethical principles means to cause no harm

Q:

3. Analyzing a Film. View a feature film or a video (e.g., Chir-raq or Brooklyn) and assume the position of a researcher. Analyze the cultural meanings in the film from each of the three...

Q:

d. How were you expected to contribute to family life?

Q:

2. Analyzing Cultural Patterns. Find a text or speech that discusses some intercultural or cultural issues, and analyze the cultural patterns present in the text. Consider, for example, the I Have a...