Uyifaka njani idatha kwitafile yedatha yeMySQL? php faka umzekelo wengxelo yedatha kuMySQL

MySQL databaseIndlela yokufaka idatha kwitafile? php uyaMySQLFaka ingxelo yedatha umzekelo

MySQL faka idatha

Ukusetyenziswa kwetafile yeMySQL FAKA KWI Ingxelo yeSQL ukufaka idatha.

Ungafaka idatha kwitafile yedatha nge-mysql> iwindow yomyalelo womyalelo, okanye ngeskripthi se-PHP ukufaka idatha.

Igrama

Ezi zilandelayo ziqhelekileyo zokufaka idatha kwiitafile zedatha ye-MySQL FAKA KWI Isivakalisi se-SQL:

INSERT INTO table_name ( field1, field2,...fieldN )
                       VALUES
                       ( value1, value2,...valueN );

Ukuba idatha iluhlobo lomlinganiswa, kufuneka usebenzise ukucaphula okukodwa okanye ukucaphula kabini, oku: "ixabiso".

Faka idatha ngefestile yomyalelo womyalelo

Ngezantsi siza kusebenzisa iSQL FAKA KWI Ingxelo ifaka idatha kwitafile yedatha yeMySQL chenweiliang_tbl

Umzekelo

Kulo mzekelo ulandelayo siza kufaka amaqhekeza amathathu edatha kwitheyibhile ye-chenweiliang_tbl:

root@host# mysql -u root -p password;
Enter password:*******
mysql> use chenweiliang;
Database changed
mysql> INSERT INTO chenweiliang_tbl 
    -> (chenweiliang_title, chenweiliang_author, submission_date)
    -> VALUES
    -> ("学习 PHP", "菜鸟教程", NOW());
Query OK, 1 rows affected, 1 warnings (0.01 sec)
mysql> INSERT INTO chenweiliang_tbl
    -> (chenweiliang_title, chenweiliang_author, submission_date)
    -> VALUES
    -> ("学习 MySQL", "菜鸟教程", NOW());
Query OK, 1 rows affected, 1 warnings (0.01 sec)
mysql> INSERT INTO chenweiliang_tbl
    -> (chenweiliang_title, chenweiliang_author, submission_date)
    -> VALUES
    -> ("JAVA 教程", "chenweiliang.com", '2016-05-06');
Query OK, 1 rows affected (0.00 sec)
mysql>

Qaphela: Phawula ngeentolo -> Ayiyonxalenye yengxelo yeSQL, imele nje umgca omtsha, ukuba inkcazo yeSQL inde kakhulu, singenza umgca omtsha ukubhala ingxelo yeSQL ngokusebenzisa iqhosha elithi Ngena. isemikholoni ;,

Kulo mzekelo ungasentla, asizange sinikeze idatha ye-chenweiliang_id, kuba le ndawo imiselwe njengophawu lwe-AUTO_INCREMENT xa sasidala itafile.Ke ngoko, intsimi iya kwandiswa ngokuzenzekelayo ngaphandle kokuba sifune ukuyiseta.Kumzekelo NOW () ngumsebenzi weMySQL obuyisela umhla kunye nexesha.

Okulandelayo, sinokujonga idatha yetafile yedatha kunye nengxelo elandelayo:

Faka idatha usebenzisa iscript sePHP

Ungasebenzisa mysqli_query() umsebenzi wePHP ukwenza SQL FAKA KUumyalelo wokufaka idatha.

Umsebenzi uneparameters ezimbini kwaye ubuyisela TRUE ukuba uphumezo luphumelele, kungenjalo ibuyisela FALSE.

Igrama

mysqli_query(connection,query,resultmode);

Umzekelo

Inkqubo kulo mzekelo ulandelayo ifumana iindawo ezintathu zedatha efakwe ngumsebenzisi kwaye ifake kwitafile yedatha:

<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
 die('连接失败: ' . mysqli_error($conn));
}
echo '连接成功
';
// 设置编码，防止中文乱码
mysqli_query($conn , "set names utf8");
 
$chenweiliang_title = '学习 Python';
$chenweiliang_author = 'chenweiliang.com';
$submission_date = '2016-03-06';
 
$sql = "INSERT INTO chenweiliang_tbl ".
 "(chenweiliang_title,chenweiliang_author, submission_date) ".
 "VALUES ".
 "('$chenweiliang_title','$chenweiliang_author','$submission_date')";
 
 
 
mysqli_select_db( $conn, 'chenweiliang' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
 die('无法插入数据: ' . mysqli_error($conn));
}
echo "数据插入成功\n";
mysqli_close($conn);
?>

Okulandelayo, sinokujonga idatha yetafile yedatha kunye nengxelo elandelayo: