Archive:PHP and MySQL Programming/Database Connectivity: Difference between revisions
wikademia>Ralfe No edit summary |
wikademia>Wikademia m moved PHP and MySQL Programming/Database Connectivity to Archive:PHP and MySQL Programming/Database Connectivity over redirect |
||
| (16 intermediate revisions by 8 users not shown) | |||
| Line 1: | Line 1: | ||
== Introduction == | == Introduction == | ||
You can only do so much with storing information in files. When you need to store large amounts of data, and perform intensive number crunching on that data, there is nothing better than a good SQL database. In this section, we'll discuss connecting PHP to a MySQL database and perform queries and retrieve data back | You can only do so much with storing information in files. When you need to store large amounts of data, and perform intensive number crunching on that data, there is nothing better than a good SQL database. In this section, we'll discuss connecting PHP to a MySQL database and perform queries and retrieve data back from the database. | ||
== Opening a Connection to a MySQL Database == | == Opening a Connection to a MySQL Database == | ||
| Line 20: | Line 17: | ||
== Creating a Query == | == Creating a Query == | ||
Once a connection to a database has been made, you will | Once a connection to a database has been made, you will inevitably want to perform a database query. To create a query on the selected database, we use the mysql_query() function. If you use a SELECT query, then the data returned from that query will be passed to the mysql_query() function, which will in turn return it to a variable which you can specify. In the following example, two queries are made, the first does not return any data, and the second does. | ||
<? | <? | ||
| Line 31: | Line 28: | ||
== Retrieving data from a SELECT Query == | == Retrieving data from a SELECT Query == | ||
There are many methods for retrieving data from a SELECT Query. | |||
If we take, for example, the following code : | |||
<? | |||
# --- Connect To Database --- | |||
$db = "db1"; | |||
$link = mysql_connect("localhost", "user", "pass"); | |||
mysql_select_db($db, $link); | |||
# --- Select Info from Database --- | |||
$result = mysql_query ("SELECT val1, val2 FROM tbl1"); | |||
?> | |||
To now retrieve the data from the $result variable, we can use one of many methods. The recommended method, however, is to sequentially go through each row of the table, storing it into a one-dimensional array. We do this by using the mysql_fetch_row() function, passing it the variable intowhich the result is stored. Here is a simple example : | |||
<? | |||
while ($row = mysql_fetch_row($result)){ | |||
foreach ($row as $field) { | |||
print "$field . "; | |||
} | |||
print ""; | |||
} | |||
?> | |||
This will simply output the result in table-like format. | |||
Here is another example of using this method : | |||
<? | |||
$counter = 0; | |||
while ($row = mysql_fetch_row($result)){ | |||
$val1[$counter] = $row[0]; | |||
$val2[$counter] = $row[1]; | |||
$counter++; | |||
} | |||
$numRows = $counter; | |||
?> | |||
The above example, simply splits the results up into multiple one-dimensional arrays, for easy manipulation. | |||
== Closing a Database Connection == | == Closing a Database Connection == | ||
| Line 51: | Line 87: | ||
?> | ?> | ||
[[ | [[../File Handling/|Previous: File Handling]] | [[../|TOC]] | [[../Session Handling/|Next: Session Handling]] | ||
[[Category:PHP and MySQL Programming|{{SUBPAGENAME}}]] | |||