Find this useful? Enter your email to receive occasional updates for securing PHP code.

Signing you up...

Thank you for signing up!

PHP Decode

--TEST-- PDO SQLRELAY (bindParam() and bindValue() do not work with MySQL MATCH () AGAINST..

Decoded Output download

--TEST--
PDO SQLRELAY (bindParam() and bindValue() do not work with MySQL MATCH () AGAINST ())
--SKIPIF--
<?php include "pdo_sqlrelay_mysql_skipif.inc"?>
--FILE--
<?php
include "PDOSqlrelayMysqlTestConfig.inc";
$db = PDOSqlrelayMysqlTestConfig::PDOfactory();

try {

	$db->exec('DROP TABLE IF EXISTS test');
	$db->exec('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=MyISAM');
	$db->exec('CREATE FULLTEXT INDEX idx1 ON test(label)');

	$stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)');
	$stmt->execute(array(':placeholder' => 'row'));
	var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));

	$stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)');
	$stmt->execute(array('placeholder' => 'row'));
	var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));

	$stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (?)');
	$stmt->execute(array('row'));
	var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));

} catch (PDOException $e) {

	printf("[001] %s, [%s} %s
",
		$e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));

}

print "done!";
?>
--CLEAN--
<?php
include "PDOSqlrelayMysqlTestConfig.inc";
$db = PDOSqlrelayMysqlTestConfig::PDOfactory(true);
$db->exec('DROP TABLE IF EXISTS test');
?>
--EXPECTF--
array(0) {
}
array(0) {
}
array(0) {
}
done!

Did this file decode correctly?

Original Code

--TEST--
PDO SQLRELAY (bindParam() and bindValue() do not work with MySQL MATCH () AGAINST ())
--SKIPIF--
<?php include "pdo_sqlrelay_mysql_skipif.inc"?>
--FILE--
<?php
include "PDOSqlrelayMysqlTestConfig.inc";
$db = PDOSqlrelayMysqlTestConfig::PDOfactory();

try {

	$db->exec('DROP TABLE IF EXISTS test');
	$db->exec('CREATE TABLE test(id INT, label CHAR(255)) ENGINE=MyISAM');
	$db->exec('CREATE FULLTEXT INDEX idx1 ON test(label)');

	$stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)');
	$stmt->execute(array(':placeholder' => 'row'));
	var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));

	$stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (:placeholder)');
	$stmt->execute(array('placeholder' => 'row'));
	var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));

	$stmt = $db->prepare('SELECT id, label FROM test WHERE MATCH label AGAINST (?)');
	$stmt->execute(array('row'));
	var_dump($stmt->fetchAll(PDO::FETCH_ASSOC));

} catch (PDOException $e) {

	printf("[001] %s, [%s} %s\n",
		$e->getMessage(), $db->errorCode(), implode(' ', $db->errorInfo()));

}

print "done!";
?>
--CLEAN--
<?php
include "PDOSqlrelayMysqlTestConfig.inc";
$db = PDOSqlrelayMysqlTestConfig::PDOfactory(true);
$db->exec('DROP TABLE IF EXISTS test');
?>
--EXPECTF--
array(0) {
}
array(0) {
}
array(0) {
}
done!

Function Calls

None

Variables

None

Stats

MD5 48af5a509e8317a80dfcd4f2e7f3ed6e
Eval Count 0
Decode Time 94 ms