PHP/MySQL Database/Database Query

Материал из Web эксперт
Перейти к: навигация, поиск

Get data from database query

<html>
<body>
<ul>
<?php
$cnx = mysql_connect("mysql153.secureserver.net","wbex","password");
mysql_select_db("wbex");
$employees = @mysql_query("SELECT ID, FirstName FROM Employee");
if (!$employees) {
  die("<p>Error retrieving employees from database!<br />".
      "Error: " . mysql_error() . "</p>");
}
while ($employee = mysql_fetch_array($employees)) {
  $id   = $employee["ID"];
  $name = htmlspecialchars($author["Name"]);
  echo("$name <br>");
  echo("$id <br>");
}
?>
</ul>
</p>
</body>
</html>



List Database, Table, and Field

<html>
<head>
<title>Listing every database, table, and field</title>
</head>
<body>
<?php
$user = "wbex";
$pass = "password";
$db = "wbex";
$link =  mysql_connect( "mysql153.secureserver.net", $user, $pass );
if ( ! $link )
    die( "Couldn"t connect to MySQL" );
$db_res = mysql_list_dbs( $link );
while ( $db_rows = mysql_fetch_row( $db_res ) ) {
    print "<b>$db_rows[0]</b>\n";
    if ( !@mysql_select_db( $db_rows[0], $link ) ) {
        print "<dl><dd>couldn"t connect -- " . mysql_error() ." </dl>";
        continue;
    }
    $tab_res = mysql_list_tables( $db_rows[0], $link );
    print "\t<dl><dd>\n";
    while ( $tab_rows = mysql_fetch_row( $tab_res ) ){
        print "\t<b>$tab_rows[0]</b>\n";
        $query_res = mysql_query( "SELECT * from $tab_rows[0]" );
        $num_fields = mysql_num_fields( $query_res );
        print "\t\t<dl><dd>\n";
        for ( $x=0; $x<$num_fields; $x++ ){
            print "\t\t<i>";
            print mysql_field_type( $query_res, $x );
            print "</i> <i>";
            print mysql_field_len( $query_res, $x );
            print "</i> <b>";
            print mysql_field_name( $query_res, $x );
            print "</b> <i>";
            print mysql_field_flags( $query_res, $x );
            print "</i><br>\n";
        }
        print "\t\t</d1>\n";
    }
    print "\t</d1>\n";
}
mysql_close( $link );
?>
</body>
</html>



Sending SQL Queries to a MySQL Database using the mysql_query () function

<?php
  $host="mysql153.secureserver.net";
  $uname="wbex";
  $pass="password";
  $database="wbex";
  
  $connection= mysql_connect ($host, $uname, $pass) or die ("Database connection failed!");
  $result=mysql_select_db ($database) or die ("Database could not be selected");
  $query = "drop table if exists mytable";
  $result = mysql_query ($query) or die ("Query failed.");
?>
Источник — «http://wbex.ru/index.php?title=PHP/MySQL_Database/Database_Query&oldid=1123»