Webeng

7,050
reputation
4
31
59
<?php
  require('life_config.php');//obtaining $alive value

  $sql = "UPDATE my_life SET drink=:drink, passion=:passion,
  lifestyle=:lifestyle, ongoing=:ongoing WHERE :alive";
  $stmt = $conn->prepare(sql);

  $stmt->bindParam(':drink', 'Green Tea');
  $stmt->bindParam(':passion', 'web development');
  $stmt->bindParam(':lifestyle', 'two days of jiujitsu rolling / week');
  $stmt->bindParam(':onging', 'research');
  $stmt->bindParam(':alive', $alive);

  $stmt->execute();//Life update complete
?>