developer_web said ...
I told the doctor it hurts when I do this
$stmt_fetch = mysqli_stmt_fetch($stmt);
if($stmt_fetch === FALSE) //Q11. SHOULD I KEEP THIS IF OR THE IF THAT COMES AFTER THIS IF ?
{
printf("Error: %s.\n", mysqli_stmt_error($stmt));
printf("Error: %d.\n", mysqli_stmt_errno($stmt));
die;
}
The doctor said ...
Don't do that !
<?
//require 'error_reporting.php';
//require 'conn.php';
$servername = "localhost";
$username = "u308145272_daVey";
$password = "!?Dav!?2468!?";
$dbname = "u308145272_daBase";
$conn = mysqli_connect($servername, $username, $password, $dbname);
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}else{
printf("Connect suckedseed<br>");
}
$sql = "CREATE TABLE IF NOT EXISTS TestE (
page_url VARCHAR(255),
link_anchor_text VARCHAR(255),
page_description VARCHAR(255),
keyphrases VARCHAR(255),
keywords VARCHAR(255))";
$result=mysqli_query($conn, $sql);
echo mysqli_errno($conn)."<br>";
$stmt = mysqli_stmt_init($conn);
if(ISSET($_GET['keywords'])){
$keywords = $_GET['keywords'];
if(array_key_exists('search1',$_GET)){
echo $keywords."<br>";
$query = "SELECT page_url,link_anchor_text,page_description,keyphrases,keywords FROM TestE WHERE keywords = ?";
if(mysqli_stmt_prepare($stmt,$query)) echo "prepare aok<br>";
mysqli_stmt_bind_param($stmt,'s',$keywords);
if(mysqli_stmt_execute($stmt) === FALSE){
printf("Error: %s.\n", mysqli_stmt_error($stmt));
printf("Error: %d.\n", mysqli_stmt_errno($stmt));
die();
}
// $stmt_execute = mysqli_stmt_execute($stmt);
// if($stmt_execute === FALSE){
// printf("Error: %s.\n", mysqli_stmt_error($stmt));
// printf("Error: %d.\n", mysqli_stmt_errno($stmt));
// die;
// }
// if(!mysqli_stmt_execute($stmt)){
// printf("Error: %s.\n", mysqli_stmt_error($stmt));
// printf("Error: %d.\n", mysqli_stmt_errno($stmt));
// die;
// } all three ways are functionally equivalent !
if(!mysqli_stmt_bind_result(
$stmt,$page_url,$link_anchor_text,$page_description,$keyphrase,$keywords)
){
printf("Error: %s.\n", mysqli_stmt_error($stmt));
printf("Error: %d.\n", mysqli_stmt_errno($stmt));
die();
}
while(mysqli_stmt_fetch($stmt)) {
echo "$page_url"; echo "<br>";
echo "$link_anchor_text"; echo "<br>";
echo "$page_description"; echo "<br>";
echo "$keyphrase"; echo "<br>";
echo "$keywords"; echo "<br>";
echo "|";
echo "<br>";
}
}
if(array_key_exists('search2',$_GET)){
echo $keywords."xxxxxx<br>";
$query = "SELECT page_url,link_anchor_text,page_description,keyphrases,keywords FROM TestE WHERE keywords = ?";
if(!mysqli_stmt_prepare($stmt,$query))die("UnPrepared");
if(!mysqli_stmt_bind_param($stmt,'s',$keywords))die("UnBound");
if(!mysqli_stmt_execute($stmt))die("UnExecuted");
if(!$result=mysqli_stmt_get_result($stmt))die("NotGot");
while($row = mysqli_fetch_array($result,MYSQLI_ASSOC)){
$page_url = $row['page_url']; echo $page_url; echo "<br>";
$link_anchor_text = $row['link_anchor_text']; echo $link_anchor_text; echo "<br>";
$page_description = $row['page_description']; echo $page_description; echo "<br>";
$keyphrases = $row['keyphrases']; echo $keyphrases; echo "<br>";
$keywords = $row['keywords']; echo $keywords; echo "<br>";
echo "|";
echo "<br>";
}
}
}
if (array_key_exists('insert',$_GET)){
$data = $_GET[data];
echo var_dump($_GET[data])."<br>";
$sql ="insert into TestE values (?,?,?,?,?)";
if(mysqli_stmt_prepare($stmt,$sql)) echo "prepare ok"."<br>";
echo $data."<br>";
mysqli_stmt_bind_param($stmt, "sssss", $data[0], $data[1], $data[2], $data[3], $data[4]);
if(!mysqli_stmt_execute($stmt)){echo "exe Failed";}
}
?>
<form>
page_url<input name=data[]><br>
link_anchor_text<input name=data[]><br>
page_description<input name=data[]><br>
keyphrases<input name=data[]><br>
keywords<input name=data[]><br>
<input type="reset"><br>
<button name=insert>send</button></form>
<form>
<label for="keywords">Keywords:*</label>
<input type="text" name="keywords" id="keywords" placeholder="Input Keywords" required>
<br>
<button name=search2>Search2</button><br>
<button name=search1>Search1</button><br>
<input type="reset">
<br>
</form>