All pastes #912826 Raw Edit

Anonymous

public text v1 · immutable
·published 2008-02-21 17:43 UTC
rendered paste body
<?php 

require "conninfo.php";

$mysqli = new mysqli($serverbd, $userbd, $passbd, $bd); 

$idnews = intval($_GET['idnt']);

/* check connection */ 
if (mysqli_connect_errno()) { 
    printf("Connect failed: %s\n", mysqli_connect_error()); 
    exit(); 
} 

echo $idnews;

$stmt = $mysqli->prepare(" SELECT * FROM NOTICIAS WHERE IDNOTICIA = ? "); 
$stmt->bind_param('i', $idnews); 


/* execute prepared statement */ 
$stmt->execute(); 

echo "COUNT = " . $stmt->num_rows . "<br>";
//printf("%d Row inserted.\n", $stmt->affected_rows); 

//WOULD THIS WORK?
$results = $stmt->fetch();

echo "<br>DUMP - " . var_dump($results);

echo "<br>results - titulo = " . $results->TITULO;
echo "<br>" . $TITULO;
//?

/* close statement and connection */ 
$stmt->close(); 

/* Clean up table CountryLanguage */ 
//$mysqli->query("DELETE FROM NOTICIAS WHERE TITULO='DEU'"); 
//printf("%d Row deleted.\n", $mysqli->affected_rows); 

/* close connection */ 
$mysqli->close(); 
?>