hrwgSWM0

1string 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
12if ($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
35if (!$connection) {
36die("Connection failed: " . $conn->connect_error);
37}
38
39/*mysqli_query($connection, "DROP DATABASE if exists MyDb;");
40
41if(!mysqli_query($connection, "CREATE DATABASE MyDb;")){
42echo "Error creating database: " . $connection->error;
43}
44
45mysqli_query($connection, "use MyDb;");
46mysqli_query($connection, "DROP TABLE if exists employee;");
47
48$table="CREATE TABLE employee (
49id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
50firstname VARCHAR(30) NOT NULL,
51lastname VARCHAR(30) NOT NULL,
52email VARCHAR(50),
53reg_date TIMESTAMP
54)"; 
55$value="INSERT INTO employee (firstname,lastname,email) VALUES ('john', 'steve', 'johnsteve@yahoo.com')";
56if(!mysqli_query($connection, $table)){echo "Error creating table: " . $connection->error;}
57if(!mysqli_query($connection, $value)){echo "Error inserting values: " . $connection->error;}*/