{
echo
$row
àp_id;
echo
$row
àp_name;
}
mysql_insert_id
在使用
INSERT 命令增加完一条信息后,可利用此函数取得刚刚增加记录的 unique id
语法
int mysql_insert_id([esource link_identifier])
eg
代码如下
:
$DB_HOST
="localhost";
$DB_LOGIN
="root";
$DB_PASSWORD
="123456";
$DB_NAME
="flag";
$conn
=mysql_connect(
$DB_HOST
,
$DB_LOGIN
,
$DB_PASSWORD
);
mysql_select_db(
$DB_NAME
);
$SQLStr
"INSERT INTO produce (p_id,p_name)VALUES('','PHP 书')";
$res
=mysql_query(
$res
);
$p_id
=mysql_insert_id();
mysql_num_rows
取得查询结果里有几行
语法
int mysql_num_rows(resource result)
eg
代码如下
:
$DB_HOST
="localhost";
$DB_LOGIN
="root";
$DB_PASSWORD
="123456";
$DB_NAME
="flag";
$conn
=mysql_connect(
$DB_HOST
,
$DB_LOGIN
,
$DB_PASSWORD
);
mysql_select_db(
$DB_NAME
);
$res
=mysql_query("SELECT * FROM PRODUCT");
$num
=mysql_num_rows(
$res
);