1 / 6

What is Database

What is Database. Lesson 2 - Finals. Database. Is like a repository of data that resides on your server. Data stored in a paper files and steel filing cabinets are also considered databases. Data managed by a computer-based application is also a database.

carol
Download Presentation

What is Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. What is Database Lesson 2 - Finals

  2. Database • Is like a repository of data that resides on your server. • Data stored in a paper files and steel filing cabinets are also considered databases. • Data managed by a computer-based application is also a database. • Thus the term “database” could refer to either manual or computerized database.

  3. What is database management system (DBMS) • A DBMS is a software package/system to facilitate the creation and maintenance of a computerized database. A single DBMS can administer a number of databases • MySQL, Oracle, Postgress, and MSSQL are examples of DBMSs. • Some databases are relational, i.e. data is stored in tables, while some are object-oriented for managing complex structures such as biological information with multimedia (graphics, sounds, images, video). Still others are a combination of relational and object-oriented, hence the term object-relational databases.

  4. What is MySQL • MySQL is an example of a relational DBMS • MySQL can administer a number of databases. • Each database in MySQL comprise a table or a number of tables. • Each table consists of a number of rows and column similar to a spreadsheet. • Each ROW in a table corresponds to a record. • Each COLUMN in a table corresponds to a field of that table • Official website for MySQL if http://www.mysql.com

  5. Connecting to the MySQL database • Before you can use PHP to access data in a MySQL database, You must first connect to MySQL • To connect to MySQL, you need to create a resource variable which will store information about the MySQL database connection. This is done through the use of the mysql_connect() function. The syntax is

  6. $resource_variable=mysql_connect([host],[username],[password]);$resource_variable=mysql_connect([host],[username],[password]); Resource variable could be localhost or an IP address of the server which hosts the MySQL database Username and password you can use to connect to the MYSQL database. make sure you don’t use the root account or any user with full privilege to the MYSQL database to connect the MYSQL through PHP. Example: $dbconnect=mysql_connect(“localhost”,”rochelle”,”1234”);

More Related