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 / Database Information

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:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:

List Databases

<?php
$link 
mysql_connect('localhost''mysql_user''mysql_password');
$db_list mysql_list_dbs($link);

while (
$row mysql_fetch_object($db_list)) {
    echo 
$row->Database "n";
}
?>

List Tables
<?php
    $dbname 
'mysql_dbname';

    if (!
mysql_connect('mysql_host''mysql_user''mysql_password')) {
        print 
'Could not connect to mysql';
        exit;
    }

    
$result mysql_list_tables($dbname);
    
    if (!
$result) {
        print 
"DB Error, could not list tablesn";
        print 
'MySQL Error: ' mysql_error();
        exit;
    }
    
    while (
$row mysql_fetch_row($result)) {
        print 
"Table: $row[0]n";
    }

    
mysql_free_result($result);
?>

List fields
<?php
$link 
mysql_connect('localhost''mysql_user''mysql_password');

$fields mysql_list_fields("database1""table1"$link);
$columns mysql_num_fields($fields);

for (
$i 0$i $columns$i++) {
    echo 
mysql_field_name($fields$i) . "n";
}
?>

List Processes
<?php
$link 
mysql_connect('localhost''mysql_user''mysql_password');

$result mysql_list_processes($link);
while (
$row mysql_fetch_row($result)){
    
printf("%s %s %s %s %sn"$row["Id"], $row["Host"], $row["db"],
       
$row["Command"], $row["Time"]);
}
mysql_free_result ($result);
?>
 
Description for: MySQL / Database Information
  List information on databases available on a MySQL server, tables, fields and processes


 
Powered by: PHP-CSL V0.9