Answers for "php mysql result"

PHP
1

php echo sql result

$sql = "select * FROM tableName;";

$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_assoc($result)) {
  echo $row['columnName']; 
}
Posted by: Guest on August-19-2021
1

php get result sql server

//on sql server
public function get_data_from($id){
  $request = "SELECT * FROM yourTable WHERE id = ?";

  //preparing the request
  $stmt = $this->dbh->prepare($request);

  //executing the request
  $stmt->execute( array($id)  );

  //fetching the result of the request
  $result = $stmt->fetchAll();

  return $result;
}
Posted by: Guest on May-31-2021
1

php echo sql result

$sql="SELECT * my_table"

$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) {
    echo $row['fieldname']; 
}
Posted by: Guest on July-03-2021

Browse Popular Code Answers by Language