php database connection example

php connect to mysql database, oracle database

1. <?php 
2. @$dbcnnct = mysql_connect("localhost", "username", "password");
3. if(!$dbcnnct)
4. {
5. echo "could not connect";
6. }
7. @$db=mysql_select_db("project");
8. if(!$db)
9. {
10. echo "could not select";
11. }
12. 
    
13. $sql = mysql_query("SELECT * FROM country ");
14. if(!$sql)
15. echo "error==".mysql_error($sql);
16.         while($row = mysql_fetch_array($sql))
17.         {
18.             
19. echo ("$row[table column name]");
20.         }
21. 
    
22. @$dbcls = mysql_close($dbcnnct);
23. ?>