SpellsBook

 +PHP
+ Adobe Flash 2 0 (0)
+ Arrays (4)
+ COM for Windows (2)
+ Image (2)
+ LDAP (3)
+ MySQL (11)
+ Basic MySQL Example
+ Database Information
+ Error Checking
+ Fetch Associative Array
+ Last Insert ID
+ Mysql PROD function
+ Number of Rows
+ SQL Dump to Database
+ Select Examples
+ Table and Field Information
+ Various Information
+ Regular Expressions (2)
+ String Manipulation (12)
+ Time and Date (6)
 +Snippet Options
+   Printer Friendly
 +Library Options
+   View Other Library
Adobe_Flash_3_0
C_Plus_Plus
Debian_Install
Del_me_Soon
HTML_and_CSS
JavaScript
Linux_Commands
PHP
 +General Options
+   Library Home
+   PHP-CSL Credits
+   PHP-CSL License
+   Resource Links
+   Log in
Syntax for: MySQL / Basic MySQL Example

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:

<?php

    
/* Connecting, selecting database */
    
$link mysql_connect("mysql_host""mysql_user""mysql_password")
        or die(
"Could not connect");
    print 
"Connected successfully";
    
mysql_select_db("my_database") or die("Could not select database");

    
/* Performing SQL query */
    
$query "SELECT * FROM my_table";
    
$result mysql_query($query) or die("Query failed");

    
/* Printing results in HTML */
    
print "<table>n";
    while (
$line mysql_fetch_array($resultMYSQL_ASSOC)) {
        print 
"t<tr>n";
        foreach (
$line as $col_value) {
            print 
"tt<td>$col_value</td>n";
        }
        print 
"t</tr>n";
    }
    print 
"</table>n";

    
/* Free resultset */
    
mysql_free_result($result);

    
/* Closing connection */
    
mysql_close($link);
?>
 
Description for: MySQL / Basic MySQL Example
  Connect, execute a query, print resulting rows and disconnect from a MySQL database


 
Powered by: PHP-CSL V0.9