Menu
Why my code fails ?
<i>
</i>mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);
$conn = mysqli_connect("localhost","root","","gulf"); //mysqli_connect("server","user","password","db");
$input_1 = 'studenbuzz';
$sql = "SELECT email from users WHERE password = ?";
$stmt = mysqli_stmt_init($conn);
if(mysqli_stmt_prepare($stmt,$sql))
{
mysqli_stmt_bind_param($stmt,"s",$input_1);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_bind_result($stmt,$output_1);
<br/>
<i> </i>while($row = mysqli_fetch_array($result,MYSQLI_ASSOC))
<i> </i>{
<i> </i> $id = $row["id"];
<i> </i> echo "$id<br>";
<i> </i>}
<i> </i>mysqli_stmt_close($stmt);
<i> </i>mysqli_close($conn);
<i> </i>
}
else
{
echo 'Mysqli Error: ' .mysqli_stmt_error();
echo '<br>';
echo 'Mysqli Error No: ' .mysqli_stmt_errno();
}
<i>
</i>mysqli_report(MYSQLI_REPORT_ERROR|MYSQLI_REPORT_STRICT);
$conn = mysqli_connect("localhost","root","","gulf"); //mysqli_connect("server","user","password","db");
$input_1 = 'studentbuzz';
$sql = "SELECT email from users WHERE password = ?";
$stmt = mysqli_stmt_init($conn);
if(mysqli_stmt_prepare($stmt,$sql))
{
mysqli_stmt_bind_param($stmt,"s",$input_1);
mysqli_stmt_execute($stmt);
mysqli_stmt_bind_result($stmt,$output_1);
<br/>
<i> </i>while(mysqli_stmt_fetch($stmt))
<i> </i>{
<i> </i> echo "$output_1<br>";
<i> </i>}
<i> </i>mysqli_stmt_close($stmt);
<i> </i>mysqli_close($conn);
<i> </i>
}
else
{
echo 'Mysqli Error: ' .mysqli_stmt_error();
echo '<br>';
echo 'Mysqli Error No: ' .mysqli_stmt_errno();
}
>@novice2022#1644061 Argument #1 ($result) must be of type mysqli_result, bool given
mysqli_stmt_execute()
false
mysqli_result
[code=php]
$result = mysqli_stmt_bind_result($stmt,$output_1);
if($result === false) {
die("<pre>".$stmt->error."</pre>");
}
[/code]
>@novice2022#1644061 The following works when I use the mysqli_stmt_fetch() function.
mysqli_fetch_array()
mysqli_result
mysql_stmt_get_result()
mysqli_fetch_array()
<i>
</i>if (!$pdo = my_pdo_connect_function($dbname))
{
(handle the error here and exit?)
}
$q = "select stuff from where idcolumn = :idcol order by"; // put query statement into a var
$qst = $pdo->prepare($q);
$parms = array(
'idcol'=>$id_value
);
if (!$qst->execute($parms))
{
(handle the failure of the query)
}
else
{
while($row = $qst->fetch())
{
(output your query results?)
}
}
<i>
</i>$conn = mysqli_connect("localhost","root","","gulf"); //mysqli_connect("server","user","password","db");
$input_1 = 'fat'; //keyword.
$sql = "SELECT id,domain from users WHERE keyword = ?";
$stmt = mysqli_stmt_init($conn);
mysqli_stmt_prepare($stmt,$sql);
mysqli_stmt_bind_param($stmt,"s",$input_1);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$row=mysqli_fetch_array($result,MYSQLI_BOTH); //Same as: $row=mysqli_fetch_array($result);
$id = $row['0'];
$email = $row['domain'];
echo "$id<br>";
echo "$domain<br>";
mysqli_stmt_close($stmt);
mysqli_close($conn);
<i>
</i>$conn = mysqli_connect("localhost","root","","gulf"); //mysqli_connect("server","user","password","db");
$input_1 = 'fat'; //keyword.
$sql = "SELECT id,domain from users WHERE keyword = ?";
$stmt = mysqli_stmt_init($conn);
mysqli_stmt_prepare($stmt,$sql);
mysqli_stmt_bind_param($stmt,"s",$input_1);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$row=mysqli_fetch_array($result); //Same as: $row=mysqli_fetch_array($result,MYSQLI_BOTH);
$id = $row['0'];
$domain = $row['domain'];
echo "$id<br>";
echo "$domain<br>";
mysqli_stmt_close($stmt);
mysqli_close($conn);
<i>
</i>$conn = mysqli_connect("localhost","root","","gulf"); //mysqli_connect("server","user","password","db");
$input_1 = 'fat'; //keyword.
$sql = "SELECT id,domain from users WHERE keyword = ?";
$stmt = mysqli_stmt_init($conn);
mysqli_stmt_prepare($stmt,$sql);
mysqli_stmt_bind_param($stmt,"s",$input_1);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$row=mysqli_fetch_array($result,MYSQLI_ASSOC); //Same as: $row=mysqli_fetch_assoc(%result);
$id = $row['id'];
$domain = $row['domain'];
echo "$id<br>";
echo "$domain<br>";
mysqli_stmt_close($stmt);
mysqli_close($conn);
<i>
</i>$conn = mysqli_connect("localhost","root","","gulf"); //mysqli_connect("server","user","password","db");
$input_1 = 'fat'; //keyword.
$sql = "SELECT id,domain from users WHERE password = ?";
$stmt = mysqli_stmt_init($conn);
mysqli_stmt_prepare($stmt,$sql);
mysqli_stmt_bind_param($stmt,"s",$input_1);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$row=mysqli_fetch_assoc($result); //Same as: $row=mysqli_fetch_array($result,MYSQLI_ASSOC);
$id = $row['id'];
$domain = $row['domain'];
echo "$id<br>";
echo "$domain<br>";
mysqli_stmt_close($stmt);
mysqli_close($conn);
<i>
</i>$conn = mysqli_connect("localhost","root","","gulf"); //mysqli_connect("server","user","password","db");
$input_1 = 'fat'; //keyword.
$sql = "SELECT id,email from users WHERE keyword = ?";
$stmt = mysqli_stmt_init($conn);
mysqli_stmt_prepare($stmt,$sql);
mysqli_stmt_bind_param($stmt,"s",$input_1);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$row=mysqli_fetch_array($result,MYSQLI_NUM);
$id = $row['0'];
$email = $row['3'];
echo "$id<br>";
echo "$email<br>";
mysqli_stmt_close($stmt);
mysqli_close($conn);
<i>
</i>$conn = mysqli_connect("localhost","root","","gulf"); //mysqli_connect("server","user","password","db");
$input_1 = 'fat'; //keyword
$input_2 = 'heavy weight'; //keyphrase
$sql = "SELECT id,email from users WHERE keyword = ? OR keyphrase = ?";
$stmt = mysqli_stmt_init($conn);
if(mysqli_stmt_prepare($stmt,$sql))
{
mysqli_stmt_bind_param($stmt,"s",$input_1,$input_2);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
<i> </i>while($row=mysqli_fetch_array($result,MYSQLI_BOTH))
<i> </i>{
<i> </i> $id = $row['0'];
<i> </i> $email = $row['email'];
<i> </i>
<i> </i> echo "$id<br>";
<i> </i> echo "$email<br>";
<i> </i>}
}
else
{
echo 'Mysqli Error: ' .mysqli_stmt_error();
echo '<br>';
echo 'Mysqli Error No: ' .mysqli_stmt_errno();
}
mysqli_stmt_close($stmt);
mysqli_close($conn);
<i>
</i>
$conn = mysqli_connect("localhost","root","","gulf"); //mysqli_connect("server","user","password","db");
$inputs = array('gulp','ebrute');
$sql = "SELECT id,email from users WHERE username = ?";
$stmt = mysqli_stmt_init($conn);
if(mysqli_stmt_prepare($stmt,$sql))
{
mysqli_stmt_bind_param($stmt,"s",$input);
<i> </i>foreach($inputs AS $input)
<i> </i>{
<i> </i> mysqli_stmt_execute($stmt);
<i> </i> $result = mysqli_stmt_get_result($stmt);
<i> </i>
<i> </i> while($row=mysqli_fetch_array($result,MYSQLI_BOTH))
<i> </i> {
<i> </i> $id = $row['0'];
<i> </i> $email = $row['email'];
<i> </i>
<i> </i> echo "$id<br>";
<i> </i> echo "$email<br>";
<i> </i> }
<i> </i>}
}
else
{
echo 'Mysqli Error: ' .mysqli_stmt_error();
echo '<br>';
echo 'Mysqli Error No: ' .mysqli_stmt_errno();
}
mysqli_stmt_close($stmt);
mysqli_close($conn);
?>
<i>
</i>$conn = mysqli_connect("localhost","root","","gulf"); //mysqli_connect("server","user","password","db");
$inputs = array('gulp','ebrute');
$sql = "SELECT id,email from users WHERE username = ?";
$stmt = mysqli_stmt_init($conn);
if(mysqli_stmt_prepare($stmt,$sql))
{
mysqli_stmt_bind_param($stmt,"s",$input);
<i> </i>foreach($inputs AS $input)
<i> </i>{
<i> </i> mysqli_stmt_execute($stmt);
<i> </i> $result = mysqli_stmt_get_result($stmt);
<i> </i>
<i> </i> while($row=mysqli_fetch_array($result,MYSQLI_NUM)) //Do not do: while($row=mysqli_fetch_array($result,MYSQLI_BOTH)) as it outputs each result twice.
<i> </i> {
<i> </i> foreach($row AS $r)
<i> </i> {
<i> </i> echo "$r<br>";
<i> </i> }
<i> </i> }
<i> </i>}
}
else
{
echo 'Mysqli Error: ' .mysqli_stmt_error();
echo '<br>';
echo 'Mysqli Error No: ' .mysqli_stmt_errno();
}
mysqli_stmt_close($stmt);
mysqli_close($conn);
<i>
</i>$conn = mysqli_connect("localhost","root","","gulf"); //mysqli_connect("server","user","password","db");
$inputs = array('gulp','ebrute');
$sql = "SELECT id,email from users WHERE username = ?";
$stmt = mysqli_stmt_init($conn);
if(mysqli_stmt_prepare($stmt,$sql))
{
mysqli_stmt_bind_param($stmt,"s",$input);
<i> </i>foreach($inputs AS $input)
<i> </i>{
<i> </i> mysqli_stmt_execute($stmt);
<i> </i> $result = mysqli_stmt_get_result($stmt);
<i> </i>
<i> </i> $row=mysqli_fetch_array($result,MYSQLI_NUM); //Do not do: while($row=mysqli_fetch_array($result,MYSQLI_BOTH)) as it outputs each result twice.
<i> </i> foreach($row AS $r)
<i> </i> {
<i> </i> echo "$r<br>";
<i> </i> }
<i> </i>}
}
else
{
echo 'Mysqli Error: ' .mysqli_stmt_error();
echo '<br>';
echo 'Mysqli Error No: ' .mysqli_stmt_errno();
}
mysqli_stmt_close($stmt);
mysqli_close($conn);
0.1.9 — BETA 5.2