YSN7Sfyk

1string mysql_error ([ resource $link_identifier ] )
2	
3<?php
4$server   = "localhost";
5$database = "database";
6$username = "user";
7$password = "password";
8
9$mysqlConnection = mysql_connect($server, $username, $password);
10if (!$mysqlConnection)
11{
12  echo "Please try later.";
13}
14else
15{
16mysql_select_db($database, $mysqlConnection);
17}
18?>
19	
20<?php 
21$username = 'user';
22$password = 'password';
23$server = 'localhost'; 
24// Opens a connection to a MySQL server
25$connection = mysql_connect ($server, $username, $password) or die('try again in some minutes, please');
26//if you want to suppress the error message, substitute the connection line for:
27//$connection = @mysql_connect($server, $username, $password) or die('try again in some minutes, please');
28?>
29	
30$servername='localhost';
31$username='root';
32$password='';
33$databasename='MyDb';
34
35$connection = mysqli_connect($servername,$username,$password);
36
37if (!$connection) {
38die("Connection failed: " . $conn->connect_error);
39}
40
41/*mysqli_query($connection, "DROP DATABASE if exists MyDb;");
42
43if(!mysqli_query($connection, "CREATE DATABASE MyDb;")){
44echo "Error creating database: " . $connection->error;
45}
46
47mysqli_query($connection, "use MyDb;");
48mysqli_query($connection, "DROP TABLE if exists employee;");
49
50$table="CREATE TABLE employee (
51id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
52firstname VARCHAR(30) NOT NULL,
53lastname VARCHAR(30) NOT NULL,
54email VARCHAR(50),
55reg_date TIMESTAMP
56)"; 
57$value="INSERT INTO employee (firstname,lastname,email) VALUES ('john', 'steve', 'johnsteve@yahoo.com')";
58if(!mysqli_query($connection, $table)){echo "Error creating table: " . $connection->error;}
59if(!mysqli_query($connection, $value)){echo "Error inserting values: " . $connection->error;}*/