Archive:PHP and MySQL Programming/Database Connectivity: Difference between revisions
wikademia>Wikademia m moved PHP and MySQL Programming/Database Connectivity to Archive:PHP and MySQL Programming/Database Connectivity over redirect |
|||
| (14 intermediate revisions by 6 users not shown) | |||
| Line 1: | Line 1: | ||
== Introduction == | == Introduction == | ||
| 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 50: | Line 47: | ||
while ($row = mysql_fetch_row($result)){ | while ($row = mysql_fetch_row($result)){ | ||
foreach ($row as $field) { | foreach ($row as $field) { | ||
print "$ | print "$field . "; | ||
} | } | ||
print " | print ""; | ||
} | } | ||
?> | ?> | ||
| Line 90: | Line 87: | ||
?> | ?> | ||
[[ | [[../File Handling/|Previous: File Handling]] | [[../|TOC]] | [[../Session Handling/|Next: Session Handling]] | ||
[[Category:PHP and MySQL Programming|{{SUBPAGENAME}}]] | |||