Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2017
428
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.73 KB | None | 0 0
  1. string mysql_error ([ resource $link_identifier ] )
  2.  
  3. <?php
  4. $servername = "localhost";
  5. $database = "database";
  6. $username = "user";
  7. $password = "password";
  8.  
  9. // Create connection
  10. $conn = new mysqli($servername, $username, $password);
  11. // Check connection
  12. if ($conn->connect_error) {
  13. die("Connection failed: " . $conn->connect_error);
  14. }
  15. echo "Connected successfully";
  16. ?>
  17.  
  18. <?php
  19. $username = 'user';
  20. $password = 'password';
  21. $server = 'localhost';
  22. // Opens a connection to a MySQL server
  23. $connection = mysql_connect ($server, $username, $password) or die('try again in some minutes, please');
  24. //if you want to suppress the error message, substitute the connection line for:
  25. //$connection = @mysql_connect($server, $username, $password) or die('try again in some minutes, please');
  26. ?>
  27.  
  28. $servername='localhost';
  29. $username='root';
  30. $password='';
  31. $databasename='MyDb';
  32.  
  33. $connection = mysqli_connect($servername,$username,$password);
  34.  
  35. if (!$connection) {
  36. die("Connection failed: " . $conn->connect_error);
  37. }
  38.  
  39. /*mysqli_query($connection, "DROP DATABASE if exists MyDb;");
  40.  
  41. if(!mysqli_query($connection, "CREATE DATABASE MyDb;")){
  42. echo "Error creating database: " . $connection->error;
  43. }
  44.  
  45. mysqli_query($connection, "use MyDb;");
  46. mysqli_query($connection, "DROP TABLE if exists employee;");
  47.  
  48. $table="CREATE TABLE employee (
  49. id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  50. firstname VARCHAR(30) NOT NULL,
  51. lastname VARCHAR(30) NOT NULL,
  52. email VARCHAR(50),
  53. reg_date TIMESTAMP
  54. )";
  55. $value="INSERT INTO employee (firstname,lastname,email) VALUES ('john', 'steve', 'johnsteve@yahoo.com')";
  56. if(!mysqli_query($connection, $table)){echo "Error creating table: " . $connection->error;}
  57. if(!mysqli_query($connection, $value)){echo "Error inserting values: " . $connection->error;}*/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement