我创建了一个自定义函数,但我收到了这个错误。我认为我的脚本中没有"解析错误"。
Parse error: syntax error, unexpected ',', expecting '&' or T_VARIABLE in C:'wamp'www'web template'test.php on line 8
<?php
require('global script/php/dbConnect.php');
$varName = 'sd';
echo checkDBDuplicate('account_list', 'memberID', $varName);
function checkDBDuplicate(tableName, dbFieldName, variableName)
{
$tableName = tableName;
$dbFieldName = dbFieldName;
$variableName = variableName;
$searchDuplicate = mysql_query('
SELECT $dbFieldName
FROM $tableName
WHERE $dbFieldName = $variableName
') or die(mysql_error());
$countRow = mysql_num_rows($searchDuplicate);
return $countRow;
}
?>
这个脚本的目的是测试我是否可以在SELECT语句中使用变量。
变量应该有一个$
前缀。所以
function checkDBDuplicate(tableName, dbFieldName, variableName) {
是错误的,使其
function checkDBDuplicate($tableName, $dbFieldName, $variableName) {
显然,进一步地说也是如此,所以:
$tableName = tableName;
$dbFieldName = dbFieldName;
$variableName = variableName;
需要相同的处理
function checkDBDuplicate(tableName, dbFieldName, variableName) {
应该是
function checkDBDuplicate($tableName, $dbFieldName, $variableName) {
和iside功能体:
$tableName = $tableName;
$dbFieldName = $dbFieldName;
$variableName = $variableName;
您的函数应该是这样的:
<?php
require('global script/php/dbConnect.php');
$varName = 'sd';
echo checkDBDuplicate('account_list', 'memberID', $varName);
function checkDBDuplicate($tableName, $dbFieldName, $variableName) {
$tableName = $tableName;
$dbFieldName = $dbFieldName;
$variableName = $variableName;
$searchDuplicate = mysql_query("
SELECT $dbFieldName
FROM $tableName
WHERE $dbFieldName = $variableName
") or die(mysql_error());
$countRow = mysql_num_rows($searchDuplicate);
return $countRow;
}
?>
不需要再次分配变量!!!
还有一些"answers"缺少SQL查询。
<?php
require('global script/php/dbConnect.php');
$varName = 'sd';
echo checkDBDuplicate('account_list', 'memberID', $varName);
function checkDBDuplicate($tableName, $dbFieldName, $variableName) {
$searchDuplicate = mysql_query("
SELECT `$dbFieldName`
FROM `$tableName`
WHERE `$dbFieldName` = '$variableName'
") or die(mysql_error());
$countRow = mysql_num_rows($searchDuplicate);
return $countRow;
}
?>