PHP MySQL
| : PHP MySql. , (mysql_connect, mysql_query, mysql_result, mysql_num_rows, mysql_close). - web - .
: , PHP, mysql, , sql, html-, , , artifact, , ,text, , , , , , ,mysql_connect, MYSQL_CLIENT_COMPRESS, MYSQL_CLIENT_IGNORE_SPACE, MYSQL_CLIENT_INTERACTIVE, mysql_close, mysql_select_db,mysql_field_name, mysql_field_len, mysql_field_type, mysql_field_flags, BLOB, mysql_query, mysql_num_rows, explode, , , explain, DESCRIBE, $_POST, , SQL, , , , mysql_result, mysql_fetch_array,, , fieldname, , , mysql_fetch_row, , , , ,
PHP , MySQL. MySQL, web- . , ? , SQL. web- html- , . .
Artifacts, . , (Persons) (Images). , Artifacts :
(title);
(author);
(description);
(alternative);
(photo).
255 (.. VARCHAR(255)), - ( TEXT), " " "" Persons Images .
, - . , (.. ) html-.
|
|
:
;
;
;
html-.
, , . .
, , , - . mysql_connect.
mysql_connect
mysql_connect ([ server
[, username [, password
[, new_link
[, client_flags]]]]])
MySQL FALSE . :
server = 'localhost:3306'
username =
password =
, , . , new_link, .
client_flags - : MYSQL_CLIENT_COMPRESS ( ), MYSQL_CLIENT_IGNORE_SPACE ( ), MYSQL_CLIENT_INTERACTIVE (interactive_timeout - wait_timeout - ).
new_link PHP 4.2.0, client_flags - PHP 4.3.0.
, mysql_close().
, nina "123":
<?
$conn = mysql_connect(
"localhost", "nina","123")
or die("
: ". mysql_error());
echo " ";
mysql_close($conn);
?>
mysql_connect
shell>mysql -u nina -p123
, . book. MySQL use:
mysql>use book;PHP mysql_select_db.
mysql_select_db:
mysql_select_db ( database_name [, link_identifier])TRUE FALSE - .
book :
<?$conn = mysql_connect("localhost","nina","123") or die(" : ". mysql_error());echo " ";mysql_select_db("book");?>
. ? . PHP - mysql_list_fields.
mysql_list_fields
mysql_list_fields ( database_name, table_name [, link_identifier])table_name database_name. , , . , - . , . , , , .
|
|
mysql_field_name , . mysql_field_len . mysql_field_type , mysql_field_flags , . int, real, string, blob .. not_null, primary_key,unique_key, blob, auto_increment ..
:
mysql_field_name ( result, field_offset) mysql_field_type ( result, field_offset) mysql_field_flags ( result, field_offset) mysql_field_len ( result, field_offset)result - (, , mysql_list_fields mysql_query ( )), field_offset - .
, , mysql_list_fields mysql_query, , , . , , . mysql_field_name .. , . mysql_num_rows ( result) result.
Artifacts ( ).
<?$conn = mysql_connect("localhost","nina","123")or die(" : ". mysql_error());echo " ";mysql_select_db("book");$list_f = mysql_list_fields ("book","Artifacts",$conn); $n = mysql_num_fields($list_f);for($i=0;$i<$n; $i++){ $type = mysql_field_type($list_f, $i); $name_f = mysql_field_name($list_f,$i); $len = mysql_field_len($list_f, $i); $flags_str = mysql_field_flags ($list_f, $i);echo "<br> : ". $name_f;echo "<br> : ". $type;echo "<br> : ". $len;echo "<br> : ". $flags_str. "<hr>";}?>( , ):
: id : int : 11 : not_null primary_key auto_increment_________________________________________________ : title : string : 255 :