, . - . , , INSERT SQL. :
mysql> INSERT INTO Artifacts
SET title='';
, ( SQL) PHP . mysql_query().
mysql_query
mysql_query ( query
[, link_identifier])
mysql_query() SQL- MySQL , link_identifier ( - MySQL). link_identifier , . , , mysql_connect() . .
: .
SELECT, SHOW, EXPLAIN, DESCRIBE, mysql_query() , FALSE, . mysql_query() TRUE, , FALSE - . , FALSE, , . . , . mysql_query() FALSE, .
, , . , . insert.php, , $ _POST ['_'].
<?
$conn=mysql_connect("localhost","nina","123");//
//
$database = "book";
$table_name = "Artifacts";
mysql_select_db($database); //
$list_f = mysql_list_fields($database,$table_name);
//
$n = mysql_num_fields($list_f); //
//
//
$sql = "INSERT INTO $table_name SET "; //
// ,
for($i=0;$i<$n; $i++){
$name_f = mysql_field_name ($list_f,$i); //
$value = $_POST[$name_f]; //
$j = $i + 1;
$sql = $sql. $name_f." = '$value'"; //
// $sql =
if ($j <> $n) $sql = $sql. ", "; //
// ,
}
// - ,
// ,
//echo $sql;
$result = mysql_query($sql,$conn); //
|
|
//
if (!$result) echo " Can't add ($table_name) ";
else echo "Success!<br>";
?>
11.0.2. insert.php
, web- . . , (author, photo) (Persons, Images). MySQL ( - . ), , .. . , . , , , , . , , . - , MySQL.