我已经保存了输出后续行的参数化字符串匹配查询所需的步骤。传输到故障驱动器时,我的文件丢失了。所以...我正在尝试将所有内容混在一起,这是行不通的。
$stmt = $link->prepare("SELECT id,entry,date from table WHERE string=? ORDER by Id DESC");
$stmt->bind_param('s',$string);
$stmt->execute();
$stmt->bind_result($id_db,$entry_db,$date_db);
if (($result = $link->query($stmt)) {
while ($row = $result->fetch_row()){
}
}
我已经知道这是错误的,我不使用参数化结果,而是尝试使用数组索引,例如$ row [0]。
我为此知道要大喊大叫。
我想要的最终结果例如:
string1具有以下行:bob,mack,chris
string2具有行:爱丽丝,克莱尔,劳拉
如果$ string = string1,则输出应为:
克里斯
马克
鲍勃
我相信我的问题是我正在混合语句类型
最佳答案
假设“ $ link”是PHP的“ mysqli”类的一个实例,并且“ id”和“ Id”是表中的两个不同列(如果不是,请尝试在其中将“ Id”替换为“ id”)段“ .. ORDER BY Id ..”),根据您的示例,以下是我建议您尝试的操作:
// Declare your "prepare" statement (make sure to change "Id" for "id" if both are used
// in reference to the same column in your table)
$stmt = $link->prepare('SELECT id, entry, date FROM table WHERE string = ? ORDER BY Id DESC');
// Bind the $string variable
$stmt->bind_param('s',$string);
// Execute the statement
$stmt->execute();
// Store the result (this is sometimes useful, depending on the data types in your table)
$stmt->store_result();
// Check whether at least one row in table matches the query, if not, stop here...
if ($stmt->num_rows === 0) exit('No matching rows'); // or do something else...
// Declare a container (i.e. storage) for each row (this is optional and depends on what
// you are trying to achieve)
$data = [];
// Loop through results (this is just an example; this could be achieved in a number
// of different ways)
for ($i = 0; $i < $stmt->num_rows; $i++)
{
// Add a new array cell to $data, at index $i
$data[$i] = [];
// Bind result for row $i
$stmt->bind_result($data[$i]['id'],$data[$i]['entry'],$data[$i]['date']);
// Fetch $i^{th} row
$stmt->fetch();
}
// Check if it worked (temporary)
var_dump($data);