php/mysql其他挑战

Question

我正在尝试两个不同的查询，他们都很好地单独工作，但我希望他们中的一个会落在PHP的elseif if语句中，或者如果有人有更好的solution.below是第一个和第二个语句的代码。

第一条语句

$retvval = mysql_query( $sqql);
$sqql = "SELECT `autoID`, `Name of Doctor`, `Email`, `Hospital of Practise`, `State`,
`Specialization`, `Professional Organization`, `webpage` FROM `doctor_locator`
WHERE state = '$states' AND `name of doctor` LIKE 'Dr%'";
$retvval = mysql_query( $sqql);
if(! $retvval )
{
  die('Could not get data: ' . mysql_error());
}

while($row = mysql_fetch_array($retvval))
{
 echo "{$row['autoID']}.  "."Name of Doctor: <a href = \"{$row['webpage']}\">{$row['Name of Doctor']} </a><br>"
    ."Email: {$row['Email']} <br>". "Hospital of Practise: {$row['Hospital of Practise']}
    <br>". "State:  {$row['State']} <br>" . "Specialization: {$row['Specialization']} <br> ";
}

第二条语句

$retval = mysql_query( $sql);
$sql = "SELECT `autoID`, `Name of Doctor`, `Email`, `Hospital of Practise`, `State`,
`Specialization`, `Professional Organization`, `webpage` FROM `doctor_locator`
WHERE state = '$states' AND specialization = '$specialize' ";
 $retval = mysql_query( $sql);
 if(! $retval )
 {
  die('Could not get data: ' . mysql_error());
 }

 while($row = mysql_fetch_array($retval))
 {
echo "{$row['autoID']}.  "."Name of Doctor: <a href = \"{$row['webpage']}">{$row['Name of Doctor']} </a><br>"."Email: {$row['Email']} <br>". "Hospital of Practise:{$row['Hospital of Practise']}<br>". "State:  {$row['State']} <br>" . "Specialization: {$row['Specialization']} <br> ";
}

Answer 1

你可以这样做。

$sql = "SELECT `autoID`, `Name of Doctor`, `Email`, `Hospital of Practise`, `State`,
`Specialization`, `Professional Organization`, `webpage` FROM `doctor_locator`
WHERE state = '$states' AND specialization = '$specialize' ";

$sqql = "SELECT `autoID`, `Name of Doctor`, `Email`, `Hospital of Practise`, `State`,
`Specialization`, `Professional Organization`, `webpage` FROM `doctor_locator`
WHERE state = '$states' AND `name of doctor` LIKE 'Dr%'";

$retval = (mysql_query($sqql) ? mysql_query($sqql) : mysql_query($sql));

if($retval){
      while loop
} 
else { 
      die(); 
}

Answer 2

这可以通过PDO来完成：

/* Create new connection http://php.net/manual/en/pdo.construct.php */
$pdo = new Pdo($connectionString, $user, $pass);
/* Prepare the first query */
$statement = $pdo->prepare($sqql);
/* Without actually executing it, check if there is any error */
if ($statement->errorCode()) {
  /* If so, then prepare the second statement */
  $statement = $pdo->prepare($sql);
}

/* Execute it. It will be the first, if it was valid or the second, if the first was not valid. */
$statement->execute();