MySQL中的mysqli模糊查询

$content='3';

$mysqli = new MYSQLI( 'localhost', 'root', '12345678', 'ceshi', 3306 ); //实例化mysqli

$query="select * from dunling_chat where content like '%".$content."%' ";

$result=$mysqli->prepare($query);

@$result->bind_param("s",$content); //绑定参数

$result->execute();

$result->bind_result($id,$nicheng,$content,$time); //绑定结果

while ($result->fetch()) {

echo $id."

echo $nicheng."

echo $content."

echo $time."

}

$result->close();

$mysqli->close();

?>

MySQL中的pdo模糊查询

/php操作pdo实现查询

header( "Content-type: text/html; charset=utf-8" );

$dbms = 'mysql';

$user = 'root';

$pwd = '12345678';

$dbName = 'ceshi';

$host = 'localhost';

$charset = 'utf8';

$dsn = "$dbms:host=$host;dbname=$dbName;charset=$charset";

try {

$pdo = new PDO( $dsn, $user, $pwd );

} catch ( Exception $e ) {

echo $e->getMessage();

}

$content = '23';

//查询

$sql = "select * from dunling_chat where content like '%".$content."%' ";

//准备sql模板

$stmt = $pdo->prepare( $sql );

//绑定参数

$stmt->bindValue( 1, $content );

//执行预处理语句

$stmt->execute();

//推荐这种方式来获取查询结果

while ( $row = $stmt->fetch() ) {

echo $row[ 'id' ] . "

echo $row[ 'nicheng' ] . "

echo $row[ 'content' ] . "

echo $row[ 'time' ] . "

}

//释放查询结果

$stmt = null;

//关闭连接

$pdo = null;

?>