Connecting to underlying data sources: Difference between revisions
Mr. MacKenty (talk | contribs) No edit summary |
Mr. MacKenty (talk | contribs) No edit summary |
||
| Line 6: | Line 6: | ||
# The location of the database. In many cases this is localhost but there is NO REQUIREMENT that the database is on the same server as the webpage. | # The location of the database. In many cases this is localhost but there is NO REQUIREMENT that the database is on the same server as the webpage. | ||
# The credentials to authenticate (which | # The credentials to authenticate (which is usually a username and password) | ||
# The name of the database. | # The name of the database. | ||
Revision as of 08:35, 3 December 2024
Web Science[1]
A webpage can be connected to a data source. A datasource can be a relational database, a flat-file data source (such as a JSON file or an XML file or just a simple plaintext file).
In order to connect to an underlying datasource, we generally require three things:
- The location of the database. In many cases this is localhost but there is NO REQUIREMENT that the database is on the same server as the webpage.
- The credentials to authenticate (which is usually a username and password)
- The name of the database.
As an example, the code below creates a connection to a relational database:
<?php
$connect = mysqli_connect("localhost","YOURUSERNAME","YOURPASSWORD","YOURDATABASE");
// the code below handles errors
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
?>
As another example, you can connect to a flat file (or plain text) data source using file open, file read and file write operations[2]
<?php
$handle = fopen("c:\\folder\\resource.txt", "r");
?>
When a web page connects to an underlying datasource, it is protected access, meaning a web user cannot see the authentication details being passed to the database.
Standards[edit]
These standards are used from the IB Computer Science Subject Guide[3]
- Describe how web pages can be connected to underlying data sources.
References[edit]
- ↑ http://www.flaticon.com/
- ↑ http://php.net/manual/en/function.fopen.php
- ↑ IB Diploma Programme Computer science guide (first examinations 2014). Cardiff, Wales, United Kingdom: International Baccalaureate Organization. January 2012.