Guest User

Untitled

a guest
Oct 8th, 2018
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. PHP provides mysql_connect function to open a db connection
  2. This function takes 5 parameters.
  3.  
  4. 1.server
  5. 2.user
  6. 3.passwd
  7. 4.new_link
  8. 5.client_flags
  9.  
  10. <?php
  11. $dbhost='localhost:8080';
  12. $dbuser='root';
  13. $dbpass='root';
  14. $conn=mysql_connect($dbhost,$dbuser,$dbpass);
  15. if(!$conn)
  16. {
  17. die('could not connect:'. mysql_error());
  18. }
  19. echo 'connected successfully';
  20. $sql='CREATE Database test_db';
  21. $retval=mysql_query($sql,$conn)
  22. if(!$retval)
  23. {
  24. die('Could not create db:'. mysql_error());
  25. }
  26. echo "db created";
  27. $sql='CREATE TABLE employee('.
  28. 'emp_id INT NOT NULL AUTO_INCREMENT,'.
  29. 'emp_name VARCHAR(20) NOT NULL,'.
  30. 'emp_address VARCHAR(20) NOT NULL,'.
  31. 'emp_salary INT NOT NULL,'.
  32. 'join_date timestamp(14) NOT NULL,'.
  33. 'primary key(emp_id))';
  34. mysql_select_db('test_db')
  35. $retval=mysql_query($sql,$conn)
  36. if(!$retval)
  37. {
  38. die('Could not create table:'. mysql_error());
  39. }
  40. echo "table created successfully";
  41. mysql_close($conn);
  42. ?>
  43. ?>
Add Comment
Please, Sign In to add comment