我在Dreamweaver中新建一个php文件saveaddleibie.php。代码如下:
<?php
include("conn/conn.php");
mysql_query("insert into tb_type(id
,typename
) values ('3','机械')",$conn);
?>
当然conn文件夹下的conn.php文件也写好。用DW打开saveaddleibie.php,按F12运行后,应该向数据库的tb_type表中插入数据。但结果令人无解,只插入成功'id'列的3,
'typename'列的'机械'没插入成功。具体看命令行的查询。如下图:
但我在命令行中输入语句insert into tb_type(id
,typename
) values ('3','机械')后,
两列都能正常插入。请各位大神,我该怎么办才能在用DW的方式正常插入两列数据呢?
汉字得编码在php中估计有问题。
个人觉得不至于一列成功一列不成功的情况
1、检查一下是不是后面有update操作,把另一个字段置空了
2、配置一下mysql日志,把执行的SQL记录下来,执行一次,查一下sql记录
我是提问者,根据回答者的提示,我配置了一下mysql日志,再在DW中按F12,执行一次插入,查看一下sql记录,还没找到原因。具体mysql日志如下:
MySQL, Version: 5.6.22-log (MySQL Community Server (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
150417 19:05:39 1 Connect root@localhost on
1 Query SET CHARACTER SET 'utf8mb4'
1 Query SET collation_connection = 'utf8mb4_unicode_ci'
1 Query SHOW TABLES FROM db_shop
1 Init DB db_shop
1 Query SELECT DATABASE()
1 Init DB db_shop
1 Query SELECT * FROM tb_type
LIMIT 0, 25
1 Query SELECT TABLE_NAME
FROM information_schema.VIEWS
WHERE TABLE_SCHEMA = 'db_shop'
AND TABLE_NAME = 'tb_type'
1 Query SELECT ,TABLE_SCHEMA
AS Db
,TABLE_NAME
AS Name
,TABLE_TYPE
AS TABLE_TYPE
,ENGINE
AS Engine
,ENGINE
AS Type
,VERSION
AS Version
,ROW_FORMAT
AS Row_format
,TABLE_ROWS
AS Rows
,AVG_ROW_LENGTH
AS Avg_row_length
,DATA_LENGTH
AS Data_length
,MAX_DATA_LENGTH
AS Max_data_length
,INDEX_LENGTH
AS Index_length
,DATA_FREE
AS Data_free
,AUTO_INCREMENT
AS Auto_increment
,CREATE_TIME
AS Create_time
,UPDATE_TIME
AS Update_time
,CHECK_TIME
AS Check_time
,TABLE_COLLATION
AS Collation
,CHECKSUM
AS Checksum
,CREATE_OPTIONS
AS Create_options
,TABLE_COMMENT
AS Comment
FROM information_schema
.TABLES
t
WHERE TABLE_SCHEMA
IN ('db_shop')
AND t.TABLE_NAME
= 'tb_type' ORDER BY Name ASC
1 Query SELECT COUNT() FROM db_shop
.tb_type
1 Query SELECT TABLE_NAME
FROM information_schema.VIEWS
WHERE TABLE_SCHEMA = 'db_shop'
AND TABLE_NAME = 'tb_type'
AND IS_UPDATABLE = 'YES'
1 Query SHOW INDEXES FROM db_shop
.tb_type
1 Query SHOW CREATE TABLE db_shop
.tb_type
1 Query SHOW FULL COLUMNS FROM db_shop
.tb_type
1 Query SHOW COLUMNS FROM db_shop
.tb_type
1 Query SELECT CURRENT_USER()
1 Query SELECT PRIVILEGE_TYPE
FROM INFORMATION_SCHEMA
.USER_PRIVILEGES
WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'
1 Init DB db_shop
1 Quit
2 Connect root@localhost on
2 Query SET CHARACTER SET 'utf8mb4'
2 Query SET collation_connection = 'utf8mb4_unicode_ci'
2 Quit
150417 19:05:46 3 Connect root@localhost on
3 Init DB db_shop
3 Query set character set gb2312
3 Query set names gb2312
3 Query insert into tb_type(id
,typename
) values ('3','机械')
3 Quit
150417 19:05:57 4 Connect root@localhost on
4 Query SET CHARACTER SET 'utf8mb4'
4 Query SET collation_connection = 'utf8mb4_unicode_ci'
4 Query SHOW TABLES FROM db_shop
4 Init DB db_shop
4 Query SELECT DATABASE()
4 Init DB db_shop
4 Query SELECT * FROM tb_type
LIMIT 0, 25
4 Query SELECT TABLE_NAME
FROM information_schema.VIEWS
WHERE TABLE_SCHEMA = 'db_shop'
AND TABLE_NAME = 'tb_type'
4 Query SELECT ,TABLE_SCHEMA
AS Db
,TABLE_NAME
AS Name
,TABLE_TYPE
AS TABLE_TYPE
,ENGINE
AS Engine
,ENGINE
AS Type
,VERSION
AS Version
,ROW_FORMAT
AS Row_format
,TABLE_ROWS
AS Rows
,AVG_ROW_LENGTH
AS Avg_row_length
,DATA_LENGTH
AS Data_length
,MAX_DATA_LENGTH
AS Max_data_length
,INDEX_LENGTH
AS Index_length
,DATA_FREE
AS Data_free
,AUTO_INCREMENT
AS Auto_increment
,CREATE_TIME
AS Create_time
,UPDATE_TIME
AS Update_time
,CHECK_TIME
AS Check_time
,TABLE_COLLATION
AS Collation
,CHECKSUM
AS Checksum
,CREATE_OPTIONS
AS Create_options
,TABLE_COMMENT
AS Comment
FROM information_schema
.TABLES
t
WHERE TABLE_SCHEMA
IN ('db_shop')
AND t.TABLE_NAME
= 'tb_type' ORDER BY Name ASC
4 Query SELECT COUNT() FROM db_shop
.tb_type
4 Query SELECT TABLE_NAME
FROM information_schema.VIEWS
WHERE TABLE_SCHEMA = 'db_shop'
AND TABLE_NAME = 'tb_type'
AND IS_UPDATABLE = 'YES'
4 Query SHOW INDEXES FROM db_shop
.tb_type
4 Query SHOW CREATE TABLE db_shop
.tb_type
4 Query SHOW FULL COLUMNS FROM db_shop
.tb_type
4 Query SHOW COLUMNS FROM db_shop
.tb_type
4 Query SELECT CURRENT_USER()
4 Query SELECT PRIVILEGE_TYPE
FROM INFORMATION_SCHEMA
.USER_PRIVILEGES
WHERE GRANTEE='''root''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'
4 Init DB db_shop
4 Quit
5 Connect root@localhost on
5 Query SET CHARACTER SET 'utf8mb4'
5 Query SET collation_connection = 'utf8mb4_unicode_ci'
5 Quit
请问各位大神是什么原因呢?