title: Why doesn't my database load from Heroku ClearDB when in Heroku app?
body: <p>I built a php based website on the cloud9(C9) ide and I have a database based in heroku. The database works and information is retrieved when running it on my cloud (All tables requested in code appear where they should be). But when I push all my code to Heroku to the same application hosting the database, it fails to retrieve the information, no error codes shown, just a blank portion of the page. All Heroku credentials are correct because cloud9 can still pull from Heroku and I can physically see my database loaded on MySql Workbench on the Heroku server, so it is there.</p>
  
  <p>When ran in the development environment cloud9 provides my code was pulling data out the clearDB database just fine, but when this code is pushed to Heroku and ran in Heroku, I receive a different result. The website design is there, but when I press the management tab there are not items from the ClearDB database present. Below you will see images of the differences between the code being ran in cloud9 and heroku.<a href="https://i.stack.imgur.com/qrfmq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qrfmq.png" alt="Build on Cloud9 ide when I press the &#39;management tab&#39;"></a></p>
  
  <p><a href="https://i.stack.imgur.com/5MU2t.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5MU2t.png" alt="Build on Heroku When I press the management tab "></a></p>
  
  <p><a href="https://i.stack.imgur.com/NRKIq.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/NRKIq.png" alt="The database exists on the Heroku server"></a></p>
  
  <p><a href="https://i.stack.imgur.com/4GM08.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/4GM08.png" alt="Heroku logs, everything looks okay"></a></p>
  
  <p>Application logs</p>
  
  <blockquote>
    <p>2018-05-28T07:52:36.460199+00:00 heroku[router]: at=info method=GET path="/CoffeeOverview.php" host=serene-shelf-61592.herokuapp.com request_id=80ec77fc-9fdd-4ffb-a325-955a41a85493 fwd="198.189.249.57" dyno=web.1 connect=0ms service=4ms status=500 bytes=530 protocol=https
    2018-05-28T07:52:36.459705+00:00 app[web.1]: [28-May-2018 07:52:36 UTC] PHP Fatal error:  Call to undefined function mysql_connect() in /app/Model/CoffeeModel.php on line 30
    2018-05-28T07:52:36.460137+00:00 app[web.1]: 10.111.216.133 - - [28/May/2018:07:52:36 +0000] "GET /CoffeeOverview.php HTTP/1.1" 500 340 "<a href="https://serene-shelf-61592.herokuapp.com/Management.php" rel="nofollow noreferrer">https://serene-shelf-61592.herokuapp.com/Management.php</a>" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36
    2018-05-28T08:19:47.074063+00:00 heroku[router]: at=info method=GET path="/Management.php" host=serene-shelf-61592.herokuapp.com request_id=91a804d7-81f2-4fed-b3da-d922e2438cee fwd="185.20.6.84" dyno=web.1 connect=0ms service=4ms status=200 bytes=1472 protocol=http
    2018-05-28T08:19:47.074422+00:00 app[web.1]: 10.41.164.211 - - [28/May/2018:08:19:47 +0000] "GET /Management.php HTTP/1.1" 200 1301 "-" "Mozilla/5.0 (TweetmemeBot/4.0; +<a href="http://datasift.com/bot.html" rel="nofollow noreferrer">http://datasift.com/bot.html</a>) Gecko/20100101 Firefox/31.0
    2018-05-28T08:56:00.991844+00:00 heroku[web.1]: Idling
    2018-05-28T08:56:00.993076+00:00 heroku[web.1]: State changed from up to down
    2018-05-28T08:56:01.900896+00:00 app[web.1]: Going down, terminating child processes...
    2018-05-28T08:56:01.883618+00:00 heroku[web.1]: Stopping all processes with SIGTERM
    2018-05-28T08:56:01.993121+00:00 heroku[web.1]: Process exited with status 143
     Autoscroll with output Save
    heroku.com Blogs Careers Documentation</p>
  </blockquote>