Advertisement
Guest User

Untitled

a guest
Apr 8th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.65 KB | None | 0 0
  1. <?php
  2. $servername = "localhost";
  3. $username = "root";
  4. $password = "";
  5. $dbname = "women";
  6. $conn = new mysqli($servername, $username, $password, $dbname);
  7. $id=$_GET['id'];
  8. if ($conn->connect_error) {
  9. die("Connection failed: " . $conn->connect_error);}
  10. $sql = "SELECT DAY(ADDDATE(`dateDebutC`, `dureeC`))AS MONTHS,DAY(ADDDATE(ADDDATE(`dateDebutC`, `dureeC`),`dureeR`))AS DAYS FROM normalW where id = '$id'";
  11. $result = $conn->query($sql);
  12. if ($result->num_rows > 0) {
  13. foreach($new_array as $array){
  14. echo $row['DAYS'].'<br />';
  15. echo $row['MONTHS'].'<br />';}
  16. } else {
  17. echo "0 results";
  18. }
  19. $conn->close();
  20. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement