php:<p>
Search the employee database:<br />
<form action="<?php htmlspecialchars($_SERVER['PHP_SELF']);?>" method="post">
Keyword:<br />
<input type="text" name="lastname" size="20" maxlength="40" value=""/><br />
<input type="submit" name="Submit" value="Search!"/>
</form>
</p>
<?php
if (isset($_POST['Submit'])) {
if (isset($_POST['lastname'])) {
$mysqldb = new mysqli('localhost', 'QQAA2233', '3322QQAA', 'corporate');
$keyword = mysqli_real_escape_string($mysqldb, $_POST['lastname']);
$result = mysqli_query($mysqldb, "SELECT first_name, email FROM employees WHERE MATCH(last_name) AGAINST('$keyword')");
if (mysqli_num_rows($result) > 0) {
while (($row = mysqli_fetch_object($result)) == true)
echo "$row->first_name ($row->email)<br />";
}
else
echo 'No results found.';
}
}
?>
数据库corporate:表employees:
| id | employee_id | first_name | last_name | email | phone |salary |
+----+-------------+------------+-----------+---------------------+------------+--------+
| 1 | 1 | Bob | Connors | [email protected] | 2125559945 |100.00 |
| 2 | 2 | Jason | Gilmore | [email protected] | 2125551212 |200.00 |
| 3 | 3 | Matt | Wade | [email protected] | 2125559999 |300.00 |
| 4 | | Mike | Ailmore | [email protected] | |0.00 |
其中last_name中有两个有相同ilmore,Gilmore与Ailmore。但我在PHP中输入ilmore为什么不能显示Jason与Mike的列?提示
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in D:\xampp\htdocs\Project\newfile3.php on line 20
No results found.
Search the employee database:<br />
<form action="<?php htmlspecialchars($_SERVER['PHP_SELF']);?>" method="post">
Keyword:<br />
<input type="text" name="lastname" size="20" maxlength="40" value=""/><br />
<input type="submit" name="Submit" value="Search!"/>
</form>
</p>
<?php
if (isset($_POST['Submit'])) {
if (isset($_POST['lastname'])) {
$mysqldb = new mysqli('localhost', 'QQAA2233', '3322QQAA', 'corporate');
$keyword = mysqli_real_escape_string($mysqldb, $_POST['lastname']);
$result = mysqli_query($mysqldb, "SELECT first_name, email FROM employees WHERE MATCH(last_name) AGAINST('$keyword')");
if (mysqli_num_rows($result) > 0) {
while (($row = mysqli_fetch_object($result)) == true)
echo "$row->first_name ($row->email)<br />";
}
else
echo 'No results found.';
}
}
?>
数据库corporate:表employees:
| id | employee_id | first_name | last_name | email | phone |salary |
+----+-------------+------------+-----------+---------------------+------------+--------+
| 1 | 1 | Bob | Connors | [email protected] | 2125559945 |100.00 |
| 2 | 2 | Jason | Gilmore | [email protected] | 2125551212 |200.00 |
| 3 | 3 | Matt | Wade | [email protected] | 2125559999 |300.00 |
| 4 | | Mike | Ailmore | [email protected] | |0.00 |
其中last_name中有两个有相同ilmore,Gilmore与Ailmore。但我在PHP中输入ilmore为什么不能显示Jason与Mike的列?提示
Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in D:\xampp\htdocs\Project\newfile3.php on line 20
No results found.
解决方案 »
- fckeditor没有英文语言包无法访问
- 关于页面保存填写信息的问题
- 根据用户的ip地址判断出来其所在的城市!!急!!!!
- 时间循环的问题,在线等
- 为什么使用session_start();的时候总是警告啊?
- php 与 sql server2000
- urlencode()和 rawurlencode()有什么区别??
- 我是php未入门者,请指教!
- php 怎么同时输出 MySQL表的字段和值
- php 如何获取另一个php文件中的执行后的变量值,不受其它干扰因素
- 练习php文件下载:提示打不开图片文件,因为此文件可能已经损坏,或者过大
- PHP新手请教:getimagesize不能获取远程图片信息!??急
看看都是什么错
我已经在last_name上建立了全文索引了,不过始终还是No results found.我在mysql中select match(last_name) against('ilmore') from employees;但显示
+------------------------------------+
| match(last_name) against('ilmore') |
+------------------------------------+
| 0 |
| 0 |
| 0 |
| 0 |
+------------------------------------+
全部为0,是不是我的用法错误呢
+-------------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------------------+------+-----+---------+----------------+
| id | smallint(5) unsigned | NO | PRI | NULL | auto_increment |
| employee_id | char(8) | NO | | NULL | |
| first_name | varchar(25) | NO | | NULL | |
| last_name | varchar(35) | NO | MUL | NULL | |
| email | varchar(55) | NO | | NULL | |
| phone | char(10) | NO | | NULL | |
| salary | decimal(8,2) | NO | | NULL | |
+-------------+----------------------+------+-----+---------+----------------+
另外我添加了索引fulltext(last_name)
mysql> show table status like '%employees%'\G;
*************************** 1. row ***************************
Name: employees
Engine: MyISAM
Version: 10
Row_format: Dynamic
Rows: 4
Avg_row_length: 52
Data_length: 208
Max_data_length: 281474976710655
Index_length: 3072
Data_free: 0
Auto_increment: 5
Create_time: 2012-10-26 08:48:19
Update_time: 2012-10-26 08:48:19
Check_time: NULL
Collation: latin1_swedish_ci
Checksum: NULL
Create_options:
Comment:
1 row in set (0.00 sec)
不是ALTER TABLE employees ADD FULLTEXT(last_name);这样子的吗?