IdeaWazaWiki - User contributions [en]

Archive:PHP and MySQL Programming/Creating a Database

2008-02-17T02:41:34Z

72.73.69.235: /* Introduction */

== Introduction ==

MySQL is a relational database. In a relational database, data is stored as a collection of fields called a row. Like fields, rows are in turn collectively stored as a table. Tables are stored collectively in a database. One MySQL server can store multiple databases, and have users who have various rights to each database.

Now a days, mysql is the one of the mostly used relational database among others as it is simple, free (free source), easy to maintain and cost effective.

In order to store data into MySQL, it is thus obvious that we will need to prepare a space in MySQL for a table of data known as a database.

== SQL Code ==

The code for creating such a database in SQL (Sequential Query Language) is a simple query :
<br>
mysql> CREATE DATABASE `database_name`;

== Using the Database ==

After a database has been created, you have to tell MySQL that to make it the active database before you can start running further queries on it. You do this as follows :

mysql> USE `database_name`;

[[../Introduction to MySQL/|Previous: Introduction to MySQL]] | [[../|TOC]] | [[../Creating a Table/|Next: Creating a Table]]

[[Category:PHP and MySQL Programming|{{SUBPAGENAME}}]]

Archive:PHP and MySQL Programming/Creating a Database

2008-02-17T02:40:55Z

72.73.69.235: /* SQL Code */

== Introduction ==

MySQL is a relational database. In a relational database, data is stored as a collection of fields called a row. Like fields, rows are in turn collectively stored as a table. Tables are stored collectively in a database. One MySQL server can store multiple databases, and have users who have various rights to each database.

Now a days, mysql is the one of the mostly used relational database among others as it is simple, free (free source), easy to maintain and cost effective.

In order to store data into MySQL, it is thus obvious that we will need to prepare a space in MySQL for a table of data known as a Database.

== SQL Code ==

The code for creating such a database in SQL (Sequential Query Language) is a simple query :
<br>
mysql> CREATE DATABASE `database_name`;

== Using the Database ==

After a database has been created, you have to tell MySQL that to make it the active database before you can start running further queries on it. You do this as follows :

mysql> USE `database_name`;

[[../Introduction to MySQL/|Previous: Introduction to MySQL]] | [[../|TOC]] | [[../Creating a Table/|Next: Creating a Table]]

[[Category:PHP and MySQL Programming|{{SUBPAGENAME}}]]

Archive:PHP and MySQL Programming/Creating a Database

2008-02-17T02:40:05Z

72.73.69.235: /* Using the Database */

== Introduction ==

MySQL is a relational database. In a relational database, data is stored as a collection of fields called a row. Like fields, rows are in turn collectively stored as a table. Tables are stored collectively in a database. One MySQL server can store multiple databases, and have users who have various rights to each database.

Now a days, mysql is the one of the mostly used relational database among others as it is simple, free (free source), easy to maintain and cost effective.

In order to store data into MySQL, it is thus obvious that we will need to prepare a space in MySQL for a table of data known as a Database.

== SQL Code ==

The code for creating such a database in SQL (Sequential Query Language) is a simple query :

mysql> CREATE DATABASE `database_name`;

== Using the Database ==

After a database has been created, you have to tell MySQL that to make it the active database before you can start running further queries on it. You do this as follows :

mysql> USE `database_name`;

[[../Introduction to MySQL/|Previous: Introduction to MySQL]] | [[../|TOC]] | [[../Creating a Table/|Next: Creating a Table]]

[[Category:PHP and MySQL Programming|{{SUBPAGENAME}}]]

Archive:PHP and MySQL Programming/File Handling

2008-02-17T02:29:18Z

72.73.69.235: /* Introduction */

== Introduction ==

As with most programming languages, filehandling is very important for storing and retrieving a wide variety of data.

== Opening and Closing Files ==

To open a file, we use the fopen() function. This function takes in two parameters. Firstly, a String containing the name of the file, and secondly, the mode with which to open the file with. It returns a filehandler. e.g. :

<?
$filename = "text.txt";
$f = fopen($filename, 'r');
?>

The above code assigns the file name of "text.txt" to a variable called $filename. Then it uses the fopen function to open up "text.txt" with 'r' mode (meaning "read mode") and returns a filehandler to $f.

To close a file, we simply call the fclose() function, and pass it the filehandler. e.g. :

<?
fclose($f);
?>

== Including a File ==

It is very easy, in PHP, to include code (be it PHP or HTML) from one file into another. This is achieved by means of the include() function.

<?
include ("objects.php");
?>

In the above example, the PHP code will look within the current directory of the PHP file calling the include function, it will then open the objects.php file, and include its content at of that file at the position of the include() function.

== Writing to a File ==

The procedure for writing to a file is:
1. Create a file handler.
2. Use the file handler to open up an input stream from a file.
3. Write Data to the file handler.
4. Close the file handler.

Here is an example of writing two lines of text to a file:

<?
$filename = "file.txt";
$f = fopen($filename, 'w');
fputs($f, "Bonjour Madam.\n");
fputs($f, "Bonjour Monseur.\n");
fclose($f);
?>

fputs() is used to write data to the file. It takes 2 variables, firstly, the file handler, and secondly, a String to write to the file handler.

== Reading from a File ==

Reading from a file goes along much the same format as writing to one. The function used to read from a file is fgets() function. Which takes in two variables. Firstly, the filehandler from which to read, and secondly, the amount of data to retrieve.

<?
$filename = "text.txt";
$f = fopen($filename, 'r');
$line = fgets($f, 1024);
print $line;
print $total_contents;
fclose($f);
?>

The above code opens up a file, reads the first line of the file, and then displays it. If we wanted to rather read the entire contents of the file into a variable, we could replace the $line=fgets() line with :

$total_contents = fread($f, filesize($filename));

[[../Syntax Overview/|Previous: Syntax Overview]] | [[../|TOC]] | [[../Database Connectivity/|Next: Database Connectivity]]

[[Category:PHP and MySQL Programming|{{SUBPAGENAME}}]]