Web- - . -, , , mysql_connect(), MySQL. -, SQL-, , mysql_query(), PHP- SQL. -, Web- Web-. , MySQL mysql_fetch_array(), SQL- . , echo print() Web-.
, , MySQL HTML- Web- SQL- , . , mysql_connect() :
$link = mysql_connect($db_host, $db_user, $db_pass);
$db_host "localhost" ( MySQL , Web-) IP- , MySQL, . ( IP- MySQL Internet-.) , $db_user $db_pass, , mysql_connect() MySQL. MySQL , , $db_user="root" $db_pass="password".
mysql_connect() $link false, . , if $link, . , , , , :
if (!mysql_select_db($db_name, $link)
{
// ,
//
}
else
{
//
//
}
MySQL, , , , . $db_name "", a $link , mysql_connect(). , , PHP- ( mysql_select_db()), , . mysql_select_db() true false .
|
|
|
MySQL mysql_query(), :
$result = mysql_query($query, $link);
, products, $query SQL-:
SELECT * FROM ORDER BY
, $link , mysql_connect(), . mysql_query() false ( - SQL-) , .
(. . , products) mysql_fetch_array() . Web-. , ( ), , , , HTML-, Web-:
// ,
$fields = mysql_num_f ields ($result);
// HTML-
echo "<center><table border='1' cellpadding='5'>";
//
// HTML-
echo "<tr>";
for ($i = 0; $i < $fields; $i++)
{
echo "<th>". mysql_field_name($result, $i). "</th>";
$fieldType[$i] =mysql_field_type($result,$i);
}
echo "</tr>";
// HTML-
while ($array = mysql_fetch_array ($result))
{
echo "<tr>";
for ($i = 0; $i < $fields; $i ++)
{
if ($fieldType[$i] <> "string")
echo "<td align='right'>";
else
echo "<td align='left'>";
echo "$array[$i]</td>";
}
echo "</tr>";
}
echo "</table></center>";
, , , .
Devart dbForge Studio for MySQL (. 1). PHP, (.1).
d:\server\www\index.php. d:\server\mysql\data. , URL- http://localhost.
| ||||
1
| . . - ( ); - ( ); - ( ); - ( ); - ; - . | |
| . . - - ( ); - ( ); - ; - ; - ; | |
| . - ( ); - ( ); - ( ); - ( ); - ; - . | |
| . - ( ); - ( ); - ( ); - ( ); - ( ); | |
| - ( ); - ; - ( ); - ; | |
| - ( ); - ( ); - ; - ; - ; | |
| - ( ); - ( ); - ; - - ( ); - - ; | |
| - ( ); - ( ); - ; - ( ); - ; | |
| - - ( ) (., , ..); - ( ); - - ( ); - ( ); - ( ); - ( ); | |
| - ( ); - / ( ); - ( ); - ; - ( ); |
